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.

Data Granularity

Provides one row per location per day

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns

Actual Volume (Day) Actual volume for the day SCH_LOCATION_DAY_BASED_METRICS_ACTUAL_VOLUME Number No
Actual Weighted Volume (Day) Actual weighted volume for the day SCH_LOCATION_DAY_BASED_METRICS_ACTUAL_WEIGHTED_VOLUME Number No
Budget Volume (Day) Budgeted volume for the day SCH_LOCATION_DAY_BASED_METRICS_BUDGET_VOLUME Number No
Budget Weighted Volume (Day) Budgeted weighted volume for the day SCH_LOCATION_DAY_BASED_METRICS_BUDGET_WEIGHTED_VOLUME Number No
Direct Actual Hours (Day) Direct actual hours for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_ACTUAL_HOURS Number No
Direct Actual Hours per Volume (Day) Direct actual hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_ACTUAL_HPPD Number No
Direct Budget Hours (Day) Direct budgeted hours for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_BUDGET_HOURS Number No
Direct Budget Hours per Volume (Day) Direct budgeted hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_BUDGET_HPPD Number No
Direct Hours per Volume Variance (Day) Direct variance hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_VARIANCE_HPPD Number No
Direct Scheduled Hours (Day) Direct scheduled hours for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_SCHEDULED_HOURS Number No
Direct Scheduled Hours per Volume (Day) Direct scheduled hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_SCHEDULED_HPPD Number No
Direct Target Hours (Day) Direct target hours for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_TARGET_HOURS Number No
Direct Target Hours per Volume (Day) Direct target hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_TARGET_HPPD Number No
Direct Total Variance Hours (Day) Direct total variance hours for the day SCH_LOCATION_DAY_BASED_METRICS_DIRECT_TOTAL_VARIANCE_HOURS Number No
Indirect Actual Hours (Day) Indirect actual hours for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_ACTUAL_HOURS Number No
Indirect Actual Hours per Volume (Day) Indirect actual hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_ACTUAL_HPPD Number No
Indirect Budget Hours (Day) Indirect budgeted hours for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_BUDGET_HOURS Number No
Indirect Budget Hours per Volume (Day) Indirect budgeted hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_BUDGET_HPPD Number No
Indirect Hours per Volume Variance (Day) Indirect variance hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_VARIANCE_HPPD Number No
Indirect Scheduled Hours (Day) Indirect scheduled hours for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_SCHEDULED_HOURS Number No
Indirect Scheduled Hours per Volume (Day) Indirect scheduled hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_SCHEDULED_HPPD Number No
Indirect Target Hours (Day) Indirect target hours for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_TARGET_HOURS Number No
Indirect Target Hours per Volume (Day) Indirect target hours per volume for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_TARGET_HPPD Number No
Indirect Total Variance Hours (Day) Indirect total variance hours for the day SCH_LOCATION_DAY_BASED_METRICS_INDIRECT_TOTAL_VARIANCE_HOURS Number No
Location Name (Path) Location name (path) for which metric has been returned SCH_LOCATION_DAY_BASED_METRICS_LOCATION_NAME_PATH String No
Metric Date Date for the metric that has been returned SCH_LOCATION_DAY_BASED_METRICS_DATE Date No
Plan Volume (Day) Planned volume for the day SCH_LOCATION_DAY_BASED_METRICS_PLAN_VOLUME Number No
Plan Weighted Volume (Day) Planned weighted volume for the day SCH_LOCATION_DAY_BASED_METRICS_PLAN_WEIGHTED_VOLUME Number No
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 String No
Volume Variance (Day) Volume variance for the day SCH_LOCATION_DAY_BASED_METRICS_VOLUME_VARIANCE Number No

Additional Info

The Schedule Planner enables direct and indirect grouping for the Metrics add-on.

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many