Banner EDW Source: WFT_FINAID_APPLICATION

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
FM_GROSS_NEED	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	FM_GROSS_NEED	STUDENT PROGRESS	NO
FM_TOTAL_FAMILY_INCOME	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	FM_TOTAL_FAMILY_INCOME	STUDENT PROGRESS	NO
FM_UNMET_NEED	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	FM_UNMET_NEED	STUDENT PROGRESS	NO
IM_GROSS_NEED	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	IM_GROSS_NEED	STUDENT PROGRESS	NO
IM_TOTAL_FAMILY_INCOME	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	IM_TOTAL_FAMILY_INCOME	STUDENT PROGRESS	NO
IM_UNMET_NEED	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	IM_UNMET_NEED	STUDENT PROGRESS	NO
TOTAL_FEDERAL_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_FEDERAL_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_GIFT_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_GIFT_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_GRANT_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_GRANT_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_INSTITUTION_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_INSTITUTION_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_INST_GIFT_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_INST_GIFT_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_LOAN_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_LOAN_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_ORIGINAL_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_ORIGINAL_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_OTHER_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_OTHER_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_SCHOLARSHIP_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_SCHOLARSHIP_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_SELF_HELP_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_SELF_HELP_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_STATE_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_STATE_OFFER_AMOUNT	STUDENT PROGRESS	NO
TOTAL_WORK_OFFER_AMOUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_WORK_OFFER_AMOUNT	STUDENT PROGRESS	NO

Ver: 9.0