ADO.NET Provider for Bullhorn CRM

Build 25.0.9539

Appointment

Represents appointment records that track scheduled interactions between users, candidates, and clients. This table supports workflow management by enabling users to organize meetings, synchronize schedules, and review engagement histories.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for this appointment record. This Id supports data integrity by linking the appointment to related CRM workflow elements.

AppointmentUUID String False

Specifies the system-generated universal unique Id that is assigned to the appointment. This field supports cross-system synchronization by ensuring that external integrations can reference the appointment reliably.

CandidateId Int False

Specifies the Id of the candidate who is associated with the appointment. This field enables recruiters to track candidate participation in interviews, meetings, or other scheduled interactions.

ClientContactId Int False

Specifies the Id of the client contact who is linked to the appointment. This field supports client communication workflows by identifying the contact involved in the scheduled interaction.

CommunicationMethod String False

Captures the method of communication that is used for the appointment (for example, phone, video, or in-person). This field supports activity reporting by classifying how appointments are conducted.

DateAdded Datetime False

Captures the date and time when the appointment record is created. This field supports timeline analysis by establishing when the appointment enters the CRM.

DateLastModified Datetime False

Captures the date and time when the appointment record is most recently updated. This field supports audit tracking by indicating when changes occur.

Description String False

Stores the descriptive text that summarizes the purpose or content of the appointment. This field supports communication clarity by documenting additional context for participants.

EndDate Datetime False

Specifies the date and time when the appointment ends. This field supports duration tracking and calendar planning by defining the appointment's conclusion.

IsAllDay Bool False

Returns a value of 'true' when the appointment spans the entire day. It returns a value of 'false' when the appointment occupies a specific time range.

JobId Int False

Specifies the Id of the job order that is associated with the appointment. This field supports job-related scheduling by linking the appointment to an active job requirement.

JobSubmissionId Int False

Specifies the Id of the job submission that is linked to the appointment. This field supports workflow coordination by tracking appointments related to specific candidate submissions.

Location String False

Captures the location where the appointment occurs. This field supports logistical planning by indicating the meeting place for participants.

MigrateGUID String False

Stores the migration Id that is used during data imports or system transitions. This field supports data conversion workflows by mapping appointments from legacy systems.

OwnerId Int False

Specifies the Id of the user who owns the appointment. This field supports workload distribution by identifying responsibility for managing the appointment.

ParentAppointmentId Int False

Specifies the Id of the parent appointment when the current appointment is part of a recurring or grouped series. This field supports scheduling hierarchy by linking related appointments.

PlacementId Int False

Specifies the Id of the placement that is associated with the appointment. This field supports post-placement activities by linking meetings to ongoing assignment management.

RecurrenceDayBits Int False

Stores the bitmask values that define the specific days on which a recurring appointment occurs. This field supports automated scheduling by encoding multi-day recurrence patterns.

RecurrenceFrequency Int False

Specifies the numeric recurrence frequency for repeating appointments. This field supports scheduling logic by defining how often the appointment recurs.

RecurrenceMax Int False

Captures the maximum number of occurrences for a recurring appointment. This field supports calendar automation by limiting how many future instances are generated.

RecurrenceMonthBits Int False

Stores the bitmask values that define the months in which the recurring appointment can occur. This field supports scheduling rules by encoding month-level recurrence patterns.

RecurrenceStyle String False

Defines the recurrence style that is applied to the appointment (for example, daily, weekly, or monthly patterns). This field supports calendar automation by determining the rule structure.

RecurrenceType String False

Specifies the recurrence type that the system uses to schedule repeating appointments. This field supports workflow consistency by standardizing how recurring meetings are created.

Reminder Int False

Specifies the reminder interval that is set for the appointment. This field supports participant preparedness by defining when reminder notifications are triggered.

ShowTimeAs String False

Captures how the appointment appears on a calendar (for example, 'busy' or 'tentative'). This field supports scheduling awareness by communicating availability states to users.

StartDate Datetime False

Specifies the date and time when the appointment begins. This field supports activity planning by establishing the starting point of the scheduled event.

Subject String False

Stores the subject line or title of the appointment. This field supports quick identification by summarizing the meeting's primary topic.

TimeZoneID String False

Captures the time zone that is applied to the appointment's date and time values. This field supports accurate scheduling across regions by ensuring that all participants view correct appointment times.

Type String False

Specifies the appointment type that categorizes the interaction (for example, 'interview' or 'client meeting'). This field supports reporting and workflow organization by classifying scheduled activities.

Visibility Bool False

Returns a value of 'true' when the appointment is visible to other users. It returns a value of 'false' when the appointment is restricted due to privacy or access controls.

IsDeleted Bool False

Returns a value of 'true' when the appointment record is marked for deletion. It returns a value of 'false' when the appointment remains active in the CRM.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539