Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR	The last two digits of the first year for the academic year being processed. EXAMPLE: '90' for the 1990-91 academic year.	VARCHAR2(2)	RCRAPP1	RCRAPP1_ACYR_CODE
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRAPP1	RCRAPP1_ACTIVITY_DATE
ADJUSTED_GROSS_INCOME	Amount of AGI in the base year reported by the student on his/her federal tax return.	NUMBER	RCRAPP1	RCRAPP1_US_INC
AGE_OLDER_PARENT	Age of the older parent.	NUMBER	RCRAPP1	RCRAPP1_PAR_OLDER_AGE
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RCRAPP1	RCRAPP1_AIDY_CODE
AID_YEAR_DESC	Description of the aid year.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ALIEN_REGISTRATION_NUMBER	Number assigned by the federal government to all eligible permanent resident non-citizens.	VARCHAR2(9)	RCRAPP1	RCRAPP1_ALIEN_REG_NO
APPLICATION_CREATE_DATE	The date that this application record was created on the database, either manually or through dataload.	DATE	RCRAPP1	RCRAPP1_CREATE_DATE
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP1	RCRAPP1_SEQ_NO
APPLICATION_RECEIPT_DATE	Date that the processor received the aid application.	DATE	RCRAPP1	RCRAPP1_RCPT_DATE
APPLICATION_REVISION_RCPT_DATE	Date that the processor received a request for revisions from the student.	DATE	RCRAPP1	RCRAPP1_REV_RCPT_DATE
APPLICATION_SIGNED_BY	Indicates if the application was signed by the student and/or the parent(s).	VARCHAR2(1)	RCRAPP1	RCRAPP1_SIGNED
APPLICATION_SIGNED_BY_DESC	Application signed description.	VARCHAR2(25)	CALCULATION	DECODE(RCRAPP1_SIGNED)
AT_RISK_OF_HOMELESSNESS		VARCHAR2(1)
AT_RISK_OF_HOMELESSNESS_DESC		VARCHAR2(4000)
BIRTH_DATE	Student's date of birth.	DATE	RCRAPP1	RCRAPP1_BIRTH_DATE
BUSINESS_DEBT	Amount of the student's outstanding debts against business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_DBT
BUSINESS_VALUE	Current market value of the student's business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_VAL
CASH_SAVINGS	Amount the student currently has in cash on hand and in savings and checking accounts.	NUMBER	RCRAPP1	RCRAPP1_CASH_AMT
CHILD_SUPPORT_INCOME	Student's base year income from child support received for all children.	NUMBER	RCRAPP1	RCRAPP1_CHILD_SUPP
CITIZENSHIP_ELIGIBILITY_TYPE	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(1)	RCRAPP1	RCRAPP1_CITZ_IND
CITIZENSHIP_ELIGIBIL_TYPE_DESC	Citizen type description.	VARCHAR2(4000)
CITY	City of the student's address from the aid application.	VARCHAR2(50)	RCRAPP1	RCRAPP1_CITY
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE
COLLEGE1	First college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_1
COLLEGE2	Second college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_2
COLLEGE3	Third college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_3
COLLEGE4	Fourth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_4
COLLEGE5	Fifth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_5
COLLEGE6	Sixth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_6
COLLEGE7	Seventh college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_7
COLLEGE8	Eighth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_8
COLLEGE_CHOICE1	Student's first choice of college planning to attend.	VARCHAR2(6)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1
COLLEGE_CHOICE2	Student's second choice of college planning to attend.	VARCHAR2(6)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2
COLLEGE_CHOICE3	Student's third choice of college planning to attend.	VARCHAR2(6)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(1)	RCRAPP1	RCRAPP1_CURR_REC_IND
DATE_APPLICATION_COMPLETED	Date the application was completed.	DATE	RCRAPP1	RCRAPP1_COMPLETION_DATE
DEGREE_BY_JULY_IND	Indicates if the student will have a first bachelor's degree by July 1, of the start of the aid year.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_DEGREE_BY_JULY)
DIVORCED_PARENT_INFO_IND	Indicates whether or not information was supplied by the student about divorced, separated or remarried parents.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND)
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
DRIVER_LICENSE_NUMBER	Student's drivers license number.	VARCHAR2(20)	RCRAPP1	RCRAPP1_DRIVER_LIC_NO
DRIVER_LICENSE_STATE_PROVINCE	State or province that issued the student's drivers license.	VARCHAR2(2)	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(30)	STVSTAT	STVSTAT_DESC
EMANCIPATED_MINOR		VARCHAR2(1)
EMANCIPATED_MINOR_DESC		VARCHAR2(4000)
EXPECTED_ACADEMIC_YEAR_INCOME	Student's expected academic year income from wages.	NUMBER	RCRAPP1	RCRAPP1_EXP_ACYR_INC
EXPECTED_ACAD_YR_OTHER_INC	Student's expected academic year other taxable income.	NUMBER	RCRAPP1	RCRAPP1_EXP_ACYR_OTH_TAX_INC
EXPECTED_ACAD_YR_UNTAX_INC	Student's expected academic year nontaxable income and benefits.	NUMBER	RCRAPP1	RCRAPP1_EXP_ACYR_UNTAX_INC
EXPECTED_ENROLL_STATUS	Student's expected enrollment status for the school year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_EXP_ENROLL_STATUS
EXPECTED_ENROLL_STATUS_DESC	Description of the student's expected enrollment status.	VARCHAR2(4000)
EXPECTED_FATHER_INCOME	Expected calendar year income from work for the student's father.	NUMBER	RCRAPP1	RCRAPP1_EXP_FATH_INC_FR_WRK
EXPECTED_MOTHER_INCOME	Expected calendar year income from work for the student's mother.	NUMBER	RCRAPP1	RCRAPP1_EXP_MOTH_INC_FR_WRK
EXPECTED_PARENT_OTHER_INCOME	Expected calendar year other taxable income for the student's parents.	NUMBER	RCRAPP1	RCRAPP1_EXP_PAR_OTH_TAX_INC
EXPECTED_PARENT_UNTAXED_INCOME	Expected calendar year nontaxable income and benefits for the student's parents.	NUMBER	RCRAPP1	RCRAPP1_EXP_PAR_UNTAX_INC
EXPECTED_SPOUSE_SUMMER_INCOME	Expected income from work during the summer for the student's spouse.	NUMBER	RCRAPP1	RCRAPP1_EXP_SPS_SMR_INC
EXPECTED_SUMMER_INCOME	Student's expected income from work for the summer.	NUMBER	RCRAPP1	RCRAPP1_EXP_SMR_INC
EXPECTED_SUMMER_OTHER_INCOME	Student's expected other taxable income for the summer.	NUMBER	RCRAPP1	RCRAPP1_EXP_SMR_OTH_TAX_INC
EXPECTED_SUMMER_UNTAXED_INC	Student's expected nontaxable income and benefits for the summer.	NUMBER	RCRAPP1	RCRAPP1_EXP_SMR_UNTAX_INC
EXP_SPOUSE_ACAD_YEAR_INCOME	Student's spouse's academic year expected income from work.	NUMBER	RCRAPP1	RCRAPP1_EXP_SPS_ACYR_INC
FAMILY_IN_COLLEGE	Total number of family members in the student's household that attend college at least half time.	NUMBER	RCRAPP1	RCRAPP1_NO_IN_COLL
FAMILY_SIZE	Number of people in the student's household during the school year.	NUMBER	RCRAPP1	RCRAPP1_FAM_MEMB
FATHER_WORK_INCOME	Amount of income earned from work by the student's father in the base year.	NUMBER	RCRAPP1	RCRAPP1_FATH_INC_FR_WRK
FIRST_NAME	Student's first name as reported on the aid application.	VARCHAR2(60)	RCRAPP1	RCRAPP1_FIRST_NAME
GOVERNMENT_BENEFITS	Amount of government benefits (such as social security benefits in the United States) received by the student (and spouse) in the base year.	NUMBER	RCRAPP1	RCRAPP1_SS_BENE
GOVERNMENT_BENEFIT_FOR_STUDENT	The portion of government benefits (such as social security in the United States) received by the family for the student. Institutional Method will exclude students benefits. EFM will include students benefits.	NUMBER	RCRAPP1	RCRAPP1_PAR_SS_BENE_STU_ONLY
GOVERNMENT_FAMILY_AID	Student's base year income from government family aid (such as the Aid to Families with Dependent Children program in the United States).	NUMBER	RCRAPP1	RCRAPP1_AFDC
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	The housing code reported by the student applicant for the school that is receiving this application record.	VARCHAR2(1)	RCRAPP1	RCRAPP1_INST_HOUS_CDE
HOUSING1	The housing code for the school listed first on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_1
HOUSING1_DESC	Housing code description.	VARCHAR2(4000)
HOUSING2	Housing code for the school listed second on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_2
HOUSING2_DESC	Housing code description.	VARCHAR2(4000)
HOUSING3	Housing code for the school listed third on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_3
HOUSING3_DESC	Housing code description.	VARCHAR2(4000)
HOUSING4	Housing code for the school listed fourth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_4
HOUSING4_DESC	Housing code description.	VARCHAR2(4000)
HOUSING5	Housing code for the school listed fifth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_5
HOUSING5_DESC	Housing code description.	VARCHAR2(4000)
HOUSING6	Housing code for the school listed sixth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_6
HOUSING6_DESC	Housing code description.	VARCHAR2(4000)
HOUSING7	Housing code for the school listed seventh on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_7
HOUSING7_DESC	Housing code description.	VARCHAR2(4000)
HOUSING8	Housing code for the school listed eighth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_8
HOUSING8_DESC	Housing code description.	VARCHAR2(4000)
HOUSING_DESC	Institutional housing code description.	VARCHAR2(4000)
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(7)	RCRAPP1	RCRAPP1_INFC_CODE
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(30)	RTVINFC	RTVINFC_DESC
INTERNATIONAL_PHONE_NUMBER		VARCHAR2(15)
LAST_NAME	Student's last name as reported on the aid application.	VARCHAR2(60)	RCRAPP1	RCRAPP1_LAST_NAME
LEGAL_DEPENDENT_IND	Indicates whether or not the student has legal dependents other than a spouse for determining dependency status.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_HAS_LEGAL_DEPEND)
LEGAL_GUARDIANSHIP		VARCHAR2(1)
LEGAL_GUARDIANSHIP_DESC		VARCHAR2(4000)
LINE2_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE2_ATTEND_COLL
LINE2_ATTEND_COLLEGE_DESC	Line2 attends college description.	VARCHAR2(20)
LINE2_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE2_RELSHIP
LINE2_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE2_RELSHIP)
LINE3_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE3_ATTEND_COLL
LINE3_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE3_ATTEND_COLL)
LINE3_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE3_RELSHIP
LINE3_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE3_RELSHIP)
LINE4_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE4_ATTEND_COLL
LINE4_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE4_ATTEND_COLL)
LINE4_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE4_RELSHIP
LINE4_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE4_RELSHIP)
LINE5_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE5_ATTEND_COLL
LINE5_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE5_ATTEND_COLL)
LINE5_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE5_RELSHIP
LINE5_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE5_RELSHIP)
LINE6_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE6_ATTEND_COLL
LINE6_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE6_ATTEND_COLL)
LINE6_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE6_RELSHIP
LINE6_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE6_RELSHIP)
LINE7_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE7_ATTEND_COLL
LINE7_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE7_ATTEND_COLL)
LINE7_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE7_RELSHIP
LINE7_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE7_RELSHIP)
LINE8_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE8_ATTEND_COLL
LINE8_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE8_ATTEND_COLL)
LINE8_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE8_RELSHIP
LINE8_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE8_RELSHIP)
MAILING_CITY		VARCHAR2(21)
MAILING_NATION		VARCHAR2(2)
MAILING_NATION_DESC		VARCHAR2(30)
MAILING_POSTAL_CODE		VARCHAR2(17)
MAILING_STATE_PROVINCE		VARCHAR2(2)
MAILING_STATE_PROVINCE_DESC		VARCHAR2(30)
MAILING_STREET		VARCHAR2(35)
MARITAL_STATUS	Student's reported marital status.	VARCHAR2(1)	RCRAPP1	RCRAPP1_MRTL_STATUS
MARITAL_STATUS_DESC	Marital status description associated with the student.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_MRTL_STATUS)
MEDICAL_DENTAL_EXPENSE	Student's reported base year medical and dental expenses not paid by insurance.	NUMBER	RCRAPP1	RCRAPP1_MED_DEN_EXP
MIDDLE_INITIAL	The student's middle initial as reported on the aid application.	VARCHAR2(60)	RCRAPP1	RCRAPP1_MI
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA
MILTARY_ACTIVE_DUTY		VARCHAR2(1)
MILTARY_ACTIVE_DUTY_DESC		VARCHAR2(4000)
MOTHER_WORK_INCOME	Mother's reported base year income from work.	NUMBER	RCRAPP1	RCRAPP1_MOTH_INC_FR_WRK
NAME_PREFIX	Student's title. (Mr. or Ms.).	VARCHAR2(5)	CALCULATION	DECODE(RCRAPP1_TITLE)
NUMBER_OF_EXEMPTIONS	Number of tax exemptions claimed by the student on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_NO_EXEMPT
OLDER_THAN_24_IND	Indicates whether or not the student is older than 24 years old.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_BORN_BEFORE_1_1_XX)
ORIGINAL_COMPUTE_DATE	Date that the application was originally processed by the processor.	DATE	RCRAPP1	RCRAPP1_ORIG_COMP_DATE
OTHER_NON_REPORTED_MONEY		NUMBER
OTHER_UNTAXED_INCOME	Student's reported base year other untaxed income and benefits.	NUMBER	RCRAPP1	RCRAPP1_OTH_UNTAX_INC
PARENT_ADJUSTED_GROSS_INCOME	Amount of the adjusted gross income in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_US_INC
PARENT_BUSINESS_INCOME	Amount of income the student's parents received from business, farm, rents, royalties, partnerships, estates, trusts, etc. in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_BUS_FARM_INC
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	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_INCOME		NUMBER
PARENT_DIVIDEND_INCOME	Amount of income received from dividends by the student's parents in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_DIV_INC
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_GOVERNMENT_BENEFITS	Government benefits (such as Social Security in the United States) received in the base year by the student's parents for all household members.	NUMBER	RCRAPP1	RCRAPP1_PAR_SS_BENE
PARENT_GOVERNMENT_FAMILY_AID	Amount of government aid (such as Aid to Families with Dependent Children in the United States) received by the student's parents in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_AFDC
PARENT_HOME_AMOUNT_PAID	Amount that the student's parents paid for their home.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_PURCH_AMT
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_HOME_YEAR_PURCHASED	Last two digits of the year that the student's parents purchased their home.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_YR_PURCH
PARENT_HOUSING_STATUS	Housing Status of the parent.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_HOUS_STAT
PARENT_HOUSING_STATUS_DESC	Parent housing status description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_PAR_HOUS_STAT)
PARENT_INCOME_ADJUSTMENTS	Amount that the parents reported as adjustments to income on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_ADJ_TO_INC
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_INTEREST_INCOME	Amount of interest income received in the base year by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_INT_INC
PARENT_MARITAL_STATUS	Marital status for the student's parents.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_MRTL_STATUS
PARENT_MARITAL_STATUS_DESC	Parents marital status description.	VARCHAR2(4000)
PARENT_MEDICAL_DENTAL_EXPENSE	Amount of medical and dental expenses paid by the student's parents in the base year that was not paid by insurance.	NUMBER	RCRAPP1	RCRAPP1_PAR_MED_DEN_EXP
PARENT_NATION_OF_RESIDENCE		VARCHAR2(2)
PARENT_NATION_RESIDENCE_DESC		VARCHAR2(30)
PARENT_NO_CHILD_SEC_TUITION_PD	Number of children in the parents household that incurred elementary, jr. high, or high school tuition expenses.	NUMBER	RCRAPP1	RCRAPP1_PAR_NO_CHILD_TUIT
PARENT_NUMBER_OF_EXEMPTIONS	Number of income tax exemptions claimed by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_NO_EXEMPT
PARENT_OTHER_INCOME	Other taxable income reported by the student's parents from alimony, capital gains, pensions, annuities, etc.	NUMBER	RCRAPP1	RCRAPP1_PAR_OTH_TAX_INC
PARENT_OTHER_UNTAXED_INCOME	Other untaxed income received in the base year by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_OTH_UNTAX_INC
PARENT_REMARRIAGE_DATE	Date parent remarried.	DATE	RCRAPP1	RCRAPP1_PAR_REMARRIAGE_DATE
PARENT_RETIREMENT_PLAN_DISTRIB		NUMBER
PARENT_STATE_OF_RESIDENCE	State or province of legal residence for the student's parents.	VARCHAR2(2)	RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES
PARENT_STATE_OF_RESIDENCE_DESC	Parents stare or province of legal residence description.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
PARENT_TAX_RETURN_TYPE	Type of federal income tax return form the student's parents filed.	VARCHAR2(2)	RCRAPP1	RCRAPP1_PAR_TAX_FORM_IND
PARENT_TAX_RETURN_TYPE_DESC	Parent tax return type description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_PAR_TAX_FORM_IND)
PARENT_TUITION_PAID	Amount of elementary, jr. high, and high school tuition paid by the student's parents in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_TUIT_PD
PARENT_UNTAXED_PENSIONS		NUMBER
PARENT_VETERAN_NON_ED_BENEFIT		NUMBER
PARENT_WAGES	Amount of wages, salaries, tips, etc. in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_WAGES
PERMIT_DRAFT_REGISTRATION_IND	Indicates whether or not the student gave permission to the processor to send data to the Selective Service for draft registration.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PERMIT_DRAFT_REG
PERM_RESIDENCY_CONFIRMED_IND	Indicates whether or not the student's permanent resident status has been confirmed by the federal government.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_INS)
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP1	RCRAPP1_PIDM
PHONE_AREA	Area code of the student's home telephone number.	VARCHAR2(6)	RCRAPP1	RCRAPP1_PHONE_AREA
PHONE_NUMBER	Student's home telephone number without area code.	VARCHAR2(12)	RCRAPP1	RCRAPP1_PHONE_NO
POSTAL_CODE	Postal code for the student's address.	VARCHAR2(30)	RCRAPP1	RCRAPP1_ZIP
REQUESTED_AID_FALL	Indicates if the student requested aid for the fall term.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_FALL_THIS_YR
REQUESTED_AID_FALL_DESC	Requested aid for the fall description.	VARCHAR2(4000)
REQUESTED_AID_NEXT_SUMMER	Indicates if the student requested aid for the summer term following the normal school year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_SUMMER_NEXT_YR
REQUESTED_AID_NEXT_SUMMER_DESC	Requested aid for the next summer description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR)
REQUESTED_AID_PRECEDING_SUMMER	Indicates if the student requested aid for the summer term that preceded the normal school year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_SUMMER_THIS_YR
REQUESTED_AID_PREC_SUMMER_DESC	Requested aid for the preceding summer description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)
REQUESTED_AID_SPRING	Indicates if the student requested aid for the spring term.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_SPRING_NEXT_YR
REQUESTED_AID_SPRING_DESC	Requested aid for the spring description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)
REQUESTED_AID_WINTER	Indicates if the student requested aid for the winter term.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_WINTER_NEXT_YR
REQUESTED_AID_WINTER_DESC	Requested aid for the winter description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)
RETIREMENT_PLAN_DISTRIBUTION		NUMBER
REVISION_COMPUTE_DATE	Date that the processor processed a revised report for the applicant.	DATE	RCRAPP1	RCRAPP1_REV_COMP_DATE
SELECTED_FOR_VERIFICATION_IND	Indicates whether or not the student has been selected for verification by the Federal Government or by the institution.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_VERIFICATION_MSG)
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
START_RESIDENCE_DATE	Date the student began living in his/her state or province of legal residence in MMYY format.	VARCHAR2(4)	RCRAPP1	RCRAPP1_START_RES_MTH_YR
STATE_OF_RESIDENCE	Student's state or province of legal residence.	VARCHAR2(2)	RCRAPP1	RCRAPP1_STAT_CODE_RES
STATE_OF_RESIDENCE_DESC	Name of the student's state or province of legal residence.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
STATE_PROVINCE	State or province associated with the student's address.	VARCHAR2(2)	RCRAPP1	RCRAPP1_STAT_CODE
STATE_PROVINCE_DESC	State or province name associated with the student's address.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
STREET	Student's number and street for their address as reported on their aid application.	VARCHAR2(75)	RCRAPP1	RCRAPP1_ADDR
TAX_ID	Student's tax identification number assigned by their home federal government as reported on the aid application.	VARCHAR2(15)	RCRAPP1	RCRAPP1_SSN
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(2)	RCRAPP1	RCRAPP1_TAX_FORM_IND
TAX_RETURN_TYPE_DESC	Description of the tax return type.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_TAX_FORM_IND)
TRANSACTION_NUMBER	The one up sequence number assigned by the Central Processing System to this application/correction record.	VARCHAR2(2)	RCRAPP1	RCRAPP1_USED_TRANS_NO
UNACCOMPANIED_YOUTH_HUD		VARCHAR2(1)
UNACCOMPANIED_YOUTH_HUD_DESC		VARCHAR2(4000)
UNACCOMPANIED_YOUTH_SCHL_DESC		VARCHAR2(4000)
UNACCOMPANIED_YOUTH_SCHOOL		VARCHAR2(1)
UNTAXED_PENSIONS		NUMBER
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RCRAPP1	RCRAPP1_USER_ID
VERIFICATION_PRIORITY	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(4)	RCRAPP1	RCRAPP1_VERIFICATION_PRTY
VETERAN_BENEFITS_TYPE		VARCHAR2(1)
VETERAN_BENEFITS_TYPE_DESC		VARCHAR2(4000)
VETERAN_IND	Indicates if the student is a veteran of the Armed Forces.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_US_VET)
VETERAN_MONTHLY_OTHER_BENEFITS		NUMBER
VETERAN_NON_EDUCATION_BENEFIT		NUMBER
VETERAN_OTHER_BENEFITS	Amount per month from other VA programs.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_AMT
VETERAN_OTHER_BENEFITS_MONTHS		NUMBER
VETERAN_OTH_BEN_NO_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		VARCHAR2(1)
VETERAN_RECEIVING_BENEFIT_DESC		VARCHAR2(4000)
WARD_OF_COURT		VARCHAR2(1)
WARD_OF_COURT_DESC		VARCHAR2(4000)
WARD_OF_COURT_IND	Indicates if the student reported being a ward of the court or is an orphan.	VARCHAR2(1)
YEAR_IN_COLLEGE	Year of study (first, second, etc.) that the student enrolls in this year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_YR_IN_COLL
YEAR_IN_COLLEGE_DESC	Description of the year of study.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_YR_IN_COLL)
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: