Previous Topic: Group_Member TableNext Topic: in_trans Table


Impact Table

Impact is a measure of the significance of an event by the user. It is used on Incident Reports.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_
Table::enum

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

enum

INTEGER

 

Primary key for this table.

id

INTEGER

 

Specifies the 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

 

Indicates the timestamp of when this record was last modified.

nx_desc

nvarchar(40)

 

Specifies the textual description of this impact.

sym

nvarchar(12)

 

Identifies the symbolic value for this impact.

value

INTEGER

 

Shows the numeric representation of this impact.