HP ALM Database Reference
td.DELETED_ASSETS_INFO Table

Description

Records of deleted assets for tracing.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key DAI_IDThe record ID.int4  
 DAI_ASSET_IDThe ID of the deleted asset in the table given in DAI_ASSET_TYPE.int4  
 DAI_ASSET_PATH

For TEST, RESOURCE, and COMPONENT, the path is <QC entity path>\<entity id>.

For USER_ASSET, the path is  <QC owner entity path>\<owner entity id>\<user asset id>

varchar255 
 DAI_ASSET_NAMEThe name of the deleted entity as it appears in the user interface.varchar255 
 DAI_ASSET_TYPEFor example:

TEST, RESOURCES, COMPONENT, or, USER_ASSET

varchar40  
 DAI_ASSET_DISPLAY_TYPEThe type of the deleted entity as it appears in the user interface.varchar255 
 DAI_ASSET_DESCRIPTIONA description of the deleted asset.varchar16 
 DAI_DELETED_BY varchar60  
 DAI_DELETED_DATE datetime4  
 DAI_OWNER_ID

For entities that have an owner, the ID of the owner. For example, user assets that are QuickTest Professional actions are owned by the QTP test, so this field would store the ID of the test.

int4 
 DAI_OWNER_TYPEThe type of the owner entity. For example, TEST.varchar40 
 DAI_OWNER_DISPLAY_TYPEThe owner type as it appears in the user interface. For example, QUICKTEST_TEST.varchar255 
 DAI_OWNER_NAMEThe owner name as it appears in the user interface.varchar255 
 DAI_OWNER_DESCRIPTIONThe description of the owner.varchar16 

See Also