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

SGHE Enterprise Data Warehouse Banner EDW Source: NEED_ANALYSIS - NULL

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

FACT TABLE

WFT_FINAID_APPLICATION

FM_STUDENT_CONTRIBUTION

FINANCIAL AID APPLICATION 

NO

FM_PARENT_INAS NO

FACT TABLE

WFT_FINAID_APPLICATION

FM_PARENT_CONTRIBUTION

FINANCIAL AID APPLICATION 

NO

FM_TOTAL_INCOME NO

FACT TABLE

WFT_FINAID_APPLICATION

WFT_FINANCIAL_AID_STUDENT

WFT_FINANCIAL_AID_PRE_STUDENT

FM_STUDENT_INCOME

FAMILY_INCOME

FAMILY_INCOME

FINANCIAL AID APPLICATION 

FINANCIAL AID STUDENT 

FINANCIAL AID PRE STUDENT 

NO

NO

NO

IM_CONTRIBUTION NO

FACT TABLE

WFT_FINAID_APPLICATION

IM_STUDENT_CONTRIBUTION

FINANCIAL AID APPLICATION 

NO

IM_PARENT_CONTRIBUTION NO

FACT TABLE

WFT_FINAID_APPLICATION

IM_PARENT_CONTRIBUTION

FINANCIAL AID APPLICATION 

NO

IM_PARENT_TOTAL_INCOME NO

FACT TABLE

WFT_FINAID_APPLICATION

WFT_FINAID_APPLICATION

IM_CUSTODIAL_PARENT_INCOME

IM_NON_CUSTODIAL_PARENT_INCOME

FINANCIAL AID APPLICATION 

FINANCIAL AID APPLICATION 

NO

NO

IM_TOTAL_INCOME NO

FACT TABLE

WFT_FINAID_APPLICATION

IM_STUDENT_INCOME

FINANCIAL AID APPLICATION 

NO



Ver: 9.0