BrainTrust Investment Lab › SS5 — Error Event Schema › companyfacts
companyfacts — the SS5 walk
The fundamentals backbone: 123.8 million reported facts from the SEC's own XBRL archive — every value a company ever filed, kept as filed. The walk proved the seven-part key duplicate-free across all 123,831,691 rows, found the provider's garbage (period ends in the year 6016 — really), and tagged every flaw with a signed screen instead of a quiet fix. Restatements are never averaged away: the filing date is the truth-clock, so you get each number as it was known, not as it was corrected later.
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]