Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_STUDY_KEY	Key for the academic study dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT
AGE	Calculated by a function that subtracts the birth date from the load date.	NUMBER	CALCULATION	FUNCTION	NO	NO	FINANCIAL AID STUDENT
AWARD_ACCEPTED_AMOUNT	Displays the amount of awards that have been accepted.	NUMBER	AWARD_BY_PERSON	AWARD_ACCEPT_AMOUNT	NO	NO	FINANCIAL AID STUDENT
AWARD_AUTHORIZED_AMOUNT	Displays the amount of awards that are authorized.	NUMBER	AWARD_BY_PERSON	AWARD_AUTHORIZE_AMOUNT	NO	NO	FINANCIAL AID STUDENT
AWARD_CANCELED_AMOUNT	Displays the amount of the cancelled award.	NUMBER	AWARD_BY_PERSON	AWARD_CANCEL_AMOUNT	NO	NO	FINANCIAL AID STUDENT
AWARD_DECLINED_AMOUNT	Displays the amount of awards that have been declined.	NUMBER	AWARD_BY_PERSON	AWARD_DECLINE_AMOUNT	NO	NO	FINANCIAL AID STUDENT
AWARD_OFFERED_AMOUNT	Displays the amount of all original awards for the FUND in the specified aid year.	NUMBER	AWARD_BY_PERSON	AWARD_OFFER_AMOUNT	NO	NO	FINANCIAL AID STUDENT
AWARD_PAID_AMOUNT	Displays the amount of awards that have been paid for the FUND for the time dimension.	NUMBER	AWARD_BY_PERSON	AWARD_PAID_AMOUNT	NO	NO	FINANCIAL AID STUDENT
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT
ENROLLMENT_STATUS_KEY	Key for enrollment status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT
FAMILY_INCOME	Student's family income as recorded in the ODS.	NUMBER	NEED_ANALYSIS	FM_TOTAL_INCOME	NO	NO	FINANCIAL AID STUDENT
FINANCIAL_AID_FUND_KEY	Key for the financial aid fund dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT
PERSON_UID	System internally generated ID to uniquely identify the person.	NUMBER	PERSON	PERSON_UID	NO	NO	FINANCIAL AID STUDENT
STUDENT_KEY	Key for the Student dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT
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 STUDENT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID STUDENT

Ver: 9.0