Previous Topic: Change_Status TableNext Topic: chg_trans Table


Chg_Template Table

Maps a template name to a Change_Request that will be used as a template.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_
Table::enum

Delete flag that represents the following:
0—Active
1—Inactive/marked as deleted

description

nvarchar (1000)

 

Describes the template.

id

INTEGER

 

Unique (to the table) numeric ID.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Identifies the timestamp of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id)

quick_tmpl_ type

INTEGER

Quick_Template_Types::enum

Flag that indicates the following:
1—Quick tmpl
2—Quick tmpl+review

template

INTEGER

chg id

Unique (to the table) numeric ID.

template_class

nvarchar(12)

 

Allows subclassing templates.

template_name

nvarchar(30)

 

Unique name of the template.