Field Integrity

The following table describes the audit queries and resolutions for this area:

Query Description Resolution

FIELD-3

This query lists invalid default fields.

Modify the default value in record field properties.

FIELD-4

This query lists fields that are used in record definitions but do not exist in PSDBFIELD.

Define the field in Application Designer.

FIELD-5

This query lists fields that have multiple default field labels in PSDBFLDLABL.

Open the field, select the default label, and save.

FIELD-06

This query lists deleted fields that have orphaned field labels in PSDBFLDLABL.

Run this SQL: 

DELETE FROM PSDBFLDLABL
WHERE FIELDNAME NOT IN
 (SELECT FIELDNAME
  FROM PSDBFIELD)