Child pages
  • Tool: Main-Schedule
Skip to end of metadata
Go to start of metadata

Tool: Main

Tab: Schedule

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:

Main-Schedule.jpg

Main-Schedule.pdf

Main-Schedule.vsd

 

ParameterExternal TableLocationField NameDescriptionExample
term_codeexternal_student_transcript_courseMain-Schedule
Main-Transcript
MAP-Transcript
TermSpecifies what term the course was taken by the student and taught by the facultyFA2013
formatted_courseexternal_student_transcript_courseMain-Schedule
Main-Transcript
MAP-Transcript
CourseThe formatted courseENG076
section_numberexternal_student_transcript_courseMain-ScheduleSectionThe section number associated with course registration002
titleexternal_student_transcript_courseMain-Schedule
Main-Transcript
MAP-Transcript
Course TitleThe full course titleCollege Writing II
credit_earnedexternal_student_transcript_courseMain-Schedule
Main-Transcript
MAP-Transcript
Cr HrsCredit hours earned by the student in the course.3
first_nameexternal_personMain-Dashboard
Main-Details
Main-Schedule
InstructorInstructor's first nameDavid
middle_nameexternal_personMain-Dashboard
Main-Details
Main-Schedule
Instructor

Instructor's middle name

N/A
last_nameexternal_person

Main-Dashboard
Main-Details
Main-Schedule

InstructorInstructor's last nameMartinez
status_codeexternal_student_transcript_courseMain-ScheduleStatusDesignator 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
auditedexternal_student_transcript_courseMain-ScheduleAuditedY or N, indicates if the student audited the courseN
participationexternal_student_transcript_courseMain-ScheduleParticipationA 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
  • No labels