HP ALM Database Reference
td.FACETS Table

Description

Metadata on an implementation of a business component.

Remarks

Records in other tables that belong to the implementation point to the facet record. For example, a component step belongs to the facet indicated with COMPONENT_STEP.CS_FACET_ID.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key FCT_IDThe record ID.int4  
 FCT_COMPONENT_IDThe COMPONENT.CO_ID of the parent component.int4  
 FCT_SUBTYPE_IDThe facet type, for example: hp.qc.facet.MANUAL, hp.qc.facet.QT-SCRIPTED, hp.qc.facet.QT-KW, or hp.qc.facet.SERVICE-TEST-AUTOMATED.  varchar50 
 FCT_STATUSThe facet status, for example, Ready, Maintenance, Not Implemented, Error or Under Development.varchar70 
 FCT_CREATED_BYThe user name of the user who created this item.varchar60 
 FCT_CREATION_DATEThe server date when this item was created.datetime4 
 FCT_ASSIGN_TO varchar60 
 FCT_SYNCED_FROMThe FCT_ID of the facet this facet is synched from.int4 
 FCT_VER_STAMPThe version number of this record.int4 
 FCT_USER_01User-defined field.varchar40 
 FCT_USER_02User-defined field.varchar40 
 FCT_USER_03User-defined field.varchar40 
 FCT_USER_04User-defined field.varchar40 
 FCT_USER_05User-defined field.varchar40 
 FCT_VC_CHECKOUT_USER_NAMEThe user who checked out the item under version control.varchar60 

See Also