|
Oip_Id_Number
|
The unique identifier for a record (use this value to map records in this
data collection).
|
|
SSN
|
Social Security Number. Access to SSN requires approval; individuals who do not have access to SSNs will see nulls in this column.
|
| Penn_ID |
Penn_ID (can be null, if the person has not yet been assigned a PennID) |
| Last_Name |
Last Name, as it appears on the person's passport. This may be different
from the name that is found in the Payroll and Student Data System collections. |
| First_Name |
First Name, as it appears on the person's passport. This may be different
from the name that is found in the Payroll and Student Data System collections. |
| Middle_Name |
Middle Name, as it appears on the person's passport. This may be different
from the name that is found in the Payroll and Student Data System collections. |
| Birth_Date |
Birth Date, as it appears on the person's passport. This may be different
from the date of birth that is found in the Payroll and Student Data System
collections. |
| Immigration_Status |
Represents the immigrations status code (use OIP_IMMIGRATION_STATUS_CODE
to map immigration status description). For example:
F-1 (F1 Student)
H1B (Temp Worker)
|
| Country_of_Citizenship |
Country of citizenship (use OIP_COUNTRY_CODE to map description) |
| Country_of_Birth |
Country of birth (use OIP_COUNTRY_CODE to map description) |
| Country_of_Residence |
The person's country of residence immediately prior to coming to the University
of Pennsylvania (use OIP_COUNTRY_CODE to map description) |
| Campus_ID |
Represents the source system description for a person.
1 – University of Pennsylvania (Student or Worker)
2 – ELP Student (English Language Program)
|
| Last_Activity_Date |
Date the record was last modified by source system. |
| Last_Extract_Date |
Date the record was last imported into the data warehouse. |
