Salesforce Docs Portal

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 Id field.
  • ParentRecordId has a FOREIGNKEY relationship with the Clinical Service Request DMO Id field.
  • ParentRecordId has a FOREIGNKEY relationship with the Care Program Enrollee DMO Id field.
  • ServiceTerritoryId has a FOREIGNKEY relationship with the Service Territory DMO Id field.
  • CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
  • AddressId has a FOREIGNKEY relationship with the Location DMO Id field.
  • AccountId has a FOREIGNKEY relationship with the Account DMO Id field.
  • AccountContactId has a FOREIGNKEY relationship with the Account Contact DMO Id field.
  • OwnerId has a FOREIGNKEY relationship with the User DMO Id field.
  • OwnerId has a FOREIGNKEY relationship with the User Group DMO Id field.
  • LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.
  • DurationUOMId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
  • ParentRecordId has a FOREIGNKEY relationship with the Work Order Item DMO Id field.
  • ParentRecordId has a FOREIGNKEY relationship with the Opportunity DMO Id field.
  • ParentRecordId has a FOREIGNKEY relationship with the Asset DMO Id field.
  • ParentRecordId has a FOREIGNKEY relationship with the Account DMO Id field.
  • WorkTypeId has a FOREIGNKEY relationship with the Work Type DMO Id field.
  • ParentRecordId has a FOREIGNKEY relationship with the Work Order DMO Id field.
  • AddressId has a FOREIGNKEY relationship with the Address DMO Id field.
  • RelatedBundleId has a FOREIGNKEY relationship with the Service Appointment DMO Id field.

Fields

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.