ACCESSDATEVAL
The ACCESSDATEVAL table captures the last used date and last verified date around various entities and attributes.
This table is used by the following functional feature.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| ACC_DATE_VAL_ID | A unique, system-generated key that identifies a default object in the system. | BIGINT | Not Null | Yes |
| INSTANCE_PK | The actual primary key of the row in the logical entity. | BIGINT | Not Null | No |
| ENTITY_NAME | The name of the business entity. | VARCHAR(20) | Not Null | No |
| COL_NAME | The actual name of the column where the default occurred. | VARCHAR(20) | Null | No |
| DESCRIPTION | A description of the record. | VARCHAR(1000) | Null | No |
| LAST_USED_DT | The date that this data was last used. There is no business logic associated with this field. | TIMESTAMP | Null | No |
| LAST_VERIFIED_DT | The date that this data was last verified. There is no business logic associated with this field. | 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 |