seqctl

Used to determine what to use for a prefix and suffix when generating call request numbers. Users may not create new records or delete records in this table.

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) numeric identifier.
del integer not null Deleted flag (0=active 1=inactive/marked as deleted)
sym nvarchar(30) not null The sym value for this Sequence_Control.
last_mod_dt integer with null Timestamp of when this record was last modified
code nvarchar(12) not null Noneditable key for record
prefix nvarchar(5) with null Prefix to sequence number
suffix nvarchar(5) with null Suffix to sequence number
description nvarchar(240) with null Textual description
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.