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 |
Related entities
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 |
