RETURN TO EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse EDW Source: EDW CLEANSING PROCESS

Source Column Local Source Target Type Target Target Column Local Target
NA NO

DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_TIME

WDT_EMPLOYEE

WDT_EMPLOYEE

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_TIME

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_STUDENT_APPLICATION

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_POSITION

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_PLEDGE

WDT_TIME

WDT_PRE_STUDENT

WDT_JOB

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_PRE_STUDENT

WDT_TIME

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_POSITION

WDT_TIME

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_PLEDGE

WDT_TIME

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_DEMOGRAPHIC

WDT_PRE_STUDENT

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_TIME

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_TIME

WDT_POSITION

WDT_TIME

WDT_TIME

WDT_PLEDGE

WDT_PLEDGE

WDT_PLEDGE

WDT_EMPLOYEE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_PRE_STUDENT

WDT_DEMOGRAPHIC

WDT_GRANT_TYPE

WDT_DEMOGRAPHIC

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_TIME

WDT_DEMOGRAPHIC

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_PRE_STUDENT

WDT_TIME

WDT_TIME

WDT_TIME

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_PLEDGE

WDT_PLEDGE

WDT_PRE_STUDENT

WDT_JOB

WDT_DEMOGRAPHIC

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_MULTI_SOURCE

WDT_TIME

WDT_PLEDGE

WDT_EMPLOYEE

WDT_EMPLOYEE

WDT_EMPLOYEE

WDT_TIME

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_DEMOGRAPHIC

WDT_TIME

WDT_DEMOGRAPHIC

WDT_PLEDGE

WDT_TIME

WDT_TIME

WDT_PRE_STUDENT

WDT_PRE_STUDENT

WDT_DEMOGRAPHIC

WDT_TIME

WDT_PRE_STUDENT

WDT_TIME

WDT_TIME

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_GRANT_TYPE

WDT_PLEDGE

WDT_DEMOGRAPHIC

WDT_STUDENT_APPLICATION

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

AGE_RANGE_LD

FISCAL_PERIOD_LD

ANNUAL_SALARY_RANGE

ANNUAL_SALARY_RANGE_LD

TEST5_SCORE_RANGE_LD

TEST6_SCORE_RANGE

FISCAL_PERIOD_SD

ACADEMIC_PERCENTILE_RANGE_SD

TEST1_SCORE_RANGE_LD

FISCAL_YEAR_LD

EVENT_SD

AGE_RANGE

INTENDED_TIME_STATUS_SD

ADMINISTRATIVE_GROUP_SD

ADMINISTRATIVE_GROUP_LD

PROGRAM_CLASSIFICATION_LD

AGE_RANGE

EVENT_LD

CALENDAR_YEAR_SD

CALENDAR_YEAR_LD

FISCAL_PERIOD_SD

CALENDAR_MONTH_LD

OUTSTANDING_PLEDGE_RANGE_SD

CALENDAR_MONTH_LD

TEST5_SCORE_RANGE

JOB_SUFFIX_LD

EVENT_SD

FISCAL_PERIOD_SD

FISCAL_YEAR_SD

FISCAL_QUARTER_SD

EVENT_SD

FISCAL_PERIOD_LD

EVENT_SD

TEST1_SCORE_RANGE_SD

CALENDAR_YEAR_LD

ADMINISTRATIVE_GROUP_LD

PROCESS_GROUP_SD

PROGRAM_CLASSIFICATION_SD

FISCAL_QUARTER_SD

EVENT_SD

CALENDAR_MONTH_SD

FAMILY_INCOME_RANGE

ORIGINAL_PLEDGE_RANGE_LD

CALENDAR_MONTH_SD

TEST4_SCORE_RANGE_LD

TEST6_SCORE_RANGE_SD

FAMILY_INCOME_RANGE

TEST7_SCORE_RANGE

FAMILY_INCOME_RANGE

EVENT_LD

FISCAL_QUARTER_LD

FISCAL_QUARTER_LD

FISCAL_QUARTER_SD

AGE_RANGE_SD

CALENDAR_MONTH_LD

CALENDAR_MONTH_SD

CALENDAR_YEAR_SD

PROCESS_GROUP_LD

ADMINISTRATIVE_GROUP_SD

PROCESS_GROUP_SD

FISCAL_YEAR

PROGRAM_CLASSIFICATION

FISCAL_YEAR_SD

FISCAL_QUARTER_LD

FINAL_INSTALL_MONTH_SD

ORIGINAL_PLEDGE_RANGE

ORIGINAL_PLEDGE_RANGE_SD

YEARS_OF_SERVICE_RANGE_SD

CALENDAR_MONTH_LD

FISCAL_YEAR_SD

CALENDAR_YEAR_LD

FISCAL_PERIOD_SD

ACADEMIC_PERCENTILE_RANGE

AGE_RANGE

RESEARCH_PURPOSE_LD

FAMILY_INCOME_RANGE_LD

PROCESS_GROUP_LD

ADMINISTRATIVE_GROUP_LD

ADMINISTRATIVE_GROUP_SD

FAMILY_INCOME_RANGE

FISCAL_YEAR_LD

CALENDAR_YEAR_LD

FAMILY_INCOME_RANGE_SD

CALENDAR_MONTH_SD

AGE_RANGE

TEST2_SCORE_RANGE_LD

TEST2_SCORE_RANGE_SD

TEST3_SCORE_RANGE

TEST4_SCORE_RANGE

TEST4_SCORE_RANGE_SD

FAMILY_INCOME_RANGE_LD

FAMILY_INCOME_RANGE_SD

TEST7_SCORE_RANGE_SD

FISCAL_QUARTER_LD

FISCAL_PERIOD_LD

FISCAL_QUARTER_LD

ADMINISTRATIVE_GROUP_SD

ADMINISTRATIVE_GROUP_SD

PROCESS_GROUP_LD

PROCESS_GROUP_SD

FINAL_INSTALL_YEAR_LD

OUTSTANDING_PLEDGE_RANGE_LD

TEST3_SCORE_RANGE_LD

JOB_SUFFIX_SD

FAMILY_INCOME_RANGE_SD

FISCAL_PERIOD_LD

FISCAL_QUARTER_SD

FISCAL_YEAR_LD

FISCAL_YEAR_LD

CALENDAR_YEAR_SD

EVENT_LD

EVENT_LD

FISCAL_PERIOD_SD

FISCAL_QUARTER_SD

EVENT_LD

AGE_RANGE_SD

ADMINISTRATIVE_GROUP_LD

CALENDAR_YEAR_SD

OUTSTANDING_PLEDGE_RANGE

ANNUAL_SALARY_RANGE_SD

YEARS_OF_SERVICE_RANGE

YEARS_OF_SERVICE_RANGE_LD

CALENDAR_YEAR_LD

AGE_RANGE_LD

AGE_RANGE_SD

TEST3_SCORE_RANGE_SD

TEST5_SCORE_RANGE_SD

TEST1_SCORE_RANGE

TEST2_SCORE_RANGE

PROCESS_GROUP_SD

PROCESS_GROUP_LD

AGE_RANGE_SD

CALENDAR_MONTH_SD

FAMILY_INCOME_RANGE_LD

FINAL_INSTALL_YEAR_SD

CALENDAR_MONTH_LD

CALENDAR_YEAR_SD

TEST6_SCORE_RANGE_LD

TEST7_SCORE_RANGE_LD

FAMILY_INCOME_RANGE_LD

FISCAL_PERIOD_LD

ACADEMIC_PERCENTILE_RANGE_LD

FISCAL_YEAR_LD

FISCAL_YEAR_SD

AGE_RANGE_LD

FAMILY_INCOME_RANGE_SD

RESEARCH_PURPOSE_SD

FINAL_INSTALL_MONTH_LD

AGE_RANGE_LD

INTENDED_TIME_STATUS_LD

PROCESS_GROUP_SD

PROCESS_GROUP_LD

ADMINISTRATIVE_GROUP_LD

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO



Ver: 3.1