| 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_PENN_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Penn ID of the prior incumbent of the position. |
PRIOR_WORKDAY_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The Workday ID of the prior incumbent of the position. |
RECORD_END
Format DATE
Indexed? Yes
May be Null? Yes |
The date and time that the position history record was no longer the "active" history record for the position.
Note: the RECORD_START and RECORD_END dates are not the dates when a change to a position was effective in Workday but rather the dates when a change to a position was first reflected in the warehouse (RECORD_START) and subsequently superseded (RECORD_END). |
RECORD_START
Format DATE
Indexed? Yes
May be Null? Yes |
The date and time that the position history record became the "active" history record for the position.
Note: the RECORD_START and RECORD_END dates are not the dates when a change to a position was effective in Workday but rather the dates when a change to a position was first reflected in the warehouse (RECORD_START) and subsequently superseded (RECORD_END).
|
SCD_ACTIVE
Format NUMBER(15)
Indexed? Yes
May be Null? Yes |
Indicates whether (1) or not (0) the position history record is the "active" record. The "active" position history record is the record that contains the current data for the position as stored in the HCM_POSITION table. |
SCD_END
Format DATE
Indexed? Yes
May be Null? Yes |
The date and time that the position history record was no longer the "active" history record for the position_id/workday_id combination.
Note: the SCD_START and SCD_END dates are not the dates when a change to a position was effective in Workday but rather the dates when a change to a position was first reflected in the warehouse (SCD_START) and subsequently superseded (SCD_END). |
SCD_START
Format DATE
Indexed? Yes
May be Null? Yes |
The date and time that the position history record became the "active" history record for the position_id/workday_id combination.
Note: the SCD_START and SCD_END dates are not the dates when a change to a position was effective in Workday but rather the dates when a change to a position was first reflected in the warehouse (SCD_START) and subsequently superseded (SCD_END).
|
SCD_VERSION
Format NUMBER(15)
Indexed? Yes
May be Null? Yes |
The version number of the history record for 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. |
