| Data element |
Definition |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the record was extracted from Workday and loaded to the Data Warehouse. |
MAILING_ADD_COUNTRY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The country of the person's mailing address. |
MAILING_ADD_COUNTRY_ISO_CODE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The ISO code for the country person's mailing address. |
MAILING_ADD_POSTAL_CODE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The postal code of the person's mailing address. |
MAILING_ADD_PROVINCE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The province of the person's mailing address. |
MAILING_ADD_REGION
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The region of the person's mailing address. |
MAILING_ADD_STATE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The state of the person's mailing address. |
MAILING_ADDRESS_CITY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The city or post office of the person's mailing address. |
MAILING_ADDRESS_LINE1
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The first line of the person's mailing address. |
MAILING_ADDRESS_LINE2
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The second line of the person's mailing address. |
MAILING_ADDRESS_LINE3
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The third line of the person's mailing address. |
MAILING_ADDRESS_LINE4
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fourth line of the person's mailing address. |
MAILING_ADDRESS_LINE5
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fifth line of the person's mailing address. |
MAILING_ADDRESS_LINE6
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The sixth line of the person's mailing address. |
MAILING_ADDRESS_LINE7
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The seventh line of the person's mailing address. |
MAILING_ADDRESS_LINE8
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The eighth line of the person's mailing address. |
MAILING_ADDRESS_LINE9
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The ninth line of the person's mailing address. |
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_ACADEMIC_UNIT_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Academic Unit of the person's primary appointment. This field is only populated for academic workers or affiliates with a current appointment. |
PRI_ACADEMIC_UNIT_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name representing the Academic Unit of the person's primary appointment. This field is only populated for academic workers or affiliates with a current appointment. |
PRI_HOME_ADD_COUNTRY_ISO_CODE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The ISO code for the country person's primary home address. |
PRI_HOME_ADDRESS_CITY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The city or post office of the person's primary home address. |
PRI_HOME_ADDRESS_COUNTRY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The country of the person's primary home address. |
PRI_HOME_ADDRESS_LINE1
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The first line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE2
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The second line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE3
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The third line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE4
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fourth line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE5
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fifth line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE6
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The sixth line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE7
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The seventh line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE8
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The eighth line of the person's primary home address. |
PRI_HOME_ADDRESS_LINE9
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The ninth line of the person's primary home address. |
PRI_HOME_ADDRESS_POSTAL_CODE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The postal code of the person's primary home address. |
PRI_HOME_ADDRESS_PROVINCE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The province of the person's primary home address. |
PRI_HOME_ADDRESS_REGION
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The region of the person's primary home address. |
PRI_HOME_ADDRESS_STATE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The state of the person's primary home address. |
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. |
PRI_SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Supervisory Organization for the person's primary position. This field is only populated for workers with a current position. |
PRI_SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name representing the Supervisory Organization for the person's primary position. This field is only populated for workers with a current position. |
PRI_WORK_ADD_COUNTRY_ISO_CODE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The ISO code for the country person's primary work address. |
PRI_WORK_ADDRESS_CITY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The city or post office of the person's primary work address. |
PRI_WORK_ADDRESS_COUNTRY
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The country of the person's primary work address. |
PRI_WORK_ADDRESS_LINE1
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The first line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE2
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The second line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE3
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The third line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE4
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fourth line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE5
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fifth line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE6
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The sixth line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE7
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The seventh line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE8
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The eighth line of the person's primary work address. |
PRI_WORK_ADDRESS_LINE9
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The ninth line of the person's primary work address. |
PRI_WORK_ADDRESS_POSTAL_CODE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The postal code of the person's primary work address. |
PRI_WORK_ADDRESS_PROVINCE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The province of the person's primary work address. |
PRI_WORK_ADDRESS_REGION
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The region of the person's primary work address. |
PRI_WORK_ADDRESS_STATE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The state of the person's primary work address. |
PRIMARY_HOME_PHONE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The person's primary home phone number. |
PRIMARY_WORK_PHONE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The person's primary work phone number. |
WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
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. |
