蒲公英 - 制药技术的传播者 GMP理论的实践者

搜索
楼主: 恨我不成钢
收起左侧

[数据完整性] Excel电子表格验证模板(RA、URS、DQ、IQ、OQ、PQ、SOP)

  [复制链接]
发表于 2018-11-5 13:21:43 | 显示全部楼层
好资料,多谢分享
回复

使用道具 举报

药徒
发表于 2018-11-5 14:02:24 | 显示全部楼层
感谢楼主分享~这个真是让人头大呀...
回复

使用道具 举报

药徒
发表于 2018-11-5 14:21:07 | 显示全部楼层
EXCEL表格如果涉及方程或具体的计算的话,需要进行验证,
如果用EXCEL进行简单的文字记录,没必要做验证吧。
以上纯属个人意见,谢谢!
回复

使用道具 举报

发表于 2018-11-9 11:48:54 | 显示全部楼层
回复

使用道具 举报

药徒
发表于 2018-11-13 11:43:54 | 显示全部楼层
回复

使用道具 举报

发表于 2018-11-15 14:08:13 | 显示全部楼层
看得人脑仁疼,好复杂的样子。学习了
回复

使用道具 举报

药徒
发表于 2018-11-21 10:35:49 | 显示全部楼层
收藏了。。!!!
回复

使用道具 举报

药徒
发表于 2018-11-21 12:51:59 | 显示全部楼层
感谢分享,学习学习
回复

使用道具 举报

药徒
发表于 2018-11-21 13:08:07 | 显示全部楼层
谢谢分享,很实用~~~~
回复

使用道具 举报

药生
发表于 2018-11-21 13:15:45 | 显示全部楼层
粗略看了一下,很牛掰的资料,谢谢分享。
回复

使用道具 举报

药徒
发表于 2018-11-21 13:24:44 | 显示全部楼层
写得很好,谢谢分享
回复

使用道具 举报

药徒
发表于 2018-11-21 13:28:45 | 显示全部楼层
感谢分享!
回复

使用道具 举报

发表于 2018-11-22 12:35:36 | 显示全部楼层
Excel验证,这标题一出,能吓倒一片人,也可能让一些企业付出很多不必要的精力。按照这个套路,windows系统,网络传输协议,甚至电信运营商 要不要验证?

有人可能用FDA警告信反驳,提前摘录如下:
FDA警告信:年度回顾所使用的EXCEL表格
FDA发出关于日本协和Kyowa Hakko Bio Co., Ltd的警告信,

摘译如下:

1.      Failure of your quality unit to exercise its responsibility to ensure the API manufactured at your facility are in compliance with CGMP.
质量部门未能履行其职责确保在生产的API符合CGMP。

Your firm performed retesting or manipulated data after obtaining out-of-specification (OOS) or other unacceptable results. For example, investigation 2016-C-023 stated that the system suitability test (SST) was nonconforming and that “some data were manipulated to meet SST specification” for the high-performance liquid chromatography (HPLC) an alysisof your raw material (b)(4). You attributed the root cause to your firm’s “lack of awareness of the seriousness” of CGMP deviations, and to an “environment where test data could be easily manipulated.” Your investigation stated that you reanalyzed the crude sample and concluded that it met the specification. You provided no further details on the root causes and on the effect of using a system that failed SST to test your raw material.
你公司在得到OOS或其它不可接受的结果之后进行了复测或捏造数据。例如,调查2016-C-023说你们原料XX的HPLC分析的系统适用性测试(SST)不合格,“一些数据是捏造出来以符合SST标准”。你们将根本原因归因于你们公司“缺乏明白CGMP偏差严重性的意识”,以及“易于捏造数据的环境”。你们的调查说你们重复分析了精品样品并得出结论说其符合质量标准。你们未提供更多根本原因以及使用不合格SST系统检测原料的影响的详细内容。

Your response stated that no product in distribution was found to be OOS, but you included no data to support this conclusion. Your response is inadequate. You identified additional data integrity issues, but failed to provide details regarding the corrective measures your firm has implemented.
你们的回复说未发现销售中的产品为OOS,但你们没有放入数据来支持此结论。你们的回复是不充分的。你们发现了更多的数据完整性问题,但未提交关于你们公司已实施的纠正措施的详细信息。

In response to this letter, provide a thorough assessment of your overall system for investigating deviations, discrepancies, OOS results, complaints, and other failures. In addition, provide a retrospective review of all distributed lots within expiry to determine whether your firm released lots not conforming to established specifications or appropriate manufacturing standards.
在回复此函时,请提交一份对你们偏差、差异、OOS结果、投诉和其它失败调查的整体系统的彻底评估。另外,请提供一份对所有已销售且仍在效期内的批准的回顾性审核,确定你们公司是否有放行不符合既定标准或适当生产标准的批次。

For more information about handling failing, OOS,out-of-trend, or other unexpected results and documentation of your investigations, see FDA’s guidance document, Investigating Out-of-Specification (OOS) Test Results for Pharmaceutical Production, athttps://www.fda.gov/downloads/drugs/guidances/ucm070287.pdf.
更多OOS处理信息请参见官网指南。

2.      Failure to exercise sufficient controls over computerized systems to prevent unauthorized access or changes to data, and failure to have adequate controls to prevent omission of data.
未能对计算机化系统进行充分控制以防止未经授权的访问或对数据的修改,且没有足够的控制防止数据遗漏。

Your firm’s controls over your HPLC systems are inadequate. Some HPLC systems did not have audit trail capability or audit trails enabled. In addition, unique user names and passwords were not required to perform HPLC activities. You stated that you did not create unique user names and passwords sothat operators in different (b)(4) could continue what previous operators had initiated.
你公司对你们HPLC系统的控制是不充分的。一些HPLC系统并无审计追踪能力或审计追踪未激活。另外,未要求有唯一用户名和密码来执行HPLC活动。你们声称你们并未创建唯一用户名和密码,因此不同XX的操作员可以继续之前的操作员已开始的工作。

In your annual product reviews, you used unprotected Excel worksheets to perform calculations and statistical evaluations of production data, such as standard deviation and process capability. These electronic files were not secured to prevent unauthorized changes, and have no change history.
在你们的年度产品回顾中,你们使得了未经保护的EXCEL表格对生产数据进行计算和统计评估,如标准偏差和工艺能力。这些电子文件并未受到保护以防止未经授权的修改,亦无修改历史。

Your firm’s lack of data control calls the reliability of your data into question.
你们公司对数据缺乏控制,导致你们公司数据的可靠性存在问题。

Your response stated that you stopped operating these HPLC systems without audit trail capability. Your response also stated that you will create a procedure for control of your electronic worksheets. Your response is inadequate because you have not assessed the effects of using data from uncontrolled HPLC systems or unsecured worksheets on your products.
你们的回复声称你们已停止使用这些没有审计追踪能力的HPLC系统。你们的回复亦声称你们将建立程序对电子工作表进行控制。你们的回复是不充分的,因为你们并未评估使用不受控制HPLC系统的数据或没有安全保护的工作表对你们产品的影响性。

In response to this letter, provide a comprehensive,independent review of controls and procedures for electronic data generated from all of your laboratory equipment. Based on this review, provide a detailed corrective action and preventive action (CAPA) plan to remediate laboratory systems, including but not limited to data creation, modification, maintenance, retention, and system security. Your plan should also include the process you will use to evaluate CAPA effectiveness.
在回复此函时,请提交一份对你们化验室仪器获得的电子数据的控制和程序的独立全面审核。基于此审核,请提交一份详细的CAPA计划用以补救化验室系统,包括但不仅限于数据创建、修改、维护、保存和系统安全。你们的计划亦应包括你们将用于评估CAPA有效性的流程。

Also see additional requests under the Data Integrity Remediation section below.
亦请参见以下数据完整性补救措施部分里的其它要求。

Repeat observations at multiple sites
多个工厂重复缺陷

In a previous warning letter (WL 320-10-009), FDA cited similar CGMP deviations related to your quality unit’s failure to thoroughly investigate and document OOS events. FDA also cited similar CGMP observations at your Ube site during our September 2017 inspection. These repeated failures at multiple sites demonstrate that executive management oversight and controlover the manufacture of drugs is inadequate.
在之前的警告信(WL 320-10-009)中,FDA引用了类似的质量部门未能彻底调查和记录OOS事件的CGMP偏差。FDA在2017年9月检查期间对你们的Ube工厂亦引用了类似缺陷。这些在多个工厂的重复失败说明执行管理人员对药品生产的监管和控制是不充分的。

Your executive management remains responsible for fully resolving all deficiencies, and ensuring ongoing CGMP compliance. You shouldimmediately and comprehensively assess your company’s global manufacturingoperations to ensure that systems and processes, and ultimately, the products manufactured, conform to FDA requirements.
你们的执行管理人员负有解决所有缺陷以及确保持续CGMP合规的义务。你们应立即对你公司的全球生产运作进行全面评估,以确保系统和工艺,以及最终,所生产的产品符合FDA要求。

Data Integrity Remediation
数据完整性补救措施

Your quality system does not adequately ensure the accuracyand integrity of data to support the safety, effectiveness, and quality of thedrugs you manufacture. We acknowledge that you are using a consultant to audit your operation and assist in meeting FDA requirements. Each third party consultant used by your firm must be qualified for their specific assigned function, including data integrity remediation.
你们的质量体系不能充分确保数据的准确性和完整性,无法支持你们生产的药品的安全性、有效性和质量。我们被告知你们正在使用一个顾问审计你们的运作情况,协助符合FDA要求。你们公司所用的每个第三方顾问均必须具备其指定领域的资质,包括数据完整性补救。

In response to this letter, provide the following.
在回复此函,请提交以下资料:

A.    A comprehensive investigation into theextent of the inaccuracies in data records and reporting. Your investigationshould include:
一份对数据记录和报告不准确性程度的全面调查。你们的调查应包括:

A detailed investigation protocol and methodology; a summary of all laboratories, manufacturing operations, and systems to be covered by the assessment; and a justification for any part of your operation that you propose to exclude.
详细的调查方案和方法学;对评估所覆盖的所有化验室、生产操作和系统的总结,以及对你们意在排除的操作中所有部分的论证。
Interviews of current and former employees to identify the nature, scope, and root cause of data inaccuracies. We recommend that these interviews be conducted by a qualified third party.
与现有的和已离职的员工进行面谈,找出数据不准确的表现、范围、根本原因。我们建议这些面谈由一个有资质的第三方来实施。
An assessment of the extent of data integrity deficiencies at your facility. Identify omissions, alterations, deletions, record destruction, non-contemporaneous record completion, and other deficiencies. Describe all parts of your facility’s operations in which you discovered data integrity lapses.
你们工厂数据完整性缺陷的程度的评估。识别出省略、修改、删除、记录销毁、不同步记录填写和其它缺陷。描述你们工厂操作中发现数据完整性问题的所有部分。
A comprehensive retrospective evaluation of the nature of the testing, manufacturing, and other data integrity deficiencies. We recommend that a qualified third party with specific expertise in the area where potential breaches were identified should evaluate all data integrity lapses.
一份对数据完整性缺陷状况的全面回顾性评估。我们建议由一个有资质的第三方里具有该领域专业水平的专家评估所有数据完整性问题。

B.   A current risk assessment of the potential effects of the observed failures onthe quality of your drugs. Your assessment should include analysesof the risksto patients caused by the release of drugs affected by a lapse of dataintegrity, and risks posed by ongoing operations.
对你们药品质量中所发现的不合格情况的潜在影响的当前风险评估。你们的评估应包括由于受到数据完整性问题影响的药品放行导致的患者风险的分析,以及持续运营所具有的风险。

C.    A management strategy for your firmthat includes the details of your global corrective action and preventiveaction plan. Your strategy should include:
你们公司的管理策略,包括你们全球CAPA计划详细情况。你们的策略应包括:

A detailed corrective action plan that describes how you intend to ensure the reliability and completeness of all the data you generate, including analytical data, manufacturing records, and all data submitted to FDA.
详细的CA计划,描述你们如何确保你们生成的所有数据的可靠性和完整性,包括分析数据、生产记录和所有提交给FDA的数据。
A comprehensive description of the root causes of your data integrity lapses, including evidence that the scope and depth of the current action plan is commensurate with the findings of the investigation and risk assessment. Indicate whether individuals responsible for data integrity lapses remain able to influence CGMP-related or drug application data at     your firm.
一份完整的描述你们数据完整性问题的根本原因的描述,包括认定当前行动计划的范围和深度与调查和风险评估发现相称的证据。说明是否对数据完整性问题承担责任的个人仍有能力对你公司对CGMP相关或药物应用数据产生影响。
Interim measures describing the actions you have taken or will take to protect patients and to ensure the quality of your drugs, such as notifying your customers, recalling product, conducting additional testing, adding lots to your stability programs to assure stability, drug application actions, and enhanced complaint monitoring.
临时措施,描述你们已采取的行动,或即将采取用以保护患者确保你们药品质量的努力,例如通知你们的客户、召回产品、实施额外测试、向稳定性试验计划中增加批次以确保稳定性、药品申报行动以及加强投诉监测。
Long-term measures describing any remediation efforts and enhancements to procedures, processes, methods, controls, systems, management oversight, and human resources (e.g., training, staffing improvements) designed to ensure the integrity of your company’s data.
长期措施,其中描述所有对用以确保你们公司数据完整性的程序、流程、方法、控制、系统、管理监管和人力资源(例如培训、员工提高)的弥补和提升。
A status report for any of the above activities already underway or completed.
对上述活动已开展或已经完成的状态报告。
回复

使用道具 举报

发表于 2018-11-22 12:42:09 | 显示全部楼层
有些人根本没有好好看过正文,摘录出来:
In your annual product reviews, you used unprotected Excel worksheets to perform calculations and statistical evaluations of production data, such as standard deviation and process capability. These electronic files were not secured to prevent unauthorized changes, and have no change history.
在你们的年度产品回顾中,你们使得了未经保护的EXCEL表格对生产数据进行计算和统计评估,如标准偏差和工艺能力。这些电子文件并未受到保护以防止未经授权的修改,亦无修改历史。


注意:这里所说的根本不是验证,而是缺乏评估,缺乏电子文件的保护
回复

使用道具 举报

发表于 2018-11-23 10:06:24 | 显示全部楼层
谢谢分享,内容不错
回复

使用道具 举报

发表于 2018-11-23 10:14:52 | 显示全部楼层
未曾想过这个也要验证,受教了
回复

使用道具 举报

药徒
发表于 2018-12-7 13:23:53 | 显示全部楼层
学习了,提供的文件确实是经过很熟练的设计人员编写而成,有很强的实用性。
回复

使用道具 举报

药生
发表于 2018-12-10 10:40:57 | 显示全部楼层
谢谢            
回复

使用道具 举报

发表于 2018-12-10 10:43:47 | 显示全部楼层
谢谢你的分享
回复

使用道具 举报

发表于 2018-12-28 15:23:48 | 显示全部楼层
好好哦,谢谢分享这么好的资料哦
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

×发帖声明
1、本站为技术交流论坛,发帖的内容具有互动属性。您在本站发布的内容:
①在无人回复的情况下,可以通过自助删帖功能随时删除(自助删帖功能关闭期间,可以联系管理员微信:8542508 处理。)
②在有人回复和讨论的情况下,主题帖和回复内容已构成一个不可分割的整体,您将不能直接删除该帖。
2、禁止发布任何涉政、涉黄赌毒及其他违反国家相关法律、法规、及本站版规的内容,详情请参阅《蒲公英论坛总版规》。
3、您在本站发表、转载的任何作品仅代表您个人观点,不代表本站观点。不要盗用有版权要求的作品,转贴请注明来源,否则文责自负。
4、请认真阅读上述条款,您发帖即代表接受上述条款。

QQ|手机版|蒲公英|ouryao|蒲公英 ( 京ICP备14042168号-1 )  增值电信业务经营许可证编号:京B2-20243455  互联网药品信息服务资格证书编号:(京)-非经营性-2024-0033

GMT+8, 2025-2-17 20:04

Powered by Discuz! X3.4运维单位:苏州豚鼠科技有限公司

Copyright © 2001-2020, Tencent Cloud.

声明:蒲公英网站所涉及的原创文章、文字内容、视频图片及首发资料,版权归作者及蒲公英网站所有,转载要在显著位置标明来源“蒲公英”;禁止任何形式的商业用途。违反上述声明的,本站及作者将追究法律责任。
快速回复 返回顶部 返回列表