- Before
- Runs dozens of active studies and spends Mondays retyping lot numbers from emails. At each quarter end, chases reports, copies ship dates and checks invoices line by line.
- Now
- Confirms figures the agents read and cited, approves a drafted recovery plan in one step, and sees each study's drift on the portfolio river.
A third quarter of investigator-initiated study management, report to payment
One investigator-initiated study tests weekly home self-injection of a study drug in 24 adults with IgA nephropathy over 52 weeks, at one medical center. It was approved in study review, and from contract signature it runs here, against its baseline. Its third-quarter progress report has just arrived. Here is what happens next, screen by screen, in the working solution.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 01The morning the report arrives
38 studies on the portfolio river, one row each
ESR managerThe ESR manager opens the portfolio: 38 active investigator-initiated studies, one thin row each. Hollow marks are the baselined milestones, solid marks the actual or forecast ones, and the gap between them is the drift in weeks. Two studies sit in At risk and ten in Drifting, each band with one line from the agents on why. Needs you lists 4 reports to confirm, 3 shipments, 6 invoices, one amendment, one close-out, and a new study just arrived from review at contract signature with its baseline.
“Third quarter: 34 of your 38 reports are in and read. The study’s report has just arrived: 9 enrolled against 16 planned.”
- 02Minutes later
The quarterly progress report read, each figure cited to page 2
Quarterly report readerThe study's 3-page progress report arrives through the investigator portal, uploaded by the study coordinator. The quarterly report reader reads the enrollment table (screened 14, enrolled 9, treated 9, completed 2), each figure cited to page 2, open on the left. Against the plan of 16 enrolled by quarter end, the study is 7 behind. At 1.17 patients a month over two quarters, last patient in is forecast 30 weeks late, with a range around it, and the study moves from Drifting to At risk: seven steps in 6.4 seconds.
“Drifting → At risk · rule: more than 12 weeks late on last patient in.”
- 03Two minutes later
40 vials filled from the packing list, and a lot that expires too soon
Supply tracerThe relabeling vendor confirms dispatch of 40 vials of the study drug, sent through the vendor because the site's pharmacy cannot apply study labels. The supply tracer reads the dispatch email and packing list and fills ship date, quantity, lot, expiry, courier tracking, temperature logger and labels, each cited, nothing typed. It records the transfer of value, 40 vials × $4,850 = $194,000 of in-kind research support, and flags the lot.
“The lot expires 7 weeks before the study’s forecast last patient last visit.”
- 04Five minutes later
A later lot asked for, and the vendor's reply read
ESR managerThe ESR manager clicks Ask for a later lot. The supply tracer drafts and sends the request to the vendor, reads the reply and refills the record with a new lot whose expiry falls after the study's forecast last visit. The flag clears, and the ESR manager confirms the shipment record. Nothing was typed by hand.
“The new lot outlasts the study. Flag cleared.”
- 05Back on the report
Recovery plan approved in one step; milestone 3 held
ESR managerThe ESR manager confirms the quarter's figures and approves the drafted recovery plan with one electronic signature. Five actions, each with an owner and a date: a second site with its own investigator; referral letters to 6 community nephrology clinics; protocol amendment 2 to widen kidney function to eGFR ≥ 30, sent to the IRB; a monthly call; and milestone 3, $96,000, held until the second site is open. The drafted message to the investigator waits for the ESR manager to edit and send through the portal.
“Figures confirmed and recovery plan approved by the ESR manager · meaning: Approved · milestone 3 held.”
- 06Before the afternoon payment run
The quarter's invoice is paid because the report earned it
Invoice matcher · financeThe site's invoice asks $26,800, the per-patient fee for the 4 patients enrolled in the quarter. The invoice matcher ties it to the contract's $6,700 per enrolled patient and to the report the ESR manager confirmed, checks the $33,500 already paid against the $160,800 cap, and classifies it as a research payment for Open Payments, in the current program year, with the site's investigator named as principal investigator. The ESR manager reviews it; the finance payments approver approves it as the second person, and it goes to accounts payable by API in the afternoon run.
The invoice matcher's guardrail: “Never approves a payment.” Unearned milestones are held, and a person rejects a duplicate.
- 07An amendment arrives
Another study's follow-up doubles; the re-baseline is proposed
Amendment readerAnother study's protocol amendment 3 extends follow-up from 12 to 24 months. The amendment reader compares it with the baseline and proposes the re-baseline: last patient last visit and the final study report each move a year later, and a secondary manuscript is added. The budget rises $84,000 to $674,000. That is 14.2%, above the 10% rule, so a contract amendment is raised, and product rises by 288 bottles, flagged to the clinical supply coordinator.
The amendment reader drafts a re-baseline and does not apply it: the ESR manager proposes it, and the global ESR lead approves.
- 08The same day
A pediatric study closes early, with two signatures
Close-out assembler · medical directorA pediatric study enrolled 3 of 20 children in 22 months and missed two recovery plans, and its investigator agrees to close early. The close-out assembler builds the case: enrollment against plan, the two recovery attempts, the spend ($186,400 paid of $512,000, a final payment of $18,200, $307,400 released) and the product: 60 bottles shipped, 22 dispensed, 12 needed to finish, 26 to destroy at the site with a certificate. The ESR manager prepared it and cannot sign; the medical director has signed, and the global ESR lead signs next.
“Recommended: early close. No new patients; the 3 enrolled children finish their 52 weeks.”
- 09A final report received
A final study report read against the protocol: 11 of 12 sections
Deliverables trackerThe deliverables tracker lists 17 deliverables due in the next 120 days (interim reports, abstracts, posters, manuscripts, final study reports and registry results) and 2 overdue. It reads one completed study's 84-page final study report against the protocol's report content and finds 11 of 12 sections: the month-24 eGFR slope table is missing. That study's ClinicalTrials.gov results fall due under 42 CFR 11.44, and as an ESR collaboration its co-authorship obligations are tracked too.
The tracker does not accept a deliverable itself: the choice is “Ask for the missing table” or “Accept with a note”.
- 10Inspection
Each action on the record, exported as one inspection pack
QA auditorEach step by people and agents is on the audit trail: who, what, when, on which study, the meaning of each signature and the evidence behind it. The QA auditor exports an inspection pack for the study from its start to today: the audit trail in CSV and PDF, the electronic signature manifest with meanings, the source documents the agents cited, agent and model versions per run, the configuration versions in force, and roles and access during the period.
“For FDA and EMA inspections, internal audit and partner audits. The pack is hashed (SHA-256).”