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

SGHE Enterprise Data Warehouse EDW Source: ACADEMIC_STUDY

Source Column Local Source Target Type Target Target Column Local Target
ADMISSIONS_POPULATION NO

DIMENSION TABLE

WDT_ACADEMIC_PROGRAM

ADMISSIONS_POPULATION

NO

ADMISSIONS_POPULATION_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_PROGRAM

ADMISSIONS_POPULATION_LD

ADMISSIONS_POPULATION_SD

NO

NO

AWARD_CATEGORY NO

DIMENSION TABLE

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

AWARD_CATEGORY

AWARD_CATEGORY

AWARD_CATEGORY

AWARD_CATEGORY

NO

NO

NO

NO

AWARD_CATEGORY_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

AWARD_CATEGORY_LD

AWARD_CATEGORY_SD

AWARD_CATEGORY_SD

AWARD_CATEGORY_SD

AWARD_CATEGORY_LD

AWARD_CATEGORY_LD

AWARD_CATEGORY_SD

AWARD_CATEGORY_LD

NO

NO

NO

NO

NO

NO

NO

NO

CAMPUS NO

DIMENSION TABLE

WDT_STUDENT

WDT_ACADEMIC_PROGRAM

WDT_STUDENT

CAMPUS

CAMPUS

CAMPUS

NO

NO

NO

CAMPUS_DESC NO

DIMENSION TABLE

WDT_STUDENT

WDT_STUDENT

WDT_ACADEMIC_PROGRAM

WDT_STUDENT

WDT_ACADEMIC_PROGRAM

WDT_STUDENT

CAMPUS_LD

CAMPUS_LD

CAMPUS_LD

CAMPUS_SD

CAMPUS_SD

CAMPUS_SD

NO

NO

NO

NO

NO

NO

COLLEGE NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

COLLEGE

COLLEGE

COLLEGE

COLLEGE

NO

NO

NO

NO

COLLEGE_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

COLLEGE_SD

COLLEGE_LD

COLLEGE_LD

COLLEGE_SD

COLLEGE_SD

COLLEGE_SD

COLLEGE_LD

COLLEGE_LD

NO

NO

NO

NO

NO

NO

NO

NO

CURRICULUM_PRIORITY_NUMBER NO        
DEGREE NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

DEGREE

DEGREE

DEGREE

DEGREE

NO

NO

NO

NO

DEGREE_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

DEGREE_LD

DEGREE_SD

DEGREE_SD

DEGREE_SD

DEGREE_LD

DEGREE_LD

DEGREE_LD

DEGREE_SD

NO

NO

NO

NO

NO

NO

NO

NO

DEPARTMENT NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_MAJOR

WDT_ACADEMIC_STUDY

DEPARTMENT

DEPARTMENT

DEPARTMENT

DEPARTMENT

NO

NO

NO

NO

DEPARTMENT_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_MAJOR

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_MAJOR

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

DEPARTMENT_LD

DEPARTMENT_LD

DEPARTMENT_SD

DEPARTMENT_SD

DEPARTMENT_SD

DEPARTMENT_LD

DEPARTMENT_SD

DEPARTMENT_LD

NO

NO

NO

NO

NO

NO

NO

NO

FIRST_CONCENTRATION NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

FIRST_CONCENTRATION_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

FIRST_MINOR NO

DIMENSION TABLE

WDT_MINOR

MINOR

NO

FIRST_MINOR_DESC NO

DIMENSION TABLE

WDT_MINOR

WDT_MINOR

MINOR_SD

MINOR_LD

NO

NO

FOURTH_DEPARTMENT NO

DIMENSION TABLE

WDT_MAJOR

DEPARTMENT

NO

FOURTH_DEPARTMENT_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_MAJOR

DEPARTMENT_LD

DEPARTMENT_SD

NO

NO

FOURTH_MAJOR NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_MAJOR

CONCENTRATION_MAJOR

MAJOR

NO

NO

FOURTH_MAJOR_CONC_1 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

FOURTH_MAJOR_CONC_1_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

FOURTH_MAJOR_CONC_2 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

FOURTH_MAJOR_CONC_2_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

FOURTH_MAJOR_CONC_3 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

FOURTH_MAJOR_CONC_3_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

FOURTH_MAJOR_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_MAJOR

WDT_CONCENTRATION

WDT_MAJOR

CONCENTRATION_MAJOR_SD

MAJOR_LD

CONCENTRATION_MAJOR_LD

MAJOR_SD

NO

NO

NO

NO

FOURTH_MINOR NO

DIMENSION TABLE

WDT_MINOR

MINOR

NO

FOURTH_MINOR_DESC NO

DIMENSION TABLE

WDT_MINOR

WDT_MINOR

MINOR_LD

MINOR_SD

NO

NO

FOURTH_PROGRAM_CLASSIFICATION NO

DIMENSION TABLE

WDT_MAJOR

PROGRAM_CLASSIFICATION

NO

FOURTH_PROGRAM_CLASSIF_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_MAJOR

PROGRAM_CLASSIFICATION_LD

PROGRAM_CLASSIFICATION_SD

NO

NO

INTENDED_TIME_STATUS NO

DIMENSION TABLE

WDT_GRADUATION

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_GRADUATION

WDT_GRADUATION

WDT_ENROLLMENT_STATUS

INTENDED_TIME_STATUS_SD

INTENDED_TIME_STATUS

INTENDED_TIME_STATUS_SD

INTENDED_TIME_STATUS

INTENDED_TIME_STATUS_LD

INTENDED_TIME_STATUS_LD

INTENDED_TIME_STATUS_LD

INTENDED_TIME_STATUS

INTENDED_TIME_STATUS_SD

NO

NO

NO

NO

NO

NO

NO

NO

NO

INTENDED_TIME_STATUS_DESC NO        
MAJOR NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_MAJOR

WDT_ACADEMIC_STUDY

WDT_CONCENTRATION

WDT_ACADEMIC_STUDY

MAJOR

MAJOR

MAJOR

CONCENTRATION_MAJOR

MAJOR

NO

NO

NO

NO

NO

MAJOR_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_ACADEMIC_STUDY

WDT_CONCENTRATION

WDT_CONCENTRATION

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_MAJOR

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

MAJOR_LD

MAJOR_LD

CONCENTRATION_MAJOR_LD

CONCENTRATION_MAJOR_SD

MAJOR_SD

MAJOR_LD

MAJOR_SD

MAJOR_LD

MAJOR_SD

MAJOR_SD

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

PROGRAM NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

PROGRAM

PROGRAM

PROGRAM

PROGRAM

NO

NO

NO

NO

PROGRAM_CLASSIFICATION NO

DIMENSION TABLE

WDT_MAJOR

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

PROGRAM_CLASSIFICATION

PROGRAM_CLASSIFICATION

PROGRAM_CLASSIFICATION

PROGRAM_CLASSIFICATION

NO

NO

NO

NO

PROGRAM_CLASSIFICATION_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_MAJOR

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_MAJOR

PROGRAM_CLASSIFICATION_SD

PROGRAM_CLASSIFICATION_SD

PROGRAM_CLASSIFICATION_SD

PROGRAM_CLASSIFICATION_SD

PROGRAM_CLASSIFICATION_LD

PROGRAM_CLASSIFICATION_LD

PROGRAM_CLASSIFICATION_LD

PROGRAM_CLASSIFICATION_LD

NO

NO

NO

NO

NO

NO

NO

NO

PROGRAM_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

PROGRAM_LD

PROGRAM_SD

PROGRAM_LD

PROGRAM_SD

PROGRAM_LD

PROGRAM_SD

PROGRAM_LD

PROGRAM_SD

NO

NO

NO

NO

NO

NO

NO

NO

SECOND_CONCENTRATION NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

SECOND_CONCENTRATION_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

SECOND_DEPARTMENT NO

DIMENSION TABLE

WDT_MAJOR

DEPARTMENT

NO

SECOND_DEPARTMENT_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_MAJOR

DEPARTMENT_SD

DEPARTMENT_LD

NO

NO

SECOND_MAJOR NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_MAJOR

CONCENTRATION_MAJOR

MAJOR

NO

NO

SECOND_MAJOR_CONC_1 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

SECOND_MAJOR_CONC_1_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

SECOND_MAJOR_CONC_2 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

SECOND_MAJOR_CONC_2_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_LD

CONCENTRATION_SD

NO

NO

SECOND_MAJOR_CONC_3 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

SECOND_MAJOR_CONC_3_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

SECOND_MAJOR_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_CONCENTRATION

WDT_MAJOR

WDT_CONCENTRATION

MAJOR_SD

CONCENTRATION_MAJOR_LD

MAJOR_LD

CONCENTRATION_MAJOR_SD

NO

NO

NO

NO

SECOND_MINOR NO

DIMENSION TABLE

WDT_MINOR

MINOR

NO

SECOND_MINOR_DESC NO

DIMENSION TABLE

WDT_MINOR

WDT_MINOR

MINOR_SD

MINOR_LD

NO

NO

SECOND_PROGRAM_CLASSIFICATION NO

DIMENSION TABLE

WDT_MAJOR

PROGRAM_CLASSIFICATION

NO

SECOND_PROGRAM_CLASSIF_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_MAJOR

PROGRAM_CLASSIFICATION_LD

PROGRAM_CLASSIFICATION_SD

NO

NO

STUDENT_CLASSIFICATION NO

DIMENSION TABLE

WDT_STUDENT

WDT_ACADEMIC_PROGRAM

WDT_STUDENT

STUDENT_CLASSIFICATION

STUDENT_CLASSIFICATION

STUDENT_CLASSIFICATION

NO

NO

NO

STUDENT_CLASSIFICATION_DESC NO

DIMENSION TABLE

WDT_STUDENT

WDT_STUDENT

WDT_STUDENT

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_PROGRAM

WDT_STUDENT

STUDENT_CLASSIFICATION_SD

STUDENT_CLASSIFICATION_LD

STUDENT_CLASSIFICATION_SD

STUDENT_CLASSIFICATION_LD

STUDENT_CLASSIFICATION_SD

STUDENT_CLASSIFICATION_LD

NO

NO

NO

NO

NO

NO

STUDENT_LEVEL NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

NO

NO

NO

NO

STUDENT_LEVEL_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_PROGRAM

STUDENT_LEVEL_LD

STUDENT_LEVEL_SD

STUDENT_LEVEL_LD

STUDENT_LEVEL_LD

STUDENT_LEVEL_SD

STUDENT_LEVEL_SD

STUDENT_LEVEL_LD

STUDENT_LEVEL_SD

NO

NO

NO

NO

NO

NO

NO

NO

STUDENT_POPULATION NO

DIMENSION TABLE

WDT_STUDENT

WDT_STUDENT

WDT_ACADEMIC_PROGRAM

STUDENT_POPULATION

STUDENT_POPULATION

STUDENT_POPULATION

NO

NO

NO

STUDENT_POPULATION_DESC NO

DIMENSION TABLE

WDT_STUDENT

WDT_ACADEMIC_PROGRAM

WDT_ACADEMIC_PROGRAM

WDT_STUDENT

WDT_STUDENT

WDT_STUDENT

STUDENT_POPULATION_LD

STUDENT_POPULATION_SD

STUDENT_POPULATION_LD

STUDENT_POPULATION_SD

STUDENT_POPULATION_LD

STUDENT_POPULATION_SD

NO

NO

NO

NO

NO

NO

THIRD_CONCENTRATION NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

THIRD_CONCENTRATION_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

THIRD_DEPARTMENT NO

DIMENSION TABLE

WDT_MAJOR

DEPARTMENT

NO

THIRD_DEPARTMENT_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_MAJOR

DEPARTMENT_SD

DEPARTMENT_LD

NO

NO

THIRD_MAJOR NO

DIMENSION TABLE

WDT_MAJOR

WDT_CONCENTRATION

MAJOR

CONCENTRATION_MAJOR

NO

NO

THIRD_MAJOR_CONC_1 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

THIRD_MAJOR_CONC_1_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_SD

CONCENTRATION_LD

NO

NO

THIRD_MAJOR_CONC_2 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

THIRD_MAJOR_CONC_2_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_LD

CONCENTRATION_SD

NO

NO

THIRD_MAJOR_CONC_3 NO

DIMENSION TABLE

WDT_CONCENTRATION

CONCENTRATION

NO

THIRD_MAJOR_CONC_3_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_CONCENTRATION

CONCENTRATION_LD

CONCENTRATION_SD

NO

NO

THIRD_MAJOR_DESC NO

DIMENSION TABLE

WDT_CONCENTRATION

WDT_MAJOR

WDT_CONCENTRATION

WDT_MAJOR

CONCENTRATION_MAJOR_SD

MAJOR_LD

CONCENTRATION_MAJOR_LD

MAJOR_SD

NO

NO

NO

NO

THIRD_MINOR NO

DIMENSION TABLE

WDT_MINOR

MINOR

NO

THIRD_MINOR_DESC NO

DIMENSION TABLE

WDT_MINOR

WDT_MINOR

MINOR_LD

MINOR_SD

NO

NO

THIRD_PROGRAM_CLASSIFICATION NO

DIMENSION TABLE

WDT_MAJOR

PROGRAM_CLASSIFICATION

NO

THIRD_PROGRAM_CLASSIF_DESC NO

DIMENSION TABLE

WDT_MAJOR

WDT_MAJOR

PROGRAM_CLASSIFICATION_SD

PROGRAM_CLASSIFICATION_LD

NO

NO



Ver: 3.1