BrainTrust Investment Lab › SS5 — Error Event Schema › sec_cik
sec_cik — the SS5 walk
The SEC's own identity register — 49,270 rows binding company names to CIK numbers. Identity is where financial data goes wrong first, so the resolver the star joins on is measured like a first-class source, not treated as a lookup.
One source per sheet; every step CERTIFIED or OWED by BrainTrust Staff, matched against the book’s page.
steps certified
8 of 8
step schema · the star EXISTS, measured against Figure 19-1 -- and its DDL of record is named ✓ CERTIFIED · p.458
step screen_dim · every declared screen has ONE dimension row -- closed BOTH directions against… ✓ CERTIFIED · p.459
step batch · the run is ONE batch row, and the batch ENDS ✓ CERTIFIED · p.458
step date_key · the calendar date RESOLVES -- to a dimension that exists ✓ CERTIFIED · p.458-459
step grain · EXACTLY ONE ROW PER ERROR THROWN -- and every counted defect has its row ✓ CERTIFIED · p.458
step detail_grain · the LOWER grain -- one field, in one record, per detail row ✓ CERTIFIED · p.459-460
step populate · THIS LANE'S SCREENS WRITE -- in THIS run, by a writer that exists ✓ CERTIFIED · p.460
step tables · the lane's tables measured ✓ CERTIFIED · p.[house]