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