Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA NEED EDE Table . Pennant Financial Aid Home . Data Warehouse Home

FA_NEED_EDE Table - Data Element Index

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

Data element Definition
Active_Duty

Indexed - no
Format - Are You On Active Duty In The U.S Armed Forces?
May be Null? Y

Addr

Indexed - no
Format - Permanent Mailing Address
May be Null? Y

Aidy_Code

Indexed - yes
Format - The Aid Year Associated With Information In This Record.
May be Null? Y

Alien_Reg_No

Indexed - no
Format - Students Alien Registration Number
May be Null? Y

At_Risk_Homeless

Indexed - no
Format - At Risk Of Homelessness?
May be Null? Y

Birth_Date

Indexed - no
Format - Students Date Of Birth
May be Null? Y

Born_Before

Indexed - no
Format - Born Before 01-01-1997?
May be Null? Y

Bus_Net_Worth

Indexed - no
Format - Students Business And/Or Investment Farm Net Worth
May be Null? Y

C_Par_2_Adj_Bf_Net_Wth

Indexed - no
Format - Business And Farm Net Worth
May be Null? Y

C_Par_2_Avail_Disc_Inc

Indexed - no
Format - Total Available Income
May be Null? Y

C_Par_2_Disc_Net_Wth

Indexed - no
Format - Discretionary Net Worth
May be Null? Y

C_Par_2_Hme_Val

Indexed - no
Format - Calculated Home Equity
May be Null? Y

C_Par_2_Med_Den_Exp

Indexed - no
Format - Allowable Medical / Dental Expenses
May be Null? Y

C_Par_2_Mnt_Allow

Indexed - no
Format - Income Protection Allowance
May be Null? Y

C_Par_2_Net_Wth

Indexed - no
Format - Net Worth
May be Null? Y

C_Par_2_Re_Inv_Val

Indexed - no
Format - Other Real Estate And Investments
May be Null? Y

C_Par_2_Sch_Tuit

Indexed - no
Format - Allowable School Tuition Expense
May be Null? Y

C_Par_2_Tot_Allow

Indexed - no
Format - Total Expenses And Allowances
May be Null? Y

C_Par_2_Tot_Inc

Indexed - no
Format - Adjusted Total Income
May be Null? Y

Cash_Amt

Indexed - no
Format - Students Cash, Savings, And Checking
May be Null? Y

Child_Supp

Indexed - no
Format - Students Child Support Received
May be Null? Y

Child_Supp_Paid

Indexed - no
Format - Students Child Support Paid
May be Null? Y

Citizen_Code

Indexed - no
Format - Students Citizenship Code.
May be Null? Y

Citizen_Desc

Indexed - no
Format - Students Citizenship Description.
May be Null? Y

Citizen_Ind

Indexed - no
Format - Students Citizenship Status
May be Null? Y

City

Indexed - no
Format - Students Permanent City
May be Null? Y

Co_Op_Earnings

Indexed - no
Format - Students Co-Op Earnings
May be Null? Y

Combat_Pay

Indexed - no
Format - Students Combat Pay
May be Null? Y

Curr_Rec_Ind

Indexed - no
Format - Indicates Current Ede Or Isir Record For Aid Year For Student.
May be Null? Y

Degree_By_July

Indexed - no
Format - Indicates If Student Will Get A High School Degree By July Of Beginning Of Aid Year.
May be Null? Y

Degree_Type

Indexed - no
Format - Degree Or Certificate Pursual.
May be Null? Y

Disl_Wrk

Indexed - no
Format - Student/Spouse Dislocated Worker
May be Null? Y

Driver_Lic_No

Indexed - no
Format - Students Drivers License Number
May be Null? Y

Driver_Lic_Stat_Code

Indexed - no
Format - Students Drivers License State Code
May be Null? Y

Drug_Conviction

Indexed - no
Format - Student Has A Drug Conviction.
May be Null? Y

Email_Address

Indexed - no
Format - Students E-Mail Address
May be Null? Y

Emancipated_Minor

Indexed - no
Format - As Of Today, An Emancipated Minor?
May be Null? Y

Exp_Par_No_Child_Tuit

Indexed - no
Format - School Tuition - Number Children
May be Null? Y

Exp_Par_Tuit_Pd

Indexed - no
Format - School Tuition
May be Null? Y

F_1040A_Elig_Ind

Indexed - no
Format - Student Eligible For Filing Of 1040A Or 1040Ez.
May be Null? Y

Fam_Memb

Indexed - no
Format - Students Number Of Family Members
May be Null? Y

Filed_Sched_1

Indexed - no
Format - Student Filed A Schedule 1?
May be Null? Y

First_Name

Indexed - no
Format - Students First Name
May be Null? Y

Food_Stamps

Indexed - no
Format - Studentsupplemental Nutrition Program (Snap) Benefits
May be Null? Y

Gender_Code

Indexed - no
Format - Students Gender Listed.
May be Null? Y

Grad_Or_Prof

Indexed - no
Format - Working On A Master S Or Doctorate Program?
May be Null? Y

Grant_Scholar_Aid

Indexed - no
Format - Students Grant/Scholarship Aid
May be Null? Y

Has_Children

Indexed - no
Format - Have Children You Support?
May be Null? Y

Has_Legal_Depend

Indexed - no
Format - Have Legal Dependents Other Than Children Or Spouse?
May be Null? Y

Hme_Dbt

Indexed - no
Format - Home Owed
May be Null? Y

Hme_Purch_Amt

Indexed - no
Format - Purchase Price
May be Null? Y

Hme_Val

Indexed - no
Format - Home Worth
May be Null? Y

Hme_Yr_Purch

Indexed - no
Format - Home Purchase Year.
May be Null? Y

Housing_Food_Othr

Indexed - no
Format - Students Military/Clergy Allowances
May be Null? Y

Hs_City

Indexed - no
Format - High School City Location.
May be Null? Y

Hs_Code

Indexed - no
Format - High School Code.
May be Null? Y

Hs_Ged_Rcvd

Indexed - no
Format - Received A High School Diploma Or Equivialent (Ie Ged).
May be Null? Y

Hs_Name

Indexed - no
Format - High School Name.
May be Null? Y

Hs_Stat_Code

Indexed - no
Format - High School State Code.
May be Null? Y

Inc_Fr_Wrk

Indexed - no
Format - Students Income Earned From Work.
May be Null? Y

Infc_Code

Indexed - no
Format - Interface Tape Code: A Code From The Interface Tape Table Indicating The Source And Format Of The Application Record. Examples: Css, Act-Css.
May be Null? Y

Infc_Desc

Indexed - no
Format - Interface Tape Descrption: Description From The Interface Tape Table Indicating The Source And Format Of The Application Record. Examples: Css, Act-Css.
May be Null? Y

Inv_Net_Worth

Indexed - no
Format - Students Investment Net Worth
May be Null? Y

Invest_Dbt

Indexed - no
Format - Investment Owed
May be Null? Y

Invest_Val

Indexed - no
Format - Investment Worth
May be Null? Y

Ira_Distributions

Indexed - no
Format - Students Ira Distributions
May be Null? Y

Ira_Keogh_Acct_Val

Indexed - no
Format - Ira And Keough Account Value
May be Null? Y

Ira_Keogh_Amt

Indexed - no
Format - Students Ira Payments
May be Null? Y

Last_Name

Indexed - no
Format - Students Last Name
May be Null? Y

Legal_Guardian

Indexed - no
Format - As Of Today, In Legal Guardianship?
May be Null? Y

Legal_Res_Date

Indexed - no
Format - Students Legal Residence Date
May be Null? Y

Legal_Res_Ind

Indexed - no
Format - Students Legal Resident Before 01-01-2015?
May be Null? Y

Married

Indexed - no
Format - Is Student Married?
May be Null? Y

Mi

Indexed - no
Format - Middle Initial
May be Null? Y

Mrtl_Desc

Indexed - no
Format - Students Marital Status
May be Null? Y

Mrtl_Status

Indexed - no
Format - Students Marital Status
May be Null? Y

Mrtl_Status_Date

Indexed - no
Format - Students Marital Status Date
May be Null? Y

Need_Based_Employ

Indexed - no
Format - Students Need Based Employment
May be Null? Y

No_Exempt

Indexed - no
Format - Students Exemptions Claimed
May be Null? Y

No_In_Coll

Indexed - no
Format - Students Number In College
May be Null? Y

Original_Name_Id

Indexed - no
Format - The First Two Characters Of The Last Name Portion Of The Sar Identification Number.
May be Null? Y

Oth_Untax_Inc

Indexed - no
Format - Students Other Untaxed Income
May be Null? Y

Othr_Non_Report_Money

Indexed - no
Format - Students Other Non-Reported Money
May be Null? Y

Par_1_Anticipated_Inc

Indexed - no
Format - Projected Income Adjustment
May be Null? Y

Par_1040A_Elig_Ind

Indexed - no
Format - Parents Eligible To File 1040A Or 1040Ez?
May be Null? Y

Par_2_Anticipated_Inc

Indexed - no
Format - Projected Income Adjustment - Par 2
May be Null? Y

Par_Act_Fica

Indexed - no
Format - Fica
May be Null? Y

Par_Act_St_Loc_Tax

Indexed - no
Format - State And Local
May be Null? Y

Par_Addl_Child_Tx_Cred

Indexed - no
Format - Tax Deferred Pensions
May be Null? Y

Par_Adj_To_Inc

Indexed - no
Format - Adjustments To Income
May be Null? Y

Par_Afdc

Indexed - no
Format - Social Security Benefits
May be Null? Y

Par_Agi_Ovr

Indexed - no
Format - Adjusted Taxable Income
May be Null? Y

Par_Annual_Ed_Savings

Indexed - no
Format - Aesa
May be Null? Y

Par_Bus_Dbt

Indexed - no
Format - Business Owed
May be Null? Y

Par_Bus_Farm_Inc

Indexed - no
Format - Business Income (Schedule C, Schedule E, Farm)
May be Null? Y

Par_Bus_Net_Worth

Indexed - no
Format - Parents Business And/Or Investment Farm Net Worth
May be Null? Y

Par_Bus_Val

Indexed - no
Format - Business Worth
May be Null? Y

Par_Cash_Amt

Indexed - no
Format - Parents Cash, Savings, And Checking
May be Null? Y

Par_Child_Supp

Indexed - no
Format - Parents Child Support Received
May be Null? Y

Par_Child_Support_Paid

Indexed - no
Format - Parents Child Support Paid
May be Null? Y

Par_Co_Op_Earnings

Indexed - no
Format - Parents Co-Op Earnings
May be Null? Y

Par_Combat_Pay

Indexed - no
Format - Parents Combat Pay
May be Null? Y

Par_Combat_Pay_1

Indexed - no
Format - Education Tax Credits
May be Null? Y

Par_Cum_Ed_Savings

Indexed - no
Format - Cumulative Education Savings Allowance
May be Null? Y

Par_Dependent_Care

Indexed - no
Format - Fsa Healthcare Contribution
May be Null? Y

Par_Disl_Wrk

Indexed - no
Format - Parent Dislocated Worker
May be Null? Y

Par_Div_Inc

Indexed - no
Format - Dividends
May be Null? Y

Par_Edu_Credits

Indexed - no
Format - Parents Educational Credits
May be Null? Y

Par_Educ_Credits

Indexed - no
Format - Students Educational Credits
May be Null? Y

Par_Eic

Indexed - no
Format - Hsa Pre-Tax Contribution
May be Null? Y

Par_Emerg_Res_Allow

Indexed - no
Format - Emergency Reserve Allowance
May be Null? Y

Par_Fam_Memb

Indexed - no
Format - Parents Number Of Family Members
May be Null? Y

Par_Fam_Support_Inc

Indexed - no
Format - Child Support Received
May be Null? Y

Par_Farm_Dbt

Indexed - no
Format - Farm Owed
May be Null? Y

Par_Farm_Val

Indexed - no
Format - Farm Worth
May be Null? Y

Par_Filed_Sched_1

Indexed - no
Format - Parents Filed A Schedule 1?
May be Null? Y

Par_Food_Stamps

Indexed - no
Format - Parent Supplemental Nutrition Program (Snap) Benefits
May be Null? Y

Par_For_Inc_Excl

Indexed - no
Format - Earned Income Credit
May be Null? Y

Par_Fsa_Health_Care

Indexed - no
Format - Tuition And Fees Deduction
May be Null? Y

Par_Grant_Scholarship_Aid

Indexed - no
Format - Parents Grant/Scholarship Aid
May be Null? Y

Par_Health_Sav_Account

Indexed - no
Format - Fsa Dependent Care Contribution
May be Null? Y

Par_Hme_Dbt

Indexed - no
Format - Home Owed
May be Null? Y

Par_Hme_Purch_Amt

Indexed - no
Format - Purchase Price
May be Null? Y

Par_Hme_Val

Indexed - no
Format - Home Worth
May be Null? Y

Par_Hme_Yr_Purch

Indexed - no
Format - Year Purchased
May be Null? Y

Par_Home_Eq_Reduce_Ovr

Indexed - no
Format - Assets/Home Equity Reduction
May be Null? Y

Par_Hope_Ll_Credit

Indexed - no
Format - Foreign Income Exclusion
May be Null? Y

Par_House_Food_Oth

Indexed - no
Format - Parents Military/Clergy Allowances
May be Null? Y

Par_Hsa_Pre_Tax

Indexed - no
Format - Hsa Contribution
May be Null? Y

Par_Im_Oth_Untaxed_Inc

Indexed - no
Format - Tax-Exempt Interest
May be Null? Y

Par_Inc_Benefits

Indexed - no
Format - Untaxed Ira
May be Null? Y

Par_Inc_From_Debts

Indexed - no
Format - Income From Debts
May be Null? Y

Par_Int_Inc

Indexed - no
Format - Interest
May be Null? Y

Par_Inv_Net_Worth

Indexed - no
Format - Parents Investment Net Worth
May be Null? Y

Par_Invest_Dbt

Indexed - no
Format - Investment Owed
May be Null? Y

Par_Invest_Val

Indexed - no
Format - Investment Worth
May be Null? Y

Par_Ira_Distributions

Indexed - no
Format - Parents Ira Distributions
May be Null? Y

Par_Ira_Keogh

Indexed - no
Format - Parents Ira Payments
May be Null? Y

Par_Legal_Res_Ind

Indexed - no
Format - Parents Legal Residents Before 01-01-2015?
May be Null? Y

Par_Mar_Mth_Yr

Indexed - no
Format - Parents Marital Status Date
May be Null? Y

Par_Med_Den_Exp

Indexed - no
Format - Medical / Dental Expenses
May be Null? Y

Par_Med_Dent_Exp_Im_Ovr

Indexed - no
Format - Allowable Medical / Dental Expenses Override
May be Null? Y

Par_Mil_Hous_Allow

Indexed - no
Format - Parents Military Allowance.
May be Null? Y

Par_Mrtl_Desc

Indexed - no
Format - Parents Marital Status
May be Null? Y

Par_Mth_Mort_Rent_Pay

Indexed - no
Format - Housing Adjustment
May be Null? Y

Par_Need_Based_Employ

Indexed - no
Format - Parents Need-Based Employment
May be Null? Y

Par_No_Exempt

Indexed - no
Format - Parents Exemptions Claimed
May be Null? Y

Par_No_In_Coll

Indexed - no
Format - Parents Number In College (Parents Excluded)
May be Null? Y

Par_Oth_Re_Purch_Amt

Indexed - no
Format - Farm Purchase Price
May be Null? Y

Par_Oth_Re_Yr_Purch

Indexed - no
Format - Farm Year Purchased
May be Null? Y

Par_Oth_Tax_Inc

Indexed - no
Format - Other Taxable Income
May be Null? Y

Par_Oth_Untax_Inc

Indexed - no
Format - Parents Other Untaxed Income
May be Null? Y

Par_Other_Assets

Indexed - no
Format - Other Assets As Reported
May be Null? Y

Par_Other_Assets_Ovr

Indexed - no
Format - Assets/Home Equity Increase
May be Null? Y

Par_Owed_By_Others

Indexed - no
Format - Amount Owed From Others
May be Null? Y

Par_Re_Dbt

Indexed - no
Format - Other Real Estate Owed
May be Null? Y

Par_Re_Val

Indexed - no
Format - Other Real Estate Worth
May be Null? Y

Par_Recd_Ssi

Indexed - no
Format - Parent Medicaid Or Supplemental Security Income (Ssi) Benefits
May be Null? Y

Par_Recd_Tanf

Indexed - no
Format - Parent Tanf Benefits
May be Null? Y

Par_Recd_Wic

Indexed - no
Format - Parent Wic Benefits
May be Null? Y

Par_School_Lunch

Indexed - no
Format - Parent Free Or Reduced Price School Lunch Benefits
May be Null? Y

Par_Sibling_Assets

Indexed - no
Format - Assets In Siblings Names
May be Null? Y

Par_Ss_Bene

Indexed - no
Format - Social Security Benefits
May be Null? Y

Par_Stat_Code_Res

Indexed - no
Format - Parents State Of Legal Residence
May be Null? Y

Par_Tax_Def_Pension

Indexed - no
Format - Parents Pension Payments
May be Null? Y

Par_Tax_Filing_Code

Indexed - no
Format - Parent Tax Return Filing Code.
May be Null? Y

Par_Tax_Filing_Status

Indexed - no
Format - Parents Tax Return Filing Status
May be Null? Y

Par_Tax_Form_Ind

Indexed - no
Format - Parents Type Oftax Form Used?
May be Null? Y

Par_Tax_Form_Ind_Desc

Indexed - no
Format - Parents Type Of Tax Form Used Description?
May be Null? Y

Par_Te_Int_Inc

Indexed - no
Format - Parents Interest Income
May be Null? Y

Par_Tui_Fee_Ded

Indexed - no
Format - Welfare And Tanf
May be Null? Y

Par_Tuit_Exp_Im_Ovr

Indexed - no
Format - Allowable School Tuition Expense Override
May be Null? Y

Par_Tx_Ret_Filed_Desc

Indexed - no
Format - Parents Tax Return Complete Description
May be Null? Y

Par_Tx_Ret_Filled_Ind

Indexed - no
Format - Parents Tax Return Completed Indicator.
May be Null? Y

Par_Untax_Ira_Pns_Dist

Indexed - no
Format - Parentsí Untaxed Portions Of Ira Distributions And Pensions
May be Null? Y

Par_Untax_Pensions

Indexed - no
Format - Parents Untaxed Pensions
May be Null? Y

Par_Us_Inc

Indexed - no
Format - Parents Adjusted Gross Income From Irs Form
May be Null? Y

Par_Us_Inc_Tax_Pd

Indexed - no
Format - Parents U.S. Income Tax Paid
May be Null? Y

Par_Us_Inc_Tax_Pd_1

Indexed - no
Format - Us Income Tax Paid
May be Null? Y

Par_Vets_Non_Ed_Ben

Indexed - no
Format - Parents Veterans Non-Education Benefits
May be Null? Y

Par_Wages

Indexed - no
Format - Parent Wages.
May be Null? Y

Par1_Birth_Date

Indexed - no
Format - Parent 1 Date Of Birth
May be Null? Y

Par1_Edu_Code

Indexed - no
Format - Parent 1 Highest Education Level Code.
May be Null? Y

Par1_Edu_Desc

Indexed - no
Format - Parent 1 Highest Educaiton Level Description.
May be Null? Y

Par1_Inc_Fr_Wrk

Indexed - no
Format - Parent 1 Income Earned From Work
May be Null? Y

Par2_Birth_Date

Indexed - no
Format - Parent 2 Date Of Birth
May be Null? Y

Par2_Edu_Code

Indexed - no
Format - Parent 2 Highest Education Level Code.
May be Null? Y

Par2_Edu_Desc

Indexed - no
Format - Parent 2 Highest Education Level Description.
May be Null? Y

Par2_Inc_Frm_Wrk

Indexed - no
Format - Parent 2 Income Earned From Work
May be Null? Y

Penn_Id

Indexed - no
Format - Internal Number For Individual Within Banner.
May be Null? Y

Phone_Area

Indexed - no
Format - Students Permanent Phone Area
May be Null? Y

Phone_No

Indexed - no
Format - Students Permanent Phone Number
May be Null? Y

Pidm

Indexed - yes
Format - Financial Aid Year Associated With Financial Aid Applicant.
May be Null? Y

Pk_Fa_Need_Ede

Indexed - yes
Format - Internal Warehouse Primary Key: Based On Pidm, Aidy_Code
May be Null? Y

Re_Dbt

Indexed - no
Format - Other Real Estate Owed
May be Null? Y

Re_Val

Indexed - no
Format - Other Real Estate Worth
May be Null? Y

Rec_Type

Indexed - no
Format - Record Type For Ede Or Isir.
May be Null? Y

Recd_Ssi

Indexed - no
Format - Student Medicaid Or Supplemental Security Income (Ssi) Benefits
May be Null? Y

Recd_Tanf

Indexed - no
Format - Student Tanf Benefits
May be Null? Y

Recd_Wic

Indexed - no
Format - Student Wic Benefits
May be Null? Y

Refresh_Date

Indexed - no
Format - Last Date Record Was Refreshed In Data Ware House.
May be Null? Y

Res_Date_Mo_Yr

Indexed - no
Format - Parents Legal Residence Date
May be Null? Y

S_Div_Int_Inc

Indexed - no
Format - Dividend And Interest Income
May be Null? Y

School_Lunch

Indexed - no
Format - Student Free Or Reduced Price School Lunch Benefits
May be Null? Y

Selective_Services

Indexed - no
Format - Student Indicated Interest In Selective Services.
May be Null? Y

Sps_Inc_Frm_Wrk

Indexed - no
Format - Spouses Income Earned From Work.
May be Null? Y

Stat_Code

Indexed - no
Format - Students Permanent State
May be Null? Y

Stat_Code_Res

Indexed - no
Format - Students State Of Legal Residence
May be Null? Y

Tax_Def_Pension

Indexed - no
Format - Students Pension Payments
May be Null? Y

Tax_Filing_Code

Indexed - no
Format - Student Tax Filing Status Code.
May be Null? Y

Tax_Filing_Status

Indexed - no
Format - Student Tax Filing Status.
May be Null? Y

Tax_Form_Ind

Indexed - no
Format - Student Tax Form Inidcator.
May be Null? Y

Tax_Form_Ind_Desc

Indexed - no
Format - Student Tax Form Description.
May be Null? Y

Te_Int_Inc

Indexed - no
Format - Students Interest Income
May be Null? Y

Transaction_Numb

Indexed - no
Format - The Sar Transaction Number Portion Of The Sar Identification Number.
May be Null? Y

Trust_Amt

Indexed - no
Format - Trust
May be Null? Y

Tx_Ret_Filed_Desc

Indexed - no
Format - Student Completed Tax Return Description.
May be Null? Y

Tx_Ret_Filed_Ind

Indexed - no
Format - Student Completed Tax Return Indicator.
May be Null? Y

Unaccmp_Youth_Hud

Indexed - no
Format - Unaccompanied Youth Determined By Hud?
May be Null? Y

Unccomp_Youth_School

Indexed - no
Format - Unaccompanied Youth Determined By School District Liaison?
May be Null? Y

Untax_Ira_Pns_Dist

Indexed - no
Format - Students Untaxed Portions Of Ira Distributions And Pensions
May be Null? Y

Untax_Pension

Indexed - no
Format - Students Untaxed Pensions
May be Null? Y

Us_Inc

Indexed - no
Format - Students Adjusted Gross Income From Irs Form.
May be Null? Y

Us_Inc_Tax_Pd

Indexed - no
Format - Students U.S. Income Tax Paid.
May be Null? Y

Us_Vet

Indexed - no
Format - Veteran Of U.S. Armed Forces?
May be Null? Y

Vets_Non_Ed_Ben

Indexed - no
Format - Students Veterans Non-Education Benefits
May be Null? Y

Ward_Of_Court

Indexed - no
Format - Orphan, Ward Of Court, Or Foster Care?
May be Null? Y

Wrk_Stdy_Loans_Int

Indexed - no
Format - Indicated Interest In Receiveing Work Study.
May be Null? Y

Yr_In_Coll

Indexed - no
Format - Grade Level In College.
May be Null? Y

Yr_In_Coll_2

Indexed - no
Format - Grade Level In College 2.
May be Null? Y

Zip

Indexed - no
Format - Students Permanent Zip Code
May be Null? Y

FA Need EDE Table . 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