Rules reporting tables
Check the Postgres, Db2 statements for the tables that are related to data protection rules.
| Subject area | Table name | Description |
|---|---|---|
| Rules | enforcement_rules | The data protection rules that are defined. |
enforcement_rules table
This table contains information about the enforcement rules (data protection rules) that are defined.
This table has the following columns:
rule_id- The identifier of the rule.rule_type- The type of the rule.name- The name of the rule.created_by- The identifier of the user that created the rule.created_on- The timestamp when the rule was created.modified_by- The identifier of the user that last modified the rule.modified_on- The timestamp when the rule was last modified.description- The description of the rule.action_name- The type of the action that this rule enforces.rule_json- The JSON representation of the defined rule.
Postgres
CREATE TABLE statement:
create table enforcement_rules(rule_id varchar(36) not null,
rule_type varchar(128) not null,
name varchar(256) not null,
description text,
action_name varchar(256) not null,
created_on timestamp(6) not null,
created_by varchar(128) not null,
modified_on timestamp(6),
modified_by varchar(128),
rule_json text not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(rule_id));
Db2
CREATE TABLE statement:
create table enforcement_rules(rule_id varchar(36) not null,
rule_type varchar(128) not null,
name varchar(256) not null,
description clob,
action_name varchar(256) not null,
created_on timestamp(12) not null,
created_by varchar(128) not null,
modified_on timestamp(12),
modified_by varchar(128),
rule_json clob not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(rule_id),
period SYSTEM_TIME (tech_start,
tech_end) )
Learn more
Parent topic: Reporting tables