Description
This table is for internal use. Do not change data.
Remarks
Used to manage purge jobs.
TMPDF_IS_DROP, TMPDF_IS_DELETE, and TMPDF_IS_TRUNCATE are mutually exclusive.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| TEMPORARY_DATA_FOOTPRINT_PK | | |
See Also