skeletons

Program control table used by Unicenter Knowledge Tools

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) numeric identifier.
user_def_id nvarchar(40) with null The user defined id value for this SKELETONS.
active_state integer with null The document state value for this SKELETONS.
active_state_date integer with null The document state date value for this SKELETONS.
hits integer with null The hits value for this SKELETONS.
sd_accepted_hits integer with null The solution count value for this SKELETONS.
status_id integer with null The status id value for this SKELETONS.
priority_id integer with null The workflow priority id value for this SKELETONS.
doc_type_id integer with null The document type id value for this SKELETONS.
ext_doc_id integer with null The decision tree root id value for this SKELETONS.
initiator_id byte(16) with null The initiator id value for this SKELETONS.
initiator nvarchar(100) with null The initiator value for this SKELETONS.
owner_id byte(16) with null The owner id value for this SKELETONS.
author_id byte(16) with null The author id value for this SKELETONS.
subject_expert_id byte(16) with null The subject expert id value for this SKELETONS.
assignee_id byte(16) with null The assignee id value for this SKELETONS.
creation_date integer with null The timestamp indicating when this record was created
modify_date integer with null The modify date value for this SKELETONS.
start_date integer with null The start date value for this SKELETONS.
expiration_date integer with null The expiration date value for this SKELETONS.
review_date integer with null The review date value for this SKELETONS.
last_accepted_date integer with null The last accepted date value for this SKELETONS.
sd_product_id integer with null The product id value for this SKELETONS.
sd_asset_id byte(16) with null The asset id value for this SKELETONS.
sd_rootcause_id integer with null The root cause id value for this SKELETONS.
sd_priority_id integer with null The priority id value for this SKELETONS.
sd_severity_id integer with null The severity id value for this SKELETONS.
sd_impact_id integer with null The impact id value for this SKELETONS.
sd_urgency_id integer with null The urgency id value for this SKELETONS.
created_via integer with null The created via value for this SKELETONS.
read_pgroup integer with null The read pgroup value for this SKELETONS.
write_pgroup integer with null The write pgroup value for this SKELETONS.
primary_index integer with null The primary category value for this SKELETONS.
kd_permission_index_id integer with null The inherit permissions from category id value for this SKELETONS.
inherit_permission integer with null The inherit permissions flag value for this SKELETONS.
current_action_id integer with null The task id value for this SKELETONS.
resolution_short nvarchar(255) with null The short resolution value for this SKELETONS.
resolution_length integer with null The resolution length value for this SKELETONS.
doc_template_id integer with null The document template id value for this SKELETONS.
custom1 nvarchar(50) with null The custom 1 value for this SKELETONS.
custom2 nvarchar(50) with null The custom 2 value for this SKELETONS.
custom3 nvarchar(50) with null The custom 3 value for this SKELETONS.
custom4 nvarchar(255) with null The custom 4 value for this SKELETONS.
custom5 nvarchar(255) with null The custom 5 value for this SKELETONS.
custom_num1 float with null The custom num 1 value for this SKELETONS.
custom_num2 float with null The custom num 2 value for this SKELETONS.
bu_result float with null The faq rating value for this SKELETONS.
expire_notification_sent integer with null The expire notification sent value for this SKELETONS.
published_date integer with null The published date value for this SKELETONS.
wf_template integer with null The workflow template value for this SKELETONS.
doc_version nvarchar(50) with null The document version value for this SKELETONS.
ver_count integer with null The version count value for this SKELETONS.
ver_cross_ref_id integer with null The version cross reference id value for this SKELETONS.
ver_comment nvarchar(1000) with null The version comment value for this SKELETONS.
locked_by_id byte(16) with null The locked by id value for this SKELETONS.
word_count_total integer with null The word count total value for this SKELETONS.
wordcount integer with null The wordcount value for this SKELETONS.
title nvarchar(255) with null The title value for this SKELETONS.
summary nvarchar(255) with null The summary value for this SKELETONS.
problem long nvarchar with null The problem value for this SKELETONS.
resolution long nvarchar with null The resolution text value for this SKELETONS.
notes long nvarchar with null The notes value for this SKELETONS.
fullwords long nvarchar with null The fullwords value for this SKELETONS.
shortwords long nvarchar with null The shortwords value for this SKELETONS.
wordcounts long nvarchar with null The wordcounts value for this SKELETONS.
wordspans long nvarchar with null The wordspans value for this SKELETONS.
wordplaces long nvarchar with null The wordplaces value for this SKELETONS.
wordorders long nvarchar with null The wordorders value for this SKELETONS.
last_mod_dt integer with null Timestamp of when this record was last modified
indexed integer with null The indexed value for this SKELETONS.
parent_cr nvarchar(30) with null The parent request value for this SKELETONS.
parent_iss nvarchar(30) with null The parent issue value for this SKELETONS.
total_weight float with null  
user_slv_cnt integer with null  
vote_count integer with null  
avg_rating float with null  
faq_sym integer with null  

Product Name: Unicenter Service Desk

Table Type: Table

Copyright © 2006 CA. All rights reserved.