- Before
- Finds out what was missing at the last quarterly QC review, works a backlog of thousands by hand and keeps the expected-document list in a spreadsheet.
- Now
- Sees what is missing today, site by site and zone by zone, confirms only the filings the agents were unsure of, and signs each one.
One site, one staff change, one morning
VLT-302 is a Phase 3, randomised, double-blind study of Veltrimab in moderate-to-severe plaque psoriasis — 46 sites in 12 countries, run under a US IND. Here is what Lena Ortiz, its TMF lead, sees and does, screen by screen, in the working solution.
- 0106:00
The whole file on one heatmap
Lena Ortiz · TMF lead and QC reviewerTMF Reference Model zones run down the side, sites across. The completeness checker scored every cell at 06:00: the study is 94.2% complete, 33 of 46 sites are ready in every zone and 37 gaps are open. Trial-level zones show a dash — they are filed once for the study — and late filings carry a red dot. The side panel lists the five weakest cells, Site 114 first.
“Each cell counts only the documents a site should have by today.”
- 02Hatched cells
Blank is not missing
Completeness checkerSite 144 in Phoenix was activated on 29 Sep. Its Zone 06 cell is hatched, not red: the first IP shipment is planned for 14 Oct, so nothing in IP and Trial Supplies is due yet. Local lab documents become due at first patient, planned for 27 Oct, and visit reports after the first monitoring visit on 3 Nov.
“The cell turns on when that milestone is reached — until then a blank is not a gap.”
- 03One click
Site 114, Zone 05: 67% complete, 75% on time
Lena Ortiz · TMF lead and QC reviewerHarbourview Research Centre in Rotterdam has 12 of the 18 Site Management documents expected by today. The milestone strip shows why 18 are expected — selected 9 Mar, activated 30 Jun, first patient 14 Jul, a sub-investigator added 15 Sep, Visit 3 on 22 Sep — and 7 more are not expected yet. Five are missing, and three were filed late, the worst Dr. Elena Varga's Form FDA 1572: signed 12 Jun, filed 14 Sep, 94 days.
- 04The evidence
A staff change found inside a visit report
Completeness checkerNo spreadsheet knew Dr. Pieter Janssen had joined. The checker read it on page 3 of the Visit 3 monitoring report: he joined as Sub-Investigator on 15 Sep and performed PASI and IGA assessments for two subjects. It set that against delegation log v1, which has no entry for him, and section 6.3 of the VLT-302 TMF Plan v2.1, then opened gap G-1052 with each passage one click away.
Visit 3 report: “The Site Signature and Delegation Log has not yet been updated to include Dr. Janssen.”
- 05One step
Four gaps to the site's CRA
Lena Ortiz · TMF lead and QC reviewerThe Zone 05 owner rule suggests Omar Haddad, the CRA for Sites 114 and 116. Lena assigns the delegation log v2 with the three gaps that go with it — Dr. Janssen's CV, GCP certificate and financial disclosure — due 13 Oct 2026, with a note on what to collect. For the late 1572, the gap follow-up agent drafts a request to Dr. Varga for a note to file.
“Nothing is sent until you press Send.”
- 06The register
Every gap with an owner, a stage and a due date
Omar Haddad · CRA, Netherlands and GermanyThe four Site 114 gaps now sit with Omar, assigned and requested. The register shows the 14 most urgent of the 37 open: Site 107's local lab normal ranges and lab certificate, 28 days open and overdue since 2 Oct, chased by Dana Okafor; Site 119's August temperature log with Ewa Nowak; a missing return record for expired IP kits at Site 129.
- 07Re-derived
Nine rules turn milestones into due dates
Completeness checkerThe expected-document list is rules from TMF Plan v2.1 and SOP TMF-104: when a site is activated, a staff member is added, an investigator signs a 1572, an amendment is approved, IP kits expire, a visit is held, a month of enrolment closes, IP ships or a site closes out, these documents are due by then. Re-deriving for 46 sites reads the milestones, applies the 9 rules and compares the result with the filed TMF.
“38,655 documents expected across 46 sites today · 1,214 more will become due at future milestones.”
- 08Batch 0412
240 new documents, read and filed
Classifier and Metadata extractorThe batch arrived at 08:12 from the site upload portal (162), the vendor file drop (51) and CRA email (27): 612 pages. The classifier matched each document to a TMF Reference Model v3.3.1 artifact; the metadata extractor read site, document date, version, signatures and people named. 228 were filed at 90% confidence or more, 6 held for a QC reviewer and 6 set aside — 4 duplicates found by content and 2 that are not trial documents.
“Site 114 is still red in Zone 05 Site Management: the delegation log v2 was not in this batch.”
- 09To confirm
A letter that looks like a report — 64% confident
ClassifierThe Visit 3 follow-up letter came in titled “Site Visit Summary”, which visit reports often use, so 29% went to Monitoring Visit Report. But it is a letter to the PI with agreed action items, and it says the full visit report is held by the sponsor. The classifier puts it at 05.04.04 Monitoring Visit Follow-up Letter, highlights every passage it relied on, and holds it for Lena.
- 10Signed
She confirms the filing with her signature
Lena Ortiz · TMF lead and QC reviewerLena files the letter to 05.04.04 with the meaning of her signature — “Reviewed — filing and details are correct”. Site 114 Zone 05 moves from 67% to 72%, 13 of 18 expected documents. The delegation log v2 is still with Omar, and the cell stays red until it arrives and passes QC.
“Your signature, the time and the reason are written to the audit trail and cannot be changed.”