Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RCRAPP3
|
RCRAPP3_ACTIVITY_DATE
|
NO
|
NO
|
ADJUSTED_EFC_CALC_REQUEST
|
Contains a request to calculate the adjusted Effective Family Contribution.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_ADJ_EFC_CALC_REQ
|
NO
|
NO
|
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
|
NO
|
NO
|
APPLICATION_COMPLETE_MONTH_DAY
|
Contains the month and day the application was completed.
|
VARCHAR2(4)
|
RCRAPP3
|
RCRAPP3_C_SIGNED_MTH_DAY
|
NO
|
NO
|
APPLICATION_COMPLETE_YEAR
|
Contains the year the application was completed.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_C_SIGNED_YR
|
NO
|
NO
|
APPLICATION_NUMBER
|
Financial aid application unique sequence number.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_SEQ_NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
BUSINESS_DEBT
|
Student's farm debt.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_FARM_DBT
|
NO
|
NO
|
BUSINESS_VALUE
|
Student's farm value.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_FARM_VAL
|
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_PAID
|
Contains the amount paid for child support by a student.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_CHILD_SUPP_PAID
|
NO
|
NO
|
COLLEGE_CHOICE10
|
|
VARCHAR2(6)
|
|
|
|
NO
|
COLLEGE_CHOICE4
|
Fourth college choice a student plans to attend.
|
VARCHAR2(6)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_4
|
NO
|
NO
|
COLLEGE_CHOICE5
|
Fifth college choice a student plans to attend.
|
VARCHAR2(6)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_5
|
NO
|
NO
|
COLLEGE_CHOICE6
|
Sixth college choice a student plans to attend.
|
VARCHAR2(6)
|
RCRAPP3
|
RCRAPP3_FED_COLL_CHOICE_6
|
NO
|
NO
|
COLLEGE_CHOICE7
|
|
VARCHAR2(6)
|
|
|
|
NO
|
COLLEGE_CHOICE8
|
|
VARCHAR2(6)
|
|
|
|
NO
|
COLLEGE_CHOICE9
|
|
VARCHAR2(6)
|
|
|
|
NO
|
COOPERATIVE_EARNINGS
|
|
NUMBER
|
|
|
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DEGREE_TYPE
|
Contains the abbreviation of the degree or certificate a student is pursuing.
|
VARCHAR2(3)
|
RCRAPP3
|
RCRAPP3_DEGREE_TYPE
|
NO
|
NO
|
DEGREE_TYPE_DESC
|
Degree type description.
|
VARCHAR2(4000)
|
CALCULATION
|
DECODE(RCRAPP3_DEGREE_TYPE)
|
NO
|
NO
|
DEPENDENCY_OVERRIDE
|
Used by the financial aid administrator to override dependency.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_FAA_DEP_OVERRIDE
|
NO
|
NO
|
DEPENDENCY_OVERRIDE_DESC
|
Dependency override description.
|
VARCHAR2(70)
|
CALCULATION
|
DECODE(RCRAPP3_FAA_DEP_OVERRIDE)
|
NO
|
NO
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
EDUCATION_TAX_CREDIT
|
|
NUMBER
|
|
|
|
NO
|
EFC_RECALC_SPECIAL_CIRCUM
|
|
VARCHAR2(1)
|
|
|
|
NO
|
EFC_RECALC_SPECIAL_CIRCUM_DESC
|
|
VARCHAR2(4000)
|
|
|
|
NO
|
FATHER_AGE
|
Father's age.
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_FATHER_AGE
|
NO
|
NO
|
FATHER_HIGHEST_GRADE
|
Highest grade level completed by the father.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_FATHER_HI_GRADE
|
NO
|
NO
|
FATHER_SIGNATURE_IND
|
Indicates whether or not a father's signature is on the application.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_C_SIGNED_FATH)
|
NO
|
NO
|
FATHER_TAX_ID_MATCH
|
Father's/Stepfather's Tax ID Match Flag.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_FATH_SSN_MATCH
|
NO
|
NO
|
FATHER_TAX_ID_MATCH_DESC
|
Father Tax ID match description.
|
VARCHAR2(4000)
|
CALCULATION
|
DECODE(RCRAPP3_FATH_SSN_MATCH)
|
NO
|
NO
|
FEDERAL_SCHOOL_CODE
|
School Code that requested a dependency override or adjusted calculation request.
|
VARCHAR2(6)
|
RCRAPP3
|
RCRAPP3_FAA_TITLE_IV_CODE
|
NO
|
NO
|
GRADUATE_PROFESSIONAL_IND
|
Indicates whether or not a student is a graduate or professional student.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_GRAD_OR_PROF)
|
NO
|
NO
|
GRANT_SCHOLARSHIP_AID
|
|
NUMBER
|
|
|
|
NO
|
HOUSING_FOOD_ALLOWANCE
|
|
NUMBER
|
|
|
|
NO
|
IM_PARENT_TUITION_FEE_DEDUCT
|
Tuition and fees deduction from federal tax forms.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_TUI_FEE_DED
|
NO
|
NO
|
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
|
NO
|
NO
|
INVESTMENT_DEBT
|
Student's investment debt.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_INVEST_DBT
|
NO
|
NO
|
INVESTMENT_VALUE
|
Student's investment value.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_INVEST_VAL
|
NO
|
NO
|
IRS_AGI_FLAG
|
Indicates whether IRS Adjusted Gross Income data for the student was transferred to the FAFSA.
|
VARCHAR2(1)
|
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(4000)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
IRS_DISPLAY_FLAG
|
Indicates whether IRS Data Retrieval Transfer option was displayed for the student.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_IRS_DISPLAY_FLAG
|
NO
|
NO
|
IRS_DISPLAY_FLAG_DESC
|
IRS Data Retrieval Transfer option was displayed for the student indicator description.
|
VARCHAR2(4000)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
IRS_FIT_FLAG
|
Indicates whether IRS Federal Income Tax data for the student was transferred to the FAFSA
|
VARCHAR2(1)
|
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(4000)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
IRS_REQUEST_STATUS
|
|
VARCHAR2(2)
|
|
|
|
NO
|
IRS_REQUEST_STATUS_DESC
|
|
VARCHAR2(4000)
|
|
|
|
NO
|
MARITAL_STATUS_DATE
|
Month and year the student is married, widowed, separated, or divorced.
|
VARCHAR2(6)
|
RCRAPP3
|
RCRAPP3_S_MAR_MTH_YR
|
NO
|
NO
|
MARITAL_STATUS_IND
|
Indicates whether or not a student is married.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_MARRIED)
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
MOTHER_AGE
|
Mother's age.
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_MOTHER_AGE
|
NO
|
NO
|
MOTHER_HIGHEST_GRADE
|
Highest grade level completed by the mother.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_MOTHER_HI_GRADE
|
NO
|
NO
|
MOTHER_SIGNATURE_IND
|
Indicates whether or not a mother's signature is on the application.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_C_SIGNED_MOTH)
|
NO
|
NO
|
MOTHER_TAX_ID_MATCH
|
Mother's/Stepmother's Tax ID Match Flag.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_MOTH_SSN_MATCH
|
NO
|
NO
|
MOTHER_TAX_ID_MATCH_DESC
|
Mother Tax ID match description.
|
VARCHAR2(4000)
|
CALCULATION
|
DECODE(RCRAPP3_MOTH_SSN_MATCH)
|
NO
|
NO
|
NEED_BASED_EMPLOYMENT
|
|
NUMBER
|
|
|
|
NO
|
OFFICIAL_SOURCE_IND
|
Official or unofficial indicator.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_OFFL_UNOFFL_IND)
|
NO
|
NO
|
PARENT_BUSINESS_DEBT
|
Parents' business debt.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_BUS_DBT
|
NO
|
NO
|
PARENT_BUSINESS_VALUE
|
Parents' business value.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_BUS_VAL
|
NO
|
NO
|
PARENT_CHILD_SUPPORT_PAID
|
Amount paid for child support by the parents.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_CHILD_SUPP_PAID
|
NO
|
NO
|
PARENT_COOPERATIVE_EARNINGS
|
|
NUMBER
|
|
|
|
NO
|
PARENT_EARNED_INCOME_CREDIT
|
Parents' earned income credit.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_EIC
|
NO
|
NO
|
PARENT_EDUCATION_TAX_CREDIT
|
|
NUMBER
|
|
|
|
NO
|
PARENT_FARM_DEBT
|
Parents' farm debt.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_FARM_DBT
|
NO
|
NO
|
PARENT_FARM_VALUE
|
Parents' farm value.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_FARM_VAL
|
NO
|
NO
|
PARENT_FOREIGN_INC_EXCLUSION
|
Parents' foreign income exclusion.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_FOR_INC_EXCL
|
NO
|
NO
|
PARENT_GRANT_SCHOLARSHIP_AID
|
|
NUMBER
|
|
|
|
NO
|
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
|
NO
|
NO
|
PARENT_INVESTMENT_DEBT
|
Parents' investment debt.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_INVEST_DBT
|
NO
|
NO
|
PARENT_INVESTMENT_VALUE
|
Parents' investment value.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_INVEST_VAL
|
NO
|
NO
|
PARENT_IRS_AGI_FLAG
|
Indicates whether IRS Adjusted Gross Income data for the parent was transferred to the FAFSA.
|
VARCHAR2(1)
|
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(4000)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
PARENT_IRS_DISPLAY_FLAG
|
Indicates whether IRS Data Retrieval Transfer option was displayed for the parent.
|
VARCHAR2(1)
|
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(4000)
|
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(1)
|
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(4000)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
PARENT_IRS_REQUEST_STATUS
|
|
VARCHAR2(2)
|
|
|
|
NO
|
PARENT_IRS_REQUEST_STATUS_DESC
|
|
VARCHAR2(4000)
|
|
|
|
NO
|
PARENT_MARITAL_STATUS_DATE
|
Month and year the parents were married, widowed, separated, or divorced.
|
VARCHAR2(6)
|
RCRAPP3
|
RCRAPP3_PAR_MAR_MTH_YR
|
NO
|
NO
|
PARENT_MORTGAGE_RENT_PAYMENT
|
Parents' monthly home mortgage or rental payment.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_MTH_MORT_RENT_PAY
|
NO
|
NO
|
PARENT_NEED_BASED_EMPLOYMENT
|
|
NUMBER
|
|
|
|
NO
|
PARENT_REAL_ESTATE_DEBT
|
Parents' real estate debt.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_RE_DBT
|
NO
|
NO
|
PARENT_REAL_ESTATE_VALUE
|
Parents' real estate value.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_RE_VAL
|
NO
|
NO
|
PARENT_RESIDE_FARM_IND
|
Indicates whether or not the parents are living on a farm.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_PAR_LIVE_ON_FARM)
|
NO
|
NO
|
PARENT_RETIREMENT_PLAN_PAYMENT
|
Parents' deductible IRA and/or keough payments.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_IRA_KEOUGH
|
NO
|
NO
|
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
|
NO
|
NO
|
PARENT_TAX_EXEMPT_INTEREST_INC
|
Parents' tax exempt interest income.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_TE_INT_INC
|
NO
|
NO
|
PARENT_TOTAL_UNTAXED_INCOME
|
Parents' untaxed income and benefits.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PAR_INC_BENEFITS
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_PIDM
|
NO
|
NO
|
PREPARER_EIN
|
Preparer's employee identification number.
|
VARCHAR2(9)
|
RCRAPP3
|
RCRAPP3_PREPARER_EIN
|
NO
|
NO
|
PREPARER_SIGNATURE_IND
|
Indicates whether or not the preparer's signature is on the application.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_PREPARER_SIGN)
|
NO
|
NO
|
PREPARER_TAX_ID
|
Preparer' social security number.
|
VARCHAR2(15)
|
RCRAPP3
|
RCRAPP3_PREPARER_SSN
|
NO
|
NO
|
REAL_ESTATE_DEBT
|
Student's real estate debt.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_RE_DBT
|
NO
|
NO
|
REAL_ESTATE_VALUE
|
Student's real estate value.
|
NUMBER
|
RCRAPP3
|
RCRAPP3_RE_VAL
|
NO
|
NO
|
REJECTION_OVERRIDE20_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
REJECTION_OVERRIDE21_IND
|
|
VARCHAR2(1)
|
|
|
|
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(1)
|
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(1)
|
RCRAPP3
|
RCRAPP3_REJECT_OVRD_3
|
NO
|
NO
|
REJECTION_OVERRIDE4_IND
|
|
VARCHAR2(1)
|
|
|
|
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(1)
|
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(1)
|
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(1)
|
RCRAPP3
|
RCRAPP3_REJECT_OVRD_1
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
REJECT_REASON_PRIORITY_1
|
Reject Reason Priority 1
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_1
|
NO
|
NO
|
REJECT_REASON_PRIORITY_10
|
Reject Reason Priority 10
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_10
|
NO
|
NO
|
REJECT_REASON_PRIORITY_11
|
Reject Reason Priority 11
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_11
|
NO
|
NO
|
REJECT_REASON_PRIORITY_12
|
Reject Reason Priority 12
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_12
|
NO
|
NO
|
REJECT_REASON_PRIORITY_13
|
Reject Reason Priority 13
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_13
|
NO
|
NO
|
REJECT_REASON_PRIORITY_14
|
Reject Reason Priority 14
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_14
|
NO
|
NO
|
REJECT_REASON_PRIORITY_2
|
Reject Reason Priority 2
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_2
|
NO
|
NO
|
REJECT_REASON_PRIORITY_3
|
Reject Reason Priority 3
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_3
|
NO
|
NO
|
REJECT_REASON_PRIORITY_4
|
Reject Reason Priority 4
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_4
|
NO
|
NO
|
REJECT_REASON_PRIORITY_5
|
Reject Reason Priority 5
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_5
|
NO
|
NO
|
REJECT_REASON_PRIORITY_6
|
Reject Reason Priority 6
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_6
|
NO
|
NO
|
REJECT_REASON_PRIORITY_7
|
Reject Reason Priority 7
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_7
|
NO
|
NO
|
REJECT_REASON_PRIORITY_8
|
Reject Reason Priority 8
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_8
|
NO
|
NO
|
REJECT_REASON_PRIORITY_9
|
Reject Reason Priority 9
|
VARCHAR2(2)
|
RCRAPP3
|
RCRAPP3_REJ_REASON_PRTY_9
|
NO
|
NO
|
RESIDE_FARM_IND
|
Indicates whether or not a student is living on a farm.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_LIVE_ON_FARM)
|
NO
|
NO
|
SIGNATURE_IND
|
Indicates whether or not a student's signature ison the application.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_C_SIGNED)
|
NO
|
NO
|
SPECIAL_CIRCUMSTANCE
|
|
VARCHAR2(1)
|
|
|
|
NO
|
SPECIAL_CIRCUMSTANCE_DESC
|
|
VARCHAR2(4000)
|
|
|
|
NO
|
SPOUSE_SIGNATURE_IND
|
Indicates whether or not a spouse's signature is on the application.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRAPP3_C_SIGNED_SPS)
|
NO
|
NO
|
TAX_DEFERRED_PENSION
|
|
NUMBER
|
|
|
|
NO
|
TAX_EXEMPT_INTEREST_INC
|
|
NUMBER
|
|
|
|
NO
|
TAX_ID_MATCH_STATUS
|
Tax ID match status.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_SOC_SEC
|
NO
|
NO
|
TAX_ID_MATCH_STATUS_DESC
|
Tax ID match status description.
|
VARCHAR2(4000)
|
CALCULATION
|
DECODE(RCRAPP3_SOC_SEC)
|
NO
|
NO
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
RCRAPP3
|
RCRAPP3_USER_ID
|
NO
|
NO
|
YEAR_IN_COLLEGE2
|
Year of study (first, second, etc.) that the student enrolls in this year.
|
VARCHAR2(1)
|
RCRAPP3
|
RCRAPP3_YR_IN_COLL_2
|
NO
|
NO
|
YEAR_IN_COLLEGE2_DESC
|
Description of the year of study.
|
VARCHAR2(4000)
|
CALCULATION
|
DECODE(RCRAPP3_YR_IN_COLL_2)
|
NO
|
NO
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|