Shifts
The Shifts table.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True | |
| Acl_Team_Set_Id | String | False | |
| Assigned_User_Id | String | False |
User ID assigned to record |
| Assigned_User_Name | String | True | |
| Commentlog | String | True | |
| Created_By | String | True |
User who created record |
| Created_By_Name | String | True | |
| Date_End | Date | False |
Date is which shift is scheduled to (or did) end |
| Date_Entered | Datetime | True |
Date record created |
| Date_Modified | Datetime | True |
Date record last modified |
| Date_Start | Date | False |
Date in which shift is schedule to (or did) start |
| Deleted | Bool | False |
Record deletion indicator |
| Description | String | False |
Full text of the note |
| Following | Bool | False |
Is user following this record |
| Friday_Close_Hour | String | False |
The hour portion of the time this business center is closed on Friday |
| Friday_Close_Minutes | String | False |
The minute portion of the time this business center is closed on Friday |
| Friday_Open_Hour | String | False |
The hour portion of the time this business center is open on Friday |
| Friday_Open_Minutes | String | False |
The minute portion of the time this business center is open on Friday |
| Id [KEY] | String | True |
Unique identifier |
| Is_Open_Friday | Bool | False |
Explicit marker for if this business center is open on Friday |
| Is_Open_Monday | Bool | False |
Explicit marker for if this business center is open on Monday |
| Is_Open_Saturday | Bool | False |
Explicit marker for if this business center is open on Saturday |
| Is_Open_Sunday | Bool | False |
Explicit marker for if this business center is open on Sunday |
| Is_Open_Thursday | Bool | False |
Explicit marker for if this business center is open on Thursday |
| Is_Open_Tuesday | Bool | False |
Explicit marker for if this business center is open on Tuesday |
| Is_Open_Wednesday | Bool | False |
Explicit marker for if this business center is open on Wednesday |
| Locked_Fields | String | True | |
| Modified_By_Name | String | True | |
| Modified_User_Id | String | True |
User who last modified record |
| Monday_Close_Hour | String | False |
The hour portion of the time this business center is closed on Monday |
| Monday_Close_Minutes | String | False |
The minute portion of the time this business center is closed on Monday |
| Monday_Open_Hour | String | False |
The hour portion of the time this business center is open on Monday |
| Monday_Open_Minutes | String | False |
The minute portion of the time this business center is open on Monday |
| My_Favorite | Bool | False |
Favorite for the user |
| Name | String | False | |
| Saturday_Close_Hour | String | False |
The hour portion of the time this business center is closed on Saturday |
| Saturday_Close_Minutes | String | False |
The minute portion of the time this business center is closed on Saturday |
| Saturday_Open_Hour | String | False |
The hour portion of the time this business center is open on Saturday |
| Saturday_Open_Minutes | String | False |
The minute portion of the time this business center is open on Saturday |
| Sunday_Close_Hour | String | False |
The hour portion of the time this business center is closed on Sunday |
| Sunday_Close_Minutes | String | False |
The minute portion of the time this business center is closed on Sunday |
| Sunday_Open_Hour | String | False |
The hour portion of the time this business center is open on Sunday |
| Sunday_Open_Minutes | String | False |
The minute portion of the time this business center is open on Sunday |
| Sync_Key | String | True | |
| Tag | String | False | |
| Team_Count | String | False | |
| Team_Id | String | False |
Team ID for the account |
| Team_Name | String | False | |
| Team_Set_Id | String | False | |
| Thursday_Close_Hour | String | False |
The hour portion of the time this business center is closed on Thursday |
| Thursday_Close_Minutes | String | False |
The minute portion of the time this business center is closed on Thursday |
| Thursday_Open_Hour | String | False |
The hour portion of the time this business center is open on Thursday |
| Thursday_Open_Minutes | String | False |
The minute portion of the time this business center is open on Thursday |
| Timezone | String | False |
Time Zone in which this Shift operates |
| Tuesday_Close_Hour | String | False |
The hour portion of the time this business center is closed on Tuesday |
| Tuesday_Close_Minutes | String | False |
The minute portion of the time this business center is closed on Tuesday |
| Tuesday_Open_Hour | String | False |
The hour portion of the time this business center is open on Tuesday |
| Tuesday_Open_Minutes | String | False |
The minute portion of the time this business center is open on Tuesday |
| Wednesday_Close_Hour | String | False |
The hour portion of the time this business center is closed on Wednesday |
| Wednesday_Close_Minutes | String | False |
The minute portion of the time this business center is closed on Wednesday |
| Wednesday_Open_Hour | String | False |
The hour portion of the time this business center is open on Wednesday |
| Wednesday_Open_Minutes | String | False |
The minute portion of the time this business center is open on Wednesday |