ShiftExceptions
The ShiftExceptions table.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
Unique identifier |
Name | String | False | |
Date_Entered | Datetime | True |
Date record created |
Date_Modified | Datetime | True |
Date record last modified |
Modified_User_Id | String | True |
User who last modified record |
Modified_By_Name | String | True | |
Created_By | String | True |
User who created record |
Created_By_Name | String | True | |
Description | String | False |
Full text of the note |
Deleted | Bool | False |
Record deletion indicator |
Timezone | String | False |
Time Zone in which this Shift Exception operates |
Shift_Exception_Type | String | False |
The Shift Exception is of this type |
All_Day | Bool | False |
The Shift Exception is all day or not |
Start_Date | Date | False |
The start date of the shift exception |
Start_Hour | String | False |
The hour portion of the time this shift exception starts |
Start_Minutes | String | False |
The minute portion of the time this shift exception starts |
End_Date | Date | False |
The end date of the shift exception |
End_Hour | String | False |
The hour portion of the time this shift exception ends |
End_Minutes | String | False |
The minute portion of the time this shift exception ends |
Enabled | Bool | False |
An indicator of whether shift exception is enabled |
Following | Bool | False |
Is user following this record |
My_Favorite | Bool | False |
Favorite for the user |
Tag | String | False | |
Commentlog | String | True | |
Locked_Fields | String | True | |
Sync_Key | String | True | |
Assigned_User_Id | String | False |
User ID assigned to record |
Assigned_User_Name | String | True | |
Team_Id | String | False |
Team ID for the account |
Team_Set_Id | String | False | |
Acl_Team_Set_Id | String | False | |
Team_Count | String | False | |
Team_Name | String | False | |
Acl_Team_Names | String | True |