Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE 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 AID_YEAR, FUND
FUND, AID_YEAR
AID_YEAR, FUND, ACADEMIC_PERIOD

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