AVG_RATING

AVG_RATING

DOUBLE

Document State

ACTIVE_STATE

INTEGER

Document State Date

ACTIVE_STATE_ DATE

LOCAL_TIME

Assignee ID

ASSIGNEE_ID

UUID

ca_contact uuid

Author ID

AUTHOR_ID

UUID

ca_contact uuid

FAQ Rating

BU_RESULT

REAL

Created Via

CREATED_VIA

INTEGER

Creation Date

CREATION_DATE

LOCAL_TIME

Task ID

CURRENT_ACTION_ID

INTEGER

CI_ACTIONS id

Custom 1

CUSTOM1

STRING

Custom 2

CUSTOM2

STRING

Custom 3

CUSTOM3

STRING

Custom 4

CUSTOM4

STRING

Custom 5

CUSTOM5

STRING

Custom Num 1

CUSTOM_NUM1

REAL

Custom Num 2

CUSTOM_NUM2

REAL

Document Template ID

DOC_TEMPLATE_ ID

INTEGER

CI_DOC_ TEMPLATES id

Document Type ID

DOC_TYPE_ID

INTEGER

CI_DOC_ TYPES id

Document Version

DOC_VERSION

STRING

Expiration Date

EXPIRATION_DATE

LOCAL_TIME

EXPIRE_ NOTIFICATION_ SENT

EXPIRE_ NOTIFICATION_ SENT

INTEGER

Decision Tree Root ID

EXT_DOC_ID

INTEGER

ebr_search_text

ebr_search_text

STRING

ebr_min_relevance

ebr_min_relevance

STRING

ebr_fuzziness

ebr_fuzziness

STRING

ebr_search_type

ebr_search_type

STRING

ebr_match_type

ebr_match_type

STRING

ebr_search_in

ebr_search_in

STRING

ebr_primary_order

ebr_primary_order

STRING

ebr_secondary_ order

ebr_secondary_ order

STRING

ebr_order_direction

ebr_order_direction

STRING

ebr_custom_filter

ebr_custom_filter

STRING

ebr_sd_persid

ebr_sd_persid

STRING

ebr_filter_data

ebr_flter_data

STRING

ebr_url_text

ebr_url_text

STRING

ebr_ks_source

ebr_ks_source

STRING

ebr_kcat_id

ebr_kcat_id

STRING

ebr_ad_blc

ebr_ad_blc

STRING

ebr_serial_num

ebr_serial_num

STRING

ebr_relevance

ebr_relevance

STRING

ebr_ks_teaser

ebr_ks_teaser

STRING

ebr_ks_concepts

ebr_ks_concepts

STRING

FLG_COUNT

FLG_COUNT

QREL

FULLWORDS

FULLWORDS

STRING

Hits

HITS

INTEGER

id

ID

INTEGER

KEY

INDEXED

INDEXED

INTEGER

Inherit Permissions Flag

INHERIT_ PERMISSION

INTEGER

Initiator

INITIATOR

STRING

Initiator ID

INITIATOR_ID

UUID

ca_contact uuid

Inherit Permissions from Category ID

KD_PERMISSION_ INDEX_ID

INTEGER

O_INDEXES id

KS_TYPE

KS_TYPE

INTEGER

Last Accepted Date

LAST_ACCEPTED_DATE

LOCAL_TIME

Last Modified Date

LAST_MOD_DT

LOCAL_TIME

Indicates the timestamp of when this record was last modified.

Locked By ID

LOCKED_BY_ID

UUID

ca_contact uuid

Modify Date

MODIFY_DATE

LOCAL_TIME

Notes

NOTES

STRING

Owner ID

OWNER_ID

UUID

ca_contact uuid

Parent Request

PARENT_CR

STRING

call_req persid

Parent Issue

PARENT_ISS

STRING

issue persistent_id

persistent_id

persid

STRING

Primary Category

PRIMARY_INDEX

INTEGER

O_INDEXES id

Workflow Priority ID

PRIORITY_ID

INTEGER

CI_PRIORITIES id

Problem

PROBLEM

STRING

producer_id

producer_id

STRING

Published Date

PUBLISHED_DATE

LOCAL_TIME

READ_PGROUP

READ_PGROUP

INTEGER

P_GROUPS id

PGROUP TYPE

PGROUP_TYPE

INTEGER

Indicates if the P Groups is based on Roles or Groups:

1—Groups (Default)

2—Roles

QA_STATUS

QA_STATUS

SREL

kt_qa_status.id

Resolution Text

RESOLUTION

STRING

Resolution Length

RESOLUTION_ LENGTH

INTEGER

Short Resolution

RESOLUTION_ SHORT

STRING

Review Date

REVIEW_DATE

LOCAL_TIME

Solution Count

SD_ACCEPTED_ HITS

INTEGER

Asset ID

SD_ASSET_ID

UUID

ca_owned_ resource uuid

Impact ID

SD_IMPACT_ID

INTEGER

impact enum

PRIMARY_KCAT_ CHANGE_ONKCAT_ DELETE

PRIMARY_KCAT_ CHANGE_ONKCAT_ DELETE

INTEGER

Priority ID

SD_PRIORITY_ID

INTEGER

pri enum

PROBLEM_SHORT

PROBLEM_SHORT

STRING 255

Product ID

SD_PRODUCT_ID

INTEGER

product id

RESOLUTION_ TEXT

RESOLUTION_ TEXT

STRING

Root Cause ID

SD_ROOTCAUSE_ ID

INTEGER

rootcause id

Severity ID

SD_SEVERITY_ID

INTEGER

sevrty enum

Urgency ID

SD_URGENCY_ID

INTEGER

urgncy enum

USER_SLV_CNT

USER_SLV_CNT

INTEGER

SHORTWORDS

SHORTWORDS

STRING

Start Date

START_DATE

LOCAL_TIME

Status ID

STATUS_ID

INTEGER

CI_STATUSES id

Subject Expert ID

SUBJECT_EXPERT_ID

UUID

ca_contact uuid

SUBMIT_ KNOWLEDGE_ GUEST_USER_ NAME

SUBMIT_ KNOWLEDGE_ GUEST_USER_ NAME

STRING

SUBMIT_ KNOWLEDGE_ GUEST_MAIL

SUBMIT_ KNOWLEDGE_ GUEST_MAIL

STRING

Summary

SUMMARY

STRING

ticket_avoided_cnt

ticket_avoided_cnt

INTEGER

Title

TITLE

STRING

User Defined ID

USER_DEF_ID

STRING

Version Comment

VER_COMMENT

STRING

Version Count

VER_COUNT

INTEGER

Version Cross Reference ID

VER_CROSS_REF_ ID

INTEGER

Workflow Template

WF_TEMPLATE

INTEGER

CI_WF_ TEMPLATES id

WORD_COUNT_ TOTAL

WORD_COUNT_ TOTAL

INTEGER

WORDCOUNT

WORDCOUNT

INTEGER

WORDCOUNTS

WORDCOUNTS

STRING

WORDORDERS

WORDORDERS

STRING

WORDPLACES

WORDPLACES

STRING

WORDSPANS

WORDSPANS

STRING

WRITE_PGROUP

WRITE_PGROUP

INTEGER

P_GROUPS id