maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
The site dimension for the warehousing domain — one row per warehouse across the EU/UK/NA/APAC network with type, automation, capacity, and three certification flags (GDP / ISO27001 / hazmat). The raw column is `region`; the mart/metric/ontology dimension `site_region` is a coalesced alias of it. No `certifications` string or `temp_capabilities` column exists — cert state is the three UInt8 flags.
12 of 12
Column
Description
Tests · PII
site_id
UUID5 — primary key on the source side. Stable across re-syncs.
2 tests
site_code
Short human site code, e.g. `DE-HAM-01`. Free-text.
site_name
Human-readable site name, e.g. "Hamburg Süd DC". Free-text.
country
ISO-3166 alpha-2 country code of the site.
region
Site region — `EU`, `UK`, `NA`, `APAC`. RAW name is `region`; aliased to `site_region` downstream (INC-08).
site_type
Site type — `multi_user`, `dedicated`, `in_house`.
capacity_m2
Gross floor area in m². Coerced to Int32 in staging.
automation
Automation level — `autostore`, `shuttle`, `manual`.
cert_gdp
GDP (pharma cold-chain) certified. String "true"/"false" → UInt8 (0/1).
cert_iso27001
ISO 27001 certified. String "true"/"false" → UInt8 (0/1).
cert_hazmat
ADR/hazmat-licensed. String "true"/"false" → UInt8 (0/1).
opened_date
ISO-8601 date the site opened. Coerced to Date in staging.