Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_NEED_ANALYSIS_PROFILE_SPEC

Description Additional Institutional Methodology Data
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated. DATE

RCRIMP1

RCRIMP1_ACTIVITY_DATE

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 Financial aid application unique sequence number. NUMBER(3)

RCRIMP1

RCRIMP1_SEQ_NO

APPLICATION_TYPE Indicates the type (regular or renewal) of application. VARCHAR2(1)

RCRIMP1

RCRIMP1_APPLIC_TYPE

APPLICATION_TYPE_DESC Application type descriptioni VARCHAR2(15)

CALCULATION

DECODE(RCRIMP1_APPLIC_TYPE)

COLLEGE10 Tenth college/program code listed by the student on the aid application for receipt of information. VARCHAR2(6)

RCRIMP1

RCRIMP1_COLL_CDE_10

COLLEGE9 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 System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

EARNED_INCOME_CREDIT Earned income credit reported by the student. NUMBER(5)

RCRIMP1

RCRIMP1_EIC

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 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 Amount of contribution expected from the parents of the student. NUMBER(5)

RCRIMP1

RCRIMP1_EXP_PAR_CTRB

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 Indicates the student financial aid status. VARCHAR2(1)

RCRIMP1

RCRIMP1_FIN_AID_STATUS

FINANCIAL_AID_STATUS_DESC Financial aid status description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_FIN_AID_STATUS)

FOREIGN_ADDRESS_IND Indicates that the student lives outside the U.S. VARCHAR2(1)

CALCULATION

DECODE(RCRIMP1_FOREIGN_ADDR_IND)

FOREIGN_COUNTRY Identifies the country for students that live outside the U.S. VARCHAR2(25)

RCRIMP1

RCRIMP1_COUNTRY

FOREIGN_POSTAL_CODE Identifies the foreign postal code for students that live outside the U.S. VARCHAR2(9)

RCRIMP1

RCRIMP1_FOREIGN_POSTAL_CDE

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 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 code description. VARCHAR2(20)

CALCULATION

DECODE(RCRIMP1_HOUS_CDE_10)

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

HOUSING9_DESC Housing code description. VARCHAR2(20)

CALCULATION

DECODE(RCRIMP1_HOUS_CDE_9)

IM_ASSUMPTION_MESSAGE1 First IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_1

IM_ASSUMPTION_MESSAGE10 Tenth IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_10

IM_ASSUMPTION_MESSAGE2 Second IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_2

IM_ASSUMPTION_MESSAGE3 Third IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_3

IM_ASSUMPTION_MESSAGE4 Fourth IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_4

IM_ASSUMPTION_MESSAGE5 Fifth IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_5

IM_ASSUMPTION_MESSAGE6 Sixth IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_6

IM_ASSUMPTION_MESSAGE7 Seventh IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_7

IM_ASSUMPTION_MESSAGE8 Eighth IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_8

IM_ASSUMPTION_MESSAGE9 Ninth IM assumption returned by INAS. VARCHAR2(4)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_9

IM_CUM_ED_SAVING_ALLOWANCE Amount of student's Cumulative Education Savings Allowance. NUMBER(6)

RCRIMP1

RCRIMP1_CUM_ED_SAVINGS

IM_CUST_PARENT_CONTRIB_ASSET Custodial parent's contribution from assets using options. NUMBER(5)

RCRIMP1

RCRIMP1_PAR_OPT_CTRB_ASSETS

IM_CUST_PARENT_CONTRIB_INCOME Custodial parent's contribution from income using options. NUMBER(5)

RCRIMP1

RCRIMP1_PAR_OPT_CTRB_INC

IM_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 Custodial parent's total contribution using options. NUMBER(5)

RCRIMP1

RCRIMP1_PAR_OPT_TOT_CTRB

IM_ED_SAVING_ALLOWANCE Amount of student's Annual Education Savings Allowance. NUMBER(5)

RCRIMP1

RCRIMP1_ANNUAL_ED_SAVINGS

IM_EMERG_RES_ALLOWANCE Amount of student's Emergency Reserve Allowance. NUMBER(5)

RCRIMP1

RCRIMP1_EMERG_RES_ALLOW

IM_LARGE_BUSINESS_IND Student owns large business indicator. VARCHAR2(1)

CALCULATION

DECODE(RCRIMP1_SMALL_BUSINESS)

IM_LOW_INCOME_ALLOWANCE Amount of student's low income allowance. NUMBER(8)

RCRIMP1

RCRIMP1_LOW_INC_ALLOW

IM_PARENT_CUM_ED_SAVING_ALLOW Amount of parents' Cumulative Education Savings Allowance. NUMBER(6)

RCRIMP1

RCRIMP1_PAR_CUM_ED_SAVINGS

IM_PARENT_ED_SAVING_ALLOWANCE Amount of parents' Annual Education Savings Allowance. NUMBER(5)

RCRIMP1

RCRIMP1_PAR_ANNUAL_ED_SAVINGS

IM_PARENT_EMERG_RES_ALLOWANCE Amount of parents' Emergency Reserve Allowance. NUMBER(5)

RCRIMP1

RCRIMP1_PAR_EMERG_RES_ALLOW

IM_PARENT_LARGE_BUSINESS_IND Parent owns large business indicator. VARCHAR2(1)

CALCULATION

DECODE(RCRIMP1_PAR_SMALL_BUSINESS)

IM_PARENT_LOW_INCOME_ALLOWANCE Amount of parents' low income allowance. NUMBER(8)

RCRIMP1

RCRIMP1_PAR_LOW_INC_ALLOW

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

IM_PARENT_PRE_PAID_TUITION_AMT 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 Parent self employed indicator. VARCHAR2(1)

CALCULATION

DECODE(RCRIMP1_PAR_SELF_EMPLOYED)

IM_SELF_EMPLOYED_IND Student self employed indicator. VARCHAR2(1)

CALCULATION

DECODE(RCRIMP1_OWN_BUS_HM_SELF_EMP)

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 deductions reported by the student. NUMBER(5)

RCRIMP1

RCRIMP1_ITEM_DEDUCTNS

LINE2_AGE Age of the person listed second on the family member matrix. NUMBER(2)

RCRIMP1

RCRIMP1_LINE2_AGE

LINE2_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 School type description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_LINE2_SCHL_TYPE)

LINE3_AGE Age of the person listed third on the family member matrix. NUMBER(2)

RCRIMP1

RCRIMP1_LINE3_AGE

LINE3_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 School type description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_LINE3_SCHL_TYPE)

LINE4_AGE Age of the person listed fourth on the family member matrix. NUMBER(2)

RCRIMP1

RCRIMP1_LINE4_AGE

LINE4_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 School type description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_LINE4_SCHL_TYPE)

LINE5_AGE Age of the person listed fifth on the family member matrix. NUMBER(2)

RCRIMP1

RCRIMP1_LINE5_AGE

LINE5_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 School type description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_LINE5_SCHL_TYPE)

LINE6_AGE Age of the person listed sixth on the family member matrix. NUMBER(2)

RCRIMP1

RCRIMP1_LINE6_AGE

LINE6_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 School type description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_LINE6_SCHL_TYPE)

LINE7_AGE Age of the person listed seventh on the family member matrix. NUMBER(2)

RCRIMP1

RCRIMP1_LINE7_AGE

LINE7_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 School type description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_LINE7_SCHL_TYPE)

LINE8_AGE Age of the person listed eighth on the family member matrix. NUMBER(2)

RCRIMP1

RCRIMP1_LINE8_AGE

LINE8_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 School type description. VARCHAR2(25)

CALCULATION

DECODE(RCRIMP1_LINE8_SCHL_TYPE)

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

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 The student's country of citizenship. VARCHAR2(15)

RCRIMP1

RCRIMP1_CITZ_COUNTRY

NONCUSTODIAL_CONTRIBUTION Reported contribution for the non-custodial parent. NUMBER(6)

RCRIMP1

RCRIMP1_PC_NON_CUST_PAR

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)

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 Year of parents' divorce. VARCHAR2(4)

RCRIMP1

RCRIMP1_PAR_YR_DIV

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 Expected child support paid to be paid by the parents. NUMBER(5)

RCRIMP1

RCRIMP1_EXP_PAR_CHILD_SUPP_PD

PARENT_EXP_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 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 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 Itemized deductions reported by the parents. NUMBER(6)

RCRIMP1

RCRIMP1_PAR_ITEM_DEDUCTNS

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

PARENT_MARIT_STAT_SEP_DIV_DESC Parent marital status separated/divorced description. VARCHAR2(40)

CALCULATION

DECODE(RCRIMP1_PAR_NTRL_SEP_DIV)

PARENT_OTHER_REAL_ESTATE_AMT Amount that the parents paid for other real estate. NUMBER(7)

RCRIMP1

RCRIMP1_PAR_OTH_RE_PURCH_AMT

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 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 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 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 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 Amount of untaxed income received by the parents during the prior year. NUMBER(6)

RCRIMP1

RCRIMP1_PAR_PRYR_UNTAX_INC

PARENT_SEPARATION_YEAR Year of parents' separation. VARCHAR2(4)

RCRIMP1

RCRIMP1_PAR_YR_SEP

PARENT_SIB_PRE_PAID_TUIT_AMT 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 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 lives with description. VARCHAR2(20)

CALCULATION

DECODE(RCRIMP1_STU_LIVES_WITH)

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 who provided primary support deescription. VARCHAR2(10)

CALCULATION

DECODE(RCRIMP1_STU_MOST_SUPPORT_FROM)

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

RCRIMP1

RCRIMP1_PIDM

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. VARCHAR2(20)

CALCULATION

DECODE(RCRIMP1_LOCATION_COMPUTER)

RETIREMENT_ACCOUNT_VALUE Total value of the student IRA, Keogh, 401k, 403b, etc. accounts NUMBER(6)

RCRIMP1

RCRIMP1_IRA_KEOGH_ACCT_VAL

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(5)

RCRIMP1

RCRIMP1_TAX_STU_AID

TRUST_AMOUNT Total value of all trust accounts for the student. NUMBER(6)

RCRIMP1

RCRIMP1_TRUST_AMT

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)

TRUST_ESTABLISHER Indicates who established the trust for the student. VARCHAR2(1)

RCRIMP1

RCRIMP1_TRUST_ESTAB_BY

TRUST_ESTABLISHER_DESC Trust establisher description. VARCHAR2(10)

CALCULATION

DECODE(RCRIMP1_TRUST_ESTAB_BY)

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

RCRIMP1

RCRIMP1_USER_ID

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 8.0