CustomFieldValues Table

Applies to QAComplete�14.4, last modified on May 20, 2024


The CustomFieldValues table contains the values for custom fields 11 through 90 across all modules, in a one-to-one relationship. For example, each defect on the Bugs table has a corresponding record on the CustomFieldValues table where the values of the custom fields are stored.


The table contains the following columns:

CustomFieldValueId  :  int, primary key, allows null: no, default: auto generated

The unique numeric identifier of the item.

Custom11..Custom90  :  varchar (max 100 chars), allows null: yes

The values of custom fields 11 through 90.

EntityCode  :  varchar (max 100 chars), allows null: no

The module where the custom field is used.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FKId  :  int, allows null: no

The ID of the related item (BugId, TestId, and so on).

See Also

CustomFields Table

Highlight search results