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

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 Name Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE

RCRAPP2

RCRAPP2_ACTIVITY_DATE

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

NA

NA

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

RCRAPP2

RCRAPP2_AIDY_CODE

AID_YEAR_DESC Financial Aid Year Description Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

APPLICATION_NUMBER Application Number Financial aid application unique sequence number. NUMBER

RCRAPP2

RCRAPP2_SEQ_NO

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

RCRAPP1

RCRAPP1_CURR_REC_IND

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IM_ADJUSTED_AVAILABLE_INCOME Institution Method 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 Institution Method 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 Institution Method 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 Institution Method Analysis Type Analysis type used for the Institutional Method student contribution. VARCHAR2(63)

RCRAPP2

RCRAPP2_IM_1_ANLY_TYPE

IM_ANALYSIS_TYPE_DESC Institution Method Analysis Type Description Analysis type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

IM_ASSET_PROTECT_ALLOWANCE Institution Method 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 Institution Method Available Income Student's available discretionary income for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_AVAIL_DISC_INC

IM_AVAILABLE_TAX_INCOME Institution Method Available Tax Income Student's available taxable income for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_AVAIL_TAX_INC

IM_BUDGET_DURATION Institution Method Budget Duration Budget duration used for the Institutional Method calculation. NUMBER

RCRAPP4

RCRAPP4_IM_BUDG_DUR_FOR_CALC

IM_CALC_AVAILABLE_INCOME Institution Method Calculated Available Income Student's calculated available income for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CALC_AVAIL_INC

IM_CASH_AMOUNT Institution Method 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 Institution Method Contribution Primary institutional methodology student contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_SC

IM_CONTRIBUTION_AMOUNT Institution Method Contribution Amount Student Institutional Method contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_IM_CTRB_STDT

IM_CONTRIBUTION_ASSET Institution Method Contribution Asset Student's contribution from assets for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_ASSET

IM_CONTRIBUTION_INCOME Institution Method Contribution Income Student's contribution from income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_INC

IM_CONTRIBUTION_OFFICIAL Institution Method 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 Institution Method Contribution Official Description Description of the Institutional Method student contribution. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)

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

RCRAPP2

RCRAPP2_C_2_CONV_PCT

IM_CUSTODIAL_PARENT Institution Method 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 Institution Method Custodial Parent Description Institutional Method custodial parent description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_CUSTODIAL_PARENT)

IM_DEPENDENCY_STATUS Institution Method Dependency Status Calculated Institutional Method dependency status. This may be different than the EFM or Federal Method values. VARCHAR2(63)

RCRAPP4

RCRAPP4_IM_FORMULA_FOR_CALC

IM_DEPENDENCY_STATUS_DESC Institution Method Dependency Status Description Institutional Method calculated dependency status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

IM_DISCRET_NET_WORTH Institution Method 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 Institution Method 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 Institution Method 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 Institution Method Home Equity Home equity used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_HME_VAL

IM_INAS Institution Method INAS The student contribution for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FOR_STDT

IM_INCOME_SUPPLEMENT Institution Method 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 Institution Method 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_MONTHLY_OTHER_VET_AMOUNT Institution Method Monthly Other Vet Amount Amount per month from other veteran educational benefit programs. NUMBER

RCRAPP1

RCRAPP1_OTH_VA_AMT

IM_MULTI_ENROLL_ADJUSTED Institution Method Multi Enrollment 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 Institution Method 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 Institution Method 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 Institution Method Other Asset Ovr Amount of the other asset (override) used in the student Institutional Method calculation. NUMBER

RCRAPP4

RCRAPP4_C_2_OTH_ASSET

IM_OTHER_VET_NUMBER_OF_MONTHS Institution Method Other Vet Number Of Months Number of months that the other veteran educational benefits will be received during the award year. NUMBER

RCRAPP1

RCRAPP1_OTH_VA_MTH

IM_PARENT_ADJUST_GROSS_INCOME Institution Method Parent Adjustment 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 Institution Method Parent Adjustment 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 Institution Method Parent Adjustment 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 Institution Method 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 Institution Method Parent Analysis Type Description Analysis type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

IM_PARENT_ASSET_PROT_ALLOWANCE Institution Method 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 Institution Method 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 Institution Method 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 Institution Method Parent Contribution Primary institutional methodology parent contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_PC

IM_PARENT_CONTRIBUTION_AMOUNT Institution Method Parent Contribution Amount Parent Institutional Method contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_P_IM_CTRB_STDT

IM_PARENT_CONTRIBUTION_ASSET Institution Method 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 Institution Method 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 Institution Method Parent Contribution 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 Institution Method Parent Contribution Off Description Description of the Institutional Method parent contribution. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)

IM_PARENT_CONVERSION_PERCENT Institution Method 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 Institution Method Parent Data Available Indicator Indicates whether parent data was available for the Institutional Method calculation. VARCHAR2(63)

RCRAPP4

RCRAPP4_IM_PAR_DATA_AVAIL

IM_PARENT_DISCRET_NET_WORTH Institution Method 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 Institution Method 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 Institution Method 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 Institution Method Parent Home Equity Home equity used in the parent's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_HME_VAL

IM_PARENT_INAS Institution Method Parent INAS The parent contribution for the Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FOR_STDT

IM_PARENT_INCOME_SUPPLEMENT Institution Method 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 Institution Method Parent Medical Dental Expiration 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 Institution Method Parent Multi Enrollment Adjustment 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method Parent State Province 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method 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 Institution Method Total Allowances Amount of total allowances used in the student's Institutional Method calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_ALLOW

IM_TOTAL_CONTRIBUTION Institution Method 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 Institution Method Total Family Contribution Primary institutional methodology total family contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_TFC

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

RCRAPP2

RCRAPP2_C_2_TOT_INC

IM_TOTAL_UNTAX_INCOME Institution Method 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 Institution Method 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 Institution Method 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 Institution Method Veteran Benefits Indicator 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 Institution Method 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 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 Interface Tape Description Description of the interface tape code. VARCHAR2(255)

RTVINFC

RTVINFC_DESC

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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

RCRAPP2

RCRAPP2_PIDM

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

NA

NA

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

RCRAPP2

RCRAPP2_USER_ID



Ver: 9.2