Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_NEED_IM_MV . Pennant Financial Aid Home . Data Warehouse Home

FA_NEED_IM_MV - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Im_Adjusted_Avlb_Income

Indexed - no
Format - Number (22)
May be Null? Y

Adjusted Available Income

Im_Adjustments_To_Income

Indexed - no
Format - Number (22)
May be Null? Y

Adjustments to Income

Im_Aesa

Indexed - no
Format - Number (22)
May be Null? Y

Annual Educations Savings Account (AESA)

Im_Aidy_Code

Indexed - yes
Format - Varchar2 (16)
May be Null? Y

Aid year code for record.

Im_Allowable_Med_Dental_Exp

Indexed - no
Format - Number (22)
May be Null? Y

Allowable Medical / Dental Expenses

Im_Allowable_Sch_Tuit_Expense

Indexed - no
Format - Number (22)
May be Null? Y

Allowable School Tuition Expense

Im_Allowable_Sch_Tuit_Ovr

Indexed - no
Format - Number (22)
May be Null? Y

Allowable School Tuition Expense Override

Im_Business_Farm_Networth

Indexed - no
Format - Number (22)
May be Null? Y

Business and Farm Net Worth

Im_Business_Income

Indexed - no
Format - Number (22)
May be Null? Y

Business Income

Im_Calc_Home_Equity

Indexed - no
Format - Number (22)
May be Null? Y

Calculated Home Equity

Im_Case_Complexity

Indexed - no
Format - Varchar2 (16)
May be Null? Y

Case Complexity

Im_Cash_Savings_Checking

Indexed - no
Format - Number (22)
May be Null? Y

Cash/Savings/Checking

Im_Child_Support_Rcvd

Indexed - no
Format - Number (22)
May be Null? Y

Child Support Received

Im_Combat_Pay

Indexed - no
Format - Number (22)
May be Null? Y

Combat Pay

Im_Cost_Of_Living_Mutliplier

Indexed - no
Format - Number (22)
May be Null? Y

Cost of Living Multiplier - % Override

Im_Cumul_Edu_Savings_Allow

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative Education Savings Allowance

Im_Dependency

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Dependancy

Im_Depreciation

Indexed - no
Format - Number (22)
May be Null? Y

Depreciation

Im_Disc_Net_Wth

Indexed - no
Format - Number (22)
May be Null? Y

Discretionary Net Worth

Im_Dividends

Indexed - no
Format - Number (22)
May be Null? Y

Dividends

Im_Earned_Income_Credit

Indexed - no
Format - Number (22)
May be Null? Y

Earned Income Credit

Im_Edu_Tax_Credit

Indexed - no
Format - Number (22)
May be Null? Y

Education Tax Credits

Im_Efc

Indexed - no
Format - Number (22)
May be Null? Y

Estimated Family Contribution

Im_Emerg_Reserve_Allow

Indexed - no
Format - Number (22)
May be Null? Y

Emergency reserve allowance

Im_Family_Support_Income

Indexed - no
Format - Number (22)
May be Null? Y

Family Support Income

Im_Farm_Purch_Price

Indexed - no
Format - Number (22)
May be Null? Y

Farm Purchase Price

Im_Farm_Yr_Purch

Indexed - no
Format - Number (22)
May be Null? Y

Farm Year Purchased

Im_Fica

Indexed - no
Format - Number (22)
May be Null? Y

FICA

Im_Food_Stamps

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Food Stamps

Im_For_Inc_Excl

Indexed - no
Format - Number (22)
May be Null? Y

Foreign Income Exclusion

Im_Fsa_Dependent_Care

Indexed - no
Format - Number (22)
May be Null? Y

FSA Dependent Care Contribution

Im_Fsa_Healthcare

Indexed - no
Format - Number (22)
May be Null? Y

FSA Healthcare Contribution

Im_Home_Equity_Increase

Indexed - no
Format - Number (22)
May be Null? Y

Assets/Home Equity Increase

Im_Home_Equity_Reduction

Indexed - no
Format - Number (22)
May be Null? Y

Assets/Home Equity Reduction

Im_Home_Owed

Indexed - no
Format - Number (22)
May be Null? Y

Home Owed

Im_Home_Purchase_Price

Indexed - no
Format - Number (22)
May be Null? Y

Home Purchase Price

Im_Home_Purchase_Yr

Indexed - no
Format - Number (22)
May be Null? Y

Home Year Purchased

Im_Home_Val

Indexed - no
Format - Number (22)
May be Null? Y

Home Worth

Im_Housing_Adjustment

Indexed - no
Format - Number (22)
May be Null? Y

Housing Adjustment

Im_Hsa_Contribution

Indexed - no
Format - Number (22)
May be Null? Y

HSA Contribution

Im_Hsa_Pre_Tax

Indexed - no
Format - Number (22)
May be Null? Y

HSA Pre-Tax Contribution

Im_Income_Protection_Allow

Indexed - no
Format - Number (22)
May be Null? Y

Income Protection Allowance

Im_Interest

Indexed - no
Format - Number (22)
May be Null? Y

Interest

Im_Investment_Value

Indexed - no
Format - Number (22)
May be Null? Y

Investment Worth

Im_Ira_Keough_Dedct

Indexed - no
Format - Number (22)
May be Null? Y

IRA and Keough Deductions

Im_Medicaid

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Medicaid

Im_Med_Dental_Exp

Indexed - no
Format - Number (22)
May be Null? Y

Medical / Dental Expenses

Im_Military_Clergy_Allow

Indexed - no
Format - Number (22)
May be Null? Y

Military and Clergy Allowance

Im_Military_Housing_Allow

Indexed - no
Format - Number (22)
May be Null? Y

Military Housing Allowance

Im_Mrtl_Desc

Indexed - no
Format - Varchar2 (60)
May be Null? Y

Im_Mrtl_Status

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Im_Ncp_Contrb_Pc

Indexed - no
Format - Number (22)
May be Null? Y

Non-Custodial Parent Contribution

Im_Net_Worth

Indexed - no
Format - Number (22)
May be Null? Y

Net Worth

Im_Non_Custodial_Pc

Indexed - no
Format - Number (22)
May be Null? Y

Non-Custodial Parent Contribution

Im_No_In_Coll

Indexed - no
Format - Number (22)
May be Null? Y

Number from Household in College

Im_No_In_Family

Indexed - no
Format - Number (22)
May be Null? Y

Number in Household

Im_No_Of_Exemptions

Indexed - no
Format - Number (22)
May be Null? Y

Number of Exemptions

Im_Other_Allowances

Indexed - no
Format - Number (22)
May be Null? Y

Other Allowances

Im_Other_Assets

Indexed - no
Format - Number (22)
May be Null? Y

Other Assets as Reported

Im_Other_Taxable_Income

Indexed - no
Format - Number (22)
May be Null? Y

Other Taxable Income

Im_Other_Untax_Income

Indexed - no
Format - Number (22)
May be Null? Y

Other Untaxed Income

Im_Other_Untax_Income_Im

Indexed - no
Format - Number (22)
May be Null? Y

Other Untaxed Income for IM

Im_Othr_Real_Estate_Inv

Indexed - no
Format - Number (22)
May be Null? Y

Other Real Estate and Investments

Im_Othr_Real_Estate_Owed

Indexed - no
Format - Number (22)
May be Null? Y

Other Real Estate Owed

Im_Othr_Real_Estate_Val

Indexed - no
Format - Number (22)
May be Null? Y

Other Real Estate Worth

Im_Owed_To_Others

Indexed - no
Format - Number (22)
May be Null? Y

Amount Owed from Others

Im_Parent_1_Age

Indexed - no
Format - Number (22)
May be Null? Y

Parent 1 Age

Im_Parent_1_Edu_C

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Parent 1 Education Level

Im_Parent_1_Edu_D

Indexed - no
Format - Varchar2 (35)
May be Null? Y

Parent 1 Education Level Description

Im_Parent_1_Wages

Indexed - no
Format - Number (22)
May be Null? Y

Parent 1 wages

Im_Parent_2_Age

Indexed - no
Format - Number (22)
May be Null? Y

Parent 2 Age

Im_Parent_2_Edu_C

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Parent 2 Education Level

Im_Parent_2_Edu_D

Indexed - no
Format - Varchar2 (35)
May be Null? Y

Parent 2 Education Level Description

Im_Parent_2_Wages

Indexed - no
Format - Number (22)
May be Null? Y

Parent 2 wages

Im_Parent_Contribution

Indexed - no
Format - Number (22)
May be Null? Y

Parent Contribution

Im_Par_Addl_Child_Tx_Cred

Indexed - no
Format - Number (22)
May be Null? Y

Additional Child Tax Credit

Im_Par_Mrtl_Desc

Indexed - no
Format - Varchar2 (240)
May be Null? Y

Im_Par_Mrtl_Status

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Im_Penn_Id

Indexed - no
Format - Varchar2 (9)
May be Null? Y

Penn ID for individual

Im_Pidm

Indexed - yes
Format - Number (22)
May be Null? Y

Internal personal identification number for Banner database.

Im_Primary_Par_Ctrb

Indexed - no
Format - Number (22)
May be Null? Y

Primary Parent Contribution

Im_Prof_Adjustment

Indexed - no
Format - Number (22)
May be Null? Y

Professional Adjustment

Im_Proj_Income_Adj_1

Indexed - no
Format - Number (22)
May be Null? Y

Projected Income Adjustment

Im_Proj_Income_Adj_2

Indexed - no
Format - Number (22)
May be Null? Y

Projected Income Adjustment - Par 2

Im_Reported_Irs_Agi

Indexed - no
Format - Number (22)
May be Null? Y

Reported IRS AGI

Im_School_Lunch

Indexed - no
Format - Varchar2 (4)
May be Null? Y

School Lunch

Im_School_Tuition_No_Child

Indexed - no
Format - Number (22)
May be Null? Y

School Tuition - Number Children

Im_School_Tuition_Paid

Indexed - no
Format - Number (22)
May be Null? Y

School Tuition

Im_Self_Help_Base

Indexed - no
Format - Varchar2 (80)
May be Null? Y

Self Help Base

Im_Self_Help_Level

Indexed - no
Format - Varchar2 (80)
May be Null? Y

Self Help Level

Im_Sibling_Assets

Indexed - no
Format - Number (22)
May be Null? Y

Assets in Siblings Names

Im_Ss_Benefits

Indexed - no
Format - Number (22)
May be Null? Y

Social Security Benefits

Im_State_And_Local

Indexed - no
Format - Number (22)
May be Null? Y

State and Local

Im_State_Resd

Indexed - no
Format - Varchar2 (8)
May be Null? Y

State of Residence

Im_Stu_Contribution

Indexed - no
Format - Number (22)
May be Null? Y

Student Contribution

Im_Summer_Savings

Indexed - no
Format - Number (22)
May be Null? Y

Summer Savings

Im_Taxable_Income

Indexed - no
Format - Number (22)
May be Null? Y

Adjusted Taxable Income

Im_Tax_Deferred_Pension

Indexed - no
Format - Number (22)
May be Null? Y

Tax Deferred Pensions

Im_Tax_Exmpt_Interst

Indexed - no
Format - Number (22)
May be Null? Y

Tax-Exempt Interest

Im_Tax_Filing_Desc

Indexed - no
Format - Varchar2 (45)
May be Null? Y

Tax Filing Status Description

Im_Tax_Filing_Status

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Tax Filing Status

Im_Tax_Ret_Desc

Indexed - no
Format - Varchar2 (12)
May be Null? Y

Tax Return Filed Description

Im_Tax_Ret_Ind

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Tax Return Filed

Im_Total_Assets

Indexed - no
Format - Number (22)
May be Null? Y

Total Assets

Im_Total_Avaliable_Income

Indexed - no
Format - Number (22)
May be Null? Y

Total Available Income

Im_Total_Income

Indexed - no
Format - Number (22)
May be Null? Y

Adjusted Total Income

Im_Total_Taxable_Income

Indexed - no
Format - Number (22)
May be Null? Y

Total taxable income

Im_Total_Untaxable_Income

Indexed - no
Format - Number (22)
May be Null? Y

Total Untaxable Income

Im_Tot_Expenses_Allowances

Indexed - no
Format - Number (22)
May be Null? Y

Total Expenses and Allowances

Im_Trust_Amount

Indexed - no
Format - Number (22)
May be Null? Y

Trust

Im_Tuition_Fee_Deduction

Indexed - no
Format - Number (22)
May be Null? Y

Tuition and Fees Deduction

Im_Unmet_Need

Indexed - no
Format - Number (22)
May be Null? Y

Unmet Need

Im_Untax_Ira

Indexed - no
Format - Number (22)
May be Null? Y

Untaxed IRA

Im_Untax_Pension

Indexed - no
Format - Number (22)
May be Null? Y

Untaxed Pensions

Im_Us_Tax_Paid

Indexed - no
Format - Number (22)
May be Null? Y

US Income Tax Paid

Im_Va_Non_Edu_Benefit

Indexed - no
Format - Number (22)
May be Null? Y

VA Non-Education Benefits

Im_Wages_Salary_Tips

Indexed - no
Format - Number (22)
May be Null? Y

Wages, Salaries, and Tips

Im_Welfare_And_Tanf

Indexed - no
Format - Varchar2 (4)
May be Null? Y

Welfare and TANF

FA_NEED_IM_MV . Pennant Financial Aid Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania