| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACCEPT_AMOUNT
|
Accept Amount
|
Amount accepted by the student for the indicated financial aid fund for this aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_ACCEPT_AMT
|
|
ACCEPT_AWARDS
|
Accept Awards
|
Number of awards accepted for this fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_ACCEPT_NO
|
|
ACCEPT_AWARD_STATUS
|
Accept Award Status
|
Fund's accepted award status.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_ACCEPT_AWST_CODE
|
|
ACCEPT_AWARD_STATUS_DESC
|
Accept Award Status Description
|
Accept award status description.
|
VARCHAR2(255)
|
RTVAWST
|
RTVAWST_DESC
|
|
ACG_GRADE_LEVEL
|
Acg Grade Level
|
Indicates the ACG Grant year funding level.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_ACG_YEAR
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AID_YEAR
|
Aid Year
|
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_AIDY_CODE
|
|
AID_YEAR_DESC
|
Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
AUTHORIZE_AMOUNT
|
Authorize Amount
|
Authorized amount of financial aid for this fund.
|
NUMBER
|
RFRASPC
|
RFRASPC_AUTHORIZE_AMT
|
|
AUTHORIZE_AWARDS
|
Authorize Awards
|
Number of awards authorized for the fund in this aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_AUTHORIZE_NO
|
|
AUTOMATIC_PACKAGE_IND
|
Automatic Package Indicator
|
Indicates whether the fund should be used in automatic packaging.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_AUTO_PACK_IND
|
|
AVAILABLE_OFFER_AMOUNT
|
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
|
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
|
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
|
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
|
Cancel Awards
|
Canceled amount for the financial aid award.
|
NUMBER
|
RFRASPC
|
RFRASPC_CANCEL_NO
|
|
CANCEL_AWARD_STATUS
|
Cancel Award Status
|
Fund's canceled award status.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_CANCEL_AWST_CODE
|
|
CANCEL_AWARD_STATUS_DESC
|
Cancel Award Status Description
|
Cancel award status description.
|
VARCHAR2(255)
|
RTVAWST
|
RTVAWST_DESC
|
|
DECLINE_AMOUNT
|
Decline Amount
|
Total amount of this fund declined by the student's for this aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_DECLINE_AMT
|
|
DECLINE_AWARDS
|
Decline Awards
|
Number of awards declined for this fund code in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_DECLINE_NO
|
|
DECLINE_AWARD_STATUS
|
Decline Award Status
|
Fund's declined award status.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_DECLINE_AWST_CODE
|
|
DECLINE_AWARD_STATUS_DESC
|
Decline Award Status Description
|
Decline award status description.
|
VARCHAR2(255)
|
RTVAWST
|
RTVAWST_DESC
|
|
DIRECT_LOAN_TYPE
|
Direct Loan Type
|
Identifies the direct loan type for the fund when applicable.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_DIRECT_LOAN_IND
|
|
DIRECT_LOAN_TYPE_DESC
|
Direct Loan Type Description
|
Direct loan type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN RFRASPC_DIRECT_LOAN_IND
|
|
ELECTRONIC_LOAN_TYPE
|
Electronic Loan Type
|
Identifies the electronic loan type for the fund when applicable.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_EL_IND
|
|
ELECTRONIC_LOAN_TYPE_DESC
|
Electronic Loan Type Description
|
Electronic loan type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN RFRASPC_EL_LOAN_IND
|
|
EQUITY_PACKAGE_IND
|
Equity Package Indicator
|
Indicates whether the fund should be considered in EQUITY packaging.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_EQUITY_IND
|
|
EXTERNAL_REFERENCE_VALUE
|
External Reference Value
|
User-defined field that enables you to cross reference IDs used for funds by another office.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_XREF_VALUE
|
|
FEDERAL_FUND_ID
|
Federal Fund ID
|
Federal fund associated with the fund code.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_FED_FUND_ID
|
|
FEDERAL_GRANT_DISBURSED
|
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
|
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
|
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
|
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
|
|
FINAID_ENROLLMENT_RULE
|
Financial Aid Enrollment Rule
|
Enrollment rule used to disburse the fund.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_ENRR_CODE
|
|
FINAID_ENROLLMENT_RULE_DESC
|
Financial Aid Enrollment Rule Description
|
Financial Aid enrollment rule code description.
|
VARCHAR2(255)
|
RTVENRR
|
RTVENRR_DESC
|
|
FINAID_FUND_ACTIVITY_DATE
|
Financial Aid Fund Activity Date
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
RFRASPC
|
RFRASPC_ACTIVITY_DATE
|
|
FINAID_FUND_USER_ID
|
Financial Aid Fund User ID
|
Unique identification code of the user who entered or last touched the record.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_USER_ID
|
|
FINANCIAL_AID_TYPE
|
Financial Aid Type
|
Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund.
|
VARCHAR2(63)
|
RTVFTYP
|
RTVFTYP_ATYP_IND
|
|
FINANCIAL_AID_TYPE_DESC
|
Financial Aid Type Description
|
Financial aid type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RTVFTYP_ATYP_IND)
|
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_FUND_CODE
|
|
FUND_DETAIL_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_DETAIL_CODE_DESC
|
Fund Detail Code Description
|
Detail code description.
|
VARCHAR2(255)
|
TBBDETC
|
TBBDETC_DESC
|
|
FUND_LONG_TITLE
|
Fund Long Title
|
Full description of the fund code.
|
VARCHAR2(255)
|
RFRBASE
|
RFRBASE_FUND_TITLE_LONG
|
|
FUND_PERIOD_ENABLED_IND
|
Fund Period Enabled Indicator
|
Determines whether the fund is enabled for aid enrollment period awarding.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_ENABLE_PERIOD_AWARDING
|
|
FUND_SOURCE
|
Fund Source
|
Fund source code to be associated with the fund as defined by the institution.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_FSRC_CODE
|
|
FUND_SOURCE_DESC
|
Fund Source Description
|
Describes the fund source code and identifies what it represents.
|
VARCHAR2(255)
|
RTVFSRC
|
RTVFSRC_DESC
|
|
FUND_SOURCE_TYPE
|
Fund Source Type
|
Identifies the fund source type as either federal, state, institution or other.
|
VARCHAR2(63)
|
RTVFSRC
|
RTVFSRC_IND
|
|
FUND_SOURCE_TYPE_DESC
|
Fund Source Type Description
|
Description for the type of source for this fund.
|
VARCHAR2(255)
|
RTVFSRC
|
RTVFSRC_DESC
|
|
FUND_TITLE
|
Fund Title
|
Full title of the financial aid fund code.
|
VARCHAR2(255)
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
|
FUND_TYPE
|
Fund Type
|
Fund type code to be associated with the fund as defined by the institution.
|
VARCHAR2(63)
|
RTVFTYP
|
RTVFTYP_ATYP_IND
|
|
FUND_TYPE_DESC
|
Fund Type Description
|
Fund type code description or title.
|
VARCHAR2(255)
|
RTVFTYP
|
RTVFTYP_DESC
|
|
GIFT_OR_SELF_HELP_AID
|
Gift or Self Help Indicator
|
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
|
Gift or Self Help Aid Indicator Description
|
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
|
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
|
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
|
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
|
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
|
|
LOAN_FEE_PERCENT
|
Loan Fee Percent
|
Loan fee percentage. Starting with 1516 aid year, this field is only used for Electronic and Manual Loan processing.
|
NUMBER
|
RFRASPC
|
RFRASPC_LOAN_FEE_PCT
|
|
LOAN_SOURCE
|
Loan Source
|
Identifies the fund's packaging rule source as either a direct loan, electronic loan, manual loan or other type of loan.
|
VARCHAR2(63)
|
CALCULATION
|
CASE WHEN RFRASPC_DIRECT_LOAN_IND
|
|
LOAN_SOURCE_DESC
|
Loan Source Description
|
Loan source description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN RFRASPC_DIRECT_LOAN_IND
|
|
MANUAL_LOAN_TYPE
|
Manual Loan Type
|
Identifies the manual loan type for the fund when applicable.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_MANUAL_LOAN_IND
|
|
MANUAL_LOAN_TYPE_DESC
|
Manual Loan Type Description
|
Manual loan type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN RFRASPC_MANUAL_LOAN_IND
|
|
MAX_AWARD_AMOUNT
|
Maximum 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
|
Memo Amount
|
Amount of memo'd awards for the f und code in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_MEMO_AMT
|
|
MEMO_AWARDS
|
Memo Awards
|
Number of memo'd awards for the fund code in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_MEMO_NO
|
|
MEMO_AWARD_ALLOWED
|
Memo Award Allowed
|
Indicates whether the fund can be carried as a credit memo based on fund award status. Valid values include (N)one, (A)ccepted, (O)ffered.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_APPL_MEMO_IND
|
|
MEMO_AWARD_ALLOWED_DESC
|
Memo Award Allowed Description
|
Application memo indicator description.
|
VARCHAR2(255)
|
CALCULATION
|
SELECT RORMVAL_DESC FROM RORMVAL WHERE RORMVAL_COLUMN = 'RFRASPC_APPL_MEMO_IND' AND RORMVAL_CODE = RFRASPC_APPL_MEMO_IND
|
|
MIN_AWARD_AMOUNT
|
Minimum Award Amount
|
Minimum award the institution wishes to offer to any one student from each specific fund.
|
NUMBER
|
RFRASPC
|
RFRASPC_MIN_AWARD_AMT
|
|
MIX_ACCEPT_AWARD_STATUS
|
Mix Accept Award Status
|
Fund's accepted award status when aid enrollment periods statuses are not the same value.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_MIX_ACCEPT_AWST_CODE
|
|
MIX_ACCEPT_AWARD_STATUS_DESC
|
Mix Accept Award Status Description
|
Mix accept award status description.
|
VARCHAR2(255)
|
RTVAWST
|
RTVAWST_DESC
|
|
MIX_DECLINE_AWARD_STATUS
|
Mix Decline Award Status
|
Fund's declined award status when aid enrollment periods statuses are not the same value.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_MIX_DECLINE_AWST_CODE
|
|
MIX_DECLINE_AWARD_STATUS_DESC
|
Mix Decline Award Status Description
|
Mix decline award status description.
|
VARCHAR2(255)
|
RTVAWST
|
RTVAWST_DESC
|
|
MIX_OFFER_AWARD_STATUS
|
Mix Offer Award Status
|
Fund's offered award status when aid enrollment periods statuses are not the same value.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_MIX_OFFER_AWST_CODE
|
|
MIX_OFFER_AWARD_STATUS_DESC
|
Mix Offer Award Status Description
|
Mix offer award status description.
|
VARCHAR2(255)
|
RTVAWST
|
RTVAWST_DESC
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NEED_ANALYSIS_IND
|
Need Analysis Indicator
|
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
|
Need Based Indicator
|
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
|
Offer Amount
|
Amount of awards that have been offered for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_OFFER_AMT
|
|
OFFER_AWARDS
|
Offer Awards
|
Number of awards that are currently offered for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_OFFER_NO
|
|
OFFER_AWARD_STATUS
|
Offer Award Status
|
Fund's offered award status.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_OFFER_AWST_CODE
|
|
OFFER_AWARD_STATUS_DESC
|
Offer Award Status Description
|
Offer award status description.
|
VARCHAR2(255)
|
RTVAWST
|
RTVAWST_DESC
|
|
ORIGINAL_OFFER_AMOUNT
|
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
|
Original Offer Awards
|
Number of original awards for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_ORIG_OFFER_NO
|
|
OTHER_GRANT_DISBURSED
|
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
|
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
|
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
|
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
|
Override Need to COA Indicator
|
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
|
Override Unmet Need Indicator
|
Packaging rule that indicates if this fund should override the validation of unmet need.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_OVERRIDE_NEED_IND
|
|
PAID_AMOUNT
|
Paid Amount
|
Amount of awards paid for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_PAID_AMT
|
|
PAID_NUMBER
|
Paid Number
|
Number of awards paid for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_PAID_NO
|
|
PARTIAL_AMOUNT_ACCEPTED_IND
|
Partial Amount Accepted Indicator
|
Indicates whether the Accept Partial Amount option should be available to the student on the Accept Award Offer page in Self-Service.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_ACPT_PARTIAL_AMT_IND
|
|
PRIOR_BALANCE_AMOUNT
|
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 Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
REBATE_FEE_PERCENT
|
Rebate Fee Percent
|
Rebate fee percentage. Starting with 1516 aid year, this field is only used for Electronic and Manual Loan processing.
|
NUMBER
|
RFRASPC
|
RFRASPC_REBATE_PERCENT
|
|
REPLACE_TFC_IND
|
Replace Tfc Indicator
|
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
|
|
ROLL_AWARD_IND
|
Roll Award Indicator
|
Indicates whether the fund is eligible for the award roll process.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_ROLL_IND
|
|
SMART_GRADE_LEVEL
|
Smart Grade Level
|
Indicates the SMART Grant year funding level.
|
VARCHAR2(63)
|
RFRASPC
|
RFRASPC_SMART_YEAR
|
|
STATE_GRANT_DISBURSED
|
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
|
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
|
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
|
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
|
|
TEACH_REDUCTION_PERCENT
|
Teach Reduction Percent
|
Percentage of the full award amount that TEACH will be reduced.
|
NUMBER
|
RFRASPC
|
RFRASPC_TEACH_REDUCTION_PCT
|
|
TOTAL_ALLOCATED_AMOUNT
|
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
|
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 Msg Number
|
Voice response message number assigned to the recorded message that describes the fund code.
|
NUMBER
|
RFRBASE
|
RFRBASE_VR_MSG_NO
|