Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_APPLICATION Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

APPLICATION Table - Data Element Index

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



 

Data element

Definition

Object name in Business Objects universe (if different from data element name)

Admission_Status

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

Specifies whether students are admits, matriculants, cancels, declines, or deferred admission. Use TRK-ADMSTAT and translate, 0 = CANDIDATE, 1 = MATRICULANT, 2 = CANCEL, 3 = CAD, 5 = HOLDOVER (or use x-reference table)

 
Application_Complete_Date

Indexed - no
Format - Date
May be Null? Y

The date the aid application was completed; required for need-based aid to disburse.

 
Application_Status

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

The current status of the application for Need-based aid

Values:

incomplete
application complete
needs analysis complete
evaluation complete
packaging complete
notification complete

 
Contrib_Child_Support

Indexed - no
Format - Number
May be Null? Y

Parental contribution from child support as reported on the FAFSA

 
Contrib_Other

Indexed - no
Format - Number
May be Null? Y

Student contribution from other resources

 
Contrib_Student_Assets

Indexed - no
Format - Number
May be Null? Y

This amount is calculated based on the value of student assets, if any

 
Contrib_Student_Savings

Indexed - no
Format - Number
May be Null? Y

Contribution from summer savings varies based on student's year in school, whether or not they receive outside scholarships, or are considered to be high need

 
Effect_Parent_Contrib

Indexed - no
Format - Number
May be Null? Y

The portion of the Parent_Contribution that comes from custodial parent.

 
Electronic_Profile_Received

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

Profile received from College Board.

Values:
Y – Profile received from the College Board
N – Profile not received

 
FAFSA_Submitted

Indexed - no
Format - Date
May be Null? Y

The date that the Institutional Information Student Record (ISIR) was received. The ISIR contains information from the Free Application for Federal Student Aid (FAFSA). Much of the student's initial financial aid application is populated from FAFSA data.

 
Fall_Course_Units_Enrolled

Indexed - no
Format - Number
May be Null? Y

This is the number of course units for which the student is enrolled for the Fall semester.

 
Father_Date_Of_Birth

Indexed - no
Format - Date
May be Null? Y

Father's date of birth as reported on FAFSA

 
Father_Educ_Level

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

College, High School, Middle School, Elementary School, Unknown

 
Fed_Dependency_Ind

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

Student considered dependent by federal methodology.

Values:
Y – student is considered a dependent
N – student is not considered a dependent

 
Fed_Expect_Fam_Contrib

Indexed - no
Format - Number
May be Null? Y

This value reflects the federal standard methodology for calculating family contribution. See Penn_Expect_Fam_Contrib for description of the Expected Family Contribution.

 
Fed_Parent_Contrib

Indexed - no
Format - Number
May be Null? Y

This value reflects the federal standard methodology for calculating parental contribution. See Penn_Expect_Fam_Contrib for description of the Expected Parental Contribution.

 
File_Complete_Date

Indexed - no
Format - Date
May be Null? Y

Date when application status changed to complete. Required to allow Aid to be packaged.

 
Freshman_Dual_Deg_Indicator

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

Indicator of whether or not freshman student admitted as dual degree candidate

Values:
Y – student admitted as dual degree candidate
N – student not admitted as dual degree

 
Gross_Financial_Need

Indexed - no
Format - Number
May be Null? Y

This value, which can be positive or negative, reflects the difference between the expected student budget based on calculated cost of attendance and the student's expected family contribution. Penn offers aid to completely cover student gross financial need

 
Load_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this student's record was refreshed in the warehouse from the Student Aid Management system (SAM). Does not indicate a specific column in a table has changed; the entire student's record gets refreshed whenever there is any change in SAM

 
Mother_Date_Of_Birth

Indexed - no
Format - Date
May be Null? Y

Mother's date of birth as reported on FAFSA

 
Mother_Educ_Level

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

Mother's highest level of education as reported on FAFSA.

Values: College, High School, Middle School, Elementary School, Unknown

 
Need_Based_Aid_Ind

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

Need-based recipients are students who were found to demonstrate need beyond their expected family contribution. Students with an EFC greater than their budget have a negative need, and they will therefore receive no institutional aid.

Values:
Y – student is a need-based applicant
N – student is not a need-based applicant

 
Need_Based_Track_Indicator

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

Based on student being assigned a Need-based financial aid track.

Values:
Y – student has been assigned to a need-based financial aid track
N – student has not been assigned to a need-based financial aid track

 
Non_Cust_Parent_Contrib

Indexed - no
Format - Number
May be Null? Y

Amount of financial contribution expected this year from the non-custodial parent. This also includes any child support reported.

 
Non_Cust_Parent_Contrib_Ind

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

This indicator is used if parents are divorced and if the non-custodial parent contributes to student's school-related expenditures. This also includes any child support reported.

Values:
Y – the non-custodial parent contributes to school-related expenses
N – the non-custodial parent does not contribute to school-related expenses

 
Parent_Agi_Reported

Indexed - no
Format - Number
May be Null? Y

Adjusted Gross Income from parent tax return, not necessarily the income used for Needs Analysis. See also PARENT_AGI_SOURCE.

 
Parent_Agi_Source

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

Source of Reported Adjusted Gross Income

Values: Tax Return, FAFSA

 
Parent_Business_Farm_Equity

Indexed - no
Format - Number
May be Null? Y

Value of business and farm equity as reported on FAFSA

 
Parent_Business_Income

Indexed - no
Format - Number
May be Null? Y

Business Income from tax return (Schedule C)

 
Parent_Cash_Acct_Balance

Indexed - no
Format - Number
May be Null? Y

Cash and Bank Account Balance as reported on the FAFSA

 
Parent_Contribution

Indexed - no
Format - Number
May be Null? Y

This value represents the contribution from the parent(s) (custodial and non-custodial).

 
Parent_Deductions

Indexed - no
Format - Number
May be Null? Y

Total deductions listed on tax return

 
Parent_Exemptions

Indexed - no
Format - Number
May be Null? Y

Number of Exemptions Claimed from tax return

 
Parent_Farm_Income

Indexed - no
Format - Number
May be Null? Y

Farm Income from tax return

 
Parent_Fed_Tax_Submitted

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

Parental tax form submitted (Y/N)

 
Parent_Home_Debt

Indexed - no
Format - Number
May be Null? Y

Home Debt Amount as reported on FAFSA

 
Parent_Home_Equity

Indexed - no
Format - Number
May be Null? Y

Home Equity Amount as reported on FAFSA

 
Parent_Home_Purchase_Amount

Indexed - no
Format - Number
May be Null? Y

Home Purchase Amount as reported on FAFSA

 
Parent_Home_Purchase_Year

Indexed - no
Format - Number
May be Null? Y

Home Purchase Year amount as reported on FAFSA

 
Parent_Home_Value_Computed

Indexed - no
Format - Number
May be Null? Y

Home Value Computed amount as reported on FAFSA

 
Parent_Home_Value_Reported

Indexed - no
Format - Number
May be Null? Y

Home Value Reported amount as reported on FAFSA

 
Parent_Household_In_College

Indexed - no
Format - Number
May be Null? Y

Number of family members in college as reported on FAFSA. For families with more children in college, the expected family contribution is lower than those with fewer children in college.

 
Parent_Household_Size

Indexed - no
Format - Number
May be Null? Y

Parent's reported size of household, for dependent students only

 
Parent_Inv_Real_Estate_Equity

Indexed - no
Format - Number
May be Null? Y

Value of investment equity and other real estate as reported on FAFSA

 
Parent_Need_Analysis_Income

Indexed - no
Format - Number
May be Null? Y

Calculated income used in Needs analysis:

Needs Analyzer Income = PC_Total_Inc minus IM_PC_Housing_Adjustment minus IM_PC_Bus_Add_Back_BAB

 
Parent_Net_Worth

Indexed - no
Format - Number
May be Null? Y

Sum of Cash and Bank Account Balance, Inv. Equity / Other Real Estate, Bus/Farm Equity, and Home Equity

 
Parent_Rental_Income

Indexed - no
Format - Number
May be Null? Y

Income from tax return - Schedule E

 
Penn_Dependency_Ind

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

Student considered dependent by the institution? (Y/N)

 
Penn_Expect_Fam_Contrib

Indexed - no
Format - Number
May be Null? Y

The Expected Family Contribution, or EFC, is the amount the institution expects the student and his or her parents or guardians to provide to attend Penn.

 
Penn_Fin_Aid_Supp_Submitted

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

Penn Financial Aid Supplement submitted (Y/N)

 
Penn_Id

Indexed - no
Format - Char
May be Null? Y

The 8-digit identification number assigned to the student; populated from a lookup to an extract from the PennCommunity database

 
Prior_Degree_Indicator

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

Indicator for students who have received prior degree (Y/N) (undergraduates only)

 

Prior_Dept_Grant_Awarded

Total paid to the student for terms prior to this term from departmental grant sources

 
Prior_Endow_Fund_Awarded Total Funds paid from from Endowment Awarded for terms prior to this term  
Prior_Fac_Staff_Awarded Total paid to the student for terms prior to this term from Faculty and Staff Benefits  
Prior_Fed_Grant_Awarded Total Federal grant aid paid to student for terms prior to this term. Includes, Pell grant, Academic Competitiveness grant (ACG), SMART grant, and Supplemental Educational Opportunity Grant (SEOG)  
Prior_Gradplus_Awarded Total paid to the student for terms prior to this term from GradPLUS and Direct GradPLUS Loan funds.  
Prior_Health_Prof_Awarded Total paid to the student for terms prior to this term from Health Profession Loan funds Prior Health Profession Loan Awarded
Prior_Inst_Grant_Awarded Total institutional grant aid paid to student for terms prior to this term. This is the sum of unrestricted funds, funds from endowment, and term gift funds  
Prior_Loan_Awarded Total paid to the student from terms prior to this term from loans borrowed from Federal, institutional, and outside sources  
Prior_Nursing_Loan_Awarded Total paid to the student for terms prior to this term from Nursing loan funds  
Prior_Outside_Awarded Total paid to the student for terms prior to this term from Outside Grant sources  
Prior_Other_Inst_Loan_Awarded Total paid to the student for terms prior to this term from Non-Federal / Institutional Loan Sources  
Prior_Packaged_Loan_Awarded Total loan amount packaged in student's financial aid package from prior terms  
Prior_Penn_Guar_Loan_Awarded Total paid to the student for terms prior to this term from Penn guaranteed loan funds  
Prior_Perkins_Awarded Total paid to the student for terms prior to this term from Perkins Loan  
Prior_Private_Loan_Awarded Total paid to the student for terms prior to this term from Private Loans  
Prior_Staffford_Awarded Total paid to the student for terms prior to this term from Stafford Loans (2009 and prior) or Total Direct Loans (starting in 2010) Prior Stafford Direct Loans Awarded
Prior_State_Grant_Awarded Total paid to the student for terms prior to this term from State Grant funds  
Prior_Term_Gift_Awarded Total grant paid to the student from Term Gifts for terms prior to this term.  
Prior_Unres_Fund_Awarded Total Grant paid from Unrestricted Funds for terms prior to this term.  
Prior_Work_Study_Awarded Amount of Work Study awarded prior to the current application term, if any.  
SAM_School_Code The two-digit code for the school used in the SAM system. See dwsfa.fa_school_lookup table for mapping to SRS school and division codes.  
SAM_Term

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

Identifies the term to which the associated Student Aid Management information pertains. 'B' implies the fall term of the calendar year, followed by the spring term of the following calendar year. 'A' is the label for the summer session before the academic year, and 'C' is the tag for the summer session following the academic year. (E.g. 2009B is Fall 2009 to Spring 2010, 2009C is the first summer session in Summer 2010, followed by 2010A for the second summer session)  
Self_Help_Base

Indexed - no
Format - Number
May be Null? Y

Standard amount of expected student self-help. For most students, this amount will be awarded in work study.

 
Self_Help_Level

Indexed - no
Format - Number
May be Null? Y

Revised Self Help Base as determined by current term award

 
Sid

Indexed - yes
Format - Char
May be Null? N

Social Security Number which is key from the SAM source

 
Spring_Course_Units_Enrolled

Indexed - no
Format - Number
May be Null? Y

This is the number of course units for which the student is enrolled for the Spring semester.

 
SRS_Division_Code The 2-character code for the school used in the Student Records System (SRS) See also the dwsfa.fa_school_lookup table for code mappings.  
SRS_School_Code The 3-character code for the division used in the Student Records System (SRS) See also the dwsfa.fa_school_lookup table for code mappings.  
State_Of_Legal_Residence

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

Parent state of legal residence (if student dependent), or student state of legal residence.

Values: 2-character US State codes.

 
Student_Agi_Reported

Indexed - no
Format - Number
May be Null? Y

Student Adjusted Gross Income from the student’s tax return. While this income is taken into account, it is not reflected in the Needs Analyzer income values used for income reporting.

 
Student_Cash_Acct_Balance

Indexed - no
Format - Number
May be Null? Y

Student Cash and Bank Account Balance

 
Student_Contribution

Indexed - no
Format - Number
May be Null? Y

Student contribution is comprised of expected savings from summer employment (which varies based on the student's year in school) and any assets and investment dividends belonging to the student

 
Student_Cost_Attendance

Indexed - no
Format - Number
May be Null? Y

This value is usually the projected cost of attendance as determined by Admissions. This includes the actual and projected costs that make up cost of student attendance, including tuition, fees, room, board, textbooks, and some personal expenses

 
Student_Earnings

Indexed - no
Format - Number
May be Null? Y

Student earnings as reported on FAFSA for given year.

 
Student_Fed_Tax_Submitted

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

Student Federal Tax Return submitted (Y/N)

 
Student_Net_Worth

Indexed - no
Format - Number
May be Null? Y

Net worth of student (cash and investments)

 
Student_Spouse_Earnings

Indexed - no
Format - Number
May be Null? Y

Student Spouse Earnings as reported on FAFSA for given year.

 
Student_Spouse_Total_Income

Indexed - no
Format - Number
May be Null? Y

Student/Spouse Total Income as reported on FAFSA for given year.

 
Student_Total_Assets

Indexed - no
Format - Number
May be Null? Y

Student Total Assets as reported on FAFSA for given year.

 
Total_Endow_Fund_Awarded

Indexed - no
Format - Number
May be Null? Y

Total Funds paid from from Endowment Awarded

 
Total_Dept_Grant_Awarded Total paid to the student for this term from departmental grant sources  
Total_Fac_Staff_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from Faculty and Staff Benefits

 
Total_Fed_Grant_Awarded

Indexed - no
Format - Number
May be Null? Y

Total Federal grant aid offered to student in given term. Includes, Pell grant, Academic Competitiveness grant (ACG), SMART grant, and Supplemental Educational Opportunity Grant (SEOG)

 
Total_Gradplus_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from GradPLUS and Direct GradPLUS Loan funds.

 
Total_Health_Prof_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from Health Profession Loan funds

 
Total_Inst_Grant_Awarded

Indexed - no
Format - Number
May be Null? Y

Total institutional grant aid offered to student in given term. This is the sum of unrestricted funds, funds from endowment, and term gift funds

 
Total_Loan_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from loans borrowed from Federal, institutional, and outside sources

 
Total_Nursing_Loan_Awarded Total paid to the student for this term from Nursing loan funds  
Total_Other_Inst_Loan_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from Non-Federal / Institutional Loan Sources

Total Other Inst Loan Awarded
Total_Outside_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from Outside Grant sources

 
Total_Packaged_Loan_Awarded

Indexed - no
Format - Number
May be Null? Y

Total loan amount packaged in student's financial aid package

 
Total_Penn_Guar_Loan_Awarded Total paid to the student for this term from Penn guaranteed loan funds  
Total_Perkins_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from Perkins Loan

 
Total_Private_Loan_Awarded Total paid to the student for this term from Private Loans  
Total_Stafford_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from Stafford Loans (2009 and prior) or Total Direct Loans (starting in 2010)

Total Stafford Direct Loans Awarded
Total_State_Grant_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student from State Grant funds this term

 
Total_Term_Gift_Awarded

Indexed - no
Format - Number
May be Null? Y

Total grant paid to the student from Term Gifts this term

 
Total_Unres_Fund_Awarded

Indexed - no
Format - Number
May be Null? Y

Total Grant paid from Unrestricted Funds

 
Total_Work_Study_Awarded

Indexed - no
Format - Number
May be Null? Y

Total paid to the student for this term from work study funds. Work study award types include Federal Work Study, Penn Work Study, and International Work Study.

 

Track

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

Financial Aid Track  

YearinSch

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

Year in School  
FA_APPLICATION Table   Tables and Data Elements   FinAid 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