Course Transcripts (Public LEA Only)

# Property Name Data Type Public (Required/ Optional/ Conditional) Choice (Required/ Optional/ Conditional) Business Definition Data Element Page 1.0 courseAttemptResultDescriptor string REQ'D NOT REQ'D The result from the student's attempt to take the course, for example: Pass Fail Incomplete Withdrawn. NA 2.0 courseCode string OPT NOT REQ'D A unique alphanumeric code assigned to a course. 3.0 educationOrganizationId integer REQ'D NOT REQ'D The identifier assigned to an education organization. 4.0 schoolYear integer REQ'D NOT REQ'D The identifier for the school year. NA 5.0 studentUniqueId string REQ'D NOT REQ'D A unique alphanumeric code assigned to a student. NA 6.0 termDescriptor string REQ'D NOT REQ'D The term for the session during the school year. NA 7.0 alternativeCourseCode (used by Xello) string OPT NOT REQ'D The local code assigned by the school that identifies the course offering, the code from an external educational organization, or other alternate course code. 8.0 alternativeCourseTitle (used by Xello) string OPT NOT REQ'D The descriptive name given to a course of study offered in the school, if different from the CourseTitle. 9.0 AttemptedCredits number REQ'D NOT REQ'D The value of credits or units of value awarded for the completion of a course. NA 10.0 earnedCredits number OPT NOT REQ'D The value of credits or units of value awarded for the completion of a course. NA 11.0 finalLetterGradeEarned (used by Xello) string CONDITINALLY REQ'D NOT REQ'D The final indicator of student performance in a class as submitted by the instructor. 12.0 finalNumericGradeEarned (used by Xello) number CONDITINALLY REQ'D NOT REQ'D The final indicator of student performance in a class as submitted by the instructor. 13.0 whenTakenGradeLevelDescriptor string REQ'D NOT REQ'D Student's grade level at time of course. NA

Namespace Code Value Short Description Description uri://ed-fi.org/CourseAttemptResultDescriptor Fail Fail Fail Incomplete Incomplete Incomplete Pass Pass Pass Withdrawn Withdrawn Withdrawn uri://dpi.wi.gov/TermDescriptor A Annual Annual S1 1st Semester 1st Semester (:Do_Not: Removed 2026-27 SY) S2 2nd Semester 2nd Semester (:Do_Not: Removed 2026-27 SY) T1 1st Trimester 1st Trimester (:Do_Not: Removed 2026-27 SY) T2 2nd Trimester 2nd Trimester (:Do_Not: Removed 2026-27 SY) T3 3rd Trimester 3rd Trimester (:Do_Not: Removed 2026-27 SY) Q1 1st Quarter 1st Quarter (:Do_Not: Removed 2026-27 SY) Q2 2nd Quarter 2nd Quarter (:Do_Not: Removed 2026-27 SY) Q3 3rd Quarter 3rd Quarter (:Do_Not: Removed 2026-27 SY) Q4 4th Quarter 4th Quarter (:Do_Not: Removed 2026-27 SY) uri://ed-fi.org/TermDescriptor (🆕 Added 2026-27 SY) Annual Annual Annual 1st Semester 1st Semester 1st Semester 2nd Semester 2nd Semester 2nd Semester 1st Trimester 1st Trimester 1st Trimester 2nd Trimester 2nd Trimester 2nd Trimester 3rd Trimester 3rd Trimester 3rd Trimester 1st Quarter 1st Quarter 1st Quarter 2nd Quarter 2nd Quarter 2nd Quarter 3rd Quarter 3rd Quarter 3rd Quarter 4th Quarter 4th Quarter 4th Quarter uri://dpi.wi.gov/GradeLevelDescriptor 7 Seventh Grade Seventh Grade 8 Eighth Grade Eighth Grade 9 Ninth Grade Ninth Grade 10 Tenth Grade Tenth Grade 11 Eleventh Grade Eleventh Grade 12 Twelfth Grade Twelfth Grade

# Use Case Title Use Case Description What to Submit/retrieve 1.0 Sending Course Transcripts for all the courses a student has taken as part of their graduation plan, and the student is currently NOT in senior year When a student is enrolled in the same LEA for grade levels 9-11, then the SIS sends one /courseTranscripts record for all the courses completed by student form previous years (9th-10th gardes) where earned credits and final letter grades are available. At the start of a school year for the 11th grade student, we would expect to see 9th and 10th grade courses. At the end of the first term, the transcript can be updated to include those courses where credits have been earned. At the end of the year, the courses in 11th grade should be then posted. DPI expects one Course Transcript record from the most recent school in the district that contains the student’s full credit history. The courseTranscript can be sent at any time and should include the data available up to that point. Prerequisite: Submit the a/studentAcademicRecord (without diploma details) before submitting /courseTranscripts. For an 11th grade student, we expect a single annual studentAcademicRecord with a courseTranscript record that included all courses (regardless of where taken) for 9th, 10th and 11th grades (whenTakenGradeLevel). At the end of 12th grade, it would be 9,10,11,and 12. SIS vendors may post multiple SARs and use them for CourseTranscripts. SIS vendors may send SAR and courseTranscripts records for grade levels 7 and 8, and they can use 'T' course to send Roster data for 7th and 8th grades. but it's NOT required. POST on / studentAcademicRecords: educationOrganizationReference: educationOrganizationId: 7525 schoolYearTypeReference: schoolYear: 2021 studentReference: studentUniqueId: 8660232105 termDescriptor: uri://dpi.wi.gov/TermDescriptor#A POST on /courseTranscripts: courseAttemptResultDescriptor: uri://ed-fi.org/CourseAttemptResultDescriptor#Pass courseReference: courseCode: 10017 educationOrganizationId: 48856 studentAcademicRecordReference: educationOrganizationId: 7525 schoolYear: 2021 studentUniqueId: 8660232105 termDescriptor: uri://dpi.wi.gov/TermDescriptor#A alternativeCourseCode: 214 alternativeCourseTitle: Astronomy attemptedCredits: 0.5 earnedCredits: 17 finalLetterGradeEarned: P finalNumericGradeEarned: 45 whenTakenGradeLevelDescriptor: uri://dpi.wi.gov/GradeLevelDescriptor#11 courseAttemptResultDescriptor: uri://ed-fi.org/CourseAttemptResultDescriptor#Pass courseReference: educationOrganizationId: 48856 courseCode: 10022 studentAcademicRecordReference: educationOrganizationId: 7525 schoolYear: 2021 studentUniqueId: 8660232105 termDescriptor: uri://dpi.wi.gov/TermDescriptor#S2 alternativeCourseCode: "VSCI0236B2, alternativeCourseTitle: "ENVIRONMENTAL SCIENCE, courseTitle: Refer to Courses for Title, earnedCredits:0.5 finalLetterGradeEarned: P finalNumericGradeEarned: 22 whenTakenGradeLevelDescriptor: "uri://dpi.wi.gov/GradeLevelDescriptor#10 etc. 2.0 Sending Course Transcripts for all the courses a student has taken as part of their graduation plan, and the student is currently in senior year When a student is in 12th grade, SIS shoud submit Course Transcripts for all high school courses taken in previous years (9th-11th) where earned credits and final letter grades are available. SIS may send the courses completed by student form the current year (12th grade). DPI expects one Course Transcript record from the most recent school in the district that contains the student’s full credit history. The courseTranscript can be sent at any time and should include the data available up to that point. POST on / studentAcademicRecords and /courseTranscripts For a graduating student, an addition SAR record with diploma information must be submitted with ‘Annual’ term descriptor from the student's most recent enrolled school. In addition to other SAR records with term descriptor other than 'Annual'. POST on / studentAcademicRecords: educationOrganizationReference: educationOrganizationId: 7525 schoolYearTypeReference: schoolYear: 2021 studentReference: studentUniqueId: 8660232105 termDescriptor: uri://dpi.wi.gov/TermDescriptor#A diplomas: diplomaAwardDate: 2021-06-15 diplomaTypeDescriptor: uri://dpi.wi.gov/DiplomaTypeDescriptor#R achievementCategoryDescriptor: uri://dpi.wi.gov/AchievementCategoryDescriptor#D 3.0 Sending Course Transcripts for a student with a dropped course LEA may choose to generate a transcript with final letter grade as 'Withdrawal - W' . Some LEAs don't show dropped course on the transcript based on the timeline of when the student dropped the course. POST on /courseTranscripts: courseAttemptResultDescriptor: uri://ed-fi.org/CourseAttemptResultDescriptor#Withdrawn finalLetterGradeEarned: W 4.0 Sending Course Transcripts for a student who transfered to different schools within the same district (multiple SSA records from same LEA, but different school are expected) School 1 will submit the Course Transcripts for all the course taken by student before the transfer. School 2 will submit Course Transcripts for all the courses taken by student in School 2, as well as the courses trasferred from School 1. NOTE: When multiple schools sending data for Course Transcripts, then the data submitted by the school with the current SSA will be taken into account by Xello. School 1: POST /studentAcademicRecord and /courseTranscript School 2: POST /studentAcademicRecord and /courseTranscript 5.0 Sending Course Transcript for a student who transfered from one district to another in the same school year (multiple SSA records are expected) District 1 will submit the Course Transcripts for all the course taken by student before the transfer. District 2 will do the mapping of the courses taken in District 1 to their course catalogue, and submit Course Transcripts for all the courses transferred form previous grades and the course taken by student in current grade in District 2. NOTE: When multiple schools sending data for Course Transcripts, then the data submitted by the school with the current SSA will be taken into account by Xello. District 1: POST /studentAcademicRecord and /courseTranscript District 2: POST /studentAcademicRecord and /courseTranscript 6.0 Sending Course Transcript for a student taking courses at non-primary school (enrollment type is Coursework) Generally, the school holding the non-primary enrollment would NOT send Course Transcript. The primary school has to consolidate the course work taken at both primary and non-primary school and submit Course Transcript to DPI. However, in an exceptional scenario where a charter school is the primary school and the student is taking high school classes in a non-primary school, if the non-primary school is generating a Course Transcript, then the non-primary school can submit Course Transcript to DPI. POST on / studentAcademicRecords and /courseTranscripts 7.0 Sending Course Transcript for a student taking Certified or Non-certified Programs, which are not tied to any courses. (e.g: Youth Apprenticeship , IRC , State Skilled) Course Transcript is NOT submitted for any Certified and Non-certified Programs that are not tied to any courses. NA 8.0 Sending Course Transcript for a student in grade level 11 taking a course in previous years which is not in 20/21 course list (deprecated course) In order to support the previous year's deprecated courses, DPI added new 'Transcript Courses' starting from the 20/21 SY and forward that can only be used on reference within /courseTranscripts resource SIS vendors must handle the use of 'T' course codes in the backend without user interference. Example: Course code: T01, Course Title: Transcript 01, Description: 'For course transcript only, this course may be used when another more appropriate course is not available in the current school year such as in the case of transfers from out of state or deprecated/removed courses.' POST on /courseTranscripts: courseReference: courseCode: T01 9.0 Sending Course Transcript for a student taking a course multiple times in the same school year, or in multiple years as part of their whole high school course When a student takes a course in the previous grade level (e.g. 9th grade) and courseAttemptDescriptor is 'PASS', and for whatever reason takes that same course again in the next grade level (e.g. 10th grade) with courseAttemptDescriptor is 'PASS', then there can be natural key constraint. This scenario can also be with same grade level but different term. In order to support this scenarios, DPI is allowing SIS vendors to send multiple SARs with their corresponding courseTranscripts. SAR and courseTranscipt records are expected to be sent to the current school year, with SAR and courseTranscipt included from prior years. SIS vendors may also use the new 'T01 - T50' course codes in the CourseCode for the same state code twice during a year. POST on /courseTranscripts: Term 1: courseReference: courseCode: T01 alternativeCourseCode: 2019_401_104 alternativeCourseTitle: HEALTH/LIFE attemptedCredits: 0.5 finalLetterGradeEarned: A finalNumericGradeEarned: 92.18 Term 1: courseReference: courseCode: T02 alternativeCourseCode: 2019_401_104 alternativeCourseTitle: HEALTH/LIFE attemptedCredits: 0.5 finalLetterGradeEarned: B+ finalNumericGradeEarned: 88.42 10.0 Sending summer school courses in Course Transcripts While Summer Enrollment and Roster data are not sent to WISEdata, LEAs can track it locally in the SIS. SIS vendors should send Summer school courses into /CourseTranscripts to show on the student's transcript SIS vendors may use "Annual" for the termDescriptor on /SAR. Roster data are not required to be sent to support the /courseTranscripts. DPI does NOT recommend sending session, courseOffering, section, studentSectionAssociation, grades, gradingPeriods, etc. for courses taken in the Summer. POST on / studentAcademicRecords and /courseTranscripts

{ "courseAttemptResultDescriptor": "uri://ed-fi.org/CourseAttemptResultDescriptor#Pass", "courseReference": { "educationOrganizationId": 48856, "courseCode": "16336", }, "studentAcademicRecordReference": { "educationOrganizationId": 7525, "schoolYear": 2027, "studentUniqueId": "XXXXXXXXXX", "termDescriptor": "uri://ed-fi.org/TermDescriptor#Annual", }, "alternativeCourseCode": "LCC-4108", "alternativeCourseTitle": "LCT-4108", "courseTitle": "Refer to Courses for Title", "earnedCredits": 36.25, "finalLetterGradeEarned": "P", "finalNumericGradeEarned": 1, "whenTakenGradeLevelDescriptor": "uri://ed-fi.org/GradeLevelDescriptor#Twelfth Grade", }

{ "courseAttemptResultDescriptor": "uri://ed-fi.org/CourseAttemptResultDescriptor#Pass", "courseReference": { "educationOrganizationId": 48856, "courseCode": "16336", }, "studentAcademicRecordReference": { "educationOrganizationId": 7525, "schoolYear": 2026, "studentUniqueId": "2181787249", "termDescriptor": "uri://dpi.wi.gov/TermDescriptor#A", }, "alternativeCourseCode": "LCC-8248", "alternativeCourseTitle": "LCT-8248", "courseTitle": "Refer to Courses for Title", "earnedCredits": 36.25, "finalLetterGradeEarned": "P", "finalNumericGradeEarned": 1, "whenTakenGradeLevelDescriptor": "uri://dpi.wi.gov/GradeLevelDescriptor#12", }

{ "termDescriptor": "uri://ed-fi.org/TermDescriptor#Annual", "educationOrganizationReference": { "educationOrganizationId": 7525, }, "schoolYearTypeReference": { "schoolYear": 2027, }, "studentReference": { "studentUniqueId": "XXXXXXXXXX", }, "_ext": { "wi": { "graduationStatusOptOut": true, } }, "diplomas": [{ "diplomaTypeDescriptor": "uri://ed-fi.org/DiplomaTypeDescriptor#Regular diploma", "diplomaAwardDate": "2027-06-15", "achievementCategoryDescriptor": "uri://ed-fi.org/AchievementCategoryDescriptor#Diploma Earned", }], }

{ "termDescriptor": "uri://ed-fi.org/TermDescriptor#1st Trimester", "educationOrganizationReference": { "educationOrganizationId": 7525 }, "schoolYearTypeReference": { "schoolYear": 2021 }, "studentReference": { "studentUniqueId": "8660232105" }, }