Skip to main content

Query management in study conduct phase(CLINICAL DATA MANAGENT)

 In clinical data management, a query refers to a request for clarification or additional information about data entered in a clinical trial database. Clinical data management involves the collection, validation, and storage of data generated during a clinical trial or research study.

Queries play a crucial role in ensuring the accuracy, completeness, and integrity of the clinical data. When data inconsistencies, discrepancies, or missing information are identified during data review, data managers issue queries to the site personnel or data entry personnel responsible for entering the data. These queries are essentially questions or requests for clarification to resolve the data-related issues.

Query management. In terms of clinical trials, a query is a request for clarification from trial sponsors to researchers. Such requests are made during data review, before database lock, and aimed at resolving errors and inconsistencies. The query management feature facilitates communication among data managers, sponsors, and other stakeholders. It helps faster resolve all questions.

  • Open queries : when site coordinator open query( seen the query)

  • Closed queries: when site coordinator opened ,answered query and closed query

  • Answered queries: when site coordinator opened and answered query

  • Canceled queries: when DM/biostatician/medical monitor/clinical coder enter  query in EDC and it can be canceled by these people

  • Queries  prepare  in excel sheet which discrepancy is present in data(EDC)

  • Query posting

        DM of CRO will provide weekly metrics

         Sponsor DM will review metrics

         Metrics: can be open query by–DM, CRA, medical reviewer

         Queries like eg: subject part, unconfirmed missed date etc..,

  • Automated query—query populate in EDC when discrepancy is entered by site coordinate–edit checks

Here are key aspects of queries in clinical data management:

1. **Query Generation:**

- Data managers or clinical monitors review the data entered into the database against predefined data validation checks and protocol requirements. If discrepancies or issues are identified, they generate queries to address those issues.

2. **Query Types:**

- Queries can take various forms, including requests for clarification, correction of data entry errors, or additional information to resolve discrepancies. Common types of queries include data clarification queries, range checks, consistency checks, and validation checks.

3. **Query Management System:**

- Many clinical trials use a query management system to track and manage queries efficiently. This system helps organize queries, monitor their resolution status, and maintain a clear audit trail of communication between the data management team and the site personnel.

4. **Resolution Process:**

- Upon receiving a query, the site personnel or data entry personnel responsible for the data are expected to respond to the query by providing the necessary information or correcting the data entry errors. This response is then reviewed and documented by the data management team.

5. **Timeline for Resolution:**

- There is usually a specified timeline for resolving queries to ensure that data discrepancies are addressed promptly. Timely resolution of queries is crucial for maintaining data quality and meeting regulatory requirements.

6. **Documentation:**

- All communication related to queries, including the initial query and the site's response, is documented. This documentation is an essential part of the clinical trial's data management process and serves as an audit trail.

7. **Final Database Lock:**

- Before finalizing the clinical trial database for analysis, a process known as database lock, all queries must be resolved to ensure that the data are accurate and complete. After the database is locked, no further changes can be made to the data.

Effectively managing queries in clinical data management is critical for ensuring the reliability and validity of the clinical trial data, which, in turn, contributes to the integrity of the study results and supports regulatory submissions.




Comments

Popular posts from this blog

Difference between central lab and Local Lab

 In the context of clinical trials, both central laboratories (central labs) and local laboratories (local labs) play essential roles in processing and analyzing biological samples. However, they differ significantly in their operations, advantages, and applications. Here’s a detailed comparison: ### Central Laboratory **Definition:** A central laboratory is a large, centralized facility that processes and analyzes samples from multiple sites participating in a clinical trial. These labs are usually equipped with advanced technology and staffed by highly trained personnel. **Key Characteristics:** - **Standardization:** Central labs offer standardized procedures and protocols, ensuring consistent and uniform testing across all samples. - **Quality Control:** They maintain stringent quality control measures, often accredited by recognized bodies (e.g., CAP, CLIA). - **Advanced Technology:** Equipped with state-of-the-art equipment and specialized assays, central labs can perform a w...

study start up

  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....

Edit check specification

  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 st...