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

RNROVRD

RNROVRD_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)

RNROVRD

RNROVRD_AIDY_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

CALC_IM_PC_INDEPEND_STUD_IND Calculated Institution Method Parent Contribution Independ Stud Indicator Indicates whether an Institutional Method parental contribution should be calculated for an independent student. VARCHAR2(63)

RNROVRD

RNROVRD_CALC_PC_IM

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

RNROVRD

RNROVRD_ASSET_ALLOW_FM

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

RNROVRD

RNROVRD_BUDG_DUR_FM

FM_CALC_PC_INDEPEND_STUD_IND Federal Method Calculated Parent Contribution Independ Stud Indicator Indicates whether a Federal Method parental contribution should be calculated for an independent student. VARCHAR2(63)

RNROVRD

RNROVRD_CALC_PC_FM

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

RNROVRD

RNROVRD_CHG_DEPEND_FM

FM_CHANGE_DEPENDENCY_STAT_DESC Federal Method Change Dependency State Description Federal Method change dependency status description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_CHG_DEPEND_FM)

FM_MEDICAL_DENTAL_EXPENSE_ACT Federal Method 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

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

RNROVRD

RNROVRD_OTH_ASSET_FM

FM_OTHER_INCOME_ALLOWANCE Federal Method 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

FM_PARENT_ASSET_ALLOWANCE Federal Method 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

FM_PARENT_CALC_FED_TAX_OVR_IND Federal Method Parent Calculated Federal Tax Ovr Indicator 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)

FM_PARENT_MEDICAL_DENT_EXP_ACT Federal Method Parent Medical Dent Expiration Act Amount of medical and dental expenses to be included in the parent Federal Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_MED_DENT_EXP_FM

FM_PARENT_NO_COLLEGE_OVR_IND Federal Method Parent Number College Ovr Indicator One-character code to indicate if the one parent in college assumption should be overridden. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_FM_PAR_NUM_COL)

FM_PARENT_OTHER_ASSET_AMOUNT Federal Method 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

FM_PARENT_OTHER_INCOME_ALLOW Federal Method 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

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

RNROVRD

RNROVRD_PAR_TUIT_EXP_FM

FM_REJECT_A_INAS_OVR_IND Federal Method Rejection A INAS Ovr Indicator Option to override the 'birth year' reject edit (Reject A). VARCHAR2(63)

RNROVRD

RNROVRD_REJ_A_INAS_OVRD

FM_REJECT_C_INAS_OVR_IND Federal Method Rejection C INAS Ovr Indicator Option to override 'Taxes Paid = AGI' reject edit (Reject C). VARCHAR2(63)

RNROVRD

RNROVRD_REJ_C_INAS_OVRD

FM_REJECT_D_IND Federal Method Rejection D Indicator 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)

FM_REJECT_E_IND Federal Method Rejection E Indicator 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)

FM_REJECT_F_IND Federal Method Rejection F Indicator 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)

FM_REJECT_R_IND Federal Method Rejection R Indicator 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)

FM_REJECT_S_IND Federal Method Rejection S Indicator 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)

FM_REJECT_T_IND Federal Method Rejection T Indicator 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)

FM_STUD_CALC_FED_TAX_OVR_IND Federal Method Stud Calculated Federal Tax Ovr Indicator 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)

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

RNROVRD

RNROVRD_TUIT_EXP_FM

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_ADD_HOPE_LL_IND Institution Method Additional Hope Ll Indicator 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)

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

RNROVRD

RNROVRD_AGI

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

RNROVRD

RNROVRD_ASSET_ALLOW_IM

IM_ASSET_ASSESS_RATE Institution Method 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

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

RNROVRD

RNROVRD_FAMILY_ASSETS

IM_ASSET_COMBINED_DESC Institution Method Asset Combined Description Institutional Method assets combined description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_FAMILY_ASSETS)

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

RNROVRD

RNROVRD_BUDG_DUR_IM

IM_CALC_FEDERAL_TAX_OVR Institution Method Calculated 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

IM_CALC_FEDERAL_TAX_OVR_DESC Institution Method Calculated Federal Tax Ovr Description Institutional Method calculation of federal tax override description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_CALC_US_TAX_IM)

IM_CAP_HOME_EQ_FACTOR Institution Method 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

IM_CHANGE_DEPENDENCY_STATUS Institution Method Change Dependency Status Indicates whether the student dependency status should be changed for the Institutional Method calculation. VARCHAR2(63)

RNROVRD

RNROVRD_CHG_DEPEND_IM

IM_CHANGE_DEPENDENCY_STAT_DESC Institution Method Change Dependency State Description Institutional Method Change Dependency status description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_CHG_DEPEND_IM)

IM_CONTRIBUTION_PERCENT_INCR Institution Method 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

IM_COST_OF_LIVING_INDEX Institution Method 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

IM_EFM_ESTIMATED_INCOME_IND Institution Method Efm Estimated Income Indicator Indicates whether student projected year income should be used for the EFM calculation. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_USE_PROJ_INC_EFM)

IM_EFM_NUMBER_COLLEGE Institution Method Efm Number College Number-in-college to be used in the student EFM calculation. NUMBER

RNROVRD

RNROVRD_NUM_IN_COLL_EFM

IM_EFM_NUMBER_FAMILY Institution Method Efm Number Family Number-in-household to be used in the student EFM calculation. NUMBER

RNROVRD

RNROVRD_NUM_IN_HSLD_EFM

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

RNROVRD

RNROVRD_STU_EMP_ALLOW

IM_ESTIMATED_FEDERAL_TAX Institution Method 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

IM_FAMILY_NUMBER_COLLEGE Institution Method 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

IM_FEDERAL_TAX_AMOUNT Institution Method Federal Tax Amount Federal tax amount to be used for the student Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_US_TAX_AMT

IM_HOME_VALUE_CAP Institution Method 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

IM_HOME_VALUE_PROJECT Institution Method 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

IM_HOME_VALUE_PROJECT_DESC Institution Method Home Value Project Description Institutional Method home value projection description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_S_HOME_VAL_PROJ)

IM_HOUSING_MULTIPLIER STUDENT HOUSING MULTIPLIER OVERRIDE 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

IM_INCOME_ASSESS_RATE Institution Method 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

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

RNROVRD

RNROVRD_IPA_AMT

IM_LOWER_THAN_FM_IND Institution Method Lower Than Federal Method Indicator 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)

IM_MEDICAL_DENTAL_EXPENSE_ACT Institution Method 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

IM_MINIMUM_SC_ASSET Institution Method Minimum Student Contribution Asset Minimum Institutional Method contribution from assets expected from the student. NUMBER

RNROVRD

RNROVRD_MIN_SC_FROM_ASSETS

IM_MINIMUM_SC_INCOME Institution Method Minimum Student Contribution Income Minimum Institutional Method contribution from income expected from the student. NUMBER

RNROVRD

RNROVRD_MIN_SC_FROM_INC

IM_NONCUSTODIAL_CONTRIB_CALC Institution Method Noncustodial Contribution Calculated Amount of the contribution from the non-custodial parent to be added to the parent contribution. NUMBER

RNROVRD

RNROVRD_PC_NON_CUST_PAR

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

RNROVRD

RNROVRD_OTH_ASSET_IM

IM_OTHER_INCOME_ALLOWANCE Institution Method 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

IM_PARENT_ADD_HOPE_LL_IND Institution Method Parent Additional Hope Ll Indicator 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)

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

RNROVRD

RNROVRD_PAR_AGI

IM_PARENT_ASSET_ALLOWANCE Institution Method 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

IM_PARENT_ASSET_ASSESS_RATE Institution Method 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

IM_PARENT_CALC_FED_TAX_OVR Institution Method Parent Calculated Federal 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

IM_PARENT_CALC_FED_TAX_OV_DESC Institution Method Parent Calculated Federal Tax Ov Description Institutional Method parent calculation of federal tax override description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_PAR_CALC_US_TAX_IM)

IM_PARENT_CAP_HOME_EQ_FACTOR Institution Method 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

IM_PARENT_CONTRIB_PERCENT_INCR Institution Method Parent Contribution 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

IM_PARENT_COST_OF_LIVING_INDEX Institution Method 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

IM_PARENT_EFM_EST_INCOME_IND Institution Method Parent Efm Est Income Indicator Indicates whether parent projected year income should be used for the EFM calculation. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_PAR_USE_PROJ_INC_EFM)

IM_PARENT_EFM_NUMBER_COLLEGE Institution Method Parent Efm Number College Number-in-college to be used in the parent EFM calculation. NUMBER

RNROVRD

RNROVRD_PAR_NUM_IN_COLL_EFM

IM_PARENT_EFM_NUMBER_FAMILY Institution Method Parent Efm Number Family Number-in-household to be used in the parent EFM calculation. NUMBER

RNROVRD

RNROVRD_PAR_NUM_IN_HSLD_EFM

IM_PARENT_EMPLOYMENT_ALLOWANCE Institution Method Parent Employment Allowance Employment allowance to be used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_EMP_ALLOW

IM_PARENT_ESTIMATED_FED_TAX Institution Method Parent Estimated Federal Tax Estimated federal tax amount associated with projected year data used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_EST_TAX_AMT

IM_PARENT_EXCL_TUITION_FEE_IND Institution Method Parent Excl Tuition Fee Indicator Institutional methodology option disallowing tuition and fee deduction as untaxed income. VARCHAR2(63)

CALCULATION

NVL(RNROVRD_PAR_EXCL_TUIT_DED)

IM_PARENT_FAMILY_NUMBER_COLL Institution Method Parent Family Number College Number of family members in college to be used in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_NUM_IN_COLL

IM_PARENT_FEDERAL_TAX_AMOUNT Institution Method Parent Federal Tax Amount Federal tax amount to be used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_US_TAX_AMT

IM_PARENT_HOME_VALUE_CAP Institution Method 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

IM_PARENT_HOME_VALUE_PROJECT Institution Method 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

IM_PARENT_HOME_VALUE_PROJ_DESC Institution Method Parent Home Value Projected Description Institutional Method parent home value projection description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_HOME_VAL_PROJ)

IM_PARENT_HOUSING_MULTIPLIER PARENT HOUSING MULTIPLIER OVERRID 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

IM_PARENT_IMPUTE_ASSET Institution Method Parent Impute Asset Indicates if the globally set investment projection option should be turned off for this student. VARCHAR2(63)

RNROVRD

RNROVRD_INV_PROJ

IM_PARENT_IMPUTE_ASSET_DESC Institution Method Parent Impute Asset Description Institutional Method parent impute assets description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_INV_PROJ)

IM_PARENT_INCOME_PROTECT_ALLOW Institution Method Parent Income Protect Allow Income protection allowance amount to be used for the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_IPA_AMT

IM_PARENT_LOWER_THAN_FM_IND Institution Method Parent Lower Than Federal Method Indicator 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)

IM_PARENT_MEDICAL_DENT_EXP_ACT Institution Method Parent Medical Dent Expiration Act Amount of medical and dental expenses to be included in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_MED_DENT_EXP_IM

IM_PARENT_MINIMUM_PC_ASSET Institution Method Parent Minimum Parent Contribution Asset Minimum Institutional Method contribution from assets expected from the parents. NUMBER

RNROVRD

RNROVRD_MIN_PC_FROM_ASSETS

IM_PARENT_MINIMUM_PC_INCOME Institution Method Parent Minimum Parent Contribution Income The minimum Institutional Method contribution from income expected from the parents. NUMBER

RNROVRD

RNROVRD_MIN_PC_FROM_INC

IM_PARENT_NONCUST_CONT_CALC Institution Method Parent Noncust Contribution Calculated Option for overriding the Banner option regarding which non-custodial parental contribution should be passed to INAS. VARCHAR2(63)

RNROVRD

RNROVRD_NON_CUST_OPT

IM_PARENT_NONCUS_CONT_CAL_DESC Institution Method Parent Noncus Contribution Calendar Description Institutional Method non-custodial parent control calculation description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_NON_CUST_OPT)

IM_PARENT_OTHER_ASSET_AMOUNT Institution Method 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

IM_PARENT_OTHER_INCOME_ALLOW Institution Method 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

IM_PARENT_PRIOR_YEAR_PC Institution Method Parent Prior Year Parent Contribution 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

IM_PARENT_STATE_PROV_TAX_ACT Institution Method Parent State Province Tax Act Actual amount of state and local income taxes paid by the student's parents. NUMBER

RNROVRD

RNROVRD_PAR_ACT_ST_LOC_TAX

IM_PARENT_STATE_PROV_TAX_RATE Institution Method Parent State Province 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

IM_PARENT_TUITION_PAID Institution Method Parent Tuition Paid Amount of tuition expenses to be included in the parent Institutional Method calculation. NUMBER

RNROVRD

RNROVRD_PAR_TUIT_EXP_IM

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

RNROVRD

RNROVRD_PAR_UNTAX_INC

IM_PARENT_WAGE_TAX_ACTUAL Institution Method Parent Wage Tax Actual Actual amount of wage taxes paid by the student's parents. NUMBER

RNROVRD

RNROVRD_PAR_ACT_FICA

IM_PARENT_WHICH_AGI Institution Method 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

IM_PARENT_WHICH_AGI_DESC Institution Method Parent Which Agi Description Institutional Method parent which adjusted gross income description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_PAR_AGI_OPT)

IM_PARENT_ZERO_LOSS_BUS_IND Institution Method Parent Zero Loss Bus Indicator Indicates whether the Institutional Method calculation should add back to income any business/farm losses. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_ZERO_LOSS_BUS_FARM)

IM_PARENT_ZERO_LOSS_OTH_IND Institution Method Parent Zero Loss Oth Indicator 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)

IM_PRIOR_YEAR_SC Institution Method Prior Year Student Contribution 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

IM_RETIRE_ACCOUNT_PERCENT Institution Method Retirement 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

IM_SKIP_AGE_EXCLUSION_IND Institution Method Skip Age Exclusion Indicator 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)

IM_STATE_PROV_TAX_ACT Institution Method State Province Tax Act Actual amount of state and local income taxes paid by the student. NUMBER

RNROVRD

RNROVRD_ACT_ST_LOC_TAX

IM_STATE_PROV_TAX_RATE Institution Method State Province 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

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

RNROVRD

RNROVRD_TUIT_EXP_IM

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

RNROVRD

RNROVRD_UNTAX_INC

IM_USE_NONCUSTODIAL_PC_IND Institution Method Use Noncustodial Parent Contribution Indicator 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)

IM_WAGE_TAX_ACTUAL Institution Method Wage Tax Actual Actual amount of wage taxes paid by the student. NUMBER

RNROVRD

RNROVRD_ACT_FICA

LIMIT_OTHERS_SHARE_PC Limit Others Share Parent Contribution 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

LIMIT_OTHERS_SHARE_PC_DESC Limit Others Share Parent Contribution Description Limit others share of parental contribution description. VARCHAR2(255)

CALCULATION

DECODE(RNROVRD_LIMIT_PC_BY_BDGT)

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

PARENT_FSA_DEPEND_CARE_OPTION PARENT DEPENDENT CARE FSA 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

PARENT_FSA_HEALTH_CARE_OPTION PARENT HEALTH CARE FSA 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

PARENT_HSA_PRE_TAX_OPTION PARENTS HSA PRE-TAX CONTRIBUTION 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

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

RNROVRD

RNROVRD_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

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

RNROVRD

RNROVRD_STU_BUDGET

USE_PARENT_STATE_PROV_TAX_IND Use Parent State Province Tax Indicator Only use with independent students with dependents. VARCHAR2(63)

CALCULATION

DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)



Ver: 9.2