Penn Computing

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

FA_NEED_FM_MV - Data Element Index

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

Data element Definition
Fm_Addl_Tax_Credit

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

Additional Child Tax Credit

Fm_Aesa

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

AESA

Fm_Agi

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

Adjusted Gross Income

Fm_Aidy_Code

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

The aid year code associated with the record.

Fm_Allow_Med_Den_Exp

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

Allowable Medical / Dental Expenses

Fm_Allow_Med_Den_Exp_Ovr

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

Allowable Medical / Dental Expenses Override

Fm_Allow_Sch_Tuit_Exp

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

Allowable School Tuition Expense

Fm_Allow_Sch_Tuit_Exp_Ovr

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

Allowable School Tuition Expense Override

Fm_Asset_Home_Eqi_Incr

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

Assets/Home Equity Increase

Fm_Asset_Home_Eqi_Redc

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

Assets/Home Equity Reduction

Fm_Bus_Farm_Net_Worth

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

Business and Farm Net Worth

Fm_Bus_Farm_Owed

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

Business and Farm Owed

Fm_Bus_Farm_Worth

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

Business and Farm Worth

Fm_Bus_Income

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

Business Income

Fm_Bus_Owe

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

Business Owed

Fm_Bus_Worth

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

Business Worth

Fm_Cash_Savings_Check

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

Cash/Savings/Checking

Fm_Child_Support_Rcvd

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

Child Support Received

Fm_Combat_Pay

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

Combat Pay

Fm_Cum_Edu_Sav_Allow

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

Cumulative Education Savings Allowance

Fm_Dependency

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

Dependancy

Fm_Dividends

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

Dividends

Fm_Divid_Interes_Inc

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

Dividend and Interest Income

Fm_Earned_Income_Credit

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

Earned Income Credit

Fm_Edu_Tax_Credit

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

Education Tax Credits

Fm_Efc

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

Estimated Family Contribution

Fm_Farm_Owe

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

Farm Owed

Fm_Farm_Purchased_Price

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

Farm Purchase Price

Fm_Farm_Worth

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

Farm Worth

Fm_Farm_Yr_Purchased

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

Farm Year Purchased

Fm_Fica

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

FICA

Fm_Food_Stamps

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

Food Stamps

Fm_For_Inc_Excl

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

Foreign Income Exclusion

Fm_Gross_Need

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

Gross Need

Fm_Health_Savings

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

health savings accounts

Fm_Home_Owed

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

Home Owed

Fm_Home_Purch_Amt

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

Home Purchase Price

Fm_Home_Purch_Yr

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

HomeYear Purchased

Fm_Home_Worth

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

Home Worth

Fm_Housing_Adj

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

Housing Adjustment

Fm_Inc_Protect_Allow

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

Income Protection Allowance

Fm_Interest_Income

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

Interest Income

Fm_Ira_Keogh

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

IRA and Keough Account Value

Fm_Medicad

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

Medicaid

Fm_Med_Den_Exp

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

Medical / Dental Expenses

Fm_Net_Worth

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

Net Worth

Fm_No_Exempt

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

Number of Exemptions

Fm_No_Fam_Memb

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

Number in Household

Fm_No_In_Coll

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

Number from Household in College

Fm_Other_Assets

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

Other Assets as Reported

Fm_Other_Re_Est_Inv

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

Other Real Estate and Investments

Fm_Oth_Tax_Inc

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

Other Taxable Income

Fm_Oth_Untax_Inc

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

Other Untaxed Income

Fm_Par_1_Dob

Indexed - no
Format - Date (7)
May be Null? Y

Parent 1 Age

Fm_Par_1_Edu_Levl

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

Parent 1 Education Level

Fm_Par_Untax_Intesest

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

Tax-Exempt Interest

Fm_Penn_Id

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

Student or applicants Penn ID.

Fm_Pidm

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

Intern Banner personal idenfication number used to reference individuals throughout different tables.

Fm_Proj_Inc_Adj

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

Projected Income Adjustment

Fm_Proj_Inc_Adj_2

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

Projected Income Adjustment - Par 2

Fm_Report_Agi_Irs

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

Reported IRS AGI

Fm_Re_Est_Owe

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

Other Real Estate Owed

Fm_Re_Est_Worth

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

Other Real Estate Worth

Fm_School_Lunch

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

School Lunch

Fm_School_Tuition

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

School Tuition

Fm_Ss_Benefits

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

Social Security Benefits

Fm_State_Local_Tax

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

State and Local

Fm_Stat_Code_Res

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

State of Residence

Fm_Summer_Savings

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

Summer Savings

Fm_Tax_Def_Pension

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

Tax Deferred Pensions

Fm_Tax_Filing_Status

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

Tax Filing Status

Fm_Total_Avail_Inc

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

Total Available Income

Fm_Total_Income

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

Total Income

Fm_Tui_Fee_Ded

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

Tuition and Fees Deduction

Fm_Untax_Pension

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

Untaxed Pensions

Fm_Us_Tax_Paid

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

US Income Tax Paid

Fm_Vet_Non_Ed_Ben

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

VA Non-Education Benefits

Fm_Wages_Salaries_Tips

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

Wages, Salaries, and Tips

Fm_Ward_Of_Court

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

Ward of Court

Fm_Welfare_And_Tanf

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

Welfare and TANF

FA_NEED_FM_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