CustomFields Table

Applies to QAComplete 12.84 SaaS, last modified on July 19, 2021

Description

The table contains information on the custom fields (their type, size, custom field labels, and so on) specified in all modules. The EntityCode value defines which module contains the custom field.

Columns

The table contains the following columns:

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

The unique identifier of the field.

CustomFieldNbr  :  smallint, allows null: no

The number of the custom field (1 through 90).

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time when the custom field was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no, default: Current date and time

The date and time when the custom field was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

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.

FieldName  :  varchar (max 30 chars), allows null: no

The name of the custom field.

FieldRule  :  varchar (max 500 chars), allows null: yes

The column is reserved for system use only.

FieldSize  :  smallint, allows null: no

The size of the defined custom field.

FieldType  :  varchar (max 30 chars), allows null: no

The type of the custom field: Check Box, Look Up, Date, Numeric, Phone, SSN, Text, and so on.

GroupId  :  int, allows null: no, default: (0)

The ID of the project where the custom field is used.

IsInternalUseOnly  :  varchar (max 1 char), allows null: yes, default: N

The column is reserved for system use only.

IsRequired  :  char (max 1 char), allows null: no, default: N

Indicates whether the custom field is required.

LookupName  :  varchar (max 100 chars), allows null: yes

A reference label for the Validations table used for choice lists. The value of the LookupName column equals the value of the Code column of the corresponding record in the Validations table.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the custom field definition.

See Also

CustomFields View
Crossmodules

Highlight search results