This is a ready-to-use register for a regulatory intelligence program: the structured record where each external signal is coded and tracked from capture to closed action. The data model matters more than the platform; keep the fields below whether the register lives in a validated application or a controlled spreadsheet. Replace every <<FILL: ...>> placeholder. A field-definition table, a blank row, and a filled specimen follow.
Register control
| Field | Entry |
|---|---|
| Register number | <<FILL: LOG-ID, e.g. REG-QA-051>> |
| Parent SOP | <<FILL: SOP-ID for the RI program>> |
| Owner | <<FILL: RI lead>> |
| System / location | <<FILL: validated app or controlled spreadsheet ID>> |
| Access control | <<FILL: who can add / edit / read>> |
If the register is a spreadsheet used for GxP decisions, it is a computerized system that needs proportionate control (access, audit trail or version history, backup). Do not let an uncontrolled macro drive quality decisions.
Field definitions
| Field | Format | Required | Who enters | When |
|---|---|---|---|---|
| Signal ID | RI-YYYY-nnn | Yes | RI analyst | At capture |
| Document type | 483 / WL / EIR / EU-UK deficiency / Guidance | Yes | RI analyst | At capture |
| Issue date | date | Yes | RI analyst | At capture |
| Issuing authority / office | text | Yes | RI analyst | At capture |
| Product / firm type | text (no confidential detail) | Yes | RI analyst | At capture |
| Cited regulation(s) | text | Yes | RI analyst | At coding |
| Failure theme | controlled taxonomy | Yes | RI analyst / SME | At coding |
| Mechanism | free text (verbatim where possible) | Yes | RI analyst | At coding |
| Escalation outcome | 483 closed / OAI / WL / import alert / other | Yes | RI analyst | At coding / update |
| Applicability | Applicable / Monitor / Not applicable | Yes | SME / RI lead | After assessment |
| Applicability record | form ref | Yes | RI analyst | After assessment |
| Linked CAPA | CAPA number | If applicable | Process owner | On action |
| Linked change control | CC number | If applicable | Process owner | On action |
| Risk register entry | ref | If applicable | Process owner | On action |
| Status | Open / Monitoring / Actioned / Closed | Yes | RI lead | Ongoing |
| Effectiveness verified | Yes / No / N/A | Yes | QA | At closure |
Register table (blank)
| Signal ID | Doc type | Date | Cited reg | Failure theme | Mechanism | Escalation | Applicability | Linked CAPA / CC | Status | Eff. verified |
|---|---|---|---|---|---|---|---|---|---|---|
<<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> |
Trend view (derived, for the quarterly report)
Summarize the register by theme each period. Keep the taxonomy stable so counts trend across quarters. Weight warning-letter and OAI outcomes more heavily than routine 483 observations.
| Failure theme | Prior period count | Current period count | Share of total | Direction | Escalation-weighted flag |
|---|---|---|---|---|---|
<<FILL>> | <<FILL>> | <<FILL>> | <<FILL>> | Rising / Stable / Falling | <<FILL>> |
Filled specimen
Illustrative rows for one quarter. Company, numbers, and names are examples only.
| Signal ID | Doc type | Date | Cited reg | Failure theme | Mechanism | Escalation | Applicability | Linked CAPA / CC | Status | Eff. verified |
|---|---|---|---|---|---|---|---|---|---|---|
| RI-2026-047 | WL | 14 May 2026 | 211.194(a), Part 11 | DI: audit trail review | AT review excluded from data review; no retrospective batch review | Warning Letter | Applicable | CAPA-2026-0188 / CC-2026-0140 | Actioned | No (check at 90d) |
| RI-2026-048 | 483 | 02 May 2026 | 211.192 | OOS / investigation | 14 of 22 OOS invalidated without lab-phase justification | 483 (EIR pending) | Applicable | CAPA-2026-0190 | Open | N/A |
| RI-2026-049 | WL | 09 May 2026 | 211.42, 211.113 | Aseptic / EM excursions | EM excursions trended but not investigated | Warning Letter | Not applicable | N/A (no sterile ops) | Closed | N/A |
| RI-2026-050 | EU deficiency | 20 Apr 2026 | EU GDP guideline | Cold-chain excursion disposition | Excursed lots released on blanket stability statement | Non-compliance | Monitor | N/A | Monitoring | N/A |
Trend view for the quarter:
| Failure theme | Prior period count | Current period count | Share of total | Direction | Escalation-weighted flag |
|---|---|---|---|---|---|
| DI: audit trail review | 3 | 6 | 24% | Rising | Yes (2 WL) |
| OOS / investigation | 7 | 7 | 28% | Stable, high | Yes (1 OAI) |
| Aseptic / EM | 2 | 4 | 16% | Rising | Yes (1 WL) |
Note how RI-2026-049 is retained as a closed Not-applicable entry with its rationale (“no sterile ops”), which is exactly the record that defends the program when an inspector asks why the firm did not act on a contamination-control trend.
Common inspection findings this register prevents
- Signals collected but never coded to a mechanism, so trends cannot be built.
- Applicable signals with no linked CAPA or change record (no closed loop).
- Not-applicable decisions absent from the record, leaving the triage undefendable.
- A changing taxonomy that breaks period-over-period trending.
- An uncontrolled spreadsheet driving GxP decisions with no access control or version history.
How to adapt this register
- Set the register number, owner, and access controls in the control block.
- Load your controlled failure-theme taxonomy into the Failure theme field as a picklist.
- Wire the linked-CAPA and linked-CC fields to your real quality-system identifiers.
- Automate the trend view from the register data rather than re-keying counts each quarter.
- If the register is a spreadsheet, apply proportionate validation and access control before it drives decisions.