Share this page
ALM Project 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 Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | FCT_ID | The record ID. | int | 4 | |||
| FCT_COMPONENT_ID | The COMPONENT.CO_ID of the parent component. | int | 4 | ||||
| FCT_SUBTYPE_ID | The facet type. | varchar | 50 |  | |||
| FCT_STATUS | The facet status, for example, Ready, Maintenance, Not Implemented, Error or Under Development. | varchar | 70 | | |||
| FCT_CREATED_BY | The user name of the user who created this item. | varchar | 60 | | |||
| FCT_CREATION_DATE | The server date when this item was created. | datetime | 4 | | |||
| FCT_ASSIGN_TO | The ALM user name of the person responsible for the facet. | varchar | 60 | | |||
| FCT_SYNCED_FROM | The FCT_ID of the facet this facet is synched from. | int | 4 | | |||
| FCT_VER_STAMP | The version number of this record. | int | 4 | | |||
| FCT_USER_01 | User-defined field. | varchar | 40 | | |||
| FCT_USER_02 | User-defined field. | varchar | 40 | | |||
| FCT_USER_03 | User-defined field. | varchar | 40 | | |||
| FCT_USER_04 | User-defined field. | varchar | 40 | | |||
| FCT_USER_05 | User-defined field. | varchar | 40 | | |||
| FCT_VC_CHECKOUT_USER_NAME | The user who checked out the item under version control. If the item is not checked out, this field is blank. | varchar | 60 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| FACETS_PK | | | |
| FCT_FACETS_IX1 |
See Also
Related Objects
