|
Table and Data Details |
|
|
|
|
|
Table and Data Details |
|
|
|
|
Colleague Table and Data Details
The interface selects data from various Colleague tables to make academic sections, meetings, cross-list information, instructors, subjects, courses, and activity statuses available within Astra Schedule. The following tables detail the Colleague fields being used and their corresponding Astra Schedule values.
Sections
SIS Database Value |
Astra Schedule Value |
|---|---|
COURSE_SECTIONS.COURSE_SECTIONS_ID |
SisKey |
COURSE_SECTIONS.SEC_TERM |
Term |
COURSE_SECTIONS.SEC_COURSE_NO |
CourseNumber |
COURSE_SECTIONS.COURSE_SECTIONS_ID |
SectionCode |
COURSE_SECTIONS.SEC_NO |
SectionNumber |
COURSE_SECTIONS.SEC_SHORT_TITLE |
Title |
COURSE_SECTIONS.SEC_SUBJECT |
Subject |
COURSE_SECTIONS.SEC_COURSE_NO |
Course |
COUNT(STUDENT_COURSE_SEC.STUDENT_COURSE_SEC_ID) |
Enrollment |
COURSE_SECTIONS.SEC_CAPACITY |
MaxEnrollment |
COURSE_SECTIONS.COURSE_SECTIONS_CHGDATE |
ChangeDate |
SEC_STATUSES.SEC_STATUS |
StatusCode |
COURSE_SECTIONS.SEC_LOCATION |
Campus |
Section Meetings
SIS Database Value |
Astra Schedule Value |
|---|---|
COURSE_SEC_MEETING.CSM_COURSE_SECTION +'_'+ CSM.COURSE_SEC_MEETING_ID |
SisKey |
COURSE_SEC_MEETING.COURSE_SEC_MEETING_ID |
MeetingNumber |
COURSE_SEC_MEETING.CSM_START_DATE |
StartDate |
COURSE_SEC_MEETING.CSM_END_DATE |
EndDate |
COURSE_SEC_MEETING.CSM_START_TIME |
StartTime |
COURSE_SEC_MEETING.CSM_END_TIME |
EndTime |
COURSE_SEC_MEETING.CSM_INSTR_METHOD |
MeetingType |
COURSE_SEC_MEETING.CSM_BLDG |
Building |
COURSE_SEC_MEETING.CSM_ROOM |
Room |
COURSE_SEC_MEETING.COURSE_SEC_MEETING_CHGDATE |
ChangeDate |
CASE CSM_SUNDAY WHEN 'Y' THEN 'U' ELSE '' END + CASE CSM_MONDAY WHEN 'Y' THEN 'M' ELSE '' END + CASE CSM_TUESDAY WHEN 'Y' THEN 'T' ELSE '' END + CASE CSM_WEDNESDAY WHEN 'Y' THEN 'W' ELSE '' END + CASE CSM_THURSDAY WHEN 'Y' THEN 'R' ELSE '' END + CASE CSM_FRIDAY WHEN 'Y' THEN 'F' ELSE '' END + CASE CSM_SATURDAY WHEN 'Y' THEN 'S' ELSE '' END |
DaysMet |
Instructors
SIS Database Value |
Astra Schedule Value |
|---|---|
PERSON.ID |
SisKey |
PERSON.LAST_NAME |
LastName |
PERSON.FIRST_NAME |
FirstName |
PERSON.MIDDLE_NAME |
MiddleName |
Cross-List Information
SIS Database Value |
Astra Schedule Value |
|---|---|
COURSE_SECTIONS.SEC_TERM + '_' + COURSE_SECTIONS.COURSE_SECTIONS_ID |
SisKey |
COURSE_SECTIONS.SEC_CAPACITY |
CrossListMaxEnrollment |
COURSE_SECTIONS.COURSE_SECTIONS_ID |
CrossListNumber |
COUNT(STUDENT_COURSE_SEC.STUDENT_COURSE_SEC_ID) |
CrossListEnrollment |
COURSE_SECTIONS.SEC_XLIST |
