Go To View:  RETURN TO BANNER ODS META DATA 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 FUND, AID_YEAR
AID_YEAR

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP 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 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 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



Ver: 9.0