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

SGHE Banner Operational Data Store
Reporting View Target: AWARD_BY_FUND

Description Contains total amount of aid awarded by financial aid fund within an aid year. Detail data may include the aid year, academic period, financial aid fund, fund source, fund type, fund detail code, and federal financial aid fund identification code.
Key & Frequency One row per aid year per fund.
Recommended Search Columns FUND, AID_YEAR
AID_YEAR, FUND_SOURCE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACCEPT_AMOUNT Accept Amount Amount accepted by the student for the indicated financial aid fund for this aid year. NUMBER  

CALCULATION

SUM(RPRAWRD_ACCEPT_AMT)

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

AUTHORIZED_AMOUNT Authorized Amount Authorized amount of financial aid for this fund. NUMBER  

CALCULATION

SUM(RPRAWRD_AUTHORIZE_AMT)

CANCEL_AMOUNT Cancel Amount Total amount of this fund that was offered and or accepted by the student's and then canceled. NUMBER  

CALCULATION

SUM(RPRAWRD_CANCEL_AMT)

DECLINE_AMOUNT Decline Amount Total amount of this fund declined by the student's for this aid year. NUMBER  

CALCULATION

SUM(RPRAWRD_DECLINE_AMT)

FEDERAL_FUND_ID Federal Fund ID Federal fund associated with the fund code. VARCHAR2(63)  

RFRBASE

RFRBASE_FED_FUND_ID

FUND Fund Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)  

RPRAWRD

RPRAWRD_FUND_CODE

FUND_DETAIL_CODE Fund Detail Code Links a financial aid fund code to an AR detail code for crediting funds to student accounts. VARCHAR2(63)  

RFRBASE

RFRBASE_DETAIL_CODE

FUND_SOURCE Fund Source Fund source code to be associated with the fund code. VARCHAR2(63)  

RFRBASE

RFRBASE_FSRC_CODE

FUND_SOURCE_DESC Fund Source Description Describes the fund source code and identifies what it represents. VARCHAR2(255)  

RTVFSRC

RTVFSRC_DESC

FUND_TITLE Fund Title Full title of the financial aid fund code. VARCHAR2(30)  

RFRBASE

RFRBASE_FUND_TITLE

FUND_TYPE Fund Type Code that classifies a fiscal entity. VARCHAR2(63)  

RFRBASE

RFRBASE_FTYP_CODE

FUND_TYPE_DESC Fund Type Description Fund type code description or title. VARCHAR2(255)  

RTVFTYP

RTVFTYP_DESC

GIFT_OR_SELF_HELP_AID Gift or Self Help Aid Indicator Classification of an award (or fund) based on the financial aid type associated with the fund, with Gift Aid having an aid type of grant or scholarship and Self Help Aid having an aid type of loan or work. VARCHAR2(63)  

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

GIFT_OR_SELF_HELP_AID_DESC Gift or Self Help Aid Indicator Description Description of the Gift or Self Help Aid code, where G = Gift Aid and S = Self Help Aid. VARCHAR2(255)  

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

MEMO_AMOUNT Memo Amount Displays the amount of the memo'd award. NUMBER  

CALCULATION

SUM(RPRAWRD_MEMO_AMT)

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

OFFER_AMOUNT Offer Amount Displays the amount of the current award offer. NUMBER  

CALCULATION

SUM(RPRAWRD_OFFER_AMT)

PAID_AMOUNT Paid Amount Displays the amount of the award that was actually disbursed. NUMBER  

CALCULATION

SUM(RPRAWRD_PAID_AMT)

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA



Ver: 9.0