Changes

ServiceDeskPlus change management with comprehensive lifecycle tracking, approval workflows, and implementation coordination

Columns

Name	Type	References
Id [KEY]	Long
ApprovalStatusId	Long
CategoryId	Long
ParentChangeId	Long	Changes.Id
ChangeTypeId	Long
ClosureCodeId	Long
DepartmentId	Long
GroupId	Long
ImpactId	Long
ItemId	Long
PriorityId	Long
ReasonForChangeId	Long
ReleasesId	Long	Releases.Id
RiskId	Long
SiteId	Long
StageId	Long
StatusStageId	Long
StatusId	Long
WorkflowInstanceStatusId	Long
SubcategoryId	Long
UrgencyId	Long
ChangeManagerId	Long
ChangeOwnerId	Long
ChangeRequesterId	Long
ReleaseDetailsUpdatedById	Long
UatDetailsUpdatedById	Long
WorkflowInstanceId	Long
Title	String
StatusName	String
ChangeTypeName	String
CategoryName	String
PriorityName	String
CreatedTime	Datetime
LastUpdatedTime	Datetime
ActualEndTime	Datetime
ActualStartTime	Datetime
BackOutPlanUpdatedOn	Datetime
CabMeetingDate	Datetime
ClosedTime	Datetime
CommunicationPlanUpdatedOn	Datetime
CompletedTime	Datetime
DueByTime	Datetime
NextReviewOn	Datetime
ReleaseActualEndTime	Datetime
ReleaseActualStartTime	Datetime
ReleaseDetailsUpdatedOn	Datetime
ReleaseScheduledEndTime	Datetime
ReleaseScheduledStartTime	Datetime
RollOutPlanUpdatedOn	Datetime
ScheduledEndTime	Datetime
ScheduledStartTime	Datetime
TestPlanUpdatedOn	Datetime
UatActualEndTime	Datetime
UatActualStartTime	Datetime
UatDetailsUpdatedOn	Datetime
UatScheduledEndTime	Datetime
UatScheduledStartTime	Datetime
ActualCost	Decimal
ActualDowntime	Integer
ActualEndTimeDisplay	String
ActualHours	Long
ActualStartTimeDisplay	String
ApprovalStatusName	String
ApprovalStatusColor	String
BackOutPlanDescription	String
BackOutPlanUpdatedByName	String
BusinessImpactAssessment	String
CabApprovalStatus	String
CabMeetingDateDisplay	String
ChangeManagerCostPerHour	Decimal
ChangeManagerEmail	String
ChangeManagerMobile	String
ChangeManagerName	String
ChangeManagerPhone	String
ChangeManagerPhotoURL	String
ChangeManagerSmsMailId	String
ChangeOwnerCostPerHour	Decimal
ChangeOwnerEmail	String
ChangeOwnerMobile	String
ChangeOwnerName	String
ChangeOwnerPhone	String
ChangeOwnerPhotoURL	String
ChangeOwnerSmsMailId	String
ChangeRequesterEmail	String
ChangeRequesterMobile	String
ChangeRequesterName	String
ChangeRequesterPhone	String
ChangeRequesterPhotoURL	String
ChangeTypeColor	String
ChecklistDescription	String
ChecklistCompletedCount	Integer
ChecklistStatus	String
ChecklistTotalCount	Integer
ChildChangeCount	Integer
CloseDetailsDescription	String
ClosedTimeDisplay	String
CloseDetailsClosureCodeName	String
ClosureComments	String
Comment	String
CommentHistory	String
CommunicationPlanDescription	String
CommunicationPlanUpdatedByName	String
CompletedTimeDisplay	String
ConfigurationItems	String
CreatedTimeDisplay	String
CurrentApprovalLevel	Integer
Description	String
DisplayIdDisplayValue	String
DisplayIdValue	String
IsChangeManagerSmsNotifyEnabled	Boolean
IsChangeOwnerSmsNotifyEnabled	Boolean
IsChangeRequesterSmsNotifyEnabled	Boolean
DueByTimeDisplay	String
EstimatedCost	Decimal
EstimatedDowntime	Integer
EstimatedHours	Long
GroupName	String
HasChildChanges	Boolean
ImpactName	String
ImpactDetails	String
ImplementationNotes	String
IsCabApprovalRequired	Boolean
IsChangeManagerTechnician	Boolean
IsChangeManagerVipUser	Boolean
IsChangeOwnerTechnician	Boolean
IsChangeOwnerVipUser	Boolean
IsChangeRequesterTechnician	Boolean
IsChangeRequesterVipUser	Boolean
IsChangeTypePreApproved	Boolean
IsDowntimeRequired	Boolean
IsEmergency	Boolean
IsMinor	Boolean
IsOverdue	Boolean
IsRetrospective	Boolean
ItemName	String
LastUpdatedTimeDisplay	String
LessonsLearned	String
NextReviewOnDisplay	String
ParentChangeDisplayId	String
ParentChangeTitle	String
ReasonForChangeName	String
RelatedIncidentCount	Integer
RelatedProblemCount	Integer
RelatedServiceRequestCount	Integer
ReleaseDetailsDescription	String
ReleaseDetailsUpdatedByEmail	String
ReleaseDetailsUpdatedByName	String
ReleaseDetailsUpdatedByCostPerHour	Decimal
ReleaseDetailsUpdatedBySmsMailId	String
ReleaseDetailsUpdatedOnDisplay	String
ReleaseResults	String
ReleasesDisplayIdDisplayValue	String
ReleasesDisplayIdValue	String
ReleasesTitle	String
ReleaseStatus	String
IsApprovalRequired	Boolean
IsCabRequired	Boolean
ReviewDetailsDescription	String
ReviewResults	String
ReviewStatus	String
RiskName	String
RollbackReason	String
Roles	String
RollOutPlanDescription	String
RollOutPlanUpdatedByName	String
ScheduledEndTimeDisplay	String
ScheduledStartTimeDisplay	String
Services	String
IsPreTemplateTasksDeletionEnabled	Boolean
SiteName	String
StageIndex	Long
StageInternalName	String
StatusInternalName	String
SubcategoryName	String
SuccessMetrics	String
Tasks	String
TechnicalImpactAssessment	String
TestPlanDescription	String
TestPlanUpdatedByName	String
TimeElapsed	Long
TotalApprovalLevels	Integer
UdfFields	String
MaintenanceId	Long
IsFreezeConflicted	Boolean
HasReleaseAssociation	Boolean
IsFreezed	Boolean
IsTemplateInactive	Boolean
TemplateId	Long
TemplateName	String
IsTemplatePlanningNeededInSubmission	Boolean
WorkflowId	Long
WorkflowName	String
WorkflowType	String
IsWorkflowInactive	Boolean
IsWorkflowValidated	Boolean
IsWorkflowGuidedPath	Boolean
HasWorkflowTransitions	Boolean
WorkflowAllowedStagesConfig	String
WorkflowSubModuleDetails	String
WorkflowInstanceActiveTransition	String
IsWorkflowInstanceForkExecutionFailed	Boolean
UrgencyName	String
UserImpactAssessment	String
IsRollbackExecuted	Boolean
WorkflowInstanceStatusName	String
Worklogs	String
EntityInstanceProperties	String
Attachments	String
Assets	String