Data Base Transfers & Validation for Part 11 & Annex 11 Compliance Paul Daniel, Vaisala Senior GxP Regulatory Compliance Expert Published: Feb 20, 2018 Industrial Measurements Life Science We recently received these questions: “Are data base transfers part of software validation? If yes, how can we validate the transfer?” The transfer of data from one database to another is an important thing to get right. I don’t usually call it software validation, because this isn’t usually part of the built-in functions of a software system. If it was part of the built-in functions, we wouldn’t be talking about having to transfer the data! Electronic databases are used by computerized systems and they often contain electronic records that are used to replace paper records. This means they fall under Part 11 and Annex 11. This would justify validation/qualification efforts if the records contain information of GMP relevance. Transferring data falls under a change control. Change control must demonstrate to regulatory bodies that systems remain under control during any change. We know that change control is a favorite target of auditors because they are a good example of your organization’s ability to control its systems. Basically, in a transfer of data from one location to another we need to be prepared to prove that the data was transferred completely, without omissions or errors. We can do this by verifying the data set (perhaps validating the verification tool), or by validating the data transfer process (And that is software validation, but usually using existing tools) .There are a few ways you could go about this, but first we need to get very clear on validation vs. verification. To do this, we refer to the FDA’s “Quality System Regulation CFR Title 21 Part 820, which states: 820.3(z) Validation means establishing by objective evidence that the particular requirements for a specific intended use can be consistently fulfilled. 820.3(aa) Verification means confirmation by examination and provision of objective evidence that specified requirements have been fulfilled. Now, we offer two common verification strategies for data base transfers: Transfer your data and do a 100% verification. This actually doesn’t validate anything, but it does verify your transfer was successful without corruption. If you are using a standard tool, such as “Copy and Paste,” within a standard well-tested application such as a Microsoft Operating System, then you can probably get away with just verifying the number of files, and the size of the files, to show that nothing has changed. Again, this isn’t really validation, because you are “confirming by examination” a.k.a.: verification. We recommend the use of an application for comparison that will look at the two data sets – original and transferred – to verify that they are identical. Now if we want to validate the process, we would generally do this by validating our verification tools. That’s the part that requires validation – the tool. We would choose our data transfer tool, then transfer a fake data set (this could be a copy of our GMP data). Then we make some specific types of changes to our data set – omissions, duplications, wrong data, missing entries, extra entries, etc. Then we run our verification tool and verify that the verification tool is identifying all the changes. If we do this in the documented environment of a validation protocol, with acceptance criteria, and repeat it enough times, this should stand as a validation of the verification tool. It will be dependent on our ability to be creative (rely on your IT experts here) on exactly what kinds of data errors we should be testing for. Now, the disclaimer – we recommend the use of validated verification tools. We hope this gives you some idea of how to approach the problem, but we strongly suggest you talk to your nearest IT professional about validating verification tools, and verifying transfers of data. Please post comments below – OR contact us with any questions you have! 21 CFR Part 11 compliance for environmental monitoring: Software functions Vs. operating procedures808.45 KB Annex 11 Compliance and Environmental Monitoring Systems1.09 MB
21 CFR Part 11 compliance for environmental monitoring: Software functions Vs. operating procedures808.45 KB
Sign up to Life Science eNewsletter Your Email*I authorize Vaisala to send me information about relevant products and services. See our Privacy Policy for more details. You can modify your preference settings or unsubscribe at any time here
We invite you to view this 1-hour webinar on recent technological advances in wireless technology. The webinar covers key differences between types of wireless and Wi-Fi monitoring systems, reviewing the advantages and disadvantages of each. Learn how new long-range wireless technology eliminates the need for signal repeaters, reduces monitoring costs, and uses battery-powered devices to simplify environmental monitoring applications. The webinar includes a Question & Answer period, but if you have any questions after viewing, please email us. Key learning objectives History: Radio Waves, Micro Waves = Wireless Differences in current technologies: VaiNet, Wi-Fi, Bluetooth, ZigBee Functional comparisons of each Concepts simplified: frequency, modulation, LoRa, Link Budgets, network topology and more... If you are curious about how new wireless technologies are changing environmental monitoring, this presentation will give you a primer on the future of wireless devices. Your IT department will be impressed with your understanding of wireless technology after this webinar! Audience Quality Assurance & Quality Control Facilities Management Information Technology Regulatory Compliance Engineering Process Manager Email Address*First Name*Last Name*Your Interest Area*-- Please Select --AgrometeorologyAirplane Weather SafetyAirport WeatherAmbient or High Humidity ProcessesAtmospheric and Meteorological ResearchAutomotive Manufacturing ProcessesBallistic, Naval and Tactical WeatherBiogas ProductionBio-Decontamination ProcessesCompressed AirConcrete and ConstructionFood and Beverage ProcessesGas Turbines and Combustion EnginesGreenhouses and Indoor AgricultureHVAC & Indoor Air QualityHydrologyIndustrial Research Laboratories and FacilitiesLife Science Laboratories and FacilitiesLife Science EquipmentLiquid ConcentrationLow Humidity Processes (under 10% RH)Lubrication and Hydraulic SystemsMuseums, Archives and LibrariesOff-Shore and Ship Weather MeasurementOn-Shore Harbour WeatherOperational Weather Observations and ForecastingOther Industrial MeasurementOther Weather or Environmental MeasurementOutdoor Air QualityPower TransmissionRail WeatherRenewable Weather Energy DevelopmentRenewable Weather Energy OperationRoad WeatherUrban MeteorologyWarehouses and Cargo ContainersWind Turbine ManufacturingCompany*TitleBusiness PhoneCountry*--Please Select--United StatesUnited KingdomCanadaChinaIndiaJapanAustraliaBrazilFranceGermanyFinland--------------AfghanistanÅland IslandsAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBosnia and HerzegovinaBotswanaBouvet IslandBrazilBrit/Indian Ocean Terr.Brunei DarussalamBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos (Keeling) IslandsColombiaComorosCongoCongo, The Dem. Republic OfCook IslandsCosta RicaCôte D'IvoireCroatiaCubaCyprusCzech RepublicDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern Terr.GabonGambiaGeorgiaGermanyGhanaGibraltarUnited KingdomGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuineaGuinea-BissauGuyanaHaitiHeard/McDonald Isls.HondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsraelItalyJamaicaJapanJordanKazakhstanKenyaKiribatiKorea (North)Korea (South)KuwaitKyrgyzstanLaosLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacauMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarN. Mariana Isls.NamibiaNauruNepalNetherlandsNetherlands AntillesNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorthern IrelandNorwayOmanPakistanPalauPalestinian Territory, OccupiedPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalPuerto RicoQatarReunionRomaniaRussian FederationRwandaSaint Kitts and NevisSaint LuciaSamoaSan MarinoSao Tome/PrincipeSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSlovak RepublicSloveniaSolomon IslandsSomaliaSouth AfricaSpainSri LankaSt. HelenaSt. Pierre and MiquelonSt. Vincent and GrenadinesSudanSurinameSvalbard/Jan Mayen Isls.SwazilandSwedenSwitzerlandSyriaTaiwanTajikistanTanzaniaThailandTimor-LesteTogoTokelauTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTurks/Caicos Isls.TuvaluUgandaUkraineUnited Arab EmiratesUnited StatesUS Minor Outlying Is.UruguayUzbekistanVanuatuVatican CityVenezuelaViet NamVirgin Islands (British)Virgin Islands (U.S.)Wallis/Futuna Isls.Western SaharaYemenZambiaZimbabweState or Province*--Please Select--Other - not US or CAAlaskaAlabamaArkansasArizonaCaliforniaColoradoConnecticutD.C.DelawareFloridaMicronesiaGeorgiaHawaiiIowaIdahoIllinoisIndianaKansasKentuckyLouisianaMassachusettsMarylandMaineMichiganMinnesotaMissouriMarianasMississippiMontanaNorth CarolinaNorth DakotaNebraskaNew HampshireNew JerseyNew MexicoNevadaNew YorkOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVirginiaVermontWashingtonWisconsinWest VirginiaWyomingAlbertaManitobaBritish ColumbiaNew BrunswickNewfoundland and LabradorNova ScotiaNorthwest TerritoriesNunavutOntarioPrince Edward IslandQuebecSaskatchewanYukon TerritoryI authorize Vaisala to send me information about relevant products and services. See our Privacy Policy for more details. You can modify your preference settings or unsubscribe at any time here
Articles on GxP standards & regulations Visit our repository of articles, white papers, application notes and eBooks...
Janice Bennett-Livingston Jul 25, 2018 Thank you very much for reading our blog and commenting! :) Reply