Shifts
Stores shift schedule assignments for users or resources. This table supports operational staffing and availability planning.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this shift record. 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 record. This value is used to manage shared permission assignments. |
| Assigned_User_Id | String | False |
The unique identifier (Id) of the user who is responsible for this shift. This assignment determines ownership and workflow accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this shift. 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. This field stores collaboration notes or historical context. |
| Created_By | String | True |
The Id of the user who created this shift 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 record. This value is shown in the user interface and reports. |
| Date_End | Date | False |
The date on which the shift is scheduled to end or did end. This value defines the shift's end boundary. |
| Date_Entered | Datetime | True |
The date and time when this shift record was created. This value supports timeline tracking and audit review. |
| Date_Modified | Datetime | True |
The date and time when this shift record was most recently updated. This field supports version history and change tracking. |
| Date_Start | Date | False |
The date on which the shift is scheduled to begin or did begin. This value defines the shift's start boundary. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this shift 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. This field can include scheduling context, operational details, or instructional information. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this shift to receive activity updates. It returns a value of 'false' when the user is not following the record. |
| Friday_Close_Hour | String | False |
The hour portion of the time when this business center closes on Friday. This value defines the end of Friday service availability. |
| Friday_Close_Minutes | String | False |
The minute portion of the time when this business center closes on Friday. This value provides precise closing-time specification. |
| Friday_Open_Hour | String | False |
The hour portion of the time when this business center opens on Friday. This value defines the start of Friday service availability. |
| Friday_Open_Minutes | String | False |
The minute portion of the time when this business center opens on Friday. This value provides precise opening-time specification. |
| Id [KEY] | String | True |
The Id for this shift record. This value is used to reference and manage the shift across the system. |
| Is_Open_Friday | Bool | False |
A Boolean field that returns a value of 'true' when the business center operates on Friday. It returns a value of 'false' when the business center is closed on Friday. |
| Is_Open_Monday | Bool | False |
A Boolean field that returns a value of 'true' when the business center operates on Monday. It returns a value of 'false' when the business center is closed on Monday. |
| Is_Open_Saturday | Bool | False |
A Boolean field that returns a value of 'true' when the business center operates on Saturday. It returns a value of 'false' when the business center is closed on Saturday. |
| Is_Open_Sunday | Bool | False |
A Boolean field that returns a value of 'true' when the business center operates on Sunday. It returns a value of 'false' when the business center is closed on Sunday. |
| Is_Open_Thursday | Bool | False |
A Boolean field that returns a value of 'true' when the business center operates on Thursday. It returns a value of 'false' when the business center is closed on Thursday. |
| Is_Open_Tuesday | Bool | False |
A Boolean field that returns a value of 'true' when the business center operates on Tuesday. It returns a value of 'false' when the business center is closed on Tuesday. |
| Is_Open_Wednesday | Bool | False |
A Boolean field that returns a value of 'true' when the business center operates on Wednesday. It returns a value of 'false' when the business center is closed on Wednesday. |
| Locked_Fields | String | True |
The list of fields that are restricted from editing for this shift. This value prevents unauthorized modification of controlled properties. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this shift record. This value provides visibility into recent updates. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this shift record. This value identifies the source of the latest modification. |
| Monday_Close_Hour | String | False |
The hour portion of the time when this business center closes on Monday. This value defines the end of Monday service availability. |
| Monday_Close_Minutes | String | False |
The minute portion of the time when this business center closes on Monday. This value provides precise closing-time specification. |
| Monday_Open_Hour | String | False |
The hour portion of the time when this business center opens on Monday. This value defines the start of Monday service availability. |
| Monday_Open_Minutes | String | False |
The minute portion of the time when this business center opens on Monday. This value provides precise opening-time specification. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the shift 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. This value is used as the primary label throughout the system. |
| Saturday_Close_Hour | String | False |
The hour portion of the time when this business center closes on Saturday. This value defines the end of Saturday service availability. |
| Saturday_Close_Minutes | String | False |
The minute portion of the time when this business center closes on Saturday. This value provides precise closing-time specification. |
| Saturday_Open_Hour | String | False |
The hour portion of the time when this business center opens on Saturday. This value defines the start of Saturday service availability. |
| Saturday_Open_Minutes | String | False |
The minute portion of the time when this business center opens on Saturday. This value provides precise opening-time specification. |
| Sunday_Close_Hour | String | False |
The hour portion of the time when this business center closes on Sunday. This value defines the end of Sunday service availability. |
| Sunday_Close_Minutes | String | False |
The minute portion of the time when this business center closes on Sunday. This value provides precise closing-time specification. |
| Sunday_Open_Hour | String | False |
The hour portion of the time when this business center opens on Sunday. This value defines the start of Sunday service availability. |
| Sunday_Open_Minutes | String | False |
The minute portion of the time when this business center opens on Sunday. This value provides precise opening-time specification. |
| Sync_Key | String | True |
The synchronization key that is used to match this shift record with external systems. This value ensures data consistency across integrations. |
| Tag | String | False |
The tags that are associated with this shift record. Tags support flexible record organization, grouping, and filtering. |
| Team_Count | String | False |
The number of teams that are associated with this shift record. This value indicates collaboration scope and access distribution. |
| Team_Id | String | False |
The Id of the primary team that is responsible for this shift record. 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 record. This value is shown in the user interface for clarity and reporting. |
| Team_Set_Id | String | False |
The Id of the set of teams that share access to this shift record. This value supports multi-team collaboration and permission management. |
| Thursday_Close_Hour | String | False |
The hour portion of the time when this business center closes on Thursday. This value defines the end of Thursday service availability. |
| Thursday_Close_Minutes | String | False |
The minute portion of the time when this business center closes on Thursday. This value provides precise closing-time specification. |
| Thursday_Open_Hour | String | False |
The hour portion of the time when this business center opens on Thursday. This value defines the start of Thursday service availability. |
| Thursday_Open_Minutes | String | False |
The minute portion of the time when this business center opens on Thursday. This value provides precise opening-time specification. |
| Timezone | String | False |
The time zone in which this shift operates. This value ensures correct scheduling interpretation across geographic regions. |
| Tuesday_Close_Hour | String | False |
The hour portion of the time when this business center closes on Tuesday. This value defines the end of Tuesday service availability. |
| Tuesday_Close_Minutes | String | False |
The minute portion of the time when this business center closes on Tuesday. This value provides precise closing-time specification. |
| Tuesday_Open_Hour | String | False |
The hour portion of the time when this business center opens on Tuesday. This value defines the start of Tuesday service availability. |
| Tuesday_Open_Minutes | String | False |
The minute portion of the time when this business center opens on Tuesday. This value provides precise opening-time specification. |
| Wednesday_Close_Hour | String | False |
The hour portion of the time when this business center closes on Wednesday. This value defines the end of Wednesday service availability. |
| Wednesday_Close_Minutes | String | False |
The minute portion of the time when this business center closes on Wednesday. This value provides precise closing-time specification. |
| Wednesday_Open_Hour | String | False |
The hour portion of the time when this business center opens on Wednesday. This value defines the start of Wednesday service availability. |
| Wednesday_Open_Minutes | String | False |
The minute portion of the time when this business center opens on Wednesday. This value provides precise opening-time specification. |