Overview
In Student Success & Engagement, student transcript and enrollment information is not only used by student success teams to inform advising, but also by Predict to provide accurate predictive models.
There are 5 required transcript and enrollment-related data feeds. There are optional related feeds including delivery method, location, and status feeds. There are also other referenced feeds including program, major, curriculum/area of study, and person.
Transcript and Enrollment Related Feeds
The SIS Import Definitions outlines the import requirements for each of the following feeds.
-
academicCalendar
- Includes terms that the course section is associated with.
-
course
- The generic course information including credits, descriptions, etc. As a course changes over time - name, description, credits - a new course record would be created. This allows course sections to be associated with a specific version of the course.
- Consider filtering out continuing education/non credit courses if your team will not be using them.
-
courseSection
- The course section is the individual section that a student will enroll in.
- Each course section will be associated with a specific course and term.
- Consider filtering out continuing education/non credit sections if your team will not be using them.
-
department
- The academic department that offers the course.
-
transcript
- The transcript feed includes the student’s GPA, credit hours, and other general transcript information. This information is listed on the student profile and can be used for filtering, alerts, and Predict.
- SSE supports only one transcript per person, so for students with multiple transcripts (like UG and Grad), one will need to be chosen.
-
transcriptCourse
- Transcript Course records are the relationship between a specific Course Section and Transcript (student), also known as the course registration or enrollment.
- These enrollments will build out the student’s full transcript in SS&E.
- Transcript Course records with Registered, Withdraw-In-Progress, Withdrawn, Unknown registration statuses (transcriptCourseStatusId) are used in Predict. The others are not but may be helpful to student success teams.
- Be sure to include transfer credits, however, they often need to be handled differently than institution enrollments because SSE requires a courseSection to be associated with transfer credits. See the Transfer Credits section below for more details.
For each of these feeds, historical and inactive data will likely be needed to support historical student data. For example, if a student is returning to the institution after attending 15 years ago, the course sections they were previously enrolled in would be present on their record and the supporting data would be needed.
ER Diagrams
Example Scenario
In this example, the Olivia Student (0123456) has a few Math credits from 2018-2019, and has returned for Fall term 2025 to continue taking Business classes. She also has credit for a transferred English course from 2024. Here are the (partial) records in each feed to support her transcript data. Downloadable CSV files of these examples can be found at the bottom of this article.
academicCalendar
| id | academicYear | startDate | endDate | academicTerm | name |
|---|---|---|---|---|---|
| FA2025 | 2025 | 2025-08-15 | 2025-12-10 | FALL | Fall 2025 |
| FA2018 | 2018 | 2018-08-15 | 2018-12-10 | FALL | Fall 2018 |
| SP2019 | 2018 | 2019-01-10 | 2019-05-10 | SPRING | Spring 2025 |
| TRANSFER | 1900 | 1900-01-01 | 1900-01-01 | TRANSFER | Transfer Term |
course
| id | subject | name | credits | courseId | startDate | endDate | active |
|---|---|---|---|---|---|---|---|
| MTH-111.2015 | MTH | College Algebra | 4 | MTH-111 | 2015-08-01 | false | |
| MTH-112.2015 | MTH | Trigonometry | 4 | MTH-112 | 2015-08-01 | 2021-07-31 | false |
| ENG-101.2022 | ENG | College English I | 3 | ENG-101 | 2022-08-01 | false | |
| BUS-110.2024 | BUS | Intro to Business | 3 | BUS-110 | 2024-08-01 | false | |
| BUS-112.2024 | BUS | Business Accounting | 3 | BUS-112 | 2024-08-01 | false |
courseSection
| id | section | startDate | endDate | online | distance | courseId | academicCalendarId | selfPaced | status |
|---|---|---|---|---|---|---|---|---|---|
| 54321 | 002 | 2018-08-15 | 2018-12-10 | false | false | MTH-111.2015 | FA2018 | false | ACTIVE |
| 54322 | 001 | 2019-01-10 | 2019-05-10 | false | false | MTH-112.2015 | SP2019 | false | ACTIVE |
| ENG101.TR | TR | 1900-01-01 | 1900-01-01 | false | false | ENG101.2022 | TRANSFER | false | ACTIVE |
| 65431 | 002 | 2025-08-15 | 2025-12-10 | true | false | BUS-110.2024 | FA2025 | false | ACTIVE |
| 65433 | 001 | 2025-08-15 | 2025-12-10 | true | false | BUS-112.2024 | FA2025 | false | ACTIVE |
department
| code | id | name | active |
|---|---|---|---|
| MTH | MTH | Mathematics | true |
| ENG | ENG | English | true |
| BUS | BUS | Business | true |
transcript
| id | cumulativeGpa | cumulativeGpaCredits | primaryMajorGpa | personId | previousCollegeGpa | cumulativeCreditHoursEarned | primaryMajorCreditHoursEarned | anticipatedGraduationDate |
|---|---|---|---|---|---|---|---|---|
| 0123456 | 3.85 | 14 | 3.0 | 0123456 | 4.0 | 3 | 2028-06-01 |
transcriptCourse
| id | creditAttempted | creditEarned | midtermGrade | finalGrade | courseSectionId | transcriptId | transcriptCourseStatusId | registeredDate | droppedDate |
|---|---|---|---|---|---|---|---|---|---|
| 0123456-54321 | 4 | 4 | B | A | 54321 | 0123456 | REGISTERED | 2018-07-15 | |
| 0123456-54322 | 4 | 4 | C | B | 54322 | 0123456 | REGISTERED | 2019-11-10 | |
| 0123456-ENG101.TR | 3 | 3 | A | A | ENG101.TR | 0123456 | REGISTERED | 1900-01-01 | |
| 0123456-65431 | 3 | B | 65431 | 0123456 | REGISTERED | 2025-07-15 | |||
| 0123456-65433 | 3 | 0 | 65433 | 0123456 | DROPPED | 2025-07-15 | 2025-07-31 |
Transfer Credits
In most cases, transfer credits are associated with a course record in the SIS, not a courseSection record. However in SS&E, courseSectionId is required for all transcriptCourse records, including transfer credits. To work around this, courseSection and academicCalendar records must be “manufactured” via the data feed to support the transfer credit data.
In order to import transfer credits, create a custom file or view with the following information. A custom Accelerate query will be used to transform the data into the required format for the transcriptCourse data feed.
CSV name: transcript_course_transfer.csv
View name: transcriptCourseTransfer
| Field Name | Required | Description |
|---|---|---|
| id | Y | A unique ID for the record. This could be similar to the ID value you are using for transcriptCourse. |
| transcriptId | Y | The ID of the transcript this record should be associated with. This should be the same as an id value from the transcript feed, which is likely the same as the id value from the person feed. |
| courseId | Y | An ID from the course feed that reflects the course that the transferred credit is associated with. |
| courseName | N | The user readable name of the transfer course. This can be the course name from the external institution (if available). |
| grade | N | Letter grade received for the transfer credit |
| credits | Y | The number of credit hours for the transfer credit |
| transcriptDate | N |
The date the credit was taken at the external institution
if this information is available. (If this information
is
not available this can be blank or if it is not available
for any records it can be excluded from the feed.) Format: YYYY-MM-DD |
| transferDate | N |
The date or term start date the credit was recorded (if
this
information is available). Format: YYYY-MM-DD |
| status | Y | Some institutions enter all transfer credits, even those that are dropped or withdrawn. This field should indicate if the credit was completed, withdrawn or dropped. If you are only sending completed transfer credits this field would be marked completed for all records. |
Transfer Credit Examples
transcriptCourse
(include transfer credits in transcriptCourse)
| id | creditAttempted | creditEarned | midtermGrade | finalGrade | courseSectionId | transcriptId | transcriptCourseStatusId | registeredDate | droppedDate |
|---|---|---|---|---|---|---|---|---|---|
| 0123456-ENG101.TR | 3 | 3 | A | A | ENG101.TR | 0123456 | REGISTERED | 1900-01-01 |
transcriptCourseTransfer
(alternative/custom method for transfer credits)
| id | transcriptId | courseId | courseName | grade | credits | transcriptDate | transferDate | status |
| 9876543210 | 0123456 | ENG101.2022 | English Composition | B | 4 | 2024-06-15 | 2025-08-15 | REGISTERED |