This table is for internal use. Do not change data.
Used to manage purge jobs.
TMPDF_IS_DROP, TMPDF_IS_DELETE, and TMPDF_IS_TRUNCATE are mutually exclusive.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | TMPDF_ID | The record ID. | int | 4 | ||
TMPDF_EXPIRATION_DATE | The earliest date this row is a purge candidate. | datetime | 4 | |||
TMPDF_TABLE_NAME | The table with the temporary data. | varchar | 255 | |||
TMPDF_IS_DROP | Y indicates that purge job may drop table TMPDF_TABLE NAME. | varchar | 1 | |||
TMPDF_IS_DELETE | Y indicates that the the purge job deletes the rows identified with TMPDF_FILTER_FIELD_NAME and TMPDF_FILTER_FIELD_VALUE. | varchar | 1 | |||
TMPDF_IS_TRUNCATE | Y indicates that purge job may truncate table TMPDF_TABLE NAME. | varchar | 1 | |||
TMPDF_FILTER_FIELD_NAME | The field name used if TMPDF_IS_DELETE. | varchar | 255 | ![]() | ||
TMPDF_FILTER_FIELD_VALUE | The field value used if TMPDF_IS_DELETE. | varchar | 255 | ![]() |