Skip to main content

SQL Table - RADplus_audit_binary_tables

  1. Last updated
  2. Save as PDF

Populated when a row of data in a form’s binary storage table is edited or deleted.

Contains table columns required to join to the SQL projection SYSTEM.RADplus_audit_database_tables.

When audit trail information is deleted (Audit Trail Management form), associated binary audit information is deleted.

Binary storage tables are stored in the VIEWS directory.

Table Column

Comment

ID

Unique row ID. Computed value.

FACILITY

Associated facility.

entity_database

Entity database.

ENTITYID

Entity database ID.

field_name

Field name in associated table.

table_name

Associated table name.

table_uniqueid

Unique ID in associated table.

table_row_counter

Counter for unique ID.

audit_data

Original data.