Scheduled Shift Segment

The Scheduled Shift Segment entity provides the scheduled shift segment details for an employee. Using this entity, a manager can analyze employees’ scheduled shift segments (regular, transfers, and breaks), scheduled job, and scheduled labor categories in a defined time period.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

X

Data granularity

Provides one row per employee per scheduled shift segment.

Columns

Label

Key

Cost Center

SCH_SHIFTSEGMENT_COST_CENTER

Job Transfer Indicator

SCH_SHIFTSEGMENT_IS_TRANSFER_ORG_JOB

Labor Categories

SCH_SHIFTSEGMENT_LABOR_CATEGORIES

Labor Category Transfer Indicator

SCH_SHIFTSEGMENT_IS_TRANSFER_LABOR_ACCOUNT

Primary Cost Center

SCH_SHIFTSEGMENT_PRIMARY_COST_CENTER

Primary Job

SCH_SHIFTSEGMENT_PRIMARY_ORG_JOB

Primary Labor Categories

SCH_SHIFTSEGMENT_PRIMARY_LABOR_CATEGORIES

Primary Labor Category

SCH_SHIFTSEGMENT_PRIMARY_LABOR_ACCOUNT

Primary Work Rule

SCH_SHIFTSEGMENT_PRIMARY_WORK_RULE

Scheduled Job

SCH_SHIFTSEGMENT_ORG_JOB

Scheduled Labor Category

SCH_SHIFTSEGMENT_LABOR_ACCOUNT

Shift Segment End Date

SCH_SHIFTSEGMENT_END_DATE

Shift Segment Start Date

SCH_SHIFTSEGMENT_START_DATE

Shift Segment Type

SCH_SHIFTSEGMENT_TYPE

Skill and Certification Profile

SCH_SHIFTSEGMENT_SCPROFILE_REFERENCE

Transfer Cost Center Indicator

SCH_SHIFTSEGMENT_IS_TRANSFER_COST_CENTER

Transfer Labor Categories Indicator

SCH_SHIFTSEGMENT_IS_TRANSFER_LABOR_CATEGORIES

Transfer String

SCH_SHIFTSEGMENT_TRANSFER_STRING

User Entered Cost Center Indicator

SCH_SHIFTSEGMENT_IS_USER_ENTERED_COST_CENTER

User Entered Job Transfer Indicator

SCH_SHIFTSEGMENT_IS_USER_ENTERED_ORG_JOB

User Entered Labor Categories

SCH_SHIFTSEGMENT_USER_ENTERED_LABOR_CATEGORIES

User Entered Labor Category

SCH_SHIFTSEGMENT_USER_ENTERED_LABOR_ACCOUNT

User Entered Labor Category Indicator

SCH_SHIFTSEGMENT_IS_USER_ENTERED_LABOR_ACCOUNT

User Entered Work Rule Indicator

SCH_SHIFTSEGMENT_IS_USER_ENTERED_WORK_RULE

Work Rule

SCH_SHIFTSEGMENT_WORK_RULE

Work Rule Transfer Indicator

SCH_SHIFTSEGMENT_IS_TRANSFER_WORK_RULE

Additional information

Each scheduled shift segment can have a scheduled job transfer or a scheduled labor category transfer for the employee. Use the Scheduled Job and Scheduled Labor Category data columns in the Scheduled Shift Segment entity to examine this information.

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

X

X

Relationship

One-to-One

One-to-Many

X