IntegrityReport Table

When you click Diagnose or Fix in the Data Integrity Correction dialog box, UCS creates a table in the database, called IntegrityReport, listing all records that require repair. UCS writes into this table when it runs in diagnosis mode. Then, when it runs in repair mode, it reads and updates the table. The schema for IntegrityReport is shown below.

Note: Do not manually insert, update, or delete data in this report table.

The following table provides descriptions of the rows in the IntegrityReport table:

Column

Nullable?

Description

Id

No

Unique identifier generated by the UCS API

IssueId

No

Identifier of the issue being diagnosed or fixed; see table below.

TenantId

No

Identifier of the tenant in which this UCS database is located

DetectionDate

No

Date that this issue was last detected

CorrectionDate

Yes

Date that this issue was last fixed

FirstId

No

Depends on issue; see table below.

SecondId

Yes

Depends on issue; see table below.

Status

No

Possible values:

True—The issue is repaired.

False—The issue is not yet repaired; clicking Fix will repair it.

SessionId

No

Identifier of this session of running Data Integrity Correction

 

The following table lists possible values of some of the rows in the IntegrityReport table. "Identifier" means the identifier of this issue in the IssueId row:

Issue

Identifier

Value of FirstId

Value of SecondId

DuplicatedEmailAddressesInAContact

1

Contact Attribute ID

Contact ID

IncompatibleThreadChaining

2

Original Thread ID

Null before fix; new Thread ID after fix

OrphansInDocument

3

Document ID

Null

OrphansInAttachment

4

Attachment ID

Entity Type ID (of the nonexistent interaction)

OrphansInStandardResponseUsage

5

Standard Response Usage ID

Standard Response ID

OrphansInContactAttributes

6

Null

Contact ID

MissingContacts

7

Contact ID

Null

GhostContacts

8

Contact ID

Null

DuplicatedContacts

9

ID of the contact that is the destination of merge

ID of the contact that has been merged with the contact in FirstID

BadContactAttributes

10

Null

ID of the contact whose attribute is bad