maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Per-snapshot product enrichment. Adds `category` (coalesced to `'unknown'`) and `is_stockout` (on_hand_qty = 0). Otherwise a pass-through of the staging snapshot row.
11 of 11
Column
Description
Tests · PII
snapshot_id
From staging. Primary key.
product_id
From staging.
category
From `stg_postgres__products.category` (LEFT JOIN). Coalesced to `'unknown'`.
warehouse_code
From staging.
snapshot_date
From staging.
on_hand_qty
From staging.
reserved_qty
From staging.
reorder_point
From staging.
available_qty
From staging — `on_hand - reserved`.
under_reorder
From staging — `on_hand <= reorder_point`.
is_stockout
Derived — `on_hand_qty = 0`.