Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	RPRAWRD	RPRAWRD_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
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(63)	RFRBASE	RFRBASE_FTYP_CODE
FINANCIAL_AID_TYPE_DESC	Financial aid type description.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRADSB	RPRADSB_FUND_CODE
FUND_SOURCE_TYPE	Source of the financial assistance.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE
FUND_SOURCE_TYPE_DESC	Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC
FUND_TITLE	Descriptive title for the fund.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE
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
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
INST_SCHOLARSHIP_DISBURSED	Total disbursed amount where financial aid fund represents institutional scholarship awards.	NUMBER	FUNCTION	RPRADSB_DISBURSE_AMT
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
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
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
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
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
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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
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
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
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
TOTAL_ACCEPT_AMOUNT	Total amount accepted for this fund.	NUMBER	RPRAWRD	RPRAWRD_ACCEPT_AMT
TOTAL_DECLINE_AMOUNT	Total amount offered and then declined for this fund.	NUMBER	RPRAWRD	RPRAWRD_DECLINE_AMT
TOTAL_DISBURSED_AMT	Displays the amount actually disbursed for this fund.	NUMBER	RPRADSB	RPRADSB_DISBURSE_AMT
TOTAL_OFFER_AMOUNT	Total amount offered for this fund.	NUMBER	RPRAWRD	RPRAWRD_ORIG_OFFER_AMT
TOTAL_PAID_AMOUNT	Total amount offered and then paid from this fund.	NUMBER	RPRAWRD	RPRAWRD_PAID_AMT

Ver: 8.1