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

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