ShiftExceptions
Stores schedule exception records that are related to shift assignments. This table supports workforce planning and conflict resolution.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this shift exception. This value supports collaboration, access control, and record visibility. |
| Acl_Team_Set_Id | String | False |
The Id of the set of teams that have access to this shift exception. This value is used to manage shared permission assignments. |
| All_Day | Bool | False |
A Boolean field that returns a value of 'true' when the shift exception applies to the entire day. It returns a value of 'false' when a specific time range is defined. |
| Assigned_User_Id | String | False |
The unique identifier (Id) of the user who is responsible for this shift exception. This assignment determines ownership and workflow accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this shift exception. This value is shown in the user interface for readability and context. |
| Commentlog | String | True |
The comment log entries that are associated with this shift exception. This field stores collaboration notes or historical change details. |
| Created_By | String | True |
The Id of the user who created this shift exception record. This value identifies the record author for auditing and lifecycle tracking. |
| Created_By_Name | String | True |
The display name of the user who created this shift exception record. This value is shown in the user interface and reports. |
| Date_Entered | Datetime | True |
The date and time when this shift exception record was created. This value supports timeline tracking and audit review. |
| Date_Modified | Datetime | True |
The date and time when this shift exception record was most recently updated. This field supports version history and change transparency. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this shift exception record is marked as deleted. It returns a value of 'false' when the record remains active and available. |
| Description | String | False |
A detailed description of the shift exception. This field can include notes, scheduling context, or operational explanation. |
| Enabled | Bool | False |
A Boolean field that returns a value of 'true' when the shift exception is active and enforced in scheduling operations. It returns a value of 'false' when the exception is disabled. |
| End_Date | Date | False |
The date when the shift exception ends. This value defines the final day the exception applies. |
| End_Hour | String | False |
The hour component of the end time for the shift exception. This value is used when the exception does not span the entire day. |
| End_Minutes | String | False |
The minute component of the end time for the shift exception. This value provides precise end-time resolution. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this shift exception to receive activity updates. It returns a value of 'false' when the user is not following the record. |
| Id [KEY] | String | True |
The Id for this shift exception record. This value is used to reference and manage the exception across the system. |
| Locked_Fields | String | True |
The list of fields that are restricted from editing for this shift exception. This value prevents unauthorized modifications to system-managed attributes. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this shift exception record. This value provides visibility into update history. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this shift exception record. This value identifies the source of the most recent modification. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the record is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The name of the shift exception. This value is used as the primary label throughout the system. |
| Shift_Exception_Type | String | False |
The classification type of the shift exception (for example, 'holiday', 'time-off', or 'schedule override'). This value indicates the operational purpose of the exception. |
| Start_Date | Date | False |
The date when the shift exception begins. This value marks the first day the exception is applied. |
| Start_Hour | String | False |
The hour component of the start time for the shift exception. This value is used when the exception does not span the entire day. |
| Start_Minutes | String | False |
The minute component of the start time for the shift exception. This value enables precise scheduling control. |
| Sync_Key | String | True |
The synchronization key that is used to match this shift exception record with external systems. This value ensures data consistency across integrations. |
| Tag | String | False |
The tags that are associated with this shift exception. Tags support flexible record organization and filtering. |
| Team_Count | String | False |
The number of teams that are associated with this shift exception. This value indicates collaboration scope and access distribution. |
| Team_Id | String | False |
The Id of the primary team that is responsible for this shift exception. This value establishes ownership for permissions and visibility. |
| Team_Name | String | False |
The display name of the primary team that is associated with this shift exception. This value is shown in the user interface and reports. |
| Team_Set_Id | String | False |
The Id of the set of teams that share access to this shift exception. This value supports multi-team collaboration and permission management. |
| Timezone | String | False |
The time zone in which this shift exception takes effect. This value ensures correct scheduling interpretation across geographic regions. |