Worked Job

The Worked Job entity provides the data columns necessary to understand the job an employee worked or was scheduled to work. This job may be different than the employee’s primary job.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Not applicable. The Worked Job entity provides only dimensional data.

Columns

Label

Description

Key

Job Description — Full Path (Worked)

Full path of the job to which actual, scheduled, or projected time is charged using the description of each location.

CORE_ORGJOB_PATH_DSC

Job Full Name — Full Path (Worked)

Full path of the job to which actual, scheduled, or projected time is charged using the full name of each location.

CORE_ORGJOB_PATH_FULL_NM

Job Name - Full Path (Worked)

Full path of the job to which actual, scheduled, or projected time is charged.

CORE_ORGJOB_PATH

Job Name (Worked)

Path of the job to which actual, scheduled, or projected time is charged.

CORE_ORGJOB

Location Description (Worked)

Description of the worked location based on the selected location type.

CORE_ORGJOB_LOCATION_DESCRIPTION

Location Full Name (Worked)

Full name of the worked location based on the selected location type.

CORE_ORGJOB_LOCATION_FULL_NAME

Location Name (Worked)

Name of the worked location based on the selected location type.

CORE_ORGJOB_LOCATION_NAME

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

Relationship

One-to-One

One-to-Many

X