Object Milestone DMO

Represents milestones associated with objects such as Work Order, Incident, Problem, or Change Request. Tracks milestone status, timing metrics, and completion details.

Object Properties

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

Relationships

• ParentId has a FOREIGNKEY relationship with the Incident DMO Id field.
• ParentId has a FOREIGNKEY relationship with the Problem DMO Id field.
• ParentId has a FOREIGNKEY relationship with the Change Request DMO Id field.
• ParentId has a FOREIGNKEY relationship with the Work Order DMO Id field.
• IncidentId has a FOREIGNKEY relationship with the Incident DMO Id field.
• ProblemId has a FOREIGNKEY relationship with the Problem DMO Id field.
• ChangeRequestId has a FOREIGNKEY relationship with the Change Request DMO Id field.
• WorkOrderId has a FOREIGNKEY relationship with the Work Order DMO Id field.
• MilestoneTypeId has a FOREIGNKEY relationship with the Case Milestone Type DMO Id field.
• OperatingHoursId has a FOREIGNKEY relationship with the Operating Hours DMO Id field.
• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.

Fields

• ActualElapsedTimeInDays
• ActualElapsedTimeInHrs
• ActualElapsedTimeInMins
• cdp_sys_record_currency
• ChangeRequestId
• CompletionDateTime
• CreatedById
• CreatedDateTime
• DataSourceId
• DataSourceObjectId
• ElapsedTimeInDays
• ElapsedTimeInHrs
• ElapsedTimeInMins
• Id
• IncidentId
• InternalOrganizationId
• IsCompleted
• IsPaused
• IsViolated
• KQ_ChangeRequestId
• KQ_CreatedById
• KQ_Id
• KQ_IncidentId
• KQ_LastModifiedById
• KQ_MilestoneTypeId
• KQ_OperatingHoursId
• KQ_ParentId
• KQ_ProblemId
• KQ_WorkOrderId
• LastModifiedById
• LastModifiedDateTime
• MilestoneName
• MilestoneTypeId
• OperatingHoursId
• ParentId
• ParentObject
• PausedDateTime
• ProblemId
• StartDateTime
• StoppedTimeInDays
• StoppedTimeInHrs
• StoppedTimeInMins
• TargetDateTime
• TargetResponseInDays
• TargetResponseInHrs
• TargetResponseInMins
• TimeRemainingInDays
• TimeRemainingInHrs
• TimeRemainingInMins
• TimeSinceTargetInDays
• TimeSinceTargetInHrs
• TimeSinceTargetInMins
• WorkOrderId

ActualElapsedTimeInDays

• Field API Name: ActualElapsedTimeInDays__c
• Data Type: DOUBLE
• Description: Actual time elapsed excluding stopped time in days

ActualElapsedTimeInHrs

• Field API Name: ActualElapsedTimeInHrs__c
• Data Type: DOUBLE
• Description: Actual time elapsed excluding stopped time in hours

ActualElapsedTimeInMins

• Field API Name: ActualElapsedTimeInMins__c
• Data Type: DOUBLE
• Description: Actual time elapsed excluding stopped time in minutes

cdp_sys_record_currency

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

ChangeRequestId

• Field API Name: ChangeRequestId__c
• Data Type: TEXT
• Description: Reference to Change Request that this milestone belongs to

CompletionDateTime

• Field API Name: CompletionDateTime__c
• Data Type: DATETIME
• Description: The date and time when this milestone was completed

CreatedById

• Field API Name: CreatedById__c
• Data Type: TEXT
• Description: Reference to the user who created this record

CreatedDateTime

• Field API Name: CreatedDateTime__c
• Data Type: DATETIME
• Description: The date and time when this record was created

DataSourceId

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

DataSourceObjectId

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

ElapsedTimeInDays

• Field API Name: ElapsedTimeInDays__c
• Data Type: DOUBLE
• Description: Time elapsed since milestone start in days

ElapsedTimeInHrs

• Field API Name: ElapsedTimeInHrs__c
• Data Type: DOUBLE
• Description: Time elapsed since milestone start in hours

ElapsedTimeInMins

• Field API Name: ElapsedTimeInMins__c
• Data Type: DOUBLE
• Description: Time elapsed since milestone start in minutes

Id

• Field API Name: Id__c
• Data Type: TEXT
• Description: Primary Key

IncidentId

• Field API Name: IncidentId__c
• Data Type: TEXT
• Description: Reference to Incident that this milestone belongs to

InternalOrganizationId

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

IsCompleted

• Field API Name: IsCompleted__c
• Data Type: BOOLEAN
• Description: Indicates whether the milestone is completed

IsPaused

• Field API Name: IsPaused__c
• Data Type: BOOLEAN
• Description: Indicates whether the milestone is paused

IsViolated

• Field API Name: IsViolated__c
• Data Type: BOOLEAN
• Description: Indicates whether the milestone is violated (target date passed)

KQ_ChangeRequestId

• Field API Name: KQ_ChangeRequestId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ChangeRequestId

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_IncidentId

• Field API Name: KQ_IncidentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for IncidentId

KQ_LastModifiedById

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

KQ_MilestoneTypeId

• Field API Name: KQ_MilestoneTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MilestoneTypeId

KQ_OperatingHoursId

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

KQ_ParentId

• Field API Name: KQ_ParentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ParentId

KQ_ProblemId

• Field API Name: KQ_ProblemId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProblemId

KQ_WorkOrderId

• Field API Name: KQ_WorkOrderId__c
• Data Type: TEXT
• Description: Key Qualifier system field for WorkOrderId

LastModifiedById

• Field API Name: LastModifiedById__c
• Data Type: TEXT
• Description: Reference to the user who last modified this record

LastModifiedDateTime

• Field API Name: LastModifiedDateTime__c
• Data Type: DATETIME
• Description: The date and time when this record was last modified

MilestoneName

• Field API Name: MilestoneName__c
• Data Type: TEXT
• Description: Name of the milestone

MilestoneTypeId

• Field API Name: MilestoneTypeId__c
• Data Type: TEXT
• Description: This identifies the underlying type of the milestone.

OperatingHoursId

• Field API Name: OperatingHoursId__c
• Data Type: TEXT
• Description: Business hours used for time calculation

ParentId

• Field API Name: ParentId__c
• Data Type: TEXT
• Description: Reference to WorkOrder, Incident, Problem or ChangeRequest that this milestone belongs to

ParentObject

• Field API Name: ParentObject__c
• Data Type: TEXT
• Description: Name of the object which is being referenced as parent. Ex - Incident, Problem, Work Order, Change Request

PausedDateTime

• Field API Name: PausedDateTime__c
• Data Type: DATETIME
• Description: The date and time when this milestone paused

ProblemId

• Field API Name: ProblemId__c
• Data Type: TEXT
• Description: Reference to Problem that this milestone belongs to

StartDateTime

• Field API Name: StartDateTime__c
• Data Type: DATETIME
• Description: The date and time when this milestone started

StoppedTimeInDays

• Field API Name: StoppedTimeInDays__c
• Data Type: DOUBLE
• Description: Time during which the milestone was paused in days

StoppedTimeInHrs

• Field API Name: StoppedTimeInHrs__c
• Data Type: DOUBLE
• Description: Time during which the milestone was paused in hours

StoppedTimeInMins

• Field API Name: StoppedTimeInMins__c
• Data Type: DOUBLE
• Description: Time during which the milestone was paused in minutes

TargetDateTime

• Field API Name: TargetDateTime__c
• Data Type: DATETIME
• Description: The date and time by which this milestone should be completed

TargetResponseInDays

• Field API Name: TargetResponseInDays__c
• Data Type: DOUBLE
• Description: Target response time in days

TargetResponseInHrs

• Field API Name: TargetResponseInHrs__c
• Data Type: DOUBLE
• Description: Target response time in hours

TargetResponseInMins

• Field API Name: TargetResponseInMins__c
• Data Type: DOUBLE
• Description: Target response time in minutes

TimeRemainingInDays

• Field API Name: TimeRemainingInDays__c
• Data Type: DOUBLE
• Description: Time remaining to reach target in days

TimeRemainingInHrs

• Field API Name: TimeRemainingInHrs__c
• Data Type: DOUBLE
• Description: Time remaining to reach target in hours

TimeRemainingInMins

• Field API Name: TimeRemainingInMins__c
• Data Type: DOUBLE
• Description: Time remaining to reach target in minutes

TimeSinceTargetInDays

• Field API Name: TimeSinceTargetInDays__c
• Data Type: DOUBLE
• Description: Time elapsed since target date in days

TimeSinceTargetInHrs

• Field API Name: TimeSinceTargetInHrs__c
• Data Type: DOUBLE
• Description: Time elapsed since target date in hours

TimeSinceTargetInMins

• Field API Name: TimeSinceTargetInMins__c
• Data Type: DOUBLE
• Description: Time elapsed since target date in minutes

WorkOrderId

• Field API Name: WorkOrderId__c
• Data Type: TEXT
• Description: Reference to Work Order that this milestone belongs to