ENTITYSTATISTICS

The ENTITYSTATISTICS table stores hourly aggregated statistics data about entities stored in the system.

This table is used by the following domains.
Name Comment Datatype Null Option Is PK
ENTITY_STATISTICS_ID A unique, system-generated key that identifies an entity statistics record in the system. BIGINT NOT NULL Yes
CREATED_DT The date when this record is created. TIMESTAMP NOT NULL No
SOURCE Identifies the source system where the statistics record is from. VARCHAR(255) NULL No
ENTITY_TP_CD Identifies the entity type of this statistics record. BIGINT NOT NULL No
ADD_COUNT The total count of added entities in an hour for a type of entity. BIGINT NULL No
UPDATE_COUNT The total count of updated entities in an hour for a given type of entity. BIGINT NULL No
INACTIVE_COUNT The total count of inactivated entities in an hour for a given type of entity. BIGINT NULL No
DELETE_COUNT The total count of deleted entities in an hour for a given type of entity. BIGINT NULL No
SUSPECT_CREATED_COUNT The total count of suspected duplicates created in an hour for a given type of entity. BIGINT NULL No
SUSPECT_RESOLVED_COUNT The total count of suspected duplicates resolved in an hour for a given type of entity. BIGINT NULL No
LAST_UPDATE_DT When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field. If it does not, then the update fails. TIMESTAMP NOT NULL No