Composite View Target: AR_FINAID

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_FINAID_FUND

Description Source composite view contains each fund with its detailed information for each aid year.

Target Column Business Definition Database Data Type Source Name Source Column

ACCEPT_AMOUNT Amount accepted by the student for the indicated financial aid fund for this aid year. NUMBER(11, 2)
RFRASPC

RFRASPC_ACCEPT_AMT

ACCEPT_AWARDS Number of awards accepted for this fund in the specified aid year. NUMBER(9)
RFRASPC

RFRASPC_ACCEPT_NO

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(4)
RFRASPC

RFRASPC_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

AUTHORIZE_AMOUNT Authorized amount of financial aid for this fund. NUMBER(11, 2)
RFRASPC

RFRASPC_AUTHORIZE_AMT

AUTHORIZE_AWARDS Number of awards authorized for the fund in this aid year. NUMBER(9)
RFRASPC

RFRASPC_AUTHORIZE_NO

AVAILABLE_OFFER_AMOUNT Offered amount for the financial aid fund including any over-commitment amount. Calculated if an available to offer percent recorded for the fund. NUMBER(11, 2)
RFRASPC

RFRASPC_AVAIL_OFFER_AMT

AVAILABLE_OFFER_PERCENTAGE Total allocation percentage that the institution can offer including the over-commitment amount. NUMBER(6, 3)
RFRASPC

RFRASPC_AVAIL_OFFER_PCT

BUDGET_ALLOCATED_AMOUNT Actual allocated budget for a fund code within the given aid year. Optional field that defaults to 0. NUMBER(11, 2)
RFRASPC

RFRASPC_BUDG_ALLOC_AMT

CANCEL_AMOUNT Total amount of this fund that was offered and or accepted by the student's and then canceled. NUMBER(11, 2)
RFRASPC

RFRASPC_CANCEL_AMT

CANCEL_AWARDS Canceled amount for the financial aid award. NUMBER(9)
RFRASPC

RFRASPC_CANCEL_NO

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE
NA

SYSDATE

DECLINE_AMOUNT Total amount of this fund declined by the student's for this aid year. NUMBER(11, 2)
RFRASPC

RFRASPC_DECLINE_AMT

DECLINE_AWARDS Number of awards declined for this fund code in the specified aid year. NUMBER(9)
RFRASPC

RFRASPC_DECLINE_NO

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)
NA

NA

FEDERAL_FUND_ID Federal fund associated with the fund code. VARCHAR2(4)
RFRBASE

RFRBASE_FED_FUND_ID

FEDERAL_GRANT_DISBURSED Financial aid award sum disbursed for the time frame with a fund source type indicator equal to federal, and a fund type indicator equal to grant. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

FEDERAL_LOAN_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to federal and a fund type indicator equal to loan. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

FEDERAL_SCHOLARSHIP_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to federal and a fund type indicator equal to scholarship. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

FEDERAL_WORK_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to federal and a fund type indicator equal to work. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

FINANCIAL_AID_TYPE Identifies the type of financial assistance as either work, loan, scholarship or grant. VARCHAR2(1)
RTVFTYP

RTVFTYP_ATYP_IND

FINANCIAL_AID_TYPE_DESC The description of the type of aid being offered. VARCHAR2(30)
CALCULATION

DECODE(RTVFTYP_ATYP_IND)

FUND Unique fiscal entity code. VARCHAR2(6)
RFRASPC

RFRASPC_FUND_CODE

FUND_DETAIL_CODE Links a financial aid fund code to an AR detail code for crediting funds to student accounts. VARCHAR2(4)
RFRBASE

RFRBASE_DETAIL_CODE

FUND_SOURCE Fund source code to be associated with the fund code. VARCHAR2(4)
RFRBASE

RFRBASE_FSRC_CODE

FUND_SOURCE_DESC Describes the fund source code and identifies what it represents. VARCHAR2(30)
RTVFSRC

RTVFSRC_DESC

FUND_SOURCE_TYPE Source of the financial aid. VARCHAR2(1)
RTVFSRC

RTVFSRC_IND

FUND_SOURCE_TYPE_DESC This is the description the source of the Financial Aid. VARCHAR2(30)
CALCULATION

DECODE(RTVFSRC_IND)

FUND_TITLE Full title of the financial aid fund code. VARCHAR2(30)
RFRBASE

RFRBASE_FUND_TITLE

FUND_TYPE Code that classifies a fiscal entity. VARCHAR2(4)
RFRBASE

RFRBASE_FTYP_CODE

FUND_TYPE_DESC Fund type code description or title. VARCHAR2(30)
RTVFTYP

RTVFTYP_DESC

INST_GRANT_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to grant. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

INST_LOAN_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to loan. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

INST_SCHOLARSHIP_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to scholarship. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

INST_WORK_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to work. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

MAX_AWARD_AMOUNT Maximum award the institution wishes to offer to any one student from a specific fund. Cannot be negative and cannot be less than the award minimum. NUMBER(11, 2)
RFRASPC

RFRASPC_MAX_AWARD_AMT

MEMO_AMOUNT Amount of memo'd awards for the f und code in the specified aid year. NUMBER(11, 2)
RFRASPC

RFRASPC_MEMO_AMT

MEMO_AWARDS Number of memo'd awards for the fund code in the specified aid year. NUMBER(9)
RFRASPC

RFRASPC_MEMO_NO

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)
NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)
NA

NA

MIN_AWARD_AMOUNT Minimum award the institution wishes to offer to any one student from each specific fund. NUMBER(11, 2)
RFRASPC

RFRASPC_MIN_AWARD_AMT

NEED_BASED_IND Indicates whether the fund is need based. VARCHAR2(1)
RFRASPC

RFRASPC_REDUCE_NEED_IND

OFFER_AMOUNT Amount of awards that have been offered for the fund in the specified aid year. NUMBER(11, 2)
RFRASPC

RFRASPC_OFFER_AMT

OFFER_AWARDS Number of awards that are currently offered for the fund in the specified aid year. NUMBER(9)
RFRASPC

RFRASPC_OFFER_NO

ORIGINAL_OFFER_AMOUNT Amount of all original awards for the fund in the specified aid year. NUMBER(11, 2)
RFRASPC

RFRASPC_ORIG_OFFER_AMT

ORIGINAL_OFFER_AWARDS Number of original awards for the fund in the specified aid year. NUMBER(9)
RFRASPC

RFRASPC_ORIG_OFFER_NO

OTHER_GRANT_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to grant. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

OTHER_LOAN_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to work. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

OTHER_SCHOLARSHIP_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to scholarship. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

OTHER_WORK_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to work. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

PAID_AMOUNT Amount of awards that have been paid for the fund in the specified aid year. NUMBER(11, 2)
RFRASPC

RFRASPC_PAID_AMT

PAID_NUMBER Number of awards that have been paid for the fund in the specified aid year. NUMBER(9)
RFRASPC

RFRASPC_PAID_NO

PRIOR_BALANCE_AMOUNT Any prior balance for the fund code from a previous aid year. Optional field with a default value of 0. NUMBER(11, 2)
RFRASPC

RFRASPC_PRIOR_BAL_AMT

REPLACE_TFC_IND Used to define whether this fund should replace the total family contribution in the calculation of unmet need. VARCHAR2(1)
RFRASPC

RFRASPC_REPLACE_TFC_IND

STATE_GRANT_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to grant. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

STATE_LOAN_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to loan. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

STATE_SCHOLARSHIP_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to scholarship. NUMBER
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

STATE_WORK_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to work. NUMBER

TOTAL_ALLOCATED_AMOUNT Calculated field displays the total available amount for the fund for the aid year. It is the sum of the prior balance; the transferred amount plus the budget allocated amount. NUMBER(11, 2)
RFRASPC

RFRASPC_TOTAL_ALLOC_AMT

TRANSFER_AMOUNT Any amount that should transfer in or transfer out of a fund that affects the total allocation for the aid year. Optional with a default value of 0. Can be negative. NUMBER(11, 2)
RFRASPC

RFRASPC_TRANSFER_AMT

VOICE_RESPONSE_MSG_NO Voice response message number assigned to the recorded message that describes the fund code. NUMBER(6)
RFRBASE

RFRBASE_VR_MSG_NO

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)
NA

NA

Ver: 8.1

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCEPT_AMOUNT	Amount accepted by the student for the indicated financial aid fund for this aid year.	NUMBER(11, 2)	RFRASPC	RFRASPC_ACCEPT_AMT
ACCEPT_AWARDS	Number of awards accepted for this fund in the specified aid year.	NUMBER(9)	RFRASPC	RFRASPC_ACCEPT_NO
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)	RFRASPC	RFRASPC_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
AUTHORIZE_AMOUNT	Authorized amount of financial aid for this fund.	NUMBER(11, 2)	RFRASPC	RFRASPC_AUTHORIZE_AMT
AUTHORIZE_AWARDS	Number of awards authorized for the fund in this aid year.	NUMBER(9)	RFRASPC	RFRASPC_AUTHORIZE_NO
AVAILABLE_OFFER_AMOUNT	Offered amount for the financial aid fund including any over-commitment amount. Calculated if an available to offer percent recorded for the fund.	NUMBER(11, 2)	RFRASPC	RFRASPC_AVAIL_OFFER_AMT
AVAILABLE_OFFER_PERCENTAGE	Total allocation percentage that the institution can offer including the over-commitment amount.	NUMBER(6, 3)	RFRASPC	RFRASPC_AVAIL_OFFER_PCT
BUDGET_ALLOCATED_AMOUNT	Actual allocated budget for a fund code within the given aid year. Optional field that defaults to 0.	NUMBER(11, 2)	RFRASPC	RFRASPC_BUDG_ALLOC_AMT
CANCEL_AMOUNT	Total amount of this fund that was offered and or accepted by the student's and then canceled.	NUMBER(11, 2)	RFRASPC	RFRASPC_CANCEL_AMT
CANCEL_AWARDS	Canceled amount for the financial aid award.	NUMBER(9)	RFRASPC	RFRASPC_CANCEL_NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DECLINE_AMOUNT	Total amount of this fund declined by the student's for this aid year.	NUMBER(11, 2)	RFRASPC	RFRASPC_DECLINE_AMT
DECLINE_AWARDS	Number of awards declined for this fund code in the specified aid year.	NUMBER(9)	RFRASPC	RFRASPC_DECLINE_NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
FEDERAL_FUND_ID	Federal fund associated with the fund code.	VARCHAR2(4)	RFRBASE	RFRBASE_FED_FUND_ID
FEDERAL_GRANT_DISBURSED	Financial aid award sum disbursed for the time frame with a fund source type indicator equal to federal, and a fund type indicator equal to grant.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
FEDERAL_LOAN_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to federal and a fund type indicator equal to loan.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
FEDERAL_SCHOLARSHIP_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to federal and a fund type indicator equal to scholarship.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
FEDERAL_WORK_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to federal and a fund type indicator equal to work.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
FINANCIAL_AID_TYPE	Identifies the type of financial assistance as either work, loan, scholarship or grant.	VARCHAR2(1)	RTVFTYP	RTVFTYP_ATYP_IND
FINANCIAL_AID_TYPE_DESC	The description of the type of aid being offered.	VARCHAR2(30)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)
FUND	Unique fiscal entity code.	VARCHAR2(6)	RFRASPC	RFRASPC_FUND_CODE
FUND_DETAIL_CODE	Links a financial aid fund code to an AR detail code for crediting funds to student accounts.	VARCHAR2(4)	RFRBASE	RFRBASE_DETAIL_CODE
FUND_SOURCE	Fund source code to be associated with the fund code.	VARCHAR2(4)	RFRBASE	RFRBASE_FSRC_CODE
FUND_SOURCE_DESC	Describes the fund source code and identifies what it represents.	VARCHAR2(30)	RTVFSRC	RTVFSRC_DESC
FUND_SOURCE_TYPE	Source of the financial aid.	VARCHAR2(1)	RTVFSRC	RTVFSRC_IND
FUND_SOURCE_TYPE_DESC	This is the description the source of the Financial Aid.	VARCHAR2(30)	CALCULATION	DECODE(RTVFSRC_IND)
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(30)	RFRBASE	RFRBASE_FUND_TITLE
FUND_TYPE	Code that classifies a fiscal entity.	VARCHAR2(4)	RFRBASE	RFRBASE_FTYP_CODE
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(30)	RTVFTYP	RTVFTYP_DESC
INST_GRANT_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to grant.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
INST_LOAN_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to loan.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
INST_SCHOLARSHIP_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to scholarship.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
INST_WORK_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to work.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
MAX_AWARD_AMOUNT	Maximum award the institution wishes to offer to any one student from a specific fund. Cannot be negative and cannot be less than the award minimum.	NUMBER(11, 2)	RFRASPC	RFRASPC_MAX_AWARD_AMT
MEMO_AMOUNT	Amount of memo'd awards for the f und code in the specified aid year.	NUMBER(11, 2)	RFRASPC	RFRASPC_MEMO_AMT
MEMO_AWARDS	Number of memo'd awards for the fund code in the specified aid year.	NUMBER(9)	RFRASPC	RFRASPC_MEMO_NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
MIN_AWARD_AMOUNT	Minimum award the institution wishes to offer to any one student from each specific fund.	NUMBER(11, 2)	RFRASPC	RFRASPC_MIN_AWARD_AMT
NEED_BASED_IND	Indicates whether the fund is need based.	VARCHAR2(1)	RFRASPC	RFRASPC_REDUCE_NEED_IND
OFFER_AMOUNT	Amount of awards that have been offered for the fund in the specified aid year.	NUMBER(11, 2)	RFRASPC	RFRASPC_OFFER_AMT
OFFER_AWARDS	Number of awards that are currently offered for the fund in the specified aid year.	NUMBER(9)	RFRASPC	RFRASPC_OFFER_NO
ORIGINAL_OFFER_AMOUNT	Amount of all original awards for the fund in the specified aid year.	NUMBER(11, 2)	RFRASPC	RFRASPC_ORIG_OFFER_AMT
ORIGINAL_OFFER_AWARDS	Number of original awards for the fund in the specified aid year.	NUMBER(9)	RFRASPC	RFRASPC_ORIG_OFFER_NO
OTHER_GRANT_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to grant.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
OTHER_LOAN_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to work.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
OTHER_SCHOLARSHIP_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to scholarship.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
OTHER_WORK_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to work.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
PAID_AMOUNT	Amount of awards that have been paid for the fund in the specified aid year.	NUMBER(11, 2)	RFRASPC	RFRASPC_PAID_AMT
PAID_NUMBER	Number of awards that have been paid for the fund in the specified aid year.	NUMBER(9)	RFRASPC	RFRASPC_PAID_NO
PRIOR_BALANCE_AMOUNT	Any prior balance for the fund code from a previous aid year. Optional field with a default value of 0.	NUMBER(11, 2)	RFRASPC	RFRASPC_PRIOR_BAL_AMT
REPLACE_TFC_IND	Used to define whether this fund should replace the total family contribution in the calculation of unmet need.	VARCHAR2(1)	RFRASPC	RFRASPC_REPLACE_TFC_IND
STATE_GRANT_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to grant.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
STATE_LOAN_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to loan.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
STATE_SCHOLARSHIP_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to scholarship.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
STATE_WORK_DISBURSED	Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to work.	NUMBER
TOTAL_ALLOCATED_AMOUNT	Calculated field displays the total available amount for the fund for the aid year. It is the sum of the prior balance; the transferred amount plus the budget allocated amount.	NUMBER(11, 2)	RFRASPC	RFRASPC_TOTAL_ALLOC_AMT
TRANSFER_AMOUNT	Any amount that should transfer in or transfer out of a fund that affects the total allocation for the aid year. Optional with a default value of 0. Can be negative.	NUMBER(11, 2)	RFRASPC	RFRASPC_TRANSFER_AMT
VOICE_RESPONSE_MSG_NO	Voice response message number assigned to the recorded message that describes the fund code.	NUMBER(6)	RFRBASE	RFRBASE_VR_MSG_NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA