- Before
- Spends most of each review exporting records from six tools before he can judge anything.
- Now
- Opens a drafted review with every statement cited, decides the findings, chooses the conclusion and signs.
One system’s year, from opened to signed
ChromaVault CDS, the chromatography data system at Plant 3 — Leiden, is high risk and due its yearly review on Oct 15. Here is the review, screen by screen, in the working solution.
- 01Morning, Oct 7
The whole review programme on one screen
Omar Haddad · IT Quality leadOmar opens the review year: 64 GxP systems, 5 reviews due in the next 30 days, 2 overdue, 3 drafts ready for him, and 78 % signed on time over the last 12 months. Every validated system’s next review sits on a calendar by risk tier.
Overnight, 06:00: “Review scheduler marked ChromaVault CDS (Leiden) ready to gather — its last period records were signed Oct 5.”
- 02Opened 21 days ahead
The review opens itself, with last year’s actions linked
Review schedulerOn Sep 24 the scheduler opened PR-2026-031 — period Oct 1, 2025 to Sep 30, 2026, due Oct 15 — and linked the previous review, PR-2025-027, with its two actions. On Oct 7 it saw the last records of the period signed: the Q3 access review on Oct 3 and the September audit-trail review on Oct 5.
“A year of ChromaVault CDS lives in six places.”
- 03One click
“Gather evidence and draft” — and the agents read the year
Omar Haddad · IT Quality leadThe change and incident reader reads 37 changes, 14 incidents and 2 problems. The quality record reader reads 3 deviations, 2 CAPAs and 2 prior actions. The access and backup checker reads 4 access reviews, 86 accounts, 363 backups and 2 restore tests; the audit-trail review checker reads 12 monthly reviews and finds 1 missed.
“Read-only connections · nothing is changed in the source tools.”
- 04Draft ready
The year in one view, and ten sections drafted
The agents20 criteria checked, 4 findings, 3 observations; 10 sections and 35 citations from 26 records. The year sits on one timeline — changes, incidents, deviations, access reviews, backups and audit-trail reviews — with a red ring on every mark that became a finding.
- 05Section 3
36 of 37 changes verified — and the one that wasn’t
Change & incident reader31 standard, 4 normal and 2 emergency changes. The upgrade to release 2026.1 was validated and verified after go-live; the August emergency patch was verified the next day. The June emergency driver hotfix, CHG0048211, was closed without its post-implementation verification — finding F-1, Medium, proposed to Dr. Maya Chen, due Nov 6.
- 06Click the citation
Every statement opens on its record
Omar Haddad · IT Quality leadOmar clicks the citation and the change record opens beside the draft, the passage highlighted: the driver was deployed to all 46 instruments, and the close note says the verification is still to come. The record was read from IT service management on Oct 7 at 06:00 and kept unchanged.
“Post-implementation verification: to be attached.”
- 07Section 6
Two leavers, active for 41 days
Access & backup checkerThe Q2 access review was completed 23 days late and removed two analysts who left on Jun 20; their accounts stayed active for 41 days, with no logins after leaving. The root cause, from DEV-2026-0412: the HR leaver feed is not connected, so removal depends on a manual ticket. Finding F-2 is High — already covered by CAPA-2026-077, due Nov 30, with a check of leavers every two weeks until then.
The shared administrator account cv_admin was last year’s action A-2, still open — so it comes back as finding F-3.
- 08Section 8
Eleven of twelve audit-trail reviews — and why one was missed
Audit-trail review checkerThe reviews work: February’s found a sample set reprocessed three times without a reason, and its CAPA was checked effective. August’s was not performed during the plant shutdown and was caught up on Sep 12 with no anomalies. SOP-QC-0311 §6.4 sets a monthly review but has no rule for shutdowns — finding F-4, Low, for Priya Raman.
- 09Decided
Four actions raised, one conclusion chosen
Omar Haddad · IT Quality leadFor each finding Omar picks Not a finding, Accept with rationale or Raise action; he raises all four. The review writer proposes “Validated, with 4 actions” — none of the findings changed a reported result — and keeping the yearly frequency, because the High finding already has a CAPA. Next review due Oct 15, 2027.
The review writer proposes; the IT Quality reviewer and the system owner decide and sign.
- 10Signed · 8 days before due
Signed, sent for approval, and the actions raised
Omar Haddad · IT Quality leadOmar signs with his name, password and the meaning “Reviewed — I reviewed the evidence and agree the conclusion”, bound to this version of the record. The review goes to Dr. Maya Chen, the system owner, for her approval, and the four actions are raised in the quality system as CAPA tasks with owner and due date.