Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Financial Aid Reporting View Reports

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_EFC_CALC_REQUEST Contains a request to calculate the adjusted Effective Family Contribution. VARCHAR2(63)

RCRAPP3

RCRAPP3_ADJ_EFC_CALC_REQ

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

NA

NA

ADOPTED_AFTER_13 Indicates whether student was adopted after age 13. VARCHAR2(63)

RCRAPP4

RCRAPP4_ADOPTED_AFTER_13

ADOPTED_AFTER_13_DESC Adopted after 13 indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. 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

ASSET_THRESHOLD_EXCEED Student asset threshold exceeded. NUMBER

RCRAPP4

RCRAPP4_S_ASSET_THRESH_EXCD

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

RCRAPP1

RCRAPP1_BUS_FARM_DBT

BUSINESS_NET_WORTH Student's business net worth. NUMBER

RCRAPP4

RCRAPP4_BUS_NET_WORTH

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

CHILD_SUPPORT_INCOME Student's base year income from child support received for all children. NUMBER

RCRAPP1

RCRAPP1_CHILD_SUPP

CHILD_SUPPORT_PAID Amount paid for child support by a student. NUMBER

RCRAPP3

RCRAPP3_CHILD_SUPP_PAID

COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

RCRAPP1

RCRAPP1_COLL_CDE

COLLEGE_CHOICE1 Student's first choice of college planning to attend. VARCHAR2(63)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_1

COLLEGE_CHOICE10 Student's tenth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_10

COLLEGE_CHOICE2 Student's second choice of college planning to attend. VARCHAR2(63)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_2

COLLEGE_CHOICE3 Student's third choice of college planning to attend. VARCHAR2(63)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_3

COLLEGE_CHOICE4 Student's fourth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_4

COLLEGE_CHOICE5 Student's fifth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_5

COLLEGE_CHOICE6 Student's sixth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_6

COLLEGE_CHOICE7 Student's seventh choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_7

COLLEGE_CHOICE8 Student's eighth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_8

COLLEGE_CHOICE9 Student's ninth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_9

COMBAT_PAY Student combat Pay NUMBER

RCRAPP4

RCRAPP4_COMBAT_PAY

COOPERATIVE_EARNINGS Student's earnings from work under a cooperative education program offered by a college NUMBER

RCRAPP3

RCRAPP3_CO_OP_EARNINGS

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)

RORMVAL

RORMVAL_DESC

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)

RORMVAL

RORMVAL_DESC

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

EDUCATION_TAX_CREDIT Amount of educational tax credits that the student has received. NUMBER

RCRAPP3

RCRAPP3_EDUC_CREDITS

EFC_RECALC_SPECIAL_CIRCUM Indicates a request to the CPS to recalculate the Effective Family Contribution. VARCHAR2(63)

RCRAPP3

RCRAPP3_EFC_RECALC_CORR_REQ

EFC_RECALC_SPECIAL_CIRCUM_DESC Request to the CPS to recalculate the Effective Family Contribution indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_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. No longer populated after aid year ending in 2014. VARCHAR2(63)

RCRAPP1

RCRAPP1_EXP_ENROLL_STATUS

EXPECTED_ENROLL_STATUS_DESC Description of the student's expected enrollment status. No longer populated after aid year ending in 2014. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRAPP3

RCRAPP3_FATHER_HI_GRADE

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

RCRAPP1

RCRAPP1_FATH_INC_FR_WRK

FEDERAL_SCHOOL_CODE School Code that requested a dependency override or adjusted calculation request. VARCHAR2(63)

RCRAPP3

RCRAPP3_FAA_TITLE_IV_CODE

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)

RORMVAL

RORMVAL_DESC

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)

GRANT_SCHOLARSHIP_AID Amount of student's grant and scholarship aid. NUMBER

RCRAPP3

RCRAPP3_GRANT_SCHOLAR_AID

HOMELESS Indicates whether student is homeless. VARCHAR2(63)

RCRAPP4

RCRAPP4_HOMELESS

HOMELESS_DESC Homeless indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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)

RORMVAL

RORMVAL_DESC

HOUSING_FOOD_ALLOWANCE Housing, food, and other living allowances paid to a student who are members of the military, clergy or others. NUMBER

RCRAPP3

RCRAPP3_HOUSE_FOOD_OTH

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. 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)

RORMVAL

RORMVAL_DESC

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

INVESTMENT_NET_WORTH Student's investment net worth. NUMBER

RCRAPP4

RCRAPP4_INV_NET_WORTH

IRS_REQUEST_STATUS Status of the data request sent to the IRS for the parent. VARCHAR2(63)

RCRAPP3

RCRAPP3_IRS_REQUEST_FLAG

IRS_REQUEST_STATUS_DESC IRS request status description. VARCHAR2(255)

RORMVAL

RORMVAL_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 father/mother/stepparent. VARCHAR2(63)

RCRAPP3

RCRAPP3_MOTHER_HI_GRADE

MOTHER_WORK_INCOME Amount of income earned from work by the student's father/mother/stepparent in the base year. 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

NEED_BASED_EMPLOYMENT Amount of student's need based earnings. NUMBER

RCRAPP3

RCRAPP3_NEED_BASED_EMPLOY

OFFICIAL_SOURCE_IND Official or unofficial indicator. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

OTHER_NON_REPORTED_MONEY Amount of student's other non-reported money. NUMBER

RCRAPP1

RCRAPP1_OTH_NON_REPORT_MONEY

OTHER_UNTAXED_INCOME Student's reported base year other untaxed income and benefits. NUMBER

RCRAPP1

RCRAPP1_OTH_UNTAXED_INC

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_ASSET_THRESHOLD_EXCEED Parent asset threshold exceeded. NUMBER

RCRAPP4

RCRAPP4_P_ASSET_THRESH_EXCD

PARENT_BUSINESS_NET_WORTH Parent's business net worth. NUMBER

RCRAPP4

RCRAPP4_PAR_BUS_NET_WORTH

PARENT_CASH_ASSET Value of cash, savings and checking accounts reported by the student's parents. NUMBER

RCRAPP1

RCRAPP1_PAR_CASH_AMT

PARENT_CHILD_SUPPORT_INCOME Amount of income received by the student's parents from child support for all children in the base year. NUMBER

RCRAPP1

RCRAPP1_PAR_CHILD_SUPP

PARENT_CHILD_SUPPORT_PAID Amount paid for child support by the parents. NUMBER

RCRAPP3

RCRAPP3_PAR_CHILD_SUPP_PAID

PARENT_COMBAT_PAY Parent combat Pay NUMBER

RCRAPP4

RCRAPP4_PAR_COMBAT_PAY

PARENT_COOPERATIVE_EARNINGS Parents' earnings from work under a cooperative education program offered by a college. NUMBER

RCRAPP3

RCRAPP3_PAR_CO_OP_EARNINGS

PARENT_EDUCATION_TAX_CREDIT Amount of educational tax credits that the parent has received. NUMBER

RCRAPP3

RCRAPP3_PAR_EDUC_CREDITS

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_GRANT_SCHOLARSHIP_AID Amount of parent's grant and scholarship aid. NUMBER

RCRAPP3

RCRAPP3_PAR_GRANT_SCHOLAR_AID

PARENT_HOME_DEBT Current outstanding debts against the home for the student's parents. NUMBER

RCRAPP1

RCRAPP1_PAR_HME_DBT

PARENT_HOME_VALUE Current market value of the student's parents home. NUMBER

RCRAPP1

RCRAPP1_PAR_HME_VAL

PARENT_HOUSING_FOOD_ALLOWANCE Housing, food, and other living allowances paid to the parents who are members of the military, clergy, or others. NUMBER

RCRAPP3

RCRAPP3_PAR_HOUSE_FOOD_OTH

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_INVESTMENT_NET_WORTH Parent's investment net worth. NUMBER

RCRAPP4

RCRAPP4_PAR_INV_NET_WORTH

PARENT_IRS_REQUEST_STATUS Status of the data request sent to the IRS for the student. VARCHAR2(63)

RCRAPP3

RCRAPP3_PAR_IRS_REQUEST_FLAG

PARENT_IRS_REQUEST_STATUS_DESC IRS request status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_NEED_BASED_EMPLOYMENT Amount of parent's need based earnings. NUMBER

RCRAPP3

RCRAPP3_PAR_NEED_BASED_EMPLOY

PARENT_NUMBER_OF_BUSINESSES Parent number of businesses. NUMBER

RCRAPP4

RCRAPP4_PAR_NUM_BUSINESSES

PARENT_NUMBER_OF_FARMS Parent number of farms. NUMBER

RCRAPP4

RCRAPP4_PAR_NUM_FARMS

PARENT_OTHER_UNTAXED_INCOME Other untaxed income received in the base year by the student's parents. NUMBER

RCRAPP1

RCRAPP1_PAR_OTH_UNTAXED_INC

PARENT_RETIREMENT_PLAN_DISTRIB Parent's untaxed IRA distributions. NUMBER

RCRAPP1

RCRAPP1_PAR_IRA_DISTRIBUTIONS

PARENT_RETIREMENT_PLAN_PAYMENT Parents' deductible IRA and/or Keogh payments. NUMBER

RCRAPP3

RCRAPP3_PAR_IRA_KEOUGH

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_DEFERRED_PENSION Parent's 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_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)

RORMVAL

RORMVAL_DESC

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)

RORMVAL

RORMVAL_DESC

PARENT_UNTAXED_PENSIONS Parent's untaxed pensions. NUMBER

RCRAPP1

RCRAPP1_PAR_UNTAX_PENSIONS

PARENT_VETERAN_NON_ED_BENEFIT Parent's veterans non-education benefits. NUMBER

RCRAPP1

RCRAPP1_PAR_VETS_NON_ED_BEN

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_OVERRIDE20_IND Set by electronic application user to override reject 20: Non-tax filer reported income is above the IRS filing requirement. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_20

REJECTION_OVERRIDE21_IND Set by electronic application user to override reject 21: Student's corrected marital status date is greater than application receipt date and less than transaction receipt date. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_21

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(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_OVERRIDE4_IND Set by electronic application user to override reject 4: Student's marital status date greater than date application was signed. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_4

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(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. No longer used. 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

RCRAPP3_REJECT_OVRD_1

RCRAPP3_REJECT_OVRD_B

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

RCRAPP3

RCRAPP3_REJECT_OVRD_N

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_W

RETIREMENT_PLAN_DISTRIBUTION Amount of student's untaxed IRA distributions. NUMBER

RCRAPP1

RCRAPP1_IRA_DISTRIBUTIONS

RETIREMENT_PLAN_PAYMENT Parents' deductible IRA and/or Keogh payments. NUMBER

RCRAPP4

RCRAPP4_IRA_KEOUGH_AMT

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_DEFERRED_PENSION Student's 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_TAX_DEF_PENSION

TAX_EXEMPT_INTEREST_INC Students' tax exempt interest income. NUMBER

RCRAPP3

RCRAPP3_TE_INT_INC

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)

RORMVAL

RORMVAL_DESC

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)

RORMVAL

RORMVAL_DESC

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)

RORMVAL

RORMVAL_DESC

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

UNTAXED_PENSIONS Amount of student's untaxed pensions. NUMBER

RCRAPP1

RCRAPP1_UNTAX_PENSIONS

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

VETERAN_BENEFITS_TYPE Type of veteran's benefits that the student is receiving. VARCHAR2(63)

RCRAPP1

RCRAPP1_TYPE_VET_BENEFITS

VETERAN_BENEFITS_TYPE_DESC Veteran benefits type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

VETERAN_MONTHLY_OTHER_BENEFITS Amount per month from other Veteran Educational Benefit programs. NUMBER

RCRAPP1

RCRAPP1_OTH_VA_AMT

VETERAN_NON_EDUCATION_BENEFIT Amount of student's veterans non-education benefits. NUMBER

RCRAPP1

RCRAPP1_VETS_NON_ED_BEN

VETERAN_OTHER_BENEFITS_MONTHS Number of months that the other VA benefits will be received during the award year. NUMBER

RCRAPP1

RCRAPP1_OTH_VA_MTH

VETERAN_RECEIVING_BENEFITS Indicates whether the student is receiving veteran's benefits. VARCHAR2(63)

RCRAPP1

RCRAPP1_RECV_VET_BENEFITS

VETERAN_RECEIVING_BENEFIT_DESC Veteran receiving benefits indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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)

RORMVAL

RORMVAL_DESC



Ver: 9.1