Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
FINANCIAL_AID_FUND_KEY	Key for the financial aid fund dimension.	NUMBER	ETL GENERATED	NA	NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL_AID_SOURCE_TYPE	Aid fund source code defined as one of the following federal, institution, state or other for the aid fund.	VARCHAR2(63)	FINAID_FUND	FUND_SOURCE_TYPE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL_AID_SOURCE_TYPE_LD	Long description for the fund source type.	VARCHAR2(255)	FINAID_FUND	FUND_SOURCE_TYPE_DESC	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL_AID_SOURCE_TYPE_SD	Short description for the fund source type.	VARCHAR2(255)	FINAID_FUND	FUND_SOURCE_TYPE_DESC	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL_AID_TYPE	Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund.	VARCHAR2(63)	FINAID_FUND	FINANCIAL_AID_TYPE	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL_AID_TYPE_LD	Long description for the fund type code.	VARCHAR2(255)	FINAID_FUND	FINANCIAL_AID_TYPE_DESC	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL_AID_TYPE_SD	Short description for the fund type code.	VARCHAR2(255)	FINAID_FUND	FINANCIAL_AID_TYPE_DESC	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	FINAID_FUND	FUND	NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_LD	Long name for the financial aid fund code.	VARCHAR2(255)	FINAID_FUND	FUND_TITLE	NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SD	Short name for the financial aid fund code.	VARCHAR2(255)	FINAID_FUND	FUND_TITLE	NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SOURCE	Fund source code to be associated with the fund as defined by the institution.	VARCHAR2(63)	FINAID_FUND	FUND_SOURCE	NO	NO	FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SOURCE_LD	Long description for the institution's fund source.	VARCHAR2(255)	FINAID_FUND	FUND_SOURCE_DESC	NO	NO	FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SOURCE_SD	Short description for the institution's fund source.	VARCHAR2(255)	FINAID_FUND	FUND_SOURCE_DESC	NO	NO	FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_TYPE	Fund type code to be associated with the fund as defined by the institution.	VARCHAR2(63)	FINAID_FUND	FUND_TYPE	NO	NO	FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_TYPE_LD	Long description for the institution's fund type.	VARCHAR2(255)	FINAID_FUND	FUND_TYPE_DESC	NO	NO	FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_TYPE_SD	Short description for the institution's fund type.	VARCHAR2(255)	FINAID_FUND	FUND_TYPE_DESC	NO	NO	FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
GIFT_OR_SELF_HELP_AID	Defines whether this fund is gift or self help aid.	VARCHAR2(63)	FINAID_FUND	GIFT_OR_SELF_HELP_AID	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
GIFT_OR_SELF_HELP_AID_LD	Long description for the gift or self help aid.	VARCHAR2(255)	FINAID_FUND	GIFT_OR_SELF_HELP_AID_DESC	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
GIFT_OR_SELF_HELP_AID_SD	Short description for the gift or self help aid.	VARCHAR2(255)	FINAID_FUND	GIFT_OR_SELF_HELP_AID_DESC	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
NEED_ANALYSIS_IND	This indicator defines whether this fund requires that a need analysis record be on file for this fund to be awarded or for loan processing to occur.	VARCHAR2(63)	FINAID_FUND	NEED_ANALYSIS_IND	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
OVERRIDE_NEED_TO_COA_IND	Fund level override indicator to allow need to be overridden up to the cost of attendance (budget) amount.	VARCHAR2(63)	FINAID_FUND	OVERRIDE_NEED_TO_COA_IND	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
OVERRIDE_UNMET_NEED_IND	Override the validation of unmet need if this indicator is set.	VARCHAR2(63)	FINAID_FUND	OVERRIDE_UNMET_NEED_IND	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
REDUCE_NEED_IND	Indicates whether the fund is need based.	VARCHAR2(63)	FINAID_FUND	NEED_BASED_IND	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
REPLACE_EFC_IND	Defines whether this fund should replace the total family contribution in the calculation of unmet need.	VARCHAR2(63)	FINAID_FUND	REPLACE_TFC_IND	NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, 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 PRE STUDENT, FINANCIAL AID STUDENT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

Ver: 9.0