Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
COST_OF_ATTENDANCE	Cost of attendance used in the aid applicant's need calculation.	NUMBER	APPLICANT_NEED	COST_OF_EDUCATION	NO	NO	FINANCIAL AID APPLICATION
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FINAID_APPLICATION_GROUP_KEY	Finaid Application Group KEY.	NUMBER				NO
FINAID_AWARD_AIDY_GROUP_KEY	Key for the financial aid award aid year group dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FINANCIAL_AID_BUDGET_GRP_KEY	Key for the financial aid budget group dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FINANCIAL_AID_PACKAGE_GRP_KEY	Key for the financial aid package group dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FINANCIAL_AID_PERIOD_KEY	Key for the financial aid period dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FINANCIAL_AID_STATUS_KEY	Key for the financial aid status dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FINANCIAL_AID_YEAR_KEY	Key for the financial aid year dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FM_BATCH_LOCK_IND	Indicates whether the FM batch process is locked.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FM_EXPECT_FAMILY_CONTRIBUTION	Expected family contribution or total amount the family can contribution as calculated by the federal methodology.	NUMBER	APPLICANT_NEED	FM_TFC	NO	NO	FINANCIAL AID APPLICATION
FM_GROSS_NEED	Gross need of the applicant defined as budget minus total family contribution using the federal methodology.	NUMBER	APPLICANT_NEED	FM_GROSS_NEED	NO	NO	FINANCIAL AID APPLICATION
FM_PARENT_CONTRIBUTION	Primary parent contribution as calculated by the federal methodology.	NUMBER	NEED_ANALYSIS	FM_PARENT_INAS	NO	NO	FINANCIAL AID APPLICATION
FM_PARENT_INCOME	Parent income as calculated using the federal methodology.	NUMBER	NEED_ANALYSIS_FEDERAL_METHOD	FM_PARENT_TOTAL_INCOME	NO	NO	FINANCIAL AID APPLICATION
FM_STUDENT_CONTRIBUTION	Student contribution as calculated by the federal methodology.	NUMBER	NEED_ANALYSIS	FM_INAS	NO	NO	FINANCIAL AID APPLICATION
FM_STUDENT_INCOME	Student income as calculated using the federal methodology.	NUMBER	NEED_ANALYSIS	FM_TOTAL_INCOME	NO	NO	FINANCIAL AID APPLICATION
FM_TOTAL_FAMILY_INCOME	Total family income as calculated using the federal methodology.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
FM_UNMET_NEED	Student's federal methodology calculated unmet need (gross need minus total offered awards).	NUMBER	APPLICANT_NEED	FM_UNMET_NEED	NO	NO	FINANCIAL AID APPLICATION
IM_BATCH_LOCK_IND	Indicates whether the IM batch process is locked.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
IM_CUSTODIAL_PARENT_INCOME	Custodial parent income as calculated using the institution methodology.	NUMBER	NEED_ANALYSIS	IM_PARENT_TOTAL_INCOME	NO	NO	FINANCIAL AID APPLICATION
IM_EXPECT_FAMILY_CONTRIBUTION	Expected family contribution or total amount the family can contribution as calculated by the institution methodology.	NUMBER	APPLICANT_NEED	IM_TFC	NO	NO	FINANCIAL AID APPLICATION
IM_GROSS_NEED	Gross need of the applicant defined as budget minus total family contribution using the institution methodology.	NUMBER	APPLICANT_NEED	IM_GROSS_NEED	NO	NO	FINANCIAL AID APPLICATION
IM_NON_CUSTODIAL_INCOME_IND	Indicates non custodial parent income exists and was used in total parent/family income calculations using the institution methodology.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
IM_NON_CUSTODIAL_PARENT_INCOME	Non custodial parent income as calculated using the institution methodology.	NUMBER	NEED_ANALYSIS	IM_PARENT_TOTAL_INCOME	NO	NO	FINANCIAL AID APPLICATION
IM_PARENT_CONTRIBUTION	Primary parent contribution as calculated by the institution methodology.	NUMBER	NEED_ANALYSIS	IM_PARENT_CONTRIBUTION	NO	NO	FINANCIAL AID APPLICATION
IM_PARENT_HOME_EQUITY	Home equity used in the parent's Institutional Method calculation.	NUMBER	NEED_ANALYSIS_INST_METHOD	IM_PARENT_HOME_EQUITY	NO	NO	FINANCIAL AID APPLICATION
IM_PARENT_INCOME	Total parent income as calculated using the institution methodology.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
IM_STUDENT_CONTRIBUTION	Student contribution as calculated by the institution methodology.	NUMBER	NEED_ANALYSIS	IM_CONTRIBUTION	NO	NO	FINANCIAL AID APPLICATION
IM_STUDENT_INCOME	Student income as calculated using the institution methodology.	NUMBER	NEED_ANALYSIS	IM_TOTAL_INCOME	NO	NO	FINANCIAL AID APPLICATION
IM_TOTAL_FAMILY_INCOME	Total family income as calculated using the institution methodology.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
IM_UNMET_NEED	Student's institution methodology calculated unmet need (gross need minus total offered awards).	NUMBER	APPLICANT_NEED	IM_UNMET_NEED	NO	NO	FINANCIAL AID APPLICATION
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
OTHER_RESOURCE_IND	Indicates whether the person has any outside resources available.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
PACKAGING_COMPLETE_DATE	Date the student's financial aid package was last processed.	DATE	FINAID_APPLICANT_STATUS	PACKAGE_COMPLETE_DATE	NO	NO	FINANCIAL AID APPLICATION
PACKAGING_COMPLETE_IND	Indicates that the student's financial aid package has been processed because the complete date is recorded.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
PERSON_UID	Key for the person dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
RESOURCE_AMOUNT	Total amount of outside resources used in the aid applicant's need calculation.	NUMBER	APPLICANT_NEED	RESOURCE_AMOUNT	NO	NO	FINANCIAL AID APPLICATION
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 APPLICATION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_FEDERAL_OFFER_AMOUNT	Total offered amount identified with an aid source of Federal Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_GIFT_OFFER_AMOUNT	Total offered amount that is identified as Gift Aid meaning it has an aid type of Grant or Scholarship.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_GRANT_OFFER_AMOUNT	Total offered amount identified with an aid type of Grant Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_INSTITUTION_OFFER_AMOUNT	Total offered amount identified with an aid source of Institutional Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_INST_GIFT_OFFER_AMOUNT	Total offered amount that is identified with an aid source of Institutional and an aid type of either Grant or Scholarship.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_LOAN_OFFER_AMOUNT	Total offered amount identified with an aid type of Loan Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_OFFER_AMOUNT	Total amount of all awards offered to the aid applicant in this aid year.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_ORIGINAL_OFFER_AMOUNT	Total original amount of all awards offered to the aid applicant in this aid year.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_OTHER_OFFER_AMOUNT	Total offered amount identified with an aid source of Other Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_SCHOLARSHIP_OFFER_AMOUNT	Total offered amount identified with an aid type of Scholarship Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_SELF_HELP_OFFER_AMOUNT	Total offered amount that is identified as Self Help Aid meaning it has an aid type of Loan or Work.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_STATE_OFFER_AMOUNT	Total offered amount identified with an aid source of State Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TOTAL_WORK_OFFER_AMOUNT	Total offered amount identified with an aid type of Work Aid.	NUMBER	ETL_GENERATED	NA	NO	NO	FINANCIAL AID APPLICATION
TUITION_FEE_BUDGET_AMOUNT	Amount that represents the tuition and fee budget component.	NUMBER	FINAID_BUDGET_COMPONENT	BUDGET_COMPONENT_AMOUNT	NO	NO	FINANCIAL AID APPLICATION

Ver: 9.0