whse_consignees

source 6 PII columns

B2C delivery recipients (consumer PII).

Definition

One row per B2C delivery recipient — the primary GDPR data subject for the DSR/erasure demo. Carries identity (full_name), contact (email/phone), and location (address_line/city/postal_code) PII keyed to `consignee_id`, all tagged so masking + erasure fire end-to-end. Never surfaces raw via the AI layer (mart_order_outcomes de-identifies). `country` is coarse and not PII on its own.

10 of 10

Column

Description

Tests · PII

consignee_id

UUID5 — primary key on the source side. Stable across re-syncs.

consignee PII2 tests

full_name

Consignee full name. Identity PII; erased via `nullify`.

PII

Consignee email address. Contact PII; erased via `nullify`.

PII

phone

Consignee phone number. Contact PII; erased via `nullify`.

PII

address_line

Consignee street address. Location PII; erased via `nullify`.

PII

city

Consignee city. Location PII; erased via `nullify`.

PII

postal_code

Consignee postal code. Location PII; erased via `nullify`.

PII

country

ISO-3166 alpha-2 country. Coarse — not PII on its own.

consignee_type

Recipient type — `consumer`, `business` (B2C vs B2B2B drop).

created_at

UTC timestamp the consignee record was created. Parsed to DateTime64(3) in staging.