Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE		RCRIMP1	RCRIMP1_ACTIVITY_DATE
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)		RCRIMP1	RCRIMP1_AIDY_CODE
APPLICATION_NUMBER	Application Number	Financial aid application unique sequence number.	NUMBER(3)		RCRIMP1	RCRIMP1_SEQ_NO
APPLICATION_TYPE	Application Type	Indicates the type (regular or renewal) of application.	VARCHAR2(1)		RCRIMP1	RCRIMP1_APPLIC_TYPE
APPLICATION_TYPE_DESC	Application Type Description	Application type descriptioni	VARCHAR2(15)		CALCULATION	DECODE(RCRIMP1_APPLIC_TYPE)
COLLEGE10	College 10	Tenth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRIMP1	RCRIMP1_COLL_CDE_10
COLLEGE9	College 9	Ninth college/program code listed by the student on the aid application for receipt of information.	VARCHAR2(6)		RCRIMP1	RCRIMP1_COLL_CDE_9
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
EARNED_INCOME_CREDIT	Earned Income Credit	Earned income credit reported by the student.	NUMBER(5)		RCRIMP1	RCRIMP1_EIC
EXPECTED_GRANTS_SCHOLARSHIP	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(5)		RCRIMP1	RCRIMP1_EXP_GRANT_SCHLRSHP
EXPECTED_OTHER_CONTRIB	Expected Other Contribution	Total contribution expected by the student from other relatives, parents of the spouse, and all other sources.	NUMBER(5)		RCRIMP1	RCRIMP1_EXP_OTH_CTRB
EXPECTED_PARENT_CONTRIB	Expected Parent Contribution	Amount of contribution expected from the parents of the student.	NUMBER(5)		RCRIMP1	RCRIMP1_EXP_PAR_CTRB
EXPECTED_TUITION_BENEFITS	Expected Tuition Benefits	Total tuition benefits that the student expects to receive from parents and/or the student or spouse employer.	NUMBER(5)		RCRIMP1	RCRIMP1_EXP_TUIT_BENE
FINANCIAL_AID_STATUS	Financial Financial Aid Status	Indicates the student financial aid status.	VARCHAR2(1)		RCRIMP1	RCRIMP1_FIN_AID_STATUS
FINANCIAL_AID_STATUS_DESC	Financial Financial Aid Status Description	Financial aid status description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_FIN_AID_STATUS)
FOREIGN_ADDRESS_IND	Foreign Address Indicator	Indicates that the student lives outside the U.S.	VARCHAR2(1)		CALCULATION	DECODE(RCRIMP1_FOREIGN_ADDR_IND)
FOREIGN_COUNTRY	Foreign Country	Identifies the country for students that live outside the U.S.	VARCHAR2(25)		RCRIMP1	RCRIMP1_COUNTRY
FOREIGN_POSTAL_CODE	Foreign Postal Code	Identifies the foreign postal code for students that live outside the U.S.	VARCHAR2(17)		RCRIMP1	RCRIMP1_FOREIGN_POSTAL_CDE
HOPE_LL_CREDITS	Hope Ll Credits	Hope and Lifetime Learning tax credits as reported on student's tax return.	NUMBER(6)		RCRIMP1	RCRIMP1_HOPE_LL_CREDIT
HOUSING10	Housing 10	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
HOUSING10_DESC	Housing 10 Description	Housing code description.	VARCHAR2(20)		CALCULATION	DECODE(RCRIMP1_HOUS_CDE_10)
HOUSING9	Housing 9	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
HOUSING9_DESC	Housing 9 Description	Housing code description.	VARCHAR2(20)		CALCULATION	DECODE(RCRIMP1_HOUS_CDE_9)
IM_ASSUMPTION_MESSAGE1	Institution Method Assumption Message 1	First IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_1
IM_ASSUMPTION_MESSAGE10	Institution Method Assumption Message 10	Tenth IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_10
IM_ASSUMPTION_MESSAGE2	Institution Method Assumption Message 2	Second IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_2
IM_ASSUMPTION_MESSAGE3	Institution Method Assumption Message 3	Third IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_3
IM_ASSUMPTION_MESSAGE4	Institution Method Assumption Message 4	Fourth IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_4
IM_ASSUMPTION_MESSAGE5	Institution Method Assumption Message 5	Fifth IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_5
IM_ASSUMPTION_MESSAGE6	Institution Method Assumption Message 6	Sixth IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_6
IM_ASSUMPTION_MESSAGE7	Institution Method Assumption Message 7	Seventh IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_7
IM_ASSUMPTION_MESSAGE8	Institution Method Assumption Message 8	Eighth IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_8
IM_ASSUMPTION_MESSAGE9	Institution Method Assumption Message 9	Ninth IM assumption returned by INAS.	VARCHAR2(4)		RCRIMP1	RCRIMP1_ASSUMPT_PROF_MSG_9
IM_CUM_ED_SAVING_ALLOWANCE	Institution Method Cumulative Ed Saving Allowance	Amount of student's Cumulative Education Savings Allowance.	NUMBER(6)		RCRIMP1	RCRIMP1_CUM_ED_SAVINGS
IM_CUST_PARENT_CONTRIB_ASSET	Institution Method Cust Parent Contribution Asset	Custodial parent's contribution from assets using options.	NUMBER(5)		RCRIMP1	RCRIMP1_PAR_OPT_CTRB_ASSETS
IM_CUST_PARENT_CONTRIB_INCOME	Institution Method Cust Parent Contribution Income	Custodial parent's contribution from income using options.	NUMBER(5)		RCRIMP1	RCRIMP1_PAR_OPT_CTRB_INC
IM_CUST_PARENT_PERCENT_INCOME	Institution Method Cust Parent Percent Income	Custodial parent's percentage of income using options.	NUMBER(3)		RCRIMP1	RCRIMP1_CUST_PAR_OPT_PCT_INC
IM_CUST_PARENT_TOTAL_CONTRIB	Institution Method Cust Parent Total Contribution	Custodial parent's total contribution using options.	NUMBER(5)		RCRIMP1	RCRIMP1_PAR_OPT_TOT_CTRB
IM_ED_SAVING_ALLOWANCE	Institution Method Ed Saving Allowance	Amount of student's Annual Education Savings Allowance.	NUMBER(5)		RCRIMP1	RCRIMP1_ANNUAL_ED_SAVINGS
IM_EMERG_RES_ALLOWANCE	Institution Method Emerg Residence Allowance	Amount of student's Emergency Reserve Allowance.	NUMBER(5)		RCRIMP1	RCRIMP1_EMERG_RES_ALLOW
IM_LARGE_BUSINESS_IND	Institution Method Large Business Indicator	Student owns large business indicator.	VARCHAR2(1)		CALCULATION	DECODE(RCRIMP1_SMALL_BUSINESS)
IM_LOW_INCOME_ALLOWANCE	Institution Method Low Income Allowance	Amount of student's low income allowance.	NUMBER(8)		RCRIMP1	RCRIMP1_LOW_INC_ALLOW
IM_PARENT_CUM_ED_SAVING_ALLOW	Institution Method Parent Cumulative Ed Saving Allow	Amount of parents' Cumulative Education Savings Allowance.	NUMBER(6)		RCRIMP1	RCRIMP1_PAR_CUM_ED_SAVINGS
IM_PARENT_ED_SAVING_ALLOWANCE	Institution Method Parent Ed Saving Allowance	Amount of parents' Annual Education Savings Allowance.	NUMBER(5)		RCRIMP1	RCRIMP1_PAR_ANNUAL_ED_SAVINGS
IM_PARENT_EMERG_RES_ALLOWANCE	Institution Method Parent Emerg Residence Allowance	Amount of parents' Emergency Reserve Allowance.	NUMBER(5)		RCRIMP1	RCRIMP1_PAR_EMERG_RES_ALLOW
IM_PARENT_LARGE_BUSINESS_IND	Institution Method Parent Large Business Indicator	Parent owns large business indicator.	VARCHAR2(1)		CALCULATION	DECODE(RCRIMP1_PAR_SMALL_BUSINESS)
IM_PARENT_LOW_INCOME_ALLOWANCE	Institution Method Parent Low Income Allowance	Amount of parents' low income allowance.	NUMBER(8)		RCRIMP1	RCRIMP1_PAR_LOW_INC_ALLOW
IM_PARENT_PARENTS_COLLEGE_NO	Institution Method Parent Parents College Number	Indicates how many parents will be in college at least half-time during the school year.	VARCHAR2(1)		RCRIMP1	RCRIMP1_PAR_PRNT_IN_COLL
IM_PARENT_PRE_PAID_TUITION_AMT	Institution Method Parent Pre Paid Tuition Amount	Value of parent's assets in prepaid tuition plans for the student.	NUMBER(8)		RCRIMP1	RCRIMP1_PAR_STU_PRE_TUIT
IM_PARENT_SELF_EMPLOYED_IND	Institution Method Parent Self Employed Indicator	Parent self employed indicator.	VARCHAR2(1)		CALCULATION	DECODE(RCRIMP1_PAR_SELF_EMPLOYED)
IM_SELF_EMPLOYED_IND	Institution Method Self Employed Indicator	Student self employed indicator.	VARCHAR2(1)		CALCULATION	DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP)
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)		RCRIMP1	RCRIMP1_INFC_CODE
ITEMIZED_TAX_DEDUCTION	Itemized Tax Deduction	Itemized deductions reported by the student.	NUMBER(5)		RCRIMP1	RCRIMP1_ITEM_DEDUCTNS
LINE2_AGE	Line 2 Age	Age of the person listed second on the family member matrix.	NUMBER(2)		RCRIMP1	RCRIMP1_LINE2_AGE
LINE2_SCHOOL_TYPE	Line 2 School Type	Type of school attended by the person listed second on the family member matrix.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LINE2_SCHL_TYPE
LINE2_SCHOOL_TYPE_DESC	Line 2 School Type Description	School type description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_LINE2_SCHL_TYPE)
LINE3_AGE	Line 3 Age	Age of the person listed third on the family member matrix.	NUMBER(2)		RCRIMP1	RCRIMP1_LINE3_AGE
LINE3_SCHOOL_TYPE	Line 3 School Type	Type of school attended by the person listed third on the family member matrix.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LINE3_SCHL_TYPE
LINE3_SCHOOL_TYPE_DESC	Line 3 School Type Description	School type description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_LINE3_SCHL_TYPE)
LINE4_AGE	Line 4 Age	Age of the person listed fourth on the family member matrix.	NUMBER(2)		RCRIMP1	RCRIMP1_LINE4_AGE
LINE4_SCHOOL_TYPE	Line 4 School Type	Type of school attended by the person listed fourth on the family member matrix.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LINE4_SCHL_TYPE
LINE4_SCHOOL_TYPE_DESC	Line 4 School Type Description	School type description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_LINE4_SCHL_TYPE)
LINE5_AGE	Line 5 Age	Age of the person listed fifth on the family member matrix.	NUMBER(2)		RCRIMP1	RCRIMP1_LINE5_AGE
LINE5_SCHOOL_TYPE	Line 5 School Type	Type of school attended by the person listed fifth on the family member matrix.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LINE5_SCHL_TYPE
LINE5_SCHOOL_TYPE_DESC	Line 5 School Type Description	School type description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_LINE5_SCHL_TYPE)
LINE6_AGE	Line 6 Age	Age of the person listed sixth on the family member matrix.	NUMBER(2)		RCRIMP1	RCRIMP1_LINE6_AGE
LINE6_SCHOOL_TYPE	Line 6 School Type	Type of school attended by the person listed sixth on the family member matrix.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LINE6_SCHL_TYPE
LINE6_SCHOOL_TYPE_DESC	Line 6 School Type Description	School type description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_LINE6_SCHL_TYPE)
LINE7_AGE	Line 7 Age	Age of the person listed seventh on the family member matrix.	NUMBER(2)		RCRIMP1	RCRIMP1_LINE7_AGE
LINE7_SCHOOL_TYPE	Line 7 School Type	Type of school attended by the person listed seventh on the family member matrix.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LINE7_SCHL_TYPE
LINE7_SCHOOL_TYPE_DESC	Line 7 School Type Description	School type description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_LINE7_SCHL_TYPE)
LINE8_AGE	Line 8 Age	Age of the person listed eighth on the family member matrix.	NUMBER(2)		RCRIMP1	RCRIMP1_LINE8_AGE
LINE8_SCHOOL_TYPE	Line 8 School Type	Type of school attended by the person listed eighth on the family member matrix.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LINE8_SCHL_TYPE
LINE8_SCHOOL_TYPE_DESC	Line 8 School Type Description	School type description.	VARCHAR2(25)		CALCULATION	DECODE(RCRIMP1_LINE8_SCHL_TYPE)
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
NATION_OF_CITIZENSHIP	Nation Of Citizenship	The student's country of citizenship.	VARCHAR2(15)		RCRIMP1	RCRIMP1_CITZ_COUNTRY
NONCUSTODIAL_CONTRIBUTION	Noncustodial Contribution	Reported contribution for the non-custodial parent.	NUMBER(6)		RCRIMP1	RCRIMP1_PC_NON_CUST_PAR
ONLINE_SIGNATURE_IND	Online Signature Indicator	Indicates that student completed online version of PROFILE and the signature is electronic, or blank.	VARCHAR2(1)		CALCULATION	DECODE(RCRIMP1_ONLINE_SIG)
PARENT_ASSET_SIBLING	Parent Asset Sibling	Identifies the amount of parents' assets held in the name of a student's siblings.	NUMBER(7)		RCRIMP1	RCRIMP1_PAR_SIBLING_ASSETS
PARENT_DIVORCE_YEAR	Parent Divorce Year	Year of parents' divorce.	VARCHAR2(4)		RCRIMP1	RCRIMP1_PAR_YR_DIV
PARENT_ED_LOANS_REPAYMENT	Parent Ed Loans Repayment	Amount that the parents are spending for repayment of educational loans during the current year.	NUMBER(5)		RCRIMP1	RCRIMP1_PAR_ED_LN_RPAY_AMT
PARENT_EXP_CHILD_SUPPORT_PAID	Parent Expiration Child Support Paid	Expected child support paid to be paid by the parents.	NUMBER(5)		RCRIMP1	RCRIMP1_EXP_PAR_CHILD_SUPP_PD
PARENT_EXP_ED_LOANS_REPAYMENT	Parent Expiration Ed Loans Repayment	Expected amount that the parents will be spending for repayment of educational loans.	NUMBER(5)		RCRIMP1	RCRIMP1_EXP_PAR_ED_LN_RPAY_AMT
PARENT_EXP_MEDICAL_DENTAL_EXP	Parent Expiration Medical Dental Expiration	Amount that the parents expect to spend on medical and dental expenses.	NUMBER(5)		RCRIMP1	RCRIMP1_EXP_PAR_MED_DEN_EXPN
PARENT_HOPE_LL_CREDITS	Parent Hope Ll Credits	Hope and Lifetime Learning tax credits as reported on parent's tax return.	NUMBER(6)		RCRIMP1	RCRIMP1_PAR_HOPE_LL_CREDIT
PARENT_ITEMIZED_TAX_DEDUCTION	Parent Itemized Tax Deduction	Itemized deductions reported by the parents.	NUMBER(6)		RCRIMP1	RCRIMP1_PAR_ITEM_DEDUCTNS
PARENT_MARITAL_STAT_SEP_DIV	Parent Marital State Sep Div	Indicates whether the natural or adoptive parents of the student are separated or divorced.	VARCHAR2(1)		RCRIMP1	RCRIMP1_PAR_NTRL_SEP_DIV
PARENT_MARIT_STAT_SEP_DIV_DESC	Parent Marit State Sep Div Description	Parent marital status separated/divorced description.	VARCHAR2(40)		CALCULATION	DECODE(RCRIMP1_PAR_NTRL_SEP_DIV)
PARENT_OTHER_REAL_ESTATE_AMT	Parent Other Real Estate Amount	Amount that the parents paid for other real estate.	NUMBER(7)		RCRIMP1	RCRIMP1_PAR_OTH_RE_PURCH_AMT
PARENT_OTHER_REAL_ESTATE_YEAR	Parent Other Real Estate Year	Year (YY) when the parents purchased other real estate.	NUMBER(4)		RCRIMP1	RCRIMP1_PAR_OTH_RE_YR_PURCH
PARENT_OWN_BUSINESS_IND	Parent Own Business Indicator	Indicates whether the parents own all or part of a business or farm.	VARCHAR2(1)		CALCULATION	DECODE(RCRIMP1_PAR_OWN_BUS_FARM)
PARENT_PRIOR_YEAR_AGI	Parent Prior Year Agi	Amount of AGI reported by the parents on their prior year federal tax return.	NUMBER(7)		RCRIMP1	RCRIMP1_PAR_PRYR_AGI
PARENT_PRIOR_YEAR_FED_TAX_PAID	Parent Prior Year Federal Tax Paid	Amount of federal income tax reported by the parents on their prior year federal tax return.	NUMBER(6)		RCRIMP1	RCRIMP1_PAR_PRYR_US_TAX_PD
PARENT_PRIOR_YEAR_ITEMIZED_DED	Parent Prior Year Itemized Ded	Amount of itemized deductions reported by the parents on their prior year federal tax return.	NUMBER(6)		RCRIMP1	RCRIMP1_PAR_PRYR_ITEM_DEDUCTNS
PARENT_PRIOR_YEAR_UNTAX_INCOME	Parent Prior Year Untax Income	Amount of untaxed income received by the parents during the prior year.	NUMBER(6)		RCRIMP1	RCRIMP1_PAR_PRYR_UNTAX_INC
PARENT_SEPARATION_YEAR	Parent Separation Year	Year of parents' separation.	VARCHAR2(4)		RCRIMP1	RCRIMP1_PAR_YR_SEP
PARENT_SIB_PRE_PAID_TUIT_AMT	Parent Sib Pre Paid Tuit Amount	Value of parent's assets in prepaid tuition plans for the student's brothers and sisters.	NUMBER(8)		RCRIMP1	RCRIMP1_PAR_SIB_PRE_TUIT
PARENT_STUDENT_LIVE_PRIMARY	Parent Student Live Primary	Parent who the student lived with more during the past 12 months.	VARCHAR2(1)		RCRIMP1	RCRIMP1_STU_LIVES_WITH
PARENT_STUDENT_LIVE_PRIM_DESC	Parent Student Live Primary Description	Parent student lives with description.	VARCHAR2(20)
PARENT_SUPPORT_PRIMARY	Parent Support Primary	Parent who provided more support to the student during the past 12 months.	VARCHAR2(1)		RCRIMP1	RCRIMP1_STU_MOST_SUPPORT_FROM
PARENT_SUPPORT_PRIMARY_DESC	Parent Support Primary Description	Parent who provided primary support deescription.	VARCHAR2(10)		CALCULATION	DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM)
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RCRIMP1	RCRIMP1_PIDM
PROFILE_COMPUTER_LOCATION	Profile Computer Location	Location of computer used for completing the PROFILE application.	VARCHAR2(1)		RCRIMP1	RCRIMP1_LOCATION_COMPUTER
PROFILE_COMPUTER_LOCATION_DESC	Profile Computer Location Description	Profile computer location description.	VARCHAR2(20)		CALCULATION	DECODE(RCRIMP1_LOCATION_COMPUTER)
RETIREMENT_ACCOUNT_VALUE	Retirement Account Value	Total value of the student IRA, Keogh, 401k, 403b, etc. accounts	NUMBER(6)		RCRIMP1	RCRIMP1_IRA_KEOGH_ACCT_VAL
TAXABLE_AID	Taxable Financial 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(5)		RCRIMP1	RCRIMP1_TAX_STU_AID
TRUST_AMOUNT	Trust Amount	Total value of all trust accounts for the student.	NUMBER(6)		RCRIMP1	RCRIMP1_TRUST_AMT
TRUST_AVAILABILITY_IND	Trust Availability Indicator	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)
TRUST_ESTABLISHER	Trust Establisher	Indicates who established the trust for the student.	VARCHAR2(1)		RCRIMP1	RCRIMP1_TRUST_ESTAB_BY
TRUST_ESTABLISHER_DESC	Trust Establisher Description	Trust establisher description.	VARCHAR2(10)		CALCULATION	DECODE(RCRIMP1_TRUST_ESTAB_BY)
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		RCRIMP1	RCRIMP1_USER_ID
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: