maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelstaging

stg_gcs__mdt_contacts

staging view 3 PII columns

Client contacts, typed and FK-validated.

Lineage Builds PII registry
Definition

Cleaned mirror of raw_gcs.mdt_contacts — buyer-side contacts on each opportunity.

10 of 10
Column
Description
Tests · PII
contact_id
UUID5 primary key.
procurement_contact +1 PII2 tests
opportunity_id
FK to stg_gcs__mdt_opportunities.
smithers_employee PII2 tests
full_name
Contact full name. Identity PII.
PII
title
Job title at the buying organisation. Not PII on its own.
email
Contact email. Contact PII.
PII
phone
Contact phone. Contact PII.
PII
is_primary
1 for the opportunity's primary contact, else 0.
source_file_url
Airbyte _ab_source_file_url.
source_file_modified_at
Airbyte source object mtime.
airbyte_extracted_at
When Airbyte extracted this row.