Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: NEED_ANALYSIS

Description Contains data usually loaded from a federally supplied electronic media. Detail data will include all data collected regarding student need for the aid year and student. Data may include parental contribution, student contribution, interface tape code, application number, state/province of residence, and other need based data for doing need analysis either using a federal or institution method of calculation.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.
Recommended Search Columns AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND PERSON_UID

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_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 Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_YEAR Aid year associated with this record. 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

BUSINESS_DEBT Amount of the student's outstanding debts against business and farm assets. NUMBER

RCRAPP1

RCRAPP1_BUS_FARM_DBT

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

COLLEGE College code identifying the school to which this financial aid applicant record has applied. VARCHAR2(63)

RCRAPP1

RCRAPP1_COLL_CDE

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)

CALCULATION

DECODE(RCRAPP3_DEGREE_TYPE)

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)

CALCULATION

DECODE(RCRAPP2_MODEL_CDE)

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

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. VARCHAR2(63)

RCRAPP1

RCRAPP1_EXP_ENROLL_STATUS

EXPECTED_ENROLL_STATUS_DESC Description of the student's expected enrollment status. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP1_EXP_ENROLL_STATUS)

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

RCRAPP3

RCRAPP3_FATHER_HI_GRADE

FATHER_WORK_INCOME Amount of income earned from work by the student's father in the base year. NUMBER

RCRAPP1

RCRAPP1_FATH_INC_FR_WRK

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)

CALCULATION

DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)

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)

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)

CALCULATION

DECODE(RCRAPP1_INST_HOUS_CDE)

ID Person's or organization's current identification number. 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)

CALCULATION

DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)

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

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 mother VARCHAR2(63)

RCRAPP3

RCRAPP3_MOTHER_HI_GRADE

MOTHER_WORK_INCOME Mother's reported base year income from work. 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

OFFICIAL_SOURCE_IND Official or unofficial indicator. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

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_CHILD_SUPPORT_PAID Amount paid for child support by the parents. NUMBER

RCRAPP3

RCRAPP3_PAR_CHILD_SUPP_PAID

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

CALCULATION

DECODE(RCRAPP4_PAR_TAX_RET_FILED_IND)

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)

CALCULATION

DECODE(RCRAPP1_PAR_TAX_FORM_IND)

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

REJECTION_OVERRIDE_N_IND Set by electronic application user to override reject N: Missing first or last name. VARCHAR2(63)

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

RCRAPP3

RCRAPP3_REJECT_OVRD_6

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

CALCULATION

DECODE(RCRAPP3_SOC_SEC)

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)

CALCULATION

DECODE(RCRAPP4_TX_RET_FILED_IND)

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)

CALCULATION

DECODE(RCRAPP1_TAX_FORM_IND)

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

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

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)

CALCULATION

DECODE(RCRAPP1_YR_IN_COLL)



Ver: 8.0