HP ALM Database Reference
td.LIBRARIES Table

Description

Libraries.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key LIB_IDThe record ID.int4  
 LIB_PARENT_IDThe record ID of the folder that contains this item.int4  
 LIB_NAMEThe name of the item.varchar255  
 LIB_VER_STAMPThe version number of this record.int4 
 LIB_DESCRIPTIONA free text description of this item.varchar16 
 LIB_HAS_ATTACHMENTSY if this item has attachments.varchar1 
 LIB_TYPE

1 - Imported library

2 - Exported library

int4  
 LIB_CFR_PROJECT_UIDThe unique ID of the project from which this library was imported. varchar36 
 LIB_CFR_LIBRARY_ORIGNAMEThe name of the library from which this library was imported.varchar255 
 LIB_CFR_LIBRARY_IDThe LIB_ID of the library from which this library was imported.int4 
 LIB_CFR_LAST_SYNC_DATE

The date of the last synchronization according to the server clock.

datetime4 
 LIB_CFR_CREATED_BYThe user name who created the library from which this library was imported. Applies only to imported libraries.varchar60 
 LIB_CREATED_BYThe user name of the user who created this item.varchar60 
 LIB_CREATION_DATEThe server date when this item was created.datetime4 
 LIB_ASYNCH_STATUS

One of the following codes:

-1
Error
0
Not imported yet
1
Stable state
2
Import in progress
3
Synch in progress
4
Synchronized
int4 
 LIB_CFR_BASELINE_ORIGNAMEThe name of the baseline from which the library was created.varchar255 
 LIB_CFR_BASELINE_IDThe BASELINES.BL_ID of the baseline from which the library was created.int4 
 LIB_CFR_DOMAIN_NAMEThe domain that contains the project from which this library was imported.varchar255 
 LIB_CFR_PROJECT_NAMEThe project from which this library was imported.varchar255 
 LIB_LAST_SYNC_TO_BASELINE_IDIf the library has been synchronized, the BASELINES.BL_ID to which the library was synchronizes.int4 
 LIB_AUTOCOMPLETE_TYPE1 indicates that the covering tests are automatically added to the library.int4 
 LIB_USER_01User-defined field.varchar40 

See Also