Reklamspärr

Swedish: “advertising block”. A flag in the SCB registry indicating an organisation has opted out of receiving direct marketing.

Source: docs/SYSTEM_OVERVIEW.md § GDPR → Reklamspärr.

Source data

• SCB TSV bulk file, column Reklam (index 20)
• Value "2" → opt-out from marketing
• Mapped to scb_foundations.advertising_block (BOOLEAN) at import time. See SCB Import.

Code

// src/compliance/reklamsparre.ts
export async function isScbAdvertisingBlocked(orgNr: string): Promise<boolean> {
  const rows = await sql`
    SELECT advertising_block FROM scb_foundations WHERE org_nr = ${orgNr}
  `;
  return rows[0]?.advertising_block === true;
}

Where enforced

Called at step 1 of EnrichV7. If true, returns { enrichment_status: 'blocked', lead_score: 0 } and logs a SKIP entry to RoPA Log.

P0 — Not enforced in queue workers

Warning

src/queues/workers.ts does NOT call isScbAdvertisingBlocked() before enqueueing Enrich_Job. Companies with advertising_block = true get queued and only get blocked once the enrichment worker reaches step 1 of enrichV7. The check should also run in Scrape_Job to avoid wasted work — and more importantly, to avoid any edge case where the enrichment skips step 1. GDPR compliance gap. See Pipeline and Known Issues.

See also

GDPR Legitimate Interest, Pipeline, EnrichV7, SCB Import, RoPA Log, Known Issues.

See also

• Compliance MOC