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_OVERRIDE

Description Descriptive text about the reporting view or composite table, fact or dimension table. This is used by the technical writer to pull into documentation as the Description for the view.
Key & Frequency One row per Aid Year per Person.
Recommended Search Columns AID_YEAR, PERSON_UID

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

RNROVRD

RNROVRD_ACTIVITY_DATE

NO

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

NA

NA

NO

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

RNROVRD

RNROVRD_AIDY_CODE

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
CALC_IM_PC_INDEPEND_STUD_IND Indicates whether an Institutional Method parental contribution should be calculated for an independent student. VARCHAR2(63)

RNROVRD

RNROVRD_CALC_PC_IM

NO

NO
FM_ASSET_ALLOWANCE Amount of the optional asset allowance to be included in the student Federal Method calculation. NUMBER

RNROVRD

RNROVRD_ASSET_ALLOW_FM

NO

NO
FM_BUDGET_MONTH Number of months to be used as the budget duration by the Federal Method calculation. NUMBER

RNROVRD

RNROVRD_BUDG_DUR_FM

NO

NO
FM_CALC_PC_INDEPEND_STUD_IND Indicates whether a Federal Method parental contribution should be calculated for an independent student. VARCHAR2(63)

RNROVRD

RNROVRD_CALC_PC_FM

NO

NO
FM_CHANGE_DEPENDENCY_STATUS Indicates whether the student dependency status should be changed for the Federal Method calculation. VARCHAR2(63)

RNROVRD

RNROVRD_CHG_DEPEND_FM

NO

NO
FM_CHANGE_DEPENDENCY_STAT_DESC Federal Method change dependency status description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_CHG_DEPEND_FM)

NO

NO
FM_MEDICAL_DENTAL_EXPENSE_ACT Amount of medical and dental expenses to be included in the student Federal Method calculation. NUMBER

RNROVRD

RNROVRD_MED_DENT_EXP_FM

NO

NO
FM_OTHER_ASSET_AMOUNT Amount of the optional other asset to be included in the student Federal Method calculation. NUMBER

RNROVRD

RNROVRD_OTH_ASSET_FM

NO

NO
FM_OTHER_INCOME_ALLOWANCE Amount of the optional other income allowance to be included in the student Federal Method calculation. NUMBER

RNROVRD

RNROVRD_OTH_INC_ALLOW_FM

NO

NO
FM_PARENT_ASSET_ALLOWANCE Amount of the optional asset allowance to be included in the parent Federal Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_ASSET_ALLOW_FM

NO

NO
FM_PARENT_CALC_FED_TAX_OVR_IND Represents the option for overriding the global option regarding calculation of parent Federal Method taxes when the reported value is blank. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_PAR_CALC_US_TAX_FM)

NO

NO
FM_PARENT_MEDICAL_DENT_EXP_ACT Amount of medical and dental expenses to be included in the parent Federal Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_MED_DENT_EXP_FM

NO

NO
FM_PARENT_NO_COLLEGE_OVR_IND One-character code to indicate if the one parent in college assumption should be overridden. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_FM_PAR_NUM_COL)

NO

NO
FM_PARENT_OTHER_ASSET_AMOUNT Amount of the optional other asset to be included in the parent Federal Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_OTH_ASSET_FM

NO

NO
FM_PARENT_OTHER_INCOME_ALLOW Amount of the optional other income allowance to be included in the parent Federal Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_OTH_INC_ALLOW_FM

NO

NO
FM_PARENT_TUITION_PAID Amount of tuition expenses to be included in the parent Federal Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_TUIT_EXP_FM

NO

NO
FM_REJECT_A_INAS_OVR_IND Option to override the 'birth year' reject edit (Reject A). VARCHAR2(63)

RNROVRD

RNROVRD_REJ_A_INAS_OVRD

NO

NO
FM_REJECT_C_INAS_OVR_IND Option to override 'Taxes Paid = AGI' reject edit (Reject C). VARCHAR2(63)

RNROVRD

RNROVRD_REJ_C_INAS_OVRD

NO

NO
FM_REJECT_D_IND Option to suppress the "Student's Social Security Match but no name match" reject edit. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_SSN_NO_NAME_REJ_OVRD)

NO

NO
FM_REJECT_E_IND Option to suppress the "Father's Social Security Match but no name match" reject edit. This is an INAS, FM Override only. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_F_SSN_NO_NAME_REJ_OVRD)

NO

NO
FM_REJECT_F_IND Option to suppress the "Mother's Social Security Match but no name match" reject edit. This is an INAS, FM Override only. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_M_SSN_NO_NAME_REJ_OVRD)

NO

NO
FM_REJECT_R_IND Option to suppress the "Social Security Match but no date of birth match" reject edit. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_SSN_NO_DOB_REJ_OVRD)

NO

NO
FM_REJECT_S_IND Option to suppress the "Father's Social Security Match but no date of birth match" reject edit. This is an INAS, FM Override only. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_F_SSN_NO_DOB_REJ_OVRD)

NO

NO
FM_REJECT_T_IND Option to suppress the "Mother's Social Security Match but no date of birth match" reject edit. This is an INAS, FM Override only. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_M_SSN_NO_DOB_REJ_OVRD)

NO

NO
FM_STUD_CALC_FED_TAX_OVR_IND Represents the option for overriding the global option regarding calculation of student Federal Method taxes when the reported value is blank. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_CALC_US_TAX_FM)

NO

NO
FM_TUITION_PAID Amount of tuition expenses to be included in the student Federal Method calculation. NUMBER

RNROVRD

RNROVRD_TUIT_EXP_FM

NO

NO
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

NO

NO
IM_ADD_HOPE_LL_IND Option to add back the amount reported by the student for the Hope and Lifetime Learning tax credits to federal taxes paid. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_ADD_BK_HOPE_OPT)

NO

NO
IM_ADJUSTED_GROSS_INCOME Amount of Adjusted Gross Income to be used in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_AGI

NO

NO
IM_ASSET_ALLOWANCE Amount of the optional asset allowance to be included in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_ASSET_ALLOW_IM

NO

NO
IM_ASSET_ASSESS_RATE Asset assessment percentage (e.g. 075=75%) to be used in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_ASSET_ASSESS_PCT

NO

NO
IM_ASSET_COMBINED One-character code to indicate if student assets are to be combined with parents' assets. VARCHAR2(63)

RNROVRD

RNROVRD_FAMILY_ASSETS

NO

NO
IM_ASSET_COMBINED_DESC Institutional Method assets combined description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_FAMILY_ASSETS)

NO

NO
IM_BUDGET_MONTH Number of months to be used as the budget duration by the Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_BUDG_DUR_IM

NO

NO
IM_CALC_FEDERAL_TAX_OVR Represents the option for overriding the global option regarding calculation of student Institutional Method taxes when the reported value is blank. VARCHAR2(63)

RNROVRD

RNROVRD_CALC_US_TAX_IM

NO

NO
IM_CALC_FEDERAL_TAX_OVR_DESC Institutional Method calculation of federal tax override description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_CALC_US_TAX_IM)

NO

NO
IM_CAP_HOME_EQ_FACTOR If option is chosen, an independent student's final home equity will be capped at 0.0 to 9.9 times income. NUMBER

RNROVRD

RNROVRD_CAP_EQT_FACTOR

NO

NO
IM_CHANGE_DEPENDENCY_STATUS Indicates whether the student dependency status should be changed for the Institutional Method calculation. VARCHAR2(63)

RNROVRD

RNROVRD_CHG_DEPEND_IM

NO

NO
IM_CHANGE_DEPENDENCY_STAT_DESC Institutional Method Change Dependency status description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_CHG_DEPEND_IM)

NO

NO
IM_CONTRIBUTION_PERCENT_INCR Percentage (e.g. 125=12.5%) that the current IM student contribution should, at a minimum, exceed the prior year student contribution. NUMBER

RNROVRD

RNROVRD_SC_PCT_INCREASE

NO

NO
IM_COST_OF_LIVING_INDEX Index (e.g. 090=90%, 136=136%) to be used for calculating the IM income protection allowance for an independent student. NUMBER

RNROVRD

RNROVRD_STU_COST_LIV_INDEX

NO

NO
IM_EFM_ESTIMATED_INCOME_IND Indicates whether student projected year income should be used for the EFM calculation. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_USE_PROJ_INC_EFM)

NO

NO
IM_EFM_NUMBER_COLLEGE Number-in-college to be used in the student EFM calculation. NUMBER

RNROVRD

RNROVRD_NUM_IN_COLL_EFM

NO

NO
IM_EFM_NUMBER_FAMILY Number-in-household to be used in the student EFM calculation. NUMBER

RNROVRD

RNROVRD_NUM_IN_HSLD_EFM

NO

NO
IM_EMPLOYMENT_ALLOWANCE Employment allowance to be used for an independent student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_STU_EMP_ALLOW

NO

NO
IM_ESTIMATED_FEDERAL_TAX Estimated federal tax amount associated with projected year data used for the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_EST_TAX_AMT

NO

NO
IM_FAMILY_NUMBER_COLLEGE Number of family members in college to be used in the Institutional Method calculation for an independent student. NUMBER

RNROVRD

RNROVRD_STU_NUM_IN_COLL

NO

NO
IM_FEDERAL_TAX_AMOUNT Federal tax amount to be used for the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_US_TAX_AMT

NO

NO
IM_HOME_VALUE_CAP Cap, represented as a multiple of income (e.g. 250=2.50 times income), on the calculated Institutional Method home value for an independent student. NUMBER

RNROVRD

RNROVRD_HOME_VAL_CAP

NO

NO
IM_HOME_VALUE_PROJECT Indicates the option to be used when computing home value for an independent student in the Institutional Method calculation. VARCHAR2(63)

RNROVRD

RNROVRD_S_HOME_VAL_PROJ

NO

NO
IM_HOME_VALUE_PROJECT_DESC Institutional Method home value projection description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_S_HOME_VAL_PROJ)

NO

NO
IM_HOUSING_MULTIPLIER Projected student home value percentage (e.g. 1.50=1.5%) to be used to project current home value based on home purchase price for an independent student. NUMBER

RNROVRD

RNROVRD_HSG_MULT_OVRD

NO

NO
IM_INCOME_ASSESS_RATE Income assessment percentage (e.g. 075=75%) to be used in the Institutional Method calculation for dependent students or for independents without dependents. NUMBER

RNROVRD

RNROVRD_INC_ASSESS_RATE

NO

NO
IM_INCOME_PROTECT_ALLOWANCE Income protection allowance amount to be used for an independent student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_IPA_AMT

NO

NO
IM_LOWER_THAN_FM_IND Indicates whether the student Institutional Method contribution can be less that the student Federal Method contribution. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_ALLOW_IM_SC_LOWR_FM)

NO

NO
IM_MEDICAL_DENTAL_EXPENSE_ACT Amount of medical and dental expenses to be included in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_MED_DENT_EXP_IM

NO

NO
IM_MINIMUM_SC_ASSET Minimum Institutional Method contribution from assets expected from the student. NUMBER

RNROVRD

RNROVRD_MIN_SC_FROM_ASSETS

NO

NO
IM_MINIMUM_SC_INCOME Minimum Institutional Method contribution from income expected from the student. NUMBER

RNROVRD

RNROVRD_MIN_SC_FROM_INC

NO

NO
IM_NONCUSTODIAL_CONTRIB_CALC Amount of the contribution from the non-custodial parent to be added to the parent contribution. NUMBER

RNROVRD

RNROVRD_PC_NON_CUST_PAR

NO

NO
IM_OTHER_ASSET_AMOUNT Amount of the optional other asset to be included in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_OTH_ASSET_IM

NO

NO
IM_OTHER_INCOME_ALLOWANCE Amount of the optional other income allowance to be included in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_OTH_INC_ALLOW_IM

NO

NO
IM_PARENT_ADD_HOPE_LL_IND Option to add back the amount reported by the parent for the Hope and Lifetime Learning tax credits to federal taxes paid. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_PAR_ADD_BK_HOPE_OPT)

NO

NO
IM_PARENT_ADJUST_GROSS_INCOME Amount of Adjusted Gross Income to be used in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_AGI

NO

NO
IM_PARENT_ASSET_ALLOWANCE Amount of the optional asset allowance to be included in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_ASSET_ALLOW_IM

NO

NO
IM_PARENT_ASSET_ASSESS_RATE Asset assessment percentage (e.g. 075=75%) to be used in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_ASSET_ASSESS_PCT

NO

NO
IM_PARENT_CALC_FED_TAX_OVR Represents the option for overriding the global option regarding calculation of parent Institutional Method taxes when the reported value is blank. VARCHAR2(63)

RNROVRD

RNROVRD_PAR_CALC_US_TAX_IM

NO

NO
IM_PARENT_CALC_FED_TAX_OV_DESC Institutional Method parent calculation of federal tax override description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_PAR_CALC_US_TAX_IM)

NO

NO
IM_PARENT_CAP_HOME_EQ_FACTOR If option is chosen, the parents' final home equity will be capped at 0.0 to 9.9 times income. NUMBER

RNROVRD

RNROVRD_PAR_CAP_EQT_FACTOR

NO

NO
IM_PARENT_CONTRIB_PERCENT_INCR Percentage (e.g. 125=12.5%) that the current Institutional Method parental contribution should, at a minimum, exceed the prior year parental contribution. NUMBER

RNROVRD

RNROVRD_PC_PCT_INCREASE

NO

NO
IM_PARENT_COST_OF_LIVING_INDEX Index (e.g. 090=90%, 136=136%) to be used for calculating the Institutional Method income protection allowance for the parents. NUMBER

RNROVRD

RNROVRD_PAR_COST_LIV_INDEX

NO

NO
IM_PARENT_EFM_EST_INCOME_IND Indicates whether parent projected year income should be used for the EFM calculation. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM)

NO

NO
IM_PARENT_EFM_NUMBER_COLLEGE Number-in-college to be used in the parent EFM calculation. NUMBER

RNROVRD

RNROVRD_PAR_NUM_IN_COLL_EFM

NO

NO
IM_PARENT_EFM_NUMBER_FAMILY Number-in-household to be used in the parent EFM calculation. NUMBER

RNROVRD

RNROVRD_PAR_NUM_IN_HSLD_EFM

NO

NO
IM_PARENT_EMPLOYMENT_ALLOWANCE Employment allowance to be used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_EMP_ALLOW

NO

NO
IM_PARENT_ESTIMATED_FED_TAX Estimated federal tax amount associated with projected year data used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_EST_TAX_AMT

NO

NO
IM_PARENT_EXCL_TUITION_FEE_IND Institutional methodology option disallowing tuition and fee deduction as untaxed income. VARCHAR2(63)

CALCULATION

NVL(RNROVRD_PAR_EXCL_TUIT_DED)

NO

NO
IM_PARENT_FAMILY_NUMBER_COLL Number of family members in college to be used in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_NUM_IN_COLL

NO

NO
IM_PARENT_FEDERAL_TAX_AMOUNT Federal tax amount to be used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_US_TAX_AMT

NO

NO
IM_PARENT_HOME_VALUE_CAP Cap, represented as a multiple of income (e.g. 250=2.50 times income), on the calculated Institutional Method parent home value. NUMBER

RNROVRD

RNROVRD_PAR_HOME_VAL_CAP

NO

NO
IM_PARENT_HOME_VALUE_PROJECT Indicates if the globally set home value projection option should be turned off for this student. VARCHAR2(63)

RNROVRD

RNROVRD_HOME_VAL_PROJ

NO

NO
IM_PARENT_HOME_VALUE_PROJ_DESC Institutional Method parent home value projection description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_HOME_VAL_PROJ)

NO

NO
IM_PARENT_HOUSING_MULTIPLIER Projected parent home value percentage (e.g. 1.50=1.5%) to be used to project current home value based on home purchase price for parents of a dependent student. NUMBER

RNROVRD

RNROVRD_PAR_HSG_MULT_OVRD

NO

NO
IM_PARENT_IMPUTE_ASSET Indicates if the globally set investment projection option should be turned off for this student. VARCHAR2(63)

RNROVRD

RNROVRD_INV_PROJ

NO

NO
IM_PARENT_IMPUTE_ASSET_DESC Institutional Method parent impute assets description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_INV_PROJ)

NO

NO
IM_PARENT_INCOME_PROTECT_ALLOW Income protection allowance amount to be used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_IPA_AMT

NO

NO
IM_PARENT_LOWER_THAN_FM_IND Indicates whether the parent Institutional Method contribution can be less that the parent Federal Method contribution. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_ALLOW_IM_PC_LOWR_FM)

NO

NO
IM_PARENT_MEDICAL_DENT_EXP_ACT Amount of medical and dental expenses to be included in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_MED_DENT_EXP_IM

NO

NO
IM_PARENT_MINIMUM_PC_ASSET Minimum Institutional Method contribution from assets expected from the parents. NUMBER

RNROVRD

RNROVRD_MIN_PC_FROM_ASSETS

NO

NO
IM_PARENT_MINIMUM_PC_INCOME The minimum Institutional Method contribution from income expected from the parents. NUMBER

RNROVRD

RNROVRD_MIN_PC_FROM_INC

NO

NO
IM_PARENT_NONCUST_CONT_CALC Option for overriding the Banner option regarding which non-custodial parental contribution should be passed to INAS. VARCHAR2(63)

RNROVRD

RNROVRD_NON_CUST_OPT

NO

NO
IM_PARENT_NONCUS_CONT_CAL_DESC Institutional Method non-custodial parent control calculation description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_NON_CUST_OPT)

NO

NO
IM_PARENT_OTHER_ASSET_AMOUNT Amount of the optional other asset to be included in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_OTH_ASSET_IM

NO

NO
IM_PARENT_OTHER_INCOME_ALLOW Amount of the optional other income allowance to be included in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_OTH_INC_ALLOW_IM

NO

NO
IM_PARENT_PRIOR_YEAR_PC Parent contribution from the prior year; used with IM_PARENT_CONTRIB_PCNT_INCR to determine the minimum Institutional Method parental contribution for the current year. NUMBER

RNROVRD

RNROVRD_PRIOR_YR_PC

NO

NO
IM_PARENT_STATE_PROV_TAX_ACT Actual amount of state and local income taxes paid by the student's parents. NUMBER

RNROVRD

RNROVRD_PAR_ACT_ST_LOC_TAX

NO

NO
IM_PARENT_STATE_PROV_TAX_RATE Tax rate (e.g. 07=7%) to be used to calculate state and local taxes during the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_ST_LOC_TAX_RATE

NO

NO
IM_PARENT_TUITION_PAID Amount of tuition expenses to be included in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_TUIT_EXP_IM

NO

NO
IM_PARENT_UNTAXED_INCOME Amount of untaxed Income to be used in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_UNTAX_INC

NO

NO
IM_PARENT_WAGE_TAX_ACTUAL Actual amount of wage taxes paid by the student's parents. NUMBER

RNROVRD

RNROVRD_PAR_ACT_FICA

NO

NO
IM_PARENT_WHICH_AGI Option for overriding the global option regarding which (reported or calculated) adjusted gross income to use. VARCHAR2(63)

RNROVRD

RNROVRD_PAR_AGI_OPT

NO

NO
IM_PARENT_WHICH_AGI_DESC Institutional Method parent which adjusted gross income description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_PAR_AGI_OPT)

NO

NO
IM_PARENT_ZERO_LOSS_BUS_IND Indicates whether the Institutional Method calculation should add back to income any business/farm losses. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_ZERO_LOSS_BUS_FARM)

NO

NO
IM_PARENT_ZERO_LOSS_OTH_IND Indicates whether the Institutional Method calculation should add back to income any losses associated with other taxable income. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_ZERO_LOSS_OTH)

NO

NO
IM_PRIOR_YEAR_SC Student contribution from the prior year; used with IM_CONTRIB_PCNT_INCR to determine the minimum Institutional Method student contribution for the current year. NUMBER

RNROVRD

RNROVRD_PRIOR_YR_SC

NO

NO
IM_RETIRE_ACCOUNT_PERCENT Percentage (e.g. 075=75%) of retirement account (such as IRA/KEOGH) to be included in the Institutional Method net worth for a student. NUMBER

RNROVRD

RNROVRD_IRA_KEOGH_PCT

NO

NO
IM_SKIP_AGE_EXCLUSION_IND Option for overriding the global options regarding exclusion of family members from number in family/college based on age. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_SKIP_AGE_EXCL)

NO

NO
IM_STATE_PROV_TAX_ACT Actual amount of state and local income taxes paid by the student. NUMBER

RNROVRD

RNROVRD_ACT_ST_LOC_TAX

NO

NO
IM_STATE_PROV_TAX_RATE Tax rate (e.g. 07=7%) to be used to calculate state and local taxes during the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_ST_LOC_TAX_RATE

NO

NO
IM_TUITION_PAID Amount of tuition expenses to be included in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_TUIT_EXP_IM

NO

NO
IM_UNTAXED_INCOME Amount of Untaxed Income to be used in the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_UNTAX_INC

NO

NO
IM_USE_NONCUSTODIAL_PC_IND Option for overriding the global option regarding increasing of the custodial parents PC by the non-custodial PC. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_NON_CUST_PC_OPT)

NO

NO
IM_WAGE_TAX_ACTUAL Actual amount of wage taxes paid by the student. NUMBER

RNROVRD

RNROVRD_ACT_FICA

NO

NO
LIMIT_OTHERS_SHARE_PC Option for overriding the global option regarding limiting family members share of parental contribution based on sum or percentage of budget. VARCHAR2(63)

RNROVRD

RNROVRD_LIMIT_PC_BY_BDGT

NO

NO
LIMIT_OTHERS_SHARE_PC_DESC Limit others share of parental contribution description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_LIMIT_PC_BY_BDGT)

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PARENT_FSA_DEPEND_CARE_OPTION Overrides the global option that determines if parent dependent care FSA funds are included in untaxed income. VARCHAR2(63)

RNROVRD

RNROVRD_PAR_FSA_DEPENDENT_CARE

NO

NO
PARENT_FSA_HEALTH_CARE_OPTION Overrides the global option that determines if parent health care FSA funds are included in untaxed income. VARCHAR2(63)

RNROVRD

RNROVRD_PAR_FSA_HEALTH_CARE

NO

NO
PARENT_HSA_PRE_TAX_OPTION Overrides the global option that determines if parent HSA pre-tax contributions are included as untaxed income. VARCHAR2(63)

RNROVRD

RNROVRD_PAR_HSA_PRE_TAX

NO

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

RNROVRD

RNROVRD_PIDM

NO

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

NA

NA

NO

NO
TOTAL_BUDGET Actual student budget amount; used to override the global options regarding average total budgets. NUMBER

RNROVRD

RNROVRD_STU_BUDGET

NO

NO
USE_PARENT_STATE_PROV_TAX_IND Only use with independent students with dependents. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)

NO

NO


Ver: 9.2