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

SGHE Enterprise Data Warehouse EDW Source: YEAR_TYPE_DEFINITION

Source Column Local Source Target Type Target Target Column Local Target
ACADEMIC_PERIOD NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

ACADEMIC_PERIOD

ACADEMIC_PERIOD

ACADEMIC_PERIOD

ACADEMIC_PERIOD

NO

NO

NO

NO

ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

ACADEMIC_PERIOD_LD

ACADEMIC_PERIOD_LD

ACADEMIC_PERIOD_SD

ACADEMIC_PERIOD_LD

ACADEMIC_PERIOD_LD

ACADEMIC_PERIOD_SD

ACADEMIC_PERIOD_SD

ACADEMIC_PERIOD_SD

NO

NO

NO

NO

NO

NO

NO

NO

ACADEMIC_YEAR NO

DIMENSION TABLE

WDT_TIME

ACADEMIC_YEAR

NO

ACADEMIC_YEAR_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

ACADEMIC_YEAR_SD

ACADEMIC_YEAR_LD

NO

NO

AID_PERIOD NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

AID_PERIOD

AID_PERIOD

AID_PERIOD

AID_PERIOD

NO

NO

NO

NO

AID_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

AID_PERIOD_SD

AID_PERIOD_SD

AID_PERIOD_SD

AID_PERIOD_LD

AID_PERIOD_LD

AID_PERIOD_SD

AID_PERIOD_LD

AID_PERIOD_LD

NO

NO

NO

NO

NO

NO

NO

NO

AID_YEAR NO        
CALENDAR_MONTH NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

CALENDAR_MONTH

CALENDAR_MONTH

CALENDAR_MONTH

NO

NO

NO

CALENDAR_YEAR NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

CALENDAR_YEAR

CALENDAR_YEAR

CALENDAR_YEAR

NO

NO

NO

FISCAL_QUARTER NO        
FISCAL_YEAR NO        
FUNCTION NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

FISCAL_PERIOD

FISCAL_QUARTER

FISCAL_PERIOD

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_PERIOD

FISCAL_QUARTER

FISCAL_QUARTER

FISCAL_QUARTER

FISCAL_QUARTER

FISCAL_PERIOD

FISCAL_YEAR

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

SUB_ACADEMIC_PERIOD NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

SUB_ACADEMIC_PERIOD

NO

NO

NO

NO

NO

SUB_ACADEMIC_PERIOD_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

SUB_ACADEMIC_PERIOD_LD

SUB_ACADEMIC_PERIOD_SD

SUB_ACADEMIC_PERIOD_LD

SUB_ACADEMIC_PERIOD_SD

SUB_ACADEMIC_PERIOD_LD

SUB_ACADEMIC_PERIOD_LD

SUB_ACADEMIC_PERIOD_LD

SUB_ACADEMIC_PERIOD_SD

SUB_ACADEMIC_PERIOD_SD

SUB_ACADEMIC_PERIOD_SD

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

YEAR NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

AID_YEAR

AID_YEAR

ACADEMIC_YEAR

AID_YEAR

ACADEMIC_YEAR

ACADEMIC_YEAR

ACADEMIC_YEAR

AID_YEAR

NO

NO

NO

NO

NO

NO

NO

NO

YEAR_DESC NO

DIMENSION TABLE

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

WDT_TIME

ACADEMIC_YEAR_SD

ACADEMIC_YEAR_LD

ACADEMIC_YEAR_LD

AID_YEAR_LD

AID_YEAR_SD

AID_YEAR_SD

AID_YEAR_LD

AID_YEAR_SD

ACADEMIC_YEAR_SD

AID_YEAR_LD

ACADEMIC_YEAR_SD

ACADEMIC_YEAR_LD

AID_YEAR_LD

AID_YEAR_SD

ACADEMIC_YEAR_LD

ACADEMIC_YEAR_SD

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO



Ver: 3.1