|
Table and Data Details |
|
|
|
|
|
Table and Data Details |
|
|
|
|
Jenzabar EX Table and Data Detail
The interface selects data from various Jenzabar tables to make academic sections, meetings, cross-list information, instructors, subjects, courses, and activity statuses available within Astra Schedule. The following tables detail the Jenzabar fields being used and their corresponding Astra Schedule values.
Academic Sections
SIS Database Value |
Astra Schedule Value |
|---|---|
SECTION_MASTER.YR_CDE + '_' + SECTION_MASTER.TRM_CDE + '_' + SECTION_MASTER.Request_Num |
SisKey |
SECTION_MASTER.YR_CDE + SECTION_MASTER.TRM_CDE |
Term |
SECTION_MASTER.YR_CDE |
YearCode |
SECTION_MASTER.CRS_CDE |
CourseCode |
RTRIM(SUBSTRING (SECTION_MASTER.CRS_CDE,0,CHARINDEX(' ', SECTION_MASTER.CRS_CDE))) |
Subject |
RTRIM(SUBSTRING(LTRIM(SUBSTRING (SECTION_MASTER.CRS_CDE,CHARINDEX (' ', SECTION_MASTER.CRS_CDE),LEN (SECTION_MASTER.CRS_CDE))) ,0,CHARINDEX (' ', SECTION_MASTER.CRS_CDE))) |
Course |
RTRIM(SUBSTRING(LTRIM(SUBSTRING(LTRIM( SUBSTRING(LTRIM(SUBSTRING (SECTION_MASTER.CRS_CDE,CHARINDEX (' ',SECTION_MASTER.CRS_CDE),LEN (SECTION_MASTER.CRS_CDE))),0,LEN (SECTION_MASTER.CRS_CDE))),CHARINDEX(' ', LTRIM(SUBSTRING(LTRIM(SUBSTRING (SECTION_MASTER.CRS_CDE,CHARINDEX (' ',SECTION_MASTER.CRS_CDE),LEN (SECTION_MASTER.CRS_CDE))),0,LEN (SECTION_MASTER.CRS_CDE)))),LEN (SECTION_MASTER.CRS_CDE))),0, CHARINDEX (' ', SECTION_MASTER.CRS_CDE))) |
SectionNumber |
SECTION_MASTER.CRS_TITLE |
Title |
SECTION_SCHEDULES.LOC_CDE |
Campus |
SECTION_MASTER.CRS_TITLE |
Title |
SECTION_MASTER.CRS_CAPACITY |
MaxEnrollment |
SECTION_MASTER.CRS_ENROLLMENT |
Enrollment |
SECTION_MASTER.SECTION_STS |
StatusCode |
Academic Section Meetings
SIS Database Value |
Astra Schedule Value |
|---|---|
SECTION_SCHEDULES.IMPORT_ID |
SisKey |
SECTION_SCHEDULES.YR_CDE + SECTION_SCHEDULES.TRM_CDE |
Term |
SECTION_SCHEDULES.CRS_CDE |
CourseCode |
RTRIM(SUBSTRING (SECTION_MASTER.CRS_CDE,0,CHARINDEX(' ', SECTION_MASTER.CRS_CDE))) |
Subject |
RTRIM(SUBSTRING(LTRIM(SUBSTRING (SECTION_MASTER.CRS_CDE,CHARINDEX (' ', SECTION_MASTER.CRS_CDE),LEN (SECTION_MASTER.CRS_CDE))) ,0,CHARINDEX (' ', SECTION_MASTER.CRS_CDE))) |
Course |
RTRIM(SUBSTRING(LTRIM(SUBSTRING(LTRIM( SUBSTRING(LTRIM(SUBSTRING (SECTION_SCHEDULES.CRS_CDE,CHARINDEX (' ', SECTION_SCHEDULES.CRS_CDE),LEN (SECTION_SCHEDULES.CRS_CDE))), 0,LEN (SECTION_SCHEDULES.CRS_CDE))),CHARINDEX(' ', LTRIM(SUBSTRING(LTRIM(SUBSTRING (SECTION_SCHEDULES.CRS_CDE,CHARINDEX (' ', SECTION_SCHEDULES.CRS_CDE),LEN (SECTION_SCHEDULES.CRS_CDE))), 0,LEN (SECTION_SCHEDULES.CRS_CDE)))),LEN (SECTION_SCHEDULES.CRS_CDE))),0,CHARINDEX (' ', SECTION_SCHEDULES.CRS_CDE))) |
SectionNumber |
SECTION_SCHEDULES.LOC_CDE |
Campus |
SECTION_SCHEDULES.CRS_CDE |
CrossListCourseCode |
SECTION_SCHEDULES.BEGIN_DTE |
StartDate |
SECTION_SCHEDULES.END_DTE |
EndDate |
SECTION_SCHEDULES.BEGIN_TIM |
StartTime |
SECTION_SCHEDULES.END_TIM |
EndTime |
SECTION_SCHEDULES.CRS_MEET_TYPE |
MeetingType |
daysmet.DaysMetSunday + daysmet.DaysMetMonday + daysmet.DaysMetTuesday + daysmet.DaysMetWednesday + daysmet.DaysMetThursday + daysmet.DaysMetFriday + daysmet.DaysMetSaturday |
DaysMet |
SECTION_SCHEDULES.BLDG_CDE |
Building |
SECTION_SCHEDULES.ROOM_CDE |
Room |
CrossList Information
SIS Database Value |
Astra Schedule Value |
|---|---|
SECTION_MASTER.YR_CDE + '_' + RTRIM(SECTION_MASTER.CRS_CDE) + '_' + RTRIM(SECTION_MASTER.X_LISTED_PARNT_CRS) |
CrossListNumber |
Section Meeting Instructors
SIS Database Value |
Astra Schedule Value |
|---|---|
NAME_MASTER.ID_NUM |
SisKey |
NAME_MASTER.LAST_NAME |
LastName |
NAME_MASTER.FIRST_NAME |
FirstName |
NAME_MASTER.MIDDLE_NAME |
MiddleName |
Page url: ?jenzabarexsisinterfaceaddendum_3.htm
