Child pages
  • Tool: Main-Schedule

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

 

Image RemovedImage Added

Attachments:

Main-Schedule.jpg

...

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