Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the academic time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_ACCEPTED_AMOUNT	Accepted amount for the financial aid award for the person for an academic period within the aid year.	NUMBER	AWARD_BY_PERSON	AWARD_ACCEPT_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_ACCEPTED_DATE	Date the award was accepted by the person.	DATE	AWARD_BY_PERSON	AWARD_ACCEPT_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_AUTHORIZED_AMOUNT	Authorized amount for the financial aid award for the person for an academic period within the aid year.	NUMBER	AWARD_BY_PERSON	AWARD_AUTHORIZE_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_AUTHORIZED_DATE	Date of the award was authorization.	DATE	AWARD_BY_PERSON	AWARD_AUTHORIZE_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_CANCELED_AMOUNT	Canceled amount for the financial aid award for the person for an academic period within the aid year.	NUMBER	AWARD_BY_PERSON	AWARD_CANCEL_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_CANCELED_DATE	Date that the award was cancelled by the institution.	DATE	AWARD_BY_PERSON	AWARD_CANCEL_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_DECLINED_AMOUNT	Declined amount for the financial aid award for the person for an academic period within the aid year.	NUMBER	AWARD_BY_PERSON	AWARD_DECLINE_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_DECLINED_DATE	Date the award was declined by the person.	DATE	AWARD_BY_PERSON	AWARD_DECLINE_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_MEMO_AMOUNT	Memo amount for the financial aid award for the person for an academic period within the aid year. This amount is intended but does not yet fit into any of the other financial aid amount groupings.	NUMBER	AWARD_BY_PERSON	AWARD_MEMO_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_MEMO_EXPIRATION_DATE	Date the memo will expire.	DATE	AWARD_BY_PERSON	AWARD_MEMO_EXPIRATION_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_OFFERED_AMOUNT	Offered amount for the financial aid award for the person for an academic period within the aid year.	NUMBER	AWARD_BY_PERSON	AWARD_OFFER_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_OFFERED_DATE	Date the award was offered to the person.	DATE	AWARD_BY_PERSON	AWARD_OFFER_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_ORIGINAL_OFFERED_AMOUNT	Original offered amount for the financial aid award for the person for an academic period within the aid year.	NUMBER	AWARD_BY_PERSON	AWARD_ORIGINAL_OFFER_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_ORIGINAL_OFFERED_DATE	Date the original award offer was made to the person.	DATE	AWARD_BY_PERSON	AWARD_ORIGINAL_OFFER_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_PAID_AMOUNT	Paid or Disbursed amount for the financial aid award for the person for an academic period within the aid year.	NUMBER	AWARD_BY_PERSON	AWARD_PAID_AMOUNT	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
AWARD_PAID_DATE	Date the award was paid or disbursed by the institution.	DATE	AWARD_BY_PERSON	AWARD_PAID_DATE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINAID_AWARD_AIDY_GROUP_KEY	Key for the financial aid award aid year group key.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL_AID_FUND_KEY	Key for the financial aid fund dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL_AID_FUND_STATUS_KEY	Key for the financial aid fund status dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL_AID_STATUS_KEY	Key for the financial aid status dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL_AID_YEAR_KEY	Key for the financial aid year dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
PERSON_UID	Key for the person dimension.	NUMBER	AWARD_BY_PERSON	PERSON_UID	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD
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 ACADEMIC PERIOD
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD

Ver: 9.0