Reporting View Target: GOVERNMENT_FA

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

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