Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE		RCRAPP1	RCRAPP1_ACTIVITY_DATE
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	Organization-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	Aid year associated with this record.	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	College code identifying the school to which this financial aid applicant record has applied.	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
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
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	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to eachuniversity constituent.	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_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	LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
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_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_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_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_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_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_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_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
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)
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_ID	Tax ID	Tax Identification Number (TIN) is a number which gets assigned by the government to companies (vendors) in the United States of America, for purposes of the IRS and Department of Revenue. Each company is assigned a unique TIN.	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
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.0