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

SGHE Enterprise Data Warehouse EDW Source: ADMISSIONS_APPLICATION

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

ADMISSIONS_POPULATION NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

ADMISSIONS_POPULATION

NO

ADMISSIONS_POPULATION_DESC NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

ADMISSIONS_POPULATION_LD

ADMISSIONS_POPULATION_SD

NO

NO

APPLICATION_DATE NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

CALENDAR_YEAR

CALENDAR_MONTH

NO

NO

APPL_ACCEPT_ANY_TIME_IND NO

DIMENSION TABLE

WDT_PRE_STUDENT_STATUS

WDT_PRE_STUDENT_STATUS

ACCEPTED_IND

ACCEPTED_IND

NO

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_STUDENT_APPLICATION

CAMPUS

NO

CAMPUS_DESC NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

CAMPUS_LD

CAMPUS_SD

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

COUNTY_ADMIT NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

COUNTY_ADMIT

NO

COUNTY_ADMIT_DESC NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

COUNTY_ADMIT_LD

COUNTY_ADMIT_SD

NO

NO

DEGREE NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

DEGREE

NO

DEGREE_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

DEGREE_LD

DEGREE_SD

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

ENROLLED_IND NO

DIMENSION TABLE

WDT_PRE_STUDENT_STATUS

WDT_PRE_STUDENT_STATUS

ENROLLED_IND

ENROLLED_IND

NO

NO

FUNCTION NO

DIMENSION TABLE

WDT_PRE_STUDENT_STATUS

WDT_PRE_STUDENT_STATUS

WDT_PRE_STUDENT_STATUS

WDT_PRE_STUDENT_STATUS

APPLIED_IND

INQUIRED_IND

INQUIRED_IND

APPLIED_IND

NO

NO

NO

NO

INST_ADMIT_ANY_TIME_IND NO

DIMENSION TABLE

WDT_PRE_STUDENT_STATUS

WDT_PRE_STUDENT_STATUS

ADMITTED_IND

ADMITTED_IND

NO

NO

INTENDED_TIME_STATUS NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

INTENDED_TIME_STATUS

NO

MAJOR NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

MAJOR

NO

MAJOR_DESC NO

DIMENSION TABLE

WDT_ACADEMIC_STUDY

WDT_ACADEMIC_STUDY

MAJOR_LD

MAJOR_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

NATION_ADMIT NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

NATION_ADMIT

NO

NATION_ADMIT_DESC NO        
NATION_DESC_ADMIT NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

NATION_ADMIT_LD

NATION_ADMIT_SD

NO

NO

PERSON_UID 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

RESIDENCY NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

RESIDENCY

NO

RESIDENCY_DESC NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

RESIDENCY_SD

RESIDENCY_LD

NO

NO

SEQUENCE_NUMBER NO        
STATE_ADMIT NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

STATE_PROVINCE_ADMIT

NO

STATE_DESC_ADMIT NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

STATE_PROVINCE_ADMIT_LD

STATE_PROVINCE_ADMIT_SD

NO

NO

STATE_PROVINCE_ADMIT NO        
STATE_PROVINCE_ADMIT_DESC 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

STUDENT_POPULATION NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

STUDENT_POPULATION

NO

STUDENT_POPULATION_DESC NO

DIMENSION TABLE

WDT_STUDENT_APPLICATION

WDT_STUDENT_APPLICATION

STUDENT_POPULATION_SD

STUDENT_POPULATION_LD

NO

NO



Ver: 3.1