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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_YEAR The last two digits of the first year for the academic year being processed. EXAMPLE: '90' for the 1990-91 academic year.    

RCRAPP1

RCRAPP1_ACYR_CODE

 
ACTIVITY_DATE Date record was inserted or updated    

RCRAPP1

RCRAPP1_ACTIVITY_DATE

 
ADDRESS_CHANGE Address Only Change Flag    

RCRAPP4

RCRAPP4_ADDRESS_CHG_FLAG

 
ADDRESS_CHANGE_DESC Address Only Change Flag description.    

CALCULATION

DECODE(RCRAPP4_ADDRESS_CHG_FLAG)

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
AGE_OLDER_PARENT Age of the older parent.    

RCRAPP1

RCRAPP1_PAR_OLDER_AGE

 
AID_ELIGIBILITY_RESPONSE Drug Offense Conviction indicated.    

RCRAPP4

RCRAPP4_DRUG_OFFENSE_CONVIC

 
AID_ELIGIBILITY_RESPONSE_DESC Aid eligibility response description.    

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

RCRAPP1

RCRAPP1_AIDY_CODE

 
AID_YEAR_DESC Financial aid year name.    

FUNCTION

GOKODSF.F_GET_DESC

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

RCRAPP1

RCRAPP1_ALIEN_REG_NO

 
APPLICATION_CREATE_DATE The date that this application record was created on the database, either manually or through dataload.    

RCRAPP2

RCRAPP1_CREATE_DATE

 
APPLICATION_NUMBER Financial aid application unique sequence number.    

RCRAPP1

RCRAPP1_SEQ_NO

 
APPLICATION_RECEIPT_DATE Date that the processor received the aid application.    

RCRAPP1

RCRAPP1_RCPT_DATE

 
APPLICATION_REVISION_RCPT_DATE Date that the processor received a request for revisions from the student.    

RCRAPP1

RCRAPP1_REV_RCPT_DATE

 
APPLICATION_SIGNED_BY Indicates if the application was signed by the student and/or the parent(s).    

CALCULATION

DECODE(RCRAPP1_SIGNED)

 
APPLICATION_SIGNED_BY_DESC Application signed description.    

CALCULATION

DECODE(RCRAPP1_SIGNED)

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

RCRIMP1

RCRIMP1_APPLIC_TYPE

 
APPLICATION_TYPE_DESC Application type description.    

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.    

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.    

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.    

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.    

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.    

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.    

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.    

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.    

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.    

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_9

 
BIRTH_DATE Student's date of birth.    

RCRAPP1

RCRAPP1_BIRTH_DATE

 
CITIZENSHIP_ELIGIBILITY_TYPE Identifies the person's citizen type relationship to the institution's home country.    

RCRAPP1

RCRAPP1_CITZ_IND

 
CITIZENSHIP_ELIGIBIL_TYPE_DESC Citizen type description.    

CALCULATION

DECODE(RCRAPP1_CITZ_IND)

 
CITIZENSHIP_TYPE Student citizenship type.    

RCRAPP4

RCRAPP4_SSA_CITIZEN_IND

 
CITIZENSHIP_TYPE_DESC Student citizenship type description.    

CALCULATION

DECODE(RCRAPP4_SSA_CITIZEN_IND)

 
CITY City of the student's address from the aid application.    

RCRAPP1

RCRAPP1_CITY

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

RCRAPP1

RCRAPP1_COLL_CDE

 
CURRENT_RECORD_IND Specifies that this is the current need analysis record.    

RCRAPP1

RCRAPP1_CURR_REC_IND

 
DATE_APPLICATION_COMPLETED Date the application was completed.    

RCRAPP1

RCRAPP1_COMPLETION_DATE

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

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.    

CALCULATION

DECODE(RCRAPP1_DEGREE_BY_JULY)

 
DEGREE_TYPE Contains the abbreviation of the degree or certificate a student is pursuing.    

RCRAPP3

RCRAPP3_DEGREE_TYPE

 
DEGREE_TYPE_DESC Degree type description.    

CALCULATION

DECODE(RCRAPP3_DEGREE_TYPE)

 
DEPENDENCY_OVERRIDE Used by the financial aid administrator to override dependency.    

RCRAPP3

RCRAPP3_FAA_DEP_OVERRIDE

 
DEPENDENCY_OVERRIDE_DESC Dependency override description.    

CALCULATION

DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)

 
DRIVER_LICENSE_NUMBER Student's drivers license number.    

RCRAPP1

RCRAPP1_DRIVER_LIC_NO

 
DRIVER_LICENSE_STATE_PROVINCE State or province that issued the student's drivers license.    

RCRAPP1

RCRAPP1_STAT_CODE_LIC

 
DRIVER_LICENSE_STATE_PROV_DESC Description of the state or province in which the student holds a drivers license.    

FUNCTION

GOKODSF.F_GET_DESC

 
EMAIL_ADDRESS Student's e-mail address as reported on PROFILE.    

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)    

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)    

STVEPSC

STVEPSC_DESC

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

RCRAPP4

RCRAPP4_FATH_BIRTH_DATE

 
FATHER_LAST_NAME Father's Last Name.    

RCRAPP4

RCRAPP4_FATH_LAST_NAME

 
FATHER_SIGNATURE_IND Indicates whether or not a father's signature is on the application.    

CALCULATION

DECODE(RCRAPP3_C_SIGNED_FATH)

 
FATHER_TAX_ID Father's tax id.    

RCRAPP4

RCRAPP4_FATH_SSN

 
FATHER_TAX_ID_MATCH Father's/Stepfather's Tax ID match flag.    

RCRAPP3

RCRAPP3_FATH_SSN_MATCH

 
FATHER_TAX_ID_MATCH_DESC Father Tax ID match description.    

CALCULATION

DECODE(RCRAPP3_FATH_SSN_MATCH)

 
FINANCIAL_AID_STATUS Indicates the student's financial aid status.    

RCRIMP1

RCRIMP1_FIN_AID_STATUS

 
FINANCIAL_AID_STATUS_DESC Financial aid status description.    

CALCULATION

DECODE(RCRIMP1_AID_STATUS)

 
FIRST_NAME Student's first name as reported on the aid application.    

RCRAPP1

RCRAPP1_FIRST_NAME

 
FOREIGN_ADDRESS_IND Indicates that the student lives outside the nation in which the institution is located.    

CALCULATION

DECODE(RCRIMP1_FOREIGN_ADDR_IND)

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

RCRIMP1

RCRIMP1_COUNTRY

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

RCRIMP1

RCRIMP1_FOREIGN_POSTAL_CDE

 
GRADUATE_PROFESSIONAL_IND Indicates whether or not a student is a graduate or professional student.    

CALCULATION

DECODE(RCRAPP3_GRAD_OR_PROF)

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

RCRAPP1

RCRAPP1_INST_HOUS_CDE

 
HOUSING_DESC Institutional housing code description.    

CALCULATION

DECODE(RCRAPP1_INST_HOUS_CDE)`

 
ID Person's or organization's current identification number.    

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

RCRAPP1

RCRAPP1_INFC_CODE

 
INTERFACE_TAPE_DESC Description of the interface tape code.    

RTVINFC

RTVINFC_DESC

 
LAST_NAME Student's last name as reported on the aid application.    

RCRAPP1

RCRAPP1_LAST_NAME

 
LEGAL_DEPENDENT_IND Indicates whether or not the student has legal dependents other than a spouse for determining dependency status.    

CALCULATION

DECODE(RCRAPP1_HAS_LEGAL_DEPEND)

 
LEGAL_RESIDENT_IND Indicates whether the student was a legal resident before January 1, YYYY.    

CALCULATION

DECODE(RCRAPP4_LEGAL_RES_IND)

 
MARITAL_STATUS Student's reported marital status.    

RCRAPP1

RCRAPP1_MRTL_STATUS

 
MARITAL_STATUS_DATE Month and year the student is married, widowed, separated, or divorced.    

RCRAPP3

RCRAPP3_S_MAR_MTH_YR

 
MARITAL_STATUS_DESC Marital status description associated with the student.    

CALCULATION

DECODE(RCRAPP1_MRTL_STATUS)

 
MIDDLE_INITIAL The student's middle initial as reported on the aid application.    

RCRAPP1

RCRAPP1_MI

 
MILITARY_REGISTRATION_STATUS Military registration match flag.    

RCRAPP4

RCRAPP4_SS_MATCH

 
MILITARY_REGIST_STATUS_DESC Military registration match description.    

CALCULATION

DECODE(RCRAPP4_SS_MATCH)

 
MILITARY_REG_REQ_STATUS Results from the student's request to be registered with the military service.    

RCRAPP4

RCRAPP4_SS_REG_FLAG

 
MILITARY_REG_REQ_STATUS_DESC Student military registration request status description.    

CALCULATION

DECODE(RCRAPP4_SS_REG_FLAG)

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

RCRAPP4

RCRAPP4_MOTH_BIRTH_DATE

 
MOTHER_LAST_NAME Mother's Last Name.    

RCRAPP4

RCRAPP4_MOTH_LAST_NAME

 
MOTHER_SIGNATURE_IND Indicates whether or not a mother's signature is on the application.    

CALCULATION

DECODE(RCRAPP3_C_SIGNED_MOTH)

 
MOTHER_TAX_ID Mother's tax id.    

RCRAPP4

RCRAPP4_MOTH_SSN

 
MOTHER_TAX_ID_MATCH Mother's/Stepmother's Tax ID match fag.    

RCRAPP3

RCRAPP3_MOTH_SSN_MATCH

 
MOTHER_TAX_ID_MATCH_DESC Mother Tax ID match description.    

CALCULATION

DECODE(RCRAPP3_MOTH_SSN_MATCH)

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

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

CALCULATION

DECODE(RCRAPP1_TITLE)

 
NATION_OF_CITIZENSHIP The student's country of citizenship.    

RCRIMP1

RCRIMP1_CITZ_COUNTRY

 
OFFICIAL_SOURCE_IND Official or unofficial indicator.    

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

 
OLDER_THAN_24_IND Indicates whether or not the student is older than 24 years old.    

CALCULATION

DECODE(RCRAPP1_BORN_BEFORE_1_1_XX)

 
ORIGINAL_COMPUTE_DATE Date that the application was originally processed by the processor.    

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.    

RCRAPP2

RCRAPP2_C_PAR_OTH_IN_COLL

 
PARENT_DIVORCE_YEAR Year of parents' divorce.    

RCRIMP1

RCRIMP1_PAR_YR_DIV

 
PARENT_EMAIL_ADDRESS Parent's Email Address.    

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.    

RCRAPP1

RCRAPP1_PAR_NO_IN_COLL

 
PARENT_FAMILY_SIZE Number of family members in the parents household.    

RCRAPP1

RCRAPP1_PAR_FAM_MEMB

 
PARENT_LEGAL_RESIDENT_IND Indicates whether the parent was a legal resident before January 1, YYYY.    

CALCULATION

DECODE(RCRAPP4_PAR_LEGAL_RES_IND)

 
PARENT_MARITAL_STATUS Marital status for the student's parents.    

RCRAPP1

RCRAPP1_PAR_MRTL_STATUS

 
PARENT_MARITAL_STATUS_DATE Month and year the parents were married, widowed, separated, or divorced.    

RCRAPP3

RCRAPP3_PAR_MAR_MTH_YR

 
PARENT_MARITAL_STATUS_DESC Parents marital status description.    

CALCULATION

DECODE(RCRAPP1_PAR_MRTL_STATUS)

 
PARENT_NUMBER_IN_COLLEGE Number in college that are parents of the student.    

RCRAPP2

RCRAPP2_C_PAR_PAR_IN_COLL

 
PARENT_REMARRIAGE_DATE Date parent remarried.    

RCRAPP1

RCRAPP1_PAR_REMARRIAGE_DATE

 
PARENT_SEPARATION_YEAR Year of parents' separation.    

RCRIMP1

RCRIMP1_PAR_YR_SEP

 
PARENT_STATE_OF_RESIDENCE State or province of legal residence for the student's parents.    

RCRAPP1

RCRAPP1_PAR_STAT_CODE_RES

 
PARENT_STATE_OF_RESIDENCE_DESC Parents state or province of legal residence description.    

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.    

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.    

CALCULATION

DECODE(RCRAPP1_INS)

 
PERM_RESIDENCY_VER_STATUS Permanent residency verification status.    

RCRAPP4

RCRAPP4_SEC_INS_MATCH_IND

 
PERM_RESIDENCY_VER_STATUS_DESC Permanent residency verification status description.    

CALCULATION

DECODE(RCRAPP4_SEC_INS_MATCH_IND)

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

RCRAPP1

RCRAPP1_PIDM

 
PHONE_AREA Area code of the student's home telephone number.    

RCRAPP1

RCRAPP1_PHONE_AREA

 
PHONE_NUMBER Student's home telephone number without area code.    

RCRAPP1

RCRAPP1_PHONE_NO

 
POSTAL_CODE Postal code for the student's address.    

RCRAPP1

RCRAPP1_ZIP

 
PREPARER_EIN Preparer's employee identification number.    

RCRAPP3

RCRAPP3_PREPARER_EIN

 
PREPARER_SIGNATURE_IND Indicates whether or not the preparer's signature is on the application.    

CALCULATION

DECODE(RCRAPP3_PREPARER_SIGN)

 
PREPARER_TAX_ID Preparer's tax identification number.    

RCRAPP3

RCRAPP3_PREPARER_SSN

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

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.    

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.    

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.    

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.    

RCRAPP3

RCRAPP3_REJECT_OVRD_7

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

RCRAPP3

RCRAPP3_REJECT_OVRD_1

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

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.    

RCRAPP3

RCRAPP3_REJECT_OVRD_6

 
REQUESTED_AID_FALL Indicates if the student requested aid for the fall term.    

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.    

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.    

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.    

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.    

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.    

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.    

CALCULATION

DECODE(RCRAPP2_ELIGIBILITY_MSG)

 
SECONDARY_SCHOOL_DIPLOMA_IND Indicates if the person has received a high school diploma/GED.    

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.    

CALCULATION

DECODE(RCRAPP1_VERIFICATION_MSG)

 
SIGNATURE_IND Indicates whether or not a student's signature is on the application.    

CALCULATION

DECODE(RCRAPP3_C_SIGNED)

 
SPOUSE_SIGNATURE_IND Indicates whether or not a spouse's signature is on the application.    

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.    

RCRAPP1

RCRAPP1_START_RES_MTH_YR

 
STATE_OF_RESIDENCE Student's state or province of legal residence.    

RCRAPP1

RCRAPP1_STAT_CODE_RES

 
STATE_OF_RESIDENCE_DESC Name of the student's state or province of legal residence.    

FUNCTION

GOKODSF.F_GET_DESC

 
STATE_PROVINCE State or province associated with the student's address.    

RCRAPP1

RCRAPP1_STAT_CODE

 
STATE_PROVINCE_DESC State or province name associated with the student's address.    

FUNCTION

GOKODSF.F_GET_DESC

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

RCRAPP1

RCRAPP1_ADDR

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

RCRAPP1

RCRAPP1_SSN

 
TAX_ID_MATCH_STATUS Tax ID match status.    

RCRAPP3

RCRAPP3_SOC_SEC

 
TAX_ID_MATCH_STATUS_DESC Tax ID match status description.    

CALCULATION

DECODE(RCRAPP3_SOC_SEC)

 
TRANSACTION_NUMBER The one up sequence number assigned by the Central Processing System to this application/correction record.    

RCRAPP1

RCRAPP1_USED_TRANS_NO

 
USER_ID Unique identification code of the user who entered or last touched the transaction.    

RCRAPP1

RCRAPP1_USER_ID

 
VERIFICATION_NUMBER Government verification number.    

RCRAPP4

RCRAPP4_VERIF_NUM

 
VERIFICATION_PRIORITY Indicates the priority of the edits used to select the student for data verification.    

RCRAPP1

RCRAPP1_VERIFICATION_PRTY

 
VETERAN_IND Indicates if the student is a veteran of the Armed Forces.    

CALCULATION

DECODE(RCRAPP1_US_VET)

 
VETERAN_MATCH_STATUS Indicates the value of the Veteran's Administration federal database match flag.    

RCRAPP4

RCRAPP4_VA_MATCH_FLAG

 
VETERAN_MATCH_STATUS_DESC Veteran match status description.    

CALCULATION

DECODE(RCRAPP4_VA_MATCH_FLAG)

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

RCRAPP4

RCRAPP4_VISA_CLASS

 
VISA_CLASSIFICATION_DESC Visa classification description.    

CALCULATION

DECODE(RCRAPP4_VISA_CLASS)

 


Ver: 8.3