[HALTED] BrainTrust Investment Lab

BrainTrust Investment Lab › SS5 — Error Event Schema › edgar_filings

The spine of SEC EDGAR — 27.2 million filing records, the index every disclosure hangs from. Each text lane in the house derives its work queue from this one, so its completeness is proven, not presumed.

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]

edgar_filings — the SS5 walk