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
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RNROVRD	RNROVRD_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ALTERNATE_CONTRIB_INCOME_CALC	Indicates whether the alternate student contribution calculation should be performed.	VARCHAR2(1)	RNROVRD	RNROVRD_MIN_SC_FROM_INC_CALC	NO	NO
CALC_IM_PC_INDEPEND_STUD_IND	Indicates whether an IM parental contribution should be calculated for an independent student.	VARCHAR2(1)	RNROVRD	RNROVRD_CALC_PC_IM	NO	NO
CALC_TCA_COUNTRY_COEFFICIENT	Use the country coefficient to adjust the factors used in the determination of the total contribution from assets.	VARCHAR2(1)	RNROVRD	RNROVRD_CALC_TCA_W_CC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
FM_ASSET_ALLOWANCE	Amount of the optional asset allowance to be included in the student FM calculation.	NUMBER	RNROVRD	RNROVRD_ASSET_ALLOW_FM	NO	NO
FM_BUDGET_MONTH	Number of months to be used as the budget duration by the FM calculation.	NUMBER	RNROVRD	RNROVRD_BUDG_DUR_FM	NO	NO
FM_CALC_PC_INDEPEND_STUD_IND	Indicates whether a FM parental contribution should be calculated for an independent student.	VARCHAR2(1)	RNROVRD	RNROVRD_CALC_PC_FM	NO	NO
FM_CHANGE_DEPENDENCY_STATUS	Indicates whether the student dependency status should be changed for the FM calculation.	VARCHAR2(1)	RNROVRD	RNROVRD_CHG_DEPEND_FM	NO	NO
FM_CHANGE_DEPENDENCY_STAT_DESC	FM change dependency status description.	VARCHAR2(15)	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 FM 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 FM 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 FM 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 FM 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 FM taxes when the reported value is blank.	VARCHAR2(1)	CALCULATION	NVL(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 FM 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(1)	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 FM 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 FM 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 FM 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). This is an INAS, FM override only.	VARCHAR2(1)	RNROVRD	RNROVRD_REJ_A_INAS_OVRD	NO	NO
FM_REJECT_C_INAS_OVR_IND	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	NO	NO
FM_REJECT_D_IND	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)	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(1)	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(1)	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. This is an INAS, FM Override only.	VARCHAR2(1)	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(1)	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(1)	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 FM taxes when the reported value is blank.	VARCHAR2(1)	CALCULATION	NVL(RNROVRD_CALC_US_TAX_FM)	NO	NO
FM_TUITION_PAID	Amount of tuition expenses to be included in the student FM calculation.	NUMBER	RNROVRD	RNROVRD_TUIT_EXP_FM	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(1)	CALCULATION	NVL(RNROVRD_ADD_BK_HOPE_OPT)	NO	NO
IM_ADJUSTED_GROSS_INCOME	Amount of Adjusted Gross Income to be used in the student IM calculation.	NUMBER	RNROVRD	RNROVRD_AGI	NO	NO
IM_ANTICIPATED_US_TAX	The anticipated (base+2) U.S. tax amount to use for the student when using anticipated year income.	NUMBER	RNROVRD	RNROVRD_ANTICIPATED_US_TAX	NO	NO
IM_ASSET_ALLOWANCE	Amount of the optional asset allowance to be included in the student IM 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 IM 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(1)	RNROVRD	RNROVRD_FAMILY_ASSETS	NO	NO
IM_ASSET_COMBINED_DESC	IM assets combined description.	VARCHAR2(100)	CALCULATION	DECODE(RNROVRD_FAMILY_ASSETS)	NO	NO
IM_BUDGET_MONTH	Number of months to be used as the budget duration by the IM 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 IM taxes when the reported value is blank.	VARCHAR2(1)	RNROVRD	RNROVRD_CALC_US_TAX_IM	NO	NO
IM_CALC_FEDERAL_TAX_OVR_DESC	IM calculation of federal tax override description.	VARCHAR2(15)	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 IM calculation.	VARCHAR2(1)	RNROVRD	RNROVRD_CHG_DEPEND_IM	NO	NO
IM_CHANGE_DEPENDENCY_STAT_DESC	IM Change Dependency status description.	VARCHAR2(15)	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(1)	CALCULATION	NVL(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 IM 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 IM calculation.	NUMBER	RNROVRD	RNROVRD_EST_TAX_AMT	NO	NO
IM_FAMILY_NUMBER_COLLEGE	Number of family members in college to be used in the IM 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 IM 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 IM 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 IM calculation.	VARCHAR2(1)	RNROVRD	RNROVRD_S_HOME_VAL_PROJ	NO	NO
IM_HOME_VALUE_PROJECT_DESC	IM home value projection description.	VARCHAR2(125)	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 IM 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 IM calculation.	NUMBER	RNROVRD	RNROVRD_IPA_AMT	NO	NO
IM_LOWER_THAN_FM_IND	Indicates whether the student IM contribution can be less that the student FM contribution.	VARCHAR2(1)	CALCULATION	NVL(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 IM calculation.	NUMBER	RNROVRD	RNROVRD_MED_DENT_EXP_IM	NO	NO
IM_MINIMUM_SC_ASSET	Minimum IM contribution from assets expected from the student.	NUMBER	RNROVRD	RNROVRD_MIN_SC_FROM_ASSETS	NO	NO
IM_MINIMUM_SC_INCOME	Minimum IM 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 IM 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 IM 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(1)	CALCULATION	NVL(RNROVRD_PAR_ADD_BK_HOME_OPT)	NO	NO
IM_PARENT_ADJUST_GROSS_INCOME	Amount of Adjusted Gross Income to be used in the parent IM calculation.	NUMBER	RNROVRD	RNROVRD_PAR_AGI	NO	NO
IM_PARENT_ANTICIPATED_US_TAX	The anticipated (base+2) U.S. tax amount to use for the parents when using anticipated year income.	NUMBER	RNROVRD	RNROVRD_PAR_ANTICIPATED_US_TAX	NO	NO
IM_PARENT_ASSET_ALLOWANCE	Amount of the optional asset allowance to be included in the parent IM 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 IM 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 IM taxes when the reported value is blank.	VARCHAR2(1)	RNROVRD	RNROVRD_PAR_CALC_US_TAX_IM	NO	NO
IM_PARENT_CALC_FED_TAX_OV_DESC	IM parent calculation of federal tax override description.	VARCHAR2(15)	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 IM 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 IM 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(1)	CALCULATION	NVL(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 IM 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 IM 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(1)	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 IM calculation.	NUMBER	RNROVRD	RNROVRD_PAR_NUM_IN_COLL	NO	NO
IM_PARENT_FEDERAL_TAX_AMOUNT	Federal tax amount to be used for the parent IM 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 IM 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(1)	RNROVRD	RNROVRD_HOME_VAL_PROJ	NO	NO
IM_PARENT_HOME_VALUE_PROJ_DESC	IM parent home value projection description.	VARCHAR2(125)	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(1)	RNROVRD	RNROVRD_INV_PROJ	NO	NO
IM_PARENT_IMPUTE_ASSET_DESC	IM parent impute assets description.	VARCHAR2(125)	CALCULATION	DECODE(RNROVRD_INV_PROJ)	NO	NO
IM_PARENT_INCOME_PROTECT_ALLOW	Income protection allowance amount to be used for the parent IM calculation.	NUMBER	RNROVRD	RNROVRD_PAR_IPA_AMT	NO	NO
IM_PARENT_LOWER_THAN_FM_IND	Indicates whether the parent IM contribution can be less that the parent FM contribution.	VARCHAR2(1)	CALCULATION	NVL(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 IM calculation.	NUMBER	RNROVRD	RNROVRD_PAR_MED_DENT_EXP_IM	NO	NO
IM_PARENT_MINIMUM_PC_ASSET	Minimum IM contribution from assets expected from the parents.	NUMBER	RNROVRD	RNROVRD_MIN_PC_FROM_ASSETS	NO	NO
IM_PARENT_MINIMUM_PC_INCOME	Minimum IM 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 PC should be passed to INAS.	VARCHAR2(1)	RNROVRD	RNROVRD_NON_CUST_OPT	NO	NO
IM_PARENT_NONCUS_CONT_CAL_DESC	IM non-custodial parent control calculation description.	VARCHAR2(15)	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 IM 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 IM 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 IM 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 IM 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 IM calculation.	NUMBER	RNROVRD	RNROVRD_PAR_TUIT_EXP_IM	NO	NO
IM_PARENT_UNTAXED_INCOME	Amount of untaxed Income to be used in the parent IM 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(1)	RNROVRD	RNROVRD_PAR_AGI_OPT	NO	NO
IM_PARENT_WHICH_AGI_DESC	IM parent which adjusted gross income description.	VARCHAR2(20)	CALCULATION	DECODE(RNROVRD_PAR_AGI_OPT)	NO	NO
IM_PARENT_ZERO_LOSS_BUS_IND	Indicates whether the IM calculation should add back to income any business/farm losses.	VARCHAR2(1)	CALCULATION	NVL(RNROVRD_ZERO_LOSS_BUS_FARM)	NO	NO
IM_PARENT_ZERO_LOSS_OTH_IND	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)	NO	NO
IM_PRIOR_YEAR_SC	Student contribution from the prior year; used with IM_CONTRIBUTION_PERCENT_INCR to determine the minimum IM 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 IM net worth for an independent 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(1)	CALCULATION	NVL(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 IM calculation.	NUMBER	RNROVRD	RNROVRD_ST_LOC_TAX_RATE	NO	NO
IM_TUITION_PAID	Amount of tuition expenses to be included in the student IM calculation.	NUMBER	RNROVRD	RNROVRD_TUIT_EXP_IM	NO	NO
IM_UNTAXED_INCOME	Amount of Untaxed Income to be used in the student IM 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(1)	CALCULATION	NVL(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_IPA_INTL_STUDENT	Limit an international student's parents' IPA to an amount not greater than 25% of parental total income.	VARCHAR2(1)	RNROVRD	RNROVRD_CAP_INTL_STU_IPA	NO	NO
LIMIT_OTHERS_SHARE_PC	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	NO	NO
LIMIT_OTHERS_SHARE_PC_DESC	Limit others share of parental contribution description.	VARCHAR2(200)	CALCULATION	DECODE(RNROVRD_LIMIT_PC_BY_BDGT)	NO	NO
MIF_DESC	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	NO	NO
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	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(1)	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(1)	RNROVRD	RNROVRD_PAR_FSA_HEALTH_CARE	NO	NO
PARENT_HSA_PRE_TAX_OPTION	Overrides the global option that determines if parent dependent care FSA funds are included in untaxed income.	VARCHAR2(1)	RNROVRD	RNROVRD_PAR_HSA_PRE_TAX	NO	NO
PARENT_USE_ANT_YEAR_INCOME	This indicates if the system is to use anticipated year income (base +2) or base year income for the parents.	VARCHAR2(1)	RNROVRD	RNROVRD_PAR_USE_ANT_YR_INCOME	NO	NO
PARENT_USE_ANT_YEAR_INCOME_EFM	This indicates if the system is to use anticipated year income (base +2) or base year income for the parents for EFM.	VARCHAR2(1)	RNROVRD	RNROVRD_PAR_USE_ANT_INC_EFM	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RNROVRD	RNROVRD_PIDM	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_ANT_YEAR_INCOME	This indicates if the system is to use anticipated year income (base +2) or base year income for the student.	VARCHAR2(1)	RNROVRD	RNROVRD_USE_ANT_YR_INCOME	NO	NO
USE_ANT_YEAR_INCOME_EFM	This indicates if the system is to use anticipated year income (base +2) or base year income for the student for EFM.	VARCHAR2(1)	RNROVRD	RNROVRD_USE_ANT_INC_EFM	NO	NO
USE_PARENT_STATE_PROV_TAX_IND	Only use with independent students with dependents.	VARCHAR2(1)	CALCULATION	DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)	NO	NO
WORK_STUDY_INCOME_EXCLUSION	Indicates whether work study should always be treated as an income exclusion or only when less than or equal to 50 percent of income.	VARCHAR2(1)	RNROVRD	RNROVRD_EXCL_FWS_FR_INC_EXC	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: