Employee Scheduling Indicators

The Employee Scheduling Indicators column provides data that allows you to create Dataviews that show the values for one or more employee-based indicators that have been defined for scheduling metrics.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per day per employee.

Columns

Label

Description

Key

Indicator Date

Date for which the indicator value has been returned.

SCH_EMP_INDICATOR_DATE

Indicator Selector

Allows a user to select from a drop-down list one or more employee-based indicators that will appear as columns in the Dataview. Indicators are configured in Application Setup > Scheduler Setup > Metrics Setup > Indicators. ​The selections that are provided in the list are determined by the type of Dataview (here, Employee) and the formula that is used in the indicator.

Note: When adding an indicator column to a Dataview, you should edit its label (by default, "Indicator Selector") that distinguishes it from other indicator columns that may be added.

SCH_EMP_INDICATOR_SELECTOR

Indicator Selector (Currency)

Allows selecting domain indicators of type currency that will be added as column

SCH_EMP_INDICATOR_SELECTOR_CURRENCY

Indicator Selector (Hours)

Allows selecting domain indicators of type hours that will be added as column

SCH_EMP_INDICATOR_SELECTOR_HOURS

Indicator Selector (Number)

Allows selecting domain indicators of type number that will be added as column

SCH_EMP_INDICATOR_SELECTOR_DOUBLE

Indicator Selector (Percentage)

Allows selecting domain indicators of type percentage that will be added as column

SCH_EMP_INDICATOR_SELECTOR_PERCENTAGE

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

Activity

X

Relationship

One-to-One

One-to-Many

X