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(2)	RCRAPP1	RCRAPP1_ACYR_CODE	NO	NO
ACTIVE_DUTY_IND	Indicates whether applicant is on active duty in the military.	VARCHAR2(1)	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
ADDITIONAL_COLLEGE_NAME1	The first school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_1	NO	NO
ADDITIONAL_COLLEGE_NAME2	The second school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_2	NO	NO
ADDITIONAL_COLLEGE_NAME3	The third school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_3	NO	NO
ADDITIONAL_COLLEGE_NAME4	The fourth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_4	NO	NO
ADDITIONAL_COLLEGE_NAME5	The fifth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_5	NO	NO
ADDITIONAL_COLLEGE_NAME6	The sixth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_6	NO	NO
ADDITIONAL_COLLEGE_NAME7	The seventh school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_7	NO	NO
ADDITIONAL_COLLEGE_NAME8	The eighth school name if more than eight school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRAPP1	RCRAPP1_ADDL_COLL_NAME_8	NO	NO
ADJUSTED_GROSS_INCOME	Amount of AGI in the base year reported by the student on his/her federal tax return.	NUMBER	RCRAPP1	RCRAPP1_US_INC	NO	NO
AGE_OLDER_PARENT	Age of the older parent.	NUMBER	RCRAPP1	RCRAPP1_PAR_OLDER_AGE	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RCRAPP1	RCRAPP1_AIDY_CODE	NO	NO
AID_YEAR_DESC	Description of the aid year.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ALIEN_REGISTRATION_NUMBER	Number assigned by the federal government to all eligible permanent resident non-citizens.	VARCHAR2(9)	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	RCRAPP1	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(1)	RCRAPP1	RCRAPP1_SIGNED	NO	NO
APPLICATION_SIGNED_BY_DESC	Application signed description.	VARCHAR2(25)	CALCULATION	DECODE(RCRAPP1_SIGNED)	NO	NO
AT_RISK_HOMELESS_IND	Indicates whether student is at risk of being homeless.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_AT_RISK_HOMELESS,'1', 'Y','N')	NO	NO
AT_RISK_OF_HOMELESSNESS		VARCHAR2(1)				NO
AT_RISK_OF_HOMELESSNESS_DESC		VARCHAR2(4000)				NO
BIRTH_DATE	Student's date of birth.	DATE	RCRAPP1	RCRAPP1_BIRTH_DATE	NO	NO
BUSINESS_DEBT	Amount of the student's outstanding debts against business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_DBT	NO	NO
BUSINESS_VALUE	Current market value of the student's business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_VAL	NO	NO
CASH_SAVINGS	Amount the student currently has in cash on hand and in savings and checking accounts.	NUMBER	RCRAPP1	RCRAPP1_CASH_AMT	NO	NO
CHILD_SUPPORT_INCOME	Student's base year income from child support received for all children.	NUMBER	RCRAPP1	RCRAPP1_CHILD_SUPP	NO	NO
CITIZENSHIP_ELIGIBILITY_TYPE	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(1)	RCRAPP1	RCRAPP1_CITZ_IND	NO	NO
CITIZENSHIP_ELIGIBIL_TYPE_DESC	Citizen type description.	VARCHAR2(4000)				NO
CITY	City of the student's address from the aid application.	VARCHAR2(50)	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(6)	RCRAPP1	RCRAPP1_COLL_CDE	NO	NO
COLLEGE1	First college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_1	NO	NO
COLLEGE2	Second college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_2	NO	NO
COLLEGE3	Third college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_3	NO	NO
COLLEGE4	Fourth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_4	NO	NO
COLLEGE5	Fifth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_5	NO	NO
COLLEGE6	Sixth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_6	NO	NO
COLLEGE7	Seventh college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_7	NO	NO
COLLEGE8	Eighth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRAPP1	RCRAPP1_COLL_CDE_8	NO	NO
COLLEGE_CHOICE1	Student's first choice of college planning to attend.	VARCHAR2(6)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1	NO	NO
COLLEGE_CHOICE2	Student's second choice of college planning to attend.	VARCHAR2(6)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2	NO	NO
COLLEGE_CHOICE3	Student's third choice of college planning to attend.	VARCHAR2(6)	RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3	NO	NO
COLLEGE_NAME1	The first college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_1	NO	NO
COLLEGE_NAME2	The second college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_2	NO	NO
COLLEGE_NAME3	The third college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_3	NO	NO
COLLEGE_NAME4	The fourth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_4	NO	NO
COLLEGE_NAME5	The fifth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_5	NO	NO
COLLEGE_NAME6	The sixth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_6	NO	NO
COLLEGE_NAME7	The seventh college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_7	NO	NO
COLLEGE_NAME8	The eighth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRAPP1	RCRAPP1_COLL_NAME_8	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(1)	RCRAPP1	RCRAPP1_CURR_REC_IND	NO	NO
DATE_APPLICATION_COMPLETED	Date the application was completed.	DATE	RCRAPP1	RCRAPP1_COMPLETION_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(1)	CALCULATION	DECODE(RCRAPP1_DEGREE_BY_JULY)	NO	NO
DISLOCATED_WORKER	Indicates if the student or spouse has been certified as a dislocated worker by the appropriate agency.	VARCHAR2(1)	RCRAPP1	RCRAPP1_DISL_WRK	NO	NO
DISLOCATED_WORKER_DESC	Dislocated worker description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
DIVORCED_PARENT_INFO_IND	Indicates whether or not information was supplied by the student about divorced, separated or remarried parents.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_PAR_DIV_SEP_REM_IND)	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
DRIVER_LICENSE_NUMBER	Student's drivers license number.	VARCHAR2(20)	RCRAPP1	RCRAPP1_DRIVER_LIC_NO	NO	NO
DRIVER_LICENSE_STATE_PROVINCE	State or province that issued the student's drivers license.	VARCHAR2(2)	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(30)	STVSTAT	STVSTAT_DESC	NO	NO
EMANCIPATED_MINOR		VARCHAR2(1)				NO
EMANCIPATED_MINOR_DESC		VARCHAR2(4000)				NO
EMANCIPATED_MINOR_IND	Indicates whether student is an emancipated minor.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_EMANCIPATED_MINOR,'1', 'Y','N')	NO	NO
EXPECTED_ACADEMIC_YEAR_INCOME	Student's expected academic year income from wages.	NUMBER	RCRAPP1	RCRAPP1_EXP_ACYR_INC	NO	NO
EXPECTED_ACAD_YR_OTHER_INC	Student's expected academic year other taxable income.	NUMBER	RCRAPP1	RCRAPP1_EXP_ACYR_OTH_TAX_INC	NO	NO
EXPECTED_ACAD_YR_UNTAX_INC	Student's expected academic year nontaxable income and benefits.	NUMBER	RCRAPP1	RCRAPP1_EXP_ACYR_UNTAX_INC	NO	NO
EXPECTED_ENROLL_STATUS	Student's expected enrollment status for the school year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_EXP_ENROLL_STATUS	NO	NO
EXPECTED_ENROLL_STATUS_DESC	Description of the student's expected enrollment status.	VARCHAR2(4000)				NO
EXPECTED_FATHER_INCOME	Expected calendar year income from work for the student's father.	NUMBER	RCRAPP1	RCRAPP1_EXP_FATH_INC_FR_WRK	NO	NO
EXPECTED_MOTHER_INCOME	Expected calendar year income from work for the student's mother.	NUMBER	RCRAPP1	RCRAPP1_EXP_MOTH_INC_FR_WRK	NO	NO
EXPECTED_PARENT_OTHER_INCOME	Expected calendar year other taxable income for the student's parents.	NUMBER	RCRAPP1	RCRAPP1_EXP_PAR_OTH_TAX_INC	NO	NO
EXPECTED_PARENT_UNTAXED_INCOME	Expected calendar year nontaxable income and benefits for the student's parents.	NUMBER	RCRAPP1	RCRAPP1_EXP_PAR_UNTAX_INC	NO	NO
EXPECTED_SPOUSE_SUMMER_INCOME	Expected income from work during the summer for the student's spouse.	NUMBER	RCRAPP1	RCRAPP1_EXP_SPS_SMR_INC	NO	NO
EXPECTED_SUMMER_INCOME	Student's expected income from work for the summer.	NUMBER	RCRAPP1	RCRAPP1_EXP_SMR_INC	NO	NO
EXPECTED_SUMMER_OTHER_INCOME	Student's expected other taxable income for the summer.	NUMBER	RCRAPP1	RCRAPP1_EXP_SMR_OTH_TAX_INC	NO	NO
EXPECTED_SUMMER_UNTAXED_INC	Student's expected nontaxable income and benefits for the summer.	NUMBER	RCRAPP1	RCRAPP1_EXP_SMR_UNTAX_INC	NO	NO
EXP_SPOUSE_ACAD_YEAR_INCOME	Student's spouse's academic year expected income from work.	NUMBER	RCRAPP1	RCRAPP1_EXP_SPS_ACYR_INC	NO	NO
FAMILY_IN_COLLEGE	Total number of family members in the student's household that attend college at least half time.	NUMBER	RCRAPP1	RCRAPP1_NO_IN_COLL	NO	NO
FAMILY_SIZE	Number of people in the student's household during the school year.	NUMBER	RCRAPP1	RCRAPP1_FAM_MEMB	NO	NO
FATHER_WORK_INCOME	Amount of income earned from work by the student's father in the base year.	NUMBER	RCRAPP1	RCRAPP1_FATH_INC_FR_WRK	NO	NO
FIRST_NAME	Student's first name as reported on the aid application.	VARCHAR2(60)	RCRAPP1	RCRAPP1_FIRST_NAME	NO	NO
GOVERNMENT_BENEFITS	Amount of government benefits (such as social security benefits in the United States) received by the student (and spouse) in the base year.	NUMBER	RCRAPP1	RCRAPP1_SS_BENE	NO	NO
GOVERNMENT_BENEFIT_FOR_STUDENT	The portion of government benefits (such as social security in the United States) received by the family for the student. Institutional Method will exclude students benefits. EFM will include students benefits.	NUMBER	RCRAPP1	RCRAPP1_PAR_SS_BENE_STU_ONLY	NO	NO
GOVERNMENT_FAMILY_AID	Student's base year income from government family aid (such as the Aid to Families with Dependent Children program in the United States).	NUMBER	RCRAPP1	RCRAPP1_AFDC	NO	NO
HOME_DEBT	Student's current outstanding debts against the home.	NUMBER	RCRAPP1	RCRAPP1_HME_DBT	NO	NO
HOME_VALUE	Current market value of the student's home.	NUMBER	RCRAPP1	RCRAPP1_HME_VAL	NO	NO
HOUSING	The housing code reported by the student applicant for the school that is receiving this application record.	VARCHAR2(1)	RCRAPP1	RCRAPP1_INST_HOUS_CDE	NO	NO
HOUSING1	The housing code for the school listed first on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_1	NO	NO
HOUSING1_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING2	Housing code for the school listed second on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_2	NO	NO
HOUSING2_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING3	Housing code for the school listed third on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_3	NO	NO
HOUSING3_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING4	Housing code for the school listed fourth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_4	NO	NO
HOUSING4_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING5	Housing code for the school listed fifth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_5	NO	NO
HOUSING5_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING6	Housing code for the school listed sixth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_6	NO	NO
HOUSING6_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING7	Housing code for the school listed seventh on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_7	NO	NO
HOUSING7_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING8	Housing code for the school listed eighth on the application indicating the student's expected place of residence at school.	VARCHAR2(1)	RCRAPP1	RCRAPP1_HOUS_CDE_8	NO	NO
HOUSING8_DESC	Housing code description.	VARCHAR2(4000)				NO
HOUSING_DESC	Institutional housing code description.	VARCHAR2(4000)				NO
INCOME_TAX_PAID	Amount of federal income taxes paid by the student in the base year as reported on the student's income tax return.	NUMBER	RCRAPP1	RCRAPP1_US_INC_TAX_PD	NO	NO
INCOME_WORK	Amount of the student's base year income from working.	NUMBER	RCRAPP1	RCRAPP1_INC_FR_WRK	NO	NO
INTERFACE_TAPE_CODE	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).	VARCHAR2(7)	RCRAPP1	RCRAPP1_INFC_CODE	NO	NO
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(30)	RTVINFC	RTVINFC_DESC	NO	NO
INTERNATIONAL_PHONE_NUMBER		VARCHAR2(15)				NO
LAST_NAME	Student's last name as reported on the aid application.	VARCHAR2(60)	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(1)	CALCULATION	DECODE(RCRAPP1_HAS_LEGAL_DEPEND)	NO	NO
LEGAL_GUARDIANSHIP		VARCHAR2(1)				NO
LEGAL_GUARDIANSHIP_DESC		VARCHAR2(4000)				NO
LEGAL_GUARDIAN_IND	Indicates whether student is in legal guardianship.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_LEGAL_GUARDIAN,'1', 'Y','N')	NO	NO
LINE2_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE2_ATTEND_COLL	NO	NO
LINE2_ATTEND_COLLEGE_DESC	Line2 attends college description.	VARCHAR2(20)				NO
LINE2_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE2_RELSHIP	NO	NO
LINE2_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE2_RELSHIP)	NO	NO
LINE3_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE3_ATTEND_COLL	NO	NO
LINE3_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE3_ATTEND_COLL)	NO	NO
LINE3_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE3_RELSHIP	NO	NO
LINE3_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE3_RELSHIP)	NO	NO
LINE4_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE4_ATTEND_COLL	NO	NO
LINE4_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE4_ATTEND_COLL)	NO	NO
LINE4_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE4_RELSHIP	NO	NO
LINE4_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE4_RELSHIP)	NO	NO
LINE5_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE5_ATTEND_COLL	NO	NO
LINE5_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE5_ATTEND_COLL)	NO	NO
LINE5_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE5_RELSHIP	NO	NO
LINE5_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE5_RELSHIP)	NO	NO
LINE6_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE6_ATTEND_COLL	NO	NO
LINE6_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE6_ATTEND_COLL)	NO	NO
LINE6_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE6_RELSHIP	NO	NO
LINE6_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE6_RELSHIP)	NO	NO
LINE7_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE7_ATTEND_COLL	NO	NO
LINE7_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE7_ATTEND_COLL)	NO	NO
LINE7_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE7_RELSHIP	NO	NO
LINE7_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE7_RELSHIP)	NO	NO
LINE8_ATTEND_COLLEGE	Indicates whether or not the person listed second on the family members matrix will attend college at least half-time. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE8_ATTEND_COLL	NO	NO
LINE8_ATTEND_COLLEGE_DESC	Attends college description.	VARCHAR2(20)	CALCULATION	DECODE(RCRAPP1_LINE8_ATTEND_COLL)	NO	NO
LINE8_RELATIONSHIP	Code for the relationship to the student applicant for the person listed second on the family members matrix. (CSS source and format only).	VARCHAR2(1)	RCRAPP1	RCRAPP1_LINE8_RELSHIP	NO	NO
LINE8_RELATIONSHIP_DESC	Relationship code description.	VARCHAR2(30)	CALCULATION	DECODE(RCRAPP1_LINE8_RELSHIP)	NO	NO
MAILING_CITY		VARCHAR2(21)				NO
MAILING_NATION		VARCHAR2(2)				NO
MAILING_NATION_DESC		VARCHAR2(30)				NO
MAILING_POSTAL_CODE		VARCHAR2(17)				NO
MAILING_STATE_PROVINCE		VARCHAR2(2)				NO
MAILING_STATE_PROVINCE_DESC		VARCHAR2(30)				NO
MAILING_STREET		VARCHAR2(35)				NO
MARITAL_STATUS	Student's reported marital status.	VARCHAR2(1)	RCRAPP1	RCRAPP1_MRTL_STATUS	NO	NO
MARITAL_STATUS_DESC	Marital status description associated with the student.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_MRTL_STATUS)	NO	NO
MEANS_TESTED_BENEFITS	Indicates whether the applicant or spouse received benefits from any federal benefits program.	VARCHAR2(1)	RCRAPP1	RCRAPP1_MEANS_TEST_BEN	NO	NO
MEANS_TESTED_BENEFITS_DESC	Means tested benefits description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
MEDICAL_DENTAL_EXPENSE	Student's reported base year medical and dental expenses not paid by insurance.	NUMBER	RCRAPP1	RCRAPP1_MED_DEN_EXP	NO	NO
MIDDLE_INITIAL	The student's middle initial as reported on the aid application.	VARCHAR2(60)	RCRAPP1	RCRAPP1_MI	NO	NO
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA	NO	NO
MILITARY_ACTIVE_DUTY	Indicates whether applicant is on active duty in the military.	VARCHAR2(1)	RCRAPP1	RCRAPP1_ACTIVE_DUTY	NO	NO
MILITARY_ACTIVE_DUTY_DESC	Military active duty indicator description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
MOTHER_WORK_INCOME	Mother's reported base year income from work.	NUMBER	RCRAPP1	RCRAPP1_MOTH_INC_FR_WRK	NO	NO
NAME_PREFIX	Student's title. (Mr. or Ms.).	VARCHAR2(5)	CALCULATION	DECODE(RCRAPP1_TITLE)	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
OLDER_THAN_24_IND	Indicates whether or not the student is older than 24 years old.	VARCHAR2(1)	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
OTHER_NON_REPORTED_MONEY		NUMBER				NO
OTHER_UNTAXED_INCOME	Student's reported base year other untaxed income and benefits.	NUMBER	RCRAPP1	RCRAPP1_OTH_UNTAX_INC	NO	NO
PARENT_ADJUSTED_GROSS_INCOME	Amount of the adjusted gross income in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_US_INC	NO	NO
PARENT_BUSINESS_INCOME	Amount of income the student's parents received from business, farm, rents, royalties, partnerships, estates, trusts, etc. in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_BUS_FARM_INC	NO	NO
PARENT_CASH_ASSET	Value of cash, savings and checking accounts reported by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_CASH_AMT	NO	NO
PARENT_CHILD_SUPPORT	Amount of income received by the student's parents from child support for all children in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_CHILD_SUPP	NO	NO
PARENT_CHILD_SUPPORT_INCOME		NUMBER				NO
PARENT_DISLOCATED_WORKER	Indicates whether either of the student's parents are certified as a dislocated worker.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_DISL_WRK	NO	NO
PARENT_DISLOCATED_WORKER_DESC	Parents dislocated worker description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_DIVIDEND_INCOME	Amount of income received from dividends by the student's parents in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_DIV_INC	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_GOVERNMENT_BENEFITS	Government benefits (such as Social Security in the United States) received in the base year by the student's parents for all household members.	NUMBER	RCRAPP1	RCRAPP1_PAR_SS_BENE	NO	NO
PARENT_GOVERNMENT_FAMILY_AID	Amount of government aid (such as Aid to Families with Dependent Children in the United States) received by the student's parents in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_AFDC	NO	NO
PARENT_HOME_AMOUNT_PAID	Amount that the student's parents paid for their home.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_PURCH_AMT	NO	NO
PARENT_HOME_DEBT	Current outstanding debts against the home for the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_DBT	NO	NO
PARENT_HOME_VALUE	Current market value of the student's parents home.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_VAL	NO	NO
PARENT_HOME_YEAR_PURCHASED	Last two digits of the year that the student's parents purchased their home.	NUMBER	RCRAPP1	RCRAPP1_PAR_HME_YR_PURCH	NO	NO
PARENT_HOUSING_STATUS	Housing Status of the parent.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_HOUS_STAT	NO	NO
PARENT_HOUSING_STATUS_DESC	Parent housing status description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_PAR_HOUS_STAT)	NO	NO
PARENT_INCOME_ADJUSTMENTS	Amount that the parents reported as adjustments to income on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_ADJ_TO_INC	NO	NO
PARENT_INCOME_TAX_PAID	Amount of federal income taxes paid in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_US_INC_TAX_PD	NO	NO
PARENT_INTEREST_INCOME	Amount of interest income received in the base year by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_INT_INC	NO	NO
PARENT_MARITAL_STATUS	Marital status for the student's parents.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_MRTL_STATUS	NO	NO
PARENT_MARITAL_STATUS_DESC	Parents marital status description.	VARCHAR2(4000)				NO
PARENT_MEANS_TEST_BEN	Indicates whether the applicant's parents received benefits from any federal benefits program.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_MEANS_TEST_BEN	NO	NO
PARENT_MEANS_TEST_BEN_DESC	Parents means tested benefits description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_MEDICAL_DENTAL_EXPENSE	Amount of medical and dental expenses paid by the student's parents in the base year that was not paid by insurance.	NUMBER	RCRAPP1	RCRAPP1_PAR_MED_DEN_EXP	NO	NO
PARENT_NATION_OF_RESIDENCE		VARCHAR2(2)				NO
PARENT_NATION_RESIDENCE_DESC		VARCHAR2(30)				NO
PARENT_NO_CHILD_SEC_TUITION_PD	Number of children in the parents household that incurred elementary, jr. high, or high school tuition expenses.	NUMBER	RCRAPP1	RCRAPP1_PAR_NO_CHILD_TUIT	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_OTHER_INCOME	Other taxable income reported by the student's parents from alimony, capital gains, pensions, annuities, etc.	NUMBER	RCRAPP1	RCRAPP1_PAR_OTH_TAX_INC	NO	NO
PARENT_OTHER_UNTAXED_INCOME	Other untaxed income received in the base year by the student's parents.	NUMBER	RCRAPP1	RCRAPP1_PAR_OTH_UNTAX_INC	NO	NO
PARENT_RECD_SCHOOL_LUNCH	Indicates whether anyone in the applicant's parents household received Free or Reduced Price School Lunch benefits.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_SCHOOL_LUNCH	NO	NO
PARENT_RECD_SCHOOL_LUNCH_DESC	Parents received free or reduced school lunch description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_RECEIVED_SSI	Indicates whether the applicant's parents received Supplemental Security Income.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_RECD_SSI	NO	NO
PARENT_RECEIVED_SSI_DESC	Parents received SSI description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_RECEIVED_TANF	Indicates whether the applicant's parents received Temporary Assistance for Needy Families.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_RECD_TANF	NO	NO
PARENT_RECEIVED_TANF_DESC	Parents received TANF description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_RECEIVED_WIC	Indicates whether anyone in the applicant's parents household received assistance from the Women, Infants, and Children Program.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_RECD_WIC	NO	NO
PARENT_RECEIVED_WIC_DESC	Parents received WIC description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_REMARRIAGE_DATE	Date parent remarried.	DATE	RCRAPP1	RCRAPP1_PAR_REMARRIAGE_DATE	NO	NO
PARENT_RETIREMENT_PLAN_DISTRIB		NUMBER				NO
PARENT_SNAP_FOOD_STAMPS	Indicates whether anyone in the parents' household received Supplemental Nutrition Assistance Program (SNAP) benefits.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_FOOD_STAMPS	NO	NO
PARENT_SNAP_FOOD_STAMPS_DESC	Parent received supplemental nutrition assistance description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_STATE_OF_RESIDENCE	State or province of legal residence for the student's parents.	VARCHAR2(2)	RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES	NO	NO
PARENT_STATE_OF_RESIDENCE_DESC	Parents stare or province of legal residence description.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
PARENT_TAX_FILING_STATUS	The parents tax filing status.	VARCHAR2(1)	RCRAPP1	RCRAPP1_PAR_TAX_FILING_STATUS	NO	NO
PARENT_TAX_RETURN_TYPE	Type of federal income tax return form the student's parents filed.	VARCHAR2(2)	RCRAPP1	RCRAPP1_PAR_TAX_FORM_IND	NO	NO
PARENT_TAX_RETURN_TYPE_DESC	Parent tax return type description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_PAR_TAX_FORM_IND)	NO	NO
PARENT_TUITION_PAID	Amount of elementary, jr. high, and high school tuition paid by the student's parents in the base year.	NUMBER	RCRAPP1	RCRAPP1_PAR_TUIT_PD	NO	NO
PARENT_UNTAXED_PENSIONS		NUMBER				NO
PARENT_VETERAN_NON_ED_BENEFIT		NUMBER				NO
PARENT_WAGES	Amount of wages, salaries, tips, etc. in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_WAGES	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(1)	RCRAPP1	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(1)	CALCULATION	DECODE(RCRAPP1_INS)	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(6)	RCRAPP1	RCRAPP1_PHONE_AREA	NO	NO
PHONE_NUMBER	Student's home telephone number without area code.	VARCHAR2(12)	RCRAPP1	RCRAPP1_PHONE_NO	NO	NO
POSTAL_CODE	Postal code for the student's address.	VARCHAR2(30)	RCRAPP1	RCRAPP1_ZIP	NO	NO
RECEIVED_SCHOOL_LUNCH	Indicates whether anyone in the applicant's household received Free or Reduced Price School Lunch benefits.	VARCHAR2(1)	RCRAPP1	RCRAPP1_SCHOOL_LUNCH	NO	NO
RECEIVED_SCHOOL_LUNCH_DESC	Received free or reduced school lunch description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
RECEIVED_SSI	Indicates whether anyone in the applicant's household received Supplemental Security Income.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RECD_SSI	NO	NO
RECEIVED_SSI_DESC	Received SSI description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
RECEIVED_TANF	Indicates whether anyone in the applicant's household received Temporary Assistance For Needy Families.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RECD_TANF	NO	NO
RECEIVED_TANF_DESC	Received TANF description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
RECEIVED_WIC	Indicates whether anyone in the applicant's household received assistance from the Women, Infants, and Children Program.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RECD_WIC	NO	NO
RECEIVED_WIC_DESC	Received WIC description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
REQUESTED_AID_FALL	Indicates if the student requested aid for the fall term.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_FALL_THIS_YR	NO	NO
REQUESTED_AID_FALL_DESC	Requested aid for the fall description.	VARCHAR2(4000)				NO
REQUESTED_AID_NEXT_SUMMER	Indicates if the student requested aid for the summer term following the normal school year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_SUMMER_NEXT_YR	NO	NO
REQUESTED_AID_NEXT_SUMMER_DESC	Requested aid for the next summer description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR)	NO	NO
REQUESTED_AID_PRECEDING_SUMMER	Indicates if the student requested aid for the summer term that preceded the normal school year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_SUMMER_THIS_YR	NO	NO
REQUESTED_AID_PREC_SUMMER_DESC	Requested aid for the preceding summer description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)	NO	NO
REQUESTED_AID_SPRING	Indicates if the student requested aid for the spring term.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_SPRING_NEXT_YR	NO	NO
REQUESTED_AID_SPRING_DESC	Requested aid for the spring description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)	NO	NO
REQUESTED_AID_WINTER	Indicates if the student requested aid for the winter term.	VARCHAR2(1)	RCRAPP1	RCRAPP1_RQST_FA_WINTER_NEXT_YR	NO	NO
REQUESTED_AID_WINTER_DESC	Requested aid for the winter description.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)	NO	NO
RETIREMENT_PLAN_DISTRIBUTION		NUMBER				NO
REVISION_COMPUTE_DATE	Date that the processor processed a revised report for the applicant.	DATE	RCRAPP1	RCRAPP1_REV_COMP_DATE	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(1)	CALCULATION	DECODE(RCRAPP1_VERIFICATION_MSG)	NO	NO
SNAP_FOOD_STAMPS	Indicates whether anyone in the applicant's household received Supplemental Nutrition Assistance Program (SNAP) benefits.	VARCHAR2(1)	RCRAPP1	RCRAPP1_FOOD_STAMPS	NO	NO
SNAP_FOOD_STAMPS_DESC	Received supplemental nutrition description.	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
SPOUSE_INCOME_WORK	Amount of income earned from work by the student's spouse in the base year.	NUMBER	RCRAPP1	RCRAPP1_SPS_INC_FR_WRK	NO	NO
START_RESIDENCE_DATE	Date the student began living in his/her state or province of legal residence in MMYY format.	VARCHAR2(4)	RCRAPP1	RCRAPP1_START_RES_MTH_YR	NO	NO
STATE_OF_RESIDENCE	Student's state or province of legal residence.	VARCHAR2(2)	RCRAPP1	RCRAPP1_STAT_CODE_RES	NO	NO
STATE_OF_RESIDENCE_DESC	Name of the student's state or province of legal residence.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
STATE_PROVINCE	State or province associated with the student's address.	VARCHAR2(2)	RCRAPP1	RCRAPP1_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State or province name associated with the student's address.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
STREET	Student's number and street for their address as reported on their aid application.	VARCHAR2(75)	RCRAPP1	RCRAPP1_ADDR	NO	NO
TAX_FILING_STATUS	The student's tax filing status.	VARCHAR2(1)	RCRAPP1	RCRAPP1_TAX_FILING_STATUS	NO	NO
TAX_ID	Student's tax identification number assigned by their home federal government as reported on the aid application.	VARCHAR2(15)	RCRAPP1	RCRAPP1_SSN	NO	NO
TAX_RETURN_TYPE	Indicates which type of federal tax return the student filed (or will file) and whether or not the income data is estimated.	VARCHAR2(2)	RCRAPP1	RCRAPP1_TAX_FORM_IND	NO	NO
TAX_RETURN_TYPE_DESC	Description of the tax return type.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_TAX_FORM_IND)	NO	NO
TRANSACTION_NUMBER	The one up sequence number assigned by the Central Processing System to this application/correction record.	VARCHAR2(2)	RCRAPP1	RCRAPP1_USED_TRANS_NO	NO	NO
UNACCOMPANIED_YOUTH_HUD		VARCHAR2(1)				NO
UNACCOMPANIED_YOUTH_HUD_DESC		VARCHAR2(4000)				NO
UNACCOMPANIED_YOUTH_HUD_IND	Indicates whether student is an unaccompanied youth determined by HUD.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_UNACCOMP_YOUTH_HUD,'1', 'Y','N')	NO	NO
UNACCOMPANIED_YOUTH_SCHL_DESC		VARCHAR2(4000)				NO
UNACCOMPANIED_YOUTH_SCHOOL		VARCHAR2(1)				NO
UNACCOMPANIED_YOUTH_SCHOOL_IND	Indicates whether student is an unaccompanied youth determined by a school district liaison.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_UNACCOMP_YOUTH_SCHOOL,'1', 'Y','N')	NO	NO
UNTAXED_PENSIONS		NUMBER				NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RCRAPP1	RCRAPP1_USER_ID	NO	NO
VERIFICATION_PRIORITY	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(4)	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(4000)	RORMVAL	RORMVAL_DESC	NO	NO
VETERAN_BENEFITS_TYPE		VARCHAR2(1)				NO
VETERAN_BENEFITS_TYPE_DESC		VARCHAR2(4000)				NO
VETERAN_IND	Indicates if the student is a veteran of the Armed Forces.	VARCHAR2(1)	CALCULATION	DECODE(RCRAPP1_US_VET)	NO	NO
VETERAN_MONTHLY_OTHER_BENEFITS		NUMBER				NO
VETERAN_NON_EDUCATION_BENEFIT		NUMBER				NO
VETERAN_OTHER_BENEFITS	Amount per month from other VA programs.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_AMT	NO	NO
VETERAN_OTHER_BENEFITS_MONTHS		NUMBER				NO
VETERAN_OTH_BEN_NO_MONTHS	Number of months that the other VA benefits will be received during the award year.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_MTH	NO	NO
VETERAN_RECEIVING_BENEFITS		VARCHAR2(1)				NO
VETERAN_RECEIVING_BENEFIT_DESC		VARCHAR2(4000)				NO
WARD_OF_COURT		VARCHAR2(1)				NO
WARD_OF_COURT_DESC		VARCHAR2(4000)				NO
WARD_OF_COURT_IND	Indicates if the student reported being a ward of the court or is an orphan.	VARCHAR2(1)	CALCULATION	DECODE (RCRAPP1_WARD_OF_COURT, '1', 'Y', 'N')	NO	NO
YEAR_IN_COLLEGE	Year of study (first, second, etc.) that the student enrolls in this year.	VARCHAR2(1)	RCRAPP1	RCRAPP1_YR_IN_COLL	NO	NO
YEAR_IN_COLLEGE_DESC	Description of the year of study.	VARCHAR2(4000)	CALCULATION	DECODE(RCRAPP1_YR_IN_COLL)	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: