ComplianceEventState Table

ComplianceEventState is a static table holding all possible event states.

Table 1. Database columns for ComplianceEventState table

Database Column

Details
EventStateID

Type: integer. Key. Generated ID

A unique identifier for each ComplianceEventState. Possible values and the corresponding default strings are:

  • 1 = New (action needs to be taken for this event)
  • 2 = Postponed (no action needs to be taken at this time)
  • 3 = Accepted (the proposed action has been taken for this event)
  • 4 = Rejected (the proposed action will not be taken).
EventStateResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an event state. Foreign key to the ComplianceResourceString table.
EventStateDefaultValue

Type: text (max 100 characters)

The text to display if the state resource string has no translation.