Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

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 Local Source Local Target
ACTIVITY_DATE Date record was inserted or updated. DATE

RCRAPP2

RCRAPP2_ACTIVITY_DATE

NO

NO
AGE The student's age used in all calculations. NUMBER

RCRAPP2

RCRAPP2_C_AGE

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)

RCRAPP2

RCRAPP2_AIDY_CODE

NO

NO
APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER

RCRAPP2

RCRAPP2_SEQ_NO

NO

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

NA

SYSDATE

NO

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

RCRAPP2

RCRAPP2_MODEL_CDE

NO

NO
DEPENDENCY_INDEPEND_DESC Depend independ code description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP2_MODEL_CDE)

NO

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

RCRAPP2

RCRAPP2_C_DEPEND_STATUS

NO

NO
DEPENDENCY_STATUS_DESC Students dependency status description. VARCHAR2(15)

CALCULATION

DECODE(RCRAPP2_C_DEPEND_STATUS)

NO

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

NA

NA

NO

NO
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

NO

NO
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

NO

NO
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

RCRAPP2

RCRAPP2_C_NO_IN_COLL

NO

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

RCRAPP2

RCRAPP2_C_FAM_MEMB

NO

NO
FM_ADJUSTED_AVAIL_INCOME Student's calculated adjusted available income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_ADJ_AVAIL_INC

NO

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

RCRAPP2

RCRAPP2_C_1_ADJ_BF_NET_WTH

NO

NO
FM_ADJUSTED_GROSS_INCOME Student's adjusted gross taxable income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_AGI_TAX_INC

NO

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

RCRAPP2

RCRAPP2_C_1_ANLY_TYPE

NO

NO
FM_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP2_C_1_ANLY_TYPE)

NO

NO
FM_ASSET_PROTECT_ALLOWANCE Amount of the student's asset protection allowance in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_PROT_ALLOW

NO

NO
FM_AVAILABLE_INCOME Student's available discretionary income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_AVAIL_DISC_INC

NO

NO
FM_AVAILABLE_TAX_INCOME Student's available taxable income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_AVAIL_TAX_INC

NO

NO
FM_CALC_AVAILABLE_INCOME Student's calculated available income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CALC_AVAIL_INC

NO

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

RCRAPP2

RCRAPP2_C_1_CASH_AMT

NO

NO
FM_CONTRIBUTION_ASSET Student's contribution from assets for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FR_ASSET

NO

NO
FM_CONTRIBUTION_INCOME Student's contribution from income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FR_INC

NO

NO
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

NO

NO
FM_CONTRIBUTION_OFFICIAL_DESC Contribution official description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)

NO

NO
FM_CONVERSION_PERCENT Conversion percent used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CONV_PCT

NO

NO
FM_DISCRET_NET_WORTH Student's discretionary net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_DISC_NET_WTH

NO

NO
FM_EMPLOYMENT_ALLOWANCE Student's employment allowance used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_EMP_ALLOW

NO

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

RCRAPP2

RCRAPP2_PELL_ADJ_BF_NET_WTH

NO

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

RCRAPP2

RCRAPP2_PELL_AGI_TAX_INC

NO

NO
FM_EST_ASSET_PROT_ALLOWANCE Student's estimated asset protection allowance used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_PROT_ALLOW

NO

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

RCRAPP2

RCRAPP2_PELL_AVAIL_DISC_INC

NO

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

RCRAPP2

RCRAPP2_PELL_CASH_AMT

NO

NO
FM_EST_CONTRIBUTION_ASSET Portion of the estimated primary parent contribution that came from assets. NUMBER

RCRAPP2

RCRAPP2_PELL_CTRB_FR_ASSET

NO

NO
FM_EST_CONTRIBUTION_INCOME Portion of the estimated primary parent contribution that came from income. NUMBER

RCRAPP2

RCRAPP2_PELL_CTRB_FR_INC

NO

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

RCRAPP2

RCRAPP2_PELL_CTRB_OFFL_EST

NO

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

CALCULATION

DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)

NO

NO
FM_EST_CONVERSION_PERCENT Student's estimated conversion percentage used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_CONV_PCT

NO

NO
FM_EST_DISCRET_NET_WORTH Student's estimated discretionary net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_DISC_NET_WTH

NO

NO
FM_EST_EMPLOYMENT_ALLOWANCE Total estimated employment allowance used in the calculation of the primary student contribution. NUMBER

RCRAPP2

RCRAPP2_PELL_EMP_ALLOW

NO

NO
FM_EST_FAMILY_IN_COLLEGE Student's estimated family members in college. NUMBER

RCRAPP2

RCRAPP2_PELL_NO_IN_COLL

NO

NO
FM_EST_FEDERAL_TAX_PAID Total estimated federal taxes used in the calculation of the primary student contribution. NUMBER

RCRAPP2

RCRAPP2_PELL_US_INC_TAX

NO

NO
FM_EST_INAS The student estimated contribution for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_CTRB_FOR_STDT

NO

NO
FM_EST_NET_WORTH Student's estimated net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_NET_WTH

NO

NO
FM_EST_REAL_ESTATE_EQ Student's estimated real estate equity used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_RE_INV_VAL

NO

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

RCRAPP2

RCRAPP2_PELL_MNT_ALLOW

NO

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

RCRAPP2

RCRAPP2_PELL_ST_OTH_TAX

NO

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

RCRAPP2

RCRAPP2_PELL_TOT_ALLOW

NO

NO
FM_EST_TOTAL_CONTRIBUTION Student's estimated total contribution used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_TOT_CTRB

NO

NO
FM_EST_TOTAL_INCOME Total estimated income used in the calculation of the primary student contribution. NUMBER

RCRAPP2

RCRAPP2_PELL_TOT_INC

NO

NO
FM_EST_TOTAL_UNTAX_INCOME Total estimated untaxable income used in the calculation of the primary student contribution. NUMBER

RCRAPP2

RCRAPP2_PELL_TOT_UNTAX_INC

NO

NO
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

RCRAPP2

RCRAPP2_C_1_NO_IN_COLL

NO

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

RCRAPP2

RCRAPP2_C_1_US_INC_TAX

NO

NO
FM_HOME_EQUITY Home equity used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_HME_VAL

NO

NO
FM_INAS The student contribution for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FOR_STDT

NO

NO
FM_INCOME_SUPPLEMENT Amount of the income supplement used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_INC_SUPPLEMENT

NO

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

RCRAPP2

RCRAPP2_C_1_MED_DEN_EXP

NO

NO
FM_NET_WORTH Amount of the student's net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_NET_WTH

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_AGI_TAX_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_ADJ_AVAIL_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_ANLY_TYPE

NO

NO
FM_PARENT_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)

NO

NO
FM_PARENT_ASSET_PROT_ALLOWANCE Asset protection allowance used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_1_PROT_ALLOW

NO

NO
FM_PARENT_AVAILABLE_INCOME Available discretionary income used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_AVAIL_DISC_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_CASH_AMT

NO

NO
FM_PARENT_CONTRIBUTION_ASSET Portion of the primary parent contribution that came from assets. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_ASSET

NO

NO
FM_PARENT_CONTRIBUTION_INCOME Portion of the primary parent contribution that came from income. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_OFFL_EST

NO

NO
FM_PARENT_CONTRIB_OFF_DESC Description of the primary parent contribution. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)

NO

NO
FM_PARENT_CONVERSION_PERCENT Discretionary net worth conversion percent used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CONV_PCT

NO

NO
FM_PARENT_DISCRET_NET_WORTH Discretionary net worth used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_DISC_NET_WTH

NO

NO
FM_PARENT_EMPLOYMENT_ALLOWANCE Employment allowance used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_EMP_ALLOW

NO

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

RCRAPP2

RCRAPP2_PELL_P_AGI_TAX_INC

NO

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

RCRAPP2

RCRAPP2_PELL_P_ANLY_TYPE

NO

NO
FM_PARENT_EST_ANAL_TYPE_DESC Analysis type description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP2_PELL_P_ANLY_TYPE)

NO

NO
FM_PARENT_EST_FEDERAL_TAX_PAID Amount of estimated federal taxes used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_PELL_P_US_INC_TAX

NO

NO
FM_PARENT_EST_STAT_PROV_TAX_PD Amount of estimated state_province taxes used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_PELL_P_ST_OTH_TAX

NO

NO
FM_PARENT_EST_TOTAL_INCOME Total estimated income used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_PELL_P_TOT_INC

NO

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

RCRAPP2

RCRAPP2_PELL_P_TOT_UNTAX_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_US_INC_TAX

NO

NO
FM_PARENT_HOME_EQUITY Home equity used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_HME_VAL

NO

NO
FM_PARENT_INAS Primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FOR_STDT

NO

NO
FM_PARENT_INCOME_SUPPLEMENT Income supplement used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_INC_SUPPLEMENT

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_MED_DEN_EXP

NO

NO
FM_PARENT_NET_WORTH Net worth used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_NET_WTH

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_RE_INV_VAL

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_SCH_TUIT

NO

NO
FM_PARENT_STAND_MAINT_ALLOW Standard maintenance allownace used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_MNT_ALLOW

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_ST_OTH_TAX

NO

NO
FM_PARENT_TOTAL_ALLOWANCES Total allowances used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_TOT_ALLOW

NO

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

RCRAPP2

RCRAPP2_C_PAR_1_TOT_CTRB

NO

NO
FM_PARENT_TOTAL_INCOME Total income used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_TOT_INC

NO

NO
FM_PARENT_TOTAL_UNTAX_INCOME Total untaxed income used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_TOT_UNTAX_INC

NO

NO
FM_PARENT_WAGE_TAX_PAID Amount of wage taxes used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_FICA_TAX

NO

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

RCRAPP2

RCRAPP2_C_1_RE_INV_VAL

NO

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

RCRAPP2

RCRAPP2_C_1_SCH_TUIT

NO

NO
FM_STAND_MAINT_ALLOWANCE Standard maintenance allowance used in the calculation of the student's contribution. NUMBER

RCRAPP2

RCRAPP2_C_1_MNT_ALLOW

NO

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

RCRAPP2

RCRAPP2_C_1_ST_OTH_TAX

NO

NO
FM_TAXABLE_INCOME_CONTRIBUTION Taxable income contribution for single independent students for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_TAX_INC_CTRB

NO

NO
FM_TOTAL_ALLOWANCES Amount of total allowances used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_TOT_ALLOW

NO

NO
FM_TOTAL_CONTRIBUTION Total student contribution before the number in college adjustment for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_TOT_CTRB

NO

NO
FM_TOTAL_INCOME The total income used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_TOT_INC

NO

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

RCRAPP2

RCRAPP2_C_1_TOT_UNTAX_INC

NO

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

NO

NO
FM_WAGE_TAX_PAID Amount of wage taxes used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_FICA_TAX

NO

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

RCRAPP2

RCRAPP2_C_2_ADJ_AVAIL_INC

NO

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

RCRAPP2

RCRAPP2_C_2_ADJ_BF_NET_WTH

NO

NO
IM_ADJUSTED_GROSS_INCOME Adjusted gross taxable income used in the calculation of the IM student contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_AGI_TAX_INC

NO

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

RCRAPP2

RCRAPP2_IM_1_ANLY_TYPE

NO

NO
IM_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(4000)       NO
IM_ASSET_PROTECT_ALLOWANCE Asset protection allowance used in the calculation of the student IM contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_PROT_ALLOW

NO

NO
IM_AVAILABLE_INCOME Student's available discretionary income for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_AVAIL_DISC_INC

NO

NO
IM_AVAILABLE_TAX_INCOME Student's available taxable income for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_AVAIL_TAX_INC

NO

NO
IM_CALC_AVAILABLE_INCOME Student's calculated available income for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CALC_AVAIL_INC

NO

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

RCRAPP2

RCRAPP2_C_2_CASH_AMT

NO

NO
IM_CONTRIBUTION Primary institutional methodology student contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_SC

NO

NO
IM_CONTRIBUTION_ASSET Student's contribution from assets for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_ASSET

NO

NO
IM_CONTRIBUTION_INCOME Student's contribution from income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_INC

NO

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

RCRAPP2

RCRAPP2_C_2_CTRB_OFFL_EST

NO

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

CALCULATION

DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)

NO

NO
IM_CONVERSION_PERCENT Conversion percent used in the student's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CONV_PCT

NO

NO
IM_DISCRET_NET_WORTH Student's discretionary net worth used in the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_DISC_NET_WTH

NO

NO
IM_EMPLOYMENT_ALLOWANCE Employment allowance used in the calculation of the student IM contribution. NUMBER

RCRAPP2

RCRAPP2_C_2_EMP_ALLOW

NO

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

RCRAPP2

RCRAPP2_C_2_US_INC_TAX

NO

NO
IM_HOME_EQUITY Home equity used in the student's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_HME_VAL

NO

NO
IM_INAS The student contribution for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FOR_STDT

NO

NO
IM_INCOME_SUPPLEMENT Amount of the income supplement used in the student's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_INC_SUPPLEMENT

NO

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

RCRAPP2

RCRAPP2_C_2_MED_DEN_EXP

NO

NO
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

RCRAPP2

RCRAPP2_C_2_NO_IN_COLL

NO

NO
IM_NET_WORTH Amount of the student's net worth used in the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_NET_WTH

NO

NO
IM_PARENT_ADJUST_GROSS_INCOME Adjusted gross taxable income used in the calculation of the secondary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_AGI_TAX_INC

NO

NO
IM_PARENT_ADJ_AVAILABLE_INCOME Adjusted available income used in the calculation of the IM parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_ADJ_AVAIL_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH

NO

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

RCRAPP2

RCRAPP2_IM_1_PAR_ANLY_TYPE

NO

NO
IM_PARENT_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(4000)       NO
IM_PARENT_ASSET_PROT_ALLOWANCE Amount of the parent's asset protection allowance used in the calculation of the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_PROT_ALLOW

NO

NO
IM_PARENT_AVAILABLE_INCOME Parent's available discretionary income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_AVAIL_DISC_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_CASH_AMT

NO

NO
IM_PARENT_CONTRIBUTION Primary institutional methodology parent contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_PC

NO

NO
IM_PARENT_CONTRIBUTION_ASSET Portion of the primary parent contribution that came from income. NUMBER

CALCULATION

DECODE(RCRAPP2_C_PAR_2_CTRB_FR_ASSET)

NO

NO
IM_PARENT_CONTRIBUTION_INCOME Portion of the primary parent contribution that came from income. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_OFFL_EST

NO

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

CALCULATION

DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)

NO

NO
IM_PARENT_CONVERSION_PERCENT Conversion percent used in the parent's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CONV_PCT

NO

NO
IM_PARENT_COUNTRY_COEFFICIENT The calculated country coefficient for the parents used by the IM need analysis process. NUMBER

RCRAPP2

RCRAPP2_C_PAR_CNTRY_COEFF

NO

NO
IM_PARENT_DISCRET_NET_WORTH Parent's discretionary net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_DISC_NET_WTH

NO

NO
IM_PARENT_EMPLOYMENT_ALLOWANCE Employment allowance used in the IM calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_EMP_ALLOW

NO

NO
IM_PARENT_FEDERAL_INCOME_TAX Amount of federal income tax paid by the parent. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_US_INC_TAX

NO

NO
IM_PARENT_HOME_EQUITY Home equity used in the parent's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_HME_VAL

NO

NO
IM_PARENT_INAS The parent contribution for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FOR_STDT

NO

NO
IM_PARENT_INCOME_SUPPLEMENT Amount of the income supplement used in the parent's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_INC_SUPPLEMENT

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_MED_DEN_EXP

NO

NO
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

RCRAPP2

RCRAPP2_C_PAR_2_NO_IN_COLL

NO

NO
IM_PARENT_NET_WORTH Amount of the parent's net worth used in the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_NET_WTH

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_RE_INV_VAL

NO

NO
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

RCRAPP2

RCRAPP2_C_PAR_2_SCH_TUIT

NO

NO
IM_PARENT_STAND_MAINT_ALLOW Standard maintenance allownace used in the IM calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_MNT_ALLOW

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_ST_OTH_TAX

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_TOT_ALLOW

NO

NO
IM_PARENT_TOTAL_CONTRIBUTION Total parent contribution before the number in college adjustment for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_TOT_CTRB

NO

NO
IM_PARENT_TOTAL_INCOME Total income used in the calculation of the parent IM contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_TOT_INC

NO

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

RCRAPP2

RCRAPP2_C_PAR_2_TOT_UNTAX_INC

NO

NO
IM_PARENT_WAGE_TAX_PAID Amount of wage taxes used in the IM calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_FICA_TAX

NO

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

RCRAPP2

RCRAPP2_C_2_RE_INV_VAL

NO

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

RCRAPP2

RCRAPP2_C_2_SCH_TUIT

NO

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

RCRAPP2

RCRAPP2_C_2_MNT_ALLOW

NO

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

RCRAPP2

RCRAPP2_C_2_ST_OTH_TAX

NO

NO
IM_TAXABLE_INCOME_CONTRIBUTION Taxable income contribution for single independent students for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TAX_INC_CTRB

NO

NO
IM_TOTAL_ALLOWANCES Amount of total allowances used in the student's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_ALLOW

NO

NO
IM_TOTAL_CONTRIBUTION Total student contribution before the number in college adjustment for the IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_CTRB

NO

NO
IM_TOTAL_FAMILY_CONTRIBUTION Primary institutional methodology total family contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_TFC

NO

NO
IM_TOTAL_INCOME The total income used in the student's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_INC

NO

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

RCRAPP2

RCRAPP2_C_2_TOT_UNTAX_INC

NO

NO
IM_UNASSESSED_VETERAN_BENEFITS Unassessed VA benefits used in the primary IM student contribution calculation. NUMBER

RCRAPP2

RCRAPP2_IM_1_UNASSESSED_VA

NO

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

NO

NO
IM_WAGE_TAX_PAID Amount of wage taxes used in the student's IM calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_FICA_TAX

NO

NO
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

NO

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

RCRAPP2

RCRAPP2_C_MRTL_STATUS

NO

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

RORMVAL

RORMVAL_DESC

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

RCRAPP2

RCRAPP2_C_PAR_OTH_IN_COLL

NO

NO
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

RCRAPP2

RCRAPP2_C_PAR_NO_IN_COLL

NO

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

RCRAPP2

RCRAPP2_C_PAR_FAM_MEMB

NO

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

RCRAPP2

RCRAPP2_C_PAR_MRTL_STATUS

NO

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

RORMVAL

RORMVAL_DESC

NO

NO
PARENT_NUMBER_IN_COLLEGE Number in college that are parents of the student. NUMBER

RCRAPP2

RCRAPP2_C_PAR_PAR_IN_COLL

NO

NO
PELL_EFC The primary system Pell PGI. NUMBER

RCRAPP2

RCRAPP2_PELL_PGI

NO

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

RCRAPP2

RCRAPP2_PELL_PGI_OFFL_EST

NO

NO
PELL_EFC_OFFICIAL_DESC Pell PGI official description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP2_PELL_PGI_OFFL_EST)

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RCRAPP2

RCRAPP2_PIDM

NO

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

NO

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

CALCULATION

DECODE(RCRAPP2_PELL_ANLY_TYPE)

NO

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

RCRAPP2

RCRAPP2_USER_ID

NO

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

NA

NA

NO

NO


Ver: