Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_FINAID_APPLICATION3

Description Contains information specific to the federal methodology for computing applicant need.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.

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 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 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(3)

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(7)

RCRAPP3

RCRAPP3_FARM_DBT

BUSINESS_VALUE Student's farm value. NUMBER(7)

RCRAPP3

RCRAPP3_FARM_VAL

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 Contains the amount paid for child support by a student. NUMBER(5)

RCRAPP3

RCRAPP3_CHILD_SUPP_PAID

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

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(40)

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

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(60)

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)

IM_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 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(6)

RCRAPP3

RCRAPP3_INVEST_DBT

INVESTMENT_VALUE Student's investment value. NUMBER(6)

RCRAPP3

RCRAPP3_INVEST_VAL

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(60)

CALCULATION

DECODE(RCRAPP3_MOTH_SSN_MATCH)

OFFICIAL_SOURCE_IND Official or unofficial indicator. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

PARENT_BUSINESS_DEBT Parents' business debt. NUMBER(7)

RCRAPP3

RCRAPP3_PAR_BUS_DBT

PARENT_BUSINESS_VALUE Parents' business value. NUMBER(7)

RCRAPP3

RCRAPP3_PAR_BUS_VAL

PARENT_CHILD_SUPPORT_PAID Amount paid for child support by the parents. NUMBER(5)

RCRAPP3

RCRAPP3_PAR_CHILD_SUPP_PAID

PARENT_EARNED_INCOME_CREDIT Parents' earned income credit. NUMBER(5)

RCRAPP3

RCRAPP3_PAR_EIC

PARENT_FARM_DEBT Parents' farm debt. NUMBER(7)

RCRAPP3

RCRAPP3_PAR_FARM_DBT

PARENT_FARM_VALUE Parents' farm value. NUMBER(7)

RCRAPP3

RCRAPP3_PAR_FARM_VAL

PARENT_FOREIGN_INC_EXCLUSION Parents' foreign income exclusion. NUMBER(6)

RCRAPP3

RCRAPP3_PAR_FOR_INC_EXCL

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 Parents' investment debt. NUMBER(7)

RCRAPP3

RCRAPP3_PAR_INVEST_DBT

PARENT_INVESTMENT_VALUE Parents' investment value. NUMBER(7)

RCRAPP3

RCRAPP3_PAR_INVEST_VAL

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(5)

RCRAPP3

RCRAPP3_PAR_MTH_MORT_RENT_PAY

PARENT_REAL_ESTATE_DEBT Parents' real estate debt. NUMBER(7)

RCRAPP3

RCRAPP3_PAR_RE_DBT

PARENT_REAL_ESTATE_VALUE Parents' real estate value. NUMBER(7)

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(5)

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(5)

RCRAPP3

RCRAPP3_PAR_TAX_DEF_PENSION

PARENT_TAX_EXEMPT_INTEREST_INC Parents' tax exempt interest income. NUMBER(5)

RCRAPP3

RCRAPP3_PAR_TE_INT_INC

PARENT_TOTAL_UNTAXED_INCOME Parents' untaxed income and benefits. NUMBER(6)

RCRAPP3

RCRAPP3_PAR_INC_BENEFITS

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

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(6)

RCRAPP3

RCRAPP3_RE_DBT

REAL_ESTATE_VALUE Student's real estate value. NUMBER(6)

RCRAPP3

RCRAPP3_RE_VAL

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. 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_OVERRIDE5_IND Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank. 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. 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)

SPOUSE_SIGNATURE_IND Indicates whether or not a spouse's signature is on the application. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_SPS)

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(60)

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(50)

CALCULATION

DECODE(RCRAPP3_YR_IN_COLL_2)

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 8.0