Reporting View Target: FINAID

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: FINAID_FUND

Description Contains data regarding a financial aid fund for an aid year. Details may include fund source, fund type, fund detail code, federal financial aid fund identification, need based indicator, budget allocated amount, transfer amount, prior balance, total allocated amount, original offered amounts, accepted amount, declined amount, canceled amount, authorized amount and memoed amount.
Key & Frequency One row per aid year per fund.
Recommended Search Columns AID_YEAR,��FUND
FUND

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
RFRASPC

RFRASPC_ACCEPT_AMT

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

RFRASPC_ACCEPT_NO

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

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

RFRASPC_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

AUTHORIZE_AMOUNT Authorized amount of financial aid for this fund. NUMBER
RFRASPC

RFRASPC_AUTHORIZE_AMT

AUTHORIZE_AWARDS Number of awards authorized for the fund in this aid year. NUMBER
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
RFRASPC

RFRASPC_AVAIL_OFFER_AMT

AVAILABLE_OFFER_PERCENTAGE Total allocation percentage that the institution can offer including the over-commitment amount. NUMBER
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
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
RFRASPC

RFRASPC_CANCEL_AMT

CANCEL_AWARDS Canceled amount for the financial aid award. NUMBER
RFRASPC

RFRASPC_CANCEL_NO

DECLINE_AMOUNT Total amount of this fund declined by the student's for this aid year. NUMBER
RFRASPC

RFRASPC_DECLINE_AMT

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

RFRASPC_DECLINE_NO

FEDERAL_FUND_ID Federal fund associated with the fund code. VARCHAR2(63)
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(63)
RTVFTYP

RTVFTYP_ATYP_IND

FINANCIAL_AID_TYPE_DESC Financial aid type description. VARCHAR2(255)
CALCULATION

DECODE(RTVFTYP_ATYP_IND)

FUND Unique fiscal entity code. VARCHAR2(63)
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(63)
RFRBASE

RFRBASE_DETAIL_CODE

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

RFRBASE_FSRC_CODE

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

RTVFSRC_DESC

FUND_SOURCE_TYPE Identifies the fund source type as either federal, state, institution or other. VARCHAR2(63)
RFRBASE

RFRBASE_FSRC_CODE

FUND_SOURCE_TYPE_DESC Description for the type of source for this fund. VARCHAR2(255)
RTVFSRC

RTVFSRC_DESC

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

RFRBASE_FUND_TITLE

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

RFRBASE_FTYP_CODE

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

RTVFTYP_DESC

GIFT_OR_SELF_HELP_AID Classification of an award (or fund) based on the financial aid type associated with the fund, with Gift Aid having an aid type of grant or scholarship and Self Help Aid having an aid type of loan or work. VARCHAR2(63)
CALCULATION

DECODE(RTVFTYP_ATYP_IND)

GIFT_OR_SELF_HELP_AID_DESC Description of the Gift or Self Help Aid code, where G = Gift Aid and S = Self Help Aid. VARCHAR2(255)
CALCULATION

DECODE(RTVFTYP_ATYP_IND)

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
RFRASPC

RFRASPC_MAX_AWARD_AMT

MEMO_AMOUNT Amount of memo'd awards for the f und code in the specified aid year. NUMBER
RFRASPC

RFRASPC_MEMO_AMT

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

RFRASPC_MEMO_NO

MIN_AWARD_AMOUNT Minimum award the institution wishes to offer to any one student from each specific fund. NUMBER
RFRASPC

RFRASPC_MIN_AWARD_AMT

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

NA

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

NA

NEED_ANALYSIS_IND Packaging rule that indicates if an FM need analysis record be on file for this fund to be awarded or for loan processing to occur. VARCHAR2(1)
RFRASPC

RFRASPC_NA_REQD_IND

NEED_BASED_IND Packaging rule that indicates if this fund should only be used to reduce need, in the calculation of unmet need. It is mutually exclusive from the Replace EFC indicator. 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
RFRASPC

RFRASPC_OFFER_AMT

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

RFRASPC_OFFER_NO

ORIGINAL_OFFER_AMOUNT Amount of all original awards for the fund in the specified aid year. NUMBER
RFRASPC

RFRASPC_ORIG_OFFER_AMT

ORIGINAL_OFFER_AWARDS Number of original awards for the fund in the specified aid year. NUMBER
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

OVERRIDE_NEED_TO_COA_IND Packaging rule that indicates if this fund should override need up to the cost of attendance (budget) amount. VARCHAR2(1)
RFRASPC

RFRASPC_OVERRIDE_NEED_TO_COA

OVERRIDE_UNMET_NEED_IND Packaging rule that indicates if this fund should override the validation of unmet need. VARCHAR2(1)
RFRASPC

RFRASPC_OVERRIDE_NEED_IND

PAID_AMOUNT Amount of awards paid for the fund in the specified aid year. NUMBER
RFRASPC

RFRASPC_PAID_AMT

PAID_NUMBER Number of awards paid for the fund in the specified aid year. NUMBER
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
RFRASPC

RFRASPC_PRIOR_BAL_AMT

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

NA

REPLACE_TFC_IND Packaging rule that indicates if this fund should first replace the expected total family contribution before reducing need, 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
FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

TOTAL_ALLOCATED_AMOUNT 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. Calculated field. NUMBER
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
RFRASPC

RFRASPC_TRANSFER_AMT

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

RFRBASE_VR_MSG_NO

Ver: 8.1

Description	Contains data regarding a financial aid fund for an aid year. Details may include fund source, fund type, fund detail code, federal financial aid fund identification, need based indicator, budget allocated amount, transfer amount, prior balance, total allocated amount, original offered amounts, accepted amount, declined amount, canceled amount, authorized amount and memoed amount.
Key & Frequency	One row per aid year per fund.
Recommended Search Columns	AID_YEAR,��FUND FUND

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	RFRASPC	RFRASPC_ACCEPT_AMT
ACCEPT_AWARDS	Number of awards accepted for this fund in the specified aid year.	NUMBER	RFRASPC	RFRASPC_ACCEPT_NO
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	RFRASPC	RFRASPC_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
AUTHORIZE_AMOUNT	Authorized amount of financial aid for this fund.	NUMBER	RFRASPC	RFRASPC_AUTHORIZE_AMT
AUTHORIZE_AWARDS	Number of awards authorized for the fund in this aid year.	NUMBER	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	RFRASPC	RFRASPC_AVAIL_OFFER_AMT
AVAILABLE_OFFER_PERCENTAGE	Total allocation percentage that the institution can offer including the over-commitment amount.	NUMBER	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	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	RFRASPC	RFRASPC_CANCEL_AMT
CANCEL_AWARDS	Canceled amount for the financial aid award.	NUMBER	RFRASPC	RFRASPC_CANCEL_NO
DECLINE_AMOUNT	Total amount of this fund declined by the student's for this aid year.	NUMBER	RFRASPC	RFRASPC_DECLINE_AMT
DECLINE_AWARDS	Number of awards declined for this fund code in the specified aid year.	NUMBER	RFRASPC	RFRASPC_DECLINE_NO
FEDERAL_FUND_ID	Federal fund associated with the fund code.	VARCHAR2(63)	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(63)	RTVFTYP	RTVFTYP_ATYP_IND
FINANCIAL_AID_TYPE_DESC	Financial aid type description.	VARCHAR2(255)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)
FUND	Unique fiscal entity code.	VARCHAR2(63)	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(63)	RFRBASE	RFRBASE_DETAIL_CODE
FUND_SOURCE	Fund source code to be associated with the fund code.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE
FUND_SOURCE_DESC	Describes the fund source code and identifies what it represents.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC
FUND_SOURCE_TYPE	Identifies the fund source type as either federal, state, institution or other.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE
FUND_SOURCE_TYPE_DESC	Description for the type of source for this fund.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE
FUND_TYPE	Code that classifies a fiscal entity.	VARCHAR2(63)	RFRBASE	RFRBASE_FTYP_CODE
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC
GIFT_OR_SELF_HELP_AID	Classification of an award (or fund) based on the financial aid type associated with the fund, with Gift Aid having an aid type of grant or scholarship and Self Help Aid having an aid type of loan or work.	VARCHAR2(63)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)
GIFT_OR_SELF_HELP_AID_DESC	Description of the Gift or Self Help Aid code, where G = Gift Aid and S = Self Help Aid.	VARCHAR2(255)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)
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	RFRASPC	RFRASPC_MAX_AWARD_AMT
MEMO_AMOUNT	Amount of memo'd awards for the f und code in the specified aid year.	NUMBER	RFRASPC	RFRASPC_MEMO_AMT
MEMO_AWARDS	Number of memo'd awards for the fund code in the specified aid year.	NUMBER	RFRASPC	RFRASPC_MEMO_NO
MIN_AWARD_AMOUNT	Minimum award the institution wishes to offer to any one student from each specific fund.	NUMBER	RFRASPC	RFRASPC_MIN_AWARD_AMT
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NEED_ANALYSIS_IND	Packaging rule that indicates if an FM need analysis record be on file for this fund to be awarded or for loan processing to occur.	VARCHAR2(1)	RFRASPC	RFRASPC_NA_REQD_IND
NEED_BASED_IND	Packaging rule that indicates if this fund should only be used to reduce need, in the calculation of unmet need. It is mutually exclusive from the Replace EFC indicator.	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	RFRASPC	RFRASPC_OFFER_AMT
OFFER_AWARDS	Number of awards that are currently offered for the fund in the specified aid year.	NUMBER	RFRASPC	RFRASPC_OFFER_NO
ORIGINAL_OFFER_AMOUNT	Amount of all original awards for the fund in the specified aid year.	NUMBER	RFRASPC	RFRASPC_ORIG_OFFER_AMT
ORIGINAL_OFFER_AWARDS	Number of original awards for the fund in the specified aid year.	NUMBER	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
OVERRIDE_NEED_TO_COA_IND	Packaging rule that indicates if this fund should override need up to the cost of attendance (budget) amount.	VARCHAR2(1)	RFRASPC	RFRASPC_OVERRIDE_NEED_TO_COA
OVERRIDE_UNMET_NEED_IND	Packaging rule that indicates if this fund should override the validation of unmet need.	VARCHAR2(1)	RFRASPC	RFRASPC_OVERRIDE_NEED_IND
PAID_AMOUNT	Amount of awards paid for the fund in the specified aid year.	NUMBER	RFRASPC	RFRASPC_PAID_AMT
PAID_NUMBER	Number of awards paid for the fund in the specified aid year.	NUMBER	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	RFRASPC	RFRASPC_PRIOR_BAL_AMT
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REPLACE_TFC_IND	Packaging rule that indicates if this fund should first replace the expected total family contribution before reducing need, 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	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS
TOTAL_ALLOCATED_AMOUNT	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. Calculated field.	NUMBER	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	RFRASPC	RFRASPC_TRANSFER_AMT
VOICE_RESPONSE_MSG_NO	Voice response message number assigned to the recorded message that describes the fund code.	NUMBER	RFRBASE	RFRBASE_VR_MSG_NO