Schedule Group Totals

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

Employee Dataview Business Structure Dataview
X  

Provides one row per employee per assigned schedule group.

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

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

Employee Organization Day Organizational Job Paycode Labor Category
X          
One-to-One One-to-Many
X