Penn Computing

University of Pennsylvania
Penn Computing << go backback
HCM_PERSON_PASSPORT Table    Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

HCM_PERSON_PASSPORT Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.




Data element Definition

EXPIRATION_DATE

Format DATE

Indexed? No

May be Null? Yes

The date when the passport expires.

IDENTIFICATION_NUMBER

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The unique number assigned to the passport at its time of issuance.

ISSUED_BY_COUNTRY

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The country that issued the passport.

ISSUED_BY_COUNTRY_ISO_CODE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The ISO country code of the country that issued the passport.

ISSUED_DATE

Format DATE

Indexed? No

May be Null? Yes

The date when the passport was issued.

LAST_EXTRACT_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which the record was extracted from warehouse staging and loaded to the Data Warehouse.

PASSPORT_ID_TYPE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The type of passport.

PENN_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.

PRI_PENN_AU_COST_CENTER

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 4-digit number for the Penn Cost Center associated with the Academic Unit of the person's primary appointment. This field is only populated for academic workers or affiliates with a current appointment.

PRI_PENN_COST_CENTER

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 4-digit number for the Penn Cost Center associated with the primary position. This field is only populated for workers with a current position.

PRI_PENN_SCH_CTR

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 2-digit number used to identify the school or center for the Penn Cost Center associated with the primary position. This field is only populated for workers with a current position.

VERIFICATION_DATE

Format DATE

Indexed? No

May be Null? Yes

The date when the passport was verified.

VERIFIED_BY_WORKDAY_ID

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Workday ID of the person who verified the passport.

WORKDAY_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The unique ID for a worker or affiliate in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID.

 
HCM_PERSON_PASSPORT Table    Tables and Data Elements   Human Capital Management 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