--- schema_version: "1" id: 94dfba1d52aeb6e1dec9b4b2950444e65cc3dceb38b7c0f2c3acd31a8fb10bc8 title: Service Appointment DMO collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-serviceappointmentdmo-dmo.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-serviceappointmentdmo-dmo.html source_site: developer.salesforce.com content_type: documentation content_hash: e3cfa2f1b6c09238b254d2f999187d32dcc63c86333b1d6bd7c8ebd21656f21d products: - Data 360 DMO and Mapping Guide - Data 360 Developer Documentation --- # Service Appointment DMO ## Object Properties **Object API Name:** `ssot__ServiceAppointment__dlm` **Category:** Unassigned **Availability:** Available in 254 and later versions **Primary Key Field:** Id ## Relationships - **ParentRecordId** has a FOREIGNKEY relationship with the [Lead DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-leaddmo-dmo.md) `Id` field. - **ParentRecordId** has a FOREIGNKEY relationship with the [Clinical Service Request DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-clinicalservicerequestdmo-dmo.md) `Id` field. - **ParentRecordId** has a FOREIGNKEY relationship with the [Care Program Enrollee DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-careprogramenrolleedmo-dmo.md) `Id` field. - **ServiceTerritoryId** has a FOREIGNKEY relationship with the [Service Territory DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-serviceterritorydmo-dmo.md) `Id` field. - **CreatedById** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field. - **AddressId** has a FOREIGNKEY relationship with the [Location DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-locationdmo-dmo.md) `Id` field. - **AccountId** has a FOREIGNKEY relationship with the [Account DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountdmo-dmo.md) `Id` field. - **AccountContactId** has a FOREIGNKEY relationship with the [Account Contact DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountcontactdmo-dmo.md) `Id` field. - **OwnerId** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field. - **OwnerId** has a FOREIGNKEY relationship with the [User Group DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-usergroupdmo-dmo.md) `Id` field. - **LastModifiedById** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field. - **DurationUOMId** has a FOREIGNKEY relationship with the [Unit of Measure DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-unitofmeasuredmo-dmo.md) `Id` field. - **ParentRecordId** has a FOREIGNKEY relationship with the [Work Order Item DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderitemdmo-dmo.md) `Id` field. - **ParentRecordId** has a FOREIGNKEY relationship with the [Opportunity DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-opportunitydmo-dmo.md) `Id` field. - **ParentRecordId** has a FOREIGNKEY relationship with the [Asset DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-assetdmo-dmo.md) `Id` field. - **ParentRecordId** has a FOREIGNKEY relationship with the [Account DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountdmo-dmo.md) `Id` field. - **WorkTypeId** has a FOREIGNKEY relationship with the [Work Type DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-worktypedmo-dmo.md) `Id` field. - **ParentRecordId** has a FOREIGNKEY relationship with the [Work Order DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderdmo-dmo.md) `Id` field. - **AddressId** has a FOREIGNKEY relationship with the [Address DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-addressdmo-dmo.md) `Id` field. - **RelatedBundleId** has a FOREIGNKEY relationship with the [Service Appointment DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-serviceappointmentdmo-dmo.md) `Id` field. ## Fields - [AccountContactId](#accountcontactid) - [AccountId](#accountid) - [ActualDurationNumber](#actualdurationnumber) - [ActualEndDateTime](#actualenddatetime) - [ActualStartDateTime](#actualstartdatetime) - [AdditionalInformationText](#additionalinformationtext) - [AddressId](#addressid) - [AppointmentBundlePolicyId](#appointmentbundlepolicyid) - [AppointmentPriority](#appointmentpriority) - [AppointmentReasonCodeId](#appointmentreasoncodeid) - [AppointmentStatusReasonId](#appointmentstatusreasonid) - [ArrivalWindowEndDateTime](#arrivalwindowenddatetime) - [ArrivalWindowStartDateTime](#arrivalwindowstartdatetime) - [CancellationReasonText](#cancellationreasontext) - [cdp_sys_record_currency](#cdp_sys_record_currency) - [Comment](#comment) - [CreatedById](#createdbyid) - [CreatedDate](#createddate) - [DataSourceId](#datasourceid) - [DataSourceObjectId](#datasourceobjectid) - [Description](#description) - [DueDateTime](#duedatetime) - [DurationInMinutes](#durationinminutes) - [DurationQuantity](#durationquantity) - [DurationUOMId](#durationuomid) - [EarliestStartDateTime](#earlieststartdatetime) - [EmailAddress](#emailaddress) - [EngagementChannelType](#engagementchanneltype) - [GeocodeAccuracy](#geocodeaccuracy) - [Id](#id) - [InJeopardy](#injeopardy) - [InternalOrganizationId](#internalorganizationid) - [IsAutoScheduled](#isautoscheduled) - [IsBundle](#isbundle) - [IsBundleMember](#isbundlemember) - [IsEmergency](#isemergency) - [IsFillInCandidate](#isfillincandidate) - [IsManuallyBundled](#ismanuallybundled) - [IsMultiDay](#ismultiday) - [IsOffsiteAppointment](#isoffsiteappointment) - [IsPinned](#ispinned) - [IsUpdatedByOptimization](#isupdatedbyoptimization) - [KQ_AccountContactId](#kq_accountcontactid) - [KQ_AccountId](#kq_accountid) - [KQ_AddressId](#kq_addressid) - [KQ_CreatedById](#kq_createdbyid) - [KQ_DurationUOMId](#kq_durationuomid) - [KQ_Id](#kq_id) - [KQ_LastModifiedById](#kq_lastmodifiedbyid) - [KQ_OwnerId](#kq_ownerid) - [KQ_ParentRecordId](#kq_parentrecordid) - [KQ_RelatedBundleId](#kq_relatedbundleid) - [KQ_ServiceTerritoryId](#kq_serviceterritoryid) - [KQ_WorkTypeId](#kq_worktypeid) - [LastModifiedById](#lastmodifiedbyid) - [LastModifiedDate](#lastmodifieddate) - [OwnerId](#ownerid) - [OwnerObject](#ownerobject) - [ParentRecordId](#parentrecordid) - [ParentRecordObject](#parentrecordobject) - [ParentRecordStatusCategory](#parentrecordstatuscategory) - [PhoneNumberText](#phonenumbertext) - [RelatedBundleId](#relatedbundleid) - [ScheduledEndDateTime](#scheduledenddatetime) - [ScheduledStartDateTime](#scheduledstartdatetime) - [ServiceAppointmentNumber](#serviceappointmentnumber) - [ServiceAppointmentScheduleMode](#serviceappointmentschedulemode) - [ServiceAppointmentStatus](#serviceappointmentstatus) - [ServiceAppointmentStatusCategory](#serviceappointmentstatuscategory) - [ServiceAppointmentType](#serviceappointmenttype) - [ServiceDocumentTemplateIdentifier](#servicedocumenttemplateidentifier) - [ServiceNoteText](#servicenotetext) - [ServiceTerritoryId](#serviceterritoryid) - [ShouldScheduleOverLowerPriorityAppt](#shouldscheduleoverlowerpriorityappt) - [SubjectText](#subjecttext) - [SystemModstamp](#systemmodstamp) - [WorkTypeId](#worktypeid) ### AccountContactId - **Field API Name:** `ssot__AccountContactId__c` - **Data Type:** TEXT - **Description:** Reference to the contact associated with the appointment. ### AccountId - **Field API Name:** `ssot__AccountId__c` - **Data Type:** TEXT - **Description:** The account associated with the appointment. If the parent record is a work order or work order line item, this field’s value is inherited from the parent. Otherwise, it remains blank. This field is read only. ### ActualDurationNumber - **Field API Name:** `ssot__ActualDurationNumber__c` - **Data Type:** DOUBLE - **Description:** The actual time spent to complete the appointment. ### ActualEndDateTime - **Field API Name:** `ssot__ActualEndDateTime__c` - **Data Type:** DATETIME - **Description:** The date and time of the actual end date time. ### ActualStartDateTime - **Field API Name:** `ssot__ActualStartDateTime__c` - **Data Type:** DATETIME - **Description:** When the appointment actually began. ### AdditionalInformationText - **Field API Name:** `ssot__AdditionalInformationText__c` - **Data Type:** TEXT - **Description:** Additional info about the service appointment. ### AddressId - **Field API Name:** `ssot__AddressId__c` - **Data Type:** TEXT - **Description:** Where the service appointment takes place. ### AppointmentBundlePolicyId - **Field API Name:** `ssot__AppointmentBundlePolicyId__c` - **Data Type:** TEXT - **Description:** Reference to the bundle policy associated with this service appointment. ### AppointmentPriority - **Field API Name:** `ssot__AppointmentPriority__c` - **Data Type:** TEXT - **Description:** The priority of the appointment. Can be used to make informed decisions if needing to re-prioritize appointments. ### AppointmentReasonCodeId - **Field API Name:** `ssot__AppointmentReasonCodeId__c` - **Data Type:** TEXT - **Description:** The clinical reason code that this appointment is being scheduled. ### AppointmentStatusReasonId - **Field API Name:** `ssot__AppointmentStatusReasonId__c` - **Data Type:** TEXT - **Description:** The reason for given status of service appointment. ### ArrivalWindowEndDateTime - **Field API Name:** `ssot__ArrivalWindowEndDateTime__c` - **Data Type:** DATETIME - **Description:** The latest the service crew is expected to arrive. ### ArrivalWindowStartDateTime - **Field API Name:** `ssot__ArrivalWindowStartDateTime__c` - **Data Type:** DATETIME - **Description:** The earliest the service crew is expected to arrive. ### CancellationReasonText - **Field API Name:** `ssot__CancellationReasonText__c` - **Data Type:** TEXT - **Description:** Why the appointment was cancelled. ### cdp_sys_record_currency - **Field API Name:** `ssot__cdp_sys_record_currency__c` - **Data Type:** TEXT - **Description:** System-generated metadata field that stores a 3-letter ISO currency code. ### Comment - **Field API Name:** `ssot__Comment__c` - **Data Type:** TEXT - **Description:** Comments about the service appointment. Maximum size is 255 characters. ### CreatedById - **Field API Name:** `ssot__CreatedById__c` - **Data Type:** TEXT - **Description:** User who created the record. ### CreatedDate - **Field API Name:** `ssot__CreatedDate__c` - **Data Type:** DATETIME - **Description:** Date and time when this record was created. ### DataSourceId - **Field API Name:** `ssot__DataSourceId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### DataSourceObjectId - **Field API Name:** `ssot__DataSourceObjectId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### Description - **Field API Name:** `ssot__Description__c` - **Data Type:** TEXT - **Description:** The description of the appointment. ### DueDateTime - **Field API Name:** `ssot__DueDateTime__c` - **Data Type:** DATETIME - **Description:** The date by which the appointment must be completed. ### DurationInMinutes - **Field API Name:** `ssot__DurationInMinutes__c` - **Data Type:** DOUBLE - **Description:** Numeric value representing the duration in minutes. Do not include currency symbols or commas. ### DurationQuantity - **Field API Name:** `ssot__DurationQuantity__c` - **Data Type:** DOUBLE - **Description:** The estimated time required to complete the appointment. ### DurationUOMId - **Field API Name:** `ssot__DurationUOMId__c` - **Data Type:** TEXT - **Description:** Unit of Measurement of the Duration. For example, Hours, Minutes. ### EarliestStartDateTime - **Field API Name:** `ssot__EarliestStartDateTime__c` - **Data Type:** DATETIME - **Description:** The earliest the service crew may arrive. ### EmailAddress - **Field API Name:** `ssot__EmailAddress__c` - **Data Type:** TEXT - **Description:** The email address for email address. ### EngagementChannelType - **Field API Name:** `ssot__EngagementChannelType__c` - **Data Type:** TEXT - **Description:** A means by which a message can be delivered, for example an email, telephone call, SMS message or TV advertisement. ### GeocodeAccuracy - **Field API Name:** `ssot__GeocodeAccuracy__c` - **Data Type:** TEXT - **Description:** The level of accuracy of a location’s geographical coordinates compared with its physical address. Usually provided by a geocoding service based on the address’ latitude and longitude coordinates. ### Id - **Field API Name:** `ssot__Id__c` - **Data Type:** TEXT - **Description:** Required. A unique, system-generated identifier for this ServiceAppointment record. Maximum size is 36 characters. ### InJeopardy - **Field API Name:** `ssot__InJeopardy__c` - **Data Type:** TEXT - **Description:** Whether service appointment is in risk of not starting on time. ### InternalOrganizationId - **Field API Name:** `ssot__InternalOrganizationId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### IsAutoScheduled - **Field API Name:** `ssot__IsAutoScheduled__c` - **Data Type:** TEXT - **Description:** Whether to schedule an SA automatically by the schedule operation. ### IsBundle - **Field API Name:** `ssot__IsBundle__c` - **Data Type:** TEXT - **Description:** Whether this service appointment is a bundle service appointment. The default value is false. ### IsBundleMember - **Field API Name:** `ssot__IsBundleMember__c` - **Data Type:** TEXT - **Description:** Whether this service appointment is a bundle member service appointment. The default value is false. ### IsEmergency - **Field API Name:** `ssot__IsEmergency__c` - **Data Type:** TEXT - **Description:** Whether this service appointment is an emergency appointment. The default value is false. ### IsFillInCandidate - **Field API Name:** `ssot__IsFillInCandidate__c` - **Data Type:** TEXT - **Description:** Whether the appointment is can be used to fill in spaces. ### IsManuallyBundled - **Field API Name:** `ssot__IsManuallyBundled__c` - **Data Type:** TEXT - **Description:** Whether this bundle was created manually. The default value is false. ### IsMultiDay - **Field API Name:** `ssot__IsMultiDay__c` - **Data Type:** TEXT - **Description:** Whether the appointment is muilti day or not. ### IsOffsiteAppointment - **Field API Name:** `ssot__IsOffsiteAppointment__c` - **Data Type:** TEXT - **Description:** Any type of work that can be done remotely. ### IsPinned - **Field API Name:** `ssot__IsPinned__c` - **Data Type:** TEXT - **Description:** Whether this appointment is pinned by the dispatcher. ### IsUpdatedByOptimization - **Field API Name:** `ssot__IsUpdatedByOptimization__c` - **Data Type:** TEXT - **Description:** Whether SA was updated by optimazation. ### KQ_AccountContactId - **Field API Name:** `KQ_AccountContactId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AccountContactId ### KQ_AccountId - **Field API Name:** `KQ_AccountId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AccountId ### KQ_AddressId - **Field API Name:** `KQ_AddressId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AddressId ### KQ_CreatedById - **Field API Name:** `KQ_CreatedById__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for CreatedById ### KQ_DurationUOMId - **Field API Name:** `KQ_DurationUOMId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for DurationUOMId ### KQ_Id - **Field API Name:** `KQ_Id__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for Id ### KQ_LastModifiedById - **Field API Name:** `KQ_LastModifiedById__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for LastModifiedById ### KQ_OwnerId - **Field API Name:** `KQ_OwnerId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for OwnerId ### KQ_ParentRecordId - **Field API Name:** `KQ_ParentRecordId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ParentRecordId ### KQ_RelatedBundleId - **Field API Name:** `KQ_RelatedBundleId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for RelatedBundleId ### KQ_ServiceTerritoryId - **Field API Name:** `KQ_ServiceTerritoryId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ServiceTerritoryId ### KQ_WorkTypeId - **Field API Name:** `KQ_WorkTypeId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for WorkTypeId ### LastModifiedById - **Field API Name:** `ssot__LastModifiedById__c` - **Data Type:** TEXT - **Description:** User who most recently changed the record. ### LastModifiedDate - **Field API Name:** `ssot__LastModifiedDate__c` - **Data Type:** DATETIME - **Description:** Date and time when a user last modified this record. ### OwnerId - **Field API Name:** `ssot__OwnerId__c` - **Data Type:** TEXT - **Description:** The owner of the service appointment. ### OwnerObject - **Field API Name:** `ssot__OwnerObject__c` - **Data Type:** TEXT - **Description:** Indicates the Owner object name. For example, User, UserGroup. ### ParentRecordId - **Field API Name:** `ssot__ParentRecordId__c` - **Data Type:** TEXT - **Description:** The parent record associated with the appointment. The parent record can’t be updated after the service appointment is created. ### ParentRecordObject - **Field API Name:** `ssot__ParentRecordObject__c` - **Data Type:** TEXT - **Description:** Indicates the Parent Record Object Name. For example, WorkOrder, WorkOrderItem, Account, Opportunity, Asset. ### ParentRecordStatusCategory - **Field API Name:** `ssot__ParentRecordStatusCategory__c` - **Data Type:** TEXT - **Description:** The Status Category of the parent record. If the parent record is a work order or work order line item, this field is populated; otherwise, it remains blank. This field is read only. ### PhoneNumberText - **Field API Name:** `ssot__PhoneNumberText__c` - **Data Type:** TEXT - **Description:** The phone number for phone number text. Maximum size is 255 characters. ### RelatedBundleId - **Field API Name:** `ssot__RelatedBundleId__c` - **Data Type:** TEXT - **Description:** The bundle that this service appointment is a member of. ### ScheduledEndDateTime - **Field API Name:** `ssot__ScheduledEndDateTime__c` - **Data Type:** DATETIME - **Description:** When the appointment is schedule to end. ### ScheduledStartDateTime - **Field API Name:** `ssot__ScheduledStartDateTime__c` - **Data Type:** DATETIME - **Description:** When the appointment is schedule to begin. ### ServiceAppointmentNumber - **Field API Name:** `ssot__ServiceAppointmentNumber__c` - **Data Type:** TEXT - **Description:** Service Appointment Number. ### ServiceAppointmentScheduleMode - **Field API Name:** `ssot__ServiceAppointmentScheduleMode__c` - **Data Type:** TEXT - **Description:** Represents how the appointment was scheduled. For example, Manual, Automatic, Optimization, None. ### ServiceAppointmentStatus - **Field API Name:** `ssot__ServiceAppointmentStatus__c` - **Data Type:** TEXT - **Description:** Values Service Appointment Status may include: Scheduled-waiting for customer confirmation, and Scheduled-Resource requested. ### ServiceAppointmentStatusCategory - **Field API Name:** `ssot__ServiceAppointmentStatusCategory__c` - **Data Type:** TEXT - **Description:** Values Service Appointment Status Category include: Scheduled, In-Progress, Completed. ### ServiceAppointmentType - **Field API Name:** `ssot__ServiceAppointmentType__c` - **Data Type:** TEXT - **Description:** Represents type of appointment. For example, Phone, Branch, Video. ### ServiceDocumentTemplateIdentifier - **Field API Name:** `ssot__ServiceDocumentTemplateIdentifier__c` - **Data Type:** TEXT - **Description:** The template ID which sets the template for each service document for the Document Builder feature. ### ServiceNoteText - **Field API Name:** `ssot__ServiceNoteText__c` - **Data Type:** TEXT - **Description:** Instruction for the person assigned to the service appointment. ### ServiceTerritoryId - **Field API Name:** `ssot__ServiceTerritoryId__c` - **Data Type:** TEXT - **Description:** The service territory associated with the appointment. If the parent record is a work order or work order line item, the appointment inherits its parent’s service territory. ### ShouldScheduleOverLowerPriorityAppt - **Field API Name:** `ssot__ShouldScheduleOverLowerPriorityAppt__c` - **Data Type:** TEXT - **Description:** Whether SA is allowed to take precedence over lower priority SAs. ### SubjectText - **Field API Name:** `ssot__SubjectText__c` - **Data Type:** TEXT - **Description:** Subject text for the Service Appointment. ### SystemModstamp - **Field API Name:** `ssot__SystemModstamp__c` - **Data Type:** DATETIME - **Description:** Date and time when this record was last modified by a user or by an automated process. ### WorkTypeId - **Field API Name:** `ssot__WorkTypeId__c` - **Data Type:** TEXT - **Description:** The work type associated with the service appointment. The work type is inherited from the appointment’s parent record if the parent is a work order or work order line item.