Penn Computing

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

HCM_POSITION_HISTORY_GENERAL_V Table - Data Element Index

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




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.

 
HCM_POSITION_HISTORY_GENERAL_V 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