Data element |
Definition |
CURR_POSITION_FILLED_EFF_DATE
Format DATE
Indexed? No
May be Null? Yes |
The most recent date on which the worker occupied the position. |
JOB_PROFILE_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system identifier of the job profile for the position. For job profiles converted from legacy systems to Workday, this is the same number as the Job_Class code. |
JOB_PROFILE_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the job profile for the position. |
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. |
MANAGER_PENN_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Penn ID of the manager for the position. |
MANAGER_WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The Workday ID of the manager for the position. |
OCCUPANT_FROM_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date from which the worker occupied the position. |
OCCUPANT_FROM_FISCAL_YEAR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The fiscal year from which the worker occupied the position. |
OCCUPANT_FROM_YEAR
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The calendar year from which the worker occupied the position. |
PENN_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 8-digit identification number assigned to the worker 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. |
POSITION_EMPLOYEE_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The employee type assigned to the position (e.g. academic, staff, student). |
POSITION_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The unique system identifier for the position. |
POSITION_PENN_COST_CENTER
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 4-digit number for the Penn Cost Center associated with the position. |
POSITION_SCHOOL_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 position. |
POSITION_STATUS
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The status of the position. |
POSITION_TITLE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The title for the position. |
POSITION_VACATED_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the worker left the position. |
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 worker's primary 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 worker's primary position. |
PRIMARY_POSITION_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For individuals with multiple current positions, a Y/N flag indicating the primary position. |
PRIOR_INCUMBENT_EMPLOYEE_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Workday ID of the prior incumbent of the position. |
PRIOR_INCUMBENT_PENN_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Penn ID of the prior incumbent of the position. |
SUPERVISORY_ORG_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Supervisory Organization for the position. |
SUPERVISORY_ORG_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name representing the Supervisory Organization for the position. |
WORKDAY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The unique ID for the worker in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID. |