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.

Data Granularity

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

Supported Dataview/RDO Type

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

Columns

Scheduled Count SCH_COVERAGE_SCHEDULED_COUNT Number No
Scheduled Count Date SCH_COVERAGE_SCHEDULED_COUNT_DATE Date No
Scheduled Count Job SCH_COVERAGE_SCHEDULED_COUNT_JOB String No
Scheduled Count Job Group Name * SCH_COVERAGE_SCHEDULED_COUNT_JOB_GROUP_NAME String No
Scheduled Count Span End Time SCH_COVERAGE_SCHEDULED_COUNT_SPAN_END_TIME DateTime No
Scheduled Count Span Name SCH_COVERAGE_SCHEDULED_COUNT_SPAN_NAME String No
Scheduled Count Span Start Time SCH_COVERAGE_SCHEDULED_COUNT_SPAN_START_TIME DateTime No
Scheduled Count Span Type SCH_COVERAGE_SCHEDULED_COUNT_SPAN_TYPE String No

Additional Info

  • 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
  • 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

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many