STUDY START UP/STUDY SET UP:
eCRF(case report form):
The case report form is a printed or electronic questionnaire for collecting data from study participants and reporting it to trial sponsors. The document is created specifically for each research project in accordance with
the trial protocol, and
recommendations of the Clinical Data Acquisitions Standards Harmonization (CDASH). They are developed by Clinical Data Interchange Standards Consortium to streamline industry-wide data exchange. Say, CDASH dictates dd/mm/yy format for collecting dates. (Read our article on CDISC standards to learn more.)
Well-designed case report forms collect only data necessary for the particular study avoiding any redundancy. The fields to be filled in may include
demographics (age, gender),
basic measurements (height, weight),
vital signs (blood pressure, temperature, etc.) captured at various time points,
lab exams,
medical history,
adverse events, and
more, based on the research requirements.
Data managers create data entry screens and eCRF layouts in collaboration with a database programmer. The design usually goes through several review cycles before finalization.
Crf pfd
Compare crf pdf with protocol
eCRF specification-prepare
Explain ecrf spec to programmer
Draft ecrf Review,updates and changes
Final ecrf
Ecrf in EDC(electronic data management)
Compare ecrf spec with EDC
EDIT CHECK DOCUMENT:
Edit check document
Edit check specification
Manual query and automated query
Dynamics
Populate a query in edc
Provide edit check specification parallel with ecrf specification to programmer
Compare edit check specifications with edc
UAT(user acceptance testing):
Role testing: testing role for team members like access
Screen testing
Structural functionality
Edit checks
Any of the data which falls out of range it should populate a query and for any thing which falls within a range that it express should not populate a query
LAB values-enter in UAT
Sponsor DMโCRO DMโLNR(lower normal range) templateโLead CRA(site)---Fill(template)---CRO CMโEDC โ---manual,automated
eCRF completion guidelines
.What you donโt know about study startup activities as Clinical Data Manager
.
.
Often when you hear Study start up activities as clinical data manager, your typical thought process includes
Get Protocol & review ---> Study Kick off Meeting --> Start Building EDC (eCRF's & Edits) --> Screen Review meeting --> UAT --> Go live
However ๐๐ต๐ถ๐ ๐ถ๐ ๐ผ๐ป๐น๐ ๐ฎ ๐ฝ๐ฒ๐ฟ๐๐ฝ๐ฒ๐ฐ๐๐ถ๐๐ฒ from Clinical Data Management.
When you consider the study ๐๐๐ฎ๐ฟ๐-๐๐ฝ ๐ฝ๐ต๐ฎ๐๐ฒ ๐ฎ๐ ๐ฐ๐น๐ถ๐ป๐ถ๐ฐ๐ฎ๐น ๐๐ฟ๐ถ๐ฎ๐น ๐น๐ฒ๐๐ฒ๐น, you will see whole different picture and in the clinical data Management is one critical step.
So let's explore the ๐ฏ๐ถ๐ด๐ด๐ฒ๐ฟ ๐ฝ๐ถ๐ฐ๐๐๐ฟ๐ฒ of study Start-up activities
โญ ๐ฃ๐ฟ๐ผ๐๐ผ๐ฐ๐ผ๐น ๐๐ฒ๐๐ฒ๐น๐ผ๐ฝ๐บ๐ฒ๐ป๐: The first step in the study start-up phase is protocol development. This protocol includes the study design, inclusion/exclusion criteria, data collection forms, and procedures for data analysis.
โญ๐๐๐ต๐ถ๐ฐ๐ ๐๐ผ๐บ๐บ๐ถ๐๐๐ฒ๐ฒ ๐ฎ๐ป๐ฑ ๐ฅ๐ฒ๐ด๐๐น๐ฎ๐๐ผ๐ฟ๐ ๐๐๐๐ต๐ผ๐ฟ๐ถ๐๐ ๐๐ฝ๐ฝ๐ฟ๐ผ๐๐ฎ๐น: Before the study can start, it must receive approval from the relevant ethics committees and regulatory authorities.
โญ ๐๐ฑ๐ฒ๐ป๐๐ถ๐ณ๐ & ๐ฆ๐ฒ๐น๐ฒ๐ฐ๐ ๐ฆ๐ถ๐๐ฒ๐ : The sites are identified based on several factors, such as the patient population, regulatory environment, and availability of qualified investigators etc.
โญ๐๐ป๐๐ฒ๐๐๐ถ๐ด๐ฎ๐๐ผ๐ฟ ๐ฎ๐ป๐ฑ ๐ฆ๐ถ๐๐ฒ ๐ค๐๐ฎ๐น๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป: The investigators and staff from the site must meet certain qualifications and experience requirements before they can participate in the study.
โญ ๐๐ผ๐ป๐๐ฟ๐ฎ๐ฐ๐๐ ๐ฎ๐ป๐ฑ ๐๐๐ฑ๐ด๐ฒ๐๐: Once the sites selection is completed, contracts are negotiated and budgets are developed. These contracts and budgets define the terms of the study, including compensation for the investigators and site staff.
โญ ๐ฆ๐ถ๐๐ฒ ๐๐ป๐ถ๐๐ถ๐ฎ๐๐ถ๐ผ๐ป ๐ฉ๐ถ๐๐ถ๐ (๐ฆ๐๐ฉ): The SIV (Site Initiation Visit) serves the purpose of training and ensuring that the Principal Investigator (PI) and their staff fully understand the protocol and Good Clinical Practice (GCP) requirements related to all aspects of the study.
โญ ๐ง๐ฟ๐ถ๐ฎ๐น ๐ ๐ฎ๐๐๐ฒ๐ฟ ๐๐ถ๐น๐ฒ (๐ง๐ ๐) ๐ฆ๐ฒ๐๐๐ฝ: A Trial Master File (TMF) is set up to manage all the study-related documents. The TMF includes the protocol, study plans, and other essential documents required for the study.
โญ ๐๐ป๐๐ฒ๐๐๐ถ๐ด๐ฎ๐๐ถ๐ผ๐ป๐ฎ๐น ๐ฃ๐ฟ๐ผ๐ฑ๐๐ฐ๐ ๐ ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐: Investigational product management includes the distribution, tracking, and management of the study drug or device.
โญ๐๐ฎ๐๐ฎ ๐ ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐ ๐ฃ๐น๐ฎ๐ป๐ป๐ถ๐ป๐ด: here is where clinical data managers comes in and perform all the critical steps required for data base go live.
As you can see study start-up activities includes more steps then one does in CDM. Also many companies follow additional steps as per their SOP's / SOW.
This phase has immense downstream impact on study conduct and closeout stages & clean study start-up activities can save whole lot of time, money & rework.
We can Categorize study startup activities in to 3 main headings.
๐ญ. ๐๐๐ ๐๐ฎ๐๐ฎ๐ฏ๐ฎ๐๐ฒ ๐๐ฒ๐๐ถ๐ด๐ป
๐ฎ. ๐จ๐๐ง ๐ง๐ฒ๐๐๐ถ๐ป๐ด
๐ฏ. ๐ ๐ฒ๐ฒ๐๐ถ๐ป๐ด๐
Let's Learn them one by one:
๐๐๐ ๐๐๐ง๐๐๐๐ฆ๐ ๐๐๐ฆ๐๐๐ก
EDC (Electronic Data Capture) is an essential component of study start-up, which allows clinical trial data to be collected, managed, and analysed in a more efficient and accurate way.
So what goes into EDC design?
๐ญ. ๐๐น๐ฒ๐ฎ๐ฟ ๐๐ป๐ฑ๐ฒ๐ฟ๐๐๐ฎ๐ป๐ฑ๐ถ๐ป๐ด ๐ผ๐ณ ๐๐๐๐ฑ๐ ๐ฟ๐ฒ๐พ๐๐ถ๐ฟ๐ฒ๐บ๐ฒ๐ป๐๐ ๐ณ๐ฟ๐ผ๐บ ๐ฃ๐ฟ๐ผ๐๐ผ๐ฐ๐ผ๐น:
All the data that needs to be collected in the study has to be mapped back to study protocol. So clear understanding of study data requirements from the protocol crucial. This link has detailed explanation about how Data Manager need to review Study protocol : https://www.slideshare.net/slideshow/protocol-document-in-clinical-research/267027997
๐ฎ. ๐๐ป๐ฝ๐๐๐ ๐ณ๐ฟ๐ผ๐บ ๐๐น๐ถ๐ป๐ถ๐ฐ๐ฎ๐น ๐ฆ๐๐๐ฑ๐ ๐๐ฒ๐ฎ๐บ :
Here mainly we are focusing on the inputs from study team who brings the wealth of their experience in conducting clinical trials to enhance the study data collection steps or to avoid major issues. Also inputs regarding how study end points needs to be meet with right data collection, what are the challenges & risks in conducting the study
๐ฏ. ๐๐ฎ๐๐ฒ ๐ฅ๐ฒ๐ฝ๐ผ๐ฟ๐ ๐๐ผ๐ฟ๐บ (๐๐ฅ๐) ๐๐ฒ๐๐ถ๐ด๐ป:
The CRF is the foundation of EDC design. It is a standardized questionnaire that captures data from study participants. The CRF must be designed in a way that is easy to understand, user-friendly, and collects all necessary data points required by the study protocol. SDTM / CDASH standards should be followed.
๐ฐ. ๐๐ฎ๐๐ฎ๐ฏ๐ฎ๐๐ฒ ๐๐ฒ๐๐ถ๐ด๐ป:
The database must be designed to ensure data accuracy, consistency, and completeness. It should also be able to handle large volumes of data, have built-in data validation checks, and ensure data privacy and security.
๐ฑ. ๐๐ฑ๐ถ๐ ๐๐ต๐ฒ๐ฐ๐ธ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ๐บ๐ถ๐ป๐ด:
To ensure data accuracy and completeness, the EDC system should have built-in data validation checks and edit checks. Edit checks are programmed to detect logical errors in the data. We use Edit Check spec to guide the programming team.
๐ฒ. ๐ ๐ฒ๐ฑ๐ถ๐ฐ๐ฎ๐น ๐๐ผ๐ฑ๐ถ๐ป๐ด, ๐ฃ๐ฟ๐ผ๐๐ผ๐ฐ๐ผ๐น ๐๐ฒ๐๐ถ๐ฎ๐๐ถ๐ผ๐ป๐ (๐ฃ๐๐ฆ) & ๐ฉ๐ฒ๐ป๐ฑ๐ผ๐ฟ ๐๐ฎ๐๐ฎ ๐๐ฒ๐๐๐ฝ :
Medical coding is an important component of EDC that involves assigning standardized codes to medical terms, procedures, and diagnoses.
Similarly, PD's & all the required vendor data setup needs to included into EDC.
.
.
Most important goal of a Clinical Data Manager is to ensure the consistency, quality & accuracy of clinical data. In this journey Edit check specification (ECS)plays a very crucial role to enable data cleaning.
ECS is created by DMโs with the input of study team member in clinical database build stage.
3 crucial things to understand about ECS
1. What are the pre-requisites to create / build ECS?
2. What are the checks to include in ECS?
3. What to avoid while writing ECS?
โญ ๐ฃ๐ฟ๐ฒ-๐ฟ๐ฒ๐พ๐๐ถ๐๐ถ๐๐ฒ๐ ๐๐ผ ๐ฐ๐ฟ๐ฒ๐ฎ๐๐ฒ / ๐ฏ๐๐ถ๐น๐ฑ ๐๐๐ฆ: To build an ECS that severs the CDM needs,
- One should have clear understanding of study protocol & eCRF data points collected.
- Data dictionary of the database (EDC) - this helps to understand the various attributes, definitions of the elements that are being used in database.
- Possible data entry scenarios & test data: This will help to create a correct edit checks to address all the possible data issues that can happen when study go live.
- List of critical data points such as study end points, AE / SAE data etc.
โญ ๐๐ต๐ฒ๐ฐ๐ธ๐ ๐ถ๐ป๐ฐ๐น๐๐ฑ๐ฒ๐ฑ ๐ถ๐ป ๐๐๐ฆ?
Based on the type, checks in ECS can be categorized into
a. Univariate checks (these checks only applicable to a single field or single variable ona eCRF.)
b. Multi-variate Checks (edit checks with more than one fields or variables involved.)
c. Programmed Checks (they will fire as soon wrong data is entered)
d. Manual Checks ( need to run manual programs on the data & output reports are analyzed for data issues)
Based on core function โ checks that are included in ECS can be categorized into
1. Missing data & eCRF checks : these checks ensure all the critical data points & eCRFโs are collected as needed (Ex : Missing inform consent date / missing Vital sign forms etc
2. Range Checks & format checks: they raises a query when entered value is out of range or format - specified for data collection point (ex: height, weight dates, time etc
3. Checks for Duplicate data: These checks alerts sites / DM when duplicate data is entered. Ex: Entering same AE event twice
4. Protocol deviation checks : These are must have checks to flag PDโs
5. External Data Checks : These check will ensure data quality of external data such as labs data, ECG etc
6. Inconsistency across single CRF & other eCRFโs : These will check inconsistencies on the same eCRF form across eCRF forms.
โญ ๐ช๐ต๐ฎ๐ ๐๐ผ ๐ฎ๐๐ผ๐ถ๐ฑ ๐๐ต๐ถ๐น๐ฒ ๐๐ฟ๐ถ๐๐ถ๐ป๐ด ๐๐๐ฆ?
1. Avoid complicate queries messages โ this will hurt sites
2. Avoid placing too many edit checks in a form or visit
3. Avoid leading /probing/ or guiding participants enter any data point in a particular way.
4. Do not blindly copy checks from other / sister studies.
User Acceptance testing (UAT)
.UAT is part of validation done by end users to ensure the database is built as per the study requirements. Before go live end users will be sponsors & internal testing team.๐ฃ๐๐ฟ๐ฝ๐ผ๐๐ฒ ๐ผ๐ณ ๐๐ต๐ฒ ๐จ๐๐ง ๐ถ๐ป๐ฐ๐น๐๐ฑ๐ฒ
1. To identify any issues or defects & address them before database go live
2. To gain feedback from end-users about the system's functionality, usability, and performance.
3. To document the validation steps for that serves as evidence of testing.
๐๐บ๐ฝ๐ผ๐ฟ๐๐ฎ๐ป๐ ๐ฐ๐ผ๐บ๐ฝ๐ผ๐ป๐ฒ๐ป๐๐ ๐ผ๐ณ ๐จ๐๐ง includes:
.
.1. UAT Plan
2. Testcases
3. Mock data for testing
4. Documentation
5. Approvals
What you miss in UAT during study start-up will come back and haunt you as PPC in study conduct!! & this will cost you time, money and effort.
UAT is a critical component in ensuring the clear database go live during the study startup, also we do minor UAT testingโs during PPC implementation as well.
After handling multiple PPCโs that have raised due to start up issue, i can say how significant proper understanding & implementation of UAT is .
So letโs explore 5 critical steps to ensure successful UAT during study startup.
1. ๐๐น๐ฒ๐ฎ๐ฟ๐น๐ ๐ฑ๐ฒ๐ณ๐ถ๐ป๐ถ๐ป๐ด ๐๐ต๐ฒ ๐จ๐๐ง ๐ฝ๐น๐ฎ๐ป:
UAT Plan is the heart of the testing, which defines what components of databases are tested ( eCRFโs edit checks etc). Clear UAT plan serves a long way in successful UAT.
2. ๐๐ฟ๐ฒ๐ฎ๐๐ฒ ๐ฎ ๐๐ฒ๐๐ ๐ฐ๐ฎ๐ฟ๐ฒ ๐๐ต๐ฎ๐ ๐ฐ๐ผ๐๐ฒ๐ฟ๐ ๐บ๐๐น๐๐ถ๐ฝ๐น๐ฒ ๐๐ฐ๐ฒ๐ป๐ฎ๐ฟ๐ถ๐ผ๐
An experience clinical data managers can come up a multiple scenarios to be tested for a given data point on the eCRFโs, for example โ on lab forms test cases need to written to test scenarios for blank data, values below or above the normal limits, checking for correct units etc.
3. ๐ ๐ผ๐ฐ๐ธ ๐๐ฎ๐๐ฎ ๐ฒ๐ป๐๐ฟ๐ & ๐๐ฒ๐๐๐ถ๐ป๐ด
Mock data entry gives a real time experience for database tester to clearly test the eCRFโs or Edit checks โ as it simulate the live data entry.
4. ๐๐น๐ฒ๐ฎ๐ฟ ๐จ๐๐ง ๐๐ฒ๐๐๐ถ๐ป๐ด ๐ฑ๐ผ๐ฐ๐๐บ๐ฒ๐ป๐๐ฎ๐๐ถ๐ผ๐ป
Missing / incomplete UAT documentation is one of the major audit findings one notice in study startup phase. Ensure to clear document UAT testing steps, checks that are failed, passed, and next round of testing for failed checks.
5. ๐๐ฝ๐ฝ๐ฟ๐ผ๐๐ฎ๐น๐ & ๐๐ผ๐บ๐บ๐๐ป๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป
Proper closure of UAT is required to move ahead with go live of the study / PPC which includes complete approvals from database testers, data managers and study lead.
Ensure to keep a clear, open communication with study team about the UAT proceedings.
What ๐ฐ๐ผ๐บ๐ฝ๐ผ๐ป๐ฒ๐ป๐๐ ๐ฎ๐ฟ๐ฒ ๐๐ฒ๐๐๐ฒ๐ฑ ๐ฑ๐๐ฟ๐ถ๐ป๐ด ๐จ๐๐ง:
๐ญ. ๐ฒ๐๐ฅ๐'๐: During UAT, eCRF functionality is tested for the completeness & accuracy of the entered data. Also dynamic visits and eCRF's are tested as well.
๐ฎ. ๐๐ฑ๐ถ๐ ๐ฐ๐ต๐ฒ๐ฐ๐ธ๐: Edit checks are automated validation rules that flag potential errors or discrepancies in the data collected on the eCRFs. During UAT, edit check are tested to ensure that they are triggered correctly and are accurately detecting data anomalies with accurate queries.
๐ฏ. ๐๐ผ๐ฑ๐ถ๐ป๐ด: Coding refers to the process of assigning standardized medical codes to clinical trial data, such as adverse events or medications. During UAT, coding functionality is tested to ensure that the correct codes are assigned to the correct data in AE, MH & CM forms.
๐ฐ. ๐ฃ๐ฟ๐ผ๐๐ผ๐ฐ๐ผ๐น ๐๐ฒ๐๐ถ๐ฎ๐๐ถ๐ผ๐ป๐ (๐ฃ๐'๐) are events that occur during a clinical trial that deviate from the study protocol. During UAT, PD tracking functionality is tested to ensure that deviations are being captured and documented accurately.
๐ฑ. ๐๐ฉ๐ฅ๐ฆ/๐๐ช๐ฅ๐ฆ ๐๐ฒ๐๐๐ฝ: ๐nt
er active Voice Response Systems (IVRS) and Interactive Web Response Systems (IWRS) are used to manage clinical trial supplies and randomization. During UAT, IVRS/IWRS functionality is tested to ensure that randomization is being performed correctly and that supplies are being tracked and managed accurately.
๐ฒ. ๐ฉ๐ฒ๐ป๐ฑ๐ผ๐ฟ ๐๐ฎ๐๐ฎ ๐๐ฒ๐๐๐ฝ: During clinical trials, vendors may be contracted to provide data management services or technology platforms. During UAT, vendor data setup is tested to ensure that data is being transferred and managed accurately between the study team and the vendor.
During UAT all the errors are logged in defect tracking sheet subsequent rounds of testing is performed to address all the open errors.
Data Manager, Database Programmer & tester, Coding SME, Sponsor are involved in the UAT
๐๐บ๐ฝ๐ผ๐ฟ๐๐ฎ๐ป๐ ๐ ๐ฒ๐ฒ๐๐ถ๐ป๐ด๐ ๐ถ๐ป ๐ฆ๐๐๐ฑ๐ ๐ฆ๐๐ฎ๐ฟ๐-๐๐ฝ :
โญ ๐ฆ๐๐๐ฑ๐ ๐ธ๐ถ๐ฐ๐ธ ๐ผ๐ณ๐ณ ๐บ๐ฒ๐ฒ๐๐ถ๐ป๐ด
This meeting brings together all stakeholders involved in the study, including clinical research associates, clinical trial lead, statisticians, programmers (Database, SDTM, SAS) project managers, and the study sponsor to plan the study activities in details & also highlight any possible risks to the study.
โญ ๐ฆ๐ฐ๐ฟ๐ฒ๐ฒ๐ป ๐ฟ๐ฒ๐๐ถ๐ฒ๐ ๐บ๐ฒ๐ฒ๐๐ถ๐ป๐ด
In this meeting DM along with technical designer & database programmer, presents the eCRF's & edits to study sponsor for review and feedback on the initial EDC build.
This meeting happens before the UAT.
โญ ๐๐ป๐๐ฒ๐๐๐ถ๐ด๐ฎ๐๐ผ๐ฟ ๐บ๐ฒ๐ฒ๐๐ถ๐ป๐ด (๐ณ๐ผ๐ฟ ๐๐ ๐ฝ๐ฟ๐ฒ๐๐ฒ๐ป๐๐ฎ๐๐ถ๐ผ๐ป)
Before database go live Data manager attends the Investigator meetings to give a complete overview of the EDC system to the PI, Sites, CRA's & other study personals.
The topics covered in the presentation include data collection process, including non-CRF data , sample case report forms (CRFs), CRF completion guidelines, data queries and self-evident corrections etc.
โญ ๐ฉ๐ฒ๐ป๐ฑ๐ผ๐ฟ๐ ๐ ๐ฒ๐ฒ๐๐ถ๐ป๐ด
DM will meet with various vendors who provide third party data such as central labs, imaging data, specialist labs etc, for EDC integration & work on documentations (such as Data Transfer agreement & specifications ) & test transfers before database go live to ensure things are in place.
๐๐บ๐ฝ๐ผ๐ฟ๐๐ฎ๐ป๐ ๐๐ผ๐ฐ๐๐บ๐ฒ๐ป๐๐ ๐ถ๐ป ๐ฆ๐๐๐ฑ๐ ๐ฆ๐๐ฎ๐ฟ๐๐๐ฝ :
โญ ๐๐๐ฆ
Edit check specification is a document that describes the rules and conditions that are used to validate the data entered into a clinical trial database.
โญ ๐๐ฎ๐๐ฎ ๐ ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐ ๐ฃ๐น๐ฎ๐ป (๐๐ ๐ฃ)
A document that outlines the procedures for collecting, managing, and analysing data for a clinical trial. (Know more here https://clinicalda.blogspot.com/2024/02/data-management-plan.html)
โญ ๐ฒ๐๐ฅ๐ ๐ฒ๐ป๐๐ฟ๐ ๐๐๐ถ๐ฑ๐ฒ๐น๐ถ๐ป๐ฒ๐
A set of instructions that provide guidance to clinical trial personnel on how to correctly and consistently enter data into the eCRF
โญ ๐๐ฎ๐๐ฎ ๐ง๐ฟ๐ฎ๐ป๐๐ณ๐ฒ๐ฟ ๐๐ด๐ฟ๐ฒ๐ฒ๐บ๐ฒ๐ป๐๐ (๐๐ง๐) & ๐๐ฎ๐๐ฎ ๐ง๐ฟ๐ฎ๐ป๐๐ณ๐ฒ๐ฟ ๐ฆ๐ฝ๐ฒ๐ฐ๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป (๐๐ง๐ฆ). More details on DTS here https://clinicalda.blogspot.com/2024/03/dtadata-transfer-agreement.html
โญ ๐ฃ๐ฟ๐ผ๐๐ผ๐ฐ๐ผ๐น ๐๐ฒ๐๐ถ๐ฎ๐๐ถ๐ผ๐ป ๐ฆ๐ฝ๐ฒ๐ฐ๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป๐
Along with above mentioned documents, ensuring completeness of UAT documents, Database go live checklist & its approval are critical in study start-up.
Comments
Post a Comment