Go To View:  RETURN TO REPORTING VIEW 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)

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

CALCULATION

DECODE(RCRAPP4_DRUG_OFFENSE_CONVIC)

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 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: Parent's Number of College assumed to be 1. 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

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)

CALCULATION

DECODE(RCRAPP1_CITZ_IND)

CITIZENSHIP_TYPE Student citizenship type. VARCHAR2(63)

RCRAPP4

RCRAPP4_SSA_CITIZEN_IND

CITIZENSHIP_TYPE_DESC Student citizenship type description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_SSA_CITIZEN_IND)

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

RCRAPP1

RCRAPP1_CITY

COLLEGE College code identifying the school to which this financial aid applicant record has applied. VARCHAR2(63)

RCRAPP1

RCRAPP1_COLL_CDE

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)

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

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

RCRAPP4

RCRAPP4_EMAIL_ADDRESS

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

FATHER_BIRTH_DATE Father's/Stepfather's date of birth. DATE

RCRAPP4

RCRAPP4_FATH_BIRTH_DATE

FATHER_LAST_NAME Father'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. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_FATH)

FATHER_TAX_ID Father's tax id. VARCHAR2(63)

RCRAPP4

RCRAPP4_FATH_SSN

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

RCRAPP3

RCRAPP3_FATH_SSN_MATCH

FATHER_TAX_ID_MATCH_DESC Father Tax ID match description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP3_FATH_SSN_MATCH)

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)

CALCULATION

DECODE(RCRAPP1_INST_HOUS_CDE)`

ID Person's or organization's current identification number. 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

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_RESIDENT_IND Indicates whether the student was a legal resident before January 1, YYYY. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_LEGAL_RES_IND)

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)

CALCULATION

DECODE(RCRAPP1_MRTL_STATUS)

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)

CALCULATION

DECODE(RCRAPP4_SS_MATCH)

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)

CALCULATION

DECODE(RCRAPP4_SS_REG_FLAG)

MOTHER_BIRTH_DATE Mother's/Stepmother's date of birth. DATE

RCRAPP4

RCRAPP4_MOTH_BIRTH_DATE

MOTHER_LAST_NAME Mother'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. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_MOTH)

MOTHER_TAX_ID Mother's tax id. VARCHAR2(63)

RCRAPP4

RCRAPP4_MOTH_SSN

MOTHER_TAX_ID_MATCH Mother's/Stepmother's Tax ID match fag. VARCHAR2(63)

RCRAPP3

RCRAPP3_MOTH_SSN_MATCH

MOTHER_TAX_ID_MATCH_DESC Mother Tax ID match description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP3_MOTH_SSN_MATCH)

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)

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

RCRIMP1

RCRIMP1_CITZ_COUNTRY

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

CALCULATION

DECODE(RCRAPP1_PAR_MRTL_STATUS)

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

RCRAPP2

RCRAPP2_C_PAR_PAR_IN_COLL

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

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)

CALCULATION

DECODE(RCRAPP4_SEC_INS_MATCH_IND)

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_OVERRIDE2_IND Set to 'Y' by the electronic application user to override rejection 2: Independent student status in question because of student's age. 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_OVERRIDE5_IND Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank. 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. 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_REJECT_OVRD_1

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

RCRAPP3

RCRAPP3_REJECT_OVRD_4

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_6

REQUESTED_AID_FALL Indicates if the student requested aid for the fall term. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_FALL_THIS_YR

REQUESTED_AID_FALL_DESC Requested aid for the fall description.  

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

RCRAPP1

RCRAPP1_RQST_FA_SUMMER_NEXT_YR

REQUESTED_AID_NEXT_SUMMER_DESC Requested aid for the next summer description.  

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

RCRAPP1

RCRAPP1_RQST_FA_SUMMER_THIS_YR

REQUESTED_AID_PREC_SUMMER_DESC Requested aid for the preceding summer description.  

CALCULATION

DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)

REQUESTED_AID_SPRING Indicates if the student requested aid for the spring term. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_SPRING_NEXT_YR

REQUESTED_AID_SPRING_DESC Requested aid for the spring description.  

CALCULATION

DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)

REQUESTED_AID_WINTER Indicates if the student requested aid for the winter term. VARCHAR2(63)

RCRAPP1

RCRAPP1_RQST_FA_WINTER_NEXT_YR

REQUESTED_AID_WINTER_DESC Requested aid for the winter description.  

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

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_SCHOOL_DIPLOMA_IND Indicates if the person has received a high school diploma/GED. VARCHAR2(63)

CALCULATION

DECODE(RCRAPP4_HS_GED_RCVD)

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)

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

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)

CALCULATION

DECODE(RCRAPP3_SOC_SEC)

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

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)

CALCULATION

DECODE(RCRAPP4_VA_MATCH_FLAG)

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)

CALCULATION

DECODE(RCRAPP4_VISA_CLASS)



Ver: 8.0