- Before
- Spends weeks exporting a product's year into spreadsheets before she can call a single trend — then writes fourteen chapters against the clock.
- Now
- Opens a year already trended and a draft already cited; decides each finding, resolves the counts and signs. “Show me which attributes moved this year — and the batches that prove it.”
One product year, from period close to approved
PQR-2026-014 — Corventa 20 mg film-coated tablets, Plant 2 — Shannon, period Aug 1, 2025 – Jul 31, 2026, due Oct 29. 186 batches, 41 deviations, 4 OOS, 23 changes and 58 complaints. Here is what happens, screen by screen, in the working solution.
- 01Oct 7, morning
Her review year, with every 90-day clock
Priya Raman · Product quality leadPriya authors 17 of the 24 reviews. The review year shows all 24 product reviews of the 2026 cycle on a dial — 8 in progress, 16 approved — with the clocks still running. Talvexa oral solution is 9 days late, waiting on the QP. Corventa 20 mg has 22 days left, 9 of 14 chapters ready, 3 findings to decide and 1 count to reconcile.
“3 findings · owner Priya Raman · 3 findings to decide · 1 count to reconcile”
- 02Oct 1, 06:02
The whole year on one screen
The collectors and the Trend and capability analystOn Oct 1 at 06:02 the collectors pulled the closed period's 186 batches from ERP, MES, LIMS and the QMS. By 06:24 the analyst had drawn 24 small multiples — release testing, in-process controls, process and packaging, events and stability — each with its limit, centre line, capability and a trend call. Four need a decision, two are improving, eighteen are stable.
“186 batches loaded from ERP, MES, LIMS and QMS · pulled Oct 1, 06:02 · trend calls by the Trend and capability analyst, Oct 1, 06:24”
- 03Dissolution at 30 min
A shift from February, with the test and the batches
Trend and capability analystBatch mean fell from 94.1% to 89.6%: a Welch t-test on 91 against 95 batches gives Δ −4.5 points, t = −12.6, p < 0.001, and Nelson rule 2 finds 23 batches in a row below the earlier centre line. Cpk is 1.08 against the 1.33 target, down from 2.61. The change point sits on CC-26-0412, the second cellulose supplier — and one click on CV26-1017 opens its batch record: the first batch with Halvern cellulose, dissolution 91.8%.
“CV25-1188 · OOS-25-114 — rejected, left out of the SD”
- 04The contrast
The contract-made tablets show no shift
Trend and capability analystPriya switches the year to Corventa 20 mg made at Bracken Pharma Services: 72 batches, original cellulose only. Dissolution is stable — before against after Feb 9, Δ −0.2 points, p = 0.71, Cpk 1.41. Six in-process panels wait for data, because Bracken has not yet sent 2 of 6 exports; the call is made the day the data arrives.
“Bracken buys microcrystalline cellulose only from the original supplier (Avenor Fibre) — the contrast that points F1 at the new source.”
- 05Packaging
Forming depth, line 2 — and five broken tablets
Trend and capability analystForming depth on blister line 2 dropped from 4.62 to 4.41 mm after the sealing temperature was lowered from 195 to 185 °C under CC-25-0388 on Mar 30: Δ −0.21 mm, p < 0.001, Cpk 1.00 against 2.11 before. Still inside 4.20–5.00 mm — but the same batches carry five broken-tablet complaints from April to June, a cluster against a rule of 3 in 90 days.
Common factor: “Blister line 2, after CC-25-0388 (5 of 5)”.
- 06Stability
Impurity B out of trend, inside the limit
Trend and capability analystOn the 2025 annual stability batch CV25-1045 at 25 °C / 60% RH, impurity B reached 0.31% at 18 months, above the 0.29% upper bound of the 95% prediction interval. Sam Patel's OOT-26-019 found no analytical cause. The regression projects 0.42% at 36 months, upper bound 0.47%, inside the 0.5% limit.
Recommended: keep on watch, add a 21-month pull, review again at 24 months. No change to shelf-life.
- 07Chapter 4
She opens F1 and decides
Priya Raman · Product quality lead“Open F1 in chapter 4” takes her into the draft review: the critical quality attribute table with each Cpk, and the finding with its four citations. The analyst recommends a CAPA — add particle size (d50) to the incoming test for cellulose, test dissolution on every batch for 6 months, and ask MSAT to assess a supplier-specific granulation water amount. She raises it as recommended.
Her choices: “Raise CAPA as recommended” · “Watch only” · “No action — give a reason”.
- 08Chapter 10
Two systems disagree on the complaint count
Reconciliation checkerThe complaint system counts 58 complaints for the period; the QMS product link counts 57. The checker found why: CMP-26-0311, a discolouration complaint from May 2026, is linked to Corventa 40 mg in the QMS, but the batch on the complaint photo, CV26-1058, is a 20 mg batch. Priya relinks it — 58 in both systems.
A count that differs between two systems blocks sign-off until a person resolves it.
- 09Chapter 14
Sign as author, with the meaning
Priya Raman · authorWith all three findings decided — F2 a CAPA for a forming-depth check at line start-up, F3 on watch — and the counts reconciled, the signature opens. The electronic signature records who signs, the version and its meaning, and sends the review on to Dr. Omar Haddad, then Dana Okafor.
“Author — I prepared this review; its content and conclusions are accurate.”
- 10Approved · 22 days early
QP and Head of Quality sign; the review is locked
Dr. Omar Haddad and Dana OkaforThe QP signs that the review supports continued certification of Corventa 20 mg batches; the Head of Quality approves the review, its conclusions and its actions. PQR-2026-014 is locked as version 1.0 and filed on Oct 7, 22 days before its due date, with the review history drawn from the audit trail.
“Approved — PQR-2026-014 is locked and filed, 22 days before its due date”