Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
AWARD_ACCEPTED_AMOUNT	Accepted amount for the financial aid award for the person for the aid year.	NUMBER	AWARD_BY_AID_YEAR	TOTAL_ACCEPT_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_ACCEPTED_DATE	Date the award was accepted by the person.	DATE	AWARD_BY_AID_YEAR	TOTAL_ACCEPT_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_AUTHORIZED_AMOUNT	Authorized amount for the financial aid award for the person for the aid year.	NUMBER	AWARD_BY_AID_YEAR	ANNUAL_AWARD_AUTHORIZE_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_AUTHORIZED_DATE	Date of the award was authorization.	DATE	AWARD_BY_AID_YEAR	ANNUAL_AWARD_AUTHORIZE_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_CANCELED_AMOUNT	Canceled amount for the financial aid award for the person for the aid year.	NUMBER	AWARD_BY_AID_YEAR	ANNUAL_AWARD_CANCEL_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_CANCELED_DATE	Date that the award was cancelled by the institution.	DATE	AWARD_BY_AID_YEAR	ANNUAL_AWARD_CANCEL_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_DECLINED_AMOUNT	Declined amount for the financial aid award for the person for the aid year.	NUMBER	AWARD_BY_AID_YEAR	TOTAL_DECLINE_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_DECLINED_DATE	Date the award was declined by the person.	DATE	AWARD_BY_AID_YEAR	TOTAL_DECLINE_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_MEMO_AMOUNT	Memo amount for the financial aid award for the person for the aid year. This amount is intended but does not yet fit into any of the other financial aid amount groupings.	NUMBER	AWARD_BY_AID_YEAR	ANNUAL_AWARD_MEMO_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_MEMO_EXPIRATION_DATE	Date the memo will expire.	DATE	AWARD_BY_AID_YEAR	ANNUAL_AWARD_MEMO_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_OFFERED_AMOUNT	Offered amount for the financial aid award for the person for the aid year.	NUMBER	AWARD_BY_AID_YEAR	OFFER_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_OFFERED_DATE	Date the award was offered to the person.	DATE	AWARD_BY_AID_YEAR	OFFER_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_ORIGINAL_OFFERED_AMOUNT	Original offered amount for the financial aid award for the person for the aid year.	NUMBER	AWARD_BY_AID_YEAR	TOTAL_OFFER_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_ORIGINAL_OFFERED_DATE	Date the original award offer was made to the person.	DATE	AWARD_BY_AID_YEAR	TOTAL_ORIGINAL_OFFER_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_PAID_AMOUNT	Paid or Disbursed amount for the financial aid award for the person for the aid year.	NUMBER	AWARD_BY_AID_YEAR	TOTAL_PAID_AMOUNT	NO	NO	FINANCIAL AID AWARD BY AID YEAR
AWARD_PAID_DATE	Date the award was paid or disbursed by the institution.	DATE	AWARD_BY_AID_YEAR	TOTAL_PAID_DATE	NO	NO	FINANCIAL AID AWARD BY AID YEAR
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
FINAID_AWARD_AIDY_GROUP_KEY	Key for the financial aid award aid year group dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_FUND_KEY	Key for the financial aid fund dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_FUND_STATUS_KEY	Key for the financial aid fund status dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_STATUS_KEY	Key for the financial aid status dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_YEAR_KEY	Key for the financial aid year dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
PERSON_UID	Key for the person dimension.	NUMBER	AWARD_BY_AID_YEAR	PERSON_UID	NO	NO	FINANCIAL AID AWARD BY AID YEAR
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY AID YEAR

Ver: 9.0