Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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)	RPRAWRD	RPRAWRD_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	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(63)	RTVFTYP	RTVFTYP_ATYP_IND	NO	NO
FINANCIAL_AID_TYPE_DESC	Financial aid type description.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRADSB	RPRADSB_FUND_CODE	NO	NO
FUND_SOURCE_TYPE	Source of the financial assistance.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE	NO	NO
FUND_SOURCE_TYPE_DESC	Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC	NO	NO
FUND_TITLE	Descriptive title for the fund.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
INST_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
INST_LOAN_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
INST_SCHOLARSHIP_DISBURSED	Total disbursed amount where financial aid fund represents institutional scholarship awards.	NUMBER	FUNCTION	ROKODSF.F_CALCULATE_DISB_AMTS	NO	NO
INST_WORK_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
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
OTHER_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
OTHER_LOAN_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
OTHER_SCHOLARSHIP_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
OTHER_WORK_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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
STATE_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
STATE_LOAN_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
STATE_SCHOLARSHIP_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
STATE_WORK_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
TOTAL_ACCEPT_AMOUNT	Total amount accepted for this fund.	NUMBER	RPRAWRD	RPRAWRD_ACCEPT_AMT	NO	NO
TOTAL_DECLINE_AMOUNT	Total amount offered and then declined for this fund.	NUMBER	RPRAWRD	RPRAWRD_DECLINE_AMT	NO	NO
TOTAL_DISBURSED_AMT	Displays the amount actually disbursed for this fund.	NUMBER	RPRADSB	RPRADSB_DISBURSE_AMT	NO	NO
TOTAL_OFFER_AMOUNT	Total amount offered for this fund.	NUMBER	RPRAWRD	RPRAWRD_ORIG_OFFER_AMT	NO	NO
TOTAL_PAID_AMOUNT	Total amount offered and then paid from this fund.	NUMBER	RPRAWRD	RPRAWRD_PAID_AMT	NO	NO

Ver: 9.2