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. |