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 API Name: ObjectMilestone_std__dlm
Category: Unassigned
Availability: Available in 262 and later versions
Primary Key Field: Id

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

• 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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