The Common Knowledge document is an XML schema that contains default fields for mapping change request form values from one system to another. The common knowledge format mirrors what one would see in an ITIL view of the Change Knowledge form with related lists expressed in embedded XML form.
Sample Common Knowledge
A sample Common Knowledge looks like this:
<common_knowledge>
<active/>
<affected_products>
<kb_name/>
</affected_products>
<approvers>
<approver/>
<approver_email/>
<approver_name/>
<assignment_group/>
<assignment_group_name/>
<comments/>
<state/>
</approvers>
<article_type/>
<author/>
<cannot_read_user_criteria/>
<can_read_user_criteria/>
<category/>
<cmdb_ci/>
<description/>
<direct/>
<disable_commenting/>
<disable_suggesting/>
<display_attachments/>
<flagged/>
<image/>
<kb_category/>
<kb_knowledge_base/>
<knowledge_feedbacks>
<article/>
<comments/>
<flagged/>
<live_message/>
<parent_feedback/>
<query/>
<rating/>
<resolved/>
<root_feedback/>
<search_id/>
<session_id/>
<useful/>
<user/>
<view_id/>
<work_notes/>
</knowledge_feedbacks>
<meta/>
<number>
<published>
<rating/>
<retired/>
<roles/>
<short_description>
<source/>
<sys_created_by>
<sys_created_on>
<sys_domain>
<sys_updated_by>
<sys_updated_on>
<sys_view_count>
<text>
<topic>
<use_count>
<valid_to>
<wiki/>
<workflow_state>
</common_knowledge>
Embedded Records
Embedded records are fields in the Common Knowledge document that cannot be mapped by singular values. Instead, they are entirely different records included inside the Common Knowledge document to be created on the subscribing system.
NOTE: Deactivate each of the transform scripts in PSP Common Knowledge to Knowledge if you choose not to parse these embedded objects into records. If you need to extend or add additional capabilities, instead of modifying the existing scripts, add new ones so that upgrades are possible.
The following are examples of the embedded records in Common Knowledge:
Knowledge Related to Products Embedded Record
The affected_product field in the Common Knowledge is an embedded record that, when populated, will create a new knowledge on the system receiving the Common Knowledge.
| Table Map Source Field | Definition |
|---|---|
| kb_name | Name of the Knowledge Base record |
Approval Embedded Record
The approver field in the Common Knowledge is an embedded record that, when populated, will create a new knowledge on the system receiving the Common Knowledge.
| Table Map Source Field | Definition |
|---|---|
approver | Unique record identifier of the Approver record |
| approver_email | Email of the Approver |
| approver_name | Name of the Approver |
| assignment_group | Unique record identifier of the Assignment Group record |
| assignment_group_name | Name of the Assignment Group |
| comments | Comments of the Approver |
| state | State of the approval record |
Knowledge Feedback Embedded Record
The kb_feedback field in the Common Knowledge is an embedded record that, when populated, will create a new knowledge on the system receiving the Common Knowledge.
| Table Map Source Field | Definition |
|---|---|
| article | Unique record identifier of the Knowledge record |
| comments | Comments in the Knowledge Feedback record |
| flagged | True / False statement if record is Knowledge Feedback flagged |
| live_message | Unique record identifier of the Live Feed Message record |
| parent_feedback | Unique record identifier of the Knowledge Feedback record |
| query | Represents encoded query |
| rating | Number of the rating of the Knowledge Feedback record |
| resolved | States if the knowledge feedback is resolved |
| root_feedback | Unique record identifier of the Live Feed Message record |
| search_id | Unique record identifier of the Knowledge Searches record |
| session_id | ID representation of the session record |
| useful | True / False statement if record is useful |
| user | Unique record identifier of the User record |
view_id | ID representation of the view record |
| work_notes | Journal notes in the Knowledge Feedback record |
Table Maps
The Perspectium Common Knowledge Helium update set will contain the following:
Outbound Table Maps
| Name | Type | Source Table | Description |
|---|---|---|---|
| Knowledge to Common Knowledge | common_knowledge | Knowledge [knowledge] | Main body of the common_knowledge format |
| Affected Products | embedded_affected_product | Knowledge Related To Products [m2m_kb_ci] | Map for building embedded affected products in common_knowledge |
| Approvers | embedded_approver | Approval [sysapproval_approver] | Map for building embedded approvers in common_knowledge |
| Knowledge Feedback | embedded_knowledge_feedback | Knowledge Feedback [kb_feedback] | Map for building knowledge feedback in common_knowledge |
Inbound Table Maps
Name | Type | Target Table | Description |
|---|---|---|---|
| Common Knowledge to PSP Common Knowledge | common_knowledge | PSP Common Knowledge (u_psp_common_knowledge) | Main body of the common_knowledge format |
Import Set
Name | Description |
|---|---|
| PSP Common Knowledge to Knowledge (u_psp_common_knowledge) | Transforms the common_knowledge format to knowledge. |