HP ALM Database Reference
td.TEMPORARY_DATA_FOOTPRINT Table

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 NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key TMPDF_IDThe record ID.int4  
 TMPDF_EXPIRATION_DATEThe earliest date this row is a purge candidate.datetime4  
 TMPDF_TABLE_NAMEThe table with the temporary data.varchar255  
 TMPDF_IS_DROPY indicates that purge job may drop table TMPDF_TABLE NAME.varchar1  
 TMPDF_IS_DELETEY indicates that the the purge job deletes the rows identified with TMPDF_FILTER_FIELD_NAME and TMPDF_FILTER_FIELD_VALUE.varchar1  
 TMPDF_IS_TRUNCATEY indicates that purge job may truncate table TMPDF_TABLE NAME.varchar1  
 TMPDF_FILTER_FIELD_NAME

The field name used if TMPDF_IS_DELETE.

varchar255 
 TMPDF_FILTER_FIELD_VALUE

The field value used if TMPDF_IS_DELETE.

varchar255 

See Also