RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE 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
ACCEPT_AMOUNT Amount accepted by the student for the indicated financial aid fund for this aid year. NUMBER(11, 2)

RFRASPC

RFRASPC_ACCEPT_AMT

ACCEPT_AWARDS Number of awards accepted for this fund in the specified aid year. NUMBER(9)

RFRASPC

RFRASPC_ACCEPT_NO

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(4)

RFRASPC

RFRASPC_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

AUTHORIZE_AMOUNT Authorized amount of financial aid for this fund. NUMBER(11, 2)

RFRASPC

RFRASPC_AUTHORIZE_AMT

AUTHORIZE_AWARDS Number of awards authorized for the fund in this aid year. NUMBER(9)

RFRASPC

RFRASPC_AUTHORIZE_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(11, 2)

RFRASPC

RFRASPC_AVAIL_OFFER_AMT

AVAILABLE_OFFER_PERCENTAGE Total allocation percentage that the institution can offer including the over-commitment amount. NUMBER(6, 3)

RFRASPC

RFRASPC_AVAIL_OFFER_PCT

BUDGET_ALLOCATED_AMOUNT Actual allocated budget for a fund code within the given aid year. Optional field that defaults to 0. NUMBER(11, 2)

RFRASPC

RFRASPC_BUDG_ALLOC_AMT

CANCEL_AMOUNT Total amount of this fund that was offered and or accepted by the student's and then canceled. NUMBER(11, 2)

RFRASPC

RFRASPC_CANCEL_AMT

CANCEL_AWARDS Canceled amount for the financial aid award. NUMBER(9)

RFRASPC

RFRASPC_CANCEL_NO

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

NA

SYSDATE

DECLINE_AMOUNT Total amount of this fund declined by the student's for this aid year. NUMBER(11, 2)

RFRASPC

RFRASPC_DECLINE_AMT

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

RFRASPC

RFRASPC_DECLINE_NO

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

NA

NA

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

RFRBASE

RFRBASE_FED_FUND_ID

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 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 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 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 Identifies the type of financial assistance as either work, loan, scholarship or grant. VARCHAR2(1)

RTVFTYP

RTVFTYP_ATYP_IND

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

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

FUND Unique fiscal entity code. VARCHAR2(6)

RFRASPC

RFRASPC_FUND_CODE

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

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

RFRBASE

RFRBASE_FSRC_CODE

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

RTVFSRC

RTVFSRC_DESC

FUND_SOURCE_TYPE Source of the financial aid. VARCHAR2(1)

RTVFSRC

RTVFSRC_IND

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

CALCULATION

DECODE(RTVFSRC_IND)

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

RFRBASE

RFRBASE_FUND_TITLE

FUND_TYPE Code that classifies a fiscal entity. VARCHAR2(4)

RFRBASE

RFRBASE_FTYP_CODE

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

RTVFTYP

RTVFTYP_DESC

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

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

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

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

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(11, 2)

RFRASPC

RFRASPC_MAX_AWARD_AMT

MEMO_AMOUNT Amount of memo'd awards for the f und code in the specified aid year. NUMBER(11, 2)

RFRASPC

RFRASPC_MEMO_AMT

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

RFRASPC

RFRASPC_MEMO_NO

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

NA

NA

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

NA

NA

MIN_AWARD_AMOUNT Minimum award the institution wishes to offer to any one student from each specific fund. NUMBER(11, 2)

RFRASPC

RFRASPC_MIN_AWARD_AMT

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

RFRASPC

RFRASPC_REDUCE_NEED_IND

OFFER_AMOUNT Amount of awards that have been offered for the fund in the specified aid year. NUMBER(11, 2)

RFRASPC

RFRASPC_OFFER_AMT

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

RFRASPC

RFRASPC_OFFER_NO

ORIGINAL_OFFER_AMOUNT Amount of all original awards for the fund in the specified aid year. NUMBER(11, 2)

RFRASPC

RFRASPC_ORIG_OFFER_AMT

ORIGINAL_OFFER_AWARDS Number of original awards for the fund in the specified aid year. NUMBER(9)

RFRASPC

RFRASPC_ORIG_OFFER_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

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

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

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

PAID_AMOUNT Amount of awards that have been paid for the fund in the specified aid year. NUMBER(11, 2)

RFRASPC

RFRASPC_PAID_AMT

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

RFRASPC

RFRASPC_PAID_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(11, 2)

RFRASPC

RFRASPC_PRIOR_BAL_AMT

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

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

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

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

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    
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(11, 2)

RFRASPC

RFRASPC_TOTAL_ALLOC_AMT

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(11, 2)

RFRASPC

RFRASPC_TRANSFER_AMT

VOICE_RESPONSE_MSG_NO Voice response message number assigned to the recorded message that describes the fund code. NUMBER(6)

RFRBASE

RFRBASE_VR_MSG_NO

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

NA

NA



Ver: 3.1