metrics_data_adjustments

-1 rows


Description

System table which identifies consistency and possible missing data across the metrics database transactional tables

Columns

Column Type Size Nulls Auto Default Children Parents Comments
table_name text 2147483647 null

Name of the table checked, or health check which was run

missing int4 10 null

The count of missing IDs from metrics (may not apply to some checks)

missing_ids text 2147483647 null

Comma separated list of missing IDs from metrics (may not apply to some checks)

missing_value numeric 12,2 null

The difference between two sources (can be negative) where a numeric difference is in scope. Null for a missing id

description text 2147483647 null

A description of the load failure or reason for descrepancy between the two sources

adjustment_timestamp timestamptz 35,6 null

When the data adjustment first occured

Relationships