kdlinks

Each record indicates a link between a KD and request or issues link_type field is an enum: 1 - KD is a solution to the ticket 2 - Ticket create based on the document last_mod_by - The person that links the document and the ticket

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) numeric identifier.
kd integer with null The document value for this kdlinks.
sd_obj_type nvarchar(5) with null The ticket type value for this kdlinks.
cr nvarchar(30) with null The request linked value for this kdlinks.
iss nvarchar(30) with null The issue linked value for this kdlinks.
sd_obj_id integer with null The ticket id value for this kdlinks.
link_type integer with null The link type value for this kdlinks.
last_mod_dt integer with null Timestamp of when this record was last modified
last_mod_by byte(16) with null Specifies the uuid of the contact who last modified this record

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.