rfx_contacts

source 3 PII columns

The people we deal with at each buying organisation.

Definition

One row per buyer-side contact at a procurement account — name, job title, email, phone, and a primary-contact flag. Carries identity PII (name/email/phone) keyed to `contact_id`; the PII columns are tagged so the manifest-driven masking + erasure rules fire end-to-end. FK-validated against `rfx_accounts` in staging.

8 of 8

Column

Description

Tests · PII

contact_id

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

mdt_client_contact +1 PII2 tests

account_id

Account this contact belongs to. String on the wire (CSV); coerced and validated against `rfx_accounts` in staging.

full_name

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

PII

title

Job title at the buying organisation. Free-text, not classified as PII on its own.

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

PII

phone

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

PII

is_primary

String "true"/"false" — set to "true" for the account's primary contact. Coerced to UInt8 (0/1) in staging.

created_at

ISO-8601 UTC timestamp the contact record was created. Parsed in staging.