Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: NEED_ANALYSIS_DEMOGRAPHIC

Description Contains demographic information about the student and parents from the financial aid application. Also contains information specific to the financial aid application itself.
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

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

RCRAPP1

RCRAPP1_ACYR_CODE

ACTIVITY_DATE Date record was inserted or updated. DATE

RCRAPP1

RCRAPP1_ACTIVITY_DATE

ADDRESS_CHANGE Address Only Change Flag. VARCHAR2(63)

RCRAPP4

RCRAPP4_ADDRESS_CHG_FLAG

ADDRESS_CHANGE_DESC Address Only Change Flag description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_ADDRESS_CHG_FLAG)

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

RCRAPP3

RCRAPP3_ADJ_EFC_CALC_REQ

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AGE_OLDER_PARENT Age of the older parent. NUMBER

RCRAPP1

RCRAPP1_PAR_OLDER_AGE

AID_ELIGIBILITY_RESPONSE Drug Offense Conviction indicated. VARCHAR2(63)

RCRAPP4

RCRAPP4_DRUG_OFFENSE_CONVIC

AID_ELIGIBILITY_RESPONSE_DESC Aid eligibility response description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

RCRAPP1

RCRAPP1_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ALIEN_REGISTRATION_NUMBER Number assigned by the federal government to all eligible permanent resident non-citizens. VARCHAR2(63)

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

RCRAPP2

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

CALCULATION

DECODE(RCRAPP1_SIGNED)

APPLICATION_SIGNED_BY_DESC Application signed description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP1_SIGNED)

APPLICATION_TYPE Indicates the type (regular or renewal) of application. VARCHAR2(63)

RCRIMP1

RCRIMP1_APPLIC_TYPE

APPLICATION_TYPE_DESC Application type description. VARCHAR2(255)

CALCULATION

DECODE(RCRIMP1_APPLIC_TYPE)

ASSUMPTION_OVERRIDE1_IND Set by electronic application user to override assumption 1: Parent's Number of Family Members assumed to be 3. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_1

ASSUMPTION_OVERRIDE2_IND Set by electronic application user to override assumption 2: Parents' AGI assumed equal to sum parent 1 and parent 2 earned income portions. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_2

ASSUMPTION_OVERRIDE3_IND Set by electronic application user to override assumption 3: Parent's AGI assumed equal to sum of parent's earned income portions. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_3

ASSUMPTION_OVERRIDE4_IND Set by electronic application user to override assumption 4: Student's Number of College assumed to be 1. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_4

ASSUMPTION_OVERRIDE5_IND Set by electronic application user to override assumption 5: Student's AGI assumed equal to sum of student's and spouse's earned income portions. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_5

ASSUMPTION_OVERRIDE6_IND Set by electronic application user to override assumption 6: Student's social security benefits assumed to be zero. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_6

ASSUMPTION_OVERRIDE7_IND Set by electronic application user to override assumption 7: Student's other real estate/investment value and debt assumed to be zero. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_7

ASSUMPTION_OVERRIDE8_IND Set by electronic application user to override assumption 8: Student's business value and debt assumed to be zero. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_8

ASSUMPTION_OVERRIDE9_IND Set by electronic application user to override assumption 9: Student's farm value and debt assumed to be zero. VARCHAR2(63)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_9

AT_RISK_OF_HOMELESSNESS Indicates whether student is at risk of being homeless. VARCHAR2(63)

RCRAPP1

RCRAPP1_AT_RISK_HOMELESS

AT_RISK_OF_HOMELESSNESS_DESC At risk of homelessness indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

BIRTH_DATE Student's date of birth. DATE

RCRAPP1

RCRAPP1_BIRTH_DATE

CITIZENSHIP_ELIGIBILITY_TYPE Identifies the person's citizen type relationship to the institution's home country. VARCHAR2(63)

RCRAPP1

RCRAPP1_CITZ_IND

CITIZENSHIP_ELIGIBIL_TYPE_DESC Citizen type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

CITIZENSHIP_TYPE Student citizenship type. VARCHAR2(63)

RCRAPP4

RCRAPP4_SSA_CITIZEN_IND

CITIZENSHIP_TYPE_DESC Student citizenship type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRAPP1

RCRAPP1_CITY

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

RCRAPP1

RCRAPP1_COLL_CDE

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

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_1

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_10

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

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_2

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

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_3

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_4

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_5

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_6

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_7

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_8

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

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_9

CORRECTION_SOURCE Source of the correction. VARCHAR2(63)

RCRAPP4

RCRAPP4_SOURCE_CORRECTION

CORRECTION_SOURCE_DESC Correction source description VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_SOURCE_CORRECTION)

CPS_ISIR_PUSHED_IND CPS pushed ISIR flag. VARCHAR2(63)

CALCULATION

NVL(RCRAPP4_PUSH_ISIR_FLAG)

CURRENT_RECORD_IND Specifies that this is the current need analysis record. VARCHAR2(63)

RCRAPP1

RCRAPP1_CURR_REC_IND

DATE_APPLICATION_COMPLETED Date the application was completed. DATE

RCRAPP1

RCRAPP1_COMPLETION_DATE

DEATH_DATE Date of death associated with the person on this application as reported to the government. DATE

RCRAPP4

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

CALCULATION

DECODE(RCRAPP1_DEGREE_BY_JULY)

DEGREE_TYPE Contains the abbreviation of the degree or certificate a student is pursuing. VARCHAR2(63)

RCRAPP3

RCRAPP3_DEGREE_TYPE

DEGREE_TYPE_DESC Degree type description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP3_DEGREE_TYPE)

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

RCRAPP3

RCRAPP3_FAA_DEP_OVERRIDE

DEPENDENCY_OVERRIDE_DESC Dependency override description. VARCHAR2(255)

CALCULATION

DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)

DOD_MATCH Applicant's SSN included in the Department of Defense match file. VARCHAR2(63)

RCRAPP4

RCRAPP4_DOD_MATCH_FLAG

DOD_MATCH_DESC Department Of Defense match flag. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

DOD_PARENT_DEATH_DATE Date the parent of the applicant died. DATE

RCRAPP4

RCRAPP4_DOD_PAR_DEATH_DATE

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

RCRAPP1

RCRAPP1_DRIVER_LIC_NO

DRIVER_LICENSE_STATE_PROVINCE State or province that issued the student's drivers license. VARCHAR2(63)

RCRAPP1

RCRAPP1_STAT_CODE_LIC

DRIVER_LICENSE_STATE_PROV_DESC Description of the state or province in which the student holds a drivers license. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DUPLICATE_TAX_ID_IND Duplicate tax id indicator identifies whether more than one person is using the same ID number. VARCHAR2(63)

CALCULATION

NVL(RCRAPP4_DUP_SSN_IND)

EFC_CHANGE_FLAG EFC change flag indicates whether the EFC has increased or decreased. VARCHAR2(63)

RCRAPP4

RCRAPP4_EFC_CHANGE_IND

EFC_CHANGE_FLAG_DESC EFC change flag description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_EFC_CHANGE_IND)

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

RCRAPP3

RCRAPP3_EFC_RECALC_CORR_REQ

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

RORMVAL

RORMVAL_DESC

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

RCRAPP4

RCRAPP4_EMAIL_ADDRESS

EMANCIPATED_MINOR Indicates whether student is an emancipated minor. VARCHAR2(63)

RCRAPP1

RCRAPP1_EMANCIPATED_MINOR

EMANCIPATED_MINOR_DESC Emancipated minor indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

ENROLLMENT_PLANNING_SERVICE EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only). VARCHAR2(63)

RCRAPP2

RCRAPP2_EPS_CDE

ENROLLMENT_PLANNING_SERV_DESC Description of the EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only). VARCHAR2(255)

STVEPSC

STVEPSC_DESC

FAMILY_IN_COLLEGE Total number of family members in the student's household that attend college at least half time. NUMBER

CALCULATION

DECODE(RCRAPP2_MODEL_CDE)

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

CALCULATION

DECODE(RCRAPP2_MODEL_CDE)

FATHER_BIRTH_DATE Father's/Mother's/Stepparent's date of birth. DATE

RCRAPP4

RCRAPP4_FATH_BIRTH_DATE

FATHER_LAST_NAME Father's/Mother's/Stepparent's last name. VARCHAR2(63)

RCRAPP4

RCRAPP4_FATH_LAST_NAME

FATHER_SIGNATURE_IND Indicates whether or not a father's signature is on the application. Obsolete after aid year 0405. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_FATH)

FATHER_TAX_ID Father's/Mother's/Stepparent's tax id. VARCHAR2(63)

RCRAPP4

RCRAPP4_FATH_SSN

FATHER_TAX_ID_MATCH Father's/Mother's/Stepparent's Tax ID match flag. VARCHAR2(63)

RCRAPP3

RCRAPP3_FATH_SSN_MATCH

FATHER_TAX_ID_MATCH_DESC Parent 1 Tax ID match description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRAPP3

RCRAPP3_FAA_TITLE_IV_CODE

FINANCIAL_AID_STATUS Indicates the student's financial aid status. VARCHAR2(63)

RCRIMP1

RCRIMP1_FIN_AID_STATUS

FINANCIAL_AID_STATUS_DESC Financial aid status description. VARCHAR2(255)

CALCULATION

DECODE(RCRIMP1_AID_STATUS)

FIRST_NAME Student's first name as reported on the aid application. VARCHAR2(63)

RCRAPP1

RCRAPP1_FIRST_NAME

FOREIGN_ADDRESS_IND Indicates that the student lives outside the nation in which the institution is located. VARCHAR2(63)

CALCULATION

DECODE(RCRIMP1_FOREIGN_ADDR_IND)

FOREIGN_COUNTRY Identifies the country for students that live outside the nation in which the institution is located. VARCHAR2(63)

RCRIMP1

RCRIMP1_COUNTRY

FOREIGN_POSTAL_CODE Identifies the foreign postal code for students that live outside the nation in which the institution is located. VARCHAR2(63)

RCRIMP1

RCRIMP1_FOREIGN_POSTAL_CDE

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

CALCULATION

DECODE(RCRAPP3_GRAD_OR_PROF)

HOUSING The housing code reported by the student applicant for the school that is receiving this application record. VARCHAR2(63)

RCRAPP1

RCRAPP1_INST_HOUS_CDE

HOUSING_DESC Institutional housing code description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

INTERFACE_TAPE_CODE Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.). VARCHAR2(63)

RCRAPP1

RCRAPP1_INFC_CODE

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

RTVINFC

RTVINFC_DESC

INTERNATIONAL_PHONE_NUMBER Phone number for a student who resides in a country outside the U.S. VARCHAR2(63)

RCRAPP1

RCRAPP1_INTL_PHONE_NO

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

RCRAPP3

RCRAPP3_IRS_REQUEST_FLAG

IRS_REQUEST_STATUS_DESC IRS request status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

LAST_NAME Student's last name as reported on the aid application. VARCHAR2(63)

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

CALCULATION

DECODE(RCRAPP1_HAS_LEGAL_DEPEND)

LEGAL_GUARDIANSHIP Indicates whether student is in legal guardianship. VARCHAR2(63)

RCRAPP1

RCRAPP1_LEGAL_GUARDIAN

LEGAL_GUARDIANSHIP_DESC Legal guardian indicator description VARCHAR2(255)

RORMVAL

RORMVAL_DESC

LEGAL_RESIDENT_IND Indicates whether the student was a legal resident before January 1, YYYY. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_LEGAL_RES_IND)

MAILING_CITY City of the student's mailing address from the aid application. VARCHAR2(63)

RCRAPP1

RCRAPP1_MAIL_CITY

MAILING_NATION Country code of the student's mailing address as reported on their application. VARCHAR2(63)

RCRAPP1

RCRAPP1_MAIL_COUNTRY_CDE

MAILING_NATION_DESC Nation/country code description. VARCHAR2(255)

STVNATN

STVNATN_NATN

MAILING_POSTAL_CODE Postal code for the student's mailing address. VARCHAR2(63)

RCRAPP1

RCRAPP1_MAIL_POSTAL_CDE

MAILING_STATE_PROVINCE Postal code for the student's mailing address. VARCHAR2(63)

RCRAPP1

RCRAPP1_MAIL_STAT_CODE

MAILING_STATE_PROVINCE_DESC State or province name associated with the student's mailing address. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

MAILING_STREET Number and street of student's mailing address as reported on their aid application. VARCHAR2(255)

RCRAPP1

RCRAPP1_MAIL_ADDR

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

RCRAPP1

RCRAPP1_MRTL_STATUS

MARITAL_STATUS_DATE Month and year the student is married, widowed, separated, or divorced. VARCHAR2(63)

RCRAPP3

RCRAPP3_S_MAR_MTH_YR

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

RORMVAL

RORMVAL_DESC

MIDDLE_INITIAL The student's middle initial as reported on the aid application. VARCHAR2(63)

RCRAPP1

RCRAPP1_MI

MILITARY_REGISTRATION_STATUS Military registration match flag. VARCHAR2(63)

RCRAPP4

RCRAPP4_SS_MATCH

MILITARY_REGIST_STATUS_DESC Military registration match description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

MILITARY_REG_REQ_STATUS Results from the student's request to be registered with the military service. VARCHAR2(63)

RCRAPP4

RCRAPP4_SS_REG_FLAG

MILITARY_REG_REQ_STATUS_DESC Student military registration request status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

MILTARY_ACTIVE_DUTY Indicates whether applicant is on active duty in the military. VARCHAR2(63)

RCRAPP1

RCRAPP1_ACTIVE_DUTY

MILTARY_ACTIVE_DUTY_DESC Military active duty indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

MOTHER_BIRTH_DATE Father's/Mother's/Stepparent's date of birth. DATE

RCRAPP4

RCRAPP4_MOTH_BIRTH_DATE

MOTHER_LAST_NAME Father's/Mother's/Stepparent's last name. VARCHAR2(63)

RCRAPP4

RCRAPP4_MOTH_LAST_NAME

MOTHER_SIGNATURE_IND Indicates whether or not a mother's signature is on the application. Obsolete after aid year 0405. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_MOTH)

MOTHER_TAX_ID Father's/Mother's/Stepparent's tax id. VARCHAR2(63)

RCRAPP4

RCRAPP4_MOTH_SSN

MOTHER_TAX_ID_MATCH Father's/Mother's/Stepparent's Tax ID match flag. VARCHAR2(63)

RCRAPP3

RCRAPP3_MOTH_SSN_MATCH

MOTHER_TAX_ID_MATCH_DESC Parent 2 Tax ID match description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NAME_PREFIX Student's title. (Mr. or Ms.). VARCHAR2(63)

CALCULATION

DECODE(RCRAPP1_TITLE)

NATIONAL_STUDENT_LOAN_SYSTEM Indicates the results of the tape match against the National Student Loan Data System database. VARCHAR2(63)

RCRAPP4

RCRAPP4_NSLDS_MATCH

NATIONAL_STUDENT_LOAN_SYS_DESC National student loan system description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_NSLDS_MATCH)

NATION_OF_CITIZENSHIP Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting. VARCHAR2(63)

RCRIMP1

RCRIMP1_CITZ_COUNTRY

NUMBER_OF_EXEMPTIONS Number of tax exemptions claimed by the student on their federal tax return. NUMBER

RCRAPP1

RCRAPP1_NO_EXEMPT

OFFICIAL_SOURCE_IND Official or unofficial indicator. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

OLDER_THAN_24_IND Indicates whether or not the student is older than 24 years old. VARCHAR2(63)

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

OTHERS_NUMBER_IN_COLLEGE Number of non-parents in the household that will be in college as used in the calculation of parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_OTH_IN_COLL

PARENT_DIVORCE_YEAR Year of parents' divorce. VARCHAR2(63)

RCRIMP1

RCRIMP1_PAR_YR_DIV

PARENT_EMAIL_ADDRESS Parent's Email Address. VARCHAR2(255)

RCRAPP4

RCRAPP4_P_EMAIL_ADDRESS

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_IRS_REQUEST_STATUS Status of the data request sent to the IRS for the student. VARCHAR2(63)

RCRAPP3

RCRAPP3_PAR_IRS_REQUEST_FLAG

PARENT_IRS_REQUEST_STATUS_DESC IRS request status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_LEGAL_RESIDENT_IND Indicates whether the parent was a legal resident before January 1, YYYY. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_PAR_LEGAL_RES_IND)

PARENT_MARITAL_STATUS Marital status for the student's parents. VARCHAR2(63)

RCRAPP1

RCRAPP1_PAR_MRTL_STATUS

PARENT_MARITAL_STATUS_DATE Month and year the parents were married, widowed, separated, or divorced. VARCHAR2(63)

RCRAPP3

RCRAPP3_PAR_MAR_MTH_YR

PARENT_MARITAL_STATUS_DESC Parents marital status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_NATION_OF_RESIDENCE Nation/country of legal residence for the student's parents. VARCHAR2(63)

RCRAPP1

RCRAPP1_PAR_CNTRY_CODE_RES

PARENT_NATION_RESIDENCE_DESC Parent nation/country of residence description. VARCHAR2(255)

STVNATN

STVNATN_NATN

PARENT_NUMBER_IN_COLLEGE Number in college that are parents of the student. NUMBER

RCRAPP2

RCRAPP2_C_PAR_PAR_IN_COLL

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_REMARRIAGE_DATE Date parent remarried. DATE

RCRAPP1

RCRAPP1_PAR_REMARRIAGE_DATE

PARENT_SEPARATION_YEAR Year of parents' separation. VARCHAR2(63)

RCRIMP1

RCRIMP1_PAR_YR_SEP

PARENT_STATE_OF_RESIDENCE State or province of legal residence for the student's parents. VARCHAR2(63)

RCRAPP1

RCRAPP1_PAR_STAT_CODE_RES

PARENT_STATE_OF_RESIDENCE_DESC Parents state or province of legal residence description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PARENT_TYPE1 Type of parent assigned to the traditional father position. VARCHAR2(63)

RCRAPP4

RCRAPP4_PARENT_TYPE_1

PARENT_TYPE1_DESC Parent type 1 description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_TYPE2 Type of parent assigned to the traditional mother position. VARCHAR2(63)

RCRAPP4

RCRAPP4_PARENT_TYPE_2

PARENT_TYPE2_DESC Parent type 2 description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

CALCULATION

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

CALCULATION

DECODE(RCRAPP1_INS)

PERM_RESIDENCY_VER_STATUS Permanent residency verification status. VARCHAR2(63)

RCRAPP4

RCRAPP4_SEC_INS_MATCH_IND

PERM_RESIDENCY_VER_STATUS_DESC Permanent residency verification status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRAPP1

RCRAPP1_PHONE_AREA

PHONE_NUMBER Student's home telephone number without area code. VARCHAR2(63)

RCRAPP1

RCRAPP1_PHONE_NO

POSTAL_CODE Postal code for the student's address. VARCHAR2(63)

RCRAPP1

RCRAPP1_ZIP

PREPARER_EIN Preparer's employee identification number. VARCHAR2(63)

RCRAPP3

RCRAPP3_PREPARER_EIN

PREPARER_SIGNATURE_IND Indicates whether or not the preparer's signature is on the application. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_PREPARER_SIGN)

PREPARER_TAX_ID Preparer's tax identification number. VARCHAR2(63)

RCRAPP3

RCRAPP3_PREPARER_SSN

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

REJECTION_OVERRIDE20_IND Set by electronic application user to override reject 20: Non-tax filer reported income is above the IRS filing requirement. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_20

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

RCRAPP3

RCRAPP3_REJECT_OVRD_21

REJECTION_OVERRIDE2_IND Set to 'Y' by the electronic application user to override rejection 2: Independent student status in question because of student's age. No longer used. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_2

REJECTION_OVERRIDE3_IND Set to 'Y' by the electronic application user to override rejection 3: Student's taxes paid are greater than zero and equal to or greater than AGI. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_3

REJECTION_OVERRIDE4_IND Set by electronic application user to override reject 4: Student's marital status date greater than date application was signed. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_4

REJECTION_OVERRIDE5_IND Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank. No longer used. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_5

REJECTION_OVERRIDE7_IND Set to 'Y' by the electronic application user to override rejection 7: Unusually large number of family members. No longer used. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_7

REJECTION_OVERRIDE_B_IND Indicates if Reject B override accepted - Independent status in question because of student's age. VARCHAR2(63)

RCRAPP3

RCRAPP3

RCRAPP3_REJECT_OVRD_1

RCRAPP3_REJECT_OVRD_B

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

RCRAPP3

RCRAPP3_REJECT_OVRD_N

REJECTION_OVERRIDE_W_IND Set by electronic application user to override reject W: Questionable number of family members, greater than 15. VARCHAR2(63)

RCRAPP3

RCRAPP3_REJECT_OVRD_W

REQUESTED_AID_FALL Indicates if the student requested aid for the fall term. No longer populated after aid year ending in 2014. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_FALL_THIS_YR

REQUESTED_AID_FALL_DESC Requested aid for the fall description. No longer populated after aid year ending in 2014. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

REQUESTED_AID_NEXT_SUMMER Indicates if the student requested aid for the summer term following the normal school year. No longer populated after aid year ending in 2014. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_SUMMER_NEXT_YR

REQUESTED_AID_NEXT_SUMMER_DESC Requested aid for the next summer description. No longer populated after aid year ending in 2014. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

REQUESTED_AID_PRECEDING_SUMMER Indicates if the student requested aid for the summer term that preceded the normal school year. No longer populated after aid year ending in 2014. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_SUMMER_THIS_YR

REQUESTED_AID_PREC_SUMMER_DESC Requested aid for the preceding summer description. No longer populated after aid year ending in 2014. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

REQUESTED_AID_SPRING Indicates if the student requested aid for the spring term. No longer populated after aid year ending in 2014. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_SPRING_NEXT_YR

REQUESTED_AID_SPRING_DESC Requested aid for the spring description. No longer populated after aid year ending in 2014. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

REQUESTED_AID_WINTER Indicates if the student requested aid for the winter term. No longer populated after aid year ending in 2014. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_WINTER_NEXT_YR

REQUESTED_AID_WINTER_DESC Requested aid for the winter description. No longer populated after aid year ending in 2014. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

REVISION_COMPUTE_DATE Date that the processor processed a revised report for the applicant. DATE

RCRAPP1

RCRAPP1_REV_COMP_DATE

SAR_C_IND Eligibility status message that is the result of data base matches indicating further investigation by the aid administrator needed. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP2_ELIGIBILITY_MSG)

SECONDARY_SCHL_STATE_PROV_DESC State/Province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

SECONDARY_SCHOOL Secondary school code. VARCHAR2(63)

RCRAPP4

RCRAPP4_HIGH_SCH_CDE

SECONDARY_SCHOOL_CITY City in which the student attended secondary school. VARCHAR2(255)

RCRAPP4

RCRAPP4_HIGH_SCHOOL_CITY

SECONDARY_SCHOOL_DIPLOMA_IND Indicates if the person has received a high school diploma/GED. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_HS_GED_RCVD)

SECONDARY_SCHOOL_INVALID Indicates whether reported high school was not found in the file of valid high schools. VARCHAR2(63)

RCRAPP4

RCRAPP4_HIGH_SCHOOL_FLG

SECONDARY_SCHOOL_INVALID_DESC Secondary school invalid flag description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

SECONDARY_SCHOOL_NAME Name of the secondary school attended by the student. VARCHAR2(255)

RCRAPP4

RCRAPP4_HIGH_SCHOOL_NAME

SECONDARY_SCHOOL_STATE_PROV State/Province code in which the student attended secondary school. VARCHAR2(63)

RCRAPP4

RCRAPP4_STAT_CODE_HIGH_SCH

SELECTED_FOR_VERIFICATION_IND Indicates whether or not the student has been selected for verification by the Federal Government or by the institution. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP1_VERIFICATION_MSG)

SIGNATURE_IND Indicates whether or not a student's signature is on the application. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_C_SIGNED)

SIMPLIFIED_NEEDS_TEST_IND Indicates whether the Simplified Needs Test conditions have been met. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP2_PELL_ANLY_TYPE)

SPECIAL_CIRCUMSTANCE Indicates type of special circumstance performed. VARCHAR2(63)

RCRAPP3

RCRAPP3_SPEC_CIRCUM_FLAG

SPECIAL_CIRCUMSTANCE_DESC Special circumstance description VARCHAR2(255)

RORMVAL

RORMVAL_DESC

SPOUSE_SIGNATURE_IND Indicates whether or not a spouse's signature is on the application. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_SPS)

START_RESIDENCE_DATE Date the student began living in his/her state or province of legal residence in MMYY format. VARCHAR2(63)

RCRAPP1

RCRAPP1_START_RES_MTH_YR

STATE_OF_RESIDENCE Student's state or province of legal residence. VARCHAR2(63)

RCRAPP1

RCRAPP1_STAT_CODE_RES

STATE_OF_RESIDENCE_DESC Name of the student's state or province of legal residence. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STATE_PROVINCE State or province associated with the student's address. VARCHAR2(63)

RCRAPP1

RCRAPP1_STAT_CODE

STATE_PROVINCE_DESC State or province name associated with the student's address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STREET Student's number and street for their address as reported on their aid application. VARCHAR2(255)

RCRAPP1

RCRAPP1_ADDR

SUBSEQUENT_RECORD_SELECTED_VER Subsequent record selected for verification. VARCHAR2(63)

RCRAPP4

RCRAPP4_SUB_VERIF_SELECTED

TAX_ID Student's tax identification number assigned by their home federal government as reported on the aid application. VARCHAR2(63)

RCRAPP1

RCRAPP1_SSN

TAX_ID_MATCH_STATUS Tax ID match status. VARCHAR2(63)

RCRAPP3

RCRAPP3_SOC_SEC

TAX_ID_MATCH_STATUS_DESC Tax ID match status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

UNACCOMPANIED_YOUTH_HUD Indicates whether student is an unaccompanied youth determined by HUD. VARCHAR2(63)

RCRAPP1

RCRAPP1_UNACCOMP_YOUTH_HUD

UNACCOMPANIED_YOUTH_HUD_DESC Unaccompanied youth HUD indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

UNACCOMPANIED_YOUTH_SCHL_DESC Unaccompanied youth school indicator description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

UNACCOMPANIED_YOUTH_SCHOOL Indicates whether student is an unaccompanied youth determined by a school district liaison. VARCHAR2(63)

RCRAPP1

RCRAPP1_UNACCOMP_YOUTH_SCHOOL

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

RCRAPP1

RCRAPP1_USER_ID

VERIFICATION_NUMBER Government verification number. VARCHAR2(63)

RCRAPP4

RCRAPP4_VERIF_NUM

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

RCRAPP1

RCRAPP1_VERIFICATION_PRTY

VETERAN_IND Indicates if the student is a veteran of the Armed Forces. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP1_US_VET)

VETERAN_MATCH_STATUS Indicates the value of the Veteran's Administration federal database match flag. VARCHAR2(63)

RCRAPP4

RCRAPP4_VA_MATCH_FLAG

VETERAN_MATCH_STATUS_DESC Veteran match status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

VISA_CLASSIFICATION Indicates what a students VISA classification is, see CSS tape layout for valid values. VARCHAR2(63)

RCRAPP4

RCRAPP4_VISA_CLASS

VISA_CLASSIFICATION_DESC Visa classification description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

WARD_OF_COURT Indicates whether the student reported is a ward of the court or is an orphan. VARCHAR2(63)

RCRAPP1

RCRAPP1_WARD_OF_COURT

WARD_OF_COURT_DESC Ward of court indicator description VARCHAR2(255)

RORMVAL

RORMVAL_DESC



Ver: 8.5