RETURN TO EDW META DATA REPORTS LIST
(ODS Target Report)

SGHE Enterprise Data Warehouse EDW Source: STUDENT_COURSE

Source Column Local Source Target Type Target Target Column Local Target
ACADEMIC_PERIOD NO

DIMENSION TABLE

WDT_TIME

ACADEMIC_PERIOD

NO

ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

ACADEMIC_PERIOD_SD

ACADEMIC_PERIOD_LD

NO

NO

ACADEMIC_YEAR NO

DIMENSION TABLE

WDT_TIME

ACADEMIC_YEAR

NO

ACADEMIC_YEAR_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

ACADEMIC_YEAR_LD

ACADEMIC_YEAR_SD

NO

NO

ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

CAMPUS NO

DIMENSION TABLE

WDT_COURSE

COURSE_CAMPUS

NO

CAMPUS_DESC NO

DIMENSION TABLE

WDT_COURSE

WDT_COURSE

COURSE_CAMPUS_SD

COURSE_CAMPUS_LD

NO

NO

COLLEGE NO

DIMENSION TABLE

WDT_COURSE

COURSE_COLLEGE

NO

COLLEGE_DESC NO

DIMENSION TABLE

WDT_COURSE

WDT_COURSE

COURSE_COLLEGE_LD

COURSE_COLLEGE_SD

NO

NO

COURSE_CREDITS NO        
COURSE_IDENTIFICATION NO

DIMENSION TABLE

WDT_COURSE

COURSE_IDENTIFICATION

NO

COURSE_LEVEL NO

DIMENSION TABLE

WDT_COURSE

COURSE_LEVEL

NO

COURSE_LEVEL_DESC NO

DIMENSION TABLE

WDT_COURSE

WDT_COURSE

COURSE_LEVEL_LD

COURSE_LEVEL_SD

NO

NO

COURSE_NUMBER NO

DIMENSION TABLE

WDT_COURSE

COURSE_NUMBER

NO

COURSE_REFERENCE_NUMBER NO        
CREDITS_ATTEMPTED NO        
CREDITS_EARNED NO        
CREDITS_FOR_GPA NO        
CREDITS_GPA_CALCULATION NO        
CREDITS_PASSED NO        
DEPARTMENT NO

DIMENSION TABLE

WDT_COURSE

COURSE_DEPARTMENT

NO

DEPARTMENT_DESC NO

DIMENSION TABLE

WDT_COURSE

WDT_COURSE

COURSE_DEPARTMENT_LD

COURSE_DEPARTMENT_SD

NO

NO

DIVISION NO

DIMENSION TABLE

WDT_COURSE

COURSE_DIVISION

NO

DIVISION_DESC NO

DIMENSION TABLE

WDT_COURSE

WDT_COURSE

COURSE_DIVISION_SD

COURSE_DIVISION_LD

NO

NO

FINAL_GRADE NO

DIMENSION TABLE

WDT_REGISTRATION

FINAL_GRADE

NO

GRADE_TYPE NO

DIMENSION TABLE

WDT_REGISTRATION

GRADE_TYPE

NO

GRADE_TYPE_DESC NO

DIMENSION TABLE

WDT_REGISTRATION

WDT_REGISTRATION

GRADE_TYPE_LD

GRADE_TYPE_SD

NO

NO

MULTI_SOURCE NO

DIMENSION TABLE

WDT_MULTI_SOURCE

MULTI_SOURCE

NO

MULTI_SOURCE_DESC NO

DIMENSION TABLE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

MULTI_SOURCE_SD

MULTI_SOURCE_LD

NO

NO

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

QUALITY_POINTS NO        
REGISTRATION_STATUS NO

DIMENSION TABLE

WDT_REGISTRATION

REGISTRATION_STATUS

NO

REGISTRATION_STATUS_DESC NO

DIMENSION TABLE

WDT_REGISTRATION

WDT_REGISTRATION

REGISTRATION_STATUS_LD

REGISTRATION_STATUS_SD

NO

NO

SCHEDULE NO

DIMENSION TABLE

WDT_COURSE

SCHEDULE

NO

SCHEDULE_DESC NO

DIMENSION TABLE

WDT_COURSE

WDT_COURSE

SCHEDULE_LD

SCHEDULE_SD

NO

NO

SUBJECT NO

DIMENSION TABLE

WDT_COURSE

SUBJECT

NO

SUBJECT_DESC NO

DIMENSION TABLE

WDT_COURSE

WDT_COURSE

SUBJECT_LD

SUBJECT_SD

NO

NO

SUB_ACADEMIC_PERIOD NO

DIMENSION TABLE

WDT_TIME

SUB_ACADEMIC_PERIOD

NO

SUB_ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

SUB_ACADEMIC_PERIOD_SD

SUB_ACADEMIC_PERIOD_LD

NO

NO

TITLE_LONG_DESC NO

DIMENSION TABLE

WDT_COURSE

COURSE_TITLE_LONG

NO

TITLE_SHORT_DESC NO

DIMENSION TABLE

WDT_COURSE

COURSE_TITLE_SHORT

NO



Ver: 3.1