Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_YEAR	The last two digits of the first year for the academic year being processed. EXAMPLE: '90' for the 1990-91 academic year.	VARCHAR2(63)	RCRAPP1	RCRAPP1_ACYR_CODE
ACTIVITY_DATE	Date record was inserted or updated	DATE	RCRAPP1	RCRAPP1_ACTIVITY_DATE
ADDRESS_CHANGE	Address Only Change Flag	VARCHAR2(63)	RCRAPP4	RCRAPP4_ADDRESS_CHG_FLAG
ADDRESS_CHANGE_DESC	Address Only Change Flag description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_ADDRESS_CHG_FLAG)
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGE_OLDER_PARENT	Age of the older parent.	NUMBER	RCRAPP1	RCRAPP1_PAR_OLDER_AGE
AID_ELIGIBILITY_RESPONSE	Drug Offense Conviction indicated.	VARCHAR2(63)	RCRAPP4	RCRAPP4_DRUG_OFFENSE_CONVIC
AID_ELIGIBILITY_RESPONSE_DESC	Aid eligibility response description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_DRUG_OFFENSE_CONVIC)
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	RCRAPP1	RCRAPP1_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ALIEN_REGISTRATION_NUMBER	Number assigned by the federal government to all eligible permanent resident non-citizens.	VARCHAR2(63)	RCRAPP1	RCRAPP1_ALIEN_REG_NO
APPLICATION_CREATE_DATE	The date that this application record was created on the database, either manually or through dataload.	DATE	RCRAPP2	RCRAPP1_CREATE_DATE
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP1	RCRAPP1_SEQ_NO
APPLICATION_RECEIPT_DATE	Date that the processor received the aid application.	DATE	RCRAPP1	RCRAPP1_RCPT_DATE
APPLICATION_REVISION_RCPT_DATE	Date that the processor received a request for revisions from the student.	DATE	RCRAPP1	RCRAPP1_REV_RCPT_DATE
APPLICATION_SIGNED_BY	Indicates if the application was signed by the student and/or the parent(s).	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_SIGNED)
APPLICATION_SIGNED_BY_DESC	Application signed description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_SIGNED)
APPLICATION_TYPE	Indicates the type (regular or renewal) of application.	VARCHAR2(63)	RCRIMP1	RCRIMP1_APPLIC_TYPE
APPLICATION_TYPE_DESC	Application type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRIMP1_APPLIC_TYPE)
ASSUMPTION_OVERRIDE1_IND	Set by electronic application user to override assumption 1: Parent's Number of Family Members assumed to be 3.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_1
ASSUMPTION_OVERRIDE2_IND	Set by electronic application user to override assumption 2: Parent's Number of College assumed to be 1.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_2
ASSUMPTION_OVERRIDE3_IND	Set by electronic application user to override assumption 3: Parent's AGI assumed equal to sum of parent's earned income portions.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_3
ASSUMPTION_OVERRIDE4_IND	Set by electronic application user to override assumption 4: Student's Number of College assumed to be 1.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_4
ASSUMPTION_OVERRIDE5_IND	Set by electronic application user to override assumption 5: Student's AGI assumed equal to sum of student's and spouse's earned income portions.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_5
ASSUMPTION_OVERRIDE6_IND	Set by electronic application user to override assumption 6: Student's social security benefits assumed to be zero.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_6
ASSUMPTION_OVERRIDE7_IND	Set by electronic application user to override assumption 7: Student's other real estate/investment value and debt assumed to be zero.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_7
ASSUMPTION_OVERRIDE8_IND	Set by electronic application user to override assumption 8: Student's business value and debt assumed to be zero.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_8
ASSUMPTION_OVERRIDE9_IND	Set by electronic application user to override assumption 9: Student's farm value and debt assumed to be zero.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ASSUMPT_OVRD_9
BIRTH_DATE	Student's date of birth.	DATE	RCRAPP1	RCRAPP1_BIRTH_DATE
CITIZENSHIP_ELIGIBILITY_TYPE	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CITZ_IND
CITIZENSHIP_ELIGIBIL_TYPE_DESC	Citizen type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_CITZ_IND)
CITIZENSHIP_TYPE	Student citizenship type.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SSA_CITIZEN_IND
CITIZENSHIP_TYPE_DESC	Student citizenship type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_SSA_CITIZEN_IND)
CITY	City of the student's address from the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CITY
COLLEGE	College code identifying the school to which this financial aid applicant record has applied.	VARCHAR2(63)	RCRAPP1	RCRAPP1_COLL_CDE
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CURR_REC_IND
DATE_APPLICATION_COMPLETED	Date the application was completed.	DATE	RCRAPP1	RCRAPP1_COMPLETION_DATE
DEATH_DATE	Date of death associated with the person on this application as reported to the government.	DATE	RCRAPP4	RCRAPP4_DEATH_DATE
DEGREE_BY_JULY_IND	Indicates if the student will have a first bachelor's degree by July 1, of the start of the aid year.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_DEGREE_BY_JULY)
DEGREE_TYPE	Contains the abbreviation of the degree or certificate a student is pursuing.	VARCHAR2(63)	RCRAPP3	RCRAPP3_DEGREE_TYPE
DEGREE_TYPE_DESC	Degree type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_DEGREE_TYPE)
DEPENDENCY_OVERRIDE	Used by the financial aid administrator to override dependency.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE
DEPENDENCY_OVERRIDE_DESC	Dependency override description.	VARCHAR2(255)	CALCULATION	DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)
DRIVER_LICENSE_NUMBER	Student's drivers license number.	VARCHAR2(63)	RCRAPP1	RCRAPP1_DRIVER_LIC_NO
DRIVER_LICENSE_STATE_PROVINCE	State or province that issued the student's drivers license.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_LIC
DRIVER_LICENSE_STATE_PROV_DESC	Description of the state or province in which the student holds a drivers license.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMAIL_ADDRESS	Student's e-mail address as reported on PROFILE.	VARCHAR2(255)	RCRAPP4	RCRAPP4_EMAIL_ADDRESS
ENROLLMENT_PLANNING_SERVICE	EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only)	VARCHAR2(63)	RCRAPP2	RCRAPP2_EPS_CDE
ENROLLMENT_PLANNING_SERV_DESC	Description of the EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only)	VARCHAR2(255)	STVEPSC	STVEPSC_DESC
FATHER_BIRTH_DATE	Father's/Stepfather's date of birth.	DATE	RCRAPP4	RCRAPP4_FATH_BIRTH_DATE
FATHER_LAST_NAME	Father's Last Name.	VARCHAR2(63)	RCRAPP4	RCRAPP4_FATH_LAST_NAME
FATHER_SIGNATURE_IND	Indicates whether or not a father's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_C_SIGNED_FATH)
FATHER_TAX_ID	Father's tax id.	VARCHAR2(63)	RCRAPP4	RCRAPP4_FATH_SSN
FATHER_TAX_ID_MATCH	Father's/Stepfather's Tax ID match flag.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FATH_SSN_MATCH
FATHER_TAX_ID_MATCH_DESC	Father Tax ID match description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_FATH_SSN_MATCH)
FINANCIAL_AID_STATUS	Indicates the student's financial aid status.	VARCHAR2(63)	RCRIMP1	RCRIMP1_FIN_AID_STATUS
FINANCIAL_AID_STATUS_DESC	Financial aid status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRIMP1_AID_STATUS)
FIRST_NAME	Student's first name as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FIRST_NAME
FOREIGN_ADDRESS_IND	Indicates that the student lives outside the nation in which the institution is located.	VARCHAR2(63)	CALCULATION	DECODE(RCRIMP1_FOREIGN_ADDR_IND)
FOREIGN_COUNTRY	Identifies the country for students that live outside the nation in which the institution is located.	VARCHAR2(63)	RCRIMP1	RCRIMP1_COUNTRY
FOREIGN_POSTAL_CODE	Identifies the foreign postal code for students that live outside the nation in which the institution is located.	VARCHAR2(63)	RCRIMP1	RCRIMP1_FOREIGN_POSTAL_CDE
GRADUATE_PROFESSIONAL_IND	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)
HOUSING	The housing code reported by the student applicant for the school that is receiving this application record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_INST_HOUS_CDE
HOUSING_DESC	Institutional housing code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_INST_HOUS_CDE)`
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INTERFACE_TAPE_CODE	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).	VARCHAR2(63)	RCRAPP1	RCRAPP1_INFC_CODE
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(255)	RTVINFC	RTVINFC_DESC
LAST_NAME	Student's last name as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_LAST_NAME
LEGAL_DEPENDENT_IND	Indicates whether or not the student has legal dependents other than a spouse for determining dependency status.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_HAS_LEGAL_DEPEND)
LEGAL_RESIDENT_IND	Indicates whether the student was a legal resident before January 1, YYYY.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_LEGAL_RES_IND)
MARITAL_STATUS	Student's reported marital status.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MRTL_STATUS
MARITAL_STATUS_DATE	Month and year the student is married, widowed, separated, or divorced.	VARCHAR2(63)	RCRAPP3	RCRAPP3_S_MAR_MTH_YR
MARITAL_STATUS_DESC	Marital status description associated with the student.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_MRTL_STATUS)
MIDDLE_INITIAL	The student's middle initial as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MI
MILITARY_REGISTRATION_STATUS	Military registration match flag.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SS_MATCH
MILITARY_REGIST_STATUS_DESC	Military registration match description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_SS_MATCH)
MILITARY_REG_REQ_STATUS	Results from the student's request to be registered with the military service.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SS_REG_FLAG
MILITARY_REG_REQ_STATUS_DESC	Student military registration request status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_SS_REG_FLAG)
MOTHER_BIRTH_DATE	Mother's/Stepmother's date of birth.	DATE	RCRAPP4	RCRAPP4_MOTH_BIRTH_DATE
MOTHER_LAST_NAME	Mother's Last Name.	VARCHAR2(63)	RCRAPP4	RCRAPP4_MOTH_LAST_NAME
MOTHER_SIGNATURE_IND	Indicates whether or not a mother's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_C_SIGNED_MOTH)
MOTHER_TAX_ID	Mother's tax id.	VARCHAR2(63)	RCRAPP4	RCRAPP4_MOTH_SSN
MOTHER_TAX_ID_MATCH	Mother's/Stepmother's Tax ID match fag.	VARCHAR2(63)	RCRAPP3	RCRAPP3_MOTH_SSN_MATCH
MOTHER_TAX_ID_MATCH_DESC	Mother Tax ID match description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_MOTH_SSN_MATCH)
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NAME_PREFIX	Student's title. (Mr. or Ms.)	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_TITLE)
NATION_OF_CITIZENSHIP	The student's country of citizenship.	VARCHAR2(63)	RCRIMP1	RCRIMP1_CITZ_COUNTRY
OFFICIAL_SOURCE_IND	Official or unofficial indicator.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)
OLDER_THAN_24_IND	Indicates whether or not the student is older than 24 years old.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_BORN_BEFORE_1_1_XX)
ORIGINAL_COMPUTE_DATE	Date that the application was originally processed by the processor.	DATE	RCRAPP1	RCRAPP1_ORIG_COMP_DATE
OTHERS_NUMBER_IN_COLLEGE	Number of non-parents in the household that will be in college as used in the calculation of parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_OTH_IN_COLL
PARENT_DIVORCE_YEAR	Year of parents' divorce.	VARCHAR2(63)	RCRIMP1	RCRIMP1_PAR_YR_DIV
PARENT_EMAIL_ADDRESS	Parent's Email Address.	VARCHAR2(255)	RCRAPP4	RCRAPP4_P_EMAIL_ADDRESS
PARENT_FAMILY_IN_COLLEGE	Number of people in the parents household that will be enrolled in college at least half-time.	NUMBER	RCRAPP1	RCRAPP1_PAR_NO_IN_COLL
PARENT_FAMILY_SIZE	Number of family members in the parents household.	NUMBER	RCRAPP1	RCRAPP1_PAR_FAM_MEMB
PARENT_LEGAL_RESIDENT_IND	Indicates whether the parent was a legal resident before January 1, YYYY.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_PAR_LEGAL_RES_IND)
PARENT_MARITAL_STATUS	Marital status for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_MRTL_STATUS
PARENT_MARITAL_STATUS_DATE	Month and year the parents were married, widowed, separated, or divorced.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_MAR_MTH_YR
PARENT_MARITAL_STATUS_DESC	Parents marital status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_PAR_MRTL_STATUS)
PARENT_NUMBER_IN_COLLEGE	Number in college that are parents of the student.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_PAR_IN_COLL
PARENT_REMARRIAGE_DATE	Date parent remarried.	DATE	RCRAPP1	RCRAPP1_PAR_REMARRIAGE_DATE
PARENT_SEPARATION_YEAR	Year of parents' separation.	VARCHAR2(63)	RCRIMP1	RCRIMP1_PAR_YR_SEP
PARENT_STATE_OF_RESIDENCE	State or province of legal residence for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES
PARENT_STATE_OF_RESIDENCE_DESC	Parents state or province of legal residence description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PERMIT_DRAFT_REGISTRATION_IND	Indicates whether or not the student gave permission to the processor to send data to the Selective Service for draft registration.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_PERMIT_DRAFT_REG)
PERM_RESIDENCY_CONFIRMED_IND	Indicates whether or not the student's permanent resident status has been confirmed by the federal government.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_INS)
PERM_RESIDENCY_VER_STATUS	Permanent residency verification status.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SEC_INS_MATCH_IND
PERM_RESIDENCY_VER_STATUS_DESC	Permanent residency verification status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_SEC_INS_MATCH_IND)
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP1	RCRAPP1_PIDM
PHONE_AREA	Area code of the student's home telephone number.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PHONE_AREA
PHONE_NUMBER	Student's home telephone number without area code.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PHONE_NO
POSTAL_CODE	Postal code for the student's address.	VARCHAR2(63)	RCRAPP1	RCRAPP1_ZIP
PREPARER_EIN	Preparer's employee identification number.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PREPARER_EIN
PREPARER_SIGNATURE_IND	Indicates whether or not the preparer's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_PREPARER_SIGN)
PREPARER_TAX_ID	Preparer's tax identification number.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PREPARER_SSN
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REJECTION_OVERRIDE2_IND	Set to 'Y' by the electronic application user to override rejection 2: Independent student status in question because of student's age.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_2
REJECTION_OVERRIDE3_IND	Set to 'Y' by the electronic application user to override rejection 3: Student's taxes paid are greater than zero and equal to or greater than AGI.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_3
REJECTION_OVERRIDE5_IND	Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_5
REJECTION_OVERRIDE7_IND	Set to 'Y' by the electronic application user to override rejection 7: Unusually large number of family members.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_7
REJECTION_OVERRIDE_B_IND	Indicates if Reject B override accepted - Independent status in question because of student's age.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_1
REJECTION_OVERRIDE_N_IND	Set by electronic application user to override reject N: Missing first or last name.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_4
REJECTION_OVERRIDE_W_IND	Set by electronic application user to override reject W: Questionable number of family members, greater than 15.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_6
REQUESTED_AID_FALL	Indicates if the student requested aid for the fall term.	VARCHAR2(63)	RCRAPP1	RCRAPP1_RQST_FA_FALL_THIS_YR
REQUESTED_AID_FALL_DESC	Requested aid for the fall description.		CALCULATION	DECODE(RCRAPP1_RQST_FA_FALL_THIS_YR)
REQUESTED_AID_NEXT_SUMMER	Indicates if the student requested aid for the summer term following the normal school year.	VARCHAR2(63)	RCRAPP1	RCRAPP1_RQST_FA_SUMMER_NEXT_YR
REQUESTED_AID_NEXT_SUMMER_DESC	Requested aid for the next summer description.		CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR)
REQUESTED_AID_PRECEDING_SUMMER	Indicates if the student requested aid for the summer term that preceded the normal school year.	VARCHAR2(63)	RCRAPP1	RCRAPP1_RQST_FA_SUMMER_THIS_YR
REQUESTED_AID_PREC_SUMMER_DESC	Requested aid for the preceding summer description.		CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)
REQUESTED_AID_SPRING	Indicates if the student requested aid for the spring term.	VARCHAR2(63)	RCRAPP1	RCRAPP1_RQST_FA_SPRING_NEXT_YR
REQUESTED_AID_SPRING_DESC	Requested aid for the spring description.		CALCULATION	DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)
REQUESTED_AID_WINTER	Indicates if the student requested aid for the winter term.	VARCHAR2(63)	RCRAPP1	RCRAPP1_RQST_FA_WINTER_NEXT_YR
REQUESTED_AID_WINTER_DESC	Requested aid for the winter description.		CALCULATION	DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)
REVISION_COMPUTE_DATE	Date that the processor processed a revised report for the applicant.	DATE	RCRAPP1	RCRAPP1_REV_COMP_DATE
SAR_C_IND	Eligibility status message that is the result of data base matches indicating further investigation by the aid administrator needed.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP2_ELIGIBILITY_MSG)
SECONDARY_SCHOOL_DIPLOMA_IND	Indicates if the person has received a high school diploma/GED.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_HS_GED_RCVD)
SELECTED_FOR_VERIFICATION_IND	Indicates whether or not the student has been selected for verification by the Federal Government or by the institution.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_VERIFICATION_MSG)
SIGNATURE_IND	Indicates whether or not a student's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_C_SIGNED)
SPOUSE_SIGNATURE_IND	Indicates whether or not a spouse's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_C_SIGNED_SPS)
START_RESIDENCE_DATE	Date the student began living in his/her state or province of legal residence in MMYY format.	VARCHAR2(63)	RCRAPP1	RCRAPP1_START_RES_MTH_YR
STATE_OF_RESIDENCE	Student's state or province of legal residence.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_RES
STATE_OF_RESIDENCE_DESC	Name of the student's state or province of legal residence.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STATE_PROVINCE	State or province associated with the student's address.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE
STATE_PROVINCE_DESC	State or province name associated with the student's address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STREET	Student's number and street for their address as reported on their aid application.	VARCHAR2(255)	RCRAPP1	RCRAPP1_ADDR
TAX_ID	Student's tax identification number assigned by their home federal government as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_SSN
TAX_ID_MATCH_STATUS	Tax ID match status.	VARCHAR2(63)	RCRAPP3	RCRAPP3_SOC_SEC
TAX_ID_MATCH_STATUS_DESC	Tax ID match status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_SOC_SEC)
TRANSACTION_NUMBER	The one up sequence number assigned by the Central Processing System to this application/correction record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USED_TRANS_NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USER_ID
VERIFICATION_NUMBER	Government verification number.	VARCHAR2(63)	RCRAPP4	RCRAPP4_VERIF_NUM
VERIFICATION_PRIORITY	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(63)	RCRAPP1	RCRAPP1_VERIFICATION_PRTY
VETERAN_IND	Indicates if the student is a veteran of the Armed Forces.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_US_VET)
VETERAN_MATCH_STATUS	Indicates the value of the Veteran's Administration federal database match flag.	VARCHAR2(63)	RCRAPP4	RCRAPP4_VA_MATCH_FLAG
VETERAN_MATCH_STATUS_DESC	Veteran match status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_VA_MATCH_FLAG)
VISA_CLASSIFICATION	Indicates what a students VISA classification is, see CSS tape layout for valid values.	VARCHAR2(63)	RCRAPP4	RCRAPP4_VISA_CLASS
VISA_CLASSIFICATION_DESC	Visa classification description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_VISA_CLASS)

Ver: 8.1