Previous Topic: Cr_Stored_Queries TableNext Topic: cr_trans Table


Cr_Template Table

Request Template Table maps a template name to a Call_Req that will be used as a template.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_ Table::enum

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

description

nvarchar(1000)

 

Shows the description of the template.

id

INTEGER

 

Identifies the nique (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

 

Indicates the timestamp of when this record was last modified.

quick_tmpl_type

INTEGER

Quick_Template_ Types::enum

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

template

nvarchar(30)

Call_Req::persid

Persistent ID (SystemObjectName:id).

template_class

nvarchar(12)

 

Indicates to allow subclassing templates.

template_name

nvarchar(30)

 

Identifies the unique name of the template.