Tableau Connector for Salesforce

Build 25.0.9434

BusinessHours

Defines business hours used in case escalation rules, Service-level Agreement (SLA) calculations, and time-based workflows.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the business hours record.

Name String False

Name of the business hours entry, used for identification.

IsActive Bool False

Indicates whether the business hours are currently active.

IsDefault Bool False

Indicates whether these are the default business hours for the organization.

SundayStartTime Time False

Start time for business hours on Sunday.

SundayEndTime Time False

End time for business hours on Sunday.

MondayStartTime Time False

Start time for business hours on Monday.

MondayEndTime Time False

End time for business hours on Monday.

TuesdayStartTime Time False

Start time for business hours on Tuesday.

TuesdayEndTime Time False

End time for business hours on Tuesday.

WednesdayStartTime Time False

Start time for business hours on Wednesday.

WednesdayEndTime Time False

End time for business hours on Wednesday.

ThursdayStartTime Time False

Start time for business hours on Thursday.

ThursdayEndTime Time False

End time for business hours on Thursday.

FridayStartTime Time False

Start time for business hours on Friday.

FridayEndTime Time False

End time for business hours on Friday.

SaturdayStartTime Time False

Start time for business hours on Saturday.

SaturdayEndTime Time False

End time for business hours on Saturday.

TimeZoneSidKey String False

Time zone associated with the business hours configuration.

CreatedDate Datetime True

Date and time when the business hours record was created.

CreatedById String True

User.Id

ID of the user who created the business hours record.

LastModifiedById String True

User.Id

ID of the user who last modified the business hours record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Timestamp used for system synchronization and replication.

LastModifiedDate Datetime True

Date and time when the business hours record was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434