|
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 |
|
R2T4_Fall
Indexed - no
Format - CHAR(1 Char)
May be Null? Y |
SAM-SPTAL2 (A1) - used for Fall return of TIV funds (value = 'F') |
|
R2T4_Spring
Indexed - no
Format - CHAR(1 Char)
May be Null? Y |
SAM-SPTAL3 (A1) - used for Spring return of TIV funds (value = 'S') |
|
R2T4_Summer
Indexed - no
Format - CHAR(1 Char)
May be Null? Y |
SAM-SPTAL4 (A1) - used for Summer return of TIV funds (value = 'M') |
|
