Schedule Metrics by Span (Job)

The Schedule Metrics by Span (Job) entity provides the data columns needed to show workload hours by span for a job. The hours for each workload span are calculated by multiplying the headcount for each workload span by the duration of the span.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per job per workload span.

Columns

Label

Description

Key

Actual Hours by Span

Number of actual hours for the time period.

SCH_JOB_BASED_METRICS_BY_SPAN_ACTUAL_HOURS

Budgeted Hours by Span

Number of budgeted hours for the time period.

SCH_JOB_BASED_METRICS_BY_SPAN_BUDGETED_HOURS

Earned Hours by Span

Number of earned hours for the time period.

SCH_JOB_BASED_METRICS_BY_SPAN_EARNED_HOURS

Job Name (Path)

Job name (path) for the metric that has been returned.

SCH_JOB_BASED_METRICS_BY_SPAN_JOB_NAME_PATH

Metric Date

Date of the metric that has been returned.

SCH_JOB_BASED_METRICS_BY_SPAN_DATE

Metric Span Name

Span name for the metric that has been returned.

SCH_JOB_BASED_METRICS_BY_SPAN_SPAN_NAME

Metric Span Type

Span time for the metric that has been returned.

SCH_JOB_BASED_METRICS_BY_SPAN_SPAN_TYPE

Planned Hours by Span

Number of planned hours for the time period.

SCH_JOB_BASED_METRICS_BY_SPAN_PLANNED_HOURS

Projected Hours by Span

Number of projected hours for the time period.

SCH_JOB_BASED_METRICS_BY_SPAN_PROJECTED_HOURS

Scheduled Hours by Span

Number of scheduled hours for thye time period.

SCH_JOB_BASED_METRICS_BY_SPAN_SCHEDULED_HOURS

Additional information

Earned hours represent the hours calculated from the Actual workload, as represented in the Workload Planner.

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

Activity

X

X

Relationship

One-to-One

One-to-Many

X