Glossary

Plain-English definitions of every term that appears in InsightBase: SIC codes, jurisdictions, sponsor licence ratings, etc.

3 min readReference

Plain-English definitions of terms you'll encounter in InsightBase.

Audit-locked
A daily-feed run that has been verified set-equal against Companies House and is no longer mutable. Locked days don't accept further writes.
Canonical layer
The shared CH corpus (ch_companies, ch_addresses, etc). Read by everyone, written by platform-admin paths only.
Confirmation statement (CS)
Annual filing every UK company must submit to Companies House confirming directors, address, shareholders, and PSCs are still accurate.
Daily feed
The 00:00 London-time rail that ingests every UK company incorporated yesterday.
Dynamic segment
A saved query whose members re-evaluate when new companies match. Default and recommended.
Freshness
How recently we last touched a company's profile. Tracked per-row and used to drive the refresh queue.
Jurisdiction
The legal jurisdiction the company is registered under — england-wales, scotland, northern-ireland, and overseas variants for OE-prefix entities.
OE prefix
Companies whose number starts with 'OE' are overseas entities registered with Companies House. They typically have multiple jurisdiction rows (one for england-wales, one for the home country).
PSC
Person with Significant Control. UK transparency requirement: any individual or entity controlling 25%+ of a company must be on the PSC register.
Reconciliation mismatch
When verification finds the canonical row count doesn't equal the CH-reported total for a day. Surfaces as set-not-equal and blocks audit-lock.
Set-equal
Verification result: every expected company for a day is present in canonical, no extras, no missing. The pre-condition for audit-lock.
Sponsor licence
Permission from the UK Home Office allowing a company to sponsor non-British workers under the points-based immigration system.
SIC code
Standard Industrial Classification — UK SIC 2007. A 5-digit code per industry. Sections A–U group codes into broad categories.
Stall watchdog
Cron that runs every 2 min looking for ingest runs with no row progress. Opens slow/stalled/severe alerts and auto-clears them when progress resumes.
Verification watchdog
Separate cron (every 10 min) that checks for days stuck in verification_pending and opens warning alerts. Distinct from the stall watchdog.
Workspace overlay
Per-workspace data layered on top of canonical: notes, tags, segments, watchlist, enrichment. RLS-isolated by workspace_id.

Ready to use it?

Create an InsightBase account or sign in to open this workflow inside the product.