maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Ephemeral join — flattens otif_target_pct, pick_accuracy_target_pct, dock_to_stock_target_hrs, and billing_model onto one row per contract, decorated with client segment/tier/name, site region/type/certs, and capacity. Aliases raw start_date → term_start, end_date → term_end (INC-06); site_region coalesces raw sites.region (INC-08). Derives is_active (term_start ≤ logistics_as_of AND (term_end IS NULL OR term_end ≥ logistics_as_of) — fixed anchor, never the wall clock). Inlined into mart_client_scorecard + mart_site_performance.
24 of 24
Column
Description
Tests · PII
contract_id
From stg_gcs__whse_contracts.contract_id. Primary key.
2 tests
site_id
Contracted site FK. From staging.
contract_ref
Human contract ref. From staging.
billing_model
open_book / fixed_fee / cost_plus / activity_based. From staging.
otif_target_pct
SLA OTIF target. From staging.
pick_accuracy_target_pct
SLA pick-accuracy target. From staging.
dock_to_stock_target_hrs
SLA dock-to-stock target. From staging.
term_start
Alias of raw start_date (INC-06). Contract term start.
term_end
Alias of raw end_date (INC-06). Contract term end. Nullable.
monthly_fee_eur
Recurring fee, Decimal(14,2). From staging.
client_name
Brand tenant name (a company — not PII). From stg_gcs__whse_clients (LEFT JOIN).
client_segment
Client segment (raw client_segment, INC-07); coalesced to 'unknown'.
client_tier
Client tier (strategic / key / standard). From stg_gcs__whse_clients (LEFT JOIN).
site_region
coalesce(sites.region, 'unknown') (INC-08).
site_name
Site display name. From stg_gcs__whse_sites (LEFT JOIN).
country
Site ISO country. From stg_gcs__whse_sites (LEFT JOIN).
site_type
multi_user / dedicated / in_house. From stg_gcs__whse_sites (LEFT JOIN).
automation
autostore / shuttle / manual. From stg_gcs__whse_sites (LEFT JOIN).
capacity_m2
Gross storage capacity (m²). From stg_gcs__whse_sites (LEFT JOIN).
cert_gdp
GDP (pharma cold-chain) certified (1/0). From stg_gcs__whse_sites (LEFT JOIN).
cert_iso27001
ISO 27001 certified (1/0). From stg_gcs__whse_sites (LEFT JOIN).
cert_hazmat
Hazmat/ADR-licensed (1/0). From stg_gcs__whse_sites (LEFT JOIN).
is_active
Derived toUInt8(in term against logistics_as_of). Fixed anchor, never the wall clock.