Knowledge Management Tables
This article contains the following topics:
casm171
This article contains the following topics:
CI_ACTIONS Table
Program control table used by Knowledge Management.
- SQL Name-- CI_ACTIONS
- Object-- CI_ACTIONS
Field
| Data Type
| Reference
| Remarks
|
ACTION_ORDER | INTEGER | ||
ACTION_TITLE | STRING 100 | ||
ANALYST_ID | UUID | ca_contact::uuid | |
GROUP_ID | UUID | ca_contact::uuid | |
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
PREDEFINED | INTEGER | ||
STATUS_CURRENT_ID | INTEGER | CI_STATUSES::id | |
UNPUBLISH | INTEGER | ||
UNRETIRE | INTEGER | ||
WF_TEMPLATE_ID | INTEGER | CI_WF_TEMPLATES ::id |
CI_ACTIONS_ALTERNATE Table
Program control table used by Knowledge Management.
- SQL Name-- CI_ACTIONS_ALTERNATE
- Object-- CI_ACTIONS_ALTERNATE
Field
| Data Type
| Reference
| Remarks
|
ACTION_ID | INTEGER | CI_ACTIONS::id | |
CONTACT_ID | UUID | ca_contact::uuid | |
CONTACT_TYPE | INTEGER | ||
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. |
CI_BOOKMARKS Table
Program control table used by Knowledge Management.
- SQL Name-- CI_BOOKMARKS
- Object-- CI_BOOKMARKS
Field
| Data Type
| Reference
| Remarks
|
BOOKMARK_ TITLE | STRING 100 | ||
DOCUMENT_ID | INTEGER | SKELETONS::id | |
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
USER_ID | UUID | ca_contact::uuid |
CI_DOC_LINKS Table
Program control table used by Knowledge Management.
- SQL Name-- CI_DOC_LINKS
- Object-- CI_DOC_LINKS
Field
| Data Type
| Reference
| Remarks
|
DOC_ID1 | INTEGER | SKELETONS::id | Specifies the parent ID. |
DOC_ID2 | INTEGER | SKELETONS::id | Specifies the child ID. |
id | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
last_mod_by | UUID | ca_contact | Specifies the UUID of the contact who last modified this record. |
last_mod_dt | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
parent_child | INTEGER | Indicates the document has one of the following relationships with another document: 0 -- See also link1 -- Parent Child Link | |
tenant | UUID | ca_tenant | Specifies the UUID of the tenant. |
CI_DOC_TEMPLATES Table
Program control table used by Knowledge Management.
- SQL Name-- CI_DOC_TEMPLATES
- Object-- CI_DOC_TEMPLATES
Field
| Data Type
| Remarks
|
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID |
IS_DEFAULT | INTEGER | |
IS_PREDEFINED | INTEGER | |
KD ID | Long | Knowledge Document id that is used as a template for default values. |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. |
PAGE_HTML | STRING 32768 | |
TEMPLATE_NAME | STRING 255 |
CI_DOC_TYPES Table
Program control table used by Knowledge Management.
- SQL Name-- CI_DOC_TYPES
- Object-- CI_DOC_TYPES
Field
| Data Type
| Reference
| Remarks
|
DOC_TYPE_TXT | STRING 50 | ||
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. |
CI_PRIORITIES Table
Program control table used by Knowledge Management.
- SQL Name-- CI_PRIORITIES
- Object-- CI_PRIORITIES
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
PRIORITY | STRING 50 |
CI_STATUSES Table
Program control table used by Knowledge Management.
- SQL Name-- CI_STATUSES
- Object-- CI_STATUSES
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
PREDEFINED | INTEGER | ||
STATUS | STRING 50 | ||
STATUS_ DESCRIPTION | STRING 255 | ||
STATUS_ORDER | INTEGER |
CI_WF_TEMPLATES Table
Program control table used by Knowledge Management.
- SQL Name-- CI_WF_TEMPLATES
- Object-- CI_WF_TEMPLATES
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
IS_DEFAULT | INTEGER | ||
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
WF_DESCRIPTION | STRING 255 | ||
WF_NAME | STRING 255 |
Doc_Versions Table
Program control table used by CA SDM Knowledge Management.
- SQL Name-- DOC_VERSIONS
- Object-- DOC_VERSIONS
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER | Specifies the primary key. | |
doc_ID | INTEGER | skeletons::id | Specifies the SREL to the knowledge document object. |
ver_count | INTEGER | Specifies the internal version ID that indicates the number of versions created (1, 2, 3, 4...) | |
ver_comment | STRING (2000) | Specifies the comment text. | |
start_date | DATE | Specifies the date when this version started. | |
end_date | DATE | Specifies the date when this version ended. | |
started_by | UUID | Specifies the user that created this version. | |
published_by | UUID | Specifies the user that published this version. | |
status_ID | INTEGER | Specifies the document version status. | |
ver_status | INTEGER | Specifies the previous version's status: 0 -- Existed 1 -- Archived2 -- Deleted (this only relates to the resolution field) | |
title | STRING | Specifies the document version title. | |
summary | STRING | Specifies the document summary text. | |
problem | STRING | Specifies the problem description. | |
notes | STRING | Specifies the document notes. | |
doc_type_ID | INTEGER | Specifies the document type. | |
ext_doc_ID | INTEGER | Specifies the Tree ID when Decision Tree is used. | |
last_mod_by | Byte(16) | ca_contact::uuid | Specifies the UUID of the contact who last modified this record. |
last_mod_dt | INTEGER | Indicates the timestamp of when this record was last modified. |
EBR_ACRONYMS Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_ACRONYMS
- Object-- EBR_ACRONYMS
Field
| Data Type
| Reference
| Remarks
|
ACRONYM | STRING 50 | ||
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. |
EBR_KEYWORDS Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_KEYWORDS
- Object-- EBR_KEYWORDS
Field
| Data Type
| Reference
| Remarks
|
ENTITY_ID | INTEGER | ||
EXT_TABLE_ID | INTEGER | ||
FULL_WORD | STRING 50 | ||
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID |
EBR_LOG Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_LOG
- Object-- EBR_LOG
Field
| Data Type
| Reference
| Remarks
|
ASKED_DATE | LOCAL_TIME | ||
BEST_IDS | STRING 110 | ||
EXTERNAL_ID | STRING 50 | ||
FILTER_DATA | STRING 32768 | ||
FUZZINESS | INTEGER | ||
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
KEYWORDS | STRING 32768 | ||
MATCH_TYPE | INTEGER | ||
METHOD_ PERFORMANCE | INTEGER | ||
METHOD_TYPE | INTEGER | ||
NUM_MATCHES | INTEGER | ||
ORDER_DIRECTION | INTEGER | ||
PRIMARY_ORDER | STRING 50 | ||
ROWS_FOUND | INTEGER | ||
ROWS_TO_FETCH | INTEGER | ||
SEARCH_IN | INTEGER | ||
SEARCH_QUALITY | INTEGER | ||
SEARCH_TEXT | STRING 255 | ||
SEARCH_TYPE | INTEGER | ||
SECONDARY_ORDER | INTEGER | ||
SESSION_ID | INTEGER | ||
SQL_TEXT | STRING 32768 | ||
TOP_MATCH_ID | INTEGER | ||
UNIQUE_WORD_COUNT | INTEGER | ||
USER_ID | STRING 100 | ||
WORD_COUNT | INTEGER |
EBR_METRICS Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_METRICS
- Object-- EBR_METRICS
Field
| Data Type
| Reference
| Remarks
|
COMMENTS | STRING 255 | ||
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
METRIC | STRING 50 | ||
WEIGHT | REAL |
EBR_NOISE_WORDS Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_NOISE_WORDS
- Object-- EBR_NOISE_WORDS
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
NOISE_WORD | STRING 50 |
EBR_PATTERNS Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_PATTERNS
- Object-- EBR_PATTERNS
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
PATTERN_DEFAULT | STRING 255 | ||
PATTERN_NAME | STRING 50 | ||
PATTERN_VALUE | STRING 255 | ||
PATTERN_VALUE_ADM | STRING 255 |
EBR_PREFIXES Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_PREFIXES
- Object-- EBR_PREFIXES
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
PREFIX | STRING 50 | ||
EBR_PROPERTIES Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_PROPERTIES
- Object-- EBR_PROPERTIES
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
PROPERTY_ADMIN | INTEGER | ||
PROPERTY_DEFAULT | STRING 50 | ||
PROPERTY_NAME | STRING 50 S_KEY | ||
PROPERTY_TYPE | STRING 50 | ||
PROPERTY_VALUE | STRING 32768 | ||
PROPERTY_VALUE_ADM | STRING 32768 |
EBR_SUBSTITS Table
Program control table used by Knowledge Management.
- SQL Name-- EBR_SUBSTITS
- Object-- EBR_SUBSTITS
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
SYMBOL1 | STRING 50 | ||
SYMBOL2 | STRING 50 |
ES_CONSTANTS Table
Program control table used by Knowledge Management.
- SQL Name-- ES_CONSTANTS
- Object-- ES_CONSTANTS
Field
| Data Type
| Reference
| Remarks
|
COMMENTS | STRING 255 | ||
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
NAME | STRING 50 | Specifies the text name of this item. | |
PROPERTYID | INTEGER | ||
PROPVALUE | INTEGER |
ES_NODES Table
Program control table used by CA SDM Knowledge Management.
- SQL Name-- ES_NODES
- Object-- ES_NODES
Field
| Data Type
| Reference
| Remarks
|
DISPLAYED_ TEXT | STRING 32768 | ||
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_ DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
LINK_ID | INTEGER | ES_NODES::id | |
NODE_ID | INTEGER | ||
NODE_SHORT_DESC | STRING 150 | ||
NODE_TYPE | INTEGER | ||
PARENT_ NODE_ID | INTEGER | ||
QUERY_RESP_NUMBER | INTEGER | ||
QUERY_RESP_TYPE | STRING 50 | ||
RESPLINKID1 | INTEGER | ||
RESPLINKID2 | INTEGER | ||
RESPLINKID3 | INTEGER | ||
RESPLINKID4 | INTEGER | ||
RESPLINKID5 | INTEGER | ||
RESPLINKID6 | INTEGER | ||
RESPLINKID7 | INTEGER | ||
RESPONSE1 | STRING 100 | ||
RESPONSE2 | STRING 100 | ||
RESPONSE3 | STRING 100 | ||
RESPONSE4 | STRING 100 | ||
RESPONSE5 | STRING 100 | ||
RESPONSE6 | STRING 100 | ||
RESPONSE7 | STRING 100 | ||
ROOT_ID | INTEGER | ES_NODES::id | |
TREE_ID | INTEGER | SKELETONS::id |
ES_RESPONSES Table
Program control table used by Knowledge Management.
- SQL Name-- ES_RESPONSES
- Object-- ES_RESPONSES
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_ DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
PARENT_ NODE_ID | INTEGER | ES_NODES::id | |
RESPONSE_ LINK_ID | INTEGER | ES_NODES::id | |
RESPONSE_ LINK_ORDER | INTEGER | ||
RESPONSE_ LINK_TEXT | STRING 100 |
ES_SESSIONS Table
Program control table used by Knowledge Management.
- SQL Name-- ES_SESSIONS
- Object-- ES_SESSIONS
Field
| Data Type
| Reference
| Remarks
|
COMMENT_TEXT | STRING 50 | ||
EVALUATION | INTEGER | ||
EXTERNAL_ID | STRING 50 | ||
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
PATH_IDS | STRING 50 | ||
PATH_QAS | STRING 32768 | ||
SESSION_ID | INTEGER | ||
TREE_ID | INTEGER | ES_NODES::id |
Index_Doc_Links Table
Program control table used by Knowledge Management.
- SQL Name-- index_doc_links
- Object-- index_doc_links
Field
| Data Type
| Reference
| Remarks
|
DOC_ID | INTEGER | SKELETONS::id | |
ID | INTEGER NOT_NULL KEY | Unique (to the table) Numeric ID | |
INDEX_ID | INTEGER | O_INDEXES::id | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
RELATIONAL_ID | STRING 255 |
KD_Atmnt Table
Program control table used by Knowledge Management.
- SQL Name-- kd_attmnt
- Object-- kd_attmn
Field
| Data Type
| Reference
| Remarks
|
ATTMNT_ID | INTEGER | Attachment::id | |
DOC_ID | INTEGER | SKELETONS::id | |
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
RES_ID | Long | If there is an embedded image, the RES_ID points to the resource file id in the attmnt table. |
Knowledge_Keywords Table
Knowledge Base key words for associating trouble codes and call areas to solutions.
- SQL Name-- km_kword
- Object-- kwrd
Field
| Data Type
| Reference
| Remarks
|
id | INTEGER UNIQUE NOT_NULL KEY | Unique (to the table) Numeric ID | |
last_mod_dt | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
persid | STRING 30 | Persistent ID (SystemObjectName:id) | |
sym | STRING 30 NOT_NULL S_KEY | keyword |
kdlinks Table
Each record indicates a link between a KD and request or issues link_type field represented by the following enum value:
1 = KD is a solution to the ticket
2 = Ticket created is based on the document last_mod_by the person that links the document and the ticket
- SQL Name-- kdlinks
- Object-- kdlinks
Field
| Data Type
| Reference
| Remarks
|
cr | STRING 30 | Call_Req::persid | |
ID | INTEGER KEY | Specifies the Numeric ID that is unique to this table. | |
iss | STRING 30 | Issue | |
kd | INTEGER | SKELETONS::id | |
last_mod_by | UUID | ca_contact::uuid | Specifies the UUID of the contact who last modified this record. |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp for when this record was last modified. | |
link_type | INTEGER | ||
sd_obj_id | INTEGER | ||
sd_obj_type | STRING 5 |
KEIT_TEMPLATES Table
Field Name
| Type
| Index
| Comment
|
ID | Int | Primary Key | |
TEMPLATE_NAME | Text (50) | ||
EXP_SUB_CAT | int | Indicates a flag to export sub categories: 0 -- No1 -- Yes | |
EXP_SEC_CAT | int | Indicates a flag to export secondary categories 0 -- No1 -- Yes | |
EXP_ALL_DOCS | int | Indicates a flag to export all documents linked to the selected category 0 -- No1 -- Yes | |
EXP_FILTER | Text (2048) | Additional Filter for export | |
EXP_ATTMNT | int | Indicates a flag to export attachments 0 -- No1 -- Yes | |
EXP_INDEX_DOC | int | Indicates a flag to Index documents after import 0 -- No1 -- Yes | |
OVERRIDE_PUB | int | Indicates a flag to override published documents 0 -- No1 -- Yes | |
OVERRIDE_UNPUB | Indicates a flag to override unpublished documents 0 -- No1 -- Yes | ||
OVERRIDE_DEFAULTS | Use the default values when overriding documents | ||
ERR_THRESHOLD | int | Error threshold for stopping the process | |
FIELD_LIST | Text | List of fields to export | |
CAT_LIST | Text | List of categories to export | |
DEFAULT_LIST | Text | List of fields, their types and values used as defaults on import | |
STATUS_ID and following fields | Used internally to fulfill the DEFAULT_LIST field | ||
last_mod_by | UUID | ||
last_mod_dt | Long |
KT_act_content Table
The kt_act_content table is used for action content links.
Field
| Data Type
| Remarks
|
Id | Long | id |
Name | String | Name of the action content. |
Code | String (10) | Action content code - Rel_attr |
Description | String | Description of the action content |
URL | String | URL of the action content |
HTMPL | String | Parameters for the HTMPL URL |
KT_Blc Table
Program control table used by Knowledge Management to store the best link conditions data for the Recommended Documents feature.
- SQL Name-- kt_blc
- Object-- kt_blc
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER | Primary key. | |
KD | INTEGER | SREL to the knowledge document object. | |
Kcat | INTEGER | SREL to knowledge category for recommended document condition type of 4. | |
BLC_Type | INTEGER | SREL to recommended document condition type. | |
BLC_Text | STRING 255 | The recommended document condition term. | |
Author_ID | UUID | SREL to cnt | |
Del | INTEGER | Active_Boolean _Table::enum | Specifies the status of the Deleted flag: 0 -- Active1 -- Inactive/marked as deleted |
Last_mod_dt | DATE | Shows the date of when this record was last updated. |
KT_Blc_Type Table
Program control table that is used by Knowledge Management to store the Best Link Condition types for the Recommended Documents feature.
- SQL Name-- kt_blc_type
- Object-- kt_blc_type
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER | Primary key. | |
SYM | STRING 50 | 1 -- Full Match2 -- Exact Match3 -- Keyword List4 -- Knowledge Category | |
BLC_Condition | STRING 255 | Category path if BLC type is category; otherwise, BLC text is used. | |
Last_mod_dt | DATE | Shows the date of when this record was last updated. |
KT_Flg_Status Table
Identifies the different flag statuses used by the Automated Policies feature.
- SQL Name-- kt_flg_status
- Object-- kt_flg_status
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER | Identifies the unique (to the table) numeric ID. | |
sym | STRING (50) | Flag type name. |
KT_Flg_Type Table
Identifies the different flags types that are used by the Automated Policies feature to flag documents for correction.
- SQL Name-- kt_flg_type
- Object-- kt_flg_type
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER | Identifies the unique (to the table) numeric ID. | |
sym | STRING (50) | Flag type name. | |
description | STRING (2000) | Flag type description. | |
init_by_users | INTEGER (1/0) | Specifies the flag type users select in the end user interface. | |
show_as_comment | INTEGER (1/0) | Displays the flag type as a comment when document is open for viewing. | |
follow_up | INTEGER (1/0) | Raises follow-up mechanism for the flag type. | |
time_to_complete | INTEGER | Specifies the time from which the argument is completed. | |
dev_assignee | UUID | For future use. | |
del | INTEGER | Specifies if the flag type is active or inactive. | |
last_mod_by | UUID | SREL to the Contacts table. | Displays the last date of when a user modified the record. |
last_mod_dt | Long (date) | Displays the last modified date. |
KT_Life_Cycle_Rep Table
Identifies the knowledge document lifecycle data for the Automated Policies feature in Knowledge Management.
- SQL Name-- KT_Life_Cycle_Rep
- Object-- KT_Life_Cycle_Rep
Field
| Data Type
| Reference
| Remarks
|
ID | Long | Primary index. | Identifies the unique (to the table) numeric ID of the primary index. |
policy | Long | Required field. SREL to query_policy. | Identifies the Policy ID. |
kd | Long | Required field. SREL to the knowledge document (Skeletons table). | Identifies the Document ID. |
last_mod_dt | Long (date) | Displays the last modified date. |
KT_REPORT_CARD Table
Program control table used by Knowledge Management.
- SQL Name-- kt_report_card
- Object-- kt_report_card
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER | KEY Unique (to the table) Numeric ID | |
SUBJECT_ID | nvarchar(64) | ||
PAST_DAYS | INTEGER | ||
ORG_STATISTICS | INTEGER | ||
DOCUMENTS_ SUBMITTED | INTEGER | ||
DOCUMENTS_ PUBLISHED | INTEGER | ||
TOTAL_HITS | INTEGER | ||
AVERAGE_ EFFECTIVENESS_ RATING | INTEGER | ||
TOTAL_SOLUTION_ COUNT | INTEGER | ||
USER_SLV_CNT | INTEGER | ||
TOTAL_VOTES | INTEGER | ||
AVG_RATING | REAL | ||
LINKED_ KNOWLEDGE_BY_ OTHERS | INTEGER | ||
LINKED_ KNOWLEDGE_BY_ME | INTEGER | ||
CLOSED_TICKETS | INTEGER | ||
TICKETS_WITH KNOWLEDGE | INTEGER | ||
TICKETS_HAD_ SEARCH_ ACTIVITES | INTEGER | ||
KNOWLEDGE_ SUBMIT_FROM_ TICKET | INTEGER | ||
TIME_TO_PUBLISH | INTEGER | ||
MY_COMMENTS | INTEGER | ||
DOCUMENTS_ RETIRED | INTEGER | ||
TIME_TO_FIX | INTEGER | ||
FLAGS_FIXED | INTEGER | ||
COMMENTS_ON_ MY_DOCUMENTS | INTEGER | ||
FIRST_CALL_RES_ WITH_KNOW | INTEGER | ||
FIRST_CALL_RES_ WITHOUT_KNOW | INTEGER | ||
creation_user | nvarchar(64) | Specifies the name of the person who created this record. Should be in form: LastName, FirstName | |
creation_date | INTEGER | Indicates the timestamp indicating when this record was created | |
last_update_user | nvarchar(64) | Specifies the contact who last modified this record. Should be in form: LastName, FirstName | |
last_update_date | INTEGER | Indicates the timestamp of when this record was last modified | |
CONTRIBUTOR_ UUID | SREL | cnt | TENANCY_ UNRESTRICTED |
IS_SUPERVISOR | INTEGER | ||
SUPERVISOR_ UUID | SREL | cnt | TENANCY_ UNRESTRICTED |
MY_ORG_REF_ID | SREL | KT_REPORT_ CARD | |
ALL_ORG_REF_ID | SREL | KT_REPORT_ CARD | |
PAST_DAYS_TEXT | nvarchar(20) | Populates from the resource file. | |
LAST_MOD_DT_ TEXT | nvarchar(50) | Specifies the KRC calculation date. | |
DOCUMENTS_ PUBLISHED_ PERCENT | nvarchar(4) | ||
AVG_HITS | nvarchar(20) | ||
AVG_RATING_ TEXT | nvarchar(100) | ||
last_mod_by | SREL | cnt | |
last_mod_dt | DATE |
O_INDEXES Table
Program control table used by Knowledge Management.
- SQL Name-- O_INDEXES
- Object-- KCAT
Field
| Data Type
| Reference
| Remarks
|
DESCRIPTION | STRING 255 | Textual description | |
AUTHOR_ID | UUID | ca_contact::uuid | |
CAPTION | STRING 50 | ||
CR_CAT | STRING 30 | Prob_Category | |
DOC_TEMPLATE | INTEGER | CI_DOC_ TEMPLATES::id | |
HAS_CHILDREN | INTEGER | ||
HAS_DOCS | INTEGER | ||
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
iSS_CAT | STRING 30 | Issue_Category | |
KEYWORDS | STRING 255 | ||
LAST_MOD_BY | UUID | ca_contact | Specifies the UUID of the contact who last modified this record. |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified | |
OWNER_ID | UUID | ca_contact::uuid | |
PARENT_ID | SREL | O_INDEXES::id | |
PERMISSION_INDEX_ ID | INTEGER | O_INDEXES::id | |
READ_PGROUP | INTEGER | P_GROUPS::id | |
RELATIONAL_ID | STRING 255 | ||
SUBJECT_EXPERT_ ID | UUID | ca_contact::uuid | |
WF_TEMPLATE | INTEGER | CI_WF_ TEMPLATES::id | |
WRITE_PGROUP | INTEGER | P_GROUPS::id |
SKELETONS Table
Program control table used by CA SDM Knowledge Management.
- SQL Name-- SKELETONS
- Object-- KD
Field
| Data Type
| Reference
| Remarks
|
Active_state | INTEGER | ||
Active_state_date | LOCAL_TIME | ||
assignee_ID | UUID | ca_contact::uuid | |
author_ID | UUID | ca_contact::uuid | |
bu_result | REAL | ||
created_via | INTEGER | ||
creation_date | LOCAL_TIME | Indicates the timestamp when this record was created. | |
current_action_ID | INTEGER | ci_actions::id | |
custom1 | STRING 50 | ||
custom2 | STRING 50 | ||
custom3 | STRING 50 | ||
custom4 | STRING 255 | ||
custom5 | STRING 255 | ||
custom_num1 | REAL | ||
custom_num2 | REAL | ||
doc_template_ID | INTEGER | ci_doc_templates ::id | |
doc_type_ID | INTEGER | ci_doc_types::id | |
doc_version | STRING 50 | ||
expiration_date | LOCAL_TIME | ||
expire_notification_sent | INTEGER | ||
ext_doc_ID | INTEGER | ||
flg_cnt | INTEGER | Number of open flags in the KD. | |
fullwords | STRING 32768 | ||
hits | INTEGER | ||
ID | INTEGER KEY | Identifies the unique (to the table) numeric ID. | |
indexed | INTEGER | ||
inherit_permission | INTEGER | ||
initiator | STRING 100 | ||
initiator_ID | UUID | ca_contact::uuid | |
KD_permission_index_ID | INTEGER | o_indexes::id | |
last_accepted_date | LOCAL_TIME | ||
last_hit_date | INTEGER (DATE) | Specifies the last hit date created. | |
last_mod_dt | LOCAL_TIME | Indicates the timestamp when this record was last modified. | |
last_vote_date | INTEGER (DATE) | Specifies the last vote date presented in the Knowledge Report Card interface. | |
locked_by_ID | UUID | ca_contact::uuid | |
modify_date | LOCAL_TIME | ||
notes | STRING 32768 | ||
owner_ID | UUID | ca_contact::uuid | |
parent_cr | STRING 30 | call_req::persid | |
parent_iss | STRING 30 | issue persistent_id | |
primary_index | INTEGER | o_indexes::id | |
priority_ID | INTEGER | ci_properties::id | |
PROBLEM | STRING 32768 | ||
published_date | LOCAL_TIME | ||
read_pgroup | INTEGER | p_groups::id | |
resolution | STRING 32768 | ||
resolution_length | INTEGER | ||
resolution_short | STRING 255 | ||
review_date | LOCAL_TIME | ||
rework_ver | INTEGER (1/0) | 0 -- Specifies all available knowledge document version records.1 -- Specifies a rework version record. | |
sd_accepted_hits | INTEGER | ||
sd_asset_ID | UUID | ca_owned_ resource::uuid | |
sd_impact_ID | INTEGER | impact::enum | |
sd_priority_ID | INTEGER | priority::enum | |
sd_problem | STRING | Problem persid | |
sd_product_ID | INTEGER | Product::id | |
sd_rootcause_ID | INTEGER | rootcause::id | |
sd_severity_ID | INTEGER | severity::enum | |
sd_urgency_ID | INTEGER | urgency::enum | |
shortwords | STRING 32768 | ||
skip_auto_policies | INTEGER (4) (1/0) | Boolean (1/0) field to indicate if the automated policies should skip a knowledge document. | |
status_ID | INTEGER | ci_statuses::id | |
subject_expert_ID | UUID | ca_contact::uuid | |
summary | STRING 255 | ||
ticket_avoided | INTEGER | Specifies the counter field to update in the Customer/Employee interface when the user accepts a document as a solution to a request/incident/problem during the self-service process. | |
title | STRING 255 | ||
user_def_ID | STRING 40 | ||
user_slv_cnt | INTEGER | ||
vote_count | INTEGER | ||
avg_rating | FLOAT | ||
faq_sym | INTEGER | ||
ver_comment | STRING 1000 | Comment logged when the rework (new) version was created | |
ver_count | INTEGER | Specifies the version ID for the number of versions created (1, 2, 3, 4...). | |
ver_cross_ref_ID | INTEGER | Specifies a cross-reference between the published document record and the new version record. | |
wf_template | INTEGER | ci_wf_templates ::id | |
word_count_total | INTEGER | ||
wordcount | INTEGER | ||
wordcounts | STRING 32768 | ||
wordorders | STRING 32768 | ||
wordplace | STRING 32768 | ||
wordspans | STRING 32768 | ||
write_pgroup | INTEGER | p_groups::id |
LONG_TEXTS
Program control table used by CA SDM Knowledge Management.
- SQL Name-- long_texts
- Object-- long_texts
Field
| Data Type
| Reference
| Remarks
|
ACTUAL_TEXT | STRING 32768 | ||
CNT_ORDER | INTEGER | ||
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
REF_PERSID | STRING 30 |
P_Groups Table
Program control table used by Knowledge Management.
- SQL Name-- P_GROUPS
- Object-- P_GROUPS
Field
| Data Type
| Reference
| Remarks
|
GRP_LIST | STRING 4096 | ||
GRP_LIST_KEY | STRING 255 | ||
TYPE | INTEGER | Indicates if the P Groups is based on Roles or Groups: 1 -- Groups (Default)2 -- Roles | |
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
last_mod_by | UUID | ca_contact | Specifies the UUID of the contact who last modified this record |
last_mod_dt | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
tenant | UUID | ca_tenant | Specifies the UUID of the tenant. |
Doc_Versions
Program control table used by CA SDM Knowledge Management.
- SQL Name-- DOC_VERSIONS
- Object-- DOC_VERSIONS
Field
| Data Type
| Reference
| Remarks
|
ID | INTEGER | Specifies the primary key. | |
doc_ID | INTEGER | skeletons::id | Specifies the SREL to the knowledge document object. |
ver_count | INTEGER | Specifies the internal version ID that indicates the number of versions created (1, 2, 3, 4...) | |
ver_comment | STRING (2000) | Specifies the comment text. | |
start_date | DATE | Specifies the date when this version started. | |
end_date | DATE | Specifies the date when this version ended. | |
started_by | UUID | Specifies the user that created this version. | |
published_by | UUID | Specifies the user that published this version. | |
status_ID | INTEGER | Specifies the document version status. | |
ver_status | INTEGER | Specifies the previous version's status: 0 -- Existed 1 -- Archived2 -- Deleted (this only relates to the resolution field) | |
title | STRING | Specifies the document version title. | |
summary | STRING | Specifies the document summary text. | |
problem | STRING | Specifies the problem description. | |
notes | STRING | Specifies the document notes. | |
doc_type_ID | INTEGER | Specifies the document type. | |
ext_doc_ID | INTEGER | Specifies the Tree ID when Decision Tree is used. | |
last_mod_by | Byte(16) | ca_contact::uuid | Specifies the UUID of the contact who last modified this record. |
last_mod_dt | INTEGER | Indicates the timestamp of when this record was last modified. |
KD_Atmnt Table
Program control table used by Knowledge Management.
- SQL Name-- kd_attmnt
- Object-- kd_attmn
Field
| Data Type
| Reference
| Remarks
|
ATTMNT_ID | INTEGER | Attachment::id | |
DOC_ID | INTEGER | SKELETONS::id | |
ID | INTEGER KEY | Unique (to the table) Numeric ID | |
LAST_MOD_DT | LOCAL_TIME | Indicates the timestamp of when this record was last modified. | |
RES_ID | Long | If there is an embedded image, the RES_ID points to the resource file id in the attmnt table. |