ODBC Driver for SugarCRM

Build 24.0.9062

ShiftExceptions

The ShiftExceptions table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

All_Day Bool False

The Shift Exception is all day or not

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_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Enabled Bool False

An indicator of whether shift exception is enabled

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

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

Shift_Exception_Type String False

The Shift Exception is of this type

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

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

Timezone String False

Time Zone in which this Shift Exception operates

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062