Case Milestone DMO

Object Properties

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

Relationships

• CaseId has a FOREIGNKEY relationship with the Case DMO Id field.
• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• CaseMilestoneTypeId has a FOREIGNKEY relationship with the Case Milestone Type DMO Id field.
• OperatingHoursId has a FOREIGNKEY relationship with the Operating Hours DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.

Fields

• ActualElapsedTimeInDays
• ActualElapsedTimeInHours
• ActualElapsedTimeInMinutes
• CaseId
• CaseMilestoneTypeId
• cdp_sys_record_currency
• CompletionDateTime
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• ElapsedTimeInDays
• ElapsedTimeInHours
• ElapsedTimeInMinutes
• Id
• InternalOrganizationId
• IsCompleted
• IsDeleted
• IsPaused
• IsViolated
• KQ_CaseId
• KQ_CaseMilestoneTypeId
• KQ_CreatedById
• KQ_Id
• KQ_LastModifiedById
• KQ_OperatingHoursId
• LastModifiedById
• LastModifiedDate
• Name
• OperatingHoursId
• PausedDateTime
• StartDateTime
• StoppedTimeInDays
• StoppedTimeInHours
• StoppedTimeInMinutes
• SystemModstamp
• TargetDateTime
• TargetResponseInDays
• TargetResponseInHours
• TargetResponseInMinutes
• TimeRemainingInDays
• TimeRemainingInHours
• TimeRemainingInHoursText
• TimeRemainingInMinutes
• TimeRemainingInMinutesText
• TimeRmnInHoursText
• TimeSinceTargetInDays
• TimeSinceTargetInHours
• TimeSinceTargetInHoursText
• TimeSinceTargetInMinutes
• TimeSinceTargetInMinutesText

ActualElapsedTimeInDays

• Field API Name: ssot__ActualElapsedTimeInDays__c
• Data Type: DOUBLE
• Description: Actual Elapsed Time In Days.

ActualElapsedTimeInHours

• Field API Name: ssot__ActualElapsedTimeInHours__c
• Data Type: DOUBLE
• Description: Actual Elapsed Time In Hours.

ActualElapsedTimeInMinutes

• Field API Name: ssot__ActualElapsedTimeInMinutes__c
• Data Type: DOUBLE
• Description: Actual Elapsed Time In Minutes.

CaseId

• Field API Name: ssot__CaseId__c
• Data Type: TEXT
• Description: The ID of the case.

CaseMilestoneTypeId

• Field API Name: ssot__CaseMilestoneTypeId__c
• Data Type: TEXT
• Description: Reference to the case milestone type. For example, Close Case, Escalate Case.

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.

CompletionDateTime

• Field API Name: ssot__CompletionDateTime__c
• Data Type: DATETIME
• Description: The date and time of the completion date time.

CreatedById

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

CreatedDate

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: The 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.

ElapsedTimeInDays

• Field API Name: ssot__ElapsedTimeInDays__c
• Data Type: DOUBLE
• Description: The time required to complete a milestone in days.

ElapsedTimeInHours

• Field API Name: ssot__ElapsedTimeInHours__c
• Data Type: DOUBLE
• Description: Elapsed Time In Hours.

ElapsedTimeInMinutes

• Field API Name: ssot__ElapsedTimeInMinutes__c
• Data Type: DOUBLE
• Description: Elapsed Time In Minutes.

Id

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this CaseMilestone record. Maximum size is 15 characters.

InternalOrganizationId

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

IsCompleted

• Field API Name: ssot__IsCompleted__c
• Data Type: BOOLEAN
• Description: Whether the milestone is completed (true) or not (false).

IsDeleted

• Field API Name: ssot__IsDeleted__c
• Data Type: BOOLEAN
• Description: Whether the milestone is deleted.

IsPaused

• Field API Name: ssot__IsPaused__c
• Data Type: BOOLEAN
• Description: Whether the milestone is paused(true) or not (false).

IsViolated

• Field API Name: ssot__IsViolated__c
• Data Type: BOOLEAN
• Description: Whether the milestone is violated (true) or not (false).

KQ_CaseId

• Field API Name: KQ_CaseId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CaseId

KQ_CaseMilestoneTypeId

• Field API Name: KQ_CaseMilestoneTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CaseMilestoneTypeId

KQ_CreatedById

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

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_OperatingHoursId

• Field API Name: KQ_OperatingHoursId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OperatingHoursId

LastModifiedById

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

LastModifiedDate

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

Name

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of the Case Milestone.

OperatingHoursId

• Field API Name: ssot__OperatingHoursId__c
• Data Type: TEXT
• Description: Reference to the business hours for the Case Milestone.

PausedDateTime

• Field API Name: ssot__PausedDateTime__c
• Data Type: DATETIME
• Description: Paused Date and Time of the milestone.

StartDateTime

• Field API Name: ssot__StartDateTime__c
• Data Type: DATETIME
• Description: Start Date and Time of the milestone.

StoppedTimeInDays

• Field API Name: ssot__StoppedTimeInDays__c
• Data Type: DOUBLE
• Description: Stopped Time In Days.

StoppedTimeInHours

• Field API Name: ssot__StoppedTimeInHours__c
• Data Type: DOUBLE
• Description: Stopped Time In Hours.

StoppedTimeInMinutes

• Field API Name: ssot__StoppedTimeInMinutes__c
• Data Type: DOUBLE
• Description: Stopped Time In Minutes.

SystemModstamp

• Field API Name: ssot__SystemModstamp__c
• Data Type: DATETIME
• Description: The date and time when this record was last modified by a user or by an automated process.

TargetDateTime

• Field API Name: ssot__TargetDateTime__c
• Data Type: DATETIME
• Description: Target Date and Time of the milestone.

TargetResponseInDays

• Field API Name: ssot__TargetResponseInDays__c
• Data Type: DOUBLE
• Description: The time to complete the milestone in days.

TargetResponseInHours

• Field API Name: ssot__TargetResponseInHours__c
• Data Type: DOUBLE
• Description: Target Response In Hours.

TargetResponseInMinutes

• Field API Name: ssot__TargetResponseInMinutes__c
• Data Type: DOUBLE
• Description: Target Response In Minutes.

TimeRemainingInDays

• Field API Name: ssot__TimeRemainingInDays__c
• Data Type: DOUBLE
• Description: Time remaining to reach the milestone target, measured in days.

TimeRemainingInHours

• Field API Name: ssot__TimeRemainingInHours__c
• Data Type: DOUBLE
• Description: Time Remaining In Hours.

TimeRemainingInHoursText

• Field API Name: ssot__TimeRemainingInHoursText__c
• Data Type: DOUBLE
• Description: Time Remaining In Hours.

TimeRemainingInMinutes

• Field API Name: ssot__TimeRemainingInMinutes__c
• Data Type: DOUBLE
• Description: Time Remaining In Minutes.

TimeRemainingInMinutesText

• Field API Name: ssot__TimeRemainingInMinutesText__c
• Data Type: TEXT
• Description: Time Remaining In Minutes.

TimeRmnInHoursText

• Field API Name: ssot__TimeRmnInHoursText__c
• Data Type: TEXT
• Description: Time Remaining In Hours.

TimeSinceTargetInDays

• Field API Name: ssot__TimeSinceTargetInDays__c
• Data Type: DOUBLE
• Description: The time elapsed since the milestone target, measured in days.

TimeSinceTargetInHours

• Field API Name: ssot__TimeSinceTargetInHours__c
• Data Type: DOUBLE
• Description: Time Since Target In Hours.

TimeSinceTargetInHoursText

• Field API Name: ssot__TimeSinceTargetInHoursText__c
• Data Type: TEXT
• Description: Time Since Target In Hours.

TimeSinceTargetInMinutes

• Field API Name: ssot__TimeSinceTargetInMinutes__c
• Data Type: DOUBLE
• Description: Time Since Target In Minutes.

TimeSinceTargetInMinutesText

• Field API Name: ssot__TimeSinceTargetInMinutesText__c
• Data Type: TEXT
• Description: Time Since Target In Minutes.