Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_FINAID_APPLICATION1

Description Contains information pertaining to financial aid needs analysis.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.

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

RCRAPP1

RCRAPP1_US_INC

AGE_OLDER_PARENT Age of the older parent. NUMBER(2)

RCRAPP1

RCRAPP1_PAR_OLDER_AGE

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). 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(3)

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)

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

RCRAPP1

RCRAPP1_BUS_FARM_DBT

BUSINESS_VALUE Current market value of the student's business and farm assets. NUMBER(7)

RCRAPP1

RCRAPP1_BUS_FARM_VAL

CASH_SAVINGS Amount the student currently has in cash on hand and in savings and checking accounts. NUMBER(7)

RCRAPP1

RCRAPP1_CASH_AMT

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

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

CALCULATION

DECODE(RCRAPP1_CITZ_IND)

CITY City of the student's address from the aid application. VARCHAR2(50)

RCRAPP1

RCRAPP1_CITY

COLLEGE College code identifying the school to which this financial aid applicant record has applied. 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 a college to receive information from the Central Processing System. VARCHAR2(6)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_1

COLLEGE_CHOICE2 Student's second choice of a college to receive information from the Central Processing System. VARCHAR2(6)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_2

COLLEGE_CHOICE3 Student's third choice of a college to receive information from the Central Processing System. 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

EXPECTED_ACADEMIC_YEAR_INCOME Student's expected academic year income from wages. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_ACYR_INC

EXPECTED_ACAD_YR_OTHER_INC Student's expected academic year other taxable income. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_ACYR_OTH_TAX_INC

EXPECTED_ACAD_YR_UNTAX_INC Student's expected academic year nontaxable income and benefits. NUMBER(6)

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

CALCULATION

DECODE(RCRAPP1_EXP_ENROLL_STATUS)

EXPECTED_FATHER_INCOME Expected calendar year income from work for the student's father. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_FATH_INC_FR_WRK

EXPECTED_MOTHER_INCOME Expected calendar year income from work for the student's mother. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_MOTH_INC_FR_WRK

EXPECTED_PARENT_OTHER_INCOME Expected calendar year other taxable income for the student's parents. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_PAR_OTH_TAX_INC

EXPECTED_PARENT_UNTAXED_INCOME Expected calendar year nontaxable income and benefits for the student's parents. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_PAR_UNTAX_INC

EXPECTED_SPOUSE_SUMMER_INCOME Expected income from work during the summer for the student's spouse. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_SPS_SMR_INC

EXPECTED_SUMMER_INCOME Student's expected income from work for the summer. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_SMR_INC

EXPECTED_SUMMER_OTHER_INCOME Student's expected other taxable income for the summer. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_SMR_OTH_TAX_INC

EXPECTED_SUMMER_UNTAXED_INC Student's expected nontaxable income and benefits for the summer. NUMBER(6)

RCRAPP1

RCRAPP1_EXP_SMR_UNTAX_INC

EXP_SPOUSE_ACAD_YEAR_INCOME Student's spouse's academic year expected income from work. NUMBER(6)

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

RCRAPP1

RCRAPP1_NO_IN_COLL

FAMILY_SIZE Number of people in the student's household during the school year. NUMBER(2)

RCRAPP1

RCRAPP1_FAM_MEMB

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

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

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

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

RCRAPP1

RCRAPP1_AFDC

HOME_DEBT Student's current outstanding debts against the home. NUMBER(7)

RCRAPP1

RCRAPP1_HME_DBT

HOME_VALUE Current market value of the student's home. NUMBER(7)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_1)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_2)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_3)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_4)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_5)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_6)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_7)

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

CALCULATION

DECODE(RCRAPP1_HOUS_CDE_8)

HOUSING_DESC Institutional housing code description. VARCHAR2(20)

CALCULATION

DECODE(RCRAPP1_INST_HOUS_CDE)

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

RCRAPP1

RCRAPP1_US_INC_TAX_PD

INCOME_WORK Amount of the student's base year income from working. NUMBER(6)

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

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)

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)

CALCULATION

DECODE(RCRAPP1_LINE2_ATTEND_COLL)

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)

MARITAL_STATUS Student's reported marital status. VARCHAR2(1)

RCRAPP1

RCRAPP1_MRTL_STATUS

MARITAL_STATUS_DESC Marital status description associated with the student. VARCHAR2(20)

CALCULATION

DECODE(RCRAPP1_MRTL_STATUS)

MEDICAL_DENTAL_EXPENSE Student's reported base year medical and dental expenses not paid by insurance. NUMBER(6)

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

MOTHER_WORK_INCOME Mother's reported base year income from work. NUMBER(6)

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

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_UNTAXED_INCOME Student's reported base year other untaxed income and benefits. NUMBER(6)

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

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

RCRAPP1

RCRAPP1_PAR_BUS_FARM_INC

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

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

RCRAPP1

RCRAPP1_PAR_CHILD_SUPP

PARENT_DIVIDEND_INCOME Amount of income received from dividends by the student's parents in the base year. NUMBER(6)

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

RCRAPP1

RCRAPP1_PAR_NO_IN_COLL

PARENT_FAMILY_SIZE Number of family members in the parents household. NUMBER(2)

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

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

RCRAPP1

RCRAPP1_PAR_AFDC

PARENT_HOME_AMOUNT_PAID Amount that the student's parents paid for their home. NUMBER(7)

RCRAPP1

RCRAPP1_PAR_HME_PURCH_AMT

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

RCRAPP1

RCRAPP1_PAR_HME_DBT

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

RCRAPP1

RCRAPP1_PAR_HME_VAL

PARENT_HOME_YEAR_PURCHASED Last two digits of the year that the student's parents purchased their home. NUMBER(4)

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

CALCULATION

DECODE(RCRAPP1_PAR_HOUS_STAT)

PARENT_INCOME_ADJUSTMENTS Amount that the parents reported as adjustments to income on their federal tax return. NUMBER(6)

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

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

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

CALCULATION

CALCULATION(RCRAPP1_PAR_MRTL_STATUS)

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

RCRAPP1

RCRAPP1_PAR_MED_DEN_EXP

PARENT_NO_CHILD_SEC_TUITION_PD Number of children in the parents household that incurred elementary, jr. high, or high school tuition expenses. NUMBER(1)

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

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

RCRAPP1

RCRAPP1_PAR_OTH_TAX_INC

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

RCRAPP1

RCRAPP1_PAR_OTH_UNTAX_INC

PARENT_REMARRIAGE_DATE Date parent remarried. DATE

RCRAPP1

RCRAPP1_PAR_REMARRIAGE_DATE

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

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

RCRAPP1

RCRAPP1_PAR_TUIT_PD

PARENT_WAGES Amount of wages, salaries, tips, etc. in the base year reported by the student's parents on their federal tax return. NUMBER(6)

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

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

CALCULATION

DECODE(RCRAPP1_RQST_FA_FALL_THIS_YR)

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

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

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

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

CALCULATION

DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)

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

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

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

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_IND Indicates if the student is a veteran of the Armed Forces. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP1_US_VET)

VETERAN_OTHER_BENEFITS Amount per month from other VA programs. NUMBER(4)

RCRAPP1

RCRAPP1_OTH_VA_AMT

VETERAN_OTH_BEN_NO_MONTHS Number of months that the other VA benefits will be received during the award year. NUMBER(2)

RCRAPP1

RCRAPP1_OTH_VA_MTH

WARD_OF_COURT_IND Indicates if the student reported being a ward of the court or is an orphan. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP1_WARD_OF_COURT)

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

CALCULATION

DECODE(RCRAPP1_YR_IN_COLL)

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 8.0