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		RCRAPP3	RCRAPP3_ACTIVITY_DATE
ADJUSTED_EFC_CALC_REQUEST	Adjusted Effective Family Contribution Calculated Request	Contains a request to calculate the adjusted Effective Family Contribution.	VARCHAR2(1)		RCRAPP3	RCRAPP3_ADJ_EFC_CALC_REQ
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)		RCRAPP3	RCRAPP3_AIDY_CODE
APPLICATION_COMPLETE_MONTH_DAY	Application Completion Month Day	Contains the month and day the application was completed.	VARCHAR2(4)		RCRAPP3	RCRAPP3_C_SIGNED_MTH_DAY
APPLICATION_COMPLETE_YEAR	Application Completion Year	Contains the year the application was completed.	VARCHAR2(1)		RCRAPP3	RCRAPP3_C_SIGNED_YR
APPLICATION_NUMBER	Application Number	Financial aid application unique sequence number.	NUMBER(3)		RCRAPP3	RCRAPP3_SEQ_NO
ASSUMPTION_OVERRIDE1_IND	Assumption Override 1 Indicator	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	Assumption Override 2 Indicator	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	Assumption Override 3 Indicator	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	Assumption Override 4 Indicator	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	Assumption Override 5 Indicator	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	Assumption Override 6 Indicator	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	Assumption Override 7 Indicator	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	Assumption Override 8 Indicator	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	Assumption Override 9 Indicator	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	Business Debt	Student's farm debt.	NUMBER(7)		RCRAPP3	RCRAPP3_FARM_DBT
BUSINESS_VALUE	Business Value	Student's farm value.	NUMBER(7)		RCRAPP3	RCRAPP3_FARM_VAL
CHILD_CARE_NUMBER	Child Care Number	Number of dependent children for whom the student will pay child care expenses.	NUMBER(2)		RCRAPP3	RCRAPP3_CHILD_CARE
CHILD_SUPPORT_PAID	Child Support Paid	Contains the amount paid for child support by a student.	NUMBER(5)		RCRAPP3	RCRAPP3_CHILD_SUPP_PAID
COLLEGE_CHOICE10	College Choice 10		VARCHAR2(6)
COLLEGE_CHOICE4	College Choice 4	Fourth college choice a student plans to attend.	VARCHAR2(6)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_4
COLLEGE_CHOICE5	College Choice 5	Fifth college choice a student plans to attend.	VARCHAR2(6)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_5
COLLEGE_CHOICE6	College Choice 6	Sixth college choice a student plans to attend.	VARCHAR2(6)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_6
COLLEGE_CHOICE7	College Choice 7		VARCHAR2(6)
COLLEGE_CHOICE8	College Choice 8		VARCHAR2(6)
COLLEGE_CHOICE9	College Choice 9		VARCHAR2(6)
COOPERATIVE_EARNINGS	Cooperative Earnings		NUMBER
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEGREE_TYPE	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	Degree type description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP3_DEGREE_TYPE)
DEPENDENCY_OVERRIDE	Dependency Override	Used by the financial aid administrator to override dependency.	VARCHAR2(1)		RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE
DEPENDENCY_OVERRIDE_DESC	Dependency Override Description	Dependency override description.	VARCHAR2(70)		CALCULATION	DECODE(RCRAPP3_FAA_DEP_OVERRIDE)
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
EDUCATION_TAX_CREDIT	Education Tax Credit		NUMBER
EFC_RECALC_SPECIAL_CIRCUM	Effective Family Contribution Recalc Special Circum		VARCHAR2(1)
EFC_RECALC_SPECIAL_CIRCUM_DESC	Effective Family Contribution Recalc Special Circum Description		VARCHAR2(4000)
FATHER_AGE	Father Age	Father's age.	VARCHAR2(2)		RCRAPP3	RCRAPP3_FATHER_AGE
FATHER_HIGHEST_GRADE	Father Highest Grade	Highest grade level completed by the father	VARCHAR2(1)		RCRAPP3	RCRAPP3_FATHER_HI_GRADE
FATHER_SIGNATURE_IND	Father Signature Indicator	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 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	Father Tax ID match description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP3_FATH_SSN_MATCH)
FEDERAL_SCHOOL_CODE	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	Graduate Professional Indicator	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)
GRANT_SCHOLARSHIP_AID	Grant Scholarship Financial Aid		NUMBER
HOUSING_FOOD_ALLOWANCE	Housing Food Allowance		NUMBER
IM_PARENT_TUITION_FEE_DEDUCT	Institution Method Parent Tuition Fee Deduct	Tuition and fees deduction from federal tax forms.	NUMBER(6)		RCRAPP3	RCRAPP3_PAR_TUI_FEE_DED
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)		RCRAPP3	RCRAPP3_INFC_CODE
INVESTMENT_DEBT	Investment Debt	Student's investment debt.	NUMBER(6)		RCRAPP3	RCRAPP3_INVEST_DBT
INVESTMENT_VALUE	Investment Value	Student's investment value.	NUMBER(6)		RCRAPP3	RCRAPP3_INVEST_VAL
IRS_REQUEST_STATUS	Irs Request Status		VARCHAR2(2)
IRS_REQUEST_STATUS_DESC	Irs Request Status Description		VARCHAR2(4000)
MARITAL_STATUS_DATE	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	Marital Status Indicator	Indicates whether or not a student is married.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_MARRIED)
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
MOTHER_AGE	Mother Age	Mother's age.	VARCHAR2(2)		RCRAPP3	RCRAPP3_MOTHER_AGE
MOTHER_HIGHEST_GRADE	Mother Highest Grade	Highest grade level completed by the mother	VARCHAR2(1)		RCRAPP3	RCRAPP3_MOTHER_HI_GRADE
MOTHER_SIGNATURE_IND	Mother Signature Indicator	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 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	Mother Tax ID match description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP3_MOTH_SSN_MATCH)
NEED_BASED_EMPLOYMENT	Need Based Employment		NUMBER
OFFICIAL_SOURCE_IND	Official Source Indicator	Official or unofficial indicator.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)
PARENT_BUSINESS_DEBT	Parent Business Debt	Parents' business debt.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_BUS_DBT
PARENT_BUSINESS_VALUE	Parent Business Value	Parents' business value.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_BUS_VAL
PARENT_CHILD_SUPPORT_PAID	Parent Child Support Paid	Amount paid for child support by the parents.	NUMBER(5)		RCRAPP3	RCRAPP3_PAR_CHILD_SUPP_PAID
PARENT_COOPERATIVE_EARNINGS	Parent Cooperative Earnings		NUMBER
PARENT_EARNED_INCOME_CREDIT	Parent Earned Income Credit	Parents' earned income credit.	NUMBER(5)		RCRAPP3	RCRAPP3_PAR_EIC
PARENT_EDUCATION_TAX_CREDIT	Parent Education Tax Credit		NUMBER
PARENT_FARM_DEBT	Parent Farm Debt	Parents' farm debt.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_FARM_DBT
PARENT_FARM_VALUE	Parent Farm Value	Parents' farm value.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_FARM_VAL
PARENT_FOREIGN_INC_EXCLUSION	Parent Foreign Inc Exclusion	Parents' foreign income exclusion.	NUMBER(6)		RCRAPP3	RCRAPP3_PAR_FOR_INC_EXCL
PARENT_GRANT_SCHOLARSHIP_AID	Parent Grant Scholarship Financial Aid		NUMBER
PARENT_HOUSING_FOOD_ALLOWANCE	Parent Housing Food Allowance	Housing, food,and other living allowances paid by the parents to the members of the military, clergy, and others.	NUMBER(5)		RCRAPP3	RCRAPP3_PAR_HOUSE_FOOD_OTH
PARENT_INVESTMENT_DEBT	Parent Investment Debt	Parents' investment debt.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_INVEST_DBT
PARENT_INVESTMENT_VALUE	Parent Investment Value	Parents' investment value.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_INVEST_VAL
PARENT_IRS_REQUEST_STATUS	Parent Irs Request Status		VARCHAR2(2)
PARENT_IRS_REQUEST_STATUS_DESC	Parent Irs Request Status Description		VARCHAR2(4000)
PARENT_MARITAL_STATUS_DATE	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	Parent Mortgage Rent Payment	Parents' monthly home mortgage or rental payment.	NUMBER(5)		RCRAPP3	RCRAPP3_PAR_MTH_MORT_RENT_PAY
PARENT_NEED_BASED_EMPLOYMENT	Parent Need Based Employment		NUMBER
PARENT_REAL_ESTATE_DEBT	Parent Real Estate Debt	Parents' real estate debt.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_RE_DBT
PARENT_REAL_ESTATE_VALUE	Parent Real Estate Value	Parents' real estate value.	NUMBER(7)		RCRAPP3	RCRAPP3_PAR_RE_VAL
PARENT_RESIDE_FARM_IND	Parent Reside Farm Indicator	Indicates whether or not the parents are living on a farm.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_PAR_LIVE_ON_FARM)
PARENT_RETIREMENT_PLAN_PAYMENT	Parent Retirement Plan Payment	Parents' deductible IRA and/or keough payments.	NUMBER(5)		RCRAPP3	RCRAPP3_PAR_IRA_KEOUGH
PARENT_TAX_DEFERRED_PENSION	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(5)		RCRAPP3	RCRAPP3_PAR_TAX_DEF_PENSION
PARENT_TAX_EXEMPT_INTEREST_INC	Parent Tax Exempt Interest Inc	Parents' tax exempt interest income.	NUMBER(5)		RCRAPP3	RCRAPP3_PAR_TE_INT_INC
PARENT_TOTAL_UNTAXED_INCOME	Parent Total Untaxed Income	Parents' untaxed income and benefits.	NUMBER(6)		RCRAPP3	RCRAPP3_PAR_INC_BENEFITS
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RCRAPP3	RCRAPP3_PIDM
PREPARER_EIN	Preparer Ein	Preparer's employee identification number.	VARCHAR2(9)		RCRAPP3	RCRAPP3_PREPARER_EIN
PREPARER_SIGNATURE_IND	Preparer Signature Indicator	Indicates whether or not the preparer's signature is on the application.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_PREPARER_SIGN)
PREPARER_TAX_ID	Preparer Tax ID	Preparer' social security number.	VARCHAR2(15)		RCRAPP3	RCRAPP3_PREPARER_SSN
REAL_ESTATE_DEBT	Real Estate Debt	Student's real estate debt.	NUMBER(6)		RCRAPP3	RCRAPP3_RE_DBT
REAL_ESTATE_VALUE	Real Estate Value	Student's real estate value.	NUMBER(6)		RCRAPP3	RCRAPP3_RE_VAL
REJECTION_OVERRIDE20_IND	Rejection Override 20 Indicator		VARCHAR2(1)
REJECTION_OVERRIDE21_IND	Rejection Override 21 Indicator		VARCHAR2(1)
REJECTION_OVERRIDE2_IND	Rejection Override 2 Indicator	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	Rejection Override 3 Indicator	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	Rejection Override 4 Indicator		VARCHAR2(1)
REJECTION_OVERRIDE5_IND	Rejection Override 5 Indicator	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	Rejection Override 7 Indicator	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	Rejection Override B Indicator	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	Rejection Override N Indicator	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	Rejection Override W Indicator	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	Reside Farm Indicator	Indicates whether or not a student is living on a farm.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_LIVE_ON_FARM)
SIGNATURE_IND	Signature Indicator	Indicates whether or not a student's signature ison the application.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_C_SIGNED)
SPECIAL_CIRCUMSTANCE	Special Circumstance		VARCHAR2(1)
SPECIAL_CIRCUMSTANCE_DESC	Special Circumstance Description		VARCHAR2(4000)
SPOUSE_SIGNATURE_IND	Spouse Signature Indicator	Indicates whether or not a spouse's signature is on the application.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP3_C_SIGNED_SPS)
TAX_DEFERRED_PENSION	Tax Deferred Pension		NUMBER
TAX_EXEMPT_INTEREST_INC	Tax Exempt Interest Inc		NUMBER
TAX_ID_MATCH_STATUS	Tax ID Match Status	Tax ID match status.	VARCHAR2(1)		RCRAPP3	RCRAPP3_SOC_SEC
TAX_ID_MATCH_STATUS_DESC	Tax ID Match Status Description	Tax ID match status description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP3_SOC_SEC)
USER_ID	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 In College 2	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	Year In College 2 Description	Description of the year of study.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP3_YR_IN_COLL_2)
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: