Standard Operating Procedure for Trending of Analytical Results in API Manufacturing
| Department | API Manufacturing |
|---|---|
| SOP No. | SOP/API/154/2025 |
| Supersedes | SOP/API/154/2022 |
| Page No. | Page 1 of 10 |
| Issue Date | 14/04/2025 |
| Effective Date | 16/04/2025 |
| Review Date | 14/04/2026 |
1. Purpose
To establish a structured methodology for monitoring, evaluating, and trending analytical data from laboratory tests for raw materials, intermediates, and APIs to detect potential variations or changes over time that could impact quality.
2. Scope
This SOP applies to analytical results generated for routine quality control testing of raw materials, intermediates, and final API products at the API manufacturing facility.
3. Responsibilities
- QC Analyst: Record analytical data in approved formats and upload values into the trending spreadsheet/database.
- QC Reviewer: Verify accuracy and completeness of data used for trending.
- QA Officer: Periodically review trended data and initiate investigations when statistical deviations or shifts are observed.
4. Accountability
The Head of Quality Control is accountable for implementation, review, and continual improvement of the analytical data trending program.
5. Procedure
5.1 Data Collection and Organization
- Analytical results from tests such as assay, moisture, impurities, and pH shall be recorded in a central trending format (e.g., Excel, validated software).
- Each data point should include:
- Batch number
- Lab number
- Test result
- Date of analysis
- Analyst name
- Data shall be compiled weekly or after completion of each lot analysis.
5.2 Trending Frequency
- Trending shall be performed:
- Monthly for API batches
- Quarterly for raw materials and intermediates
- Annually for stability samples
- In case of new products, trending shall be done per batch until process is validated.
5.3 Statistical Evaluation
- For each parameter, calculate the following:
- Mean (average)
- Standard Deviation (SD)
- Upper and Lower Control Limits (UCL/LCL)
- Use control charts (Annexure-1) to visualize trends and detect outliers.
- Apply rules for identifying:
- Shift – 7 consecutive points on one side of the mean
- Trend – 6 consecutive points increasing or decreasing
- Outlier – Any point outside ±3 SD
5.4 Out-of-Trend (OOT) Handling
- If a result appears as an outlier or displays a shift/trend:
- Record in the OOT Register (Annexure-2)
- Initiate investigation using the Out-of-Trend Investigation Form
- Assess impact on product quality
- OOT events must be evaluated within 7 working days of detection.
5.5 Reporting and Review
- Summarize trends monthly and submit report to QA and production teams.
- Include in Product Quality Review (PQR) and process validation documents.
- Flag repetitive trends or deviations for CAPA implementation.
5.6 Software and System Requirements
- Only validated systems shall be used for digital trending (e.g., Empower, LIMS, or Excel with audit trail).
- Access to trend files shall be restricted to QC, QA, and authorized personnel.
- Maintain backup of digital records as per data retention SOP.
6. Abbreviations
- OOT: Out of Trend
- SD: Standard Deviation
- QA: Quality Assurance
- QC: Quality Control
- UCL: Upper Control Limit
- LCL: Lower Control Limit
7. Documents
- Trend Monitoring Spreadsheet or Software Output
- Control Charts (Annexure-1)
- OOT Register (Annexure-2)
- OOT Investigation Form
- PQR Reports
8. References
- ICH Q10 – Pharmaceutical Quality System
- ICH Q9 – Quality Risk Management
- WHO Technical Report Series 996
9. SOP Version
Version: 2.0
10. Approval Section
| Prepared By | Checked By | Approved By | |
|---|---|---|---|
| Signature | |||
| Date | |||
| Name | |||
| Designation | |||
| Department |
11. Annexures
Annexure-1: Control Chart Template
| Batch No. | Test Date | Result | Mean | UCL | LCL | Remarks |
|---|---|---|---|---|---|---|
| BCH001 | 01/03/2025 | 98.6% | 98.8% | 100.2% | 97.4% | Within range |
Annexure-2: OOT Register
| Date | Parameter | Batch No. | Result | Trend Type | Investigation Status |
|---|---|---|---|---|---|
| 10/04/2025 | Assay | BCH028 | 101.1% | Outlier | Open |
Revision History:
| Revision Date | Revision No. | Details | Reason | Approved By |
|---|---|---|---|---|
| 01/01/2022 | 1.0 | Initial version | New guideline implementation | QA Head |
| 14/04/2025 | 2.0 | Added statistical tools and electronic trending system | Audit recommendation | QA Head |