prptpl

Additional properties for objects

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) numeric identifier.
persid nvarchar(30) with null Persistent ID (SystemObjectName:id)
del integer not null Deleted flag (0=active 1=inactive/marked as deleted)
object_type nvarchar(30) not null Short name of object
object_attrname nvarchar(30) not null This template belongs attribute name in object
object_attrval integer with null Which drives the template attribute value
sequence integer not null Display order
label nvarchar(80) not null Display text for property
description nvarchar(240) with null Textual description
code nvarchar(12) not null Noneditable handle for query
required integer not null 0=not required, 1=required
sample nvarchar(240) with null Help text
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.