Service Appointment DMO

Object API Name: ssot__ServiceAppointment__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

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

• AccountContactId
• AccountId
• ActualDurationNumber
• ActualEndDateTime
• ActualStartDateTime
• AdditionalInformationText
• AddressId
• AppointmentBundlePolicyId
• AppointmentPriority
• AppointmentReasonCodeId
• AppointmentStatusReasonId
• ArrivalWindowEndDateTime
• ArrivalWindowStartDateTime
• CancellationReasonText
• cdp_sys_record_currency
• Comment
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• Description
• DueDateTime
• DurationInMinutes
• DurationQuantity
• DurationUOMId
• EarliestStartDateTime
• EmailAddress
• EngagementChannelType
• GeocodeAccuracy
• Id
• InJeopardy
• InternalOrganizationId
• IsAutoScheduled
• IsBundle
• IsBundleMember
• IsEmergency
• IsFillInCandidate
• IsManuallyBundled
• IsMultiDay
• IsOffsiteAppointment
• IsPinned
• IsUpdatedByOptimization
• KQ_AccountContactId
• KQ_AccountId
• KQ_AddressId
• KQ_CreatedById
• KQ_DurationUOMId
• KQ_Id
• KQ_LastModifiedById
• KQ_OwnerId
• KQ_ParentRecordId
• KQ_RelatedBundleId
• KQ_ServiceTerritoryId
• KQ_WorkTypeId
• LastModifiedById
• LastModifiedDate
• OwnerId
• OwnerObject
• ParentRecordId
• ParentRecordObject
• ParentRecordStatusCategory
• PhoneNumberText
• RelatedBundleId
• ScheduledEndDateTime
• ScheduledStartDateTime
• ServiceAppointmentNumber
• ServiceAppointmentScheduleMode
• ServiceAppointmentStatus
• ServiceAppointmentStatusCategory
• ServiceAppointmentType
• ServiceDocumentTemplateIdentifier
• ServiceNoteText
• ServiceTerritoryId
• ShouldScheduleOverLowerPriorityAppt
• SubjectText
• SystemModstamp
• WorkTypeId

• Field API Name: ssot__AccountContactId__c
• Data Type: TEXT
• Description: Reference to the contact associated with the appointment.

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

• Field API Name: ssot__ActualDurationNumber__c
• Data Type: DOUBLE
• Description: The actual time spent to complete the appointment.

• Field API Name: ssot__ActualEndDateTime__c
• Data Type: DATETIME
• Description: The date and time of the actual end date time.

• Field API Name: ssot__ActualStartDateTime__c
• Data Type: DATETIME
• Description: When the appointment actually began.

• Field API Name: ssot__AdditionalInformationText__c
• Data Type: TEXT
• Description: Additional info about the service appointment.

• Field API Name: ssot__AddressId__c
• Data Type: TEXT
• Description: Where the service appointment takes place.

• Field API Name: ssot__AppointmentBundlePolicyId__c
• Data Type: TEXT
• Description: Reference to the bundle policy associated with this service appointment.

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

• Field API Name: ssot__AppointmentReasonCodeId__c
• Data Type: TEXT
• Description: The clinical reason code that this appointment is being scheduled.

• Field API Name: ssot__AppointmentStatusReasonId__c
• Data Type: TEXT
• Description: The reason for given status of service appointment.

• Field API Name: ssot__ArrivalWindowEndDateTime__c
• Data Type: DATETIME
• Description: The latest the service crew is expected to arrive.

• Field API Name: ssot__ArrivalWindowStartDateTime__c
• Data Type: DATETIME
• Description: The earliest the service crew is expected to arrive.

• Field API Name: ssot__CancellationReasonText__c
• Data Type: TEXT
• Description: Why the appointment was cancelled.

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

• Field API Name: ssot__Comment__c
• Data Type: TEXT
• Description: Comments about the service appointment. Maximum size is 255 characters.

• Field API Name: ssot__CreatedById__c
• Data Type: TEXT
• Description: User who created the record.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: Date and time when this record was created.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Description__c
• Data Type: TEXT
• Description: The description of the appointment.

• Field API Name: ssot__DueDateTime__c
• Data Type: DATETIME
• Description: The date by which the appointment must be completed.

• Field API Name: ssot__DurationInMinutes__c
• Data Type: DOUBLE
• Description: Numeric value representing the duration in minutes. Do not include currency symbols or commas.

• Field API Name: ssot__DurationQuantity__c
• Data Type: DOUBLE
• Description: The estimated time required to complete the appointment.

• Field API Name: ssot__DurationUOMId__c
• Data Type: TEXT
• Description: Unit of Measurement of the Duration. For example, Hours, Minutes.

• Field API Name: ssot__EarliestStartDateTime__c
• Data Type: DATETIME
• Description: The earliest the service crew may arrive.

• Field API Name: ssot__EmailAddress__c
• Data Type: TEXT
• Description: The email address for email address.

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

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

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

• Field API Name: ssot__InJeopardy__c
• Data Type: TEXT
• Description: Whether service appointment is in risk of not starting on time.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__IsAutoScheduled__c
• Data Type: TEXT
• Description: Whether to schedule an SA automatically by the schedule operation.

• Field API Name: ssot__IsBundle__c
• Data Type: TEXT
• Description: Whether this service appointment is a bundle service appointment. The default value is false.

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

• Field API Name: ssot__IsEmergency__c
• Data Type: TEXT
• Description: Whether this service appointment is an emergency appointment. The default value is false.

• Field API Name: ssot__IsFillInCandidate__c
• Data Type: TEXT
• Description: Whether the appointment is can be used to fill in spaces.

• Field API Name: ssot__IsManuallyBundled__c
• Data Type: TEXT
• Description: Whether this bundle was created manually. The default value is false.

• Field API Name: ssot__IsMultiDay__c
• Data Type: TEXT
• Description: Whether the appointment is muilti day or not.

• Field API Name: ssot__IsOffsiteAppointment__c
• Data Type: TEXT
• Description: Any type of work that can be done remotely.

• Field API Name: ssot__IsPinned__c
• Data Type: TEXT
• Description: Whether this appointment is pinned by the dispatcher.

• Field API Name: ssot__IsUpdatedByOptimization__c
• Data Type: TEXT
• Description: Whether SA was updated by optimazation.

• Field API Name: KQ_AccountContactId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountContactId

• Field API Name: KQ_AccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountId

• Field API Name: KQ_AddressId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AddressId

• Field API Name: KQ_CreatedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for CreatedById

• Field API Name: KQ_DurationUOMId__c
• Data Type: TEXT
• Description: Key Qualifier system field for DurationUOMId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_LastModifiedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for LastModifiedById

• Field API Name: KQ_OwnerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OwnerId

• Field API Name: KQ_ParentRecordId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ParentRecordId

• Field API Name: KQ_RelatedBundleId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RelatedBundleId

• Field API Name: KQ_ServiceTerritoryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ServiceTerritoryId

• Field API Name: KQ_WorkTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for WorkTypeId

• Field API Name: ssot__LastModifiedById__c
• Data Type: TEXT
• Description: User who most recently changed the record.

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: Date and time when a user last modified this record.

• Field API Name: ssot__OwnerId__c
• Data Type: TEXT
• Description: The owner of the service appointment.

• Field API Name: ssot__OwnerObject__c
• Data Type: TEXT
• Description: Indicates the Owner object name. For example, User, UserGroup.

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

• Field API Name: ssot__ParentRecordObject__c
• Data Type: TEXT
• Description: Indicates the Parent Record Object Name. For example, WorkOrder, WorkOrderItem, Account, Opportunity, Asset.

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

• Field API Name: ssot__PhoneNumberText__c
• Data Type: TEXT
• Description: The phone number for phone number text. Maximum size is 255 characters.

• Field API Name: ssot__RelatedBundleId__c
• Data Type: TEXT
• Description: The bundle that this service appointment is a member of.

• Field API Name: ssot__ScheduledEndDateTime__c
• Data Type: DATETIME
• Description: When the appointment is schedule to end.

• Field API Name: ssot__ScheduledStartDateTime__c
• Data Type: DATETIME
• Description: When the appointment is schedule to begin.

• Field API Name: ssot__ServiceAppointmentNumber__c
• Data Type: TEXT
• Description: Service Appointment Number.

• Field API Name: ssot__ServiceAppointmentScheduleMode__c
• Data Type: TEXT
• Description: Represents how the appointment was scheduled. For example, Manual, Automatic, Optimization, None.

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

• Field API Name: ssot__ServiceAppointmentStatusCategory__c
• Data Type: TEXT
• Description: Values Service Appointment Status Category include: Scheduled, In-Progress, Completed.

• Field API Name: ssot__ServiceAppointmentType__c
• Data Type: TEXT
• Description: Represents type of appointment. For example, Phone, Branch, Video.

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

• Field API Name: ssot__ServiceNoteText__c
• Data Type: TEXT
• Description: Instruction for the person assigned to the service appointment.

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

• Field API Name: ssot__ShouldScheduleOverLowerPriorityAppt__c
• Data Type: TEXT
• Description: Whether SA is allowed to take precedence over lower priority SAs.

• Field API Name: ssot__SubjectText__c
• Data Type: TEXT
• Description: Subject text for the Service Appointment.

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

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