Schedule Metrics by Day (Location)
The Schedule Metrics by Day (Location) entity provides the data columns needed to show hours per volume or HPPD for a location. It includes columns that report the volume (census) for a location as well as the workload hours for each job in the location. It also provides the calculated hours per volume values.
Supported Dataview types
Employee Dataview |
Business Structure Dataview |
---|---|
X |
Data granularity
Provides one row per location per day
Columns
Label |
Description |
Key |
---|---|---|
Actual Volume (Day) |
Actual volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_ACTUAL_VOLUME |
Actual Weighted Volume (Day) |
Actual weighted volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_ACTUAL_WEIGHTED_VOLUME |
Budget Volume (Day) |
Budgeted volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_BUDGET_VOLUME |
Budget Weighted Volume (Day) |
Budgeted weighted volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_BUDGET_WEIGHTED_VOLUME |
Direct Actual Hours (Day) |
Direct actual hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_ACTUAL_HOURS |
Direct Actual Hours per Volume (Day) |
Direct actual hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_ACTUAL_HPPD |
Direct Budget Hours (Day) |
Direct budgeted hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_BUDGET_HOURS |
Direct Budget Hours per Volume (Day) |
Direct budgeted hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_BUDGET_HPPD |
Direct Hours per Volume Variance (Day) |
Direct variance hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_VARIANCE_HPPD |
Direct Scheduled Hours (Day) |
Direct scheduled hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_SCHEDULED_HOURS |
Direct Scheduled Hours per Volume (Day) |
Direct scheduled hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_SCHEDULED_HPPD |
Direct Target Hours (Day) |
Direct target hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_TARGET_HOURS |
Direct Target Hours per Volume (Day) |
Direct target hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_TARGET_HPPD |
Direct Total Variance Hours (Day) |
Direct total variance hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_DIRECT_TOTAL_VARIANCE_HOURS |
Indirect Actual Hours (Day) |
Indirect actual hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_ACTUAL_HOURS |
Indirect Actual Hours per Volume (Day) |
Indirect actual hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_ACTUAL_HPPD |
Indirect Budget Hours (Day) |
Indirect budgeted hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_BUDGET_HOURS |
Indirect Budget Hours per Volume (Day) |
Indirect budgeted hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_BUDGET_HPPD |
Indirect Hours per Volume Variance (Day) |
Indirect variance hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_VARIANCE_HPPD |
Indirect Scheduled Hours (Day) |
Indirect scheduled hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_SCHEDULED_HOURS |
Indirect Scheduled Hours per Volume (Day) |
Indirect scheduled hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_SCHEDULED_HPPD |
Indirect Target Hours (Day) |
Indirect target hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_TARGET_HOURS |
Indirect Target Hours per Volume (Day) |
Indirect target hours per volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_TARGET_HPPD |
Indirect Total Variance Hours (Day) |
Indirect total variance hours for the day. |
SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_TOTAL_VARIANCE_HOURS |
Location Name (Path) |
Location name (path) for which metric has been returned |
SCH_LOCATION_DAY_BASED_METRICS_LOCATION_NAME_PATH |
Metric Date |
Date for the metric that has been returned. |
SCH_LOCATION_DAY_BASED_METRICS_DATE |
Plan Volume (Day) |
Planned volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_PLAN_VOLUME |
Plan Weighted Volume (Day) |
Planned weighted volume for the day. |
SCH_LOCATION_DAY_BASED_METRICS_PLAN_WEIGHTED_VOLUME |
Volume Value Type |
Volume value type, either "Raw" or "Roll Up". Indicates whether the raw value that exists at a given business structure node is returned, or whether the rolled-up value that is the sum of the child nodes is returned. |
SCH_LOCATION_DAY_BASED_METRICS_VOLUME_VALUE_TYPE |
Volume Variance (Day) |
Volume variance for the day. |
SCH_LOCATION_DAY_BASED_METRICS_VOLUME_VARIANCE |
Related entities
Additional information
The Schedule Planner enables direct and indirect grouping for the Metrics add-on.
Core entity
Employee |
Organization |
Day |
Organizational Job |
Paycode |
Labor Category |
Activity |
---|---|---|---|---|---|---|
X |
X |
Relationship
One-to-One |
One-to-Many |
---|---|
X |