Tool: Main
Tab: Schedule
Explanation of Tool, Use, etc.The Main Tool displays academic information about the student normally stored in the student information system (SIS).
The Schedule tab from the Main Tool displays the student's schedule for the current term.
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 member. | 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_student_transcript_courseperson | Main-Dashboard Main-Details Main-Schedule | Instructor | Instructor's first name | David |
| middle_name | external_student_transcript_courseperson | Main-Dashboard Main-Details Main-Schedule | Instructor | Instructor's middle name | N/A |
| last_name | external_student_transcript_courseperson | 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 |