CATEQUIV
The CATEQUIV table contains information about a category equivalency.
This table is used by the following domain.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
CAT_EQUIV_ID | A unique, system-generated key that identifies a category equivalency in the system. | BIGINT | Not Null | Yes |
CATEGORY_ID | A unique, system-generated key that identifies a category in the system. | BIGINT | Not Null | No |
ADMIN_SYS_TP_CD | Administration System Code uniquely identifies the administrative source system for a contract. Examples include Ingenium, Alltel, Huon, etc. | BIGINT | Not Null | No |
CAT_EQUIV_KEY | A key, or ID, that uniquely identifies the category in the administrative source system. | VARCHAR(160) | Null | No |
KEY_1 | A partial key, which in conjunction with other keys, identifies the category in the administrative source system. | VARCHAR(30) | Not Null | No |
KEY_2 | A partial key, which in conjunction with other keys, identifies the category in the administrative source system. | VARCHAR(30) | Null | No |
KEY_3 | A partial key, which in conjunction with other keys, identifies the category in the administrative source system. | VARCHAR(30) | Null | No |
KEY_4 | A partial key, which in conjunction with other keys, identifies the category in the administrative source system. | VARCHAR(30) | Null | No |
KEY_5 | A partial key, which in conjunction with other keys, identifies the category in the administrative source system. | VARCHAR(30) | 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 |