Lab: One night's export, from arrival to trusted table

Module 4 · Lab · About 60 minutes · Needs: lessons 1, 2 and 3 of this module (the manifest, the contract and quarantine, the crosswalk, redaction and retention)

What you are building

Module 4 adds the engagement's data pipeline: it loads the TMS export, matches TMS and CRM customers, and redacts personal data. The lessons built each part on its own. This lab runs them as one job over one night, in the order the night needs them, and leaves files in the repository harbourline-claims. It is Thursday 2 April 2026, week 3. Until Viktor approves access, Mei emails each export, so you replay the night of Tuesday 17 March: the file that carried every trap the lessons met, including HF-88312's impossible date and HF-88320, delivered with no date. The running example is HF-88207, Atlas Office Furniture's damaged desks, declared at £6,500. All data is simulated.