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

SGHE Enterprise Data Warehouse EDW Source: PRE_STUDENT

Source Column Local Source Target Type Target Target Column Local Target
FIRST_CONTACT NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

FIRST_CONTACT

NO

FIRST_CONTACT_DESC NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

FIRST_CONTACT_LD

FIRST_CONTACT_SD

NO

NO

FUNCTION NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

FINAL_DEGREE_IND

NO

LATEST_POST_SECONDARY_DESC NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

POST_SECONDARY_SCHOOL_LD

POST_SECONDARY_SCHOOL_SD

NO

NO

LATEST_POST_SECONDARY_SCHOOL NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

POST_SECONDARY_SCHOOL

NO

POST_SECONDARY_DEGREE1 NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

POST_SECONDARY_DEGREE

NO

POST_SECONDARY_DEGREE_DESC1 NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

POST_SECONDARY_DEGREE_SD

POST_SECONDARY_DEGREE_LD

NO

NO

POST_SECONDARY_MAJOR1 NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

POST_SECONDARY_MAJOR

NO

POST_SECONDARY_MAJOR_DESC1 NO

DIMENSION TABLE

WDT_POST_SECONDARY_SCHOOL

WDT_POST_SECONDARY_SCHOOL

POST_SECONDARY_MAJOR_SD

POST_SECONDARY_MAJOR_LD

NO

NO

PS_SCHOOL_PERCENTILE NO

DIMENSION TABLE

WDT_PRE_STUDENT

ACADEMIC_PERCENTILE

NO

SECONDARY_SCHOOL_DIPLOMA NO

DIMENSION TABLE

WDT_SECONDARY_SCHOOL

WDT_SECONDARY_SCHOOL

SECONDARY_DIPLOMA

SECONDARY_DIPLOMA

NO

NO

SECONDARY_SCHOOL_DIPLOMA_DESC NO

DIMENSION TABLE

WDT_SECONDARY_SCHOOL

WDT_SECONDARY_SCHOOL

WDT_SECONDARY_SCHOOL

WDT_SECONDARY_SCHOOL

SECONDARY_DIPLOMA_LD

SECONDARY_DIPLOMA_SD

SECONDARY_DIPLOMA_SD

SECONDARY_DIPLOMA_LD

NO

NO

NO

NO

SECONDARY_SCHOOL_PERCENTILE NO

DIMENSION TABLE

WDT_PRE_STUDENT

ACADEMIC_PERCENTILE

NO



Ver: 3.1