mdt_opportunities

source

One RFQ opportunity per Smithers job reference.

Definition

The opportunity dimension for the testing-services domain — one row per Smithers job reference (e.g. 24-1005376HG), with client, region, entity, study type, and the RFQ→submission date chain.

6 of 6

Column

Description

Tests · PII

opportunity_id

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

smithers_employee PII2 tests

reference_id

Smithers job reference, verbatim (e.g. 24-1005376HG).

client_name

Client legal entity name. Confidential-commercial (GSK, Kashiv, Ypsomed).

bdm_lead

Smithers commercial/BDM lead. Identity PII; erased via nullify.

te_lead

Smithers technical lead. Identity PII; erased via nullify.

pm_lead

Smithers project-manager lead. Identity PII; erased via nullify.