Target Column |
Business Name |
Business Definition |
Database Data Type |
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
|
ACTIVE_DUTY_IND
|
Active Duty Indicator
|
Indicates whether applicant is on active duty in the military.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP1_ACTIVE_DUTY,'1','Y','N')
|
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
|
Administrative-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
|
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 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_CREATOR_ID
|
Application Creator ID
|
The ID of the person who created this application record on the database, either manually or through dataload part 1.
|
VARCHAR2(30)
|
RCRAPP1
|
RCRAPP1_CREATOR_ID
|
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_HOMELESS_IND
|
At Risk Homeless Indicator
|
Indicates whether student is at risk of being homeless.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP1_AT_RISK_HOMELESS,'1', 'Y','N')
|
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
|
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
|
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
|
EMANCIPATED_MINOR_IND
|
Emancipated Minor Indicator
|
Indicates whether student is an emancipated minor.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP1_EMANCIPATED_MINOR,'1', 'Y','N')
|
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_FIRST_INITIAL
|
Father First Initial
|
Father's/Stepfather's first name/initial.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_FATH_FIRST_NAME_INI
|
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
|
Student's first name as reported on the aid application.
|
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
|
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 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_AGI_FLAG
|
Irs Agi Flag
|
Indicates whether IRS Adjusted Gross Income data for the student was transferred to the FAFSA.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_IRS_AGI_FLAG
|
IRS_AGI_FLAG_DESC
|
Irs Agi Flag Desc
|
IRS Adjusted Gross Income data for the student was transferred to the FAFSA indicator description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
IRS_FIT_FLAG
|
Irs Fit Flag
|
Indicates whether IRS Federal Income Tax data for the student was transferred to the FAFSA
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_IRS_FIT_FLAG
|
IRS_FIT_FLAG_DESC
|
Irs Fit Flag Desc
|
IRS Federal Income Tax data for the student was transferred to the FAFSA indicator description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
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
|
Student's last name as reported on the aid application.
|
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_GUARDIAN_IND
|
Legal Guardian Indicator
|
Indicates whether student is in legal guardianship.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP1_LEGAL_GUARDIAN,'1', 'Y','N')
|
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_ACTIVE_DUTY
|
Military Active Duty
|
Indicates whether applicant is on active duty in the military.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_ACTIVE_DUTY
|
MILITARY_ACTIVE_DUTY_DESC
|
Military Active Duty Description
|
Military active duty indicator description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
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
|
MOTHER_BIRTH_DATE
|
Parent 2 Birth Date
|
Father's/Mother's/Stepparent's date of birth.
|
DATE
|
RCRAPP4
|
RCRAPP4_MOTH_BIRTH_DATE
|
MOTHER_FIRST_INITIAL
|
Mother First Initial
|
Mother's/Stepmother's first name initial.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_MOTH_FIRST_NAME_INI
|
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
|
Student's title. (Mr. or Ms.).
|
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
|
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 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_AGI_FLAG
|
Parent Irs Agi Flag
|
Indicates whether IRS Adjusted Gross Income data for the parent was transferred to the FAFSA.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_PAR_IRS_AGI_FLAG
|
PARENT_IRS_AGI_FLAG_DESC
|
Parent Irs Agi Flag Desc
|
IRS Adjusted Gross Income data for the parent was transferred to the FAFSA indicator description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
PARENT_IRS_FIT_FLAG
|
Parent Irs Fit Flag
|
Indicates whether IRS Federal Income Tax data for the parent was transferred to the FAFSA.
|
VARCHAR2(63)
|
RCRAPP3
|
RCRAPP3_PAR_IRS_FIT_FLAG
|
PARENT_IRS_FIT_FLAG_DESC
|
Parent Irs Fit Flag Desc
|
IRS Federal Income Tax data for the parent was transferred to the FAFSA indicator description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
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, unique, internal identification number assigned to this person.
|
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
|
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
|
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_HUD_IND
|
Unaccompanied Youth Hud Indicator
|
Indicates whether student is an unaccompanied youth determined by HUD.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP1_UNACCOMP_YOUTH_HUD,'1', 'Y','N')
|
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
|
UNACCOMPANIED_YOUTH_SCHOOL_IND
|
Unaccompanied Youth School Indicator
|
Indicates whether student is an unaccompanied youth determined by a school district liaison.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP1_UNACCOMP_YOUTH_SCHOOL,'1', 'Y','N')
|
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
|
VERIFICATION_PRIORITY_DESC
|
Verification Priority Description
|
Description of the priority of the edits used to select the student for data verification.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
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
|
WARD_OF_COURT_IND
|
Ward Of Court Indicator
|
Indicates if the student reported being a ward of the court or is an orphan.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE (RCRAPP1_WARD_OF_COURT, '1', 'Y', 'N')
|