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

SGHE Enterprise Data Warehouse EDW Source: ENROLLMENT

Source Column Local Source Target Type Target Target Column Local Target
ACADEMIC_OUTCOME_ENROLLED_IND NO

DIMENSION TABLE

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

ACADEMIC_OUTCOME_ENROLLED_IND

ACADEMIC_OUTCOME_ENROLLED_IND

NO

NO

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

ACTIVE_ACADEMIC_PERIODS NO        
ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

NO

CURRENT_TIME_STATUS NO

DIMENSION TABLE

WDT_ENROLLMENT_STATUS

WDT_GRADUATION

WDT_ENROLLMENT_STATUS

CURRENT_TIME_STATUS

COMPLETION_TIME_STATUS

CURRENT_TIME_STATUS

NO

NO

NO

CURRENT_TIME_STATUS_DESC NO

DIMENSION TABLE

WDT_GRADUATION

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_GRADUATION

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

COMPLETION_TIME_STATUS_LD

CURRENT_TIME_STATUS_LD

CURRENT_TIME_STATUS_LD

COMPLETION_TIME_STATUS_SD

CURRENT_TIME_STATUS_SD

CURRENT_TIME_STATUS_SD

NO

NO

NO

NO

NO

NO

ENROLLED_IND NO

DIMENSION TABLE

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

ENROLLED_IND

ENROLLED_IND

NO

NO

ENROLLMENT_STATUS NO

DIMENSION TABLE

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

ENROLLMENT_STATUS

ENROLLMENT_STATUS

NO

NO

ENROLLMENT_STATUS_DESC NO

DIMENSION TABLE

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

ENROLLMENT_STATUS_LD

ENROLLMENT_STATUS_LD

ENROLLMENT_STATUS_SD

ENROLLMENT_STATUS_SD

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

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

NO

REGISTERED_IND NO

DIMENSION TABLE

WDT_ENROLLMENT_STATUS

WDT_ENROLLMENT_STATUS

REGISTERED_IND

REGISTERED_IND

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

WDT_TIME

SUB_ACADEMIC_PERIOD_SD

SUB_ACADEMIC_PERIOD_LD

SUB_ACADEMIC_PERIOD_SD

NO

NO

NO



Ver: 3.1