Dimension Table Target: WDT_FINANCIAL_AID

	RETURN TO DIMENSION TABLE REPORTS LIST
	Financial Aid Award By Academic Period Star Financial Aid Award By Aid Year Star Financial Aid Pre-Student Star Financial Aid Student Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FINANCIAL_AID_FUND

Description Financial Aid Fund Dimension table provides information about the financial aid fund. This information includes name of the fund, type and source of fund that will identify if the funds are considered grant, scholarship, and loan or work as well as if the funds are federal, institutional or other. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

FINANCIAL_AID_FUND_KEY Key for the fund dimension. NUMBER
ETL GENERATED
ETL_GENERATED

NA
NA

NO
NO
NO FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR

FINANCIAL_AID_SOURCE_TYPE Indicator for the financial aid source type associated with the fund code. For example, institutional, federal, state/province or other source. 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 Indicator for the financial aid fund type code used to classify the fund code. For example, scholarships, grants, loans or work (employment). 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 that represents a unique fiscal entity. This data will come from either the ODS FINAID Fund or the Award by Person reporting view as appropriate for the star scheme. VARCHAR2(63)
AWARD_BY_AID_YEAR
AWARD_BY_PERSON
FINAID_FUND

FUND
FUND
FUND

NO
NO
NO
NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_LD Identifies the long or full title of the financial aid fund code. VARCHAR2(255)
AWARD_BY_AID_YEAR
AWARD_BY_PERSON
FINAID_FUND

FUND_TITLE
FUND_TITLE
FUND_TITLE

NO
NO
NO
NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_SD Identifies a short title for the financial aid fund code. VARCHAR2(255)
AWARD_BY_AID_YEAR
AWARD_BY_PERSON
FINAID_FUND

FUND_TITLE
FUND_TITLE
FUND_TITLE

NO
NO
NO
NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_SOURCE Identifies the financial aid fund source associated with the fund code. VARCHAR2(63)
AWARD_BY_PERSON
FINAID_FUND

FUND_SOURCE
FUND_SOURCE

NO
NO
NO FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_SOURCE_LD Long description for the fund source. VARCHAR2(255)
AWARD_BY_PERSON
FINAID_FUND

FUND_SOURCE_DESC
FUND_SOURCE_DESC

NO
NO
NO FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_SOURCE_SD Short description for the fund source. VARCHAR2(255)
AWARD_BY_PERSON
FINAID_FUND

FUND_SOURCE_DESC
FUND_SOURCE_DESC

NO
NO
NO FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_TYPE Identifies the financial aid fund type code used to classify the fund code. For example, scholarships, grants, loans, employment and whether it is institutional, federal or other for grouping. VARCHAR2(63)
AWARD_BY_PERSON
FINAID_FUND

FUND_TYPE
FUND_TYPE

NO
NO
NO FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_TYPE_LD Long description for the fund type code. VARCHAR2(255)
AWARD_BY_PERSON
FINAID_FUND

FUND_TYPE_DESC
FUND_TYPE_DESC

NO
NO
NO FINANCIAL AID AWARD BY ACADEMIC PERIOD
FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT

FUND_TYPE_SD Short description for the fund type code. VARCHAR2(255)
AWARD_BY_PERSON
FINAID_FUND

FUND_TYPE_DESC
FUND_TYPE_DESC

NO
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 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
ETL_GENERATED

NA
NA

NO
NO
NO FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
ETL GENERATED
ETL_GENERATED

NA
NA

NO
NO
NO FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR

Ver: 8.1

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
FINANCIAL_AID_FUND_KEY	Key for the fund dimension.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_SOURCE_TYPE	Indicator for the financial aid source type associated with the fund code. For example, institutional, federal, state/province or other source.	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	Indicator for the financial aid fund type code used to classify the fund code. For example, scholarships, grants, loans or work (employment).	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 that represents a unique fiscal entity. This data will come from either the ODS FINAID Fund or the Award by Person reporting view as appropriate for the star scheme.	VARCHAR2(63)	AWARD_BY_AID_YEAR AWARD_BY_PERSON FINAID_FUND	FUND FUND FUND	NO NO NO	NO	FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_LD	Identifies the long or full title of the financial aid fund code.	VARCHAR2(255)	AWARD_BY_AID_YEAR AWARD_BY_PERSON FINAID_FUND	FUND_TITLE FUND_TITLE FUND_TITLE	NO NO NO	NO	FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SD	Identifies a short title for the financial aid fund code.	VARCHAR2(255)	AWARD_BY_AID_YEAR AWARD_BY_PERSON FINAID_FUND	FUND_TITLE FUND_TITLE FUND_TITLE	NO NO NO	NO	FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SOURCE	Identifies the financial aid fund source associated with the fund code.	VARCHAR2(63)	AWARD_BY_PERSON FINAID_FUND	FUND_SOURCE FUND_SOURCE	NO NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SOURCE_LD	Long description for the fund source.	VARCHAR2(255)	AWARD_BY_PERSON FINAID_FUND	FUND_SOURCE_DESC FUND_SOURCE_DESC	NO NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_SOURCE_SD	Short description for the fund source.	VARCHAR2(255)	AWARD_BY_PERSON FINAID_FUND	FUND_SOURCE_DESC FUND_SOURCE_DESC	NO NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_TYPE	Identifies the financial aid fund type code used to classify the fund code. For example, scholarships, grants, loans, employment and whether it is institutional, federal or other for grouping.	VARCHAR2(63)	AWARD_BY_PERSON FINAID_FUND	FUND_TYPE FUND_TYPE	NO NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_TYPE_LD	Long description for the fund type code.	VARCHAR2(255)	AWARD_BY_PERSON FINAID_FUND	FUND_TYPE_DESC FUND_TYPE_DESC	NO NO	NO	FINANCIAL AID AWARD BY ACADEMIC PERIOD FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT
FUND_TYPE_SD	Short description for the fund type code.	VARCHAR2(255)	AWARD_BY_PERSON FINAID_FUND	FUND_TYPE_DESC FUND_TYPE_DESC	NO 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	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 ETL_GENERATED	NA NA	NO NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR