WI DPI WISEdata Ed-Fi Docs
Course Transcripts (Public LEA Only)
In an effort to help integrate Xello’s Course Planner tool with the Student Information System (SIS), DPI has developed an integration that enables Xello to retrieve course transcripts from the WISEdata API and store them back into the Course Planner tool. Course Transcript is an optional integration for SIS vendors. SIS vendors that implemented this integration will send the course transcripts to the WISEdata API, which allows Xello to get the data directly through the WISEdata API instead of relying on flat files and exports. School districts may need to check their SIS Ed-Fi configuration and make sure CourseTranscript and StudentAcademicRecord are enabled.
Course Transcript is the final record of a student's performance in their courses at the end of a semester or school year. Course transcript data is not displayed on the student page in WISEdata Portal, however, school districts may download the Course Transcript export to view what their SIS vendor sent to the WISEdata API.
Ed-Fi Tech Docs: v5 Student Program > StudentCTEProgramAssociation, 
v3 Student Transcript > CourseTranscript - Ed-Fi Certification - Ed-Fi Confluence (2024/25 SY and prior)
Data Properties:
# | 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 |
Descriptors:
Use Cases:
Wisconsin Department of Public Instruction