Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_FINAID_FUND

Description Source composite view contains each fund with its detailed information for each aid year.

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

RFRASPC

RFRASPC_ACCEPT_AMT

NO

NO
ACCEPT_AWARDS Number of awards accepted for this fund in the specified aid year. NUMBER

RFRASPC

RFRASPC_ACCEPT_NO

NO

NO
AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(4)

RFRASPC

RFRASPC_AIDY_CODE

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
AUTHORIZE_AMOUNT Authorized amount of financial aid for this fund. NUMBER

RFRASPC

RFRASPC_AUTHORIZE_AMT

NO

NO
AUTHORIZE_AWARDS Number of awards authorized for the fund in this aid year. NUMBER

RFRASPC

RFRASPC_AUTHORIZE_NO

NO

NO
AVAILABLE_OFFER_AMOUNT Offered amount for the financial aid fund including any over-commitment amount. Calculated if an available to offer percent recorded for the fund. NUMBER

RFRASPC

RFRASPC_AVAIL_OFFER_AMT

NO

NO
AVAILABLE_OFFER_PERCENTAGE Total allocation percentage that the institution can offer including the over-commitment amount. NUMBER

RFRASPC

RFRASPC_AVAIL_OFFER_PCT

NO

NO
BUDGET_ALLOCATED_AMOUNT Actual allocated budget for a fund code within the given aid year. Optional field that defaults to 0. NUMBER

RFRASPC

RFRASPC_BUDG_ALLOC_AMT

NO

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

RFRASPC

RFRASPC_CANCEL_AMT

NO

NO
CANCEL_AWARDS Canceled amount for the financial aid award. NUMBER

RFRASPC

RFRASPC_CANCEL_NO

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

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

RFRASPC

RFRASPC_DECLINE_AMT

NO

NO
DECLINE_AWARDS Number of awards declined for this fund code in the specified aid year. NUMBER

RFRASPC

RFRASPC_DECLINE_NO

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
EXTERNAL_REFERENCE_VALUE User-defined field that enables you to cross reference IDs used for funds by another office. VARCHAR2(10)

RFRBASE

RFRBASE_XREF_VALUE

NO

NO
FEDERAL_FUND_ID Federal fund associated with the fund code. VARCHAR2(4)

RFRBASE

RFRBASE_FED_FUND_ID

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
FINANCIAL_AID_TYPE Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund. VARCHAR2(1)

RTVFTYP

RTVFTYP_ATYP_IND

NO

NO
FINANCIAL_AID_TYPE_DESC The description of the type of aid being offered. VARCHAR2(30)

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

NO

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

RFRASPC

RFRASPC_FUND_CODE

NO

NO
FUND_DETAIL_CODE Links a financial aid fund code to an AR detail code for crediting funds to student accounts. VARCHAR2(4)

RFRBASE

RFRBASE_DETAIL_CODE

NO

NO
FUND_DETAIL_CODE_DESC Detail code description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

NO

NO
FUND_LONG_TITLE Full description of the fund code. VARCHAR2(200)

RFRBASE

RFRBASE_FUND_TITLE_LONG

NO

NO
FUND_SOURCE Fund source code to be associated with the fund as defined by the institution. VARCHAR2(4)

RFRBASE

RFRBASE_FSRC_CODE

NO

NO
FUND_SOURCE_DESC Describes the fund source code and identifies what it represents. VARCHAR2(30)

RTVFSRC

RTVFSRC_DESC

NO

NO
FUND_SOURCE_TYPE Source of the financial aid. VARCHAR2(1)

RTVFSRC

RTVFSRC_IND

NO

NO
FUND_SOURCE_TYPE_DESC This is the description the source of the Financial Aid. VARCHAR2(30)

CALCULATION

DECODE(RTVFSRC_IND)

NO

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

RFRBASE

RFRBASE_FUND_TITLE

NO

NO
FUND_TYPE Fund type code to be associated with the fund as defined by the institution. VARCHAR2(4)

RFRBASE

RFRBASE_FTYP_CODE

NO

NO
FUND_TYPE_DESC Fund type code description or title. VARCHAR2(30)

RTVFTYP

RTVFTYP_DESC

NO

NO
GIFT_OR_SELF_HELP_AID 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(30)

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

NO

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

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

NO

NO
INST_GRANT_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to grant. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
INST_LOAN_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to loan. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
INST_SCHOLARSHIP_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to scholarship. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
INST_WORK_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to institution and a fund type indicator equal to work. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
MAX_AWARD_AMOUNT Maximum award the institution wishes to offer to any one student from a specific fund. Cannot be negative and cannot be less than the award minimum. NUMBER

RFRASPC

RFRASPC_MAX_AWARD_AMT

NO

NO
MEMO_AMOUNT Amount of memo'd awards for the f und code in the specified aid year. NUMBER

RFRASPC

RFRASPC_MEMO_AMT

NO

NO
MEMO_AWARDS Number of memo'd awards for the fund code in the specified aid year. NUMBER

RFRASPC

RFRASPC_MEMO_NO

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
MIN_AWARD_AMOUNT Minimum award the institution wishes to offer to any one student from each specific fund. NUMBER

RFRASPC

RFRASPC_MIN_AWARD_AMT

NO

NO
NEED_ANALYSIS_IND Packaging rule that indicates if an FM need analysis record be on file for this fund to be awarded or for loan processing to occur. VARCHAR2(1)

RFRASPC

RFRASPC_NA_REQD_IND

NO

NO
NEED_BASED_IND Indicates whether the fund is need based. VARCHAR2(1)

RFRASPC

RFRASPC_REDUCE_NEED_IND

NO

NO
OFFER_AMOUNT Amount of awards that have been offered for the fund in the specified aid year. NUMBER

RFRASPC

RFRASPC_OFFER_AMT

NO

NO
OFFER_AWARDS Number of awards that are currently offered for the fund in the specified aid year. NUMBER

RFRASPC

RFRASPC_OFFER_NO

NO

NO
ORIGINAL_OFFER_AMOUNT Amount of all original awards for the fund in the specified aid year. NUMBER

RFRASPC

RFRASPC_ORIG_OFFER_AMT

NO

NO
ORIGINAL_OFFER_AWARDS Number of original awards for the fund in the specified aid year. NUMBER

RFRASPC

RFRASPC_ORIG_OFFER_NO

NO

NO
OTHER_GRANT_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to grant. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
OTHER_LOAN_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to work. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
OTHER_SCHOLARSHIP_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to scholarship. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
OTHER_WORK_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to other and a fund type indicator equal to work. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
OVERRIDE_NEED_TO_COA_IND Packaging rule that indicates if this fund should override need up to the cost of attendance (budget) amount. VARCHAR2(1)

RFRASPC

RFRASPC_OVERRIDE_NEED_TO_COA

NO

NO
OVERRIDE_UNMET_NEED_IND Packaging rule that indicates if this fund should override the validation of unmet need. VARCHAR2(1)

RFRASPC

RFRASPC_OVERRIDE_NEED_IND

NO

NO
PAID_AMOUNT Amount of awards that have been paid for the fund in the specified aid year. NUMBER

RFRASPC

RFRASPC_PAID_AMT

NO

NO
PAID_NUMBER Number of awards that have been paid for the fund in the specified aid year. NUMBER

RFRASPC

RFRASPC_PAID_NO

NO

NO
PRIOR_BALANCE_AMOUNT Any prior balance for the fund code from a previous aid year. Optional field with a default value of 0. NUMBER

RFRASPC

RFRASPC_PRIOR_BAL_AMT

NO

NO
REPLACE_TFC_IND Used to define whether this fund should replace the total family contribution in the calculation of unmet need. VARCHAR2(1)

RFRASPC

RFRASPC_REPLACE_TFC_IND

NO

NO
STATE_GRANT_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to grant. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
STATE_LOAN_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to loan. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
STATE_SCHOLARSHIP_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to scholarship. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

NO

NO
STATE_WORK_DISBURSED Sum of the financial aid award disbursed for the time frame with a fund source type indicator equal to state and a fund type indicator equal to work. NUMBER       NO
TOTAL_ALLOCATED_AMOUNT Calculated field displays the total available amount for the fund for the aid year. It is the sum of the prior balance; the transferred amount plus the budget allocated amount. NUMBER

RFRASPC

RFRASPC_TOTAL_ALLOC_AMT

NO

NO
TRANSFER_AMOUNT Any amount that should transfer in or transfer out of a fund that affects the total allocation for the aid year. Optional with a default value of 0. Can be negative. NUMBER

RFRASPC

RFRASPC_TRANSFER_AMT

NO

NO
VOICE_RESPONSE_MSG_NO Voice response message number assigned to the recorded message that describes the fund code. NUMBER

RFRBASE

RFRBASE_VR_MSG_NO

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: