Schedule Group Totals

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

Data Granularity

Provides one row per employee per assigned schedule group.

Supported Dataview/RDO Type

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

Columns


Employee Certifications Display Names	All certifications assigned to an employee providing the Display Name	SCH_PEOPLE_CERTIFICATION_DISPLAY_NAMES_CONCATENATED	String	No
Employee Skills Display Names	All skills assigned to an employee providing the Display Name	SCH_PEOPLE_SKILL_DISPLAY_NAMES_CONCATENATED	String	No
Projected Totals		SCH_DATAVIEW_COLUMNS_PROJECTED_TOTALS	Number	No
Schedule Group Assignment End Date		SCH_DATAVIEW_COLUMNS_GROUP_ASSIGNMENT_END_DATE	Date	No
Schedule Group Assignment Start Date		SCH_DATAVIEW_COLUMNS_GROUP_ASSIGNMENT_START_DATE	Date	No
Schedule Group Name		SCH_DATAVIEW_COLUMNS_GROUP_NAME	String	No
Scheduled Group Names (Concatenated)		SCH_DATAVIEW_COLUMNS_GROUP_NAMES_COMMA_SEPARATED	String	No
Scheduled Totals		SCH_DATAVIEW_COLUMNS_SCHEDULE_TOTALS	Number	No

Additional Info

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	Activity	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many