Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: GOVERNMENT_FA_FUND

Description Contains a set of common data identified for known governmental reporting regarding a financial aid fund. Detail data includes aid year, financial aid source type, financial aid type with reporting group for external or internal.
Key & Frequency One row per aid year per academic period per financial aid source type per financial aid type per fund.
Recommended Search Columns FUND, AID_YEAR
AID_YEAR

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