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
|