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: std__ObjectMilestoneDmo__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
• 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: std__ActualElapsedTimeInDays__c
• Data Type: DOUBLE
• Description: Actual time elapsed excluding stopped time in days

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• Field API Name: std__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: std__PausedDateTime__c
• Data Type: DATETIME
• Description: The date and time when this milestone paused

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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