...
Note: The Schedule table is the same data source in external_student_transcript_course only for courses in the current term.
SSP calculates the current term based on dates, then limits the courses to those that match the calculated current term_code.
Attachments:
...
| Parameter | External Table | Location | Field Name | Description | Example |
|---|---|---|---|---|---|
| term_code | external_student_transcript_course | Main-Schedule Main-Transcript MAP-Transcript | Term | Specifies what term the course was taken by the student and taught by the faculty | FA2013 |
| formatted_course | external_student_transcript_course | Main-Schedule Main-Transcript MAP-Transcript | Course | The formatted course | ENG076 |
| section_number | external_student_transcript_course | Main-Schedule | Section | The section number associated with course registration | 002 |
| title | external_student_transcript_course | Main-Schedule Main-Transcript MAP-Transcript | Course Title | The full course title | College Writing II |
| credit_earned | external_student_transcript_course | Main-Schedule Main-Transcript MAP-Transcript | Cr Hrs | Credit hours earned by the student in the course. | 3 |
| first_name | external_person | Main-Dashboard Main-Details Main-Schedule | Instructor | Instructor's first name | David |
| middle_name | external_person | Main-Dashboard Main-Details Main-Schedule | Instructor | Instructor's middle name | N/A |
| last_name | external_person | Main-Dashboard | Instructor | Instructor's last name | Martinez |
| status_code | external_student_transcript_course | Main-Schedule | Status | Designator for the student's enrollment status in the course. The value in external_student_transcript_course is a code that is translated into a name by SSP. | Enrolled |
| audited | external_student_transcript_course | Main-Schedule | Audited | Y or N, indicates if the student audited the course | N |
| participation | external_student_transcript_course | Main-Schedule | Participation | A custom value that can represent course participation or other metrics for course. This field is also tied to a participation Success Indicator which can be customized. | GOOD or 100 |