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 |