Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_YEAR	Academic Year	The last two digits of the first year for the academic year being processed. EXAMPLE: '90' for the 1990-91 academic year.	VARCHAR2(2)		RCRAPP1	RCRAPP1_ACYR_CODE
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE		RCRAPP1	RCRAPP1_ACTIVITY_DATE
ADJUSTED_GROSS_INCOME	Adjusted Gross Income	Amount of AGI in the base year reported by the student on his/her federal tax return.	NUMBER(6)		RCRAPP1	RCRAPP1_US_INC
AGE_OLDER_PARENT	Age Older Parent	Age of the older parent.	NUMBER(2)		RCRAPP1	RCRAPP1_PAR_OLDER_AGE
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)		RCRAPP1	RCRAPP1_AIDY_CODE
AID_YEAR_DESC	Financial Aid Year Description	Description of the aid year.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ALIEN_REGISTRATION_NUMBER	Alien Registration Number	Number assigned by the federal government to all eligible permanent resident non-citizens.	VARCHAR2(9)		RCRAPP1	RCRAPP1_ALIEN_REG_NO
APPLICATION_CREATE_DATE	Application Create Date	The date that this application record was created on the database, either manually or through dataload.	DATE		RCRAPP1	RCRAPP1_CREATE_DATE
APPLICATION_NUMBER	Application Number	Financial aid application unique sequence number.	NUMBER(3)		RCRAPP1	RCRAPP1_SEQ_NO
APPLICATION_RECEIPT_DATE	Application Receipt Date	Date that the processor received the aid application.	DATE		RCRAPP1	RCRAPP1_RCPT_DATE
APPLICATION_REVISION_RCPT_DATE	Application Revision Rcpt Date	Date that the processor received a request for revisions from the student.	DATE		RCRAPP1	RCRAPP1_REV_RCPT_DATE
APPLICATION_SIGNED_BY	Application Signed By	Indicates if the application was signed by the student and/or the parent(s).	VARCHAR2(1)		RCRAPP1	RCRAPP1_SIGNED
APPLICATION_SIGNED_BY_DESC	Application Signed By Description	Application signed description.	VARCHAR2(25)		CALCULATION	DECODE(RCRAPP1_SIGNED)
AT_RISK_OF_HOMELESSNESS	At Risk Of Homelessness		VARCHAR2(1)
AT_RISK_OF_HOMELESSNESS_DESC	At Risk Of Homelessness Description		VARCHAR2(4000)
BIRTH_DATE	Birth Date	Student's date of birth.	DATE		RCRAPP1	RCRAPP1_BIRTH_DATE
BUSINESS_DEBT	Business Debt	Amount of the student's outstanding debts against business and farm assets.	NUMBER(7)		RCRAPP1	RCRAPP1_BUS_FARM_DBT
BUSINESS_VALUE	Business Value	Current market value of the student's business and farm assets.	NUMBER(7)		RCRAPP1	RCRAPP1_BUS_FARM_VAL
CASH_SAVINGS	Cash Savings	Amount the student currently has in cash on hand and in savings and checking accounts.	NUMBER(7)		RCRAPP1	RCRAPP1_CASH_AMT
CHILD_SUPPORT_INCOME	Child Support Income	Student's base year income from child support received for all children.	NUMBER(6)		RCRAPP1	RCRAPP1_CHILD_SUPP
CITIZENSHIP_ELIGIBILITY_TYPE	Citizenship Eligibility Type	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(1)		RCRAPP1	RCRAPP1_CITZ_IND
CITIZENSHIP_ELIGIBIL_TYPE_DESC	Citizenship Eligibil Type Description	Citizen type description.	VARCHAR2(4000)
CITY	City	City of the student's address from the aid application.	VARCHAR2(50)		RCRAPP1	RCRAPP1_CITY
COLLEGE	College	College code identifying the school to which this financial aid applicant record has applied.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE
COLLEGE1	College 1	First college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_1
COLLEGE2	College 2	Second college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_2
COLLEGE3	College 3	Third college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_3
COLLEGE4	College 4	Fourth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_4
COLLEGE5	College 5	Fifth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_5
COLLEGE6	College 6	Sixth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_6
COLLEGE7	College 7	Seventh college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_7
COLLEGE8	College 8	Eighth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRAPP1	RCRAPP1_COLL_CDE_8
COLLEGE_CHOICE1	College Choice 1	Student's first choice of college planning to attend.	VARCHAR2(6)		RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1
COLLEGE_CHOICE2	College Choice 2	Student's second choice of college planning to attend.	VARCHAR2(6)		RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2
COLLEGE_CHOICE3	College Choice 3	Student's third choice of college planning to attend.	VARCHAR2(6)		RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
CURRENT_RECORD_IND	Current Record Indicator	Specifies that this is the current need analysis record.	VARCHAR2(1)		RCRAPP1	RCRAPP1_CURR_REC_IND
DATE_APPLICATION_COMPLETED	Date Application Completed	Date the application was completed.	DATE		RCRAPP1	RCRAPP1_COMPLETION_DATE
DEGREE_BY_JULY_IND	Degree By July Indicator	Indicates if the student will have a first bachelor's degree by July 1, of the start of the aid year.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP1_DEGREE_BY_JULY)
DIVORCED_PARENT_INFO_IND	Divorced Parent Information Indicator	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)
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
DRIVER_LICENSE_NUMBER	Driver License Number	Student's drivers license number.	VARCHAR2(20)		RCRAPP1	RCRAPP1_DRIVER_LIC_NO
DRIVER_LICENSE_STATE_PROVINCE	Driver License State Province	State or province that issued the student's drivers license.	VARCHAR2(2)		RCRAPP1	RCRAPP1_STAT_CODE_LIC
DRIVER_LICENSE_STATE_PROV_DESC	Driver License State Province Description	Description of the state or province in which the student holds a drivers license.	VARCHAR2(30)		STVSTAT	STVSTAT_DESC
EMANCIPATED_MINOR	Emancipated Minor		VARCHAR2(1)
EMANCIPATED_MINOR_DESC	Emancipated Minor Description		VARCHAR2(4000)
EXPECTED_ACADEMIC_YEAR_INCOME	Expected Academic Year Income	Student's expected academic year income from wages.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_ACYR_INC
EXPECTED_ACAD_YR_OTHER_INC	Expected Academic Year Other Inc	Student's expected academic year other taxable income.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_ACYR_OTH_TAX_INC
EXPECTED_ACAD_YR_UNTAX_INC	Expected Academic Year Untax Inc	Student's expected academic year nontaxable income and benefits.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_ACYR_UNTAX_INC
EXPECTED_ENROLL_STATUS	Expected Enrollment Status	Student's expected enrollment status for the school year.	VARCHAR2(1)		RCRAPP1	RCRAPP1_EXP_ENROLL_STATUS
EXPECTED_ENROLL_STATUS_DESC	Expected Enrollment Status Description	Description of the student's expected enrollment status.	VARCHAR2(4000)
EXPECTED_FATHER_INCOME	Expected Father Income	Expected calendar year income from work for the student's father.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_FATH_INC_FR_WRK
EXPECTED_MOTHER_INCOME	Expected Mother Income	Expected calendar year income from work for the student's mother.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_MOTH_INC_FR_WRK
EXPECTED_PARENT_OTHER_INCOME	Expected Parent Other Income	Expected calendar year other taxable income for the student's parents.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_PAR_OTH_TAX_INC
EXPECTED_PARENT_UNTAXED_INCOME	Expected Parent Untaxed Income	Expected calendar year nontaxable income and benefits for the student's parents.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_PAR_UNTAX_INC
EXPECTED_SPOUSE_SUMMER_INCOME	Expected Spouse Summer Income	Expected income from work during the summer for the student's spouse.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_SPS_SMR_INC
EXPECTED_SUMMER_INCOME	Expected Summer Income	Student's expected income from work for the summer.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_SMR_INC
EXPECTED_SUMMER_OTHER_INCOME	Expected Summer Other Income	Student's expected other taxable income for the summer.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_SMR_OTH_TAX_INC
EXPECTED_SUMMER_UNTAXED_INC	Expected Summer Untaxed Inc	Student's expected nontaxable income and benefits for the summer.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_SMR_UNTAX_INC
EXP_SPOUSE_ACAD_YEAR_INCOME	Expiration Spouse Academic Year Income	Student's spouse's academic year expected income from work.	NUMBER(6)		RCRAPP1	RCRAPP1_EXP_SPS_ACYR_INC
FAMILY_IN_COLLEGE	Family In College	Total number of family members in the student's household that attend college at least half time.	NUMBER(1)		RCRAPP1	RCRAPP1_NO_IN_COLL
FAMILY_SIZE	Family Size	Number of people in the student's household during the school year.	NUMBER(2)		RCRAPP1	RCRAPP1_FAM_MEMB
FATHER_WORK_INCOME	Father Work Income	Amount of income earned from work by the student's father in the base year.	NUMBER(6)		RCRAPP1	RCRAPP1_FATH_INC_FR_WRK
FIRST_NAME	First Name	Student's first name as reported on the aid application.	VARCHAR2(60)		RCRAPP1	RCRAPP1_FIRST_NAME
GOVERNMENT_BENEFITS	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(6)		RCRAPP1	RCRAPP1_SS_BENE
GOVERNMENT_BENEFIT_FOR_STUDENT	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(6)		RCRAPP1	RCRAPP1_PAR_SS_BENE_STU_ONLY
GOVERNMENT_FAMILY_AID	Government Family Financial 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(6)		RCRAPP1	RCRAPP1_AFDC
HOME_DEBT	Home Debt	Student's current outstanding debts against the home.	NUMBER(7)		RCRAPP1	RCRAPP1_HME_DBT
HOME_VALUE	Home Value	Current market value of the student's home.	NUMBER(7)		RCRAPP1	RCRAPP1_HME_VAL
HOUSING	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
HOUSING1	Housing 1	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
HOUSING1_DESC	Housing 1 Description	Housing code description.	VARCHAR2(4000)
HOUSING2	Housing 2	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
HOUSING2_DESC	Housing 2 Description	Housing code description.	VARCHAR2(4000)
HOUSING3	Housing 3	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
HOUSING3_DESC	Housing 3 Description	Housing code description.	VARCHAR2(4000)
HOUSING4	Housing 4	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
HOUSING4_DESC	Housing 4 Description	Housing code description.	VARCHAR2(4000)
HOUSING5	Housing 5	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
HOUSING5_DESC	Housing 5 Description	Housing code description.	VARCHAR2(4000)
HOUSING6	Housing 6	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
HOUSING6_DESC	Housing 6 Description	Housing code description.	VARCHAR2(4000)
HOUSING7	Housing 7	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
HOUSING7_DESC	Housing 7 Description	Housing code description.	VARCHAR2(4000)
HOUSING8	Housing 8	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
HOUSING8_DESC	Housing 8 Description	Housing code description.	VARCHAR2(4000)
HOUSING_DESC	Housing Description	Institutional housing code description.	VARCHAR2(4000)
INCOME_TAX_PAID	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(6)		RCRAPP1	RCRAPP1_US_INC_TAX_PD
INCOME_WORK	Income Work	Amount of the student's base year income from working.	NUMBER(6)		RCRAPP1	RCRAPP1_INC_FR_WRK
INTERFACE_TAPE_CODE	Interface Tape Code	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).	VARCHAR2(7)		RCRAPP1	RCRAPP1_INFC_CODE
INTERFACE_TAPE_DESC	Interface Tape Description	Description of the interface tape code.	VARCHAR2(30)		RTVINFC	RTVINFC_DESC
INTERNATIONAL_PHONE_NUMBER	International Phone Number		VARCHAR2(15)
LAST_NAME	Last Name	Student's last name as reported on the aid application.	VARCHAR2(60)		RCRAPP1	RCRAPP1_LAST_NAME
LEGAL_DEPENDENT_IND	Legal Dependent Indicator	Indicates whether or not the student has legal dependents other than a spouse for determining dependency status.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP1_HAS_LEGAL_DEPEND)
LEGAL_GUARDIANSHIP	Legal Guardianship		VARCHAR2(1)
LEGAL_GUARDIANSHIP_DESC	Legal Guardianship Description		VARCHAR2(4000)
LINE2_ATTEND_COLLEGE	Line 2 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
LINE2_ATTEND_COLLEGE_DESC	Line 2 Attend College Description	Line2 attends college description.	VARCHAR2(20)
LINE2_RELATIONSHIP	Line 2 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
LINE2_RELATIONSHIP_DESC	Line 2 Relationship Description	Relationship code description.	VARCHAR2(30)		CALCULATION	DECODE(RCRAPP1_LINE2_RELSHIP)
LINE3_ATTEND_COLLEGE	Line 3 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
LINE3_ATTEND_COLLEGE_DESC	Line 3 Attend College Description	Attends college description.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP1_LINE3_ATTEND_COLL)
LINE3_RELATIONSHIP	Line 3 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
LINE3_RELATIONSHIP_DESC	Line 3 Relationship Description	Relationship code description.	VARCHAR2(30)		CALCULATION	DECODE(RCRAPP1_LINE3_RELSHIP)
LINE4_ATTEND_COLLEGE	Line 4 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
LINE4_ATTEND_COLLEGE_DESC	Line 4 Attend College Description	Attends college description.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP1_LINE4_ATTEND_COLL)
LINE4_RELATIONSHIP	Line 4 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
LINE4_RELATIONSHIP_DESC	Line 4 Relationship Description	Relationship code description.	VARCHAR2(30)		CALCULATION	DECODE(RCRAPP1_LINE4_RELSHIP)
LINE5_ATTEND_COLLEGE	Line 5 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
LINE5_ATTEND_COLLEGE_DESC	Line 5 Attend College Description	Attends college description.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP1_LINE5_ATTEND_COLL)
LINE5_RELATIONSHIP	Line 5 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
LINE5_RELATIONSHIP_DESC	Line 5 Relationship Description	Relationship code description.	VARCHAR2(30)		CALCULATION	DECODE(RCRAPP1_LINE5_RELSHIP)
LINE6_ATTEND_COLLEGE	Line 6 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
LINE6_ATTEND_COLLEGE_DESC	Line 6 Attend College Description	Attends college description.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP1_LINE6_ATTEND_COLL)
LINE6_RELATIONSHIP	Line 6 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
LINE6_RELATIONSHIP_DESC	Line 6 Relationship Description	Relationship code description.	VARCHAR2(30)		CALCULATION	DECODE(RCRAPP1_LINE6_RELSHIP)
LINE7_ATTEND_COLLEGE	Line 7 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
LINE7_ATTEND_COLLEGE_DESC	Line 7 Attend College Description	Attends college description.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP1_LINE7_ATTEND_COLL)
LINE7_RELATIONSHIP	Line 7 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
LINE7_RELATIONSHIP_DESC	Line 7 Relationship Description	Relationship code description.	VARCHAR2(30)		CALCULATION	DECODE(RCRAPP1_LINE7_RELSHIP)
LINE8_ATTEND_COLLEGE	Line 8 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
LINE8_ATTEND_COLLEGE_DESC	Line 8 Attend College Description	Attends college description.	VARCHAR2(20)		CALCULATION	DECODE(RCRAPP1_LINE8_ATTEND_COLL)
LINE8_RELATIONSHIP	Line 8 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
LINE8_RELATIONSHIP_DESC	Line 8 Relationship Description	Relationship code description.	VARCHAR2(30)		CALCULATION	DECODE(RCRAPP1_LINE8_RELSHIP)
MAILING_CITY	Mailing City		VARCHAR2(21)
MAILING_NATION	Mailing Nation		VARCHAR2(2)
MAILING_NATION_DESC	Mailing Nation Description		VARCHAR2(30)
MAILING_POSTAL_CODE	Mailing Postal Code		VARCHAR2(17)
MAILING_STATE_PROVINCE	Mailing State Province		VARCHAR2(2)
MAILING_STATE_PROVINCE_DESC	Mailing State Province Description		VARCHAR2(30)
MAILING_STREET	Mailing Street		VARCHAR2(35)
MARITAL_STATUS	Marital Status	Student's reported marital status.	VARCHAR2(1)		RCRAPP1	RCRAPP1_MRTL_STATUS
MARITAL_STATUS_DESC	Marital Status Description	Marital status description associated with the student.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_MRTL_STATUS)
MEDICAL_DENTAL_EXPENSE	Medical Dental Expense	Student's reported base year medical and dental expenses not paid by insurance.	NUMBER(6)		RCRAPP1	RCRAPP1_MED_DEN_EXP
MIDDLE_INITIAL	Middle Initial	The student's middle initial as reported on the aid application.	VARCHAR2(60)		RCRAPP1	RCRAPP1_MI
MIF_DESC	MIF Description	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
MIF_VALUE	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
MILTARY_ACTIVE_DUTY	Miltary Active Duty		VARCHAR2(1)
MILTARY_ACTIVE_DUTY_DESC	Miltary Active Duty Description		VARCHAR2(4000)
MOTHER_WORK_INCOME	Mother Work Income	Mother's reported base year income from work.	NUMBER(6)		RCRAPP1	RCRAPP1_MOTH_INC_FR_WRK
NAME_PREFIX	Name Prefix	Student's title. (Mr. or Ms.)	VARCHAR2(5)		CALCULATION	DECODE(RCRAPP1_TITLE)
NUMBER_OF_EXEMPTIONS	Number Of Exemptions	Number of tax exemptions claimed by the student on their federal tax return.	NUMBER(2)		RCRAPP1	RCRAPP1_NO_EXEMPT
OLDER_THAN_24_IND	Older Than 24 Indicator	Indicates whether or not the student is older than 24 years old.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP1_BORN_BEFORE_1_1_XX)
ORIGINAL_COMPUTE_DATE	Original Compute Date	Date that the application was originally processed by the processor.	DATE		RCRAPP1	RCRAPP1_ORIG_COMP_DATE
OTHER_NON_REPORTED_MONEY	Other Non Reported Money		NUMBER
OTHER_UNTAXED_INCOME	Other Untaxed Income	Student's reported base year other untaxed income and benefits.	NUMBER(6)		RCRAPP1	RCRAPP1_OTH_UNTAX_INC
PARENT_ADJUSTED_GROSS_INCOME	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(7)		RCRAPP1	RCRAPP1_PAR_US_INC
PARENT_BUSINESS_INCOME	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(6)		RCRAPP1	RCRAPP1_PAR_BUS_FARM_INC
PARENT_CASH_ASSET	Parent Cash Asset	Value of cash, savings and checking accounts reported by the student's parents.	NUMBER(7)		RCRAPP1	RCRAPP1_PAR_CASH_AMT
PARENT_CHILD_SUPPORT	Parent Child Support	Amount of income received by the student's parents from child support for all children in the base year.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_CHILD_SUPP
PARENT_CHILD_SUPPORT_INCOME	Parent Child Support Income		NUMBER
PARENT_DIVIDEND_INCOME	Parent Dividend Income	Amount of income received from dividends by the student's parents in the base year.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_DIV_INC
PARENT_FAMILY_IN_COLLEGE	Parent Family In College	Number of people in the parents household that will be enrolled in college at least half-time.	NUMBER(1)		RCRAPP1	RCRAPP1_PAR_NO_IN_COLL
PARENT_FAMILY_SIZE	Parent Family Size	Number of family members in the parents household.	NUMBER(2)		RCRAPP1	RCRAPP1_PAR_FAM_MEMB
PARENT_GOVERNMENT_BENEFITS	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(6)		RCRAPP1	RCRAPP1_PAR_SS_BENE
PARENT_GOVERNMENT_FAMILY_AID	Parent Government Family Financial 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(6)		RCRAPP1	RCRAPP1_PAR_AFDC
PARENT_HOME_AMOUNT_PAID	Parent Home Amount Paid	Amount that the student's parents paid for their home.	NUMBER(7)		RCRAPP1	RCRAPP1_PAR_HME_PURCH_AMT
PARENT_HOME_DEBT	Parent Home Debt	Current outstanding debts against the home for the student's parents.	NUMBER(7)		RCRAPP1	RCRAPP1_PAR_HME_DBT
PARENT_HOME_VALUE	Parent Home Value	Current market value of the student's parents home.	NUMBER(7)		RCRAPP1	RCRAPP1_PAR_HME_VAL
PARENT_HOME_YEAR_PURCHASED	Parent Home Year Purchased	Last two digits of the year that the student's parents purchased their home.	NUMBER(4)		RCRAPP1	RCRAPP1_PAR_HME_YR_PURCH
PARENT_HOUSING_STATUS	Parent Housing Status	Housing Status of the parent.	VARCHAR2(1)		RCRAPP1	RCRAPP1_PAR_HOUS_STAT
PARENT_HOUSING_STATUS_DESC	Parent Housing Status Description	Parent housing status description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_PAR_HOUS_STAT)
PARENT_INCOME_ADJUSTMENTS	Parent Income Adjustments	Amount that the parents reported as adjustments to income on their federal tax return.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_ADJ_TO_INC
PARENT_INCOME_TAX_PAID	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(6)		RCRAPP1	RCRAPP1_PAR_US_INC_TAX_PD
PARENT_INTEREST_INCOME	Parent Interest Income	Amount of interest income received in the base year by the student's parents.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_INT_INC
PARENT_MARITAL_STATUS	Parent Marital Status	Marital status for the student's parents.	VARCHAR2(1)		RCRAPP1	RCRAPP1_PAR_MRTL_STATUS
PARENT_MARITAL_STATUS_DESC	Parent Marital Status Description	Parents marital status description.	VARCHAR2(4000)
PARENT_MEDICAL_DENTAL_EXPENSE	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(6)		RCRAPP1	RCRAPP1_PAR_MED_DEN_EXP
PARENT_NATION_OF_RESIDENCE	Parent Nation Of Residence		VARCHAR2(2)
PARENT_NATION_RESIDENCE_DESC	Parent Nation Residence Description		VARCHAR2(30)
PARENT_NO_CHILD_SEC_TUITION_PD	Parent Number Child Second Tuition Pd	Number of children in the parents household that incurred elementary, jr. high, or high school tuition expenses.	NUMBER(1)		RCRAPP1	RCRAPP1_PAR_NO_CHILD_TUIT
PARENT_NUMBER_OF_EXEMPTIONS	Parent Number Of Exemptions	Number of income tax exemptions claimed by the student's parents on their federal tax return.	NUMBER(2)		RCRAPP1	RCRAPP1_PAR_NO_EXEMPT
PARENT_OTHER_INCOME	Parent Other Income	Other taxable income reported by the student's parents from alimony, capital gains, pensions, annuities, etc.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_OTH_TAX_INC
PARENT_OTHER_UNTAXED_INCOME	Parent Other Untaxed Income	Other untaxed income received in the base year by the student's parents.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_OTH_UNTAX_INC
PARENT_REMARRIAGE_DATE	Parent Remarriage Date	Date parent remarried.	DATE		RCRAPP1	RCRAPP1_PAR_REMARRIAGE_DATE
PARENT_RETIREMENT_PLAN_DISTRIB	Parent Retirement Plan Distribution		NUMBER
PARENT_STATE_OF_RESIDENCE	Parent State Of Residence	State or province of legal residence for the student's parents.	VARCHAR2(2)		RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES
PARENT_STATE_OF_RESIDENCE_DESC	Parent State Of Residence Description	Parents stare or province of legal residence description.	VARCHAR2(30)		STVSTAT	STVSTAT_DESC
PARENT_TAX_RETURN_TYPE	Parent Tax Return Type	Type of federal income tax return form the student's parents filed.	VARCHAR2(2)		RCRAPP1	RCRAPP1_PAR_TAX_FORM_IND
PARENT_TAX_RETURN_TYPE_DESC	Parent Tax Return Type Description	Parent tax return type description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_PAR_TAX_FORM_IND)
PARENT_TUITION_PAID	Parent Tuition Paid	Amount of elementary, jr. high, and high school tuition paid by the student's parents in the base year.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_TUIT_PD
PARENT_UNTAXED_PENSIONS	Parent Untaxed Pensions		NUMBER
PARENT_VETERAN_NON_ED_BENEFIT	Parent Veteran Non Ed Benefit		NUMBER
PARENT_WAGES	Parent Wages	Amount of wages, salaries, tips, etc. in the base year reported by the student's parents on their federal tax return.	NUMBER(6)		RCRAPP1	RCRAPP1_PAR_WAGES
PERMIT_DRAFT_REGISTRATION_IND	Permit Draft Registration Indicator	Indicates whether or not the student gave permission to the processor to send data to the Selective Service for draft registration.	VARCHAR2(1)		RCRAPP1	RCRAPP1_PERMIT_DRAFT_REG
PERM_RESIDENCY_CONFIRMED_IND	Perm Residency Confirmed Indicator	Indicates whether or not the student's permanent resident status has been confirmed by the federal government.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP1_INS)
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RCRAPP1	RCRAPP1_PIDM
PHONE_AREA	Phone Area	Area code of the student's home telephone number.	VARCHAR2(6)		RCRAPP1	RCRAPP1_PHONE_AREA
PHONE_NUMBER	Phone Number	Student's home telephone number without area code.	VARCHAR2(12)		RCRAPP1	RCRAPP1_PHONE_NO
POSTAL_CODE	Postal Code	Postal code for the student's address.	VARCHAR2(30)		RCRAPP1	RCRAPP1_ZIP
REQUESTED_AID_FALL	Requested Financial Aid Fall	Indicates if the student requested aid for the fall term.	VARCHAR2(1)		RCRAPP1	RCRAPP1_RQST_FA_FALL_THIS_YR
REQUESTED_AID_FALL_DESC	Requested Financial Aid Fall Description	Requested aid for the fall description.	VARCHAR2(4000)
REQUESTED_AID_NEXT_SUMMER	Requested Financial 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
REQUESTED_AID_NEXT_SUMMER_DESC	Requested Financial Aid Next Summer Description	Requested aid for the next summer description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_NEXT_YR)
REQUESTED_AID_PRECEDING_SUMMER	Requested Financial Aid Preceding Summer	Indicates if the student requested aid for the summer term that preceded the normal school year.	VARCHAR2(1)		RCRAPP1	RCRAPP1_RQST_FA_SUMMER_THIS_YR
REQUESTED_AID_PREC_SUMMER_DESC	Requested Financial Aid Prec Summer Description	Requested aid for the preceding summer description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_RQST_FA_SUMMER_THIS_YR)
REQUESTED_AID_SPRING	Requested Financial Aid Spring	Indicates if the student requested aid for the spring term.	VARCHAR2(1)		RCRAPP1	RCRAPP1_RQST_FA_SPRING_NEXT_YR
REQUESTED_AID_SPRING_DESC	Requested Financial Aid Spring Description	Requested aid for the spring description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_RQST_FA_SPRING_NEXT_YR)
REQUESTED_AID_WINTER	Requested Financial Aid Winter	Indicates if the student requested aid for the winter term.	VARCHAR2(1)		RCRAPP1	RCRAPP1_RQST_FA_WINTER_NEXT_YR
REQUESTED_AID_WINTER_DESC	Requested Financial Aid Winter Description	Requested aid for the winter description.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_RQST_FA_WINTER_NEXT_YR)
RETIREMENT_PLAN_DISTRIBUTION	Retirement Plan Distribution		NUMBER
REVISION_COMPUTE_DATE	Revision Compute Date	Date that the processor processed a revised report for the applicant.	DATE		RCRAPP1	RCRAPP1_REV_COMP_DATE
SELECTED_FOR_VERIFICATION_IND	Selected for Verification Indicator	Indicates whether or not the student has been selected for verification by the Federal Government or by the institution.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP1_VERIFICATION_MSG)
SPOUSE_INCOME_WORK	Spouse Income Work	Amount of income earned from work by the student's spouse in the base year.	NUMBER(6)		RCRAPP1	RCRAPP1_SPS_INC_FR_WRK
START_RESIDENCE_DATE	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
STATE_OF_RESIDENCE	State Of Residence	Student's state or province of legal residence.	VARCHAR2(2)		RCRAPP1	RCRAPP1_STAT_CODE_RES
STATE_OF_RESIDENCE_DESC	State Of Residence Description	Name of the student's state or province of legal residence.	VARCHAR2(30)		STVSTAT	STVSTAT_DESC
STATE_PROVINCE	State Province	State or province associated with the student's address.	VARCHAR2(2)		RCRAPP1	RCRAPP1_STAT_CODE
STATE_PROVINCE_DESC	State Province Description	State or province name associated with the student's address.	VARCHAR2(30)		STVSTAT	STVSTAT_DESC
STREET	Street	Student's number and street for their address as reported on their aid application.	VARCHAR2(75)		RCRAPP1	RCRAPP1_ADDR
TAX_ID	Tax ID	Student's tax identification number assigned by their home federal government as reported on the aid application.	VARCHAR2(15)		RCRAPP1	RCRAPP1_SSN
TAX_RETURN_TYPE	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
TAX_RETURN_TYPE_DESC	Tax Return Type Description	Description of the tax return type.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_TAX_FORM_IND)
TRANSACTION_NUMBER	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
UNACCOMPANIED_YOUTH_HUD	Unaccompanied Youth Hud		VARCHAR2(1)
UNACCOMPANIED_YOUTH_HUD_DESC	Unaccompanied Youth Hud Description		VARCHAR2(4000)
UNACCOMPANIED_YOUTH_SCHL_DESC	Unaccompanied Youth Schl Description		VARCHAR2(4000)
UNACCOMPANIED_YOUTH_SCHOOL	Unaccompanied Youth School		VARCHAR2(1)
UNTAXED_PENSIONS	Untaxed Pensions		NUMBER
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		RCRAPP1	RCRAPP1_USER_ID
VERIFICATION_PRIORITY	Verification Priority	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(4)		RCRAPP1	RCRAPP1_VERIFICATION_PRTY
VETERAN_BENEFITS_TYPE	Veteran Benefits Type		VARCHAR2(1)
VETERAN_BENEFITS_TYPE_DESC	Veteran Benefits Type Description		VARCHAR2(4000)
VETERAN_IND	Veteran Indicator	Indicates if the student is a veteran of the Armed Forces.	VARCHAR2(1)		CALCULATION	DECODE(RCRAPP1_US_VET)
VETERAN_MONTHLY_OTHER_BENEFITS	Veteran Monthly Other Benefits		NUMBER
VETERAN_NON_EDUCATION_BENEFIT	Veteran Non Education Benefit		NUMBER
VETERAN_OTHER_BENEFITS	Veteran Other Benefits	Amount per month from other VA programs.	NUMBER(4)		RCRAPP1	RCRAPP1_OTH_VA_AMT
VETERAN_OTHER_BENEFITS_MONTHS	Veteran Other Benefits Months		NUMBER
VETERAN_OTH_BEN_NO_MONTHS	Veteran Oth Ben Number Months	Number of months that the other VA benefits will be received during the award year.	NUMBER(2)		RCRAPP1	RCRAPP1_OTH_VA_MTH
VETERAN_RECEIVING_BENEFITS	Veteran Receiving Benefits		VARCHAR2(1)
VETERAN_RECEIVING_BENEFIT_DESC	Veteran Receiving Benefit Description		VARCHAR2(4000)
WARD_OF_COURT	Ward Of Court		VARCHAR2(1)
WARD_OF_COURT_DESC	Ward Of Court Description		VARCHAR2(4000)
WARD_OF_COURT_IND	Ward of Court Indicator	Indicates if the student reported being a ward of the court or is an orphan.	VARCHAR2(1)
YEAR_IN_COLLEGE	Year In College	Year of study (first, second, etc.) that the student enrolls in this year.	VARCHAR2(1)		RCRAPP1	RCRAPP1_YR_IN_COLL
YEAR_IN_COLLEGE_DESC	Year In College Description	Description of the year of study.	VARCHAR2(4000)		CALCULATION	DECODE(RCRAPP1_YR_IN_COLL)
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: