| Data element |
Definition |
ANNUAL_WORK_PERIOD
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive text indicating the annual work cycle for the position. |
ANNUAL_WORK_PERIOD_END_DATE
Format DATE
Indexed? No
May be Null? Yes |
The end date of the annual work cycle for the position. |
ANNUAL_WORK_PERIOD_START_DATE
Format DATE
Indexed? No
May be Null? Yes |
The start date of the annual work cycle for the position. |
BUSINESS_TITLE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The business title for the position. |
COMPANY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system name representing the Company for the position. |
COMPANY_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The descriptive name representing the Company for the position. |
CURR_POSITION_FILLED_EFF_DATE
Format DATE
Indexed? No
May be Null? Yes |
The most recent date on which the worker occupied the position. |
DEFAULT_WEEKLY_HOURS
Format NUMBER
Indexed? No
May be Null? Yes |
The standard hours for the position. |
DISBURSEMENT_PLAN_PD_END_DATE
Format DATE
Indexed? No
May be Null? Yes |
The end date of the disbursement plan period for the position. |
DISBURSEMENT_PLAN_PD_ST_DATE
Format DATE
Indexed? No
May be Null? Yes |
The start date of the disbursement plan period for the position. |
DISBURSEMENT_PLAN_PERIOD
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The descriptive text indicating the disbursement plan period for the position. |
EARLIEST_HIRE_DATE
Format DATE
Indexed? No
May be Null? Yes |
The worker's first date of hire into the position. |
END_EMPLOYMENT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which employment will end for a fixed term position. |
EXEMPT_POSITION_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the position is considered exempt. Under Federal law, employees are either exempt (Y) or nonexempt (N) from the Fair Labor Standards Act (FLSA) wage and hour regulations. Monthly-paid staff are exempt, and weekly-paid staff are non-exempt. |
FTE_PERCENT
Format NUMBER
Indexed? No
May be Null? Yes |
The ratio of a worker's scheduled weekly hours divided by the default weekly hours. This drives benefits eligibility. |
HISTORY_SEQUENCE
Format NUMBER(15)
Indexed? Yes
May be Null? Yes |
The unique sequence number that identifies the position history record.
The HISTORY_SEQUENCE number is stored in the POSITION_LINK_ID field of the HCM_WORKER_PAYMENT and HCM_WORKER_ENCUMBRANCE tables to allow joining of a payment record to the position history record that was active at the time of the payment or encumbrance. |
HOURLY_RATE
Format NUMBER
Indexed? No
May be Null? Yes |
The hourly rate for 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_BASE_PAY_INCREASE_AMOUNT
Format NUMBER
Indexed? No
May be Null? Yes |
The amount of the last increase to the base pay amount. |
LAST_COMPENSATION_CHANGE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The text describing the activity of the last compensation change. |
LAST_COMPENSATION_CHANGE_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date the compensation for the position was last changed. |
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. |
PAY_GROUP
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The pay group (e.g., academic, monthly, weekly) assigned to the position. Workers may not concurrently hold positions with different pay groups.
|
PAY_RATE_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The pay status (hourly or salaried) for the position.
|
PENN_CREF
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The default Chart of Accounts Center Reference code segment value (CREF) used in costing allocations for the position. |
PENN_FUND
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The default Chart of Accounts Fund code segment value used in costing allocations for the position. |
PENN_PROGRAM
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The default Chart of Accounts Program code segment value used in costing allocations for the position. |
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. |
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.
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.
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. |
TIME_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
A descriptive indicator of the time status for the position. This is not in any way or calculated based on the FTE_Percent. |
TOTAL_BASE_AMOUNT
Format NUMBER
Indexed? No
May be Null? Yes |
The total base salary amount 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. |
WORKER_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. |
