int_rfx__opportunity_enriched

intermediate ephemeral 1 PII columns

Opportunities, decorated with account + owning SME.

Definition

Ephemeral join — attaches account attributes (account_name, segment, tier, annual_revenue_band) and the owning SME's name + department to each RFX opportunity, keeping the derived `issued_month`. Account and SME are LEFT-joined, so an opportunity whose FK is missing surfaces NULL (coalesced to `unassigned` / `unknown` for the SME columns) rather than dropping the row — the relationships tests in staging are what flag the bad FK. Inlined into `mart_rfx_pipeline`.

21 of 21

Column

Description

Tests · PII

rfx_id

From `stg_gcs__rfx_opportunities.rfx_id`. Primary key.

2 tests

account_id

From `stg_gcs__rfx_opportunities.account_id`. FK to the account.

account_name

Account display name. From `stg_gcs__rfx_accounts.account_name` via LEFT JOIN — Nullable if the account row is missing.

segment

Account sales segment (enterprise / mid / smb). From `stg_gcs__rfx_accounts.segment` (LEFT JOIN).

tier

Account tier (strategic / key / standard). From `stg_gcs__rfx_accounts.tier` (LEFT JOIN).

annual_revenue_band

Account revenue band. From `stg_gcs__rfx_accounts.annual_revenue_band` (LEFT JOIN).

owner_sme_id

From `stg_gcs__rfx_opportunities.owner_sme_id`. FK to the owning SME.

owner_sme_name

Owning SME's full name. From `stg_gcs__rfx_sme_directory.full_name` (LEFT JOIN); coalesced to `'unassigned'`. PII — name.

PII

owner_department

Owning SME's department. From `stg_gcs__rfx_sme_directory.department` (LEFT JOIN); coalesced to `'unknown'`.

rfx_type

`RFP` / `RFQ` / `RFI`. From staging.

title

Opportunity title. From staging.

industry

Opportunity industry (mirrors the account). From staging.

region

`NA` / `EMEA` / `APAC` / `LATAM`. From staging.

issued_date

Date the RFX was issued. From staging.

due_date

Submission deadline. From staging.

est_value

Estimated deal size, Decimal(14,2). From staging.

currency

`USD` / `EUR` / `GBP`. From staging.

stage

Pipeline stage (qualifying / in_progress / submitted / won / lost / no_bid). From staging.

probability

Win probability 0..100, UInt8. From staging.

source

Origination channel (inbound / portal / referral / existing_customer). From staging.

issued_month

Derived `toStartOfMonth(issued_date)` carried through from staging. Pipeline grain key.