Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE		RNROVRD	RNROVRD_ACTIVITY_DATE
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)		RNROVRD	RNROVRD_AIDY_CODE
AID_YEAR_DESC	Financial Aid Year Description	Financial aid year name.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
CALC_IM_PC_INDEPEND_STUD_IND	Calculated Institution Method Parent Contribution Independ Stud Indicator	Indicates whether an IM parental contribution should be calculated for an independent student.	VARCHAR2(1)		RNROVRD	RNROVRD_CALC_PC_IM
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
FM_ASSET_ALLOWANCE	Federal Method Asset Allowance	Amount of the optional asset allowance to be included in the student FM calculation.	NUMBER(5)		RNROVRD	RNROVRD_ASSET_ALLOW_FM
FM_BUDGET_MONTH	Federal Method Budget Month	Number of months to be used as the budget duration by the FM calculation.	NUMBER(2)		RNROVRD	RNROVRD_BUDG_DUR_FM
FM_CALC_PC_INDEPEND_STUD_IND	Federal Method Calculated Parent Contribution Independ Stud Indicator	Indicates whether a FM parental contribution should be calculated for an independent student.	VARCHAR2(1)		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 FM calculation.	VARCHAR2(1)		RNROVRD	RNROVRD_CHG_DEPEND_FM
FM_CHANGE_DEPENDENCY_STAT_DESC	Federal Method Change Dependency State Description	FM change dependency status description.	VARCHAR2(15)		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 FM calculation.	NUMBER(5)		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 FM calculation.	NUMBER(5)		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 FM calculation.	NUMBER(5)		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 FM calculation.	NUMBER(5)		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 FM taxes when the reported value is blank.	VARCHAR2(1)		CALCULATION	NVL(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 FM calculation.	NUMBER(5)		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(1)		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 FM calculation.	NUMBER(5)		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 FM calculation.	NUMBER(5)		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 FM calculation.	NUMBER(5)		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). This is an INAS, FM override only.	VARCHAR2(1)		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). This is an INAS, FM override only.	VARCHAR2(1)		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. This is an INAS, FM Override only.	VARCHAR2(1)		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(1)		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(1)		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. This is an INAS, FM Override only.	VARCHAR2(1)		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(1)		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(1)		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 FM taxes when the reported value is blank.	VARCHAR2(1)		CALCULATION	NVL(RNROVRD_CALC_US_TAX_FM)
FM_TUITION_PAID	Federal Method Tuition Paid	Amount of tuition expenses to be included in the student FM calculation.	NUMBER(5)		RNROVRD	RNROVRD_TUIT_EXP_FM
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(1)		CALCULATION	NVL(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 IM calculation.	NUMBER(6)		RNROVRD	RNROVRD_AGI
IM_ASSET_ALLOWANCE	Institution Method Asset Allowance	Amount of the optional asset allowance to be included in the student IM calculation.	NUMBER(6)		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 IM calculation.	NUMBER(3, 2)		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(1)		RNROVRD	RNROVRD_FAMILY_ASSETS
IM_ASSET_COMBINED_DESC	Institution Method Asset Combined Description	IM assets combined description.	VARCHAR2(100)		CALCULATION	DECODE(RNROVRD_FAMILY_ASSETS)
IM_BUDGET_MONTH	Institution Method Budget Month	Number of months to be used as the budget duration by the IM calculation.	NUMBER(3, 1)		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 IM taxes when the reported value is blank.	VARCHAR2(1)		RNROVRD	RNROVRD_CALC_US_TAX_IM
IM_CALC_FEDERAL_TAX_OVR_DESC	Institution Method Calculated Federal Tax Ovr Description	IM calculation of federal tax override description.	VARCHAR2(15)		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(2,1)		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 IM calculation.	VARCHAR2(1)		RNROVRD	RNROVRD_CHG_DEPEND_IM
IM_CHANGE_DEPENDENCY_STAT_DESC	Institution Method Change Dependency State Description	IM Change Dependency status description.	VARCHAR2(15)		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(3, 1)		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(3, 2)		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(1)		CALCULATION	NVL(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(1)		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(2)		RNROVRD	RNROVRD_NUM_IN_HSLD_EFM
IM_EMPLOYMENT_ALLOWANCE	Institution Method Employment Allowance	Employment allowance to be used for an independent student IM calculation.	NUMBER(5)		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 IM calculation.	NUMBER(5)		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 IM calculation for an independent student.	NUMBER(1)		RNROVRD	RNROVRD_STU_NUM_IN_COLL
IM_FEDERAL_TAX_AMOUNT	Institution Method Federal Tax Amount	Federal tax amount to be used for the student IM calculation.	NUMBER(5)		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 IM home value for an independent student.	NUMBER(3, 2)		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 IM calculation.	VARCHAR2(1)		RNROVRD	RNROVRD_S_HOME_VAL_PROJ
IM_HOME_VALUE_PROJECT_DESC	Institution Method Home Value Project Description	IM home value projection description.	VARCHAR2(125)		CALCULATION	DECODE(RNROVRD_S_HOME_VAL_PROJ)
IM_INCOME_ASSESS_RATE	Institution Method Income Assess Rate	Income assessment percentage (e.g. 075=75%) to be used in the IM calculation for dependent students or for independents without dependents.	NUMBER(3, 2)		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 IM calculation.	NUMBER(5)		RNROVRD	RNROVRD_IPA_AMT
IM_LOWER_THAN_FM_IND	Institution Method Lower Than Federal Method Indicator	Indicates whether the student IM contribution can be less that the student FM contribution.	VARCHAR2(1)		CALCULATION	NVL(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 IM calculation.	NUMBER(5)		RNROVRD	RNROVRD_MED_DENT_EXP_IM
IM_MINIMUM_SC_ASSET	Institution Method Minimum Student Contribution Asset	Minimum IM contribution from assets expected from the student.	NUMBER(5)		RNROVRD	RNROVRD_MIN_SC_FROM_ASSETS
IM_MINIMUM_SC_INCOME	Institution Method Minimum Student Contribution Income	Minimum IM contribution from income expected from the student.	NUMBER(5)		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(5)		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 IM calculation.	NUMBER(5)		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 IM calculation.	NUMBER(5)		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(1)		CALCULATION	NVL(RNROVRD_PAR_ADD_BK_HOME_OPT)
IM_PARENT_ADJUST_GROSS_INCOME	Institution Method Parent Adjustment Gross Income	Amount of Adjusted Gross Income to be used in the parent IM calculation.	NUMBER(6)		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 IM calculation.	NUMBER(6)		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 IM calculation.	NUMBER(3, 2)		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 IM taxes when the reported value is blank.	VARCHAR2(1)		RNROVRD	RNROVRD_PAR_CALC_US_TAX_IM
IM_PARENT_CALC_FED_TAX_OV_DESC	Institution Method Parent Calculated Federal Tax Ov Description	IM parent calculation of federal tax override description.	VARCHAR2(15)		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(2,1)		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 IM parental contribution should, at a minimum, exceed the prior year parental contribution.	NUMBER(3, 1)		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 IM income protection allowance for the parents.	NUMBER(3, 2)		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(1)		CALCULATION	NVL(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(1)		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(2)		RNROVRD	RNROVRD_PAR_NUM_IN_HSLD_EFM
IM_PARENT_EMPLOYMENT_ALLOWANCE	Institution Method Parent Employment Allowance	Employment allowance to be used for the parent IM calculation.	NUMBER(5)		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 IM calculation.	NUMBER(5)		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(1)		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 IM calculation.	NUMBER(1)		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 IM calculation.	NUMBER(5)		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 IM parent home value.	NUMBER(3, 2)		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(1)		RNROVRD	RNROVRD_HOME_VAL_PROJ
IM_PARENT_HOME_VALUE_PROJ_DESC	Institution Method Parent Home Value Projected Description	IM parent home value projection description.	VARCHAR2(125)		CALCULATION	DECODE(RNROVRD_HOME_VAL_PROJ)
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(1)		RNROVRD	RNROVRD_INV_PROJ
IM_PARENT_IMPUTE_ASSET_DESC	Institution Method Parent Impute Asset Description	IM parent impute assets description.	VARCHAR2(125)		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 IM calculation.	NUMBER(5)		RNROVRD	RNROVRD_PAR_IPA_AMT
IM_PARENT_LOWER_THAN_FM_IND	Institution Method Parent Lower Than Federal Method Indicator	Indicates whether the parent IM contribution can be less that the parent FM contribution.	VARCHAR2(1)		CALCULATION	NVL(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 IM calculation.	NUMBER(5)		RNROVRD	RNROVRD_PAR_MED_DENT_EXP_IM
IM_PARENT_MINIMUM_PC_ASSET	Institution Method Parent Minimum Parent Contribution Asset	Minimum IM contribution from assets expected from the parents.	NUMBER(5)		RNROVRD	RNROVRD_MIN_PC_FROM_ASSETS
IM_PARENT_MINIMUM_PC_INCOME	Institution Method Parent Minimum Parent Contribution Income	Minimum IM contribution from income expected from the parents.	NUMBER(5)		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 PC should be passed to INAS.	VARCHAR2(1)		RNROVRD	RNROVRD_NON_CUST_OPT
IM_PARENT_NONCUS_CONT_CAL_DESC	Institution Method Parent Noncus Contribution Calendar Description	IM non-custodial parent control calculation description.	VARCHAR2(15)		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 IM calculation.	NUMBER(5)		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 IM calculation.	NUMBER(5)		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 IM parental contribution for the current year.	NUMBER(5)		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(5)		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 IM calculation.	NUMBER(2, 2)		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 IM calculation.	NUMBER(5)		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 IM calculation.	NUMBER(5)		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(5)		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(1)		RNROVRD	RNROVRD_PAR_AGI_OPT
IM_PARENT_WHICH_AGI_DESC	Institution Method Parent Which Agi Description	IM parent which adjusted gross income description.	VARCHAR2(20)		CALCULATION	DECODE(RNROVRD_PAR_AGI_OPT)
IM_PARENT_ZERO_LOSS_BUS_IND	Institution Method Parent Zero Loss Bus Indicator	Indicates whether the IM calculation should add back to income any business/farm losses.	VARCHAR2(1)		CALCULATION	NVL(RNROVRD_ZERO_LOSS_BUS_FARM)
IM_PARENT_ZERO_LOSS_OTH_IND	Institution Method Parent Zero Loss Oth Indicator	Indicates whether the IM calculation should add back to income any losses associated with other taxable income.	VARCHAR2(1)		CALCULATION	NVL(RNROVRD_ZERO_LOSS_OTH)
IM_PRIOR_YEAR_SC	Institution Method Prior Year Student Contribution	Student contribution from the prior year; used with IM_CONTRIBUTION_PERCENT_INCR to determine the minimum IM student contribution for the current year.	NUMBER(5)		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 IM net worth for an independent student.	NUMBER(3,2)		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(1)		CALCULATION	NVL(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(5)		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 IM calculation.	NUMBER(2,2)		RNROVRD	RNROVRD_ST_LOC_TAX_RATE
IM_TUITION_PAID	Institution Method Tuition Paid	Amount of tuition expenses to be included in the student IM calculation.	NUMBER(5)		RNROVRD	RNROVRD_TUIT_EXP_IM
IM_UNTAXED_INCOME	Institution Method Untaxed Income	Amount of Untaxed Income to be used in the student IM calculation.	NUMBER(5)		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(1)		CALCULATION	NVL(RNROVRD_NON_CUST_PC_OPT)
IM_WAGE_TAX_ACTUAL	Institution Method Wage Tax Actual	Actual amount of wage taxes paid by the student.	NUMBER(5)		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 PC based on sum or percentage of budget.	VARCHAR2(1)		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(200)		CALCULATION	DECODE(RNROVRD_LIMIT_PC_BY_BDGT)
MIF_DESC	MIF Description	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)		NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RNROVRD	RNROVRD_PIDM
TOTAL_BUDGET	Total Budget	Actual student budget amount used to override the global options regarding average total budgets.	NUMBER(5)		RNROVRD	RNROVRD_STU_BUDGET
USE_PARENT_STATE_PROV_TAX_IND	Use Parent State Province Tax Indicator	Only use with independent students with dependents.	VARCHAR2(1)		CALCULATION	DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: