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.

Data Granularity

Provides one row per job per workload span.

Supported Dataview/RDO Type

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

Columns


Actual Hours by Span	Number of actual hours for the time period	SCH_JOB_BASED_METRICS_BY_SPAN_ACTUAL_HOURS	Number	No
Budgeted Hours by Span	Number of budgeted hours for the time period	SCH_JOB_BASED_METRICS_BY_SPAN_BUDGETED_HOURS	Number	No
Earned Hours by Span	Number of earned hours for the time period	SCH_JOB_BASED_METRICS_BY_SPAN_EARNED_HOURS	Number	No
Job Name (Path)	Job name (path) for the metric that has been returned	SCH_JOB_BASED_METRICS_BY_SPAN_JOB_NAME_PATH	String	No
Metric Date	Date of the metric that has been returned	SCH_JOB_BASED_METRICS_BY_SPAN_DATE	Date	No
Metric Span Name	Span name for the metric that has been returned	SCH_JOB_BASED_METRICS_BY_SPAN_SPAN_NAME	String	No
Metric Span Type	Span time for the metric that has been returned	SCH_JOB_BASED_METRICS_BY_SPAN_SPAN_TYPE	String	No
Planned Hours by Span	Number of planned hours for the time period	SCH_JOB_BASED_METRICS_BY_SPAN_PLANNED_HOURS	Number	No
Projected Hours by Span	Number of projected hours for the time period	SCH_JOB_BASED_METRICS_BY_SPAN_PROJECTED_HOURS	Number	No
Scheduled Hours by Span	Number of scheduled hours for thye time period	SCH_JOB_BASED_METRICS_BY_SPAN_SCHEDULED_HOURS	Number	No

Additional Info

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	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many