# 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](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-casedmo-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.
- **CaseMilestoneTypeId** 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.
- **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)
- [ActualElapsedTimeInHours](#actualelapsedtimeinhours)
- [ActualElapsedTimeInMinutes](#actualelapsedtimeinminutes)
- [CaseId](#caseid)
- [CaseMilestoneTypeId](#casemilestonetypeid)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CompletionDateTime](#completiondatetime)
- [CreatedById](#createdbyid)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [ElapsedTimeInDays](#elapsedtimeindays)
- [ElapsedTimeInHours](#elapsedtimeinhours)
- [ElapsedTimeInMinutes](#elapsedtimeinminutes)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsCompleted](#iscompleted)
- [IsDeleted](#isdeleted)
- [IsPaused](#ispaused)
- [IsViolated](#isviolated)
- [KQ_CaseId](#kq_caseid)
- [KQ_CaseMilestoneTypeId](#kq_casemilestonetypeid)
- [KQ_CreatedById](#kq_createdbyid)
- [KQ_Id](#kq_id)
- [KQ_LastModifiedById](#kq_lastmodifiedbyid)
- [KQ_OperatingHoursId](#kq_operatinghoursid)
- [LastModifiedById](#lastmodifiedbyid)
- [LastModifiedDate](#lastmodifieddate)
- [Name](#name)
- [OperatingHoursId](#operatinghoursid)
- [PausedDateTime](#pauseddatetime)
- [StartDateTime](#startdatetime)
- [StoppedTimeInDays](#stoppedtimeindays)
- [StoppedTimeInHours](#stoppedtimeinhours)
- [StoppedTimeInMinutes](#stoppedtimeinminutes)
- [SystemModstamp](#systemmodstamp)
- [TargetDateTime](#targetdatetime)
- [TargetResponseInDays](#targetresponseindays)
- [TargetResponseInHours](#targetresponseinhours)
- [TargetResponseInMinutes](#targetresponseinminutes)
- [TimeRemainingInDays](#timeremainingindays)
- [TimeRemainingInHours](#timeremaininginhours)
- [TimeRemainingInHoursText](#timeremaininginhourstext)
- [TimeRemainingInMinutes](#timeremaininginminutes)
- [TimeRemainingInMinutesText](#timeremaininginminutestext)
- [TimeRmnInHoursText](#timermninhourstext)
- [TimeSinceTargetInDays](#timesincetargetindays)
- [TimeSinceTargetInHours](#timesincetargetinhours)
- [TimeSinceTargetInHoursText](#timesincetargetinhourstext)
- [TimeSinceTargetInMinutes](#timesincetargetinminutes)
- [TimeSinceTargetInMinutesText](#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.