SGHE Enterprise Data Warehouse
Banner EDW Source: SCHEDULE_OFFERING - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD |
COURSE SECTION |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
COURSE SECTION COURSE SECTION |
NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_YEAR |
COURSE SECTION |
NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
COURSE SECTION COURSE SECTION |
NO NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
COURSE SECTION |
NO |
| CENSUS_ENROLLMENT_DATE1 |
NO |
FACT TABLE |
WFT_COURSE_SECTION |
CENSUS_ENROLLMENT_DATE1 |
COURSE SECTION |
NO |
| CENSUS_ENROLLMENT_DATE2 |
NO |
FACT TABLE |
WFT_COURSE_SECTION |
CENSUS_ENROLLMENT_DATE2 |
COURSE SECTION |
NO |
| COURSE_REFERENCE_NUMBER |
NO |
DIMENSION TABLE |
WDT_COURSE_REFERENCE_NUMBER |
COURSE_REFERENCE_NUMBER |
COURSE SECTION |
NO |
| END_DATE |
NO |
FACT TABLE |
WFT_COURSE_SECTION |
END_DATE |
COURSE SECTION |
NO |
| GRADABLE_IND |
NO |
DIMENSION TABLE |
WDT_COURSE_SECTION WDT_COURSE_SECTION WDT_COURSE_SECTION |
GRADABLE_IND GRADABLE_IND_LD GRADABLE_IND_SD |
COURSE SECTION, STUDENT COURSE COURSE SECTION COURSE SECTION |
NO NO NO |
| MAX_CONTACT_HOURS |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_CONTACT_HOURS |
ENROLLMENT |
NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
COURSE SECTION |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_LD MULTI_SOURCE_SD |
COURSE SECTION COURSE SECTION |
NO NO |
| OFFERING_NUMBER |
NO |
DIMENSION TABLE |
WDT_COURSE_SECTION WDT_COURSE_SECTION WDT_COURSE_SECTION |
COURSE_SECTION COURSE_SECTION_LD COURSE_SECTION_SD |
COURSE SECTION, STUDENT COURSE COURSE SECTION COURSE SECTION |
NO NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
COURSE SECTION |
NO |
| SECTION_CROSS_LIST |
NO |
DIMENSION TABLE |
WDT_COURSE_SECTION |
SECTION_CROSS_LIST |
COURSE SECTION, STUDENT COURSE |
NO |
| SECTION_CROSS_LIST_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE_SECTION WDT_COURSE_SECTION |
SECTION_CROSS_LIST_SD SECTION_CROSS_LIST_LD |
COURSE SECTION, STUDENT COURSE COURSE SECTION, STUDENT COURSE |
NO NO |
| START_DATE |
NO |
FACT TABLE |
WFT_COURSE_SECTION |
START_DATE |
COURSE SECTION |
NO |
| STUDENT_MEETING_TIME |
NO |
DIMENSION TABLE |
WDT_COURSE |
SESSION_TYPE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| STUDENT_MEETING_TIME_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
SESSION_TYPE_SD SESSION_TYPE_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_SUB_ACADEMIC_PERIOD |
SUB_ACADEMIC_PERIOD |
COURSE SECTION |
NO |
| SUB_ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_SUB_ACADEMIC_PERIOD WDT_SUB_ACADEMIC_PERIOD |
SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD |
COURSE SECTION COURSE SECTION |
NO NO |