Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_NEED_ANALYSIS_OVERRIDE

Description This view returns rows of override information for aid year and person.
Key & Frequency One row per aid year per person.

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

RNROVRD

RNROVRD_ACTIVITY_DATE

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 name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

FM_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 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 Indicates whether a FM parental contribution should be calculated for an independent student. VARCHAR2(1)

RNROVRD

RNROVRD_CALC_PC_FM

FM_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 FM change dependency status description. VARCHAR2(15)

CALCULATION

DECODE(RNROVRD_CHG_DEPEND_FM)

FM_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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Amount of tuition expenses to be included in the student FM calculation. NUMBER(5)

RNROVRD

RNROVRD_TUIT_EXP_FM

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)

IM_ADJUSTED_GROSS_INCOME Amount of Adjusted Gross Income to be used in the student IM calculation. NUMBER(6)

RNROVRD

RNROVRD_AGI

IM_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 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 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 IM assets combined description. VARCHAR2(100)

CALCULATION

DECODE(RNROVRD_FAMILY_ASSETS)

IM_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 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 IM calculation of federal tax override description. VARCHAR2(15)

CALCULATION

DECODE(RNROVRD_CALC_US_TAX_IM)

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(2,1)

RNROVRD

RNROVRD_CAP_EQT_FACTOR

IM_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 IM Change Dependency status description. VARCHAR2(15)

CALCULATION

DECODE(RNROVRD_CHG_DEPEND_IM)

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(3, 1)

RNROVRD

RNROVRD_SC_PCT_INCREASE

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(3, 2)

RNROVRD

RNROVRD_STU_COST_LIV_INDEX

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)

IM_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 Number-in-household to be used in the student EFM calculation. NUMBER(2)

RNROVRD

RNROVRD_NUM_IN_HSLD_EFM

IM_EMPLOYMENT_ALLOWANCE Employment allowance to be used for an independent student IM calculation. NUMBER(5)

RNROVRD

RNROVRD_STU_EMP_ALLOW

IM_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 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 Federal tax amount to be used for the student IM calculation. NUMBER(5)

RNROVRD

RNROVRD_US_TAX_AMT

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(3, 2)

RNROVRD

RNROVRD_HOME_VAL_CAP

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

IM_HOME_VALUE_PROJECT_DESC IM home value projection description. VARCHAR2(125)

CALCULATION

DECODE(RNROVRD_S_HOME_VAL_PROJ)

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(3, 2)

RNROVRD

RNROVRD_INC_ASSESS_RATE

IM_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 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 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 Minimum IM contribution from assets expected from the student. NUMBER(5)

RNROVRD

RNROVRD_MIN_SC_FROM_ASSETS

IM_MINIMUM_SC_INCOME Minimum IM contribution from income expected from the student. NUMBER(5)

RNROVRD

RNROVRD_MIN_SC_FROM_INC

IM_NONCUSTODIAL_CONTRIB_CALC 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 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 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 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 Amount of Adjusted Gross Income to be used in the parent IM calculation. NUMBER(6)

RNROVRD

RNROVRD_PAR_AGI

IM_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 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 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 IM parent calculation of federal tax override description. VARCHAR2(15)

CALCULATION

DECODE(RNROVRD_PAR_CALC_US_TAX_IM)

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(2,1)

RNROVRD

RNROVRD_PAR_CAP_EQT_FACTOR

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(3, 1)

RNROVRD

RNROVRD_PC_PCT_INCREASE

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(3, 2)

RNROVRD

RNROVRD_PAR_COST_LIV_INDEX

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)

IM_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 Number-in-household to be used in the parent EFM calculation. NUMBER(2)

RNROVRD

RNROVRD_PAR_NUM_IN_HSLD_EFM

IM_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 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 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 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 Federal tax amount to be used for the parent IM calculation. NUMBER(5)

RNROVRD

RNROVRD_PAR_US_TAX_AMT

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(3, 2)

RNROVRD

RNROVRD_PAR_HOME_VAL_CAP

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

IM_PARENT_HOME_VALUE_PROJ_DESC IM parent home value projection description. VARCHAR2(125)

CALCULATION

DECODE(RNROVRD_HOME_VAL_PROJ)

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

IM_PARENT_IMPUTE_ASSET_DESC IM parent impute assets description. VARCHAR2(125)

CALCULATION

DECODE(RNROVRD_INV_PROJ)

IM_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 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 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 Minimum IM contribution from assets expected from the parents. NUMBER(5)

RNROVRD

RNROVRD_MIN_PC_FROM_ASSETS

IM_PARENT_MINIMUM_PC_INCOME Minimum IM contribution from income expected from the parents. NUMBER(5)

RNROVRD

RNROVRD_MIN_PC_FROM_INC

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

IM_PARENT_NONCUS_CONT_CAL_DESC IM non-custodial parent control calculation description. VARCHAR2(15)

CALCULATION

DECODE(RNROVRD_NON_CUST_OPT)

IM_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 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 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 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 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 Amount of tuition expenses to be included in the parent IM calculation. NUMBER(5)

RNROVRD

RNROVRD_PAR_TUIT_EXP_IM

IM_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 Actual amount of wage taxes paid by the student's parents. NUMBER(5)

RNROVRD

RNROVRD_PAR_ACT_FICA

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

IM_PARENT_WHICH_AGI_DESC IM parent which adjusted gross income description. VARCHAR2(20)

CALCULATION

DECODE(RNROVRD_PAR_AGI_OPT)

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)

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)

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

RNROVRD

RNROVRD_PRIOR_YR_SC

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(3,2)

RNROVRD

RNROVRD_IRA_KEOGH_PCT

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)

IM_STATE_PROV_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 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 Amount of tuition expenses to be included in the student IM calculation. NUMBER(5)

RNROVRD

RNROVRD_TUIT_EXP_IM

IM_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 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 Actual amount of wage taxes paid by the student. NUMBER(5)

RNROVRD

RNROVRD_ACT_FICA

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

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

CALCULATION

DECODE(RNROVRD_LIMIT_PC_BY_BDGT)

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

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 System generated, unique, internal identification number assigned to this person. NUMBER(8)

RNROVRD

RNROVRD_PIDM

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 Only use with independent students with dependents. VARCHAR2(1)

CALCULATION

DECODE(RNROVRD_USE_P_ST_TAX_ALWNCE)

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 8.1