Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRIMP1	RCRIMP1_ACTIVITY_DATE	NO	NO
ADDITIONAL_COLLEGE_NAME10	The tenth school name if more than ten school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRIMP1	RCRIMP1_ADDL_COLL_NAME_10	NO	NO
ADDITIONAL_COLLEGE_NAME9	The ninth school name if more than ten school codes were requested through an original application or an additional college request.	VARCHAR2(256)	RCRIMP1	RCRIMP1_ADDL_COLL_NAME_9	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)	RCRIMP1	RCRIMP1_AIDY_CODE	NO	NO
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRIMP1	RCRIMP1_SEQ_NO	NO	NO
APPLICATION_TYPE	Indicates the type (regular or renewal) of application.	VARCHAR2(1)	RCRIMP1	RCRIMP1_APPLIC_TYPE	NO	NO
APPLICATION_TYPE_DESC	Application type descriptioni.	VARCHAR2(15)	CALCULATION	DECODE(RCRIMP1_APPLIC_TYPE)	NO	NO
COLLEGE10	Tenth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRIMP1	RCRIMP1_COLL_CDE_10	NO	NO
COLLEGE9	Ninth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)	RCRIMP1	RCRIMP1_COLL_CDE_9	NO	NO
COLLEGE_NAME10	The tenth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRIMP1	RCRIMP1_COLL_NAME_10	NO	NO
COLLEGE_NAME9	The ninth college/program name listed by the student on the aid application for receipt of information.	VARCHAR2(256)	RCRIMP1	RCRIMP1_COLL_NAME_9	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
EARNED_INCOME_CREDIT	Earned income credit reported by the student.	NUMBER	RCRIMP1	RCRIMP1_EIC	NO	NO
EXPECTED_GRANTS_SCHOLARSHIP	Total amount of grants, scholarships, fellowships, etc. expected from other than the colleges or universities to which the student is applying.	NUMBER	RCRIMP1	RCRIMP1_EXP_GRANT_SCHLRSHP	NO	NO
EXPECTED_OTHER_CONTRIB	Total contribution expected by the student from other relatives, parents of the spouse, and all other sources.	NUMBER	RCRIMP1	RCRIMP1_EXP_OTH_CTRB	NO	NO
EXPECTED_PARENT_CONTRIB	Amount of contribution expected from the parents of the student.	NUMBER	RCRIMP1	RCRIMP1_EXP_PAR_CTRB	NO	NO
EXPECTED_TUITION_BENEFITS	Total tuition benefits that the student expects to receive from parents and/or the student or spouse employer.	NUMBER	RCRIMP1	RCRIMP1_EXP_TUIT_BENE	NO	NO
EXPLANATIONS_TEXT	Any actual explanations and special circumstances text provided by the applicant.	VARCHAR2(2000)	RCRIMP1	RCRIMP1_EXPLANATIONS_TEXT	NO	NO
FATHER_NAME	The name of the parent providing the information on the PROFILE and assigned to the traditional father position.	VARCHAR2(20)	RCRIMP1	RCRIMP1_FATHER_NAME	NO	NO
FINANCIAL_AID_STATUS	Indicates the student financial aid status.	VARCHAR2(1)	RCRIMP1	RCRIMP1_FIN_AID_STATUS	NO	NO
FINANCIAL_AID_STATUS_DESC	Financial aid status description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_FIN_AID_STATUS)	NO	NO
FOREIGN_ADDRESS_IND	Indicates that the student lives outside the U.S.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_FOREIGN_ADDR_IND)	NO	NO
FOREIGN_COUNTRY	Identifies the country for students that live outside the U.S.	VARCHAR2(25)	RCRIMP1	RCRIMP1_COUNTRY	NO	NO
FOREIGN_POSTAL_CODE	Identifies the foreign postal code for students that live outside the U.S.	VARCHAR2(17)	RCRIMP1	RCRIMP1_FOREIGN_POSTAL_CDE	NO	NO
HOPE_LL_CREDITS	Hope and Lifetime Learning tax credits as reported on student's tax return.	NUMBER	RCRIMP1	RCRIMP1_HOPE_LL_CREDIT	NO	NO
HOUSING10	Housing code for the school listed tenth on the application indicating the student expected place of residence at school.	VARCHAR2(1)	RCRIMP1	RCRIMP1_HOUS_CDE_10	NO	NO
HOUSING10_DESC	Housing code description.	VARCHAR2(20)	CALCULATION	DECODE(RCRIMP1_HOUS_CDE_10)	NO	NO
HOUSING9	Housing code for the school listed ninth on the application indicating the student expected place of residence at school.	VARCHAR2(1)	RCRIMP1	RCRIMP1_HOUS_CDE_9	NO	NO
HOUSING9_DESC	Housing code description.	VARCHAR2(20)	CALCULATION	DECODE(RCRIMP1_HOUS_CDE_9)	NO	NO
IM_ASSUMPTION_MESSAGE1	First IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_1	NO	NO
IM_ASSUMPTION_MESSAGE10	Tenth IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_10	NO	NO
IM_ASSUMPTION_MESSAGE2	Second IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_2	NO	NO
IM_ASSUMPTION_MESSAGE3	Third IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_3	NO	NO
IM_ASSUMPTION_MESSAGE4	Fourth IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_4	NO	NO
IM_ASSUMPTION_MESSAGE5	Fifth IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_5	NO	NO
IM_ASSUMPTION_MESSAGE6	Sixth IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_6	NO	NO
IM_ASSUMPTION_MESSAGE7	Seventh IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_7	NO	NO
IM_ASSUMPTION_MESSAGE8	Eighth IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_8	NO	NO
IM_ASSUMPTION_MESSAGE9	Ninth IM assumption returned by INAS.	VARCHAR2(4)	RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_9	NO	NO
IM_CUM_ED_SAVING_ALLOWANCE	Amount of student's Cumulative Education Savings Allowance.	NUMBER	RCRIMP1	RCRIMP1_CUM_ED_SAVINGS	NO	NO
IM_CUST_PARENT_CONTRIB_ASSET	Custodial parent's contribution from assets using options.	NUMBER	RCRIMP1	RCRIMP1_PAR_OPT_CTRB_ASSETS	NO	NO
IM_CUST_PARENT_CONTRIB_INCOME	Custodial parent's contribution from income using options.	NUMBER	RCRIMP1	RCRIMP1_PAR_OPT_CTRB_INC	NO	NO
IM_CUST_PARENT_PERCENT_INCOME	Custodial parent's percentage of income using options.	NUMBER	RCRIMP1	RCRIMP1_CUST_PAR_OPT_PCT_INC	NO	NO
IM_CUST_PARENT_TOTAL_CONTRIB	Custodial parent's total contribution using options.	NUMBER	RCRIMP1	RCRIMP1_PAR_OPT_TOT_CTRB	NO	NO
IM_ED_SAVING_ALLOWANCE	Amount of student's Annual Education Savings Allowance.	NUMBER	RCRIMP1	RCRIMP1_ANNUAL_ED_SAVINGS	NO	NO
IM_EMERG_RES_ALLOWANCE	Amount of student's Emergency Reserve Allowance.	NUMBER	RCRIMP1	RCRIMP1_EMERG_RES_ALLOW	NO	NO
IM_LARGE_BUSINESS_IND	Student owns large business indicator.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_SMALL_BUSINESS)	NO	NO
IM_LOW_INCOME_ALLOWANCE	Amount of student's low income allowance.	NUMBER	RCRIMP1	RCRIMP1_LOW_INC_ALLOW	NO	NO
IM_PARENT_CUM_ED_SAVING_ALLOW	Amount of parents' Cumulative Education Savings Allowance.	NUMBER	RCRIMP1	RCRIMP1_PAR_CUM_ED_SAVINGS	NO	NO
IM_PARENT_ED_SAVING_ALLOWANCE	Amount of parents' Annual Education Savings Allowance.	NUMBER	RCRIMP1	RCRIMP1_PAR_ANNUAL_ED_SAVINGS	NO	NO
IM_PARENT_EMERG_RES_ALLOWANCE	Amount of parents' Emergency Reserve Allowance.	NUMBER	RCRIMP1	RCRIMP1_PAR_EMERG_RES_ALLOW	NO	NO
IM_PARENT_LARGE_BUSINESS_IND	Parent owns large business indicator.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_PAR_SMALL_BUSINESS)	NO	NO
IM_PARENT_LOW_INCOME_ALLOWANCE	Amount of parents' low income allowance.	NUMBER	RCRIMP1	RCRIMP1_PAR_LOW_INC_ALLOW	NO	NO
IM_PARENT_PARENTS_COLLEGE_NO	Indicates how many parents will be in college at least half-time during the school year.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_PRNT_IN_COLL	NO	NO
IM_PARENT_PRE_PAID_TUITION_AMT	Value of parent's assets in prepaid tuition plans for the student.	NUMBER	RCRIMP1	RCRIMP1_PAR_STU_PRE_TUIT	NO	NO
IM_PARENT_SELF_EMPLOYED_IND	Parent self employed indicator.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_PAR_SELF_EMPLOYED)	NO	NO
IM_SELF_EMPLOYED_IND	Student self employed indicator.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP)	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)	RCRIMP1	RCRIMP1_INFC_CODE	NO	NO
ITEMIZED_TAX_DEDUCTION	Itemized deductions reported by the student.	NUMBER	RCRIMP1	RCRIMP1_ITEM_DEDUCTNS	NO	NO
LINE2_AGE	Age of the person listed second on the family member matrix.	NUMBER	RCRIMP1	RCRIMP1_LINE2_AGE	NO	NO
LINE2_SCHOOL_TYPE	Type of school attended by the person listed second on the family member matrix.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LINE2_SCHL_TYPE	NO	NO
LINE2_SCHOOL_TYPE_DESC	School type description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_LINE2_SCHL_TYPE)	NO	NO
LINE3_AGE	Age of the person listed third on the family member matrix.	NUMBER	RCRIMP1	RCRIMP1_LINE3_AGE	NO	NO
LINE3_SCHOOL_TYPE	Type of school attended by the person listed third on the family member matrix.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LINE3_SCHL_TYPE	NO	NO
LINE3_SCHOOL_TYPE_DESC	School type description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_LINE3_SCHL_TYPE)	NO	NO
LINE4_AGE	Age of the person listed fourth on the family member matrix.	NUMBER	RCRIMP1	RCRIMP1_LINE4_AGE	NO	NO
LINE4_NAME	The name of the person listed forth on the family member's matrix (CSS source and format only).	VARCHAR2(20)	RCRIMP1	RCRIMP1_LINE4_NAME	NO	NO
LINE4_SCHOOL_TYPE	Type of school attended by the person listed fourth on the family member matrix.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LINE4_SCHL_TYPE	NO	NO
LINE4_SCHOOL_TYPE_DESC	School type description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_LINE4_SCHL_TYPE)	NO	NO
LINE5_AGE	Age of the person listed fifth on the family member matrix.	NUMBER	RCRIMP1	RCRIMP1_LINE5_AGE	NO	NO
LINE5_NAME	The name of the person listed fifth on the family member's matrix (CSS source and format only).	VARCHAR2(20)	RCRIMP1	RCRIMP1_LINE5_NAME	NO	NO
LINE5_SCHOOL_TYPE	Type of school attended by the person listed fifth on the family member matrix.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LINE5_SCHL_TYPE	NO	NO
LINE5_SCHOOL_TYPE_DESC	School type description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_LINE5_SCHL_TYPE)	NO	NO
LINE6_AGE	Age of the person listed sixth on the family member matrix.	NUMBER	RCRIMP1	RCRIMP1_LINE6_AGE	NO	NO
LINE6_NAME	The name of the person listed sixth on the family member's matrix (CSS source and format only).	VARCHAR2(20)	RCRIMP1	RCRIMP1_LINE6_NAME	NO	NO
LINE6_SCHOOL_TYPE	Type of school attended by the person listed sixth on the family member matrix.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LINE6_SCHL_TYPE	NO	NO
LINE6_SCHOOL_TYPE_DESC	School type description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_LINE6_SCHL_TYPE)	NO	NO
LINE7_AGE	Age of the person listed seventh on the family member matrix.	NUMBER	RCRIMP1	RCRIMP1_LINE7_AGE	NO	NO
LINE7_NAME	The name of the person listed seventh on the family member's matrix (CSS source and format only).	VARCHAR2(20)	RCRIMP1	RCRIMP1_LINE7_NAME	NO	NO
LINE7_SCHOOL_TYPE	Type of school attended by the person listed seventh on the family member matrix.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LINE7_SCHL_TYPE	NO	NO
LINE7_SCHOOL_TYPE_DESC	School type description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_LINE7_SCHL_TYPE)	NO	NO
LINE8_AGE	Age of the person listed eighth on the family member matrix.	NUMBER	RCRIMP1	RCRIMP1_LINE8_AGE	NO	NO
LINE8_NAME	The name of the person listed eighth on the family member's matrix (CSS source and format only).	VARCHAR2(20)	RCRIMP1	RCRIMP1_LINE8_NAME	NO	NO
LINE8_SCHOOL_TYPE	Type of school attended by the person listed eighth on the family member matrix.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LINE8_SCHL_TYPE	NO	NO
LINE8_SCHOOL_TYPE_DESC	School type description.	VARCHAR2(25)	CALCULATION	DECODE(RCRIMP1_LINE8_SCHL_TYPE)	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
MOTHER_NAME	The name of the parent providing the information on the PROFILE and assigned to the traditional mother position.	VARCHAR2(20)	RCRIMP1	RCRIMP1_MOTHER_NAME	NO	NO
NATION_OF_CITIZENSHIP	Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting.	VARCHAR2(15)	RCRIMP1	RCRIMP1_CITZ_COUNTRY	NO	NO
NONCUSTODIAL_CONTRIBUTION	Reported contribution for the non-custodial parent.	NUMBER	RCRIMP1	RCRIMP1_PC_NON_CUST_PAR	NO	NO
ONLINE_SIGNATURE_IND	Indicates that student completed online version of PROFILE and the signature is electronic, or blank.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_ONLINE_SIG)	NO	NO
PARENT_ASSET_SIBLING	Identifies the amount of parents' assets held in the name of a student's siblings.	NUMBER	RCRIMP1	RCRIMP1_PAR_SIBLING_ASSETS	NO	NO
PARENT_BUS_TAX_RTRN_CODE1	The tax return filed for the first business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_1	NO	NO
PARENT_BUS_TAX_RTRN_CODE1_DESC	Parent's Business Tax Return Code 1 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE2	The tax return filed for the second business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_2	NO	NO
PARENT_BUS_TAX_RTRN_CODE2_DESC	Parent's Business Tax Return Code 2 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE3	The tax return filed for the third business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_3	NO	NO
PARENT_BUS_TAX_RTRN_CODE3_DESC	Parent's Business Tax Return Code 3 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE4	The tax return filed for the fourth business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_4	NO	NO
PARENT_BUS_TAX_RTRN_CODE4_DESC	Parent's Business Tax Return Code 4 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE5	The tax return filed for the fifth business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_5	NO	NO
PARENT_BUS_TAX_RTRN_CODE5_DESC	Parent's Business Tax Return Code 5 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE6	The tax return filed for the sixth business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_6	NO	NO
PARENT_BUS_TAX_RTRN_CODE6_DESC	Parent's Business Tax Return Code 6 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE7	The tax return filed for the seventh business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_7	NO	NO
PARENT_BUS_TAX_RTRN_CODE7_DESC	Parent's Business Tax Return Code 7 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE8	The tax return filed for the eighth business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_8	NO	NO
PARENT_BUS_TAX_RTRN_CODE8_DESC	Parent's Business Tax Return Code 8 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_BUS_TAX_RTRN_CODE9	The tax return filed for the ninth business reported by the parents.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_BUS_TAX_RTRN_CDE_9	NO	NO
PARENT_BUS_TAX_RTRN_CODE9_DESC	Parent's Business Tax Return Code 9 description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
PARENT_DIVORCE_YEAR	Year of parents' divorce.	VARCHAR2(4)	RCRIMP1	RCRIMP1_PAR_YR_DIV	NO	NO
PARENT_ED_LOANS_REPAYMENT	Amount that the parents are spending for repayment of educational loans during the current year.	NUMBER	RCRIMP1	RCRIMP1_PAR_ED_LN_RPAY_AMT	NO	NO
PARENT_EXP_CHILD_SUPPORT_PAID	Expected child support paid to be paid by the parents.	NUMBER	RCRIMP1	RCRIMP1_EXP_PAR_CHILD_SUPP_PD	NO	NO
PARENT_EXP_ED_LOANS_REPAYMENT	Expected amount that the parents will be spending for repayment of educational loans.	NUMBER	RCRIMP1	RCRIMP1_EXP_PAR_ED_LN_RPAY_AMT	NO	NO
PARENT_EXP_MEDICAL_DENTAL_EXP	Amount that the parents expect to spend on medical and dental expenses.	NUMBER	RCRIMP1	RCRIMP1_EXP_PAR_MED_DEN_EXPN	NO	NO
PARENT_HOPE_LL_CREDITS	Hope and Lifetime Learning tax credits as reported on parent's tax return.	NUMBER	RCRIMP1	RCRIMP1_PAR_HOPE_LL_CREDIT	NO	NO
PARENT_ITEMIZED_TAX_DEDUCTION	Itemized deductions reported by the parents.	NUMBER	RCRIMP1	RCRIMP1_PAR_ITEM_DEDUCTNS	NO	NO
PARENT_MARITAL_STAT_SEP_DIV	Indicates whether the natural or adoptive parents of the student are separated or divorced.	VARCHAR2(1)	RCRIMP1	RCRIMP1_PAR_NTRL_SEP_DIV	NO	NO
PARENT_MARIT_STAT_SEP_DIV_DESC	Parent marital status separated/divorced description.	VARCHAR2(40)	CALCULATION	DECODE(RCRIMP1_PAR_NTRL_SEP_DIV)	NO	NO
PARENT_NON_CUSTODIAL_NAME	The name of the non-custodial parent.	VARCHAR2(20)	RCRIMP1	RCRIMP1_NON_CUST_PAR_NAME	NO	NO
PARENT_OTHER_REAL_ESTATE_AMT	Amount that the parents paid for other real estate.	NUMBER	RCRIMP1	RCRIMP1_PAR_OTH_RE_PURCH_AMT	NO	NO
PARENT_OTHER_REAL_ESTATE_YEAR	Year (YY) when the parents purchased other real estate.	NUMBER	RCRIMP1	RCRIMP1_PAR_OTH_RE_YR_PURCH	NO	NO
PARENT_OWN_BUSINESS_IND	Indicates whether the parents own all or part of a business or farm.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_PAR_OWN_BUS_FARM)	NO	NO
PARENT_PRIOR_YEAR_AGI	Amount of AGI reported by the parents on their prior year federal tax return.	NUMBER	RCRIMP1	RCRIMP1_PAR_PRYR_AGI	NO	NO
PARENT_PRIOR_YEAR_FED_TAX_PAID	Amount of federal income tax reported by the parents on their prior year federal tax return.	NUMBER	RCRIMP1	RCRIMP1_PAR_PRYR_US_TAX_PD	NO	NO
PARENT_PRIOR_YEAR_ITEMIZED_DED	Amount of itemized deductions reported by the parents on their prior year federal tax return.	NUMBER	RCRIMP1	RCRIMP1_PAR_PRYR_ITEM_DEDUCTNS	NO	NO
PARENT_PRIOR_YEAR_UNTAX_INCOME	Amount of untaxed income received by the parents during the prior year.	NUMBER	RCRIMP1	RCRIMP1_PAR_PRYR_UNTAX_INC	NO	NO
PARENT_SEPARATION_YEAR	Year of parents' separation.	VARCHAR2(4)	RCRIMP1	RCRIMP1_PAR_YR_SEP	NO	NO
PARENT_SIB_PRE_PAID_TUIT_AMT	Value of parent's assets in prepaid tuition plans for the student's brothers and sisters.	NUMBER	RCRIMP1	RCRIMP1_PAR_SIB_PRE_TUIT	NO	NO
PARENT_STUDENT_LIVE_PRIMARY	Parent who the student lived with more during the past 12 months.	VARCHAR2(1)	RCRIMP1	RCRIMP1_STU_LIVES_WITH	NO	NO
PARENT_STUDENT_LIVE_PRIM_DESC	Parent student lives with description.	VARCHAR2(20)				NO
PARENT_SUPPORT_PRIMARY	Parent who provided more support to the student during the past 12 months.	VARCHAR2(1)	RCRIMP1	RCRIMP1_STU_MOST_SUPPORT_FROM	NO	NO
PARENT_SUPPORT_PRIMARY_DESC	Parent who provided primary support deescription.	VARCHAR2(10)	CALCULATION	DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM)	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRIMP1	RCRIMP1_PIDM	NO	NO
PROFILE_COMPUTER_LOCATION	Location of computer used for completing the PROFILE application.	VARCHAR2(1)	RCRIMP1	RCRIMP1_LOCATION_COMPUTER	NO	NO
PROFILE_COMPUTER_LOCATION_DESC	Profile computer location description.	VARCHAR2(20)	CALCULATION	DECODE(RCRIMP1_LOCATION_COMPUTER)	NO	NO
RETIREMENT_ACCOUNT_VALUE	Total value of the student IRA, Keogh, 401k, 403b, etc. accounts.	NUMBER	RCRIMP1	RCRIMP1_IRA_KEOGH_ACCT_VAL	NO	NO
TAXABLE_AID	Earnings from Federal Work-Study or other need-based work programs plus any grant and scholarship aid reported on the student Federal Income tax return.	NUMBER	RCRIMP1	RCRIMP1_TAX_STU_AID	NO	NO
TRAVEL_PAYMENT_SOURCE_CDE	The source of the money to pay for the student's travel while enrolled.	VARCHAR2(1)	RCRIMP1	RCRIMP1_TRAVEL_PAY_PLAN_CDE	NO	NO
TRAVEL_PAYMENT_SOURCE_CDE_DESC	Travel Payment Source Code description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
TRUST_AMOUNT	Total value of all trust accounts for the student.	NUMBER	RCRIMP1	RCRIMP1_TRUST_AMT	NO	NO
TRUST_AVAILABILITY_IND	Indicates whether any trust income or part of the trust principal is currently available to the student.	VARCHAR2(1)	CALCULATION	DECODE(RCRIMP1_TRUST_AVAIL_IND)	NO	NO
TRUST_ESTABLISHER	Indicates who established the trust for the student.	VARCHAR2(1)	RCRIMP1	RCRIMP1_TRUST_ESTAB_BY	NO	NO
TRUST_ESTABLISHER_DESC	Trust establisher description.	VARCHAR2(10)	CALCULATION	DECODE(RCRIMP1_TRUST_ESTAB_BY)	NO	NO
UPWARD_BOUND	Indicates if the student was in the upward bound program.	VARCHAR2(1)	RCRIMP1	RCRIMP1_UPWARD_BOUND	NO	NO
UPWARD_BOUND_DESC	Upward Bound description	VARCHAR2(4000)	RORMVAL	RORMVAL_DESC	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RCRIMP1	RCRIMP1_USER_ID	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: