The CATHIERARCHY table contains information about a category hierarchy.

This table is used by the following domain.
Name Comment Datatype Null Option Is PK
CAT_HIERARCHY_ID A unique, system-generated key that identifies a category hierarchy in the system. BIGINT Not Null Yes
NAME A short, meaningful label for the category hierarchy. VARCHAR(120) Not Null No
DESCRIPTION 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
HIERARCHY_TP_CD Code indicating the category hierarchy type. BIGINT 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_TX_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