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
ACCEPT_AWARD_STATUS	Fund's accepted award status.	VARCHAR2(63)	RFRASPC	RFRASPC_ACCEPT_AWST_CODE	NO	NO
ACCEPT_AWARD_STATUS_DESC	Accept award status description.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	NO	NO
ACG_GRADE_LEVEL	Indicates the ACG Grant year funding level.	VARCHAR2(63)	RFRASPC	RFRASPC_ACG_YEAR	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	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
AUTOMATIC_PACKAGE_IND	Indicates whether the fund should be used in automatic packaging.	VARCHAR2(1)	RFRASPC	RFRASPC_AUTO_PACK_IND	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
CANCEL_AWARD_STATUS	Fund's canceled award status.	VARCHAR2(63)	RFRASPC	RFRASPC_CANCEL_AWST_CODE	NO	NO
CANCEL_AWARD_STATUS_DESC	Cancel award status description.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	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
DECLINE_AWARD_STATUS	Fund's declined award status.	VARCHAR2(63)	RFRASPC	RFRASPC_DECLINE_AWST_CODE	NO	NO
DECLINE_AWARD_STATUS_DESC	Decline award status description.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	NO	NO
DIRECT_LOAN_TYPE	Identifies the direct loan type for the fund when applicable.	VARCHAR2(1)	RFRASPC	RFRASPC_DIRECT_LOAN_IND	NO	NO
DIRECT_LOAN_TYPE_DESC	Direct loan type description.	VARCHAR2(255)	CALCULATION	CASE WHEN RFRASPC_DIRECT_LOAN_IND	NO	NO
ELECTRONIC_LOAN_TYPE	Identifies the electronic loan type for the fund when applicable.	VARCHAR2(1)	RFRASPC	RFRASPC_EL_IND	NO	NO
ELECTRONIC_LOAN_TYPE_DESC	Electronic loan type description.	VARCHAR2(255)	CALCULATION	CASE WHEN RFRASPC_EL_LOAN_IND	NO	NO
EQUITY_PACKAGE_IND	Indicates whether the fund should be considered in EQUITY packaging.	VARCHAR2(1)	RFRASPC	RFRASPC_EQUITY_IND	NO	NO
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	NO	NO
FEDERAL_FUND_ID	Federal fund associated with the fund code.	VARCHAR2(63)	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
FINAID_ENROLLMENT_RULE	Enrollment rule used to disburse the fund.	VARCHAR2(63)	RFRASPC	RFRASPC_ENRR_CODE	NO	NO
FINAID_ENROLLMENT_RULE_DESC	Financial Aid enrollment rule code description.	VARCHAR2(255)	RTVENRR	RTVENRR_DESC	NO	NO
FINAID_FUND_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	RFRASPC	RFRASPC_ACTIVITY_DATE	NO	NO
FINAID_FUND_USER_ID	Unique identification code of the user who entered or last touched the record.	VARCHAR2(63)	RFRASPC	RFRASPC_USER_ID	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(63)	RTVFTYP	RTVFTYP_ATYP_IND	NO	NO
FINANCIAL_AID_TYPE_DESC	Financial aid type description.	VARCHAR2(255)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	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(63)	RFRBASE	RFRBASE_DETAIL_CODE	NO	NO
FUND_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC	NO	NO
FUND_LONG_TITLE	Full description of the fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE_LONG	NO	NO
FUND_PERIOD_ENABLED_IND	Determines whether the fund is enabled for aid enrollment period awarding.	VARCHAR2(1)	RFRASPC	RFRASPC_ENABLE_PERIOD_AWARDING	NO	NO
FUND_SOURCE	Fund source code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE	NO	NO
FUND_SOURCE_DESC	Describes the fund source code and identifies what it represents.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC	NO	NO
FUND_SOURCE_TYPE	Identifies the fund source type as either federal, state, institution or other.	VARCHAR2(63)	RTVFSRC	RTVFSRC_IND	NO	NO
FUND_SOURCE_TYPE_DESC	Description for the type of source for this fund.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC	NO	NO
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
FUND_TYPE	Fund type code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RTVFTYP	RTVFTYP_ATYP_IND	NO	NO
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(255)	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(63)	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(255)	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
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	NO	NO
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	NO	NO
LOAN_SOURCE_DESC	Loan source description.	VARCHAR2(255)	CALCULATION	CASE WHEN RFRASPC_DIRECT_LOAN_IND	NO	NO
MANUAL_LOAN_TYPE	Identifies the manual loan type for the fund when applicable.	VARCHAR2(1)	RFRASPC	RFRASPC_MANUAL_LOAN_IND	NO	NO
MANUAL_LOAN_TYPE_DESC	Manual loan type description.	VARCHAR2(255)	CALCULATION	CASE WHEN RFRASPC_MANUAL_LOAN_IND	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
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	NO	NO
MEMO_AWARD_ALLOWED_DESC	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	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
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	NO	NO
MIX_ACCEPT_AWARD_STATUS_DESC	Mix accept award status description.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	NO	NO
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	NO	NO
MIX_DECLINE_AWARD_STATUS_DESC	Mix decline award status description.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	NO	NO
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	NO	NO
MIX_OFFER_AWARD_STATUS_DESC	Mix offer award status description.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	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	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	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
OFFER_AWARD_STATUS	Fund's offered award status.	VARCHAR2(63)	RFRASPC	RFRASPC_OFFER_AWST_CODE	NO	NO
OFFER_AWARD_STATUS_DESC	Offer award status description.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	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 paid for the fund in the specified aid year.	NUMBER	RFRASPC	RFRASPC_PAID_AMT	NO	NO
PAID_NUMBER	Number of awards paid for the fund in the specified aid year.	NUMBER	RFRASPC	RFRASPC_PAID_NO	NO	NO
PARTIAL_AMOUNT_ACCEPTED_IND	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	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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
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	NO	NO
ROLL_AWARD_IND	Indicates whether the fund is eligible for the award roll process.	VARCHAR2(1)	RFRASPC	RFRASPC_ROLL_IND	NO	NO
SMART_GRADE_LEVEL	Indicates the SMART Grant year funding level.	VARCHAR2(63)	RFRASPC	RFRASPC_SMART_YEAR	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	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS	NO	NO
TEACH_REDUCTION_PERCENT	Percentage of the full award amount that TEACH will be reduced.	NUMBER	RFRASPC	RFRASPC_TEACH_REDUCTION_PCT	NO	NO
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	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

Ver: 9.2