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

SGHE Enterprise Data Warehouse EDW Source: ACADEMIC_OUTCOME

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

AWARD_CATEGORY NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

AWARD_CATEGORY

NO

AWARD_CATEGORY_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

AWARD_CATEGORY_SD

AWARD_CATEGORY_LD

NO

NO

CAMPUS NO

DIMENSION TABLE

WDT_GRADUATION

WDT_STUDENT

GRADUATION_CAMPUS

CAMPUS

NO

NO

CAMPUS_DESC NO

DIMENSION TABLE

WDT_STUDENT

WDT_GRADUATION

WDT_STUDENT

WDT_GRADUATION

CAMPUS_LD

GRADUATION_CAMPUS_LD

CAMPUS_SD

GRADUATION_CAMPUS_SD

NO

NO

NO

NO

COLLEGE NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

COLLEGE

NO

COLLEGE_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

COLLEGE_LD

COLLEGE_SD

NO

NO

CREDITS_ATTEMPTED NO        
CREDITS_EARNED NO        
CREDITS_PASSED NO        
DEGREE NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

WDT_ACADEMIC_STUDY

POST_SECONDARY_DEGREE

POST_SECONDARY_DEGREE

DEGREE

NO

NO

NO

DEGREE_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

DEGREE_LD

DEGREE_SD

POST_SECONDARY_DEGREE_LD

POST_SECONDARY_DEGREE_SD

POST_SECONDARY_DEGREE_LD

POST_SECONDARY_DEGREE_SD

NO

NO

NO

NO

NO

NO

DEPARTMENT NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

DEPARTMENT

NO

DEPARTMENT_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

DEPARTMENT_LD

DEPARTMENT_SD

NO

NO

GPA_CREDITS NO        
MAJOR NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

WDT_ACADEMIC_STUDY

WDT_POST_SECONDARY_SCHOOL

POST_SECONDARY_MAJOR

MAJOR

POST_SECONDARY_MAJOR

NO

NO

NO

MAJOR_DESC NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

WDT_ACADEMIC_STUDY

WDT_POST_SECONDARY_SCHOOL

WDT_ACADEMIC_STUDY

POST_SECONDARY_MAJOR_SD

POST_SECONDARY_MAJOR_LD

POST_SECONDARY_MAJOR_LD

MAJOR_LD

POST_SECONDARY_MAJOR_SD

MAJOR_SD

NO

NO

NO

NO

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

OUTCOME_GRADUATION_DATE NO

DIMENSION TABLE

WDT_TIME

WDT_GRADUATION

WDT_TIME

WDT_TIME

WDT_TIME

CALENDAR_MONTH

OUTCOME_GRADUATION_DATE

CALENDAR_YEAR

CALENDAR_MONTH

CALENDAR_YEAR

NO

NO

NO

NO

NO

OUTCOME_NUMBER NO        
PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

PROGRAM NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

PROGRAM

NO

PROGRAM_CLASSIFICATION NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

PROGRAM_CLASSIFICATION

NO

PROGRAM_CLASSIFICATION_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

PROGRAM_CLASSIFICATION_SD

PROGRAM_CLASSIFICATION_LD

NO

NO

PROGRAM_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

PROGRAM_LD

PROGRAM_SD

NO

NO

QUALITY_POINTS NO        
STUDENT_LEVEL NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

STUDENT_LEVEL

NO

STUDENT_LEVEL_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

STUDENT_LEVEL_LD

STUDENT_LEVEL_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



Ver: 3.1