Penn Computing

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

FA_NEED_CSS Table - Data Element Index

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

Data element Definition
Add_Coll_Date

Indexed - no
Format - Date
May be Null? Y

Add college submitted date.

Adm_Type

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

Admission type

Age

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

Age listed.

Agi

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

Reported IRS Adjusted Gross Income.

Aidy_Code

Indexed - yes
Format - Varchar2 (4 Char)
May be Null? N

The aid year associated with information in this record.

App_Submited_Date

Indexed - no
Format - Date
May be Null? Y

Application submitted date.

Applic_Type

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

Application type.

Assume_Yr_In_Coll_Code

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

Assumed year for financial aid applicant code.

Assume_Yr_In_Coll_Desc

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

Assumed year for financial aid applicant description.

Birth_Date

Indexed - no
Format - Date
May be Null? Y

Birthday.

Business_Debt

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

Business debt.

Business_Val

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

Business worth.

C_Depend_Status

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

Dependent status code listed.

Cash_Savings_Checking

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

Value of cash, savings, and checking accounts.

Catastrophic_Event

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

Catestrophic event.

Cb_Fina_Aid_Id

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

CSS lifetime indicator.

Change_In_Employment

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

Change in employment.

Child_Supp_Paid

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

Child support paid.

Child_Supp_Recd

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

Child support amount received.

Child_Supp_Recd_For_Stu

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

Child support amount allocated to student.

Child_Support_End_Mo

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

Child support end month.

Child_Support_End_Yr

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

Child support end year.

Child_Support_Paid

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

Child support paid.

Citz_Country

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

Country of citizenship.

Citz_Desc

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

Citizenship description.

Citz_Ind

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

Citizenship indicator code.

Combat_Pay

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

Combat pay.

Created_Date

Indexed - no
Format - Date
May be Null? Y

Original creation date.

Currency_Cde

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

International currency code.

Currency_Rate

Indexed - no
Format - Number (9,4)
May be Null? Y

International currency rate.

Dependency_Status

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

Dependent status listed for student.

Dislocated_Worker

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

Dislocated worker.

Dividends

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

Intereste from dividend income.

Earned_Inc_Credit

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

Earned income tax credit.

Edu_Tax_Credit

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

Education tax credits.

Efc

Indexed - no
Format - Number
May be Null? Y

Estimated family contribution.

Efm_Computed_Orphan_Or_Woc

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

EFC computed orphan ward foster indicator.

Elder_Care

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

Elder care.

Email_Address

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

Email address listed.

Excess_Adv_Prem_Tax_Cred

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

Parent Excess Advance Premium Tax Credit

Exp_Gov_Support_Ind

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

Expected government support.

Exp_Tuit_Benefit_Ind

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

Received tuition benefit.

Expected_Foundation_Supp_Ind

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

Expected foundation support.

Explantion_Text

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

Explanations text.

Fam_Age_1

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

Family member 1 age.

Fam_Age_2

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

Family member 2 age.

Fam_Age_3

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

Family member 3 age.

Fam_Age_4

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

Family member 4 age.

Fam_Age_5

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

Family member 5 age.

Fam_Age_6

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

Family member 6 age.

Fam_Age_7

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

Family member 7 age.

Fam_Attend_Coll_1

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

Family member 1 attending college.

Fam_Attend_Coll_2

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

Family member 2 attending college.

Fam_Attend_Coll_3

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

Family member 3 attending college.

Fam_Attend_Coll_4

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

Family member 4 attending college.

Fam_Attend_Coll_5

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

Family member 5 attending college.

Fam_Attend_Coll_6

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

Family member 6 attending college.

Fam_Attend_Coll_7

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

Family member 7 attending college.

Fam_Relt_1

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

Family member 1 relationship.

Fam_Relt_2

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

Family member 2 relationship.

Fam_Relt_3

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

Family member 3 relationship.

Fam_Relt_4

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

Family member 4 relationsihp.

Fam_Relt_5

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

Family member 5 relationship.

Fam_Relt_6

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

Family member 6 relationship.

Fam_Relt_7

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

Family member 7 relationship.

Fam_Schl_Type_1

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

Family member 1 college type.

Fam_Schl_Type_2

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

Family member 2 college type.

Fam_Schl_Type_3

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

Family member 3 college type.

Fam_Schl_Type_4

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

Family member 4 college type.

Fam_Schl_Type_5

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

Familiy member 5 college type.

Fam_Schl_Type_6

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

Family member 6 college type.

Fam_Schl_Type_7

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

Family member 7 college type.

Farm_Debt

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

Farm debt.

Farm_Val

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

Farm worth.

Fee_Waiver_Ind

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

Fee Waiver Indicator

Fica

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

FICA for student.

Fin_Aid_Status

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

Financial aid status.

Financial_Support

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

Financial support.

First_Name

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

First name on application.

Fm_Contribution_For_Stu

Indexed - no
Format - Number
May be Null? Y

Total contribution for student.

Fm_Par_Contribution_For_Stu

Indexed - no
Format - Number
May be Null? Y

Parent contribution for student

Fm_Par_Ctrb_Fr_Asset

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

Parent total contribution from asset estimate.

Fm_Par_Ctrb_Fr_Inc

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

Parent total contribution from income estimate.

Fm_Par_Total_Inc

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

Parent total income estimate.

Fm_Stu_Ctrb_Fr_Asset

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

Student total contribution from asset estimate.

Fm_Stu_Ctrb_Fr_Inc

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

Student total contribution from income estimate.

Fm_Stu_Total_Inc

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

Student total income estimate.

Foreign_Address_Ind

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

Foreign address indicator.

Free_Reduced_Lunch

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

Received reduced or free school lunch.

Grant_Schlshp_Aid

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

Other grant and scholarships.

Has_Legal_Dep

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

Legal depedendts indicator.

Hhb_Indicated

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

HHB Indicated.

Home_Owed

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

Amount owed on home.

Home_Purchased_Amt

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

Home purchase price.

Home_Worth

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

Home worth.

Home_Yr_Purchased

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

Home year purchased.

Homeless_Ind

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

Homelss indicator.

Household_Type

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

Household type for analysis. HHA or HHB.

Im_Computed_Orphan_Or_Woc

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

IM computed orphan ward foster indicator.

Infc_Code

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

INTERFACE TAPE CODE: A code from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT-CSS.

Infc_Desc

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

INTERFACE TAPE DESCRPTION: Description from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT-CSS.

Inst_House_Cde

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

Instituitonal housing code.

Inst_House_Desc

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

Instituitonal housing description.

Investment_Owed

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

Home equity.

Investment_Value

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

Investment worth.

Ira_Keogh

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

IRA and KEOGH Account Value

Item_Deductns

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

Itemized deductions.

Last_Name

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

Last name on application.

Live_On_Farm_Ind

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

Live on a farm.

Lrg_Bus_Ind

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

Large business indicator: Indicates if business employes more than 100 full time employees.

Mail_Addr

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

Mailing address.

Mail_City

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

Mailing city.

Mail_Postal_Cde

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

Mailing postal code.

Mail_Stat_Code

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

Mailing state code.

Med_Dental_Expense

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

Medical and dental expenses paid.

Medicaid

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

Receieved food stamps.

Memb_In_Family

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

Number of members within family unit.

Mi

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

Middle initial.

Month_Mortgage_Or_Rent

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

Monthly mortgage or rent payments.

Mrtl_Desc

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

Marital description.

Mrtl_Status

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

Maritial status.

Name_Of_School_1

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

Family member 1 college name.

Name_Of_School_2

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

Family member 2 college name.

Name_Of_School_3

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

Family member 3 college name.

Name_Of_School_4

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

Family member 4 college name.

Name_Of_School_5

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

Family member 5 college name

Name_Of_School_6

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

Family member 6 college name.

Name_Of_School_7

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

Family member 7 college name.

No_2Nd_Bap_Resp

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

No second BAP response.

No_In_Coll

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

Number of family members in college.

No_Of_Exemptions

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

Number of excemptions.

Nonrecurring_Inc

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

Nonrecurring income.

Num_Months_Va_Benefits_Recv

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

Number of months veteratn benefits received.

Oth_Taxable_Income

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

Other taxable income.

Oth_Untax_Inc

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

Other untaxed income.

Oth_Untax_Income

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

Other untaxable income.

Other

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

Other circumstances indicator.

Other_Taxable_Inc

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

Other taxable income.

Other_Untaxed_Inc

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

Other untaxable income.

Othr_Real_Estate_Debt

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

Other real estate debt.

Othr_Real_Estate_Val

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

Other real estate value

Owed_To_Par_By_Othr

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

Parents amount owned to others.

Pa_Agi

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

Parent adjustged gross income.

Par_1_Anticipated_Inc

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

Parent 1 anticipated earned income.

Par_1_Inc

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

Parent 1 income.

Par_1_Ret_Assets

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

Parent 1 retirement account value.

Par_2_Anticipated_Inc

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

Parent 2 anticipated earned income.

Par_2_Inc

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

Parent 2 income.

Par_2_Ret_Assets

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

Parent 2 retirement account value.

Par_Add_Medicare_Tax

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

Parent additoinal medicare tax paid.

Par_Addl_Child_Tx_Cred

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

Parent additoinal child tax credit.

Par_Adj_To_Inc

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

Parent adjustments to income.

Par_Alimony_Recd

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

Parent alimony amount received.

Par_Allowable_Med_Den_Exp

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

Parent allowable medical and or dental expenses.

Par_Allowable_Tuit_Expense

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

Allowable School Tuition Expense.

Par_Amt_Pd_Home_Employ

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

Parents amount paid to home employees.

Par_Analyis_Type

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

Parent analysis type.

Par_Annual_Debt_Pay

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

Annual payment for parents debt.

Par_Asea

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

Parent Annual Education Savings Account (Parent AESA).

Par_Asea_Children

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

Parent AESA children indicator.

Par_Asset_Home_Reduction

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

Parent assets and home equity reduction.

Par_Assets_Home_Equity

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

Parent assets and home equity increase.

Par_Autho_Maintenance

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

Parent expenses for auto maintenance.

Par_Bus_Dbt

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

Parents business debt

Par_Bus_Fam_Inc

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

Parent business income.

Par_Bus_Return_Field

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

Indicates business tax return form used by parents.

Par_Bus_Val

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

Parents business value.

Par_Calc_Home_Equity

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

Parents calculated home equity.

Par_Cash_Savings

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

Amount in parents cash, savings, and checking accounts.

Par_Cesa_Ages

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

Parent CESA age.

Par_Child_Supp_Recd

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

Parent child support amount received.

Par_Child_Support_Pd

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

Parent child support paid amount.

Par_Cloth_Expenses

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

Parents clothing expenses.

Par_Cntry_Cntry_Code_Res

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

Parent country code of residence.

Par_Combat_Pay

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

Parent combat pay

Par_Contrb_From_Assets

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

Parent contribution from assets.

Par_Contrb_From_Inc

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

Parent contribution from income.

Par_Cost_Of_Living_Mutliplier

Indexed - no
Format - Number (3,2)
May be Null? Y

Parent cost of living multiplier.

Par_Country_Coefficient

Indexed - no
Format - Number (8,7)
May be Null? Y

Parent country coefficient.

Par_Cum_Ed_Savings

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

Parents cumulative education savings allowance.

Par_Debt_Expense

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

Parent expenses from debt.

Par_Disc_Net_Wth

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

Parent Discretionary Net Worth.

Par_Disl_Wrk

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

Parent is a dislocated worker.

Par_Dividend_Inc

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

Parent income from dividends.

Par_Earned_Income_Credit

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

Parent Earned income credit.

Par_Edu_Credit

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

Parent education credits.

Par_Emerg_Res_Allow

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

Parent emergency reserve allowance.

Par_Entertain_Costs

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

Parents entertainment costs.

Par_Exp_No_Child_Tuit

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

Number of childen parent is paying school tuition for.

Par_Fam_Support_Inc

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

Family support income.

Par_Farm_Bus_Net_Worth

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

Parent business net worth.

Par_Farm_Dbt

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

Parent farm debt.

Par_Farm_Purch_Amt

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

Parent farm purchased

Par_Farm_Val

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

Parents farm value.

Par_Farm_Yr_Purch

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

Parent year farm purchased.

Par_Food_Expense

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

Parents food expenses.

Par_Food_Stamps

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

Parent received food stamps.

Par_For_Inc_Excl

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

Parent foreign income exclusion.

Par_Fsa_Dependent_Care

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

Parent Dependent FSA healthcare contribution.

Par_Fsa_Health_Care

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

Parent FSA healthcare contribution.

Par_Health_Savings_Account

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

Parent health savings account.

Par_Home_Debt

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

Parent home debt.

Par_Home_Purch_Amt

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

Parents home purchase amount.

Par_Home_Purch_Yr

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

Parents home year purchased.

Par_Home_Val

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

Parents home value.

Par_Hous_Stat

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

Parent housing status code

Par_Hous_Stat_Desc

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

Parent housing status description.

Par_Household_Expenses

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

Parents household expenses.

Par_Hsa_Pre_Tax

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

Parent HAS pre-tax contribution.

Par_Im_Oth_Untax_Inc

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

Parent other untaxed income for IM.

Par_Im_Zip

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

Parent IM zip code.

Par_Inc_Frm_Dbts

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

Parent income from debts.

Par_Inc_Tax_Paid

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

Parent income tax paid.

Par_Income_Protection_Allow

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

Parent Income Protection Allowance.

Par_Intrest_Inc

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

Parent income from investment.

Par_Invest_Debt

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

Parents investment debt.

Par_Invest_Val

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

Parents investment values.

Par_Ira_Distributions

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

Parent Untaxed IRA distributions.

Par_Ira_Keough_Dedct

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

IRA and Keogh deductions.

Par_Item_Deductns

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

Parent itemized deductions.

Par_Live_Farm_Ind

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

Indicator of living farms.

Par_Living_Allowance

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

Parent military and clergy allowance.

Par_Mail_Addr

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

Parent mailing address.

Par_Mail_City

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

Parent mailing city.

Par_Mail_Country_Cde

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

Parent mailing country code.

Par_Mail_Postal_Code

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

Parent postal code.

Par_Mail_Stat_Code

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

Parent mailing state code.

Par_Med_Dent_Exp_Im_Ovr

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

Parent allowable medical and or dental expenses override.

Par_Med_Dental_Expense

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

Parents medical and dental expenses.

Par_Medicaid

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

Parent is medicaid eligible.

Par_Memb_In_Family

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

Number of members in parents family unit.

Par_Mil_Hous_Allowance

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

Parent military and clergy housing allowance.

Par_Mnth_Mort_Rent_Pay

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

Parent's monthly mortgage or rent.

Par_Natrl_Sep_Div

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

Natural parent maritial status.

Par_Natrl_Sep_Div_Desc

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

Natural parent maritial description.

Par_Nbr_Employed

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

Parents number of people employed.

Par_Ncp_Contrb_Pc

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

Calculated Non-Custodial Parent Contribution.

Par_Ncp_Parent_Agreement

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

Noncustodial parent agreement of support.

Par_Net_Worth

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

Parent net worth.

Par_No_Child_Tuit

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

Parent number of children paying for private school.

Par_No_Exempt

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

Paretn number of exemptions.

Par_No_In_Coll

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

Number of members in parent family unit in college.

Par_Npc_Contribution

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

Reported non-constodial parent contribution.

Par_Num_Farms

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

Parent Number of Farms

Par_Numb_Of_Bus

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

Number of business owned by parents

Par_Numb_Of_Employ_Ind

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

Indicates if parent business has more than 100 employees.

Par_Numb_Real_Estate

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

Parents number of real estate owed.

Par_Oth_Expense

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

Parents other expenses.

Par_Oth_Tax_Inc

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

Parent other taxable income.

Par_Other_Allowances

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

Parent other allowances.

Par_Other_Untax_Inc

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

Parent other untaxed income.

Par_Othr_Real_Estate_Dbt

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

Parents other real estate debt.

Par_Othr_Real_Estate_Inv

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

Parents other real estate investment

Par_Othr_Real_Estate_Val

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

Parents other real estate worth.

Par_Pension_Dedct

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

Tax deferred pensions.

Par_Perc_From_Inc

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

Parent's percent from income.

Par_Private_Tuit_Paid

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

Parent private school tuition paid amount.

Par_Property_Insur

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

Parent property insurance payments.

Par_Qual_Bus_Inc_Ded

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

Parent qualified business income deduction.

Par_Recd_Wic

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

Parent received WIC benefits.

Par_Repay_Edu_Loan

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

Parent educational loan repayment amount.

Par_School_Lunch

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

Parent received free or reduced lunch.

Par_Sibling_Assets

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

Sibbling assets from parent family.

Par_Ss_Benefit

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

Parent SS benefit received.

Par_Ssi

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

Parent received SSI.

Par_Stat_Code_Res

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

Parent state of residence code.

Par_Stat_Locl_Tax

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

Parent state and local taxes paid.

Par_Tanf

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

Parent received TANF benfits.

Par_Tax_Exmpt_Inc

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

Parent tax exempt income.

Par_Tax_Filing_Desc

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

Parent tax filing status description.

Par_Tax_Filing_Status

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

Parent tax filing status.

Par_Tax_Form_Desc

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

Parent tax form description.

Par_Tot_Allowances

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

Parent total allowances.

Par_Tot_Avlb_Inc

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

Parent total avalialble discretionary income.

Par_Tot_Contrb

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

Total parent contribution.

Par_Tot_Inc

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

Parent total income.

Par_Tui_Fee_Ded

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

Parent tuition and fees deduction.

Par_Tuit_Expense_Im

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

Allowable School Tuition Expense Override IM.

Par_Tuit_Pd

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

Parent tution paid for private school.

Par_Tx_Form_Ind

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

Parent tax form indicator code.

Par_Tx_Ret_Desc

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

Parent tax return indicator description.

Par_Tx_Ret_Ind

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

Parent tax return indicator code.

Par_Untax_Pension

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

Parent untaxed pension.

Par_Untaxed_Ira_Pns_Dist

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

Untaxed IRAs Pensions Annuities Distribution.

Par_Utility_Expense

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

Parents utility expenses.

Par_Va_Non_Edu_Benefit

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

Parent VA Non-educational benefits.

Par_Vacation_Expense

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

Parents vacation expenses.

Par_Val_Other_Assets

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

Parent's value of other assets.

Par_Wages

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

Parent wages.

Par_Welfare_Tanf

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

Parent TANF received.

Par_Yr_Div

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

Parent year divorced.

Par_Yr_Of_Marriage

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

Parents yeas in marriage.

Par_Yr_Sep

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

Parent year seperated.

Par1_Age

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

Parent 1 age.

Par1_Birth_Date

Indexed - no
Format - Date
May be Null? Y

Parent 1 birthday.

Par1_Deceased

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

Parent 1 deceased.

Par1_Edu_Code

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

Parent 1 age code

Par1_Edu_Desc

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

Parent 2 age description.

Par1_Email_Address

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

Parent 1 email address.

Par1_Employer

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

Parent 1 employer.

Par1_Occupation

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

Parent 1 occupation.

Par1_Rel_To_Stu

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

Parent 1 relationship to student.

Par1_Self_Employed

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

Parent 1 self employed inicator.

Par1_Unemployed

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

Parent 1 uneployed indicator.

Par1_Vet

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

Parent 1 vet indicator.

Par2_Age

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

Parent 2 age.

Par2_Birth_Date

Indexed - no
Format - Date
May be Null? Y

Parent 2 birthday.

Par2_Deceased

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

Parent 2 deceased.

Par2_Edu_Code

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

Parent 2 education code.

Par2_Edu_Desc

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

Parent 2 education description.

Par2_Email_Address

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

Parent 2 email address.

Par2_Employer

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

Parent 2 employer.

Par2_Occupation

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

Parent 2 occupation.

Par2_Rel_To_Stu

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

Parent 2 relationship to student.

Par2_Self_Employed

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

Parent 2 self employed indicator.

Par2_Unemployed

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

Parent 2 unemployed indicator.

Par2_Vet

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

Parent 2 vet indicator.

Parent_Contribution_Offer

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

Contributions from parents offered.

Penn_Id

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

Internal number for individual within Banner.

Phone_Number

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

Phone number listed.

Pidm

Indexed - yes
Format - Number (8)
May be Null? N

Financial aid year associated with financial aid applicant.

Indexed - yes
Format - Varchar2
May be Null? N

Internal warehouse primary key: based on PIDM, AIDY_CODE, INFC_CODE

Postal_Code

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

Mailing zip code

Preferred_Name

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

Preferred name.

Recd_Ssi

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

Received SSI benefits.

Recd_Tanf

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

Received TANF benefits.

Recd_Wic

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

Received WIC benefits.

Indexed - no
Format - Date
May be Null? Y

Last refreshed date within data warehouse.

Relatives_Contribution_Offer

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

Contributions from relatives offered.

Res_Stat_Code

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

State of residence code.

Scholarships

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

Scholarships.

School_Assigned_Id

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

School assigned ID.

School_Yr_Earned_Inc

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

Expected income earned during school year.

School_Yr_Untax_Inc

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

School year untaxed income.

Sibl_Private_School

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

Siblings in private schools.

Snap

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

Receieved food stamps.

Special_Circumstances_None

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

Special circumstances labeld as none.

Spouse_School_Yr_Earned_Inc

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

Expected spouse income during school year.

Spouse_Sum_Earned_Inc

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

Spouse summer income.

Spouse_Wages

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

Wages for spouse or parent 2.

Ss_Benefits

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

Social security benefits received.

State_Code

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

Maling state code.

Stu_Aesa_Children

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

Student AESA children indicator.

Stu_Analyis_Type

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

Student analysis type.

Stu_Cesa_Ages

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

Student CESA age.

Stu_Contrb_From_Asset

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

Total student contribution from assets.

Stu_Contrb_From_Inc

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

Total student contribution from income.

Stu_Contribution

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

Total student contribution.

Stu_Country_Coefficient

Indexed - no
Format - Number (8,7)
May be Null? Y

Sutdent country coefficient.

Stu_Im_Zip

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

Student IM zip code.

Stu_Rec_Code

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

The student record type entered code (ie: initial or school added).

Stu_Rec_Desc

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

The student record type entered description (ie: initial or school added).

Stu_Total_Inc

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

Total student income.

Sum_Earned_Inc

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

Summer earned income

Summer_Untax_Inc

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

Summer untaxed income.

Tanf_Benefits

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

TANF benefit amount.

Tax_Filing_Status

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

Tax filing status code.

Tax_Filing_Status_Desc

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

Tax filing status description.

Tot_Contrb_For_Stu

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

Total contribution for student.

Tot_Contrb_From_Asset

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

Contribution from assets.

Tot_Contrb_From_Inc

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

Contribution from income.

Total_Inc

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

Total income on record.

Totl_Assets

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

Total assets for student.

Transfer_Stu

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

Transfer student.

Travel_Pay_Plan_Cde

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

Travel plan code for student.

Travel_Pay_Plan_Desc

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

Travel plan description for student.

Trust_Availb_Ind

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

Trust fund is avaliable indicator.

Trust_Estb_By_Desc

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

Trust fund established by description.

Trust_Estb_Code

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

Trust fund established code.

Trust_Fund

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

Value of students trust fund.

Tutition_Benefits

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

Tuition benefits received from employer.

Tx_Ret_Filed_Desc

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

Tax return filed indicator description.

Tx_Ret_Filed_Ind

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

Tax return filed indicator.

Us_Tax_Pd

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

US income tax paid.

Vet_Befefits_Desc

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

Veteran benefit type description.

Vet_Benefits_Amt

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

Veteran benefit amount.

Vet_Benefits_Type

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

Veteran benefit type code.

Vet_Ind

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

Veteran indicator

Visa_Class

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

Visa code.

Wages

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

Wages for student or parent 1.

Wrttn_Expln_Prsnt

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

Indicates if a written explanation is present for student.

FA Need CSS 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