kt_report_card

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.
subject_id nvarchar(64) with null The subject id value for this KT_REPORT_CARD.
past_days integer with null The past days value for this KT_REPORT_CARD.
org_statistics integer with null The org statistics value for this KT_REPORT_CARD.
documents_submitted integer with null The documents submitted value for this KT_REPORT_CARD.
documents_published integer with null The documents published value for this KT_REPORT_CARD.
total_hits integer with null The total hits value for this KT_REPORT_CARD.
average_effectiveness_rating integer with null The average effectiveness rating value for this KT_REPORT_CARD.
total_solution_count integer with null The total solution count value for this KT_REPORT_CARD.
creation_user nvarchar(64) with null The name of the person who created this record. Should be in form: LastName, FirstName
creation_date integer with null The timestamp indicating when this record was created
last_update_user nvarchar(64) with null Specifies the contact who last modified this record. Should be in form: LastName, FirstName
last_update_date integer with null Timestamp of when this record was last modified
total_votes integer with null  
avg_rating float with null  
user_slv_cnt integer with null  
last_mod_dt integer with null  

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.