ALM Project Database Reference
td.DELETED_ASSETS_INFO Table
Description
Records of deleted assets for tracing.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
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_BYThe user who deleted the user asset.varchar60   
 DAI_DELETED_DATEThe date the user asset was deleted.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  
Indexes
See Also