Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AID_YEAR
|
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
|
Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
ROBINST
|
ROBINST_AIDY_DESC
|
FEDERAL_GRANT_DISBURSED
|
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
|
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
|
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
|
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
|
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
|
Financial aid type description.
|
VARCHAR2(255)
|
RTVFTYP
|
RTVFTYP_DESC
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_FUND_CODE
|
FUND_SOURCE_TYPE
|
Fund Source Type
|
Source of the financial assistance.
|
VARCHAR2(63)
|
RFRBASE
|
RFRBASE_FSRC_CODE
|
FUND_SOURCE_TYPE_DESC
|
Fund Source Type Description
|
Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other.
|
VARCHAR2(255)
|
RTVFSRC
|
RTVFSRC_DESC
|
FUND_TITLE
|
Fund Title
|
Descriptive title for the fund.
|
VARCHAR2(255)
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
INST_GRANT_DISBURSED
|
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
|
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
|
Inst Scholarship Disbursed
|
Total disbursed amount where financial aid fund represents institutional scholarship awards.
|
NUMBER
|
FUNCTION
|
ROKODSF.F_CALCULATE_DISB_AMTS
|
INST_WORK_DISBURSED
|
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
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
OTHER_GRANT_DISBURSED
|
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
|
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
|
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
|
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 Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
STATE_GRANT_DISBURSED
|
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
|
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
|
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
|
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 Accept Amount
|
Total amount accepted for this fund.
|
NUMBER
|
RPRAWRD
|
RPRAWRD_ACCEPT_AMT
|
TOTAL_DECLINE_AMOUNT
|
Total Decline Amount
|
Total amount offered and then declined for this fund.
|
NUMBER
|
RPRAWRD
|
RPRAWRD_DECLINE_AMT
|
TOTAL_DISBURSED_AMT
|
Total Disbursed Amount
|
Displays the amount actually disbursed for this fund.
|
NUMBER
|
RPRADSB
|
RPRADSB_DISBURSE_AMT
|
TOTAL_OFFER_AMOUNT
|
Total Offer Amount
|
Total amount offered for this fund.
|
NUMBER
|
RPRAWRD
|
RPRAWRD_ORIG_OFFER_AMT
|
TOTAL_PAID_AMOUNT
|
Total Paid Amount
|
Total amount offered and then paid from this fund.
|
NUMBER
|
RPRAWRD
|
RPRAWRD_PAID_AMT
|