Shift configuration audit log

The creation of new shift configurations and any changes to an existing shift configuration are logged for audit purposes. An insert transaction record is created when a new shift configuration is created for a team. Insert transaction records store the original definition of a shift and the user that created the shift.

Update transaction records are created when changes are made to an existing shift configuration. These changes include updates to activities, day parts, or shift properties. They also include changes to work, break, or on-call times. Update transactions record when the change was made, the user that made the changes, and the current state of the shift configuration after the update.

Initialize transaction records are created when upgrading an existing environment that is using a version of Workforce Management before 6.3.0. An initialize transaction record is created for each existing shift configuration. Initialize records contain the configuration of a shift at the time of upgrade.

Note: Information on shift configuration changes before the upgrade is not available, because before 6.3.0, only the final configuration of the shift was recorded in the database.

The shift configuration log is accessed by selecting Scheduling > Multi-view Scheduler > ES Data Definitions > Shift Configuration Audit. This form lists all of the transaction records. Because shift configuration is performed on a per-unit basis, there is likely to be a large number of transaction records. It is recommended to use the search or advanced search options to locate transactions on a particular shift or unit. The details for a transaction record can be viewed by clicking Edit.

These tables are included in the details for each transaction record:

ES_SHIFT_AUDIT: This table contains the basic information about the shift, such as the display label and team that uses the shift.
ES_SHIFT_ATTRIBUTE_AUDIT: This table contains the shift attributes and shift attribute flags. Each set of shift attributes is effective dated. The ID for each set of effective-dated shift attributes is contained under the ESSHIFTATTR_ID column. The ESSHIFTATTR_ID column is linked to ES_SHIFT_DAY_PART_AUDIT, ES_SHIFT_ACTIVITY_AUDIT, ES_SHIFT_PROP_DATA_AUDIT, and ES_SHIFT_DAY_PART_TEAM_AUDIT to differentiate which set of effective dates corresponds with each row.
ES_SHIFT_TEAM_AUDIT: This table lists the sub-teams that are subscribed to the shift and the subscription dates for each sub-team.
ES_SHIFT_DAY_PART_AUDIT: This table contains the day parts that are associated with the shift for coverage purposes.
ES_SHIFT_ACTIVITY_AUDIT: This table contains the activities and activity times that make up the shift. It also includes the activity flags.
ES_SHIFT_PROP_DATA_AUDIT: This table contains the properties that are applied to the shift.
ES_SHIFT_DAY_PART_TEAM_AUDIT: For sub-teams that are subscribed to the shift, this table indicates if the sub-teams have overrides for the shift day parts. The ESSHIFTDPTM_OVR_SHFTDAYPART is true if the sub-team has day part overrides. The ESSHIFTDP_ID is linked to the ES_SHIFT_DAY_PART_AUDIT table to link the sub-team overrides to the corresponding day parts.