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