Schedule Group Totals

The Schedule Group Totals entity provides the scheduled totals by employee and schedule group.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per employee per assigned schedule group.

Columns

Label

Description

Key

Employee Certifications Display Names

All certifications assigned to an employee providing the Display Name.

SCH_PEOPLE_CERTIFICATION_DISPLAY_NAMES_CONCATENATED

Employee Skills Display Names

All skills assigned to an employee providing the Display Name.

SCH_PEOPLE_SKILL_DISPLAY_NAMES_CONCATENATED

Projected Totals

SCH_DATAVIEW_COLUMNS_PROJECTED_TOTALS

Schedule Group Assignment End Date

SCH_DATAVIEW_COLUMNS_GROUP_ASSIGNMENT_END_DATE

Schedule Group Assignment Start Date

SCH_DATAVIEW_COLUMNS_GROUP_ASSIGNMENT_START_DATE

Schedule Group Name

SCH_DATAVIEW_COLUMNS_GROUP_NAME

Scheduled Group Names (Concatenated)

SCH_DATAVIEW_COLUMNS_GROUP_NAMES_COMMA_SEPARATED

Scheduled Totals

SCH_DATAVIEW_COLUMNS_SCHEDULE_TOTALS

Additional information

The Schedule Group Names, Employee Certifications, and Employee Skills columns provide concatenated lists of all names, certifications, and skills assigned to the employee.

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

Relationship

One-to-One

One-to-Many

X