Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: NEED_ANALYSIS_INST_METHOD

Description Contains information specific to the institutional methodology of computing applicant need.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.
Recommended Search Columns AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated DATE

RCRAPP2

RCRAPP2_ACTIVITY_DATE

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 associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)

RCRAPP2

RCRAPP2_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER

RCRAPP2

RCRAPP2_SEQ_NO

CURRENT_RECORD_IND Specifies that this is the current need analysis record. VARCHAR2(63)

RCRAPP1

RCRAPP1_CURR_REC_IND

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IM_ADJUSTED_AVAILABLE_INCOME Amount of the adjusted available income that was used in the Institutional Method calculation of the student contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_ADJ_AVAIL_INC

IM_ADJUSTED_BUS_NET_WORTH Amount of business and farm net worth used in the calculation of the Institutional Method student contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_ADJ_BF_NET_WTH

IM_ADJUSTED_GROSS_INCOME Adjusted gross taxable income used in the calculation of the Institutional Method student contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_AGI_TAX_INC

IM_ANALYSIS_TYPE Analysis type used for the Institutional Method student contribution. VARCHAR2(63)

RCRAPP2

RCRAPP2_IM_1_ANLY_TYPE

IM_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_IM_1_ANLY_TYPE)

IM_ASSET_PROTECT_ALLOWANCE Asset protection allowance used in the calculation of the student Institutional Method contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_PROT_ALLOW

IM_AVAILABLE_INCOME Student's available discretionary income for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_AVAIL_DISC_INC

IM_AVAILABLE_TAX_INCOME Student's available taxable income for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_AVAIL_TAX_INC

IM_BUDGET_DURATION Budget duration used for the Institutional Method calculation. NUMBER

RCRAPP4

RCRAPP4_IM_BUDG_DUR_FOR_CALC

IM_CALC_AVAILABLE_INCOME Student's calculated available income for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CALC_AVAIL_INC

IM_CASH_AMOUNT Student's amounts in cash, savings and checking accounts used in the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CASH_AMT

IM_CONTRIBUTION Primary institutional methodology student contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_SC

IM_CONTRIBUTION_AMOUNT Student Institutional Method contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_IM_CTRB_STDT

IM_CONTRIBUTION_ASSET Student's contribution from assets for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_ASSET

IM_CONTRIBUTION_INCOME Student's contribution from income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_INC

IM_CONTRIBUTION_OFFICIAL Indicates if the Institutional Method student contribution is official or estimated. VARCHAR2(63)

RCRAPP2

RCRAPP2_C_2_CTRB_OFFL_EST

IM_CONTRIBUTION_OFFICIAL_DESC Description of the Institutional Method student contribution. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)

IM_CONVERSION_PERCENT Conversion percent used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CONV_PCT

IM_CUSTODIAL_PARENT Custodial parent used for Institutional Method only calculation of custodial parent's adjustment contribution. VARCHAR2(63)

RCRAPP4

RCRAPP4_CUSTODIAL_PARENT

IM_CUSTODIAL_PARENT_DESC Institutional Method custodial parent description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_CUSTODIAL_PARENT)

IM_DISCRET_NET_WORTH Student's discretionary net worth used in the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_DISC_NET_WTH

IM_EMPLOYMENT_ALLOWANCE Employment allowance used in the calculation of the student Institutional Method contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_EMP_ALLOW

IM_FEDERAL_TAX_PAID Amount of federal income taxes paid used in the calculation of the Institutional Method student contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_US_INC_TAX

IM_HOME_EQUITY Home equity used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_HME_VAL

IM_INAS The student contribution for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FOR_STDT

IM_INCOME_SUPPLEMENT Amount of the income supplement used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_INC_SUPPLEMENT

IM_MEDICAL_DENTAL_EXPENSE Amount of medical or dental expenses used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_MED_DEN_EXP

IM_MULTI_ENROLL_ADJUSTED Percentage of adjustment to the student contribution for differing numbers of family members in college. Prior to 2001, this contains the number in college as used in the calculation of EFC. NUMBER

RCRAPP2

RCRAPP2_C_2_NO_IN_COLL

IM_NET_WORTH Amount of the student's net worth used in the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_NET_WTH

IM_OTHER_ASSET_ALLOW_OVR Amount of the other asset allowance (override) used in the student Institutional Method calculation. NUMBER

RCRAPP4

RCRAPP4_C_2_OTH_ASSET_ALLOW

IM_OTHER_ASSET_OVR Amount of the other asset (override) used in the student Institutional Method calculation. NUMBER

RCRAPP4

RCRAPP4_C_2_OTH_ASSET

IM_PARENT_ADJUST_GROSS_INCOME Adjusted gross taxable income used in the calculation of the secondary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_AGI_TAX_INC

IM_PARENT_ADJ_AVAILABLE_INCOME Adjusted available income used in the calculation of the Institutional Method parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_ADJ_AVAIL_INC

IM_PARENT_ADJ_BUS_NET_WORTH Amount of business and farm net worth used in the calculation of the secondary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH

IM_PARENT_ANALYSIS_TYPE Analysis type used for the Institutional Method parent contribution. VARCHAR2(63)

RCRAPP2

RCRAPP2_IM_1_PAR_ANLY_TYPE

IM_PARENT_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_IM_1_PAR_ANLY_TYPE)

IM_PARENT_ASSET_PROT_ALLOWANCE Amount of the parent's asset protection allowance used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_PROT_ALLOW

IM_PARENT_AVAILABLE_INCOME Parent's available discretionary income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_AVAIL_DISC_INC

IM_PARENT_CASH_AMOUNT Parent's estimated amounts in cash, savings and checking accounts used in the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CASH_AMT

IM_PARENT_CONTRIBUTION Primary institutional methodology parent contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_PC

IM_PARENT_CONTRIBUTION_AMOUNT Parent Institutional Method contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_P_IM_CTRB_STDT

IM_PARENT_CONTRIBUTION_ASSET Portion of the primary parent contribution that came from income. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_ASSET

IM_PARENT_CONTRIBUTION_INCOME Portion of the primary parent contribution that came from income. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_INC

IM_PARENT_CONTRIB_OFFICIAL Indicates if the Institutional Method parent contribution is official or estimated. VARCHAR2(63)

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_OFFL_EST

IM_PARENT_CONTRIB_OFF_DESC Description of the Institutional Method parent contribution. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)

IM_PARENT_CONVERSION_PERCENT Conversion percent used in the parent's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CONV_PCT

IM_PARENT_DATA_AVAILABLE_IND Indicates whether parent data was available for the Institutional Method calculation. VARCHAR2(63)

RCRAPP4

RCRAPP4_IM_PAR_DATA_AVAIL

IM_PARENT_DISCRET_NET_WORTH Parent's discretionary net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_DISC_NET_WTH

IM_PARENT_EMPLOYMENT_ALLOWANCE Employment allowance used in the Institutional Method calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_EMP_ALLOW

IM_PARENT_FEDERAL_INCOME_TAX Amount of federal income tax paid by the parent. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_US_INC_TAX

IM_PARENT_HOME_EQUITY Home equity used in the parent's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_HME_VAL

IM_PARENT_INAS The parent contribution for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FOR_STDT

IM_PARENT_INCOME_SUPPLEMENT Amount of the income supplement used in the parent's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_INC_SUPPLEMENT

IM_PARENT_MEDICAL_DENTAL_EXP Amount of medical and dental expenses used in the Institutional Method calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_MED_DEN_EXP

IM_PARENT_MULTI_ENROLLMENT_ADJ Percentage of adjustment to the parent contribution for differing numbers of family members in college. Prior to 2001, this contains the number in college as used in the calculation of EFC. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_NO_IN_COLL

IM_PARENT_NET_WORTH Amount of the parent's net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_NET_WTH

IM_PARENT_OTH_ASSET_ALLOW_OVR Amount of the other asset allowance (override) used in the parent Institutional Method calculation. NUMBER

RCRAPP4

RCRAPP4_C_PAR_2_OTH_ASSET_ALLW

IM_PARENT_REAL_ESTATE_EQUITY Amount of other real estate/investment equity used in the parent's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_RE_INV_VAL

IM_PARENT_SECONDARY_TUITION_PD The amount of elementary, jr. high, and high school tuition paid by the student's secondary parent contributor in the base year. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_SCH_TUIT

IM_PARENT_STAND_MAINT_ALLOW Standard maintenance allownace used in the Institutional Method calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_MNT_ALLOW

IM_PARENT_STATE_PROV_TAX_PAID Amount of state and other taxes paid used in the Institutional Method calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_ST_OTH_TAX

IM_PARENT_TOTAL_ALLOWANCE Estimated amount of total allowances used in the parent's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_TOT_ALLOW

IM_PARENT_TOTAL_CONTRIBUTION Total parent contribution before the number in college adjustment for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_TOT_CTRB

IM_PARENT_TOTAL_INCOME Total income used in the calculation of the parent Institutional Method contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_TOT_INC

IM_PARENT_TOTAL_UNTAX_INCOME Amount of total untaxed income used in the parent's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_TOT_UNTAX_INC

IM_PARENT_WAGE_TAX_PAID Amount of wage taxes used in the Institutional Method calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_FICA_TAX

IM_REAL_ESTATE_EQUITY Amount of other real estate/investment equity used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_RE_INV_VAL

IM_SECOND_TUITION_PAID Amount of elementary/secondary school tuition paid that was used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_SCH_TUIT

IM_STAND_MAINT_ALLOWANCE Standard maintenance allowance used in the Institutional Method calculation of the student's contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_MNT_ALLOW

IM_STATE_PROVINCE_TAX_PAID Amount of state or province and other taxes used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_ST_OTH_TAX

IM_TAXABLE_INCOME_CONTRIBUTION Taxable income contribution for single independent students for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TAX_INC_CTRB

IM_TOTAL_ALLOWANCES Amount of total allowances used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_ALLOW

IM_TOTAL_CONTRIBUTION Total student contribution before the number in college adjustment for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_CTRB

IM_TOTAL_FAMILY_CONTRIBUTION Primary institutional methodology total family contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_TFC

IM_TOTAL_INCOME The total income used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_INC

IM_TOTAL_UNTAX_INCOME Amount of total untaxed income used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_UNTAX_INC

IM_TRUST_AMOUNT Amount of the student trust account used in the student Institutional Method calculation. NUMBER

RCRAPP4

RCRAPP4_C_2_TRUST_VAL

IM_UNASSESSED_VETERAN_BENEFITS Unassessed VA benefits used in the primary Institutional Method student contribution calculation. NUMBER

RCRAPP2

RCRAPP2_IM_1_UNASSESSED_VA

IM_VETERAN_BENEFITS_IND Indicates if VA benefits have been included in the calculation of the student's Institutional Method contribution. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP2_C_2_VA_BEN_INCL)

IM_WAGE_TAX_PAID Amount of wage taxes used in the student's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_FICA_TAX

INTERFACE_TAPE_CODE Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.). VARCHAR2(63)

RCRAPP2

RCRAPP2_INFC_CODE

INTERFACE_TAPE_DESC Description of the interface tape code. VARCHAR2(255)

RTVINFC

RTVINFC_DESC

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

NA

NA

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

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RCRAPP2

RCRAPP2_PIDM

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

NA

NA

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

RCRAPP2

RCRAPP2_USER_ID



Ver: 8.0