ADO.NET Provider for Salesforce

Build 25.0.9434

Holiday

Stores company-wide holidays, which can be referenced in business hours and case escalation rules.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the holiday record.

Name String False

Name of the holiday.

Description String False

Description of the holiday.

IsAllDay Bool False

Indicates whether the holiday spans the entire day.

ActivityDate Date False

Date on which the holiday occurs.

StartTimeInMinutes Int False

Start time of the holiday in minutes from midnight.

EndTimeInMinutes Int False

End time of the holiday in minutes from midnight.

CreatedDate Datetime True

Date and time when the holiday record was created.

CreatedById String True

User.Id

ID of the user who created the holiday record.

LastModifiedById String True

User.Id

ID of the user who last modified the holiday record.

IsRecurrence Bool False

Indicates whether the holiday is part of a recurring series.

RecurrenceStartDate Date False

Start date of the recurring holiday series.

RecurrenceEndDateOnly Date False

End date of the recurring holiday series.

RecurrenceType String False

Type of recurrence for the holiday, such as daily or weekly.

RecurrenceInterval Int False

Interval between recurring holiday events, based on the recurrence type.

RecurrenceDayOfWeekMask Int False

Bitmask representing the days of the week on which the holiday recurs.

RecurrenceDayOfMonth Int False

Specific day of the month on which the holiday recurs.

RecurrenceInstance String False

Recurrence instance, such as first, second, or last occurrence within the month.

RecurrenceMonthOfYear String False

Month in which the holiday recurs for yearly recurrence types.

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

System-generated timestamp for the last update to the record.

LastModifiedDate Datetime True

Date and time when the holiday record was last modified.

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