rca_audit_action

Stores list of actions permitted for each audit level. If a particular action is listed for given audit level, then only the audit entry is created in the database.

Field name (Key)

Field data type

Purpose

action_id (PRI)

varchar(255)

The audit action identifier.

actionName

varchar(255)

Name of the audit action, such as “REVIEW_COMPLETE”.

description

text)

Description of the audit action.

auditLevel (MUL)

varchar(255)

The audit level to use for the review.

level_id (MUL)

varchar(255)

Duplicate column for future use.

// Ethnio survey code removed