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