Previous Topic: Mgs_Act_Log TableNext Topic: Note_Board Table


Mgs_Status Table

List of valid message status definitions.

Field

Data Type

Reference

Remarks

active

INTEGER

 

Flag that indicates the following:
0—Inactive
1—Active

code

nvarchar(12)

 

Primary key of this table.

del

INTEGER

Active_Boolean_
Table::enum

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

description

nvarchar
(500)

 

Identifies the textual description of this status.

hold

INTEGER

 

Flag that specifies the following:
0—Start events
1—Stop events

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

sym

nvarchar(30)

 

Identifies the Managed Survey Status name.