Common Change

The Common Change document is an XML schema that contains default fields for mapping change request form values from one system to another. The common change format mirrors what one would see in an ITIL view of the Change Request form with related lists expressed in embedded XML form.

A sample Common Change looks like this:

<common_change>
   <affected_cis>
      <affected_ci>
         <ci_class />
         <ci_name />
         <ci_id />
      </affected_ci>
   </affected_cis>
   <approval />
   <approvers>
      <approver>
         <created />
         <approver_name />
         <assignment_group_name/>
         <approver />
         <state />
         <comments/>
         <approver_email />
         <assignment_group/>
      </approver>
   </approvers>
   <assigned_to />
   <assignment_group />
   <attachments>
      <attachment>
         <data />
         <size_bytes />
         <file_name />
         <sys_id />
         <content_type />
      </attachment>
   </attachments>
   <backout_plan />
   <category />
   <change_tasks>
      <change_task>
         <assignment_group />
         <short_description />
         <correlation_id />
         <number />
         <work_notes />
         <comments />
         <correlation_display />
         <change_task_type />
         <assigned_to />
         <state />
         <description />
         <cmdb_ci />
      </change_task>
   </change_tasks>
   <close_code />
   <close_notes />
   <cmdb_ci />
   <comments />
   <correlation_display />
   <correlation_id />
   <description />
   <end_date />
   <impact />
   <impacted_services>
      <impacted_service>
         <operational_status />
         <type />
         <location_name />
         <id />
         <manually_added />
         <name />
      </impacted_service>
   </impacted_services>
   <implementation_plan />
   <incidents_caused>
      <incident>
         <number />
         <opened_at />
         <category />
         <caller_id_name />
         <assigned_to_name />
         <short_description />
         <priority />
         <id />
         <state />
         <assignment_group_name />
      </incident>
   </incidents_caused>
   <incidents_fixed>
      <incident>
         <number />
         <opened_at />
         <category />
         <caller_id_name />
         <assigned_to_name />
         <short_description />
         <priority />
         <id />
         <state />
         <assignment_group_name />
      </incident>
   </incidents_fixed>
   <justification />
   <number />
   <priority />
   <problems>
      <problem>
         <short_description />
         <assignment_group_name />
         <id />
         <assigned_to_name />
         <state />
         <number />
      </problem>
   </problems>
   <provider />
   <psp_action />
   <requested_by />
   <requested_by_date />
   <risk />
   <short_description />
   <start_date />
   <state />
   <test_plan />
   <type />
   <work_notes />
</common_change>

Embedded records

Embedded records are fields in the Common Change document that cannot be mapped by singular values. Instead, they are entirely different records included inside the Common Change document to be created on the subscribing system.

The following are examples of the embedded records in Common Change:

Configuration Item's Affected Embedded Record

The CI affected field in the Common Change is an embedded record that, when populated, will create a new CI affected on the system receiving the Common Change.

Table Map Source Field	Definition
ci_class	Class name of the configuration item
ci_name	Name of the configuration item
ci_id	Unique record identifier of the configuration item

Approver Embedded Record

The approver field in the Common Change is an embedded record that, when populated, will create a new approver on the system receiving the Common Change.

Table Map Source Field	Definition
created	Date the record was created on
approver_name	Name of the approver
assignment_group_name	Name of the assignment group
approver	Unique record identifier of the approver record
comments	Comments of the approver
approver_email	Email of the approver
assignment_group	Unique record identifier of the assignment group record

Attachment Embedded Record

The attachment field in the Common Change is an embedded record that, when populated, will create a new attachment on the system receiving the Common Change.

Table Map Source Field	Definition
data	Attachment data in an encoded string format
size_bytes	Measurement of how much the attachment data contains
file_name	Name of the attached file
sys_id	Unique record identifier of the attachment
content_type	Attachments content type (i.e jpeg, png, txt, etc.)

Change Task Embedded Record

The change task field in the Common Change is an embedded record that, when populated, will create a new change task on the system receiving the Common Change.

Table Map Source Field	Definition
assignment_group	Unique record identifier of the assignment group record
short_description	Short description of the change task
correlation_id	Unique record identifier of the correlating change task
number	Record number of change task
work_notes	Work notes for the change task
comments	Comments for the change task
correlation_display	Unique record display of the correlating change task
change_task_type	Change task category
assigned_to	User the change task is assigned to
state	State of the change task
description	Description of the change task
cmbd_ci	Unique record identifier of the parent record

Impacted Service Embedded Record

The impacted service field in the Common Change is an embedded record that, when populated, will create a new impacted service on the system receiving the Common Change.

Table Map Source Field	Definition
operational_status	Status of the impacted service
type	Class type of the impacted service
location_name	Location of the impacted service
id	Unique record identifier of the impacted service
manually_added	Represents if the impacted service is added manually
name	Name of the impacted service

The Perspectium Common Change Helium update set will contain the following:

Outbound Table Maps

Name	Type	Source table	Description
Change to Common Change	common_change	Change Request [change_request]	Main body of the common_change format
psp_attachment	embedded_attachment	sys_attachment	Map for building embedded attachments field in common_change
psp_affected_ci	embedded_affected_ci	CIs Affected [task_ci]	Map for building embedded affected CI in common_change
psp_change_task	embedded_change_task	Change Task [change_task]	Map for building embedded change_tasks in common_change
psp_problem	embedded_problem	Problem [problem]	Map for building embedded problem records in common_change
psp_impacted_service	embedded_impacted_service	Impacted CIs [task_cmdb_ci_service]	Map for building affected CI/service to common_change
psp_incident	embedded_incident	Incident [incident]	Map for building incidents fixed and caused by embedded incidents for common_change
psp_approvers	embedded_approvers	Approval [sysapproval_approvers]	Map for building embedded approvers

Inbound Table Maps

Name	Type	Target Table	Description
Common Change to PSP Common Change	common_change	PSP Common Change (u_psp_common_change)	Main body of the common_attachment format

Import Set

Name	Description
PSP Common Change to Change Request (u_psp_common_chane)	Transforms the common_change format to change.

Content

Space Tools