|
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 |
|
| Need_Level_Indicator
Indexed - no
Format - Varchar2(1)
May be Null? Y |
Identifies the need level/complexity of need, as determined by the Financial Aid office.
Values:
HN = High Need
ML = Medium
CL = Complex
|
|
| 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). |
|
Bio Entintc Indexed - no
Format - Date
May be Null? Y |
Date the student was notified when a direct loan exit interview is required. |
|
Bio Expgrdc Indexed - no
Format - Date
May be Null? Y |
Date the student was notified when an ECSI loan exit interview is required. |
|
Bio Extint Indexed - no
Format - Date
May be Null? Y |
Date of completed direct loan exit interview. This date is cleared if student previously completed an exit interview, but had an enrollment gap, and now needs to complete another one. |
|
| 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) |
|
