Previous Topic: Cr_Call_Timers TableNext Topic: Cr_Stored_Queries Table

Data Element Dictionary › Cr_Status Table

Cr_Status Table

Call Request Status. Lists the states of the call request. May be added to at will. Allows the user to control whether the call request is active or inactive when it is changed to this status.

Field

Data Type

Reference

Remarks

active

INTEGER

 

Sets the Active flag, as follows:
0—Inactive
1—Active

code

nvarchar(12)

 

Primary key of this table.

cr_flag

INTEGER

 

When this flag is set to 1, this status is valid for Requests.

del

INTEGER

Active_Boolean_
Table::enum

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

description

nvarchar(500)

 

Identifies the textual description of the status.

hold

INTEGER

 

Sets the Hold flag, as follows:
0—Start events
1—Stop events

id

INTEGER

 

Unique (to the table) numeric ID.

in_flag

INTEGER

 

When this flag is set to 1, the status is valid for Incidents.

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).

pr_flag

INTEGER

 

When this flag set to 1, the status is valid for Problems.

resolved

INTEGER

 

Flag that indicates the following:
0— Not yet resolved
1—Resolved

sym

nvarchar(30)

 

Identifies the symbol of the Request status name.