PPREFDEFREL

The PPREFDEFREL table defines the parent child relationship between two default privacy preference records, allowing for different privacy preference regulations to supersede other regulations that are based on different criteria.

This table is used by the following domain.
Name Comment Datatype Null Option Is PK
PPREFDEFREL_ID A unique, system-generated key that identifies a relationship that two privacy preference records can have between one another in the system. BIGINT Not Null Yes
PARENT_PPREF_ID The primary key for the parent of the relationship. BIGINT Not Null No
CHILD_PPREF_ID The primary key for the child of the relationship. BIGINT Not Null No
REL_DESC Provides extra space for information that can be used for an additional definition or as free form comments to provide further meaning. VARCHAR(255) Null No
START_DT The date when this record becomes active. TIMESTAMP Not Null No
END_DT The date when this record becomes inactive. TIMESTAMP Null No
LAST_UPDATE_DT When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. TIMESTAMP Not Null No
LAST_UPDATE_USER The ID of the user who last updated the data. VARCHAR(20) Null No
LAST_UPDATE_TXN_ID A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. BIGINT Null No