ComplianceHistoryType Table

ComplianceHistoryType is a static table listing all valid types of history records.

Table 1. Database columns for ComplianceHistoryType table

Database Column

Details
ComplianceHistoryTypeID

Type: integer. Key. Generated ID

A unique identifier for a history type.
ComplianceHistoryType Description

Type: text (max 100 characters)

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

  • 1 = Insert
  • 2 = Delete
  • 3 = Update
  • 4 = Link
  • 5 = Unlink
  • 6 = Allocated
  • 7 = Unallocated
  • 8 = Assigned
  • 9 = Unassigned
  • 10 = Operator unlinked from user due to duplicate login (operator history)
  • 11 = Operator unlinked from user due to duplicate login (user history)
  • 12 = Rights to contract granted
  • 13 = Rights to contract updated
  • 14 = Rights to contract removed
  • 15 = Rights to document granted
  • 16 = Rights to document updated
  • 17 = Rights to document removed
  • 18 = Receives (referring to escalations or alerts)
  • 19 = No longer receives (referring to escalations or alerts)
  • 20 = Assigned responsibility
  • 21 = Unassigned responsibility
  • 22 = Final state of entity when deleted
  • 23 = Rights to contract removed because contract was deleted
  • 24 = Rights to document removed because document was deleted
  • 25 = No longer receives (referring to escalations or alerts) because entity deleted
  • 26 = Unassigned responsibility because entity was deleted
  • 27 = Responsibility type changed.
  • 28 = Update CloudLicense Model.
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a history type. Foreign key to the ComplianceResourceString table.
DefaultValue

Type: text (max 100 characters)

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