Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRAPP3	RCRAPP3_ACTIVITY_DATE
ADJUSTED_EFC_CALC_REQUEST	Contains a request to calculate the adjusted Effective Family Contribution.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ADJ_EFC_CALC_REQ
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RCRAPP3	RCRAPP3_AIDY_CODE
APPLICATION_COMPLETE_MONTH_DAY	Contains the month and day the application was completed.	VARCHAR2(4)	RCRAPP3	RCRAPP3_C_SIGNED_MTH_DAY
APPLICATION_COMPLETE_YEAR	Contains the year the application was completed.	VARCHAR2(1)	RCRAPP3	RCRAPP3_C_SIGNED_YR
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP3	RCRAPP3_SEQ_NO
ASSUMPTION_OVERRIDE1_IND	Set by electronic application user to override assumption 1: Parent's Number of Family Members assumed to be 3.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_1
ASSUMPTION_OVERRIDE2_IND	Set by electronic application user to override assumption 2: Parent's Number of College assumed to be 1.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_2
ASSUMPTION_OVERRIDE3_IND	Set by electronic application user to override assumption 3: Parent's AGI assumed equal to sum of parent's earned income portions.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_3
ASSUMPTION_OVERRIDE4_IND	Set by electronic application user to override assumption 4: Student's Number of College assumed to be 1.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_4
ASSUMPTION_OVERRIDE5_IND	Set by electronic application user to override assumption 5: Student's AGI assumed equal to sum of student's and spouse's earned income portions.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_5
ASSUMPTION_OVERRIDE6_IND	Set by electronic application user to override assumption 6: Student's social security benefits assumed to be zero.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_6
ASSUMPTION_OVERRIDE7_IND	Set by electronic application user to override assumption 7: Student's other real estate/investment value and debt assumed to be zero.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_7
ASSUMPTION_OVERRIDE8_IND	Set by electronic application user to override assumption 8: Student's business value and debt assumed to be zero.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_8
ASSUMPTION_OVERRIDE9_IND	Set by electronic application user to override assumption 9: Student's farm value and debt assumed to be zero.	VARCHAR2(1)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_9
BUSINESS_DEBT	Student's farm debt.	NUMBER	RCRAPP3	RCRAPP3_FARM_DBT
BUSINESS_VALUE	Student's farm value.	NUMBER	RCRAPP3	RCRAPP3_FARM_VAL
CHILD_CARE_NUMBER	Number of dependent children for whom the student will pay child care expenses.	NUMBER	RCRAPP3	RCRAPP3_CHILD_CARE
CHILD_SUPPORT_PAID	Contains the amount paid for child support by a student.	NUMBER	RCRAPP3	RCRAPP3_CHILD_SUPP_PAID
COLLEGE_CHOICE10		VARCHAR2(6)
COLLEGE_CHOICE4	Fourth college choice a student plans to attend.	VARCHAR2(6)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_4
COLLEGE_CHOICE5	Fifth college choice a student plans to attend.	VARCHAR2(6)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_5
COLLEGE_CHOICE6	Sixth college choice a student plans to attend.	VARCHAR2(6)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_6
COLLEGE_CHOICE7		VARCHAR2(6)
COLLEGE_CHOICE8		VARCHAR2(6)
COLLEGE_CHOICE9		VARCHAR2(6)
COOPERATIVE_EARNINGS		NUMBER
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DEGREE_TYPE	Contains the abbreviation of the degree or certificate a student is pursuing.	VARCHAR2(3)	RCRAPP3	RCRAPP3_DEGREE_TYPE
DEGREE_TYPE_DESC	Degree type description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP3_DEGREE_TYPE)
DEPENDENCY_OVERRIDE	Used by the financial aid administrator to override dependency.	VARCHAR2(1)	RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE
DEPENDENCY_OVERRIDE_DESC	Dependency override description.	VARCHAR2(70)	CALCULATION	DECODE(RCRAPP3_FAA_DEP_OVERRIDE)
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
EDUCATION_TAX_CREDIT		NUMBER
EFC_RECALC_SPECIAL_CIRCUM		VARCHAR2(1)
EFC_RECALC_SPECIAL_CIRCUM_DESC		VARCHAR2(4000)
FATHER_AGE	Father's age.	VARCHAR2(2)	RCRAPP3	RCRAPP3_FATHER_AGE
FATHER_HIGHEST_GRADE	Highest grade level completed by the father.	VARCHAR2(1)	RCRAPP3	RCRAPP3_FATHER_HI_GRADE
FATHER_SIGNATURE_IND	Indicates whether or not a father's signature is on the application.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_C_SIGNED_FATH)
FATHER_TAX_ID_MATCH	Father's/Stepfather's Tax ID Match Flag.	VARCHAR2(1)	RCRAPP3	RCRAPP3_FATH_SSN_MATCH
FATHER_TAX_ID_MATCH_DESC	Father Tax ID match description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP3_FATH_SSN_MATCH)
FEDERAL_SCHOOL_CODE	School Code that requested a dependency override or adjusted calculation request.	VARCHAR2(6)	RCRAPP3	RCRAPP3_FAA_TITLE_IV_CODE
GRADUATE_PROFESSIONAL_IND	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)
GRANT_SCHOLARSHIP_AID		NUMBER
HOUSING_FOOD_ALLOWANCE		NUMBER
IM_PARENT_TUITION_FEE_DEDUCT	Tuition and fees deduction from federal tax forms.	NUMBER	RCRAPP3	RCRAPP3_PAR_TUI_FEE_DED
INTERFACE_TAPE_CODE	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).	VARCHAR2(7)	RCRAPP3	RCRAPP3_INFC_CODE
INVESTMENT_DEBT	Student's investment debt.	NUMBER	RCRAPP3	RCRAPP3_INVEST_DBT
INVESTMENT_VALUE	Student's investment value.	NUMBER	RCRAPP3	RCRAPP3_INVEST_VAL
IRS_REQUEST_STATUS		VARCHAR2(2)
IRS_REQUEST_STATUS_DESC		VARCHAR2(4000)
MARITAL_STATUS_DATE	Month and year the student is married, widowed, separated, or divorced.	VARCHAR2(6)	RCRAPP3	RCRAPP3_S_MAR_MTH_YR
MARITAL_STATUS_IND	Indicates whether or not a student is married.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_MARRIED)
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA
MOTHER_AGE	Mother's age.	VARCHAR2(2)	RCRAPP3	RCRAPP3_MOTHER_AGE
MOTHER_HIGHEST_GRADE	Highest grade level completed by the mother.	VARCHAR2(1)	RCRAPP3	RCRAPP3_MOTHER_HI_GRADE
MOTHER_SIGNATURE_IND	Indicates whether or not a mother's signature is on the application.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_C_SIGNED_MOTH)
MOTHER_TAX_ID_MATCH	Mother's/Stepmother's Tax ID Match Flag.	VARCHAR2(1)	RCRAPP3	RCRAPP3_MOTH_SSN_MATCH
MOTHER_TAX_ID_MATCH_DESC	Mother Tax ID match description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP3_MOTH_SSN_MATCH)
NEED_BASED_EMPLOYMENT		NUMBER
OFFICIAL_SOURCE_IND	Official or unofficial indicator.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)
PARENT_BUSINESS_DEBT	Parents' business debt.	NUMBER	RCRAPP3	RCRAPP3_PAR_BUS_DBT
PARENT_BUSINESS_VALUE	Parents' business value.	NUMBER	RCRAPP3	RCRAPP3_PAR_BUS_VAL
PARENT_CHILD_SUPPORT_PAID	Amount paid for child support by the parents.	NUMBER	RCRAPP3	RCRAPP3_PAR_CHILD_SUPP_PAID
PARENT_COOPERATIVE_EARNINGS		NUMBER
PARENT_EARNED_INCOME_CREDIT	Parents' earned income credit.	NUMBER	RCRAPP3	RCRAPP3_PAR_EIC
PARENT_EDUCATION_TAX_CREDIT		NUMBER
PARENT_FARM_DEBT	Parents' farm debt.	NUMBER	RCRAPP3	RCRAPP3_PAR_FARM_DBT
PARENT_FARM_VALUE	Parents' farm value.	NUMBER	RCRAPP3	RCRAPP3_PAR_FARM_VAL
PARENT_FOREIGN_INC_EXCLUSION	Parents' foreign income exclusion.	NUMBER	RCRAPP3	RCRAPP3_PAR_FOR_INC_EXCL
PARENT_GRANT_SCHOLARSHIP_AID		NUMBER
PARENT_HOUSING_FOOD_ALLOWANCE	Housing, food,and other living allowances paid by the parents to the members of the military, clergy, and others.	NUMBER	RCRAPP3	RCRAPP3_PAR_HOUSE_FOOD_OTH
PARENT_INVESTMENT_DEBT	Parents' investment debt.	NUMBER	RCRAPP3	RCRAPP3_PAR_INVEST_DBT
PARENT_INVESTMENT_VALUE	Parents' investment value.	NUMBER	RCRAPP3	RCRAPP3_PAR_INVEST_VAL
PARENT_IRS_REQUEST_STATUS		VARCHAR2(2)
PARENT_IRS_REQUEST_STATUS_DESC		VARCHAR2(4000)
PARENT_MARITAL_STATUS_DATE	Month and year the parents were married, widowed, separated, or divorced.	VARCHAR2(6)	RCRAPP3	RCRAPP3_PAR_MAR_MTH_YR
PARENT_MORTGAGE_RENT_PAYMENT	Parents' monthly home mortgage or rental payment.	NUMBER	RCRAPP3	RCRAPP3_PAR_MTH_MORT_RENT_PAY
PARENT_NEED_BASED_EMPLOYMENT		NUMBER
PARENT_REAL_ESTATE_DEBT	Parents' real estate debt.	NUMBER	RCRAPP3	RCRAPP3_PAR_RE_DBT
PARENT_REAL_ESTATE_VALUE	Parents' real estate value.	NUMBER	RCRAPP3	RCRAPP3_PAR_RE_VAL
PARENT_RESIDE_FARM_IND	Indicates whether or not the parents are living on a farm.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_PAR_LIVE_ON_FARM)
PARENT_RETIREMENT_PLAN_PAYMENT	Parents' deductible IRA and/or keough payments.	NUMBER	RCRAPP3	RCRAPP3_PAR_IRA_KEOUGH
PARENT_TAX_DEFERRED_PENSION	Parents' 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_TOTAL_UNTAXED_INCOME	Parents' untaxed income and benefits.	NUMBER	RCRAPP3	RCRAPP3_PAR_INC_BENEFITS
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP3	RCRAPP3_PIDM
PREPARER_EIN	Preparer's employee identification number.	VARCHAR2(9)	RCRAPP3	RCRAPP3_PREPARER_EIN
PREPARER_SIGNATURE_IND	Indicates whether or not the preparer's signature is on the application.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_PREPARER_SIGN)
PREPARER_TAX_ID	Preparer' social security number.	VARCHAR2(15)	RCRAPP3	RCRAPP3_PREPARER_SSN
REAL_ESTATE_DEBT	Student's real estate debt.	NUMBER	RCRAPP3	RCRAPP3_RE_DBT
REAL_ESTATE_VALUE	Student's real estate value.	NUMBER	RCRAPP3	RCRAPP3_RE_VAL
REJECTION_OVERRIDE20_IND		VARCHAR2(1)
REJECTION_OVERRIDE21_IND		VARCHAR2(1)
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(1)	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(1)	RCRAPP3	RCRAPP3_REJECT_OVRD_3
REJECTION_OVERRIDE4_IND		VARCHAR2(1)
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(1)	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(1)	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(1)	RCRAPP3	RCRAPP3_REJECT_OVRD_1
REJECTION_OVERRIDE_N_IND	Set by electronic application user to override reject N: Missing first or last name.	VARCHAR2(1)	RCRAPP3	RCRAPP3_REJECT_OVRD_4
REJECTION_OVERRIDE_W_IND	Set by electronic application user to override reject W: Questionable number of family members, greater than 15.	VARCHAR2(1)	RCRAPP3	RCRAPP3_REJECT_OVRD_6
RESIDE_FARM_IND	Indicates whether or not a student is living on a farm.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_LIVE_ON_FARM)
SIGNATURE_IND	Indicates whether or not a student's signature ison the application.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_C_SIGNED)
SPECIAL_CIRCUMSTANCE		VARCHAR2(1)
SPECIAL_CIRCUMSTANCE_DESC		VARCHAR2(4000)
SPOUSE_SIGNATURE_IND	Indicates whether or not a spouse's signature is on the application.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP3_C_SIGNED_SPS)
TAX_DEFERRED_PENSION		NUMBER
TAX_EXEMPT_INTEREST_INC		NUMBER
TAX_ID_MATCH_STATUS	Tax ID match status.	VARCHAR2(1)	RCRAPP3	RCRAPP3_SOC_SEC
TAX_ID_MATCH_STATUS_DESC	Tax ID match status description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP3_SOC_SEC)
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RCRAPP3	RCRAPP3_USER_ID
YEAR_IN_COLLEGE2	Year of study (first, second, etc.) that the student enrolls in this year.	VARCHAR2(1)	RCRAPP3	RCRAPP3_YR_IN_COLL_2
YEAR_IN_COLLEGE2_DESC	Description of the year of study.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP3_YR_IN_COLL_2)
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: