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 link
1
-- 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
-- Archived
2
-- 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
-- No
1
-- Yes
EXP_SEC_CAT
int
 
Indicates a flag to export secondary categories
0
-- No
1
-- Yes
EXP_ALL_DOCS
int
 
Indicates a flag to export all documents linked to the selected category
0
-- No
1
-- Yes
EXP_FILTER
Text (2048)
 
Additional Filter for export
EXP_ATTMNT
int
 
Indicates a flag to export attachments
0
-- No
1
-- Yes
EXP_INDEX_DOC
int
 
Indicates a flag to Index documents after import
0
-- No
1
-- Yes
OVERRIDE_PUB
int
 
Indicates a flag to override published documents
0
-- No
1
-- Yes
OVERRIDE_UNPUB
 
 
Indicates a flag to override unpublished documents
0
-- No
1
-- 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
-- Active
1
-- 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 Match
2
-- Exact Match
3
-- Keyword List
4
-- 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
-- Archived
2
-- 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.