Location Scheduling Indicators
The Location Scheduling Indicators column provides data that allows you to create Dataviews that show the values for one or more location-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 location or job.
Columns
|
Label |
Description |
Key |
|---|---|---|
|
Indicator Date |
Date for which the indicator value has been returned. |
SCH_LOC_INDICATOR_DATE |
|
Indicator Selector |
Allows a user to select from a drop-down list one or more location-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, Business Structure) 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_LOC_INDICATOR_SELECTOR |
|
Indicator Selector (Currency) |
Allows selecting domain indicators of type currency that will be added as column |
SCH_LOC_INDICATOR_SELECTOR_CURRENCY |
|
Indicator Selector (Hours) |
Allows selecting domain indicators of type hours that will be added as column |
SCH_LOC_INDICATOR_SELECTOR_HOURS |
|
Indicator Selector (Number) |
Allows selecting domain indicators of type number that will be added as column |
SCH_LOC_INDICATOR_SELECTOR_DOUBLE |
|
Indicator Selector (Percentage) |
Allows selecting domain indicators of type percentage that will be added as column |
SCH_LOC_INDICATOR_SELECTOR_PERCENTAGE |
Related entities
Core entity
|
Employee |
Organization |
Day |
Organizational Job |
Paycode |
Labor Category |
Activity |
|---|---|---|---|---|---|---|
|
X |
X |
X |
Relationship
|
One-to-One |
One-to-Many |
|---|---|
|
X |