maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per temperature excursion against a chilled/frozen lot with denormalized site + client, start/end timestamps, min/max/ threshold temperatures, duration, disposition, and a resolved-within-SLA flag. Staging-only in P0/P1 — cold-chain compliance is reached via catalog/BI preview + search_documents, not query_metric/query_records. Retention anchor: legal_obligation, 1825 days (GDP ~5yr).
12 of 12
Column
Description
Tests · PII
event_id
UUID5 — primary key on the source side. Stable across re-syncs.
2 tests
lot_id
The lot the excursion occurred against. String on the wire; coerced and validated against `whse_inventory` in staging.
site_id
Denormalized site (from the lot). String on the wire.
client_id
Denormalized owning client (from the lot), carried so compliance queries can scope. String on the wire.
event_start
Excursion start timestamp. Parsed to DateTime64(3) in staging.
event_end
Excursion end timestamp. Parsed to Nullable(DateTime64(3)); null while ongoing.
min_temp_c
Minimum temperature during the excursion, °C. Coerced to Decimal(5,2) in staging.
max_temp_c
Maximum temperature during the excursion, °C. Coerced to Decimal(5,2) in staging.
threshold_temp_c
The lot's allowed ceiling temperature (from temp_class), °C. Coerced to Decimal(5,2) in staging.
duration_min
Excursion length in minutes. Coerced to Int32 in staging.
disposition
Excursion disposition — `released`, `quarantined`, `scrapped`.
resolved_within_sla
1 if closed inside the compliance SLA window, else 0. Coerced from "true"/"false" → UInt8.