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
AID_YEAR, PERSON_UID, CURRENT_RECORD_IND

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_YEAR 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 Activity Date Date record was inserted or updated DATE  

RCRAPP1

RCRAPP1_ACTIVITY_DATE

ADDRESS_CHANGE Address Change Address Only Change Flag VARCHAR2(63)  

RCRAPP4

RCRAPP4_ADDRESS_CHG_FLAG

ADDRESS_CHANGE_DESC Address Change Description Address Only Change Flag description. VARCHAR2(255)  

CALCULATION

DECODE(RCRAPP4_ADDRESS_CHG_FLAG)

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

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

NA

NA

AGE_OLDER_PARENT Age Older Parent Age of the older parent. NUMBER  

RCRAPP1

RCRAPP1_PAR_OLDER_AGE

AID_ELIGIBILITY_RESPONSE Financial Aid Eligibility Response Drug Offense Conviction indicated. VARCHAR2(63)  

RCRAPP4

RCRAPP4_DRUG_OFFENSE_CONVIC

AID_ELIGIBILITY_RESPONSE_DESC Financial Aid Eligibility Response Description Aid eligibility response description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

AID_YEAR Financial Aid Year Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)  

RCRAPP1

RCRAPP1_AIDY_CODE

AID_YEAR_DESC Financial Aid Year Description Financial aid year name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ALIEN_REGISTRATION_NUMBER 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 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 Application Number Financial aid application unique sequence number. NUMBER  

RCRAPP1

RCRAPP1_SEQ_NO

APPLICATION_RECEIPT_DATE Application Receipt Date Date that the processor received the aid application. DATE  

RCRAPP1

RCRAPP1_RCPT_DATE

APPLICATION_REVISION_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 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 By Description Application signed description. VARCHAR2(255)  

CALCULATION

DECODE(RCRAPP1_SIGNED)

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

RCRIMP1

RCRIMP1_APPLIC_TYPE

APPLICATION_TYPE_DESC Application Type Description Application type description. VARCHAR2(255)  

CALCULATION

DECODE(RCRIMP1_APPLIC_TYPE)

ASSUMPTION_OVERRIDE1_IND Assumption Override 1 Indicator 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 Assumption Override 2 Indicator 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 Assumption Override 3 Indicator 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 Assumption Override 4 Indicator 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 Assumption Override 5 Indicator 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 Assumption Override 6 Indicator 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 Assumption Override 7 Indicator 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 Assumption Override 8 Indicator 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 Assumption Override 9 Indicator 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 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 Description At risk of homelessness indicator description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

BIRTH_DATE Birth Date Student's date of birth. DATE  

RCRAPP1

RCRAPP1_BIRTH_DATE

CITIZENSHIP_ELIGIBILITY_TYPE 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 Citizenship Eligibil Type Description Citizen type description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

CITIZENSHIP_TYPE Citizenship Type Student citizenship type. VARCHAR2(63)  

RCRAPP4

RCRAPP4_SSA_CITIZEN_IND

CITIZENSHIP_TYPE_DESC Citizenship Type Description Student citizenship type description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

RCRAPP1

RCRAPP1_CITY

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

CORRECTION_SOURCE Correction Source Source of the correction. VARCHAR2(63)  

RCRAPP4

RCRAPP4_SOURCE_CORRECTION

CORRECTION_SOURCE_DESC Correction Source Description Correction source description VARCHAR2(255)  

CALCULATION

DECODE(RCRAPP4_SOURCE_CORRECTION)

CPS_ISIR_PUSHED_IND Cps Isir Pushed Indicator CPS pushed ISIR flag. VARCHAR2(63)  

CALCULATION

NVL(RCRAPP4_PUSH_ISIR_FLAG)

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

RCRAPP1

RCRAPP1_CURR_REC_IND

DATE_APPLICATION_COMPLETED Date Application Completed Date the application was completed. DATE  

RCRAPP1

RCRAPP1_COMPLETION_DATE

DEATH_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 Degree By July Indicator 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 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)  

CALCULATION

DECODE(RCRAPP3_DEGREE_TYPE)

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

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

RCRAPP4

RCRAPP4_DOD_MATCH_FLAG

DOD_MATCH_DESC Dod Match Description Department Of Defense match flag. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

DOD_PARENT_DEATH_DATE Dod Parent Death Date Date the parent of the applicant died. DATE  

RCRAPP4

RCRAPP4_DOD_PAR_DEATH_DATE

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)  

FUNCTION

GOKODSF.F_GET_DESC

DUPLICATE_TAX_ID_IND Duplicate Tax ID Indicator 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 Effective Family Contribution Change Indicator EFC change flag indicates whether the EFC has increased or decreased. VARCHAR2(63)  

RCRAPP4

RCRAPP4_EFC_CHANGE_IND

EFC_CHANGE_FLAG_DESC Effective Family Contribution Change Indicator Description EFC change flag description. VARCHAR2(255)  

CALCULATION

DECODE(RCRAPP4_EFC_CHANGE_IND)

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

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

RCRAPP1

RCRAPP1_EMANCIPATED_MINOR

EMANCIPATED_MINOR_DESC Emancipated Minor Description Emancipated minor indicator description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

ENROLLMENT_PLANNING_SERVICE 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 Enrollment Planning Serv Description 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 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_BIRTH_DATE Parent 1 Birth Date Father's/Mother's/Stepparent's date of birth. DATE  

RCRAPP4

RCRAPP4_FATH_BIRTH_DATE

FATHER_LAST_NAME Parent 1 Last Name Father's/Mother's/Stepparent's last name. VARCHAR2(63)  

RCRAPP4

RCRAPP4_FATH_LAST_NAME

FATHER_SIGNATURE_IND Father Signature Indicator 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 Parent 1 Tax ID Father's/Mother's/Stepparent's tax id. VARCHAR2(63)  

RCRAPP4

RCRAPP4_FATH_SSN

FATHER_TAX_ID_MATCH Parent 1 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 Parent 1 Tax ID match description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

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

RCRIMP1

RCRIMP1_FIN_AID_STATUS

FINANCIAL_AID_STATUS_DESC Financial Financial Aid Status Description Financial aid status description. VARCHAR2(255)  

CALCULATION

DECODE(RCRIMP1_AID_STATUS)

FIRST_NAME First Name The first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(63)  

RCRAPP1

RCRAPP1_FIRST_NAME

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

CALCULATION

DECODE(RCRIMP1_FOREIGN_ADDR_IND)

FOREIGN_COUNTRY 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 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 Graduate Professional Indicator Indicates whether or not a student is a graduate or professional student. VARCHAR2(63)  

CALCULATION

DECODE(RCRAPP3_GRAD_OR_PROF)

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

RORMVAL

RORMVAL_DESC

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

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

INTERNATIONAL_PHONE_NUMBER 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 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

LAST_NAME Last Name The last name by which a person is known. VARCHAR2(63)  

RCRAPP1

RCRAPP1_LAST_NAME

LEGAL_DEPENDENT_IND Legal Dependent Indicator 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 Legal Guardianship Indicates whether student is in legal guardianship. VARCHAR2(63)  

RCRAPP1

RCRAPP1_LEGAL_GUARDIAN

LEGAL_GUARDIANSHIP_DESC Legal Guardianship Description Legal guardian indicator description VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

CALCULATION

DECODE(RCRAPP4_LEGAL_RES_IND)

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

RCRAPP1

RCRAPP1_MAIL_CITY

MAILING_NATION 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 Mailing Nation Description Nation/country code description. VARCHAR2(255)  

STVNATN

STVNATN_NATN

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

RCRAPP1

RCRAPP1_MAIL_POSTAL_CDE

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

RCRAPP1

RCRAPP1_MAIL_STAT_CODE

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

STVSTAT

STVSTAT_DESC

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

RCRAPP1

RCRAPP1_MAIL_ADDR

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

RCRAPP1

RCRAPP1_MRTL_STATUS

MARITAL_STATUS_DATE 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 Marital status description associated with the student. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

RCRAPP1

RCRAPP1_MI

MILITARY_REGISTRATION_STATUS Military Registration Status Military registration match flag. VARCHAR2(63)  

RCRAPP4

RCRAPP4_SS_MATCH

MILITARY_REGIST_STATUS_DESC Military Regist Status Description Military registration match description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

MILITARY_REG_REQ_STATUS Military Registration Requirements 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 Military Registration Requirements Status Description Student military registration request status description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

RCRAPP1

RCRAPP1_ACTIVE_DUTY

MILTARY_ACTIVE_DUTY_DESC Miltary Active Duty Description Military active duty indicator description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

MOTHER_BIRTH_DATE Parent 2 Birth Date Father's/Mother's/Stepparent's date of birth. DATE  

RCRAPP4

RCRAPP4_MOTH_BIRTH_DATE

MOTHER_LAST_NAME Parent 2 Last Name Father's/Mother's/Stepparent's last name. VARCHAR2(63)  

RCRAPP4

RCRAPP4_MOTH_LAST_NAME

MOTHER_SIGNATURE_IND Mother Signature Indicator 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 Parent 2 Tax ID Father's/Mother's/Stepparent's tax id. VARCHAR2(63)  

RCRAPP4

RCRAPP4_MOTH_SSN

MOTHER_TAX_ID_MATCH Parent 2 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 Parent 2 Tax ID match description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

NAME_PREFIX Name Prefix An appellation used to connote rank, placement or status. A title that precedes person name. VARCHAR2(63)  

CALCULATION

DECODE(RCRAPP1_TITLE)

NATIONAL_STUDENT_LOAN_SYSTEM 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 National student loan system description. VARCHAR2(255)  

CALCULATION

DECODE(RCRAPP4_NSLDS_MATCH)

NATION_OF_CITIZENSHIP Nation Of Citizenship The student's country of citizenship. VARCHAR2(63)  

RCRIMP1

RCRIMP1_CITZ_COUNTRY

NUMBER_OF_EXEMPTIONS 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 Source Indicator Official or unofficial indicator. VARCHAR2(63)  

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

OLDER_THAN_24_IND Older Than 24 Indicator 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 Original Compute Date Date that the application was originally processed by the processor. DATE  

RCRAPP1

RCRAPP1_ORIG_COMP_DATE

OTHERS_NUMBER_IN_COLLEGE 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 Parent Divorce Year Year of parents' divorce. VARCHAR2(63)  

RCRIMP1

RCRIMP1_PAR_YR_DIV

PARENT_EMAIL_ADDRESS Parent Email Address Parent's Email Address. VARCHAR2(255)  

RCRAPP4

RCRAPP4_P_EMAIL_ADDRESS

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_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_LEGAL_RESIDENT_IND Parent Legal Resident Indicator Indicates whether the parent was a legal resident before January 1, YYYY. VARCHAR2(63)  

CALCULATION

DECODE(RCRAPP4_PAR_LEGAL_RES_IND)

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

RCRAPP1

RCRAPP1_PAR_MRTL_STATUS

PARENT_MARITAL_STATUS_DATE 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 Parent Marital Status Description Parents marital status description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

PARENT_NATION_OF_RESIDENCE 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 Residence Description Parent nation/country of residence description. VARCHAR2(255)  

STVNATN

STVNATN_NATN

PARENT_NUMBER_IN_COLLEGE 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 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 Parent Remarriage Date Date parent remarried. DATE  

RCRAPP1

RCRAPP1_PAR_REMARRIAGE_DATE

PARENT_SEPARATION_YEAR Parent Separation Year Year of parents' separation. VARCHAR2(63)  

RCRIMP1

RCRIMP1_PAR_YR_SEP

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 state or province of legal residence description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

RCRAPP4

RCRAPP4_PARENT_TYPE_1

PARENT_TYPE1_DESC Parent Type 1 Description Parent type 1 description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

RCRAPP4

RCRAPP4_PARENT_TYPE_2

PARENT_TYPE2_DESC Parent Type 2 Description Parent type 2 description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

PERMIT_DRAFT_REGISTRATION_IND Permit Draft Registration Indicator 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 Perm Residency Confirmed Indicator 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 Perm Residency Ver Status Permanent residency verification status. VARCHAR2(63)  

RCRAPP4

RCRAPP4_SEC_INS_MATCH_IND

PERM_RESIDENCY_VER_STATUS_DESC Perm Residency Ver Status Description Permanent residency verification status description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

PERSON_UID Person UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER  

RCRAPP1

RCRAPP1_PIDM

PHONE_AREA Phone Area Area code of the student's home telephone number. VARCHAR2(63)  

RCRAPP1

RCRAPP1_PHONE_AREA

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

RCRAPP1

RCRAPP1_PHONE_NO

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

RCRAPP1

RCRAPP1_ZIP

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

RCRAPP3

RCRAPP3_PREPARER_EIN

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

CALCULATION

DECODE(RCRAPP3_PREPARER_SIGN)

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

RCRAPP3

RCRAPP3_PREPARER_SSN

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

REQUESTED_AID_FALL Requested Financial 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 Financial Aid Fall Description Requested aid for the fall description. No longer populated after aid year ending in 2014. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

REQUESTED_AID_NEXT_SUMMER Requested Financial 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 Financial Aid Next Summer Description 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 Requested Financial 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 Financial Aid Prec Summer Description Requested aid for the preceding summer description. No longer populated after aid year ending in 2014. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

REQUESTED_AID_SPRING Requested Financial 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 Financial Aid Spring Description Requested aid for the spring description. No longer populated after aid year ending in 2014. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

REQUESTED_AID_WINTER Requested Financial 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 Financial Aid Winter Description Requested aid for the winter description. No longer populated after aid year ending in 2014. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

RCRAPP1

RCRAPP1_REV_COMP_DATE

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)

SECONDARY_SCHL_STATE_PROV_DESC Secondary Schl State Province Description State/Province name. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

SECONDARY_SCHOOL Secondary School Secondary school code. VARCHAR2(63)  

RCRAPP4

RCRAPP4_HIGH_SCH_CDE

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

RCRAPP4

RCRAPP4_HIGH_SCHOOL_CITY

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

CALCULATION

DECODE(RCRAPP4_HS_GED_RCVD)

SECONDARY_SCHOOL_INVALID 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 Description Secondary school invalid flag description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

RCRAPP4

RCRAPP4_HIGH_SCHOOL_NAME

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

RCRAPP4

RCRAPP4_STAT_CODE_HIGH_SCH

SELECTED_FOR_VERIFICATION_IND Selected For Verification Indicator 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 Signature Indicator Indicates whether or not a student's signature is on the application. VARCHAR2(63)  

CALCULATION

DECODE(RCRAPP3_C_SIGNED)

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

CALCULATION

DECODE(RCRAPP2_PELL_ANLY_TYPE)

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

RCRAPP3

RCRAPP3_SPEC_CIRCUM_FLAG

SPECIAL_CIRCUMSTANCE_DESC Special Circumstance Description Special circumstance description VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

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

CALCULATION

DECODE(RCRAPP3_C_SIGNED_SPS)

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

RCRAPP1

RCRAPP1_STAT_CODE_RES

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRAPP1

RCRAPP1_STAT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

STREET 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 Ver Subsequent record selected for verification. VARCHAR2(63)  

RCRAPP4

RCRAPP4_SUB_VERIF_SELECTED

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

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

UNACCOMPANIED_YOUTH_HUD 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 Description Unaccompanied youth HUD indicator description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

UNACCOMPANIED_YOUTH_SCHL_DESC Unaccompanied Youth Schl Description Unaccompanied youth school indicator description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

UNACCOMPANIED_YOUTH_SCHOOL 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 User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)  

RCRAPP1

RCRAPP1_USER_ID

VERIFICATION_NUMBER Verification Number Government verification number. VARCHAR2(63)  

RCRAPP4

RCRAPP4_VERIF_NUM

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

CALCULATION

DECODE(RCRAPP1_US_VET)

VETERAN_MATCH_STATUS 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 Veteran match status description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

VISA_CLASSIFICATION 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 Visa classification description. VARCHAR2(255)  

RORMVAL

RORMVAL_DESC

WARD_OF_COURT 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 Description Ward of court indicator description VARCHAR2(255)  

RORMVAL

RORMVAL_DESC



Ver: 9.0