Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRAPP1	RCRAPP1_ACTIVITY_DATE	NO	NO
ADDITIONAL_COLLEGE_NAME1	The first school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_1	NO	NO
ADDITIONAL_COLLEGE_NAME2	The second school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_2	NO	NO
ADDITIONAL_COLLEGE_NAME3	The third school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_3	NO	NO
ADDITIONAL_COLLEGE_NAME4	The fourth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_4	NO	NO
ADDITIONAL_COLLEGE_NAME5	The fifth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_5	NO	NO
ADDITIONAL_COLLEGE_NAME6	The sixth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_6	NO	NO
ADDITIONAL_COLLEGE_NAME7	The seventh school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_7	NO	NO
ADDITIONAL_COLLEGE_NAME8	The eighth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_8	NO	NO
ADJUSTED_EFC_CALC_REQUEST	Contains a request to calculate the adjusted Effective Family Contribution.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ADJ_EFC_CALC_REQ	NO	NO
ADJUSTED_GROSS_INCOME	Amount of AGI in the base year reported by the student on his/her federal tax return.	NUMBER	RCRAPP1	RCRAPP1_US_INC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ADOPTED_AFTER_13	Indicates whether student was adopted after age 13.	VARCHAR2(63)	RCRAPP4	RCRAPP4_ADOPTED_AFTER_13	NO	NO
ADOPTED_AFTER_13_DESC	Adopted after 13 indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	RCRAPP1	RCRAPP1_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP1	RCRAPP1_SEQ_NO	NO	NO
ASSET_THRESHOLD_EXCEED	Student asset threshold exceeded.	NUMBER	RCRAPP4	RCRAPP4_S_ASSET_THRESH_EXCD	NO	NO
BUSINESS_DEBT	Amount of the student's outstanding debts against business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_DBT	NO	NO
BUSINESS_NET_WORTH	Student's business net worth.	NUMBER	RCRAPP4	RCRAPP4_BUS_NET_WORTH	NO	NO
BUSINESS_VALUE	Current market value of the student's business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_VAL	NO	NO
CASH_SAVINGS	Amount the student currently has in cash on hand and in savings and checking accounts.	NUMBER	RCRAPP1	RCRAPP1_CASH_AMT	NO	NO
CHILD_CARE_NUMBER	Number of dependent children for whom the student will pay child care expenses.	NUMBER	RCRAPP3	RCRAPP3_CHILD_CARE	NO	NO
CHILD_SUPPORT_INCOME	Student's base year income from child support received for all children.	NUMBER	RCRAPP1	RCRAPP1_CHILD_SUPP	NO	NO
CHILD_SUPPORT_PAID	Amount paid for child support by a student.	NUMBER	RCRAPP3	RCRAPP3_CHILD_SUPP_PAID	NO	NO
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(63)	RCRAPP1	RCRAPP1_COLL_CDE	NO	NO
COLLEGE_CHOICE1	Student's first choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1	NO	NO
COLLEGE_CHOICE10	Student's tenth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_10	NO	NO
COLLEGE_CHOICE2	Student's second choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2	NO	NO
COLLEGE_CHOICE3	Student's third choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3	NO	NO
COLLEGE_CHOICE4	Student's fourth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_4	NO	NO
COLLEGE_CHOICE5	Student's fifth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_5	NO	NO
COLLEGE_CHOICE6	Student's sixth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_6	NO	NO
COLLEGE_CHOICE7	Student's seventh choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_7	NO	NO
COLLEGE_CHOICE8	Student's eighth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_8	NO	NO
COLLEGE_CHOICE9	Student's ninth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_9	NO	NO
COLLEGE_NAME1	The first college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_1	NO	NO
COLLEGE_NAME2	The second college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_2	NO	NO
COLLEGE_NAME3	The third college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_3	NO	NO
COLLEGE_NAME4	The fourth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_4	NO	NO
COLLEGE_NAME5	The fifth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_5	NO	NO
COLLEGE_NAME6	The sixth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_6	NO	NO
COLLEGE_NAME7	The seventh college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_7	NO	NO
COLLEGE_NAME8	The eighth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_8	NO	NO
COMBAT_PAY	Student combat Pay	NUMBER	RCRAPP4	RCRAPP4_COMBAT_PAY	NO	NO
COOPERATIVE_EARNINGS	Student's earnings from work under a cooperative education program offered by a college	NUMBER	RCRAPP3	RCRAPP3_CO_OP_EARNINGS	NO	NO
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CURR_REC_IND	NO	NO
DEGREE_TYPE	Contains the abbreviation of the degree or certificate a student is pursuing.	VARCHAR2(63)	RCRAPP3	RCRAPP3_DEGREE_TYPE	NO	NO
DEGREE_TYPE_DESC	Degree type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
DEPENDENCY_INDEPEND	Code that indicates if the student is independent or dependent.	VARCHAR2(63)	RCRAPP2	RCRAPP2_MODEL_CDE	NO	NO
DEPENDENCY_INDEPEND_DESC	Depend independ code description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
DEPENDENCY_OVERRIDE	Used by the financial aid administrator to override dependency.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE	NO	NO
DEPENDENCY_OVERRIDE_DESC	Dependency override description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_FAA_DEP_OVERRIDE)	NO	NO
DEPENDENCY_STATUS	Indicates the students dependency status as computed by INAS or loaded from the tape record.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_DEPEND_STATUS	NO	NO
DEPENDENCY_STATUS_DESC	Students dependency status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_C_DEPEND_STATUS)	NO	NO
DRIVER_LICENSE_NUMBER	Student's drivers license number.	VARCHAR2(63)	RCRAPP1	RCRAPP1_DRIVER_LIC_NO	NO	NO
DRIVER_LICENSE_STATE_PROVINCE	State or province that issued the student's drivers license.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_LIC	NO	NO
DRIVER_LICENSE_STATE_PROV_DESC	Description of the state or province in which the student holds a drivers license.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
EDUCATION_TAX_CREDIT	Amount of educational tax credits that the student has received.	NUMBER	RCRAPP3	RCRAPP3_EDUC_CREDITS	NO	NO
EFC_RECALC_SPECIAL_CIRCUM	Indicates a request to the CPS to recalculate the Effective Family Contribution.	VARCHAR2(63)	RCRAPP3	RCRAPP3_EFC_RECALC_CORR_REQ	NO	NO
EFC_RECALC_SPECIAL_CIRCUM_DESC	Request to the CPS to recalculate the Effective Family Contribution indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
EMAIL_ADDRESS	Student's e-mail address as reported on PROFILE.	VARCHAR2(255)	RCRAPP4	RCRAPP4_EMAIL_ADDRESS	NO	NO
ENROLLMENT_PLANNING_SERVICE	Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research.	VARCHAR2(63)	RCRAPP2	RCRAPP2_EPS_CDE	NO	NO
ENROLLMENT_PLANNING_SERV_DESC	Enrollment planning service description.	VARCHAR2(255)	STVEPSC	STVEPSC_DESC	NO	NO
EXPECTED_ENROLL_STATUS	Student's expected enrollment status for the school year. No longer populated after aid year ending in 2014.	VARCHAR2(63)	RCRAPP1	RCRAPP1_EXP_ENROLL_STATUS	NO	NO
EXPECTED_ENROLL_STATUS_DESC	Description of the student's expected enrollment status. No longer populated after aid year ending in 2014.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
FAMILY_IN_COLLEGE	Total number of family members in the student's household that attend college at least half time.	NUMBER	CALCULATION	DECODE(RCRAPP2_MODEL_CDE)	NO	NO
FAMILY_SIZE	Number of people in the student's household during the school year.	NUMBER	CALCULATION	DECODE(RCRAPP2_MODEL_CDE)	NO	NO
FATHER_HIGHEST_GRADE	Highest grade level completed by the father/mother/stepparent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FATHER_HI_GRADE	NO	NO
FATHER_WORK_INCOME	Amount of income earned from work by the student's father/mother/stepparent in the base year.	NUMBER	RCRAPP1	RCRAPP1_FATH_INC_FR_WRK	NO	NO
FEDERAL_SCHOOL_CODE	School Code that requested a dependency override or adjusted calculation request.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_TITLE_IV_CODE	NO	NO
FISAP_TOTAL_INCOME	Indicates the person's total FISAP income.	NUMBER	RCRAPP4	RCRAPP4_FISAP_INC	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(63)	RCRAPP2	RCRAPP2_C_1_CTRB_OFFL_EST	NO	NO
FM_CONTRIBUTION_OFFICIAL_DESC	Contribution official description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
FM_INAS	Student contribution for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_CTRB_FOR_STDT	NO	NO
FM_PARENT_CONTRIBUTION_ASSET	Portion of the primary parents 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_INAS	Primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FOR_STDT	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_WORKSHEET_A_TOTAL	Parents' Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_A	NO	NO
FM_TOTAL_FAMILY_CONTRIBUTION	Primary federal methodology total family contribution.	NUMBER	RCRAPP4	RCRAPP4_C_INST_1_TOT_FAM_CTRB	NO	NO
FM_TOTAL_INCOME	Total income used in the student's primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_TOT_INC	NO	NO
FM_WORKSHEET_A_TOTAL	Student's Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_A	NO	NO
GRADUATE_PROFESSIONAL_IND	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)	NO	NO
GRANT_SCHOLARSHIP_AID	Amount of student's grant and scholarship aid.	NUMBER	RCRAPP3	RCRAPP3_GRANT_SCHOLAR_AID	NO	NO
HOMELESS	Indicates whether student is homeless.	VARCHAR2(63)	RCRAPP4	RCRAPP4_HOMELESS	NO	NO
HOMELESS_DESC	Homeless indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
HOME_DEBT	Student's current outstanding debts against the home.	NUMBER	RCRAPP1	RCRAPP1_HME_DBT	NO	NO
HOME_VALUE	Current market value of the student's home.	NUMBER	RCRAPP1	RCRAPP1_HME_VAL	NO	NO
HOUSING	Housing code reported by the student applicant for the school that is receiving this application record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_INST_HOUS_CDE	NO	NO
HOUSING_DESC	Institutional housing code description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
HOUSING_FOOD_ALLOWANCE	Housing, food, and other living allowances paid to a student who are members of the military, clergy or others.	NUMBER	RCRAPP3	RCRAPP3_HOUSE_FOOD_OTH	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
IM_CONTRIBUTION	Institutional methodology calculated value for the 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_PARENT_CONTRIBUTION	Institutional methodology calculated value for the primary 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	RCRAPP2	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 primary parent contribution is official or estimated.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_OFFL_EST	NO	NO
IM_PARENT_CONTRIB_OFF_DESC	Description of the primary parent contribution.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	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_TOTAL_INCOME	Total income used in the calculation of the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_TOT_INC	NO	NO
IM_TOTAL_FAMILY_CONTRIBUTION	Primary institutional methodology for calculation of total family contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_TFC	NO	NO
IM_TOTAL_INCOME	Total income used in the student's primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TOT_INC	NO	NO
INAS_TFC	Total family contribution.	NUMBER	CALCULATION	NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL(RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0)	NO	NO
INCOME_TAX_PAID	Amount of federal income taxes paid by the student in the base year as reported on the student's income tax return.	NUMBER	RCRAPP1	RCRAPP1_US_INC_TAX_PD	NO	NO
INCOME_WORK	Amount of the student's base year income from working.	NUMBER	RCRAPP1	RCRAPP1_INC_FR_WRK	NO	NO
INTERFACE_TAPE_CODE	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).	VARCHAR2(63)	RCRAPP1	RCRAPP1_INFC_CODE	NO	NO
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(255)	RTVINFC	RTVINFC_DESC	NO	NO
INVESTMENT_NET_WORTH	Student's investment net worth.	NUMBER	RCRAPP4	RCRAPP4_INV_NET_WORTH	NO	NO
IRS_AGI_FLAG	Indicates whether IRS Adjusted Gross Income data for the student was transferred to the FAFSA.	VARCHAR2(63)	RCRAPP3	RCRAPP3_IRS_AGI_FLAG	NO	NO
IRS_AGI_FLAG_DESC	IRS Adjusted Gross Income data for the student was transferred to the FAFSA indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
IRS_DISPLAY_FLAG	Indicates whether IRS Data Retrieval Transfer option was displayed for the student.	VARCHAR2(63)	RCRAPP3	RCRAPP3_IRS_DISPLAY_FLAG	NO	NO
IRS_DISPLAY_FLAG_DESC	IRS Data Retrieval Transfer option was displayed for the student indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
IRS_FIT_FLAG	Indicates whether IRS Federal Income Tax data for the student was transferred to the FAFSA	VARCHAR2(63)	RCRAPP3	RCRAPP3_IRS_FIT_FLAG	NO	NO
IRS_FIT_FLAG_DESC	IRS Federal Income Tax data for the student was transferred to the FAFSA indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
IRS_REQUEST_STATUS	Status of the data request sent to the IRS for the parent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_IRS_REQUEST_FLAG	NO	NO
IRS_REQUEST_STATUS_DESC	IRS request status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
MARITAL_STATUS_IND	Indicates whether or not a student is married.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_MARRIED)	NO	NO
MOTHER_HIGHEST_GRADE	Highest grade level completed by the father/mother/stepparent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_MOTHER_HI_GRADE	NO	NO
MOTHER_WORK_INCOME	Amount of income earned from work by the student's father/mother/stepparent in the base year.	NUMBER	RCRAPP1	RCRAPP1_MOTH_INC_FR_WRK	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NEED_BASED_EMPLOYMENT	Amount of student's need based earnings.	NUMBER	RCRAPP3	RCRAPP3_NEED_BASED_EMPLOY	NO	NO
OFFICIAL_SOURCE_IND	Official or unofficial indicator.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)	NO	NO
OTHER_NON_REPORTED_MONEY	Amount of student's other non-reported money.	NUMBER	RCRAPP1	RCRAPP1_OTH_NON_REPORT_MONEY	NO	NO
OTHER_UNTAXED_INCOME	Student's reported base year other untaxed income and benefits.	NUMBER	RCRAPP1	RCRAPP1_OTH_UNTAXED_INC	NO	NO
PARENT_ADJUSTED_GROSS_INCOME	Amount of the AGI in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_US_INC	NO	NO
PARENT_ASSET_THRESHOLD_EXCEED	Parent asset threshold exceeded.	NUMBER	RCRAPP4	RCRAPP4_P_ASSET_THRESH_EXCD	NO	NO
PARENT_BUSINESS_NET_WORTH	Parent's business net worth.	NUMBER	RCRAPP4	RCRAPP4_PAR_BUS_NET_WORTH	NO	NO
PARENT_CASH_ASSET	Value of cash, savings and checking accounts reported by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_CASH_AMT	NO	NO
PARENT_CHILD_SUPPORT_INCOME	Amount of income received by the student's parents from child support for all children in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_CHILD_SUPP	NO	NO
PARENT_CHILD_SUPPORT_PAID	Amount paid for child support by the parents.	NUMBER	RCRAPP3	RCRAPP3_PAR_CHILD_SUPP_PAID	NO	NO
PARENT_COMBAT_PAY	Parent combat Pay	NUMBER	RCRAPP4	RCRAPP4_PAR_COMBAT_PAY	NO	NO
PARENT_COOPERATIVE_EARNINGS	Parents' earnings from work under a cooperative education program offered by a college.	NUMBER	RCRAPP3	RCRAPP3_PAR_CO_OP_EARNINGS	NO	NO
PARENT_DPDNT_CARE_CONTRIBUTION	The parents' contribution to a flexible spending account for dependent care.	NUMBER	RCRAPP4	RCRAPP4_PAR_DEPENDENT_CARE	NO	NO
PARENT_EDUCATION_TAX_CREDIT	Amount of educational tax credits that the parent has received.	NUMBER	RCRAPP3	RCRAPP3_PAR_EDUC_CREDITS	NO	NO
PARENT_FAMILY_IN_COLLEGE	Number of people in the parents household that will be enrolled in college at least half-time.	NUMBER	RCRAPP1	RCRAPP1_PAR_NO_IN_COLL	NO	NO
PARENT_FAMILY_SIZE	Number of family members in the parents household.	NUMBER	RCRAPP1	RCRAPP1_PAR_FAM_MEMB	NO	NO
PARENT_GRANT_SCHOLARSHIP_AID	Amount of parent's grant and scholarship aid.	NUMBER	RCRAPP3	RCRAPP3_PAR_GRANT_SCHOLAR_AID	NO	NO
PARENT_HEALTHCARE_CONTRIBUTION	The parents' contribution to a flexible spending account for health care.	NUMBER	RCRAPP4	RCRAPP4_PAR_FSA_HEALTH_CARE	NO	NO
PARENT_HOME_DEBT	Current outstanding debts against the home for the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_DBT	NO	NO
PARENT_HOME_VALUE	Current market value of the student's parents home.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_VAL	NO	NO
PARENT_HOUSING_FOOD_ALLOWANCE	Housing, food, and other living allowances paid to the parents who are members of the military, clergy, or others.	NUMBER	RCRAPP3	RCRAPP3_PAR_HOUSE_FOOD_OTH	NO	NO
PARENT_HSA_CONTRIBUTION	The parents' contribution to a health savings account.	NUMBER	RCRAPP4	RCRAPP4_PAR_HEALTH_SAV_ACCOUNT	NO	NO
PARENT_HSA_PRETAX_CONTRIBUTION	The amount withheld from the parent's pre-tax wages for a Heath Savings Account.	NUMBER	RCRAPP4	RCRAPP4_PAR_HSA_PRE_TAX	NO	NO
PARENT_INCOME_TAX_PAID	Amount of federal income taxes paid in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_US_INC_TAX_PD	NO	NO
PARENT_INVESTMENT_NET_WORTH	Parent's investment net worth.	NUMBER	RCRAPP4	RCRAPP4_PAR_INV_NET_WORTH	NO	NO
PARENT_IRS_AGI_FLAG	Indicates whether IRS Adjusted Gross Income data for the parent was transferred to the FAFSA.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_IRS_AGI_FLAG	NO	NO
PARENT_IRS_AGI_FLAG_DESC	IRS Adjusted Gross Income data for the parent was transferred to the FAFSA indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_IRS_DISPLAY_FLAG	Indicates whether IRS Data Retrieval Transfer option was displayed for the parent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_IRS_DISPLAY_FLAG	NO	NO
PARENT_IRS_DISPLAY_FLAG_DESC	IRS Data Retrieval Transfer option was displayed for the parent indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_IRS_FIT_FLAG	Indicates whether IRS Federal Income Tax data for the parent was transferred to the FAFSA.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_IRS_FIT_FLAG	NO	NO
PARENT_IRS_FIT_FLAG_DESC	IRS Federal Income Tax data for the parent was transferred to the FAFSA indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_IRS_REQUEST_STATUS	Status of the data request sent to the IRS for the student.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_IRS_REQUEST_FLAG	NO	NO
PARENT_IRS_REQUEST_STATUS_DESC	IRS request status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_NEED_BASED_EMPLOYMENT	Amount of parent's need based earnings.	NUMBER	RCRAPP3	RCRAPP3_PAR_NEED_BASED_EMPLOY	NO	NO
PARENT_NUMBER_OF_BUSINESSES	Parent number of businesses.	NUMBER	RCRAPP4	RCRAPP4_PAR_NUM_BUSINESSES	NO	NO
PARENT_NUMBER_OF_FARMS	Parent number of farms.	NUMBER	RCRAPP4	RCRAPP4_PAR_NUM_FARMS	NO	NO
PARENT_OTHER_UNTAXED_INCOME	Other untaxed income received in the base year by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_OTH_UNTAXED_INC	NO	NO
PARENT_RETIREMENT_PLAN_DISTRIB	Parent's untaxed IRA distributions.	NUMBER	RCRAPP1	RCRAPP1_PAR_IRA_DISTRIBUTIONS	NO	NO
PARENT_RETIREMENT_PLAN_PAYMENT	Parents' deductible IRA and/or Keogh payments.	NUMBER	RCRAPP3	RCRAPP3_PAR_IRA_KEOUGH	NO	NO
PARENT_SHORT_TAX_FORM_IND	Indicates whether the parent is eligible to file a federal short tax form.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_PAR_1040A_ELIG_IND)	NO	NO
PARENT_SNAP_FOOD_STAMPS	Indicates whether anyone in the parents' household received Supplemental Nutrition Assistance Program (SNAP) benefits.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_FOOD_STAMPS	NO	NO
PARENT_SNAP_FOOD_STAMPS_DESC	Parent received supplemental nutrition assistance description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_STATE_OF_RESIDENCE	State or province of legal residence for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES	NO	NO
PARENT_STATE_OF_RESIDENCE_DESC	Parents stare or province of legal residence description.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
PARENT_TAX_DEFERRED_PENSION	Parent's payments to tax-deferred pension and saving plans that are paid directly or withheld from earnings. Also contains the untaxed portion of 401(k) and 403(b) plans.	NUMBER	RCRAPP3	RCRAPP3_PAR_TAX_DEF_PENSION	NO	NO
PARENT_TAX_EXEMPT_INTEREST_INC	Parents' tax exempt interest income.	NUMBER	RCRAPP3	RCRAPP3_PAR_TE_INT_INC	NO	NO
PARENT_TAX_FILING_STATUS	The parents tax filing status.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_TAX_FILING_STATUS	NO	NO
PARENT_TAX_RETURN_FILED	Indicates whether the parent has already filed, will file or will not file a tax return.	VARCHAR2(63)	RCRAPP4	RCRAPP4_PAR_TX_RET_FILED_IND	NO	NO
PARENT_TAX_RETURN_FILED_DESC	Parent tax return filed dscription.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_TAX_RETURN_TYPE	Type of federal income tax return form the student's parents filed.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_TAX_FORM_IND	NO	NO
PARENT_TAX_RETURN_TYPE_DESC	Parent tax return type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_UNTAXED_PENSIONS	Parent's untaxed pensions.	NUMBER	RCRAPP1	RCRAPP1_PAR_UNTAX_PENSIONS	NO	NO
PARENT_VETERAN_NON_ED_BENEFIT	Parent's veterans non-education benefits.	NUMBER	RCRAPP1	RCRAPP1_PAR_VETS_NON_ED_BEN	NO	NO
PARENT_WORKSHEET_B_TOTAL	Parents' Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_B	NO	NO
PARENT_WORKSHEET_C_TOTAL	Parent's total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_C	NO	NO
PELL_EFC	Primary system Pell PGI.	NUMBER	RCRAPP2	RCRAPP2_PELL_PGI	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP1	RCRAPP1_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REJECTION_OVERRIDE20_IND	Set by electronic application user to override reject 20: Non-tax filer reported income is above the IRS filing requirement.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_20	NO	NO
REJECTION_OVERRIDE21_IND	Set by electronic application user to override reject 21: Student's corrected marital status date is greater than application receipt date and less than transaction receipt date.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_21	NO	NO
REJECTION_OVERRIDE2_IND	Set to 'Y' by the electronic application user to override rejection 2: Independent student status in question because of student's age. No longer used.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_2	NO	NO
REJECTION_OVERRIDE3_IND	Set to 'Y' by the electronic application user to override rejection 3: Student's taxes paid are greater than zero and equal to or greater than AGI.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_3	NO	NO
REJECTION_OVERRIDE4_IND	Set by electronic application user to override reject 4: Student's marital status date greater than date application was signed.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_4	NO	NO
REJECTION_OVERRIDE5_IND	Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank. No longer used.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_5	NO	NO
REJECTION_OVERRIDE7_IND	Set to 'Y' by the electronic application user to override rejection 7: Unusually large number of family members. No longer used.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_7	NO	NO
REJECTION_OVERRIDE_B_IND	Indicates if Reject B override accepted - Independent status in question because of student's age.	VARCHAR2(63)	RCRAPP3 RCRAPP3	RCRAPP3_REJECT_OVRD_1 RCRAPP3_REJECT_OVRD_B	NO NO	NO
REJECTION_OVERRIDE_N_IND	Set by electronic application user to override reject N: Missing first or last name.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_N	NO	NO
REJECTION_OVERRIDE_W_IND	Set by electronic application user to override reject W: Questionable number of family members, greater than 15.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_W	NO	NO
REJECT_REASON_PRIORITY_1	Reject Reason Priority 1	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_1	NO	NO
REJECT_REASON_PRIORITY_10	Reject Reason Priority 10	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_10	NO	NO
REJECT_REASON_PRIORITY_11	Reject Reason Priority 11	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_11	NO	NO
REJECT_REASON_PRIORITY_12	Reject Reason Priority 12	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_12	NO	NO
REJECT_REASON_PRIORITY_13	Reject Reason Priority 13	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_13	NO	NO
REJECT_REASON_PRIORITY_14	Reject Reason Priority 14	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_14	NO	NO
REJECT_REASON_PRIORITY_2	Reject Reason Priority 2	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_2	NO	NO
REJECT_REASON_PRIORITY_3	Reject Reason Priority 3	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_3	NO	NO
REJECT_REASON_PRIORITY_4	Reject Reason Priority 4	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_4	NO	NO
REJECT_REASON_PRIORITY_5	Reject Reason Priority 5	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_5	NO	NO
REJECT_REASON_PRIORITY_6	Reject Reason Priority 6	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_6	NO	NO
REJECT_REASON_PRIORITY_7	Reject Reason Priority 7	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_7	NO	NO
REJECT_REASON_PRIORITY_8	Reject Reason Priority 8	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_8	NO	NO
REJECT_REASON_PRIORITY_9	Reject Reason Priority 9	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJ_REASON_PRTY_9	NO	NO
RETIREMENT_PLAN_DISTRIBUTION	Amount of student's untaxed IRA distributions.	NUMBER	RCRAPP1	RCRAPP1_IRA_DISTRIBUTIONS	NO	NO
RETIREMENT_PLAN_PAYMENT	Parents' deductible IRA and/or Keogh payments.	NUMBER	RCRAPP4	RCRAPP4_IRA_KEOUGH_AMT	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(63)	CALCULATION	DECODE(RCRAPP2_ELIGIBILITY_MSG)	NO	NO
SAR_EFC	Identifies what the SAR EFC was for a person when they were added in data load.	NUMBER	RCRAPP4	RCRAPP4_SAR_EFC	NO	NO
SELECTED_FOR_VERIFICATION_IND	Indicates whether the student has been selected for verification by the department of education edits or by the institution.	VARCHAR2(63)	RCRAPP1	RCRAPP1_VERIFICATION_MSG	NO	NO
SHORT_TAX_FORM_IND	Indicates whether the student is eligible to file a federal short tax form.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_1040A_ELIG_IND)	NO	NO
SNAP_FOOD_STAMPS	Indicates whether anyone in the applicant's household received Supplemental Nutrition Assistance Program (SNAP) benefits.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FOOD_STAMPS	NO	NO
SNAP_FOOD_STAMPS_DESC	Received supplemental nutrition description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
SPOUSE_INCOME_WORK	Amount of income earned from work by the student's spouse in the base year.	NUMBER	RCRAPP1	RCRAPP1_SPS_INC_FR_WRK	NO	NO
STATE_OF_RESIDENCE	Student's state of legal residence.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_RES	NO	NO
STATE_OF_RESIDENCE_DESC	Name of the student's state, province of legal residence.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
SUPPORT_CHILDREN_IND	Student has children who receive more than half of their support from him/her.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_HAVE_CHILDREN)	NO	NO
TAX_DEFERRED_PENSION	Student's payments to tax-deferred pension and saving plans that are paid directly or withheld from earnings. Also contains the untaxed portion of 401(k) and 403(b) plans.	NUMBER	RCRAPP3	RCRAPP3_TAX_DEF_PENSION	NO	NO
TAX_EXEMPT_INTEREST_INC	Students' tax exempt interest income.	NUMBER	RCRAPP3	RCRAPP3_TE_INT_INC	NO	NO
TAX_FILING_STATUS	The student's tax filing status.	VARCHAR2(63)	RCRAPP1	RCRAPP1_TAX_FILING_STATUS	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	RCRAPP1	RCRAPP1_SSN	NO	NO
TAX_ID_MATCH_STATUS	Tax ID match status.	VARCHAR2(63)	RCRAPP3	RCRAPP3_SOC_SEC	NO	NO
TAX_ID_MATCH_STATUS_DESC	Tax ID match status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
TAX_RETURN_FILED	Indicates whether the student has already filed, will file or will not file a tax return.	VARCHAR2(63)	RCRAPP4	RCRAPP4_TX_RET_FILED_IND	NO	NO
TAX_RETURN_FILED_DESC	Student tax return filed description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
TAX_RETURN_TYPE	Indicates which type of federal tax return the student filed (or will file) and whether or not the income data is estimated.	VARCHAR2(63)	RCRAPP1	RCRAPP1_TAX_FORM_IND	NO	NO
TAX_RETURN_TYPE_DESC	Description of the tax return type.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
TRANSACTION_NUMBER	The one up sequence number assigned by the Central Processing System to this application/correction record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USED_TRANS_NO	NO	NO
UNTAXED_PENSIONS	Amount of student's untaxed pensions.	NUMBER	RCRAPP1	RCRAPP1_UNTAX_PENSIONS	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USER_ID	NO	NO
VERIFICATION_PRIORITY	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(63)	RCRAPP1	RCRAPP1_VERIFICATION_PRTY	NO	NO
VERIFICATION_PRIORITY_DESC	Description of the priority of the edits used to select the student for data verification.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
VETERAN_BENEFITS_TYPE	Type of veteran's benefits that the student is receiving.	VARCHAR2(63)	RCRAPP1	RCRAPP1_TYPE_VET_BENEFITS	NO	NO
VETERAN_BENEFITS_TYPE_DESC	Veteran benefits type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
VETERAN_MONTHLY_OTHER_BENEFITS	Amount per month from other Veteran Educational Benefit programs.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_AMT	NO	NO
VETERAN_NON_EDUCATION_BENEFIT	Amount of student's veterans non-education benefits.	NUMBER	RCRAPP1	RCRAPP1_VETS_NON_ED_BEN	NO	NO
VETERAN_OTHER_BENEFITS_MONTHS	Number of months that the other VA benefits will be received during the award year.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_MTH	NO	NO
VETERAN_RECEIVING_BENEFITS	Indicates whether the student is receiving veteran's benefits.	VARCHAR2(63)	RCRAPP1	RCRAPP1_RECV_VET_BENEFITS	NO	NO
VETERAN_RECEIVING_BENEFIT_DESC	Veteran receiving benefits indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
WORKSHEET_B_TOTAL	Student's Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_B	NO	NO
WORKSHEET_C_TOTAL	Student and spouse total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_C	NO	NO
YEAR_IN_COLLEGE	Year of study (first, second, etc.) that the student enrolls in this year.	VARCHAR2(63)	RCRAPP1	RCRAPP1_YR_IN_COLL	NO	NO
YEAR_IN_COLLEGE_DESC	Description of the year of studty.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO

Ver: 9.2