Penn Computing

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

 

BIO 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)

Foreign_Student_Indicator

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

Foreign Student Indicator

 
High_Need_Indicator

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

Student considered high need by Financial Aid Office.

 
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.

 
Name

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

Name from the Student Aid Management (SAM) Bio file.

 
Penn_ID

Indexed - yes
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.

 
Philadelphia_Resident_Ind

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

Comes from Undergraduate Admissions. This is the most reliable way of determining if a student was a Philadelphia resident when he/she was admitted. (use for undergraduate students only).

 
Sid

Indexed - yes
Format - Char
May be Null? N

Social security number from source system. This is a protected field.

 
Special_Admissions_Group

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

Indicates the student is being considered in a special admissions group category (Questbridge, Posse, etc.)

 
Ugrad_Admissions_Group

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

Includes early decision students deferred and then accepted (DEFR), early decision freshmen (EDP), regular decision freshmen (FRSH), and transfer students (STRN)

 
FA_BIO 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