Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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	NO	NO
ACTIVE_DUTY_IND	Indicates whether applicant is on active duty in the military.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_ACTIVE_DUTY,'1','Y','N')	NO	NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRAPP1	RCRAPP1_ACTIVITY_DATE	NO	NO
ADDRESS_CHANGE	Address Only Change Flag.	VARCHAR2(63)	RCRAPP4	RCRAPP4_ADDRESS_CHG_FLAG	NO	NO
ADDRESS_CHANGE_DESC	Address Only Change Flag description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_ADDRESS_CHG_FLAG)	NO	NO
ADJUSTED_EFC_CALC_REQUEST	Contains a request to calculate the adjusted Effective Family Contribution.	VARCHAR2(63)	RCRAPP3	RCRAPP3_ADJ_EFC_CALC_REQ	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AGE_OLDER_PARENT	Age of the older parent.	NUMBER	RCRAPP1	RCRAPP1_PAR_OLDER_AGE	NO	NO
AID_ELIGIBILITY_RESPONSE	Drug Offense Conviction indicated.	VARCHAR2(63)	RCRAPP4	RCRAPP4_DRUG_OFFENSE_CONVIC	NO	NO
AID_ELIGIBILITY_RESPONSE_DESC	Aid eligibility response description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ALIEN_REGISTRATION_NUMBER	Number assigned by the federal government to all eligible permanent resident non-citizens.	VARCHAR2(63)	RCRAPP1	RCRAPP1_ALIEN_REG_NO	NO	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	NO	NO
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	NO	NO
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP1	RCRAPP1_SEQ_NO	NO	NO
APPLICATION_RECEIPT_DATE	Date that the processor received the aid application.	DATE	RCRAPP1	RCRAPP1_RCPT_DATE	NO	NO
APPLICATION_REVISION_RCPT_DATE	Date that the processor received a request for revisions from the student.	DATE	RCRAPP1	RCRAPP1_REV_RCPT_DATE	NO	NO
APPLICATION_SIGNED_BY	Indicates if the application was signed by the student and/or the parent(s).	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_SIGNED)	NO	NO
APPLICATION_SIGNED_BY_DESC	Application signed description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_SIGNED)	NO	NO
APPLICATION_TYPE	Indicates the type (regular or renewal) of application.	VARCHAR2(63)	RCRIMP1	RCRIMP1_APPLIC_TYPE	NO	NO
APPLICATION_TYPE_DESC	Application type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRIMP1_APPLIC_TYPE)	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
AT_RISK_HOMELESS_IND	Indicates whether student is at risk of being homeless.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_AT_RISK_HOMELESS,'1', 'Y','N')	NO	NO
AT_RISK_OF_HOMELESSNESS	Indicates whether student is at risk of being homeless.	VARCHAR2(63)	RCRAPP1	RCRAPP1_AT_RISK_HOMELESS	NO	NO
AT_RISK_OF_HOMELESSNESS_DESC	At risk of homelessness indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
BIRTH_DATE	Student's date of birth.	DATE	RCRAPP1	RCRAPP1_BIRTH_DATE	NO	NO
CITIZENSHIP_ELIGIBILITY_TYPE	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CITZ_IND	NO	NO
CITIZENSHIP_ELIGIBIL_TYPE_DESC	Citizen type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
CITIZENSHIP_TYPE	Student citizenship type.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SSA_CITIZEN_IND	NO	NO
CITIZENSHIP_TYPE_DESC	Student citizenship type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
CITY	City of the student's address from the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CITY	NO	NO
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	NO	NO
COLLEGE_CHOICE1	Student's first choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1	NO	NO
COLLEGE_CHOICE10	Student's tenth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_10	NO	NO
COLLEGE_CHOICE2	Student's second choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2	NO	NO
COLLEGE_CHOICE3	Student's third choice of college planning to attend.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3	NO	NO
COLLEGE_CHOICE4	Student's fourth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_4	NO	NO
COLLEGE_CHOICE5	Student's fifth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_5	NO	NO
COLLEGE_CHOICE6	Student's sixth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_6	NO	NO
COLLEGE_CHOICE7	Student's seventh choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_7	NO	NO
COLLEGE_CHOICE8	Student's eighth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_8	NO	NO
COLLEGE_CHOICE9	Student's ninth choice of college planning to attend.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FED_COLL_CHOICE_9	NO	NO
CORRECTION_SOURCE	Source of the correction.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SOURCE_CORRECTION	NO	NO
CORRECTION_SOURCE_DESC	Correction source description	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_SOURCE_CORRECTION)	NO	NO
CPS_ISIR_PUSHED_IND	CPS pushed ISIR flag.	VARCHAR2(63)	CALCULATION	NVL(RCRAPP4_PUSH_ISIR_FLAG)	NO	NO
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CURR_REC_IND	NO	NO
DATE_APPLICATION_COMPLETED	Date the application was completed.	DATE	RCRAPP1	RCRAPP1_COMPLETION_DATE	NO	NO
DEATH_DATE	Date of death associated with the person on this application as reported to the government.	DATE	RCRAPP4	RCRAPP4_DEATH_DATE	NO	NO
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)	NO	NO
DEGREE_TYPE	Contains the abbreviation of the degree or certificate a student is pursuing.	VARCHAR2(63)	RCRAPP3	RCRAPP3_DEGREE_TYPE	NO	NO
DEGREE_TYPE_DESC	Degree type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_DEGREE_TYPE)	NO	NO
DEPENDENCY_OVERRIDE	Used by the financial aid administrator to override dependency.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE	NO	NO
DEPENDENCY_OVERRIDE_DESC	Dependency override description.	VARCHAR2(255)	CALCULATION	DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)	NO	NO
DOD_MATCH	Applicant's SSN included in the Department of Defense match file.	VARCHAR2(63)	RCRAPP4	RCRAPP4_DOD_MATCH_FLAG	NO	NO
DOD_MATCH_DESC	Department Of Defense match flag.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
DOD_PARENT_DEATH_DATE	Date the parent of the applicant died.	DATE	RCRAPP4	RCRAPP4_DOD_PAR_DEATH_DATE	NO	NO
DRIVER_LICENSE_NUMBER	Student's drivers license number.	VARCHAR2(63)	RCRAPP1	RCRAPP1_DRIVER_LIC_NO	NO	NO
DRIVER_LICENSE_STATE_PROVINCE	State or province that issued the student's drivers license.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_LIC	NO	NO
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	NO	NO
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)	NO	NO
EFC_CHANGE_FLAG	EFC change flag indicates whether the EFC has increased or decreased.	VARCHAR2(63)	RCRAPP4	RCRAPP4_EFC_CHANGE_IND	NO	NO
EFC_CHANGE_FLAG_DESC	EFC change flag description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_EFC_CHANGE_IND)	NO	NO
EFC_RECALC_SPECIAL_CIRCUM	Indicates a request to the CPS to recalculate the Effective Family Contribution.	VARCHAR2(63)	RCRAPP3	RCRAPP3_EFC_RECALC_CORR_REQ	NO	NO
EFC_RECALC_SPECIAL_CIRCUM_DESC	Request to the CPS to recalculate the Effective Family Contribution indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
EMAIL_ADDRESS	Student's e-mail address as reported on PROFILE.	VARCHAR2(255)	RCRAPP4	RCRAPP4_EMAIL_ADDRESS	NO	NO
EMANCIPATED_MINOR	Indicates whether student is an emancipated minor.	VARCHAR2(63)	RCRAPP1	RCRAPP1_EMANCIPATED_MINOR	NO	NO
EMANCIPATED_MINOR_DESC	Emancipated minor indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
EMANCIPATED_MINOR_IND	Indicates whether student is an emancipated minor.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_EMANCIPATED_MINOR,'1', 'Y','N')	NO	NO
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	NO	NO
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	NO	NO
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)	NO	NO
FAMILY_SIZE	Number of people in the student's household during the school year.	NUMBER	CALCULATION	DECODE(RCRAPP2_MODEL_CDE)	NO	NO
FATHER_BIRTH_DATE	Father's/Mother's/Stepparent's date of birth.	DATE	RCRAPP4	RCRAPP4_FATH_BIRTH_DATE	NO	NO
FATHER_FIRST_INITIAL	Father's/Stepfather's first name/initial.	VARCHAR2(63)	RCRAPP4	RCRAPP4_FATH_FIRST_NAME_INI	NO	NO
FATHER_LAST_NAME	Father's/Mother's/Stepparent's last name.	VARCHAR2(63)	RCRAPP4	RCRAPP4_FATH_LAST_NAME	NO	NO
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)	NO	NO
FATHER_TAX_ID	Father's/Mother's/Stepparent's tax id.	VARCHAR2(63)	RCRAPP4	RCRAPP4_FATH_SSN	NO	NO
FATHER_TAX_ID_MATCH	Father's/Mother's/Stepparent's Tax ID match flag.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FATH_SSN_MATCH	NO	NO
FATHER_TAX_ID_MATCH_DESC	Parent 1 Tax ID match description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
FEDERAL_SCHOOL_CODE	School Code that requested a dependency override or adjusted calculation request.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_TITLE_IV_CODE	NO	NO
FINANCIAL_AID_STATUS	Indicates the student's financial aid status.	VARCHAR2(63)	RCRIMP1	RCRIMP1_FIN_AID_STATUS	NO	NO
FINANCIAL_AID_STATUS_DESC	Financial aid status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRIMP1_AID_STATUS)	NO	NO
FIRST_NAME	Student's first name as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_FIRST_NAME	NO	NO
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)	NO	NO
FOREIGN_COUNTRY	Identifies the country for students that live outside the nation in which the institution is located.	VARCHAR2(63)	RCRIMP1	RCRIMP1_COUNTRY	NO	NO
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	NO	NO
GRADUATE_PROFESSIONAL_IND	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)	NO	NO
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	NO	NO
HOUSING_DESC	Institutional housing code description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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	NO	NO
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	NO	NO
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(255)	RTVINFC	RTVINFC_DESC	NO	NO
INTERNATIONAL_PHONE_NUMBER	Phone number for a student who resides in a country outside the U.S.	VARCHAR2(63)	RCRAPP1	RCRAPP1_INTL_PHONE_NO	NO	NO
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	NO	NO
IRS_AGI_FLAG_DESC	IRS Adjusted Gross Income data for the student was transferred to the FAFSA indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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	NO	NO
IRS_FIT_FLAG_DESC	IRS Federal Income Tax data for the student was transferred to the FAFSA indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
IRS_REQUEST_STATUS	Status of the data request sent to the IRS for the parent.	VARCHAR2(63)	RCRAPP3	RCRAPP3_IRS_REQUEST_FLAG	NO	NO
IRS_REQUEST_STATUS_DESC	IRS request status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
LAST_NAME	Student's last name as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_LAST_NAME	NO	NO
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)	NO	NO
LEGAL_GUARDIANSHIP	Indicates whether student is in legal guardianship.	VARCHAR2(63)	RCRAPP1	RCRAPP1_LEGAL_GUARDIAN	NO	NO
LEGAL_GUARDIANSHIP_DESC	Legal guardian indicator description	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
LEGAL_GUARDIAN_IND	Indicates whether student is in legal guardianship.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_LEGAL_GUARDIAN,'1', 'Y','N')	NO	NO
LEGAL_RESIDENT_IND	Indicates whether the student was a legal resident before January 1, YYYY.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_LEGAL_RES_IND)	NO	NO
MAILING_CITY	City of the student's mailing address from the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MAIL_CITY	NO	NO
MAILING_NATION	Country code of the student's mailing address as reported on their application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MAIL_COUNTRY_CDE	NO	NO
MAILING_NATION_DESC	Nation/country code description.	VARCHAR2(255)	STVNATN	STVNATN_NATN	NO	NO
MAILING_POSTAL_CODE	Postal code for the student's mailing address.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MAIL_POSTAL_CDE	NO	NO
MAILING_STATE_PROVINCE	Postal code for the student's mailing address.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MAIL_STAT_CODE	NO	NO
MAILING_STATE_PROVINCE_DESC	State or province name associated with the student's mailing address.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
MAILING_STREET	Number and street of student's mailing address as reported on their aid application.	VARCHAR2(255)	RCRAPP1	RCRAPP1_MAIL_ADDR	NO	NO
MARITAL_STATUS	Student's reported marital status.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MRTL_STATUS	NO	NO
MARITAL_STATUS_DATE	Month and year the student is married, widowed, separated, or divorced.	VARCHAR2(63)	RCRAPP3	RCRAPP3_S_MAR_MTH_YR	NO	NO
MARITAL_STATUS_DESC	Marital status description associated with the student.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
MIDDLE_INITIAL	The student's middle initial as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_MI	NO	NO
MILITARY_ACTIVE_DUTY	Indicates whether applicant is on active duty in the military.	VARCHAR2(63)	RCRAPP1	RCRAPP1_ACTIVE_DUTY	NO	NO
MILITARY_ACTIVE_DUTY_DESC	Military active duty indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
MILITARY_REGISTRATION_STATUS	Military registration match flag.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SS_MATCH	NO	NO
MILITARY_REGIST_STATUS_DESC	Military registration match description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
MILITARY_REG_REQ_STATUS	Results from the student's request to be registered with the military service.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SS_REG_FLAG	NO	NO
MILITARY_REG_REQ_STATUS_DESC	Student military registration request status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
MOTHER_BIRTH_DATE	Father's/Mother's/Stepparent's date of birth.	DATE	RCRAPP4	RCRAPP4_MOTH_BIRTH_DATE	NO	NO
MOTHER_FIRST_INITIAL	Mother's/Stepmother's first name initial.	VARCHAR2(63)	RCRAPP4	RCRAPP4_MOTH_FIRST_NAME_INI	NO	NO
MOTHER_LAST_NAME	Father's/Mother's/Stepparent's last name.	VARCHAR2(63)	RCRAPP4	RCRAPP4_MOTH_LAST_NAME	NO	NO
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)	NO	NO
MOTHER_TAX_ID	Father's/Mother's/Stepparent's tax id.	VARCHAR2(63)	RCRAPP4	RCRAPP4_MOTH_SSN	NO	NO
MOTHER_TAX_ID_MATCH	Father's/Mother's/Stepparent's Tax ID match flag.	VARCHAR2(63)	RCRAPP3	RCRAPP3_MOTH_SSN_MATCH	NO	NO
MOTHER_TAX_ID_MATCH_DESC	Parent 2 Tax ID match description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME_PREFIX	Student's title. (Mr. or Ms.).	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_TITLE)	NO	NO
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	NO	NO
NATIONAL_STUDENT_LOAN_SYS_DESC	National student loan system description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_NSLDS_MATCH)	NO	NO
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	NO	NO
NUMBER_OF_EXEMPTIONS	Number of tax exemptions claimed by the student on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_NO_EXEMPT	NO	NO
OFFICIAL_SOURCE_IND	Official or unofficial indicator.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)	NO	NO
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)	NO	NO
ORIGINAL_COMPUTE_DATE	Date that the application was originally processed by the processor.	DATE	RCRAPP1	RCRAPP1_ORIG_COMP_DATE	NO	NO
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	NO	NO
PARENT_DIVORCE_YEAR	Year of parents' divorce.	VARCHAR2(63)	RCRIMP1	RCRIMP1_PAR_YR_DIV	NO	NO
PARENT_EMAIL_ADDRESS	Parent's Email Address.	VARCHAR2(255)	RCRAPP4	RCRAPP4_P_EMAIL_ADDRESS	NO	NO
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	NO	NO
PARENT_FAMILY_SIZE	Number of family members in the parents household.	NUMBER	RCRAPP1	RCRAPP1_PAR_FAM_MEMB	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
PARENT_IRS_REQUEST_STATUS	Status of the data request sent to the IRS for the student.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_IRS_REQUEST_FLAG	NO	NO
PARENT_IRS_REQUEST_STATUS_DESC	IRS request status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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)	NO	NO
PARENT_MARITAL_STATUS	Marital status for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_MRTL_STATUS	NO	NO
PARENT_MARITAL_STATUS_DATE	Month and year the parents were married, widowed, separated, or divorced.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PAR_MAR_MTH_YR	NO	NO
PARENT_MARITAL_STATUS_DESC	Parents marital status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_NATION_OF_RESIDENCE	Nation/country of legal residence for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_CNTRY_CODE_RES	NO	NO
PARENT_NATION_RESIDENCE_DESC	Parent nation/country of residence description.	VARCHAR2(255)	STVNATN	STVNATN_NATN	NO	NO
PARENT_NUMBER_IN_COLLEGE	Number in college that are parents of the student.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_PAR_IN_COLL	NO	NO
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	NO	NO
PARENT_REMARRIAGE_DATE	Date parent remarried.	DATE	RCRAPP1	RCRAPP1_PAR_REMARRIAGE_DATE	NO	NO
PARENT_SEPARATION_YEAR	Year of parents' separation.	VARCHAR2(63)	RCRIMP1	RCRIMP1_PAR_YR_SEP	NO	NO
PARENT_STATE_OF_RESIDENCE	State or province of legal residence for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES	NO	NO
PARENT_STATE_OF_RESIDENCE_DESC	Parents state or province of legal residence description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PARENT_TYPE1	Type of parent assigned to the traditional father position.	VARCHAR2(63)	RCRAPP4	RCRAPP4_PARENT_TYPE_1	NO	NO
PARENT_TYPE1_DESC	Parent type 1 description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_TYPE2	Type of parent assigned to the traditional mother position.	VARCHAR2(63)	RCRAPP4	RCRAPP4_PARENT_TYPE_2	NO	NO
PARENT_TYPE2_DESC	Parent type 2 description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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)	NO	NO
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)	NO	NO
PERM_RESIDENCY_VER_STATUS	Permanent residency verification status.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SEC_INS_MATCH_IND	NO	NO
PERM_RESIDENCY_VER_STATUS_DESC	Permanent residency verification status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP1	RCRAPP1_PIDM	NO	NO
PHONE_AREA	Area code of the student's home telephone number.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PHONE_AREA	NO	NO
PHONE_NUMBER	Student's home telephone number without area code.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PHONE_NO	NO	NO
POSTAL_CODE	Postal code for the student's address.	VARCHAR2(63)	RCRAPP1	RCRAPP1_ZIP	NO	NO
PREPARER_EIN	Preparer's employee identification number.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PREPARER_EIN	NO	NO
PREPARER_SIGNATURE_IND	Indicates whether or not the preparer's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_PREPARER_SIGN)	NO	NO
PREPARER_TAX_ID	Preparer's tax identification number.	VARCHAR2(63)	RCRAPP3	RCRAPP3_PREPARER_SSN	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
REQUESTED_AID_FALL_DESC	Requested aid for the fall description. No longer populated after aid year ending in 2014.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
REQUESTED_AID_SPRING_DESC	Requested aid for the spring description. No longer populated after aid year ending in 2014.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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	NO	NO
REQUESTED_AID_WINTER_DESC	Requested aid for the winter description. No longer populated after aid year ending in 2014.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
REVISION_COMPUTE_DATE	Date that the processor processed a revised report for the applicant.	DATE	RCRAPP1	RCRAPP1_REV_COMP_DATE	NO	NO
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)	NO	NO
SECONDARY_SCHL_STATE_PROV_DESC	State/Province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
SECONDARY_SCHOOL	Secondary school code.	VARCHAR2(63)	RCRAPP4	RCRAPP4_HIGH_SCH_CDE	NO	NO
SECONDARY_SCHOOL_CITY	City in which the student attended secondary school.	VARCHAR2(255)	RCRAPP4	RCRAPP4_HIGH_SCHOOL_CITY	NO	NO
SECONDARY_SCHOOL_DIPLOMA_IND	Indicates if the person has received a high school diploma/GED.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_HS_GED_RCVD)	NO	NO
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	NO	NO
SECONDARY_SCHOOL_INVALID_DESC	Secondary school invalid flag description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
SECONDARY_SCHOOL_NAME	Name of the secondary school attended by the student.	VARCHAR2(255)	RCRAPP4	RCRAPP4_HIGH_SCHOOL_NAME	NO	NO
SECONDARY_SCHOOL_STATE_PROV	State/Province code in which the student attended secondary school.	VARCHAR2(63)	RCRAPP4	RCRAPP4_STAT_CODE_HIGH_SCH	NO	NO
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)	NO	NO
SIGNATURE_IND	Indicates whether or not a student's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_C_SIGNED)	NO	NO
SIMPLIFIED_NEEDS_TEST_IND	Indicates whether the Simplified Needs Test conditions have been met.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP2_PELL_ANLY_TYPE)	NO	NO
SPECIAL_CIRCUMSTANCE	Indicates type of special circumstance performed.	VARCHAR2(63)	RCRAPP3	RCRAPP3_SPEC_CIRCUM_FLAG	NO	NO
SPECIAL_CIRCUMSTANCE_DESC	Special circumstance description	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
SPOUSE_SIGNATURE_IND	Indicates whether or not a spouse's signature is on the application.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_C_SIGNED_SPS)	NO	NO
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	NO	NO
STATE_OF_RESIDENCE	Student's state or province of legal residence.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_RES	NO	NO
STATE_OF_RESIDENCE_DESC	Name of the student's state or province of legal residence.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STATE_PROVINCE	State or province associated with the student's address.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State or province name associated with the student's address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STREET	Student's number and street for their address as reported on their aid application.	VARCHAR2(255)	RCRAPP1	RCRAPP1_ADDR	NO	NO
SUBSEQUENT_RECORD_SELECTED_VER	Subsequent record selected for verification.	VARCHAR2(63)	RCRAPP4	RCRAPP4_SUB_VERIF_SELECTED	NO	NO
TAX_ID	Student's tax identification number assigned by their home federal government as reported on the aid application.	VARCHAR2(63)	RCRAPP1	RCRAPP1_SSN	NO	NO
TAX_ID_MATCH_STATUS	Tax ID match status.	VARCHAR2(63)	RCRAPP3	RCRAPP3_SOC_SEC	NO	NO
TAX_ID_MATCH_STATUS_DESC	Tax ID match status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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	NO	NO
UNACCOMPANIED_YOUTH_HUD	Indicates whether student is an unaccompanied youth determined by HUD.	VARCHAR2(63)	RCRAPP1	RCRAPP1_UNACCOMP_YOUTH_HUD	NO	NO
UNACCOMPANIED_YOUTH_HUD_DESC	Unaccompanied youth HUD indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
UNACCOMPANIED_YOUTH_HUD_IND	Indicates whether student is an unaccompanied youth determined by HUD.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_UNACCOMP_YOUTH_HUD,'1', 'Y','N')	NO	NO
UNACCOMPANIED_YOUTH_SCHL_DESC	Unaccompanied youth school indicator description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
UNACCOMPANIED_YOUTH_SCHOOL	Indicates whether student is an unaccompanied youth determined by a school district liaison.	VARCHAR2(63)	RCRAPP1	RCRAPP1_UNACCOMP_YOUTH_SCHOOL	NO	NO
UNACCOMPANIED_YOUTH_SCHOOL_IND	Indicates whether student is an unaccompanied youth determined by a school district liaison.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_UNACCOMP_YOUTH_SCHOOL,'1', 'Y','N')	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USER_ID	NO	NO
VERIFICATION_NUMBER	Government verification number.	VARCHAR2(63)	RCRAPP4	RCRAPP4_VERIF_NUM	NO	NO
VERIFICATION_PRIORITY	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(63)	RCRAPP1	RCRAPP1_VERIFICATION_PRTY	NO	NO
VERIFICATION_PRIORITY_DESC	Description of the priority of the edits used to select the student for data verification.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
VETERAN_IND	Indicates if the student is a veteran of the Armed Forces.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP1_US_VET)	NO	NO
VETERAN_MATCH_STATUS	Indicates the value of the Veteran's Administration federal database match flag.	VARCHAR2(63)	RCRAPP4	RCRAPP4_VA_MATCH_FLAG	NO	NO
VETERAN_MATCH_STATUS_DESC	Veteran match status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
VISA_CLASSIFICATION	Indicates what a students VISA classification is, see CSS tape layout for valid values.	VARCHAR2(63)	RCRAPP4	RCRAPP4_VISA_CLASS	NO	NO
VISA_CLASSIFICATION_DESC	Visa classification description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
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	NO	NO
WARD_OF_COURT_DESC	Ward of court indicator description	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
WARD_OF_COURT_IND	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')	NO	NO

Ver: 9.2