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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

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).    

RPRAWRD

RPRAWRD_AIDY_CODE

 
AID_YEAR_DESC Financial aid year name.    

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.    

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.    

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.    

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.    

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

 
FINANCIAL_AID_TYPE Identifies the type of financial assistance as either work, loan, scholarship or grant.    

RFRBASE

RFRBASE_FTYP_CODE

 
FINANCIAL_AID_TYPE_DESC Financial aid type description.    

RTVFTYP

RTVFTYP_DESC

 
FUND Financial Aid Fund code to be associated with information in this record.    

RPRADSB

RPRADSB_FUND_CODE

 
FUND_SOURCE_TYPE Source of the financial assistance.    

RFRBASE

RFRBASE_FSRC_CODE

 
FUND_SOURCE_TYPE_DESC Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other.    

RTVFSRC

RTVFSRC_DESC

 
FUND_TITLE Descriptive title for the fund.    

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.    

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.    

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

 
INST_SCHOLARSHIP_DISBURSED Total disbursed amount where financial aid fund represents institutional scholarship awards.    

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.    

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

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.    

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.    

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.    

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.    

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

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.    

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.    

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.    

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.    

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

 
TOTAL_ACCEPT_AMOUNT Total amount accepted for this fund.    

RPRAWRD

RPRAWRD_ACCEPT_AMT

 
TOTAL_DECLINE_AMOUNT Total amount offered and then declined for this fund.    

RPRAWRD

RPRAWRD_DECLINE_AMT

 
TOTAL_DISBURSED_AMT Displays the amount actually disbursed for this fund.    

RPRADSB

RPRADSB_DISBURSE_AMT

 
TOTAL_OFFER_AMOUNT Total amount offered for this fund.    

RPRAWRD

RPRAWRD_ORIG_OFFER_AMT

 
TOTAL_PAID_AMOUNT Total amount offered and then paid from this fund.    

RPRAWRD

RPRAWRD_PAID_AMT

 


Ver: 8.3