Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
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
|
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
|
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
|
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
|
ROKODSF.F_CALCULATE_DISB_AMTS
|
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
|