Coverage – Scheduled Count

The Coverage — Scheduled Count entity provides data for scheduled headcount by job, date, and span (schedule zone or shift set). It allows users to analyze scheduled count with workload planned count and workload budgeted count.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per job per date per span (schedule zone or shift set).Provides one row per job per date per span (schedule zone or shift set).

Columns

Note: The column marked with an asterisk returns data to reports only when selected using a parameter in BIRT Designer. When selected for a Dataview, it does not return data.

Label

Key

Scheduled Count

SCH_COVERAGE_SCHEDULED_COUNT

Scheduled Count Date

SCH_COVERAGE_SCHEDULED_COUNT_DATE

Scheduled Count Job

SCH_COVERAGE_SCHEDULED_COUNT_JOB

Scheduled Count Job Group Name*

SCH_COVERAGE_SCHEDULED_COUNT_JOB_GROUP_NAME

Scheduled Count Span End Time

SCH_COVERAGE_SCHEDULED_COUNT_SPAN_END_TIME

Scheduled Count Span Name

SCH_COVERAGE_SCHEDULED_COUNT_SPAN_NAME

Scheduled Count Span Start Time

SCH_COVERAGE_SCHEDULED_COUNT_SPAN_START_TIME

Scheduled Count Span Type

SCH_COVERAGE_SCHEDULED_COUNT_SPAN_TYPE

Related entities

Additional information

The Coverage — Scheduled Count entity does not support relationships with volume entities (such as planned volume, budgeted volume, and actual volume). Volume data exists only above the Job level in the Business Structure, but coverage scheduled count data cannot be rolled up higher than the Job level.

Core entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
X

Relationship

One-to-One

One-to-Many
X