Previous Topic: True_False_Table TableNext Topic: Urgency Table


Type_Of_Contact Table

Reference table to denote the type of issue. examples: complaint, complement and so on.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_
Table::enum

Specifies the Deleted flag, as follows:
0—Active
1—Inactive/marked as deleted

id

INTEGER

 

Primary key of this table, this is the unique 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

 

Species the timestamp of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

sym

nvarchar(60)

 

The symbolic value for this Type_Of_Contact.