Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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
EXTERNAL_REFERENCE_VALUE	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
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_DETAIL_CODE_DESC	Fund Detail Code Description	Detail code description.	VARCHAR2(30)		TBBDETC	TBBDETC_DESC
FUND_LONG_TITLE	Fund Long Title	Full description of the fund code.	VARCHAR2(200)		RFRBASE	RFRBASE_FUND_TITLE_LONG
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
GIFT_OR_SELF_HELP_AID	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)
GIFT_OR_SELF_HELP_AID_DESC	Gift or Self Help Aid Description	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)
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_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		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
OVERRIDE_NEED_TO_COA_IND	Override Need to Chart of Accounts 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		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: