ComplianceHistoryColumn Table

The ComplianceHistoryColumn table lists the fields (columns) for which history details can be recorded.

Table 1. Database columns for ComplianceHistoryColumn table

Database Column

Details

ComplianceHistoryColumnID

Type: integer. Key. Generated ID

A unique identifier for a history column.

TableName

Type: text (max 128 characters). Key

The name of the database table to which the history-record settings apply. This may have a suffix of .1 or .2. These suffixes are used for grouping purposes. Do not edit this field.

ColumnName

Type: text (max 128 characters). Key

A description of the column in the specified TableName for which the history record settings apply. If this row relates to an entire table, the ColumnName will contain the word “History”, for example, “Asset History” or “Contract History”.

BitwiseValue

Type: integer. Key

The bitwise value uniquely identifies each row relating to a single TableName. Typically, a value of 1 indicates that this row relates to an entire table. A value greater than 1 indicates that this row relates to a single field in the table. Do not edit this field.

RecordHistory

Type: boolean

Boolean field to indicate if history should be recorded. Set this value to 1 (True) to record history details. Set this value to 0 (False) if no history details should be recorded.