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

SGHE Banner Operational Data Store
Composite View Target: AR_FINAID_APPLICATION2

Description Contains demographic information about the student and parents from the financial aid application. Also contains information specific to the financial aid application itself.

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

RCRAPP2

RCRAPP2_ACTIVITY_DATE

AGE The student's age used in all calculations. NUMBER(2)

RCRAPP2

RCRAPP2_C_AGE

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)

RCRAPP2

RCRAPP2_AIDY_CODE

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER(3)

RCRAPP2

RCRAPP2_SEQ_NO

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

NA

SYSDATE

DEPENDENCY_INDEPEND Code that indicates if the student is independent or dependent. VARCHAR2(1)

RCRAPP2

RCRAPP2_MODEL_CDE

DEPENDENCY_INDEPEND_DESC Depend independ code description. VARCHAR2(15)

CALCULATION

DECODE(RCRAPP2_MODEL_CDE)

DEPENDENCY_STATUS Indicates the students dependency status as computed by INAS or loaded from the tape record. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_DEPEND_STATUS

DEPENDENCY_STATUS_DESC Students dependency status description. VARCHAR2(15)

CALCULATION

DECODE(RCRAPP2_C_DEPEND_STATUS)

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

NA

NA

ENROLLMENT_PLANNING_SERVICE EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only) VARCHAR2(4)

RCRAPP2

RCRAPP2_EPS_CDE

ENROLLMENT_PLANNING_SERV_DESC Description of the EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only) VARCHAR2(30)

STVEPSC

STVEPSC_DESC

FAMILY_IN_COLLEGE The number of people in the student's family that will be in college at least half-time as computed by the need analysis processor. NUMBER(1)

RCRAPP2

RCRAPP2_C_NO_IN_COLL

FAMILY_SIZE The number of people in the independent student's household as computed by the need analysis processor. NUMBER(2)

RCRAPP2

RCRAPP2_C_FAM_MEMB

FM_ADJUSTED_AVAIL_INCOME Student's calculated adjusted available income for the primary calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_1_ADJ_AVAIL_INC

FM_ADJUSTED_BUS_NET_WORTH Amount of business and farm net worth used in the calculation of the primary student contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_ADJ_BF_NET_WTH

FM_ADJUSTED_GROSS_INCOME Student's adjusted gross taxable income for the primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_1_AGI_TAX_INC

FM_ANALYSIS_TYPE Analysis type used to determine the primary Student Calculation. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_1_ANLY_TYPE

FM_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_C_1_ANLY_TYPE)

FM_ASSET_PROTECT_ALLOWANCE Amount of the student's asset protection allowance in the primary calculation. NUMBER(9)

RCRAPP2

RCRAPP2_C_1_PROT_ALLOW

FM_AVAILABLE_INCOME Student's available discretionary income for the primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_AVAIL_DISC_INC

FM_AVAILABLE_TAX_INCOME Student's available taxable income for the primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_1_AVAIL_TAX_INC

FM_CALC_AVAILABLE_INCOME Student's calculated available income for the primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_CALC_AVAIL_INC

FM_CASH_AMOUNT Student's amounts in cash, savings and checking accounts used in the primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_1_CASH_AMT

FM_CONTRIBUTION_ASSET Student's contribution from assets for the primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_CTRB_FR_ASSET

FM_CONTRIBUTION_INCOME Student's contribution from income for the primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_CTRB_FR_INC

FM_CONTRIBUTION_OFFICIAL Indicates if the student contribution for the primary calculation is official or estimated. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_1_CTRB_OFFL_EST

FM_CONTRIBUTION_OFFICIAL_DESC Contribution official description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)

FM_CONVERSION_PERCENT Conversion percent used in the student's primary calculation. NUMBER(3,1)

RCRAPP2

RCRAPP2_C_1_CONV_PCT

FM_DISCRET_NET_WORTH Student's discretionary net worth used in the primary calculation. NUMBER(9)

RCRAPP2

RCRAPP2_C_1_DISC_NET_WTH

FM_EMPLOYMENT_ALLOWANCE Student's employment allowance used in the primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_EMP_ALLOW

FM_EST_ADJUSTED_BUS_NET_WORTH Student's adjusted business or farm net worth used in the primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_PELL_ADJ_BF_NET_WTH

FM_EST_AGI Total estimated adjusted gross income used in the calculation of the primary student contribution. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_AGI_TAX_INC

FM_EST_ASSET_PROT_ALLOWANCE Student's estimated asset protection allowance used in the primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_PROT_ALLOW

FM_EST_AVAILABLE_INCOME Student's estimated available discretionary income used in the student's primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_AVAIL_DISC_INC

FM_EST_CASH_AMOUNT Student's estimated amounts in cash, savings and checking accounts used in the primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_CASH_AMT

FM_EST_CONTRIBUTION_ASSET Portion of the estimated primary parent contribution that came from assets. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_CTRB_FR_ASSET

FM_EST_CONTRIBUTION_INCOME Portion of the estimated primary parent contribution that came from income. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_CTRB_FR_INC

FM_EST_CONTRIBUTION_OFFICIAL Indicates if the estimated primary parent contribution is official or estimated. VARCHAR2(1)

RCRAPP2

RCRAPP2_PELL_CTRB_OFFL_EST

FM_EST_CONTRIB_OFFICIAL_DESC Description of the estimated primary parent contribution. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)

FM_EST_CONVERSION_PERCENT Student's estimated conversion percentage used in the primary calculation. NUMBER(3,1)

RCRAPP2

RCRAPP2_PELL_CONV_PCT

FM_EST_DISCRET_NET_WORTH Student's estimated discretionary net worth used in the primary calculation. NUMBER(8)

RCRAPP2

RCRAPP2_PELL_DISC_NET_WTH

FM_EST_EMPLOYMENT_ALLOWANCE Total estimated employment allowance used in the calculation of the primary student contribution. NUMBER(4)

RCRAPP2

RCRAPP2_PELL_EMP_ALLOW

FM_EST_FAMILY_IN_COLLEGE Student's estimated family members in college. NUMBER(1)

RCRAPP2

RCRAPP2_PELL_NO_IN_COLL

FM_EST_FEDERAL_TAX_PAID Total estimated federal taxes used in the calculation of the primary student contribution. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_US_INC_TAX

FM_EST_INAS The student estimated contribution for the primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_CTRB_FOR_STDT

FM_EST_NET_WORTH Student's estimated net worth used in the primary calculation. NUMBER(8)

RCRAPP2

RCRAPP2_PELL_NET_WTH

FM_EST_REAL_ESTATE_EQ Student's estimated real estate equity used in the primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_RE_INV_VAL

FM_EST_STAND_MAINT_ALLOWANCE Total estimated standard maintenance allowance used in the calculation of the primary student contribution. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_MNT_ALLOW

FM_EST_STATE_PROV_TAX_PAID Total estimated state or province taxes used in the calculation of the primary student contribution. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_ST_OTH_TAX

FM_EST_TOTAL_ALLOWANCE Estimated amount of total allowances used in the student's Federal Method calculation. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_TOT_ALLOW

FM_EST_TOTAL_CONTRIBUTION Student's estimated total contribution used in the primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_TOT_CTRB

FM_EST_TOTAL_INCOME Total estimated income used in the calculation of the primary student contribution. NUMBER(7)

RCRAPP2

RCRAPP2_PELL_TOT_INC

FM_EST_TOTAL_UNTAX_INCOME Total estimated untaxable income used in the calculation of the primary student contribution. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_TOT_UNTAX_INC

FM_FAMILY_IN_COLLEGE Number of people in the student's household that will be in college as used in the student's primary calculation. NUMBER(1)

RCRAPP2

RCRAPP2_C_1_NO_IN_COLL

FM_FEDERAL_TAX_PAID Amount of federal income taxes paid used in the student's primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_1_US_INC_TAX

FM_HOME_EQUITY Home equity used in the student's primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_1_HME_VAL

FM_INAS The student contribution for the primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_1_CTRB_FOR_STDT

FM_INCOME_SUPPLEMENT Amount of the income supplement used in the student's primary calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_1_INC_SUPPLEMENT

FM_MEDICAL_DENTAL_EXPENSE Amount of medical and dental expenses used in the student's primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_1_MED_DEN_EXP

FM_NET_WORTH Amount of the student's net worth used in the primary calculation. NUMBER(9)

RCRAPP2

RCRAPP2_C_1_NET_WTH

FM_PARENT_ADJUST_GROSS_INCOME The adjusted gross taxable income used in the calculation of the primary parents' contribution. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_1_AGI_TAX_INC

FM_PARENT_ADJ_AVAILABLE_INCOME Amount of the adjusted available income that was used in the primary calculation of the parent contribution. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_1_ADJ_AVAIL_INC

FM_PARENT_ADJ_BUS_NET_WORTH Adjusted business/farm net worth used in the primary calculation of the parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH

FM_PARENT_ANALYSIS_TYPE Analysis type used to determine the primary Parent Calculation. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_PAR_1_ANLY_TYPE

FM_PARENT_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)

FM_PARENT_ASSET_PROT_ALLOWANCE Asset protection allowance used in the calculation of the primary parent contribution. NUMBER(9)

RCRAPP2

RCRAPP2_C_1_PROT_ALLOW

FM_PARENT_AVAILABLE_INCOME Available discretionary income used in the calculation of the primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_AVAIL_DISC_INC

FM_PARENT_CASH_AMOUNT Amount of parents' cash, savings and checking accounts used in the calculation of the primary parent contribution. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_1_CASH_AMT

FM_PARENT_CONTRIBUTION_ASSET Portion of the primary parent contribution that came from assets. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_ASSET

FM_PARENT_CONTRIBUTION_INCOME Portion of the primary parent contribution that came from income. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_INC

FM_PARENT_CONTRIB_OFFICIAL Indicates if the primary parent contribution is official or estimated. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_OFFL_EST

FM_PARENT_CONTRIB_OFF_DESC Description of the primary parent contribution. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)

FM_PARENT_CONVERSION_PERCENT Discretionary net worth conversion percent used in the calculation of the primary parent contribution. NUMBER(3,1)

RCRAPP2

RCRAPP2_C_PAR_1_CONV_PCT

FM_PARENT_DISCRET_NET_WORTH Discretionary net worth used in the calculation of the primary parent contribution. NUMBER(9)

RCRAPP2

RCRAPP2_C_PAR_1_DISC_NET_WTH

FM_PARENT_EMPLOYMENT_ALLOWANCE Employment allowance used in the calculation of the primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_EMP_ALLOW

FM_PARENT_EST_AGI The estimated adjusted gross taxable income used in the calculation of the primary parents' contribution. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_P_AGI_TAX_INC

FM_PARENT_EST_ANALYSIS_TYPE Analysis type for the primary system PGI. VARCHAR2(1)

RCRAPP2

RCRAPP2_PELL_P_ANLY_TYPE

FM_PARENT_EST_ANAL_TYPE_DESC Analysis type description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_PELL_P_ANLY_TYPE)

FM_PARENT_EST_FEDERAL_TAX_PAID Amount of estimated federal taxes used in the calculation of the primary parent contribution. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_P_US_INC_TAX

FM_PARENT_EST_STAT_PROV_TAX_PD Amount of estimated state_province taxes used in the calculation of the primary parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_P_ST_OTH_TAX

FM_PARENT_EST_TOTAL_INCOME Total estimated income used in the calculation of the primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_PELL_P_TOT_INC

FM_PARENT_EST_TOT_UNTAX_INCOME The estimated total untaxed income used in the calculation of the primary parent's contribution. NUMBER(6)

RCRAPP2

RCRAPP2_PELL_P_TOT_UNTAX_INC

FM_PARENT_FEDERAL_TAX_PAID Amount of US income taxes paid used in the calculation of the primary parent contribution. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_1_US_INC_TAX

FM_PARENT_HOME_EQUITY Home equity used in the calculation of the primary parent contribution. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_1_HME_VAL

FM_PARENT_INAS Primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FOR_STDT

FM_PARENT_INCOME_SUPPLEMENT Income supplement used in the calculation of the primary parent contribution. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_1_INC_SUPPLEMENT

FM_PARENT_MEDICAL_DENTAL_EXP Amount of medical and dental expenses used in the calculation of the primary parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_1_MED_DEN_EXP

FM_PARENT_NET_WORTH Net worth used in the calculation of the primary parent contribution. NUMBER(9)

RCRAPP2

RCRAPP2_C_PAR_1_NET_WTH

FM_PARENT_REAL_ESTATE_EQUITY Other real estate and investment equity used in the calculation of the primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_RE_INV_VAL

FM_PARENT_SECONDARY_TUITION_PD Amount of elementary and secondary school tuition paid used in the calculation of the primary parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_1_SCH_TUIT

FM_PARENT_STAND_MAINT_ALLOW Standard maintenance allownace used in the calculation of the primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_MNT_ALLOW

FM_PARENT_STATE_PROV_TAX_PAID Amount of state and other taxes paid used in the calculation of the primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_ST_OTH_TAX

FM_PARENT_TOTAL_ALLOWANCES Total allowances used in the calculation of the primary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_TOT_ALLOW

FM_PARENT_TOTAL_CONTRIBUTION Total primary parent contribution before adjustment for the number of family members in college. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_TOT_CTRB

FM_PARENT_TOTAL_INCOME Total income used in the calculation of the primary parent contribution. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_1_TOT_INC

FM_PARENT_TOTAL_UNTAX_INCOME Total untaxed income used in the calculation of the primary parent contribution. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_1_TOT_UNTAX_INC

FM_PARENT_WAGE_TAX_PAID Amount of wage taxes used in the calculation of the primary parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_1_FICA_TAX

FM_REAL_ESTATE_EQUITY Amount of other real estate/investment equity used in the student's primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_1_RE_INV_VAL

FM_SECOND_TUITION_PAID Amount of elementary/secondary school tuition paid that was used in the student's primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_1_SCH_TUIT

FM_STAND_MAINT_ALLOWANCE Standard maintenance allowance used in the calculation of the student's contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_MNT_ALLOW

FM_STATE_PROVINCE_TAX_PAID Amount of state or province and other taxes used in the student's primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_ST_OTH_TAX

FM_TAXABLE_INCOME_CONTRIBUTION Taxable income contribution for single independent students for the primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_1_TAX_INC_CTRB

FM_TOTAL_ALLOWANCES Amount of total allowances used in the student's primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_TOT_ALLOW

FM_TOTAL_CONTRIBUTION Total student contribution before the number in college adjustment for the primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_TOT_CTRB

FM_TOTAL_INCOME The total income used in the student's primary calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_1_TOT_INC

FM_TOTAL_UNTAX_INCOME Amount of total untaxed income used in the student's primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_1_TOT_UNTAX_INC

FM_VETERAN_BENEFITS_IND Indicates if VA benefits have been included in the calculation of the student's primary contribution. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP2_C_1_VA_BEN_INCL)

FM_WAGE_TAX_PAID Amount of wage taxes used in the student's primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_1_FICA_TAX

IM_ADJUSTED_AVAILABLE_INCOME Amount of the adjusted available income that was used in the IM calculation of the student contribution. NUMBER(8)

RCRAPP2

RCRAPP2_C_2_ADJ_AVAIL_INC

IM_ADJUSTED_BUS_NET_WORTH Amount of business and farm net worth used in the calculation of the IM student contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_2_ADJ_BF_NET_WTH

IM_ADJUSTED_GROSS_INCOME Adjusted gross taxable income used in the calculation of the IM student contribution. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_AGI_TAX_INC

IM_ANALYSIS_TYPE Analysis type used for the IM student contribution VARCHAR2(1)

RCRAPP2

RCRAPP2_IM_1_ANLY_TYPE

IM_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_IM_1_ANLY_TYPE)

IM_ASSET_PROTECT_ALLOWANCE Asset protection allowance used in the calculation of the student IM contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_PROT_ALLOW

IM_AVAILABLE_INCOME Student's available discretionary income for the IM calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_2_AVAIL_DISC_INC

IM_AVAILABLE_TAX_INCOME Student's available taxable income for the IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_AVAIL_TAX_INC

IM_CALC_AVAILABLE_INCOME Student's calculated available income for the IM calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_2_CALC_AVAIL_INC

IM_CASH_AMOUNT Student's amounts in cash, savings and checking accounts used in the IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_CASH_AMT

IM_CONTRIBUTION Primary institutional methodology student contribution. NUMBER(5)

RCRAPP2

RCRAPP2_IM_1_SC

IM_CONTRIBUTION_ASSET Student's contribution from assets for the primary calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_CTRB_FR_ASSET

IM_CONTRIBUTION_INCOME Student's contribution from income for the primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_CTRB_FR_INC

IM_CONTRIBUTION_OFFICIAL Indicates if the IM student contribution is official or estimated. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_2_CTRB_OFFL_EST

IM_CONTRIBUTION_OFFICIAL_DESC Description of the IM student contribution. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)

IM_CONVERSION_PERCENT Conversion percent used in the student's IM calculation. NUMBER(3,1)

RCRAPP2

RCRAPP2_C_2_CONV_PCT

IM_DISCRET_NET_WORTH Student's discretionary net worth used in the IM calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_2_DISC_NET_WTH

IM_EMPLOYMENT_ALLOWANCE Employment allowance used in the calculation of the student IM contribution. NUMBER(4)

RCRAPP2

RCRAPP2_C_2_EMP_ALLOW

IM_FEDERAL_TAX_PAID Amount of federal income taxes paid used in the calculation of the IM student contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_US_INC_TAX

IM_HOME_EQUITY Home equity used in the student's IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_HME_VAL

IM_INAS The student contribution for the IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_CTRB_FOR_STDT

IM_INCOME_SUPPLEMENT Amount of the income supplement used in the student's IM calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_2_INC_SUPPLEMENT

IM_MEDICAL_DENTAL_EXPENSE Amount of medical or dental expenses used in the student's IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_MED_DEN_EXP

IM_MULTI_ENROLL_ADJUSTED Percentage of adjustment to the student contribution for differing numbers of family members in college. Prior to 0001, this contains the number in college as used in the calculation of EFC. NUMBER(4,1)

RCRAPP2

RCRAPP2_C_2_NO_IN_COLL

IM_NET_WORTH Amount of the student's net worth used in the IM calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_2_NET_WTH

IM_PARENT_ADJUST_GROSS_INCOME Adjusted gross taxable income used in the calculation of the secondary parent contribution. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_2_AGI_TAX_INC

IM_PARENT_ADJ_AVAILABLE_INCOME Adjusted available income used in the calculation of the IM parent contribution. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_2_ADJ_AVAIL_INC

IM_PARENT_ADJ_BUS_NET_WORTH Amount of business and farm net worth used in the calculation of the secondary parent contribution. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH

IM_PARENT_ANALYSIS_TYPE Analysis type used for the IM parent contribution. VARCHAR2(1)

RCRAPP2

RCRAPP2_IM_1_PAR_ANLY_TYPE

IM_PARENT_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_IM_1_PAR_ANLY_TYPE)

IM_PARENT_ASSET_PROT_ALLOWANCE Amount of the parent's asset protection allowance used in the calculation of the primary parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_PROT_ALLOW

IM_PARENT_AVAILABLE_INCOME Parent's available discretionary income for the primary calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_2_AVAIL_DISC_INC

IM_PARENT_CASH_AMOUNT Parent's estimated amounts in cash, savings and checking accounts used in the IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_2_CASH_AMT

IM_PARENT_CONTRIBUTION Primary institutional methodology parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_IM_1_PC

IM_PARENT_CONTRIBUTION_ASSET Portion of the primary parent contribution that came from income. NUMBER(5)

CALCULATION

DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET)

IM_PARENT_CONTRIBUTION_INCOME Portion of the primary parent contribution that came from income. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_INC

IM_PARENT_CONTRIB_OFFICIAL Indicates if the IM parent contribution is official or estimated. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_OFFL_EST

IM_PARENT_CONTRIB_OFF_DESC Description of the IM parent contribution. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)

IM_PARENT_CONVERSION_PERCENT Conversion percent used in the parent's IM calculation. NUMBER(3,1)

RCRAPP2

RCRAPP2_C_PAR_2_CONV_PCT

IM_PARENT_DISCRET_NET_WORTH Parent's discretionary net worth used in the primary calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_2_DISC_NET_WTH

IM_PARENT_EMPLOYMENT_ALLOWANCE Employment allowance used in the IM calculation of the parent contribution. NUMBER(4)

RCRAPP2

RCRAPP2_C_PAR_2_EMP_ALLOW

IM_PARENT_FEDERAL_INCOME_TAX Amount of federal income tax paid by the parent. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_2_US_INC_TAX

IM_PARENT_HOME_EQUITY Home equity used in the parent's IM calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_2_HME_VAL

IM_PARENT_INAS The parent contribution for the IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FOR_STDT

IM_PARENT_INCOME_SUPPLEMENT Amount of the income supplement used in the parent's IM calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_2_INC_SUPPLEMENT

IM_PARENT_MEDICAL_DENTAL_EXP Amount of medical and dental expenses used in the IM calculation of the parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_MED_DEN_EXP

IM_PARENT_MULTI_ENROLLMENT_ADJ Percentage of adjustment to the parent contribution for differing numbers of family members in college. Prior to 0001, this contains the number in college as used in the calculation of EFC. NUMBER(4,1)

RCRAPP2

RCRAPP2_C_PAR_2_NO_IN_COLL

IM_PARENT_NET_WORTH Amount of the parent's net worth used in the primary calculation. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_2_NET_WTH

IM_PARENT_REAL_ESTATE_EQUITY Amount of other real estate/investment equity used in the parent's IM calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_2_RE_INV_VAL

IM_PARENT_SECONDARY_TUITION_PD The amount of elementary, jr. high, and high school tuition paid by the student's secondary parent contributor in the base year. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_SCH_TUIT

IM_PARENT_STAND_MAINT_ALLOW Standard maintenance allownace used in the IM calculation of the parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_MNT_ALLOW

IM_PARENT_STATE_PROV_TAX_PAID Amount of state and other taxes paid used in the IM calculation of the parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_ST_OTH_TAX

IM_PARENT_TOTAL_ALLOWANCE Estimated amount of total allowances used in the parent's IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_2_TOT_ALLOW

IM_PARENT_TOTAL_CONTRIBUTION Total parent contribution before the number in college adjustment for the IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_2_TOT_CTRB

IM_PARENT_TOTAL_INCOME Total income used in the calculation of the parent IM contribution. NUMBER(8)

RCRAPP2

RCRAPP2_C_PAR_2_TOT_INC

IM_PARENT_TOTAL_UNTAX_INCOME Amount of total untaxed income used in the parent's IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_PAR_2_TOT_UNTAX_INC

IM_PARENT_WAGE_TAX_PAID Amount of wage taxes used in the IM calculation of the parent contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_FICA_TAX

IM_REAL_ESTATE_EQUITY Amount of other real estate/investment equity used in the student's IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_RE_INV_VAL

IM_SECOND_TUITION_PAID Amount of elementary/secondary school tuition paid that was used in the student's IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_SCH_TUIT

IM_STAND_MAINT_ALLOWANCE Standard maintenance allowance used in the IM calculation of the student's contribution. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_MNT_ALLOW

IM_STATE_PROVINCE_TAX_PAID Amount of state or province and other taxes used in the student's IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_ST_OTH_TAX

IM_TAXABLE_INCOME_CONTRIBUTION Taxable income contribution for single independent students for the IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_TAX_INC_CTRB

IM_TOTAL_ALLOWANCES Amount of total allowances used in the student's IM calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_TOT_ALLOW

IM_TOTAL_CONTRIBUTION Total student contribution before the number in college adjustment for the IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_TOT_CTRB

IM_TOTAL_FAMILY_CONTRIBUTION Primary institutional methodology total family contribution. NUMBER(6)

RCRAPP2

RCRAPP2_IM_1_TFC

IM_TOTAL_INCOME The total income used in the student's IM calculation. NUMBER(7)

RCRAPP2

RCRAPP2_C_2_TOT_INC

IM_TOTAL_UNTAX_INCOME Amount of total untaxed income used in the student's primary calculation. NUMBER(6)

RCRAPP2

RCRAPP2_C_2_TOT_UNTAX_INC

IM_UNASSESSED_VETERAN_BENEFITS Unassessed VA benefits used in the primary IM student contribution calculation. NUMBER(5)

RCRAPP2

RCRAPP2_IM_1_UNASSESSED_VA

IM_VETERAN_BENEFITS_IND Indicates if VA benefits have been included in the calculation of the student's IM contribution. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP2_C_2_VA_BEN_INCL)

IM_WAGE_TAX_PAID Amount of wage taxes used in the student's IM calculation. NUMBER(5)

RCRAPP2

RCRAPP2_C_2_FICA_TAX

INTERFACE_TAPE_CODE Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.). VARCHAR2(7)

RCRAPP2

RCRAPP2_INFC_CODE

MARITAL_STATUS The computed student's marital status. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_MRTL_STATUS

MARITAL_STATUS_DESC Description of the Student's marital status. VARCHAR2(20)

CALCULATION

DECODE(RCRAPP2_C_MRTL_STATUS)

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

OTHERS_NUMBER_IN_COLLEGE Number of non-parents in the household that will be in college as used in the calculation of parent contribution. NUMBER(1)

RCRAPP2

RCRAPP2_C_PAR_OTH_IN_COLL

PARENT_FAMILY_IN_COLLEGE Number of people in the parents household who will be in college as used in the calculation of the parent contribution. NUMBER(1)

RCRAPP2

RCRAPP2_C_PAR_NO_IN_COLL

PARENT_FAMILY_SIZE Number of family members in the parents' household as used in the calculation of the parent contribution. NUMBER(2)

RCRAPP2

RCRAPP2_C_PAR_FAM_MEMB

PARENT_MARITAL_STATUS Parents' marital status as used in the calculation of the parent contribution. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_PAR_MRTL_STATUS

PARENT_MARITAL_STATUS_DESC Description of the parents' marital status. VARCHAR2(20)

CALCULATION

DECODE(RCRAPP2_C_PAR_MRTL_STATUS)

PARENT_NUMBER_IN_COLLEGE Number in college that are parents of the student. NUMBER(1)

RCRAPP2

RCRAPP2_C_PAR_PAR_IN_COLL

PELL_EFC The primary system Pell PGI. NUMBER(5)

RCRAPP2

RCRAPP2_PELL_PGI

PELL_EFC_OFFICIAL Indicates if the primary system Pell PGI is official or estimated. VARCHAR2(1)

RCRAPP2

RCRAPP2_PELL_PGI_OFFL_EST

PELL_EFC_OFFICIAL_DESC Pell PGI official description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_PELL_PGI_OFFL_EST)

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

RCRAPP2

RCRAPP2_PIDM

SAR_C_IND Eligibility status message that is the result of data base matches indicating further investigation by the aid administrator needed. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP2_ELIGIBILITY_MSG)

SIMPLIFIED_NEEDS_TEST_IND Indicates if the Simplified Needs Test conditions have been met. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP2_PELL_ANLY_TYPE)

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

RCRAPP2

RCRAPP2_USER_ID

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

NA

NA



Ver: 8.0