Penn Computing

University of Pennsylvania
Penn Computing << go backback

 

OIP_PERSON_EMPLOYEE Table . Tables and Data Elements . ISSS Data Home . Data Warehouse Home

OIP_PERSON_EMPLOYEE Table - Data Element Index

 

 

 

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, see http://www.upenn.edu/computing/da/privacy/

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.

 

OIP_PERSON_EMPLOYEE Table . Tables and Data Elements . ISSS Data 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