cr_prptpl

Templates used to specify request properties.

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) Numeric ID
persid nvarchar(30) with null Persistent ID (SystemObjectName:id)
del integer not null Deleted flag (0=active 1=inactive/marked as deleted)
sequence integer not null Display order
label nvarchar(80) not null Display text for property
description nvarchar(240) with null Textual description of this template
code nvarchar(12) not null Noneditable handle for query
required integer not null 0 not required
sample nvarchar(240) with null help text
owning_area nvarchar(30) not null Parent category
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.