# 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](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-incidentdmo-dmo.md) `Id` field.
- **ParentId** has a FOREIGNKEY relationship with the [Problem DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-problemdmo-dmo.md) `Id` field.
- **ParentId** has a FOREIGNKEY relationship with the [Change Request DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-changerequestdmo-dmo.md) `Id` field.
- **ParentId** has a FOREIGNKEY relationship with the [Work Order DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderdmo-dmo.md) `Id` field.
- **IncidentId** has a FOREIGNKEY relationship with the [Incident DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-incidentdmo-dmo.md) `Id` field.
- **ProblemId** has a FOREIGNKEY relationship with the [Problem DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-problemdmo-dmo.md) `Id` field.
- **ChangeRequestId** has a FOREIGNKEY relationship with the [Change Request DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-changerequestdmo-dmo.md) `Id` field.
- **WorkOrderId** has a FOREIGNKEY relationship with the [Work Order DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderdmo-dmo.md) `Id` field.
- **MilestoneTypeId** has a FOREIGNKEY relationship with the [Case Milestone Type DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-casemilestonetypedmo-dmo.md) `Id` field.
- **OperatingHoursId** has a FOREIGNKEY relationship with the [Operating Hours DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-operatinghoursdmo-dmo.md) `Id` field.
- **CreatedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.
- **LastModifiedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.

## Fields

- [ActualElapsedTimeInDays](#actualelapsedtimeindays)
- [ActualElapsedTimeInHrs](#actualelapsedtimeinhrs)
- [ActualElapsedTimeInMins](#actualelapsedtimeinmins)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [ChangeRequestId](#changerequestid)
- [CompletionDateTime](#completiondatetime)
- [CreatedById](#createdbyid)
- [CreatedDateTime](#createddatetime)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [ElapsedTimeInDays](#elapsedtimeindays)
- [ElapsedTimeInHrs](#elapsedtimeinhrs)
- [ElapsedTimeInMins](#elapsedtimeinmins)
- [Id](#id)
- [IncidentId](#incidentid)
- [InternalOrganizationId](#internalorganizationid)
- [IsCompleted](#iscompleted)
- [IsPaused](#ispaused)
- [IsViolated](#isviolated)
- [KQ_ChangeRequestId](#kq_changerequestid)
- [KQ_CreatedById](#kq_createdbyid)
- [KQ_Id](#kq_id)
- [KQ_IncidentId](#kq_incidentid)
- [KQ_LastModifiedById](#kq_lastmodifiedbyid)
- [KQ_MilestoneTypeId](#kq_milestonetypeid)
- [KQ_OperatingHoursId](#kq_operatinghoursid)
- [KQ_ParentId](#kq_parentid)
- [KQ_ProblemId](#kq_problemid)
- [KQ_WorkOrderId](#kq_workorderid)
- [LastModifiedById](#lastmodifiedbyid)
- [LastModifiedDateTime](#lastmodifieddatetime)
- [MilestoneName](#milestonename)
- [MilestoneTypeId](#milestonetypeid)
- [OperatingHoursId](#operatinghoursid)
- [ParentId](#parentid)
- [ParentObject](#parentobject)
- [PausedDateTime](#pauseddatetime)
- [ProblemId](#problemid)
- [StartDateTime](#startdatetime)
- [StoppedTimeInDays](#stoppedtimeindays)
- [StoppedTimeInHrs](#stoppedtimeinhrs)
- [StoppedTimeInMins](#stoppedtimeinmins)
- [TargetDateTime](#targetdatetime)
- [TargetResponseInDays](#targetresponseindays)
- [TargetResponseInHrs](#targetresponseinhrs)
- [TargetResponseInMins](#targetresponseinmins)
- [TimeRemainingInDays](#timeremainingindays)
- [TimeRemainingInHrs](#timeremaininginhrs)
- [TimeRemainingInMins](#timeremaininginmins)
- [TimeSinceTargetInDays](#timesincetargetindays)
- [TimeSinceTargetInHrs](#timesincetargetinhrs)
- [TimeSinceTargetInMins](#timesincetargetinmins)
- [WorkOrderId](#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