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