Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE		RCRAPP2	RCRAPP2_ACTIVITY_DATE
AGE	Age	The student's age used in all calculations.	NUMBER(2)		RCRAPP2	RCRAPP2_C_AGE
AID_YEAR	Financial 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	Application Number	Financial aid application unique sequence number.	NUMBER(3)		RCRAPP2	RCRAPP2_SEQ_NO
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEPENDENCY_INDEPEND	Dependency Independ	Code that indicates if the student is independent or dependent.	VARCHAR2(1)		RCRAPP2	RCRAPP2_MODEL_CDE
DEPENDENCY_INDEPEND_DESC	Dependency Independ Description	Depend independ code description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP2_MODEL_CDE)
DEPENDENCY_STATUS	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	Dependency Status Description	Students dependency status description.	VARCHAR2(15)		CALCULATION	DECODE(RCRAPP2_C_DEPEND_STATUS)
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
ENROLLMENT_PLANNING_SERVICE	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	Enrollment Planning Serv Description	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	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	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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Analysis Type	Analysis type used to determine the primary Student Calculation.	VARCHAR2(1)		RCRAPP2	RCRAPP2_C_1_ANLY_TYPE
FM_ANALYSIS_TYPE_DESC	Federal Method Analysis Type Description	Analysis type description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP2_C_1_ANLY_TYPE)
FM_ASSET_PROTECT_ALLOWANCE	Federal Method 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	Federal Method Available Income	Student's available discretionary income for the primary calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_1_AVAIL_DISC_INC
FM_AVAILABLE_TAX_INCOME	Federal Method 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	Federal Method Calculated Available Income	Student's calculated available income for the primary calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_1_CALC_AVAIL_INC
FM_CASH_AMOUNT	Federal Method 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	Federal Method Contribution Asset	Student's contribution from assets for the primary calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_1_CTRB_FR_ASSET
FM_CONTRIBUTION_INCOME	Federal Method Contribution Income	Student's contribution from income for the primary calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_1_CTRB_FR_INC
FM_CONTRIBUTION_OFFICIAL	Federal Method 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	Federal Method Contribution Official Description	Contribution official description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)
FM_CONVERSION_PERCENT	Federal Method Conversion Percent	Conversion percent used in the student's primary calculation.	NUMBER(3,1)		RCRAPP2	RCRAPP2_C_1_CONV_PCT
FM_DISCRET_NET_WORTH	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Est Contribution Official Description	Description of the estimated primary parent contribution.	VARCHAR2(10)		CALCULATION	DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)
FM_EST_CONVERSION_PERCENT	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Est Family In College	Student's estimated family members in college.	NUMBER(1)		RCRAPP2	RCRAPP2_PELL_NO_IN_COLL
FM_EST_FEDERAL_TAX_PAID	Federal Method 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	Federal Method Est INAS	The student estimated contribution for the primary calculation.	NUMBER(5)		RCRAPP2	RCRAPP2_PELL_CTRB_FOR_STDT
FM_EST_NET_WORTH	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Est State Province 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	Federal Method 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	Federal Method Est Total Contribution	Student's estimated total contribution used in the primary calculation.	NUMBER(5)		RCRAPP2	RCRAPP2_PELL_TOT_CTRB
FM_EST_TOTAL_INCOME	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Home Equity	Home equity used in the student's primary calculation.	NUMBER(6)		RCRAPP2	RCRAPP2_C_1_HME_VAL
FM_INAS	Federal Method INAS	The student contribution for the primary calculation.	NUMBER(5)		RCRAPP2	RCRAPP2_C_1_CTRB_FOR_STDT
FM_INCOME_SUPPLEMENT	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Parent Adjustment 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	Federal Method Parent Adjustment 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	Federal Method Parent Adjustment 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	Federal Method 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	Federal Method Parent Analysis Type Description	Analysis type description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)
FM_PARENT_ASSET_PROT_ALLOWANCE	Federal Method Parent Asset Protection 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Parent Contribution 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	Federal Method Parent Contribution Off Description	Description of the primary parent contribution.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)
FM_PARENT_CONVERSION_PERCENT	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Parent Est Anal Type Description	Analysis type description.	VARCHAR2(10)		CALCULATION	DECODE(RCRAPP2_PELL_P_ANLY_TYPE)
FM_PARENT_EST_FEDERAL_TAX_PAID	Federal Method 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	Federal Method Parent Est State Province 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	Federal Method 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	Federal Method Parent Est Total 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	Federal Method 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	Federal Method 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	Federal Method Parent INAS	Primary parent contribution.	NUMBER(7)		RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FOR_STDT
FM_PARENT_INCOME_SUPPLEMENT	Federal Method 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	Federal Method Parent Medical Dental Expiration	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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Parent State Province 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method 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	Federal Method Total Allowances	Amount of total allowances used in the student's primary calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_1_TOT_ALLOW
FM_TOTAL_CONTRIBUTION	Federal Method 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	Federal Method Total Income	The total income used in the student's primary calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_1_TOT_INC
FM_TOTAL_UNTAX_INCOME	Federal Method 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	Federal Method Veteran Benefits Indicator	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	Federal Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method Analysis Type	Analysis type used for the IM student contribution	VARCHAR2(1)		RCRAPP2	RCRAPP2_IM_1_ANLY_TYPE
IM_ANALYSIS_TYPE_DESC	Institution Method Analysis Type Description	Analysis type description.	VARCHAR2(4000)
IM_ASSET_PROTECT_ALLOWANCE	Institution Method 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	Institution Method Available Income	Student's available discretionary income for the IM calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_2_AVAIL_DISC_INC
IM_AVAILABLE_TAX_INCOME	Institution Method 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	Institution Method Calculated Available Income	Student's calculated available income for the IM calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_2_CALC_AVAIL_INC
IM_CASH_AMOUNT	Institution Method 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	Institution Method Contribution	Primary institutional methodology student contribution.	NUMBER(5)		RCRAPP2	RCRAPP2_IM_1_SC
IM_CONTRIBUTION_ASSET	Institution Method Contribution Asset	Student's contribution from assets for the primary calculation.	NUMBER(5)		RCRAPP2	RCRAPP2_C_2_CTRB_FR_ASSET
IM_CONTRIBUTION_INCOME	Institution Method Contribution Income	Student's contribution from income for the primary calculation.	NUMBER(6)		RCRAPP2	RCRAPP2_C_2_CTRB_FR_INC
IM_CONTRIBUTION_OFFICIAL	Institution Method 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	Institution Method Contribution Official Description	Description of the IM student contribution.	VARCHAR2(10)		CALCULATION	DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)
IM_CONVERSION_PERCENT	Institution Method Conversion Percent	Conversion percent used in the student's IM calculation.	NUMBER(3,1)		RCRAPP2	RCRAPP2_C_2_CONV_PCT
IM_DISCRET_NET_WORTH	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method Home Equity	Home equity used in the student's IM calculation.	NUMBER(6)		RCRAPP2	RCRAPP2_C_2_HME_VAL
IM_INAS	Institution Method INAS	The student contribution for the IM calculation.	NUMBER(5)		RCRAPP2	RCRAPP2_C_2_CTRB_FOR_STDT
IM_INCOME_SUPPLEMENT	Institution Method 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	Institution Method 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	Institution Method Multi Enrollment 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	Institution Method 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	Institution Method Parent Adjustment 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	Institution Method Parent Adjustment 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	Institution Method Parent Adjustment 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	Institution Method 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	Institution Method Parent Analysis Type Description	Analysis type description.	VARCHAR2(4000)
IM_PARENT_ASSET_PROT_ALLOWANCE	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method Parent Contribution	Primary institutional methodology parent contribution.	NUMBER(5)		RCRAPP2	RCRAPP2_IM_1_PC
IM_PARENT_CONTRIBUTION_ASSET	Institution Method 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	Institution Method 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	Institution Method Parent Contribution 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	Institution Method Parent Contribution Off Description	Description of the IM parent contribution.	VARCHAR2(10)		CALCULATION	DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)
IM_PARENT_CONVERSION_PERCENT	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method Parent Home Equity	Home equity used in the parent's IM calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_PAR_2_HME_VAL
IM_PARENT_INAS	Institution Method Parent INAS	The parent contribution for the IM calculation.	NUMBER(5)		RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FOR_STDT
IM_PARENT_INCOME_SUPPLEMENT	Institution Method 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	Institution Method Parent Medical Dental Expiration	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	Institution Method Multi Enrollment Adjustment	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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method Parent State Province 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method 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	Institution Method Total Allowances	Amount of total allowances used in the student's IM calculation.	NUMBER(6)		RCRAPP2	RCRAPP2_C_2_TOT_ALLOW
IM_TOTAL_CONTRIBUTION	Institution Method 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	Institution Method Total Family Contribution	Primary institutional methodology total family contribution.	NUMBER(6)		RCRAPP2	RCRAPP2_IM_1_TFC
IM_TOTAL_INCOME	Institution Method Total Income	The total income used in the student's IM calculation.	NUMBER(7)		RCRAPP2	RCRAPP2_C_2_TOT_INC
IM_TOTAL_UNTAX_INCOME	Institution Method 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	Institution Method 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	Institution Method Veteran Benefits Indicator	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	Institution Method 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 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	Marital Status	The computed student's marital status.	VARCHAR2(1)		RCRAPP2	RCRAPP2_C_MRTL_STATUS
MARITAL_STATUS_DESC	Marital Status Description	Description of the Student's marital status.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP2_C_MRTL_STATUS)
MIF_DESC	MIF Description	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	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	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	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	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	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	Parent Marital Status Description	Description of the parents' marital status.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP2_C_PAR_MRTL_STATUS)
PARENT_NUMBER_IN_COLLEGE	Parent Number In College	Number in college that are parents of the student.	NUMBER(1)		RCRAPP2	RCRAPP2_C_PAR_PAR_IN_COLL
PELL_EFC	Pell Effective Family Contribution	The primary system Pell PGI.	NUMBER(5)		RCRAPP2	RCRAPP2_PELL_PGI
PELL_EFC_OFFICIAL	Pell Effective Family Contribution 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 Effective Family Contribution Official Description	Pell PGI official description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP2_PELL_PGI_OFFL_EST)
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RCRAPP2	RCRAPP2_PIDM
SAR_C_IND	Eligibility Status Indicator	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	Simplified Needs Test Indicator	Indicates if the Simplified Needs Test conditions have been met.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP2_PELL_ANLY_TYPE)
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		RCRAPP2	RCRAPP2_USER_ID
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: