Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACCEPT_AMOUNT
|
Amount accepted by the student for the indicated financial aid fund for this aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_ACCEPT_AMT
|
NO
|
NO
|
ACCEPT_AWARDS
|
Number of awards accepted for this fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_ACCEPT_NO
|
NO
|
NO
|
AID_YEAR
|
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
|
VARCHAR2(4)
|
RFRASPC
|
RFRASPC_AIDY_CODE
|
NO
|
NO
|
AID_YEAR_DESC
|
Financial aid year name.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
AUTHORIZE_AMOUNT
|
Authorized amount of financial aid for this fund.
|
NUMBER
|
RFRASPC
|
RFRASPC_AUTHORIZE_AMT
|
NO
|
NO
|
AUTHORIZE_AWARDS
|
Number of awards authorized for the fund in this aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_AUTHORIZE_NO
|
NO
|
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
|
NO
|
NO
|
AVAILABLE_OFFER_PERCENTAGE
|
Total allocation percentage that the institution can offer including the over-commitment amount.
|
NUMBER
|
RFRASPC
|
RFRASPC_AVAIL_OFFER_PCT
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
CANCEL_AWARDS
|
Canceled amount for the financial aid award.
|
NUMBER
|
RFRASPC
|
RFRASPC_CANCEL_NO
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DECLINE_AMOUNT
|
Total amount of this fund declined by the student's for this aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_DECLINE_AMT
|
NO
|
NO
|
DECLINE_AWARDS
|
Number of awards declined for this fund code in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_DECLINE_NO
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
EXTERNAL_REFERENCE_VALUE
|
User-defined field that enables you to cross reference IDs used for funds by another office.
|
VARCHAR2(10)
|
RFRBASE
|
RFRBASE_XREF_VALUE
|
NO
|
NO
|
FEDERAL_FUND_ID
|
Federal fund associated with the fund code.
|
VARCHAR2(4)
|
RFRBASE
|
RFRBASE_FED_FUND_ID
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FINANCIAL_AID_TYPE
|
Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund.
|
VARCHAR2(1)
|
RTVFTYP
|
RTVFTYP_ATYP_IND
|
NO
|
NO
|
FINANCIAL_AID_TYPE_DESC
|
The description of the type of aid being offered.
|
VARCHAR2(30)
|
CALCULATION
|
DECODE(RTVFTYP_ATYP_IND)
|
NO
|
NO
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(6)
|
RFRASPC
|
RFRASPC_FUND_CODE
|
NO
|
NO
|
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
|
NO
|
NO
|
FUND_DETAIL_CODE_DESC
|
Detail code description.
|
VARCHAR2(30)
|
TBBDETC
|
TBBDETC_DESC
|
NO
|
NO
|
FUND_LONG_TITLE
|
Full description of the fund code.
|
VARCHAR2(200)
|
RFRBASE
|
RFRBASE_FUND_TITLE_LONG
|
NO
|
NO
|
FUND_SOURCE
|
Fund source code to be associated with the fund as defined by the institution.
|
VARCHAR2(4)
|
RFRBASE
|
RFRBASE_FSRC_CODE
|
NO
|
NO
|
FUND_SOURCE_DESC
|
Describes the fund source code and identifies what it represents.
|
VARCHAR2(30)
|
RTVFSRC
|
RTVFSRC_DESC
|
NO
|
NO
|
FUND_SOURCE_TYPE
|
Source of the financial aid.
|
VARCHAR2(1)
|
RTVFSRC
|
RTVFSRC_IND
|
NO
|
NO
|
FUND_SOURCE_TYPE_DESC
|
This is the description the source of the Financial Aid.
|
VARCHAR2(30)
|
CALCULATION
|
DECODE(RTVFSRC_IND)
|
NO
|
NO
|
FUND_TITLE
|
Full title of the financial aid fund code.
|
VARCHAR2(30)
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
NO
|
NO
|
FUND_TYPE
|
Fund type code to be associated with the fund as defined by the institution.
|
VARCHAR2(4)
|
RFRBASE
|
RFRBASE_FTYP_CODE
|
NO
|
NO
|
FUND_TYPE_DESC
|
Fund type code description or title.
|
VARCHAR2(30)
|
RTVFTYP
|
RTVFTYP_DESC
|
NO
|
NO
|
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(30)
|
CALCULATION
|
DECODE(RTVFTYP_ATYP_IND)
|
NO
|
NO
|
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(30)
|
CALCULATION
|
DECODE(RTVFTYP_ATYP_IND)
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
MEMO_AMOUNT
|
Amount of memo'd awards for the f und code in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_MEMO_AMT
|
NO
|
NO
|
MEMO_AWARDS
|
Number of memo'd awards for the fund code in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_MEMO_NO
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
NEED_BASED_IND
|
Indicates whether the fund is need based.
|
VARCHAR2(1)
|
RFRASPC
|
RFRASPC_REDUCE_NEED_IND
|
NO
|
NO
|
OFFER_AMOUNT
|
Amount of awards that have been offered for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_OFFER_AMT
|
NO
|
NO
|
OFFER_AWARDS
|
Number of awards that are currently offered for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_OFFER_NO
|
NO
|
NO
|
ORIGINAL_OFFER_AMOUNT
|
Amount of all original awards for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_ORIG_OFFER_AMT
|
NO
|
NO
|
ORIGINAL_OFFER_AWARDS
|
Number of original awards for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_ORIG_OFFER_NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
PAID_AMOUNT
|
Amount of awards that have been paid for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_PAID_AMT
|
NO
|
NO
|
PAID_NUMBER
|
Number of awards that have been paid for the fund in the specified aid year.
|
NUMBER
|
RFRASPC
|
RFRASPC_PAID_NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
|
|
|
NO
|
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
|
RFRASPC
|
RFRASPC_TOTAL_ALLOC_AMT
|
NO
|
NO
|
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
|
NO
|
NO
|
VOICE_RESPONSE_MSG_NO
|
Voice response message number assigned to the recorded message that describes the fund code.
|
NUMBER
|
RFRBASE
|
RFRBASE_VR_MSG_NO
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|