CaseMilestone

Name	Label	Type	Description
Id	Case Milestone ID	ID
CaseId	Case ID	LOOKUP
StartDate	Start Date	DATETIME
TargetDate	Target Date	DATETIME
CompletionDate	Completion Date	DATETIME
MilestoneTypeId	Milestone Type ID	LOOKUP
IsCompleted	Completed	CHECKBOX
IsViolated	Violation	CHECKBOX
SystemModstamp	System Modstamp	DATETIME
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
IsDeleted	Deleted	CHECKBOX
TargetResponseInMins	Target Response (Mins)	AUTO NUMBER
TargetResponseInHrs	Target Response (Hours)	NUMBER(4,2)
TargetResponseInDays	Target Response (Days)	NUMBER(4,2)
TimeRemainingInMins	Time Remaining (Min:Sec)	TEXT(10)
TimeRemainingInHrs	Time Remaining (Hour:Min)	TEXT(10)
TimeRemainingInDays	Time Remaining (Days)	NUMBER(4,2)
ElapsedTimeInMins	Elapsed Time (Mins)	AUTO NUMBER
ElapsedTimeInHrs	Elapsed Time (Hours)	NUMBER(4,2)
ElapsedTimeInDays	Elapsed Time (Days)	NUMBER(4,2)
TimeSinceTargetInMins	Time Since Target (Min:Sec)	TEXT(10)
TimeSinceTargetInHrs	Time Since Target (Hour:Min)	TEXT(10)
TimeSinceTargetInDays	Time Since Target (Days)	NUMBER(4,2)
BusinessHoursId	Business Hours ID	LOOKUP
StoppedTimeInMins	Stopped Time (Mins)	AUTO NUMBER
StoppedTimeInHrs	Stopped Time (Hours)	NUMBER(4,2)
StoppedTimeInDays	Stopped Time (Days)	NUMBER(4,2)
ActualElapsedTimeInMins	Actual Elapsed Time (Mins)	AUTO NUMBER
ActualElapsedTimeInHrs	Actual Elapsed Time (Hours)	NUMBER(4,2)
ActualElapsedTimeInDays	Actual Elapsed Time (Days)	NUMBER(4,2)

Name	Id
Label	Case Milestone ID
Type	ID
Required	Yes

Name	CaseId
Label	Case ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	StartDate
Label	Start Date
Type	DATETIME

Name	TargetDate
Label	Target Date
Type	DATETIME
Required	Yes

Name	CompletionDate
Label	Completion Date
Type	DATETIME

Name	MilestoneTypeId
Label	Milestone Type ID
Type	LOOKUP

Name	IsCompleted
Label	Completed
Type	CHECKBOX
Required	Yes
Default value	false

Name	IsViolated
Label	Violation
Type	CHECKBOX
Required	Yes
Default value	false

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	TargetResponseInMins
Label	Target Response (Mins)
Type	AUTO NUMBER

Name	TargetResponseInHrs
Label	Target Response (Hours)
Type	NUMBER(4,2)

Name	TargetResponseInDays
Label	Target Response (Days)
Type	NUMBER(4,2)

Name	TimeRemainingInMins
Label	Time Remaining (Min:Sec)
Type	TEXT(10)

Name	TimeRemainingInHrs
Label	Time Remaining (Hour:Min)
Type	TEXT(10)

Name	TimeRemainingInDays
Label	Time Remaining (Days)
Type	NUMBER(4,2)

Name	ElapsedTimeInMins
Label	Elapsed Time (Mins)
Type	AUTO NUMBER

Name	ElapsedTimeInHrs
Label	Elapsed Time (Hours)
Type	NUMBER(4,2)

Name	ElapsedTimeInDays
Label	Elapsed Time (Days)
Type	NUMBER(4,2)

Name	TimeSinceTargetInMins
Label	Time Since Target (Min:Sec)
Type	TEXT(10)

Name	TimeSinceTargetInHrs
Label	Time Since Target (Hour:Min)
Type	TEXT(10)

Name	TimeSinceTargetInDays
Label	Time Since Target (Days)
Type	NUMBER(4,2)

Name	BusinessHoursId
Label	Business Hours ID
Type	LOOKUP

Name	StoppedTimeInMins
Label	Stopped Time (Mins)
Type	AUTO NUMBER

Name	StoppedTimeInHrs
Label	Stopped Time (Hours)
Type	NUMBER(4,2)

Name	StoppedTimeInDays
Label	Stopped Time (Days)
Type	NUMBER(4,2)

Name	ActualElapsedTimeInMins
Label	Actual Elapsed Time (Mins)
Type	AUTO NUMBER

Name	ActualElapsedTimeInHrs
Label	Actual Elapsed Time (Hours)
Type	NUMBER(4,2)

Name	ActualElapsedTimeInDays
Label	Actual Elapsed Time (Days)
Type	NUMBER(4,2)

Name	Parent object	Child object	Parent object field	Child object field
Case	Case	CaseMilestone	Id	CaseId
CreatedBy	User	CaseMilestone	Id	CreatedById
LastModifiedBy	User	CaseMilestone	Id	LastModifiedById

Label	Value