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

SGHE Enterprise Data Warehouse Banner EDW Source: FINAID_APPLICANT_STATUS - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
ADMINISTRATIVE_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

ADMINISTRATIVE_GROUP

FINANCIAL AID APPLICATION 

NO

AID_YEAR NO

DIMENSION TABLE

WDT_FINANCIAL_AID_YEAR

FINANCIAL_AID_YEAR

FINANCIAL AID APPLICATION 

NO

AID_YEAR_DESC NO

DIMENSION TABLE

WDT_FINANCIAL_AID_YEAR

WDT_FINANCIAL_AID_YEAR

FINANCIAL_AID_YEAR_LD

FINANCIAL_AID_YEAR_SD

FINANCIAL AID APPLICATION 

FINANCIAL AID APPLICATION 

NO

NO

BUDGET_GROUP NO

DIMENSION TABLE

WDT_FINANCIAL_AID_BUDGET_GRP

FINANCIAL_AID_BUDGET_GRP

FINANCIAL AID APPLICATION 

NO

BUDGET_GROUP_DESC NO

DIMENSION TABLE

WDT_FINANCIAL_AID_BUDGET_GRP

WDT_FINANCIAL_AID_BUDGET_GRP

FINANCIAL_AID_BUDGET_GRP_LD

FINANCIAL_AID_BUDGET_GRP_SD

FINANCIAL AID APPLICATION 

FINANCIAL AID APPLICATION 

NO

NO

MULTI_SOURCE NO

DIMENSION TABLE

WDT_MULTI_SOURCE

MULTI_SOURCE

FINANCIAL AID APPLICATION 

NO

MULTI_SOURCE_DESC NO

DIMENSION TABLE

WDT_MULTI_SOURCE

WDT_MULTI_SOURCE

MULTI_SOURCE_LD

MULTI_SOURCE_SD

FINANCIAL AID APPLICATION 

FINANCIAL AID APPLICATION 

NO

NO

PACKAGE_COMPLETE_DATE NO

DIMENSION TABLE


FACT TABLE

WDT_CALENDAR_DATE

WFT_FINAID_APPLICATION

CALENDAR_DATE

PACKAGING_COMPLETE_DATE

FINANCIAL AID APPLICATION 

FINANCIAL AID APPLICATION 

NO

NO

PACKAGING_GROUP NO

DIMENSION TABLE

WDT_FINANCIAL_AID_PACKAGE_GRP

FINANCIAL_AID_PACKAGE_GRP

FINANCIAL AID APPLICATION 

NO

PACKAGING_GROUP_DESC NO

DIMENSION TABLE

WDT_FINANCIAL_AID_PACKAGE_GRP

WDT_FINANCIAL_AID_PACKAGE_GRP

FINANCIAL_AID_PACKAGE_GRP_LD

FINANCIAL_AID_PACKAGE_GRP_SD

FINANCIAL AID APPLICATION 

FINANCIAL AID APPLICATION 

NO

NO

PROCESS_GROUP NO

DIMENSION TABLE

WDT_MULTI_SOURCE

PROCESS_GROUP

FINANCIAL AID APPLICATION 

NO



Ver: 8.1