Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
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 Name Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE

RCRAPP1

RCRAPP1_ACTIVITY_DATE

ADDITIONAL_COLLEGE_NAME1 Additional College Name 1 The first school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_1

ADDITIONAL_COLLEGE_NAME2 Additional College Name 2 The second school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_2

ADDITIONAL_COLLEGE_NAME3 Additional College Name 3 The third school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_3

ADDITIONAL_COLLEGE_NAME4 Additional College Name 4 The fourth school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_4

ADDITIONAL_COLLEGE_NAME5 Additional College Name 5 The fifth school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_5

ADDITIONAL_COLLEGE_NAME6 Additional College Name 6 The sixth school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_6

ADDITIONAL_COLLEGE_NAME7 Additional College Name 7 The seventh school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_7

ADDITIONAL_COLLEGE_NAME8 Additional College Name 8 The eighth school name if more than eight school codes were requested through an original application or an additional college request. VARCHAR2(256)

RCRAPP1

RCRAPP1_ADDL_COLL_NAME_8

ADJUSTED_EFC_CALC_REQUEST Adjusted Effective Family Contribution Calculated Request Contains a request to calculate the adjusted Effective Family Contribution. VARCHAR2(63)

RCRAPP3

RCRAPP3_ADJ_EFC_CALC_REQ

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

NA

NA

ADOPTED_AFTER_13 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 Description Adopted after 13 indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

AID_YEAR Financial 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 Description Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

APPLICATION_NUMBER Application Number Financial aid application unique sequence number. NUMBER

RCRAPP1

RCRAPP1_SEQ_NO

ASSET_THRESHOLD_EXCEED Asset Threshold Exceed Student asset threshold exceeded. NUMBER

RCRAPP4

RCRAPP4_S_ASSET_THRESH_EXCD

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

RCRAPP1

RCRAPP1_BUS_FARM_DBT

BUSINESS_NET_WORTH Business Net Worth Student's business net worth. NUMBER

RCRAPP4

RCRAPP4_BUS_NET_WORTH

BUSINESS_VALUE Business Value Current market value of the student's business and farm assets. NUMBER

RCRAPP1

RCRAPP1_BUS_FARM_VAL

CASH_SAVINGS 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 Child Care Number Number of dependent children for whom the student will pay child care expenses. NUMBER

RCRAPP3

RCRAPP3_CHILD_CARE

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

RCRAPP1

RCRAPP1_CHILD_SUPP

CHILD_SUPPORT_PAID Child Support Paid Amount paid for child support by a student. NUMBER

RCRAPP3

RCRAPP3_CHILD_SUPP_PAID

COLLEGE 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 College Choice 1 Student's first choice of college planning to attend. VARCHAR2(63)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_1

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_10

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

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_2

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

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_3

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_4

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_5

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_6

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_7

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_8

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_9

COLLEGE_NAME1 College Name 1 The first college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_1

COLLEGE_NAME2 College Name 2 The second college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_2

COLLEGE_NAME3 College Name 3 The third college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_3

COLLEGE_NAME4 College Name 4 The fourth college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_4

COLLEGE_NAME5 College Name 5 The fifth college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_5

COLLEGE_NAME6 College Name 6 The sixth college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_6

COLLEGE_NAME7 College Name 7 The seventh college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_7

COLLEGE_NAME8 College Name 8 The eighth college/program name listed by the student on the aid application for receipt of information. VARCHAR2(256)

RCRAPP1

RCRAPP1_COLL_NAME_8

COMBAT_PAY Combat Pay Student combat Pay NUMBER

RCRAPP4

RCRAPP4_COMBAT_PAY

COOPERATIVE_EARNINGS 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 Current Record Indicator Specifies that this is the current need analysis record. VARCHAR2(63)

RCRAPP1

RCRAPP1_CURR_REC_IND

DEGREE_TYPE 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 Degree type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

DEPENDENCY_INDEPEND Dependency Independ Code that indicates if the student is independent or dependent. VARCHAR2(63)

RCRAPP2

RCRAPP2_MODEL_CDE

DEPENDENCY_INDEPEND_DESC Dependency Independ Description Depend independ code description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

DEPENDENCY_OVERRIDE Dependency Override Used by the financial aid administrator to override dependency. VARCHAR2(63)

RCRAPP3

RCRAPP3_FAA_DEP_OVERRIDE

DEPENDENCY_OVERRIDE_DESC Dependency Override Description Dependency override description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP3_FAA_DEP_OVERRIDE)

DEPENDENCY_STATUS 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 Dependency Status Description Students dependency status description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_C_DEPEND_STATUS)

DRIVER_LICENSE_NUMBER Driver License Number Student's drivers license number. VARCHAR2(63)

RCRAPP1

RCRAPP1_DRIVER_LIC_NO

DRIVER_LICENSE_STATE_PROVINCE 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 Driver License State Province Description Description of the state or province in which the student holds a drivers license. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

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

RCRAPP3

RCRAPP3_EDUC_CREDITS

EFC_RECALC_SPECIAL_CIRCUM Effective Family Contribution 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 Effective Family Contribution Recalc Special Circum Description Request to the CPS to recalculate the Effective Family Contribution indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

EMAIL_ADDRESS Email Address Student's e-mail address as reported on PROFILE. VARCHAR2(255)

RCRAPP4

RCRAPP4_EMAIL_ADDRESS

ENROLLMENT_PLANNING_SERVICE 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 Serv Description Enrollment planning service description. VARCHAR2(255)

STVEPSC

STVEPSC_DESC

EXPECTED_ENROLL_STATUS Expected Enrollment 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 Expected Enrollment Status Description 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 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 Family Size Number of people in the student's household during the school year. NUMBER

CALCULATION

DECODE(RCRAPP2_MODEL_CDE)

FATHER_HIGHEST_GRADE Parent 1 Highest Grade Highest grade level completed by the father/mother/stepparent. VARCHAR2(63)

RCRAPP3

RCRAPP3_FATHER_HI_GRADE

FATHER_WORK_INCOME Parent 1 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 Federal School Code School Code that requested a dependency override or adjusted calculation request. VARCHAR2(63)

RCRAPP3

RCRAPP3_FAA_TITLE_IV_CODE

FISAP_TOTAL_INCOME Fisap Total Income Indicates the person's total FISAP income. NUMBER

RCRAPP4

RCRAPP4_FISAP_INC

FM_CONTRIBUTION_ASSET Federal Method Contribution Asset Student's contribution from assets for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FR_ASSET

FM_CONTRIBUTION_INCOME Federal Method Contribution Income Student's contribution from income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FR_INC

FM_CONTRIBUTION_OFFICIAL Federal Method 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 Federal Method Contribution Official Description Contribution official description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

FM_INAS Federal Method INAS Student contribution for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FOR_STDT

FM_PARENT_CONTRIBUTION_ASSET Federal Method 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 Federal Method 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 Federal Method Parent INAS Primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FOR_STDT

FM_PARENT_TOTAL_INCOME Federal Method 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 Federal Method Parent Worksheet A Total Parents' Worksheet A untaxed income total. NUMBER

RCRAPP4

RCRAPP4_PAR_WORKSHEET_A

FM_TOTAL_FAMILY_CONTRIBUTION Federal Method Total Family Contribution Primary federal methodology total family contribution. NUMBER

RCRAPP4

RCRAPP4_C_INST_1_TOT_FAM_CTRB

FM_TOTAL_INCOME Federal Method Total Income Total income used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_TOT_INC

FM_WORKSHEET_A_TOTAL Federal Method Worksheet A Total Student's Worksheet A untaxed income total. NUMBER

RCRAPP4

RCRAPP4_WORKSHEET_A

GRADUATE_PROFESSIONAL_IND Graduate Professional Indicator Indicates whether or not a student is a graduate or professional student. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_GRAD_OR_PROF)

GRANT_SCHOLARSHIP_AID Grant Scholarship Financial Aid Amount of student's grant and scholarship aid. NUMBER

RCRAPP3

RCRAPP3_GRANT_SCHOLAR_AID

HOMELESS Homeless Indicates whether student is homeless. VARCHAR2(63)

RCRAPP4

RCRAPP4_HOMELESS

HOMELESS_DESC Homeless Description Homeless indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

HOME_DEBT Home Debt Student's current outstanding debts against the home. NUMBER

RCRAPP1

RCRAPP1_HME_DBT

HOME_VALUE Home Value Current market value of the student's home. NUMBER

RCRAPP1

RCRAPP1_HME_VAL

HOUSING 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 Housing Description Institutional housing code description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

HOUSING_FOOD_ALLOWANCE 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 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 Institution Method Contribution Institutional methodology calculated value for the student contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_SC

IM_CONTRIBUTION_ASSET Institution Method Contribution Asset Student's contribution from assets for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_ASSET

IM_CONTRIBUTION_INCOME Institution Method Contribution Income Student's contribution from income for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_INC

IM_PARENT_CONTRIBUTION Institution Method Parent Contribution Institutional methodology calculated value for the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_PC

IM_PARENT_CONTRIBUTION_ASSET Institution Method 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 Institution Method 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 Institution Method Parent Contribution 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 Institution Method Parent Contribution Off Description Description of the primary parent contribution. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

IM_PARENT_COUNTRY_COEFFICIENT Calculated Parents Country Coefficient The calculated country coefficient for the parents used by the IM need analysis process. NUMBER

RCRAPP2

RCRAPP2_C_PAR_CNTRY_COEFF

IM_PARENT_TOTAL_INCOME Institution Method 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 Institution Method Total Family Contribution Primary institutional methodology for calculation of total family contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_TFC

IM_TOTAL_INCOME Institution Method Total Income Total income used in the student's primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_INC

INAS_TFC INAS Total Family Contribution Total family contribution. NUMBER

CALCULATION

NVL(RCRAPP2_C_1_CTRB_FOR_STDT,0)+NVL(RCRAPP2_C_PAR_1_CTRB_FOR_STDT,0)

INCOME_TAX_PAID 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 Income Work Amount of the student's base year income from working. NUMBER

RCRAPP1

RCRAPP1_INC_FR_WRK

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

RCRAPP1

RCRAPP1_INFC_CODE

INTERFACE_TAPE_DESC Interface Tape Description Description of the interface tape code. VARCHAR2(255)

RTVINFC

RTVINFC_DESC

INVESTMENT_NET_WORTH Investment Net Worth Student's investment net worth. NUMBER

RCRAPP4

RCRAPP4_INV_NET_WORTH

IRS_AGI_FLAG Irs Agi Flag Indicates whether IRS Adjusted Gross Income data for the student was transferred to the FAFSA. VARCHAR2(63)

RCRAPP3

RCRAPP3_IRS_AGI_FLAG

IRS_AGI_FLAG_DESC Irs Agi Flag Desc IRS Adjusted Gross Income data for the student was transferred to the FAFSA indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

IRS_DISPLAY_FLAG Irs Display Flag Indicates whether IRS Data Retrieval Transfer option was displayed for the student. VARCHAR2(63)

RCRAPP3

RCRAPP3_IRS_DISPLAY_FLAG

IRS_DISPLAY_FLAG_DESC Irs Display Flag Desc IRS Data Retrieval Transfer option was displayed for the student indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

IRS_FIT_FLAG Irs Fit Flag Indicates whether IRS Federal Income Tax data for the student was transferred to the FAFSA VARCHAR2(63)

RCRAPP3

RCRAPP3_IRS_FIT_FLAG

IRS_FIT_FLAG_DESC Irs Fit Flag Desc IRS Federal Income Tax data for the student was transferred to the FAFSA indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

IRS_REQUEST_STATUS 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 IRS request status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

MARITAL_STATUS_IND Marital Status Indicator Indicates whether or not a student is married. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_MARRIED)

MOTHER_HIGHEST_GRADE Parent 2 Highest Grade Highest grade level completed by the father/mother/stepparent. VARCHAR2(63)

RCRAPP3

RCRAPP3_MOTHER_HI_GRADE

MOTHER_WORK_INCOME Parent 2 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 Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NEED_BASED_EMPLOYMENT Need Based Employment Amount of student's need based earnings. NUMBER

RCRAPP3

RCRAPP3_NEED_BASED_EMPLOY

OFFICIAL_SOURCE_IND Official Source Indicator Official or unofficial indicator. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

OTHER_NON_REPORTED_MONEY Other Non Reported Money Amount of student's other non-reported money. NUMBER

RCRAPP1

RCRAPP1_OTH_NON_REPORT_MONEY

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

RCRAPP1

RCRAPP1_OTH_UNTAXED_INC

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

RCRAPP4

RCRAPP4_P_ASSET_THRESH_EXCD

PARENT_BUSINESS_NET_WORTH Parent Business Net Worth Parent's business net worth. NUMBER

RCRAPP4

RCRAPP4_PAR_BUS_NET_WORTH

PARENT_CASH_ASSET 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 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 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 Parent combat Pay NUMBER

RCRAPP4

RCRAPP4_PAR_COMBAT_PAY

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

RCRAPP3

RCRAPP3_PAR_CO_OP_EARNINGS

PARENT_DPDNT_CARE_CONTRIBUTION Parent Dpdnt Care Contribution The parents' contribution to a flexible spending account for dependent care. NUMBER

RCRAPP4

RCRAPP4_PAR_DEPENDENT_CARE

PARENT_EDUCATION_TAX_CREDIT Parent Education Tax Credit Amount of educational tax credits that the parent has received. NUMBER

RCRAPP3

RCRAPP3_PAR_EDUC_CREDITS

PARENT_FAMILY_IN_COLLEGE 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 Parent Family Size Number of family members in the parents household. NUMBER

RCRAPP1

RCRAPP1_PAR_FAM_MEMB

PARENT_GRANT_SCHOLARSHIP_AID Parent Grant Scholarship Financial Aid Amount of parent's grant and scholarship aid. NUMBER

RCRAPP3

RCRAPP3_PAR_GRANT_SCHOLAR_AID

PARENT_HEALTHCARE_CONTRIBUTION Parent Healthcare Contribution The parents' contribution to a flexible spending account for health care. NUMBER

RCRAPP4

RCRAPP4_PAR_FSA_HEALTH_CARE

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

RCRAPP1

RCRAPP1_PAR_HME_DBT

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

RCRAPP1

RCRAPP1_PAR_HME_VAL

PARENT_HOUSING_FOOD_ALLOWANCE 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_HSA_CONTRIBUTION Parent Hsa Contribution The parents' contribution to a health savings account. NUMBER

RCRAPP4

RCRAPP4_PAR_HEALTH_SAV_ACCOUNT

PARENT_HSA_PRETAX_CONTRIBUTION Parent Hsa Pretax Contribution The amount withheld from the parent's pre-tax wages for a Heath Savings Account. NUMBER

RCRAPP4

RCRAPP4_PAR_HSA_PRE_TAX

PARENT_INCOME_TAX_PAID 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 Investment Net Worth Parent's investment net worth. NUMBER

RCRAPP4

RCRAPP4_PAR_INV_NET_WORTH

PARENT_IRS_AGI_FLAG Parent Irs Agi Flag Indicates whether IRS Adjusted Gross Income data for the parent was transferred to the FAFSA. VARCHAR2(63)

RCRAPP3

RCRAPP3_PAR_IRS_AGI_FLAG

PARENT_IRS_AGI_FLAG_DESC Parent Irs Agi Flag Desc IRS Adjusted Gross Income data for the parent was transferred to the FAFSA indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_IRS_DISPLAY_FLAG Parent Irs Display Flag Indicates whether IRS Data Retrieval Transfer option was displayed for the parent. VARCHAR2(63)

RCRAPP3

RCRAPP3_PAR_IRS_DISPLAY_FLAG

PARENT_IRS_DISPLAY_FLAG_DESC Parent Irs Display Flag Desc IRS Data Retrieval Transfer option was displayed for the parent indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_IRS_FIT_FLAG Parent Irs Fit Flag Indicates whether IRS Federal Income Tax data for the parent was transferred to the FAFSA. VARCHAR2(63)

RCRAPP3

RCRAPP3_PAR_IRS_FIT_FLAG

PARENT_IRS_FIT_FLAG_DESC Parent Irs Fit Flag Desc IRS Federal Income Tax data for the parent was transferred to the FAFSA indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_IRS_REQUEST_STATUS 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 Parent Irs Request Status Description IRS request status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_NEED_BASED_EMPLOYMENT 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 Parent number of businesses. NUMBER

RCRAPP4

RCRAPP4_PAR_NUM_BUSINESSES

PARENT_NUMBER_OF_FARMS Parent Number Of Farms Parent number of farms. NUMBER

RCRAPP4

RCRAPP4_PAR_NUM_FARMS

PARENT_OTHER_UNTAXED_INCOME 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 Retirement Plan Distribution Parent's untaxed IRA distributions. NUMBER

RCRAPP1

RCRAPP1_PAR_IRA_DISTRIBUTIONS

PARENT_RETIREMENT_PLAN_PAYMENT Parent Retirement Plan Payment Parents' deductible IRA and/or Keogh payments. NUMBER

RCRAPP3

RCRAPP3_PAR_IRA_KEOUGH

PARENT_SHORT_TAX_FORM_IND Parent Short Tax Form Indicator Indicates whether the parent is eligible to file a federal short tax form. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_PAR_1040A_ELIG_IND)

PARENT_SNAP_FOOD_STAMPS Parent SNAP Food Stamps Indicates whether anyone in the parents' household received Supplemental Nutrition Assistance Program (SNAP) benefits. VARCHAR2(63)

RCRAPP1

RCRAPP1_PAR_FOOD_STAMPS

PARENT_SNAP_FOOD_STAMPS_DESC Parent SNAP Food Stamps Desc Parent received supplemental nutrition assistance description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_STATE_OF_RESIDENCE 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 Parent State Of Residence Description Parents stare or province of legal residence description. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

PARENT_TAX_DEFERRED_PENSION 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 Parent Tax Exempt Interest Inc Parents' tax exempt interest income. NUMBER

RCRAPP3

RCRAPP3_PAR_TE_INT_INC

PARENT_TAX_FILING_STATUS Parent Tax Filing Status The parents tax filing status. VARCHAR2(63)

RCRAPP1

RCRAPP1_PAR_TAX_FILING_STATUS

PARENT_TAX_RETURN_FILED 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 Description Parent tax return filed dscription. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_TAX_RETURN_TYPE 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 Parent tax return type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_UNTAXED_PENSIONS Parent Untaxed Pensions Parent's untaxed pensions. NUMBER

RCRAPP1

RCRAPP1_PAR_UNTAX_PENSIONS

PARENT_VETERAN_NON_ED_BENEFIT Parent Veteran Non Ed Benefit Parent's veterans non-education benefits. NUMBER

RCRAPP1

RCRAPP1_PAR_VETS_NON_ED_BEN

PARENT_WORKSHEET_B_TOTAL Parent Worksheet B Total Parents' Worksheet B untaxed income total. NUMBER

RCRAPP4

RCRAPP4_PAR_WORKSHEET_B

PARENT_WORKSHEET_C_TOTAL Parent Worksheet C Total Parent's total amount from Worksheet C. NUMBER

RCRAPP4

RCRAPP4_PAR_WORKSHEET_C

PELL_EFC Pell Effective Family Contribution Primary system Pell PGI. NUMBER

RCRAPP2

RCRAPP2_PELL_PGI

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

RCRAPP1

RCRAPP1_PIDM

PROCESS_GROUP 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 Rejection Override 20 Indicator 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 Rejection Override 21 Indicator 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 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(63)

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

RCRAPP3

RCRAPP3_REJECT_OVRD_3

REJECTION_OVERRIDE4_IND Rejection Override 4 Indicator 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 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(63)

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

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

RCRAPP3

RCRAPP3

RCRAPP3_REJECT_OVRD_1

RCRAPP3_REJECT_OVRD_B

REJECTION_OVERRIDE_N_IND Rejection Override N Indicator 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 Rejection Override W Indicator Set by electronic application user to override reject W: Questionable number of family members, greater than 15. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_W

REJECT_REASON_PRIORITY_1 Reject Reason Priority 1 Reject Reason Priority 1 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_1

REJECT_REASON_PRIORITY_10 Reject Reason Priority 10 Reject Reason Priority 10 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_10

REJECT_REASON_PRIORITY_11 Reject Reason Priority 11 Reject Reason Priority 11 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_11

REJECT_REASON_PRIORITY_12 Reject Reason Priority 12 Reject Reason Priority 12 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_12

REJECT_REASON_PRIORITY_13 Reject Reason Priority 13 Reject Reason Priority 13 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_13

REJECT_REASON_PRIORITY_14 Reject Reason Priority 14 Reject Reason Priority 14 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_14

REJECT_REASON_PRIORITY_2 Reject Reason Priority 2 Reject Reason Priority 2 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_2

REJECT_REASON_PRIORITY_3 Reject Reason Priority 3 Reject Reason Priority 3 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_3

REJECT_REASON_PRIORITY_4 Reject Reason Priority 4 Reject Reason Priority 4 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_4

REJECT_REASON_PRIORITY_5 Reject Reason Priority 5 Reject Reason Priority 5 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_5

REJECT_REASON_PRIORITY_6 Reject Reason Priority 6 Reject Reason Priority 6 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_6

REJECT_REASON_PRIORITY_7 Reject Reason Priority 7 Reject Reason Priority 7 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_7

REJECT_REASON_PRIORITY_8 Reject Reason Priority 8 Reject Reason Priority 8 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_8

REJECT_REASON_PRIORITY_9 Reject Reason Priority 9 Reject Reason Priority 9 VARCHAR2(63)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_9

RETIREMENT_PLAN_DISTRIBUTION Retirement Plan Distribution Amount of student's untaxed IRA distributions. NUMBER

RCRAPP1

RCRAPP1_IRA_DISTRIBUTIONS

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

RCRAPP4

RCRAPP4_IRA_KEOUGH_AMT

SAR_C_IND SAR C Indicator 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 SAR Effective Family Contribution 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 Selected For Verification Indicator 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 Short Tax Form Indicator Indicates whether the student is eligible to file a federal short tax form. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_1040A_ELIG_IND)

SNAP_FOOD_STAMPS SNAP Food Stamps Indicates whether anyone in the applicant's household received Supplemental Nutrition Assistance Program (SNAP) benefits. VARCHAR2(63)

RCRAPP1

RCRAPP1_FOOD_STAMPS

SNAP_FOOD_STAMPS_DESC SNAP Food Stamps Desc Received supplemental nutrition description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

SPOUSE_INCOME_WORK 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 State Of Residence Student's state of legal residence. VARCHAR2(63)

RCRAPP1

RCRAPP1_STAT_CODE_RES

STATE_OF_RESIDENCE_DESC State Of Residence Description Name of the student's state, province of legal residence. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

SUPPORT_CHILDREN_IND Support Children Indicator Student has children who receive more than half of their support from him/her. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_HAVE_CHILDREN)

TAX_DEFERRED_PENSION 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 Tax Exempt Interest Inc Students' tax exempt interest income. NUMBER

RCRAPP3

RCRAPP3_TE_INT_INC

TAX_FILING_STATUS Tax Filing Status The student's tax filing status. VARCHAR2(63)

RCRAPP1

RCRAPP1_TAX_FILING_STATUS

TAX_ID 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 Tax ID match status. VARCHAR2(63)

RCRAPP3

RCRAPP3_SOC_SEC

TAX_ID_MATCH_STATUS_DESC Tax ID Match Status Description Tax ID match status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

TAX_RETURN_FILED 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 Tax Return Filed Description Student tax return filed description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

TAX_RETURN_TYPE 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 Tax Return Type Description Description of the tax return type. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

TRANSACTION_NUMBER 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 Untaxed Pensions Amount of student's untaxed pensions. NUMBER

RCRAPP1

RCRAPP1_UNTAX_PENSIONS

USER_ID User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

RCRAPP1

RCRAPP1_USER_ID

VERIFICATION_PRIORITY Verification Priority Indicates the priority of the edits used to select the student for data verification. VARCHAR2(63)

RCRAPP1

RCRAPP1_VERIFICATION_PRTY

VERIFICATION_PRIORITY_DESC Verification Priority Desc Description of the priority of the edits used to select the student for data verification. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

VETERAN_BENEFITS_TYPE 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 Veteran benefits type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRAPP1

RCRAPP1_OTH_VA_AMT

VETERAN_NON_EDUCATION_BENEFIT Veteran Non Education Benefit Amount of student's veterans non-education benefits. NUMBER

RCRAPP1

RCRAPP1_VETS_NON_ED_BEN

VETERAN_OTHER_BENEFITS_MONTHS 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 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 Benefit Description Veteran receiving benefits indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

WORKSHEET_B_TOTAL Worksheet B Total Student's Worksheet B untaxed income total. NUMBER

RCRAPP4

RCRAPP4_WORKSHEET_B

WORKSHEET_C_TOTAL Worksheet C Total Student and spouse total amount from Worksheet C. NUMBER

RCRAPP4

RCRAPP4_WORKSHEET_C

YEAR_IN_COLLEGE 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 Year In College Description Description of the year of studty. VARCHAR2(255)

RORMVAL

RORMVAL_DESC



Ver: 9.2