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 |