Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: NEED_ANALYSIS_PROFILE_SPECIFIC

Description Additional Institutional Methodology Data.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.
Recommended Search Columns AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND

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

RCRIMP1

RCRIMP1_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

RCRIMP1

RCRIMP1_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER

RCRIMP1

RCRIMP1_SEQ_NO

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

RCRIMP1

RCRIMP1_APPLIC_TYPE

APPLICATION_TYPE_DESC Application type description. VARCHAR2(255)

CALCULATION

DECODE(RCRIMP1_APPLIC_TYPE)

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

RCRIMP1

RCRIMP1_COLL_CDE_10

COLLEGE9 Ninth college/program code listed by the student on the aid application for receipt of information. VARCHAR2(63)

RCRIMP1

RCRIMP1_COLL_CDE_9

CURRENT_RECORD_IND Specifies that this is the current need analysis record. VARCHAR2(63)

RCRAPP1

RCRAPP1_CURR_REC_IND

EARNED_INCOME_CREDIT Earned income credit reported by the student. NUMBER

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

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

RCRIMP1

RCRIMP1_EXP_OTH_CTRB

EXPECTED_PARENT_CONTRIB Amount of contribution expected from the parents of the student. NUMBER

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

RCRIMP1

RCRIMP1_EXP_TUIT_BENE

FINANCIAL_AID_STATUS Indicates the student financial aid status. VARCHAR2(63)

RCRIMP1

RCRIMP1_FIN_AID_STATUS

FINANCIAL_AID_STATUS_DESC Financial aid status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

CALCULATION

DECODE(RCRIMP1_FOREIGN_ADDR_IND)

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

RCRIMP1

RCRIMP1_COUNTRY

FOREIGN_POSTAL_CODE Identifies the foreign postal code for students that live outside the institution's home country. VARCHAR2(63)

RCRIMP1

RCRIMP1_FOREIGN_POSTAL_CDE

HOPE_LL_CREDITS Hope and Lifetime Learning tax credits as reported on student's tax return. NUMBER

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

RCRIMP1

RCRIMP1_HOUS_CDE_10

HOUSING10_DESC Housing code description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

HOUSING9 Housing code for the school listed ninth on the application indicating the student expected place of residence at school. VARCHAR2(63)

RCRIMP1

RCRIMP1_HOUS_CDE_9

HOUSING9_DESC Housing code description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IM_ASSUMPTION_MESSAGE1 First Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_1

IM_ASSUMPTION_MESSAGE10 Tenth Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_10

IM_ASSUMPTION_MESSAGE2 Second Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_2

IM_ASSUMPTION_MESSAGE3 Third Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_3

IM_ASSUMPTION_MESSAGE4 Fourth Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_4

IM_ASSUMPTION_MESSAGE5 Fifth Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_5

IM_ASSUMPTION_MESSAGE6 Sixth Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_6

IM_ASSUMPTION_MESSAGE7 Seventh Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_7

IM_ASSUMPTION_MESSAGE8 Eighth Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_8

IM_ASSUMPTION_MESSAGE9 Ninth Institutional Method assumption returned by INAS. VARCHAR2(63)

RCRIMP1

RCRIMP1_ASSUMPT_PROF_MSG_9

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

RCRIMP1

RCRIMP1_CUM_ED_SAVINGS

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

RCRIMP1

RCRIMP1_PAR_OPT_CTRB_ASSETS

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

RCRIMP1

RCRIMP1_PAR_OPT_CTRB_INC

IM_CUST_PARENT_PERCENT_INCOME Custodial parent's percentage of income using options. NUMBER

RCRIMP1

RCRIMP1_CUST_PAR_OPT_PCT_INC

IM_CUST_PARENT_TOTAL_CONTRIB Custodial parent's total contribution using options. NUMBER

RCRIMP1

RCRIMP1_PAR_OPT_TOT_CTRB

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

RCRIMP1

RCRIMP1_ANNUAL_ED_SAVINGS

IM_EMERG_RES_ALLOWANCE Amount of student's Emergency Reserve Allowance. NUMBER

RCRIMP1

RCRIMP1_EMERG_RES_ALLOW

IM_LARGE_BUSINESS_IND Indicates student owns large business. VARCHAR2(63)

CALCULATION

DECODE(RCRIMP1_SMALL_BUSINESS)

IM_LOW_INCOME_ALLOWANCE Amount of student's low income allowance. NUMBER

RCRIMP1

RCRIMP1_LOW_INC_ALLOW

IM_PARENT_CUM_ED_SAVING_ALLOW Amount of parents' Cumulative Education Savings Allowance. NUMBER

RCRIMP1

RCRIMP1_PAR_CUM_ED_SAVINGS

IM_PARENT_ED_SAVING_ALLOWANCE Amount of parents' Annual Education Savings Allowance. NUMBER

RCRIMP1

RCRIMP1_PAR_ANNUAL_ED_SAVINGS

IM_PARENT_EMERG_RES_ALLOWANCE Amount of parents' Emergency Reserve Allowance. NUMBER

RCRIMP1

RCRIMP1_PAR_EMERG_RES_ALLOW

IM_PARENT_LARGE_BUSINESS_IND Indicates parent owns large business. VARCHAR2(63)

CALCULATION

DECODE(RCRIMP1_PAR_SMALL_BUSINESS)

IM_PARENT_LOW_INCOME_ALLOWANCE Amount of parents' low income allowance. NUMBER

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

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

RCRIMP1

RCRIMP1_PAR_STU_PRE_TUIT

IM_PARENT_SELF_EMPLOYED_IND Indicates parent is self employed. VARCHAR2(63)

CALCULATION

DECODE(RCRIMP1_PAR_SELF_EMPLOYED)

IM_SELF_EMPLOYED_IND Indicates student is self employed. VARCHAR2(63)

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

RCRIMP1

RCRIMP1_INFC_CODE

INTERFACE_TAPE_DESC Description of the interface tape code. VARCHAR2(255)

RTVINFC

RTVINFC_DESC

ITEMIZED_TAX_DEDUCTION Itemized deductions reported by the student. NUMBER

RCRIMP1

RCRIMP1_ITEM_DEDUCTNS

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

RCRIMP1

RCRIMP1_LINE2_AGE

LINE2_SCHOOL_TYPE Type of school attended by the person listed second on the family member matrix. VARCHAR2(63)

RCRIMP1

RCRIMP1_LINE2_SCHL_TYPE

LINE2_SCHOOL_TYPE_DESC School type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_LINE3_AGE

LINE3_SCHOOL_TYPE Type of school attended by the person listed third on the family member matrix. VARCHAR2(63)

RCRIMP1

RCRIMP1_LINE3_SCHL_TYPE

LINE3_SCHOOL_TYPE_DESC School type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_LINE4_AGE

LINE4_SCHOOL_TYPE Type of school attended by the person listed fourth on the family member matrix. VARCHAR2(63)

RCRIMP1

RCRIMP1_LINE4_SCHL_TYPE

LINE4_SCHOOL_TYPE_DESC School type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_LINE5_AGE

LINE5_SCHOOL_TYPE Type of school attended by the person listed fifth on the family member matrix. VARCHAR2(63)

RCRIMP1

RCRIMP1_LINE5_SCHL_TYPE

LINE5_SCHOOL_TYPE_DESC School type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_LINE6_AGE

LINE6_SCHOOL_TYPE Type of school attended by the person listed sixth on the family member matrix. VARCHAR2(63)

RCRIMP1

RCRIMP1_LINE6_SCHL_TYPE

LINE6_SCHOOL_TYPE_DESC School type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_LINE7_AGE

LINE7_SCHOOL_TYPE Type of school attended by the person listed seventh on the family member matrix. VARCHAR2(63)

RCRIMP1

RCRIMP1_LINE7_SCHL_TYPE

LINE7_SCHOOL_TYPE_DESC School type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_LINE8_AGE

LINE8_SCHOOL_TYPE Type of school attended by the person listed eighth on the family member matrix. VARCHAR2(63)

RCRIMP1

RCRIMP1_LINE8_SCHL_TYPE

LINE8_SCHOOL_TYPE_DESC School type description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NATION_OF_CITIZENSHIP Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting. VARCHAR2(63)

RCRIMP1

RCRIMP1_CITZ_COUNTRY

NONCUSTODIAL_CONTRIBUTION Reported contribution for the non-custodial parent. NUMBER

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

CALCULATION

DECODE(RCRIMP1_ONLINE_SIG)

PARENT_ASSET_SIBLING Identifies the amount of parents' assets held in the name of a student's siblings. NUMBER

RCRIMP1

RCRIMP1_PAR_SIBLING_ASSETS

PARENT_DIVORCE_YEAR Year of parents' divorce. VARCHAR2(63)

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

RCRIMP1

RCRIMP1_PAR_ED_LN_RPAY_AMT

PARENT_EXP_CHILD_SUPPORT_PAID Expected child support paid to be paid by the parents. NUMBER

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

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

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

RCRIMP1

RCRIMP1_PAR_HOPE_LL_CREDIT

PARENT_ITEMIZED_TAX_DEDUCTION Itemized deductions reported by the parents. NUMBER

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

RCRIMP1

RCRIMP1_PAR_NTRL_SEP_DIV

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

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_PAR_OTH_RE_PURCH_AMT

PARENT_OTHER_REAL_ESTATE_YEAR Year (YY) when the parents purchased other real estate. NUMBER

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

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

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

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

RCRIMP1

RCRIMP1_PAR_PRYR_ITEM_DEDUCTNS

PARENT_PRIOR_YEAR_UNTAX_INCOME Amount of untaxed income received by the parents during the prior year. NUMBER

RCRIMP1

RCRIMP1_PAR_PRYR_UNTAX_INC

PARENT_SEPARATION_YEAR Year of parents' separation. VARCHAR2(63)

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

RCRIMP1

RCRIMP1_PAR_SIB_PRE_TUIT

PARENT_STUDENT_LIVE_PRIMARY Parent who the student lived with more during the past 12 months. VARCHAR2(63)

RCRIMP1

RCRIMP1_STU_LIVES_WITH

PARENT_STUDENT_LIVE_PRIM_DESC Parent student lives with description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

PARENT_SUPPORT_PRIMARY Parent who provided more support to the student during the past 12 months. VARCHAR2(63)

RCRIMP1

RCRIMP1_STU_MOST_SUPPORT_FROM

PARENT_SUPPORT_PRIMARY_DESC Parent who provided primary support deescription. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_PIDM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROFILE_COMPUTER_LOCATION Location of computer used for completing the PROFILE application. VARCHAR2(63)

RCRIMP1

RCRIMP1_LOCATION_COMPUTER

PROFILE_COMPUTER_LOCATION_DESC Profile computer location description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

RETIREMENT_ACCOUNT_VALUE Total value of the student retirement accounts such as IRA, Keogh, 401k, 403b, etc. NUMBER

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

RCRIMP1

RCRIMP1_TAX_STU_AID

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

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

CALCULATION

DECODE(RCRIMP1_TRUST_AVAIL_IND)

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

RCRIMP1

RCRIMP1_TRUST_ESTAB_BY

TRUST_ESTABLISHER_DESC Trust establisher description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRIMP1

RCRIMP1_USER_ID



Ver: 8.5