Banner EDW Source: AWARD_BY_AID_YEAR

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

**SGHE Enterprise Data Warehouse**
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 AWARD BY AID YEAR	NO
AID_YEAR	NO	DIMENSION TABLE	WDT_FINANCIAL_AID_YEAR	FINANCIAL_AID_YEAR	FINANCIAL AID AWARD BY AID YEAR	NO
AID_YEAR_DESC	NO	DIMENSION TABLE	WDT_FINANCIAL_AID_YEAR WDT_FINANCIAL_AID_YEAR	FINANCIAL_AID_YEAR_SD FINANCIAL_AID_YEAR_LD	FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY AID YEAR	NO NO
ANNUAL_AWARD_AUTHORIZE_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_AUTHORIZED_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
ANNUAL_AWARD_AUTHORIZE_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_AUTHORIZED_DATE	FINANCIAL AID AWARD BY AID YEAR	NO
ANNUAL_AWARD_CANCEL_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_CANCELED_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
ANNUAL_AWARD_CANCEL_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_CANCELED_DATE	FINANCIAL AID AWARD BY AID YEAR	NO
ANNUAL_AWARD_MEMO_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_MEMO_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
ANNUAL_AWARD_MEMO_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_MEMO_EXPIRATION_DATE	FINANCIAL AID AWARD BY AID YEAR	NO
FUND	NO	DIMENSION TABLE	WDT_FINANCIAL_AID_FUND	FUND	FINANCIAL AID AWARD BY AID YEAR	NO
FUND_TITLE	NO	DIMENSION TABLE	WDT_FINANCIAL_AID_FUND WDT_FINANCIAL_AID_FUND	FUND_LD FUND_SD	FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY AID YEAR	NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	FINANCIAL AID AWARD BY AID YEAR	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_LD MULTI_SOURCE_SD	FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY AID YEAR	NO NO
OFFER_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_OFFERED_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
OFFER_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_OFFERED_DATE	FINANCIAL AID AWARD BY AID YEAR	NO
PERSON_UID	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	PERSON_UID	FINANCIAL AID AWARD BY AID YEAR	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_ACCEPT_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_ACCEPTED_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_ACCEPT_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_ACCEPTED_DATE	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_DECLINE_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_DECLINED_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_DECLINE_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_DECLINED_DATE	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_OFFER_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_ORIGINAL_OFFERED_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_ORIGINAL_OFFER_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_ORIGINAL_OFFERED_DATE	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_PAID_AMOUNT	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_PAID_AMOUNT	FINANCIAL AID AWARD BY AID YEAR	NO
TOTAL_PAID_DATE	NO	FACT TABLE	WFT_FINAID_AWARD_AID_YEAR	AWARD_PAID_DATE	FINANCIAL AID AWARD BY AID YEAR	NO

Ver: 9.0