Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRAPP1	RCRAPP1_ACTIVITY_DATE
ADJUSTED_EFC_CALC_REQUEST	Contains a request to calculate the adjusted Effective Family Contribution.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ADJ_EFC_CALC_REQ
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
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ADOPTED_AFTER_13	Indicates whether student was adopted after age 13.	VARCHAR2(63)	RCRAPP4	RCRAPP4_ADOPTED_AFTER_13
ADOPTED_AFTER_13_DESC	Adopted after 13 indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
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
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP1	RCRAPP1_SEQ_NO
ASSET_THRESHOLD_EXCEED	Student asset threshold exceeded.	NUMBER	RCRAPP4	RCRAPP4_S_ASSET_THRESH_EXCD
BUSINESS_DEBT	Amount of the student's outstanding debts against business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_DBT
BUSINESS_NET_WORTH	Student's business net worth.	NUMBER	RCRAPP4	RCRAPP4_BUS_NET_WORTH
BUSINESS_VALUE	Current market value of the student's business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_VAL
CASH_SAVINGS	Amount the student currently has in cash on hand and in savings and checking accounts.	NUMBER	RCRAPP1	RCRAPP1_CASH_AMT
CHILD_CARE_NUMBER	Number of dependent children for whom the student will pay child care expenses.	NUMBER	RCRAPP3	RCRAPP3_CHILD_CARE
CHILD_SUPPORT_INCOME	Student's base year income from child support received for all children.	NUMBER	RCRAPP1	RCRAPP1_CHILD_SUPP
CHILD_SUPPORT_PAID	Amount paid for child support by a student.	NUMBER	RCRAPP3	RCRAPP3_CHILD_SUPP_PAID
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
COLLEGE_CHOICE1	Student's first choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1
COLLEGE_CHOICE10	Student's tenth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_10
COLLEGE_CHOICE2	Student's second choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2
COLLEGE_CHOICE3	Student's third choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3
COLLEGE_CHOICE4	Student's fourth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_4
COLLEGE_CHOICE5	Student's fifth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_5
COLLEGE_CHOICE6	Student's sixth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_6
COLLEGE_CHOICE7	Student's seventh choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_7
COLLEGE_CHOICE8	Student's eighth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_8
COLLEGE_CHOICE9	Student's ninth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_9
COMBAT_PAY	Student combat Pay	NUMBER	RCRAPP4	RCRAPP4_COMBAT_PAY
COOPERATIVE_EARNINGS	Student's earnings from work under a cooperative education program offered by a college	NUMBER	RCRAPP3	RCRAPP3_CO_OP_EARNINGS
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CURR_REC_IND
DEGREE_TYPE	Contains the abbreviation of the degree or certificate a student is pursuing.	VARCHAR2(63)	RCRAPP3	RCRAPP3_DEGREE_TYPE
DEGREE_TYPE_DESC	Degree type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
DEPENDENCY_INDEPEND	Code that indicates if the student is independent or dependent.	VARCHAR2(63)	RCRAPP2	RCRAPP2_MODEL_CDE
DEPENDENCY_INDEPEND_DESC	Depend independ code description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
DEPENDENCY_OVERRIDE	Used by the financial aid administrator to override dependency.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE
DEPENDENCY_OVERRIDE_DESC	Dependency override description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_FAA_DEP_OVERRIDE)
DEPENDENCY_STATUS	Indicates the students dependency status as computed by INAS or loaded from the tape record.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_DEPEND_STATUS
DEPENDENCY_STATUS_DESC	Students dependency status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_C_DEPEND_STATUS)
DRIVER_LICENSE_NUMBER	Student's drivers license number.	VARCHAR2(63)	RCRAPP1	RCRAPP1_DRIVER_LIC_NO
DRIVER_LICENSE_STATE_PROVINCE	State or province that issued the student's drivers license.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_LIC
DRIVER_LICENSE_STATE_PROV_DESC	Description of the state or province in which the student holds a drivers license.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
EDUCATION_TAX_CREDIT	Amount of educational tax credits that the student has received.	NUMBER	RCRAPP3	RCRAPP3_EDUC_CREDITS
EFC_RECALC_SPECIAL_CIRCUM	Indicates a request to the CPS to recalculate the Effective Family Contribution.	VARCHAR2(63)	RCRAPP3	RCRAPP3_EFC_RECALC_CORR_REQ
EFC_RECALC_SPECIAL_CIRCUM_DESC	Request to the CPS to recalculate the Effective Family Contribution indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
EMAIL_ADDRESS	Student's e-mail address as reported on PROFILE.	VARCHAR2(255)	RCRAPP4	RCRAPP4_EMAIL_ADDRESS
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
ENROLLMENT_PLANNING_SERV_DESC	Enrollment planning service description.	VARCHAR2(255)	STVEPSC	STVEPSC_DESC
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
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
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)
FAMILY_SIZE	Number of people in the student's household during the school year.	NUMBER	CALCULATION	DECODE(RCRAPP2_MODEL_CDE)
FATHER_HIGHEST_GRADE	Highest grade level completed by the father/mother/stepparent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FATHER_HI_GRADE
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
FEDERAL_SCHOOL_CODE	School Code that requested a dependency override or adjusted calculation request.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_TITLE_IV_CODE
FM_CONTRIBUTION_ASSET	Student's contribution from assets for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_CTRB_FR_ASSET
FM_CONTRIBUTION_INCOME	Student's contribution from income for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_CTRB_FR_INC
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
FM_CONTRIBUTION_OFFICIAL_DESC	Contribution official description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
FM_INAS	Student contribution for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_CTRB_FOR_STDT
FM_PARENT_CONTRIBUTION_ASSET	Portion of the primary parents contribution that came from assets.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FR_ASSET
FM_PARENT_CONTRIBUTION_INCOME	Portion of the primary parent contribution that came from income.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FR_INC
FM_PARENT_INAS	Primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FOR_STDT
FM_PARENT_TOTAL_INCOME	Total income used in the calculation of the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_TOT_INC
FM_PARENT_WORKSHEET_A_TOTAL	Parents' Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_A
FM_TOTAL_FAMILY_CONTRIBUTION	Primary federal methodology total family contribution.	NUMBER	RCRAPP4	RCRAPP4_C_INST_1_TOT_FAM_CTRB
FM_TOTAL_INCOME	Total income used in the student's primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_TOT_INC
FM_WORKSHEET_A_TOTAL	Student's Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_A
GRADUATE_PROFESSIONAL_IND	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)
GRANT_SCHOLARSHIP_AID	Amount of student's grant and scholarship aid.	NUMBER	RCRAPP3	RCRAPP3_GRANT_SCHOLAR_AID
HOMELESS	Indicates whether student is homeless.	VARCHAR2(63)	RCRAPP4	RCRAPP4_HOMELESS
HOMELESS_DESC	Homeless indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
HOME_DEBT	Student's current outstanding debts against the home.	NUMBER	RCRAPP1	RCRAPP1_HME_DBT
HOME_VALUE	Current market value of the student's home.	NUMBER	RCRAPP1	RCRAPP1_HME_VAL
HOUSING	Housing code reported by the student applicant for the school that is receiving this application record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_INST_HOUS_CDE
HOUSING_DESC	Institutional housing code description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
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
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
IM_CONTRIBUTION	Institutional methodology calculated value for the student contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_SC
IM_CONTRIBUTION_ASSET	Student's contribution from assets for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CTRB_FR_ASSET
IM_CONTRIBUTION_INCOME	Student's contribution from income for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CTRB_FR_INC
IM_PARENT_CONTRIBUTION	Institutional methodology calculated value for the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_PC
IM_PARENT_CONTRIBUTION_ASSET	Portion of the primary parent contribution that came from income.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FR_ASSET
IM_PARENT_CONTRIBUTION_INCOME	Portion of the primary parent contribution that came from income.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FR_INC
IM_PARENT_CONTRIB_OFFICIAL	Indicates if the primary parent contribution is official or estimated.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_OFFL_EST
IM_PARENT_CONTRIB_OFF_DESC	Description of the primary parent contribution.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
IM_PARENT_TOTAL_INCOME	Total income used in the calculation of the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_TOT_INC
IM_TOTAL_FAMILY_CONTRIBUTION	Primary institutional methodology for calculation of total family contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_TFC
IM_TOTAL_INCOME	Total income used in the student's primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TOT_INC
INAS_TFC	Total family contribution.	NUMBER	CALCULATION	LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
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
INCOME_WORK	Amount of the student's base year income from working.	NUMBER	RCRAPP1	RCRAPP1_INC_FR_WRK
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
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(255)	RTVINFC	RTVINFC_DESC
INVESTMENT_NET_WORTH	Student's investment net worth.	NUMBER	RCRAPP4	RCRAPP4_INV_NET_WORTH
IRS_REQUEST_STATUS	Status of the data request sent to the IRS for the parent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_IRS_REQUEST_FLAG
IRS_REQUEST_STATUS_DESC	IRS request status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
MARITAL_STATUS_IND	Indicates whether or not a student is married.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_MARRIED)
MOTHER_HIGHEST_GRADE	Highest grade level completed by the father/mother/stepparent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_MOTHER_HI_GRADE
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
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NEED_BASED_EMPLOYMENT	Amount of student's need based earnings.	NUMBER	RCRAPP3	RCRAPP3_NEED_BASED_EMPLOY
OFFICIAL_SOURCE_IND	Official or unofficial indicator.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)
OTHER_NON_REPORTED_MONEY	Amount of student's other non-reported money.	NUMBER	RCRAPP1	RCRAPP1_OTH_NON_REPORT_MONEY
OTHER_UNTAXED_INCOME	Student's reported base year other untaxed income and benefits.	NUMBER	RCRAPP1	RCRAPP1_OTH_UNTAXED_INC
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
PARENT_ASSET_THRESHOLD_EXCEED	Parent asset threshold exceeded.	NUMBER	RCRAPP4	RCRAPP4_P_ASSET_THRESH_EXCD
PARENT_BUSINESS_NET_WORTH	Parent's business net worth.	NUMBER	RCRAPP4	RCRAPP4_PAR_BUS_NET_WORTH
PARENT_CASH_ASSET	Value of cash, savings and checking accounts reported by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_CASH_AMT
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
PARENT_CHILD_SUPPORT_PAID	Amount paid for child support by the parents.	NUMBER	RCRAPP3	RCRAPP3_PAR_CHILD_SUPP_PAID
PARENT_COMBAT_PAY	Parent combat Pay	NUMBER	RCRAPP4	RCRAPP4_PAR_COMBAT_PAY
PARENT_COOPERATIVE_EARNINGS	Parents' earnings from work under a cooperative education program offered by a college.	NUMBER	RCRAPP3	RCRAPP3_PAR_CO_OP_EARNINGS
PARENT_EDUCATION_TAX_CREDIT	Amount of educational tax credits that the parent has received.	NUMBER	RCRAPP3	RCRAPP3_PAR_EDUC_CREDITS
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
PARENT_FAMILY_SIZE	Number of family members in the parents household.	NUMBER	RCRAPP1	RCRAPP1_PAR_FAM_MEMB
PARENT_GRANT_SCHOLARSHIP_AID	Amount of parent's grant and scholarship aid.	NUMBER	RCRAPP3	RCRAPP3_PAR_GRANT_SCHOLAR_AID
PARENT_HOME_DEBT	Current outstanding debts against the home for the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_DBT
PARENT_HOME_VALUE	Current market value of the student's parents home.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_VAL
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
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
PARENT_INVESTMENT_NET_WORTH	Parent's investment net worth.	NUMBER	RCRAPP4	RCRAPP4_PAR_INV_NET_WORTH
PARENT_IRS_REQUEST_STATUS	Status of the data request sent to the IRS for the student.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_IRS_REQUEST_FLAG
PARENT_IRS_REQUEST_STATUS_DESC	IRS request status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
PARENT_NEED_BASED_EMPLOYMENT	Amount of parent's need based earnings.	NUMBER	RCRAPP3	RCRAPP3_PAR_NEED_BASED_EMPLOY
PARENT_NUMBER_OF_BUSINESSES	Parent number of businesses.	NUMBER	RCRAPP4	RCRAPP4_PAR_NUM_BUSINESSES
PARENT_NUMBER_OF_FARMS	Parent number of farms.	NUMBER	RCRAPP4	RCRAPP4_PAR_NUM_FARMS
PARENT_OTHER_UNTAXED_INCOME	Other untaxed income received in the base year by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_OTH_UNTAXED_INC
PARENT_RETIREMENT_PLAN_DISTRIB	Parent's untaxed IRA distributions.	NUMBER	RCRAPP1	RCRAPP1_PAR_IRA_DISTRIBUTIONS
PARENT_RETIREMENT_PLAN_PAYMENT	Parents' deductible IRA and/or Keogh payments.	NUMBER	RCRAPP3	RCRAPP3_PAR_IRA_KEOUGH
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)
PARENT_STATE_OF_RESIDENCE	State or province of legal residence for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES
PARENT_STATE_OF_RESIDENCE_DESC	Parents stare or province of legal residence description.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
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
PARENT_TAX_EXEMPT_INTEREST_INC	Parents' tax exempt interest income.	NUMBER	RCRAPP3	RCRAPP3_PAR_TE_INT_INC
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
PARENT_TAX_RETURN_FILED_DESC	Parent tax return filed dscription.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
PARENT_TAX_RETURN_TYPE	Type of federal income tax return form the student's parents filed.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_TAX_FORM_IND
PARENT_TAX_RETURN_TYPE_DESC	Parent tax return type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
PARENT_UNTAXED_PENSIONS	Parent's untaxed pensions.	NUMBER	RCRAPP1	RCRAPP1_PAR_UNTAX_PENSIONS
PARENT_VETERAN_NON_ED_BENEFIT	Parent's veterans non-education benefits.	NUMBER	RCRAPP1	RCRAPP1_PAR_VETS_NON_ED_BEN
PARENT_WORKSHEET_B_TOTAL	Parents' Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_B
PARENT_WORKSHEET_C_TOTAL	Parent's total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_C
PELL_EFC	Primary system Pell PGI.	NUMBER	RCRAPP2	RCRAPP2_PELL_PGI
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP1	RCRAPP1_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
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
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
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
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
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
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
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
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
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
RETIREMENT_PLAN_DISTRIBUTION	Amount of student's untaxed IRA distributions.	NUMBER	RCRAPP1	RCRAPP1_IRA_DISTRIBUTIONS
RETIREMENT_PLAN_PAYMENT	Parents' deductible IRA and/or Keogh payments.	NUMBER	RCRAPP4	RCRAPP4_IRA_KEOUGH_AMT
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)
SAR_EFC	Identifies what the SAR EFC was for a person when they were added in data load.	NUMBER	RCRAPP4	RCRAPP4_SAR_EFC
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
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)
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
STATE_OF_RESIDENCE	Student's state of legal residence.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_RES
STATE_OF_RESIDENCE_DESC	Name of the student's state, province of legal residence.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
SUPPORT_CHILDREN_IND	Student has children who receive more than half of their support from him/her.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_HAVE_CHILDREN)
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
TAX_EXEMPT_INTEREST_INC	Students' tax exempt interest income.	NUMBER	RCRAPP3	RCRAPP3_TE_INT_INC
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	RCRAPP1	RCRAPP1_SSN
TAX_ID_MATCH_STATUS	Tax ID match status.	VARCHAR2(63)	RCRAPP3	RCRAPP3_SOC_SEC
TAX_ID_MATCH_STATUS_DESC	Tax ID match status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
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
TAX_RETURN_FILED_DESC	Student tax return filed description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
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
TAX_RETURN_TYPE_DESC	Description of the tax return type.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
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
UNTAXED_PENSIONS	Amount of student's untaxed pensions.	NUMBER	RCRAPP1	RCRAPP1_UNTAX_PENSIONS
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USER_ID
VERIFICATION_PRIORITY	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(63)	RCRAPP1	RCRAPP1_VERIFICATION_PRTY
VETERAN_BENEFITS_TYPE	Type of veteran's benefits that the student is receiving.	VARCHAR2(63)	RCRAPP1	RCRAPP1_TYPE_VET_BENEFITS
VETERAN_BENEFITS_TYPE_DESC	Veteran benefits type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
VETERAN_MONTHLY_OTHER_BENEFITS	Amount per month from other Veteran Educational Benefit programs.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_AMT
VETERAN_NON_EDUCATION_BENEFIT	Amount of student's veterans non-education benefits.	NUMBER	RCRAPP1	RCRAPP1_VETS_NON_ED_BEN
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
VETERAN_RECEIVING_BENEFITS	Indicates whether the student is receiving veteran's benefits.	VARCHAR2(63)	RCRAPP1	RCRAPP1_RECV_VET_BENEFITS
VETERAN_RECEIVING_BENEFIT_DESC	Veteran receiving benefits indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
WORKSHEET_B_TOTAL	Student's Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_B
WORKSHEET_C_TOTAL	Student and spouse total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_C
YEAR_IN_COLLEGE	Year of study (first, second, etc.) that the student enrolls in this year.	VARCHAR2(63)	RCRAPP1	RCRAPP1_YR_IN_COLL
YEAR_IN_COLLEGE_DESC	Description of the year of studty.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC

Ver: 9.1