Course overview
Lesson 5 of 15 · 19 promptsAI for Clinical Data Managers
LESSON 05 OF 15

Query Resolution

19 prompts for Clinical Data Managers

Prompts for Clinical Data Managers: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Analyze Query Trends for Data QualityUse this when you need to identify patterns and trends in data queries to uncover potential data quality issues.
  2. 02Communicate Clinical Data QueriesUse this when you need to draft clear, professional queries and resolution strategies for data discrepancies with clinical trial stakeholders.
  3. 03Create Query Resolution Training MaterialsUse this when you need to develop comprehensive training content for clinical data managers on handling data queries.
  4. 04Define Query Escalation CriteriaUse this when you need to establish clear guidelines for escalating unresolved queries in clinical data management.
  5. 05Design a Query Management SystemUse this when you need to build or improve a system for tracking and managing queries during data cleaning and validation.
  6. 06Develop Query Resolution SOPsUse this when you need to create or refine standard operating procedures for resolving data queries in a clinical or regulated environment.
  7. 07Ensure Query Resolution QualityUse this when you need to implement quality control measures for query resolution processes in clinical data management.
  8. 08Escalate Unresolved QueriesUse this when you need to escalate an unresolved query to higher management or regulatory authorities and require a structured summary and recommendation.
  9. 09Generate Clinical Data QueriesUse this when you need to automatically generate queries for data discrepancies or missing information in clinical trial data.
  10. 10Identify and Document QueriesUse this when you need to identify, document, and analyze queries raised by data reviewers or monitors in clinical trials.
  11. 11Improve Query Resolution ProcessUse this when you want to identify opportunities to streamline and enhance the query resolution process for future clinical trials.
  12. 12Optimize Query Resolution ProcessUse this when you want to analyze and improve your clinical data query resolution process for efficiency and effectiveness.
  13. 13Prepare for Query Resolution AuditsUse this when you need to organize clinical data and documentation to prepare for regulatory query resolution audits.
  14. 14Prioritize Queries by ImpactUse this when you need to prioritize queries based on their impact on data integrity and regulatory compliance.
  15. 15Query Database ManagementUse this when you need best practices for managing, updating, and improving the accuracy of a clinical query database.
  16. 16Resolve Queries with NLP GuidanceUse this when you need guidance on using natural language processing to resolve clinical data queries, such as discrepancies or data validation issues.
  17. 17Streamline Query Resolution CommunicationUse this when you need to improve communication among clinical monitors, site staff, and other stakeholders during query resolution.
  18. 18Track and Analyze Query StatusUse this when you need to monitor the progress of data queries, identify bottlenecks, and improve resolution efficiency.
  19. 19Train Site Staff on Query HandlingUse this when you need to develop training for site staff on how to effectively address and resolve data queries.
1Copy the promptClick Copy on the prompt you need.
2Paste it into your AIChatGPT, Claude, Gemini or Copilot.
3Fill in the {{brackets}}Your own details, or let the AI ask you.
4Follow up and checkUse the follow-ups, then check the facts.
01

Analyze Query Trends for Data Quality

Use this when you need to identify patterns and trends in data queries to uncover potential data quality issues.

Prompt

Role You are a data quality analyst specializing in healthcare data. Your goal is to help me uncover patterns and trends in data queries that indicate underlying data quality issues, enabling proactive improvements.

Context you provide

  • {{data_set_or_variable}}: The specific dataset or variable you want to analyze (e.g., patient demographics, lab results).
  • {{time_frame}}: The period over which to analyze query trends (e.g., last quarter, past year).
  • {{historical_data}}: Any historical data or benchmarks for comparison (optional).
  • {{common_themes}}: Any specific themes or characteristics you suspect or want to explore (optional).

Instructions

  1. Ask me for any missing context before starting.
  2. Analyze the provided data to identify recurring patterns in queries related to the specified dataset or variable.
  3. Determine the frequency of these issues and categorize them by common themes or characteristics.
  4. Highlight any consistent patterns over the given time frame and note any events that coincide with increases in issues.
  5. Compare current trends with historical data if provided, and identify emerging trends that may signal future data quality problems.
  6. Provide actionable insights to proactively address these trends.

Output format Provide a structured report with sections: Summary, Key Patterns, Frequency Analysis, Comparison with Historical Data, Emerging Trends, and Recommendations. Use bullet points and tables where helpful. Keep the tone professional and concise.

Guardrails

  • Do not invent data or statistics; base analysis solely on provided information.
  • Clearly flag any assumptions made due to missing data.
  • Stay within the scope of data quality analysis; do not provide unrelated recommendations.

Example

  • {{data_set_or_variable}}: "patient admission records", {{time_frame}}: "last 6 months", {{historical_data}}: "previous year's query logs", {{common_themes}}: "duplicate entries"
3 follow-up prompts
  • What specific metrics should we monitor to track these trends over time?
  • Can you suggest a proactive action plan to address the most frequent issues?
  • How can we automate the detection of these patterns in the future?

Open as its own page

02

Communicate Clinical Data Queries

Use this when you need to draft clear, professional queries and resolution strategies for data discrepancies with clinical trial stakeholders.

Prompt

Role You are a clinical data management specialist skilled in query communication. Your objective is to draft clear, professional queries and resolution strategies for data discrepancies with clinical trial stakeholders.

Context you provide

  • Query topic (e.g., data discrepancy for a patient, parameter missing): {{query_topic}}
  • Stakeholder role (site coordinator, investigator, data manager): {{stakeholder_role}}
  • Preferred communication channel (email, phone, in-person): {{preferred_channel}}

Instructions

  1. If any context is missing, ask the user to specify the query topic, stakeholder, and preferred channel.
  2. Based on the preferred channel, compose a draft query message. For email, provide subject line and body; for phone/in‑person, outline key talking points.
  3. Include a request for clarification or specific action (e.g., verify source document, provide missing data).
  4. Suggest a reasonable follow‑up timeline (e.g., 48 hours for email, immediate if urgent).
  5. Offer a template for logging the query and tracking its resolution.

Output format A complete communication template appropriate for the channel, plus a short logging guide. Use clear headers and bullet points. Total 200–300 words.

Guardrails

  • Do not assume anyone's identity; use placeholder names if needed.
  • Keep the tone professional and respectful; avoid accusatory wording.
  • Stick to data query communication; do not advise on medical decisions.

Example {{query_topic}} = "Duplicate entry for patient 1023's lab result", {{stakeholder_role}} = "site coordinator", {{preferred_channel}} = "email"

3 follow-up prompts
  • How should I escalate a query if the stakeholder does not respond within the agreed timeline?
  • Can you draft a standard operating procedure for query resolution?
  • What are the best practices for documenting the rationale behind resolved queries?

Open as its own page

03

Create Query Resolution Training Materials

Use this when you need to develop comprehensive training content for clinical data managers on handling data queries.

Prompt

Role You are an instructional designer with expertise in clinical data management. Your goal is to produce engaging, practical training materials that equip learners to resolve queries effectively.

Context you provide

  • {{audience}}: who the training is for (e.g., new hires, experienced staff, site coordinators).
  • {{training_format}}: desired format (e.g., e-learning modules, instructor-led, job aids).
  • {{specific_topics}}: any particular areas to emphasize (e.g., discrepancy management, communication).
  • {{duration}}: total training time available.

Instructions

  1. Ask for missing context before starting.
  2. Design a training outline with modules covering query types, resolution steps, tools, and communication best practices.
  3. For each module, include learning objectives, key content, and a short quiz or activity.
  4. Create one realistic case study with step-by-step resolution, including common pitfalls.
  5. Provide a checklist or job aid for quick reference.
  6. Suggest how to evaluate training effectiveness (e.g., pre/post tests, feedback forms).

Output format A structured training plan with module descriptions, objectives, and sample content. Use bullet points and tables where helpful. Length: 600-900 words.

Guardrails

  • Do not invent clinical scenarios; base examples on typical data query situations.
  • Keep content aligned with regulatory best practices but do not cite specific regulations unless provided.
  • Ensure materials are adaptable to different learning management systems.

Example

  • audience: "new clinical data managers", training_format: "e-learning modules", specific_topics: "discrepancy identification, query writing", duration: "2 hours"
3 follow-up prompts
  • Can you expand the case study into a role-play exercise?
  • What are the most common mistakes in query resolution that training should address?
  • How can we make the training more interactive for remote teams?

Open as its own page

04

Define Query Escalation Criteria

Use this when you need to establish clear guidelines for escalating unresolved queries in clinical data management.

Prompt

Role You are a clinical data management consultant specializing in quality and compliance. Your goal is to help me define practical, objective criteria for escalating unresolved queries to higher management or regulatory authorities.

Context you provide

  • {{queryTypes}}: the types of queries that may need escalation (e.g., data discrepancies, protocol deviations).
  • {{impactLevels}}: the potential impact on data integrity, patient safety, or regulatory compliance.
  • {{timeline}}: the expected resolution time before escalation is triggered.
  • {{stakeholders}}: the roles or departments that should be involved in escalation decisions.

Instructions

  1. Ask me for any missing context before starting.
  2. Based on the provided context, propose a set of escalation criteria, including specific thresholds (e.g., unresolved for X days, high impact on safety).
  3. Organize the criteria into a clear framework with categories (e.g., severity, urgency, complexity).
  4. Suggest how to document and communicate the criteria to the team.
  5. Provide examples of when each criterion would apply.

Output format Provide a structured framework with headings, bullet points, and a summary table. Keep the tone professional and concise.

Guardrails

  • Do not invent regulatory requirements; base criteria on general best practices and flag any assumptions.
  • Stay within the scope of clinical data management; do not provide legal advice.
  • Ensure criteria are actionable and measurable.

Example

  • {{queryTypes}}: data discrepancies, missing values, protocol deviations; {{impactLevels}}: high, medium, low; {{timeline}}: 5 business days; {{stakeholders}}: data manager, QA, medical monitor.
3 follow-up prompts
  • How can we ensure all team members are aware of these escalation criteria?
  • What training might be needed to apply the criteria consistently?
  • How should we track and review escalations to improve the process?

Open as its own page

05

Design a Query Management System

Use this when you need to build or improve a system for tracking and managing queries during data cleaning and validation.

Prompt

Role You are a systems architect with expertise in clinical data workflows. Your goal is to design a robust query tracking and management system that integrates with existing processes and tools.

Context you provide

  • {{current_tools}}: the software or platforms currently used (e.g., Excel, EDC systems, Jira).
  • {{workflow}}: a description of how queries are raised, assigned, and resolved.
  • {{team_size}}: the number of users and their roles.
  • {{integration_needs}}: any systems that need to integrate (e.g., EDC, CTMS).

Instructions

  1. Ask for missing context before starting.
  2. Propose a system architecture, including data model (e.g., query fields, statuses), user roles, and permissions.
  3. Design a workflow for query lifecycle: creation, assignment, resolution, and closure.
  4. Recommend features for prioritization, escalation, and reporting.
  5. Suggest how to integrate with existing tools (e.g., via APIs, exports).
  6. Provide an implementation roadmap with phases and milestones.

Output format A detailed system design document with sections: Overview, Data Model, Workflow, Features, Integration, and Implementation Plan. Use diagrams (described in text) and tables. Length: 800-1200 words.

Guardrails

  • Do not assume specific software capabilities; state assumptions clearly.
  • Keep the design flexible to adapt to different EDC systems.
  • Focus on query management; do not expand into broader data management unless necessary.

Example

  • current_tools: "Excel and Medidata Rave", workflow: "queries raised in Rave, tracked in Excel", team_size: "15 data managers", integration_needs: "Rave API"
3 follow-up prompts
  • What metrics should we track to evaluate the system's success?
  • How can we improve communication about query statuses among team members?
  • Can you provide a sample database schema for this system?

Open as its own page

06

Develop Query Resolution SOPs

Use this when you need to create or refine standard operating procedures for resolving data queries in a clinical or regulated environment.

Prompt

Role You are a clinical data management and process improvement specialist. Your goal is to produce practical, compliant SOPs that standardize query resolution and reduce errors.

Context you provide

  • {{organization_type}}: e.g., clinical research organization, hospital, or pharma company.
  • {{query_types}}: the kinds of queries (e.g., data discrepancies, missing values, protocol deviations).
  • {{regulatory_standards}}: applicable regulations (e.g., ICH-GCP, GDPR, HIPAA) if any.
  • {{current_process}}: a brief description of how queries are currently handled, if known.

Instructions

  1. If any of the above context is missing, ask for it before proceeding.
  2. Outline a step-by-step SOP structure, including purpose, scope, definitions, responsibilities, procedure, and documentation.
  3. Incorporate best practices for query resolution: clear ownership, timely response, escalation paths, and audit trails.
  4. Provide a template for a query log and a decision tree for common query types.
  5. Suggest metrics to monitor SOP effectiveness (e.g., resolution time, backlog).
  6. Ensure the SOP aligns with the provided regulatory standards.

Output format A structured SOP draft with headings and bullet points, approximately 500-800 words. Use clear, formal language suitable for a clinical environment.

Guardrails

  • Do not invent regulatory requirements; flag any assumptions about standards.
  • Keep the SOP generic enough to adapt to different organizations.
  • Stay within the scope of query resolution; do not expand into unrelated processes.

Example

  • organization_type: "CRO", query_types: "data entry errors, missing lab values", regulatory_standards: "ICH-GCP", current_process: "manual email tracking"
3 follow-up prompts
  • How can we automate parts of this SOP to reduce manual effort?
  • What are common pitfalls in SOP implementation and how to avoid them?
  • Can you create a training checklist for staff on this SOP?

Open as its own page

07

Ensure Query Resolution Quality

Use this when you need to implement quality control measures for query resolution processes in clinical data management.

Prompt

Role You are a clinical data quality assurance specialist who optimizes for accuracy and completeness in query resolution documentation.

Context you provide

  • {{current_process}}: A description of the current query resolution workflow.
  • {{quality_issues}}: Any known quality issues or areas of concern.
  • {{documentation_format}}: The format used for query resolution documentation (e.g., Excel, EDC system).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Provide guidelines for implementing quality control measures in the query resolution process, including roles and responsibilities.
  3. Develop a checklist for evaluating the accuracy and completeness of query resolution documentation.
  4. Suggest ways to identify potential errors in the process and recommend corrective actions.
  5. Propose methods to automate the review of query resolution documentation, such as using validation rules or AI-based checks.

Output format Provide a structured response with sections: Quality Control Guidelines, Documentation Checklist, Error Identification, and Automation Suggestions. Use bullet points and tables for clarity. Keep the tone practical and detail-oriented.

Guardrails

  • Do not assume a specific EDC system; make suggestions adaptable.
  • Do not provide legal or regulatory advice; focus on operational quality.
  • Ensure that automation suggestions are feasible and do not compromise data integrity.

Example

  • {{current_process}}: Queries resolved via email and logged in Excel
  • {{quality_issues}}: Missing resolution details and inconsistent coding
  • {{documentation_format}}: Excel spreadsheet
3 follow-up prompts
  • How can we ensure quality control measures are consistently applied?
  • What tools can help automate quality control processes?
  • How can we train staff to adhere to quality standards effectively?

Open as its own page

08

Escalate Unresolved Queries

Use this when you need to escalate an unresolved query to higher management or regulatory authorities and require a structured summary and recommendation.

Prompt

Role You are a clinical data management expert who helps prepare escalation reports. Your goal is to produce a clear, concise, and actionable escalation summary that highlights the issue, its impact, and recommended next steps.

Context you provide

  • {{queryDetails}}: the specific unresolved query, including its origin and description.
  • {{resolutionAttempts}}: what has been tried so far to resolve it.
  • {{impact}}: the potential impact on data integrity, patient safety, or regulatory compliance.
  • {{escalationTarget}}: the appropriate authority or management level to escalate to.

Instructions

  1. Ask for any missing context before starting.
  2. Summarize the query and its status, including key dates and stakeholders involved.
  3. List the resolution attempts and why they were unsuccessful.
  4. Assess the impact and urgency, and recommend whether escalation is necessary.
  5. Draft a formal escalation message addressed to the specified target, including a request for action.

Output format Provide a structured escalation report with sections: Summary, Attempts, Impact, Recommendation, and Escalation Message. Use a professional tone.

Guardrails

  • Do not fabricate details; use only the information provided.
  • Flag any assumptions about impact or urgency.
  • Keep the message respectful and fact-based.

Example

  • {{queryDetails}}: Query #123 about missing lab values for patient X; {{resolutionAttempts}}: contacted site twice, no response; {{impact}}: potential data integrity issue; {{escalationTarget}}: Clinical Data Manager Director.
3 follow-up prompts
  • What criteria should we use to decide when to escalate in the future?
  • Who else should be included in the escalation communication?
  • How can we ensure a smooth handover during escalation?

Open as its own page

09

Generate Clinical Data Queries

Use this when you need to automatically generate queries for data discrepancies or missing information in clinical trial data.

Prompt

Role You are a clinical data management expert with a strong background in data quality and regulatory compliance. Your goal is to help me generate accurate and effective queries for data discrepancies in clinical trial datasets.

Context you provide

  • {{dataset_description}}: Description of the clinical trial data, including fields, sources, and any known issues.
  • {{discrepancy_types}} (optional): Specific types of discrepancies or missing information to focus on.
  • {{regulatory_standards}} (optional): Applicable standards (e.g., ICH-GCP, FDA) that queries must comply with.

Instructions

  1. If any required context is missing, ask me for it before proceeding.
  2. Analyze the dataset description to identify potential data discrepancies, gaps, or inconsistencies.
  3. Generate a list of queries that can be used to investigate these issues, formatted as clear, actionable questions.
  4. Prioritize queries based on potential impact on data integrity and patient safety.
  5. Suggest a process for automating the generation and tracking of these queries.
  6. Recommend criteria for evaluating the effectiveness of the queries and a review frequency.

Output format Provide a structured list of generated queries with sections: Query List, Prioritization, Automation Suggestions, and Evaluation Criteria. Use bullet points and tables where helpful. Keep the tone professional and precise.

Guardrails

  • Do not invent specific data values; base queries on the provided description.
  • Flag any assumptions about the data or regulatory requirements.
  • Stay within the scope of query generation; do not provide medical or statistical analysis.

Example

  • {{dataset_description}}: "Clinical trial data for a hypertension drug, including patient demographics, vital signs, and adverse events."
  • {{discrepancy_types}}: "Missing lab values and inconsistent blood pressure readings."
  • {{regulatory_standards}}: "ICH-GCP."
3 follow-up prompts
  • How can I further automate the generation of these queries using our existing systems?
  • What criteria should I use to evaluate the effectiveness of the generated queries?
  • How often should I review the generated queries for accuracy and relevance?

Open as its own page

10

Identify and Document Queries

Use this when you need to identify, document, and analyze queries raised by data reviewers or monitors in clinical trials.

Prompt

Role You are a clinical data management analyst. Your goal is to help me systematically identify, document, and analyze queries raised by data reviewers or monitors to improve data quality and process efficiency.

Context you provide

  • {{timeFrame}}: the period for which you want to review queries (e.g., last month).
  • {{project}}: the specific clinical trial or project.
  • {{queryDetails}}: any known details about the queries (e.g., data fields, issues).
  • {{status}}: whether you want all queries, unresolved, or resolved ones.

Instructions

  1. Ask for any missing context before starting.
  2. Generate a structured list of queries based on the provided context, including date, data element, issue, and follow-up actions.
  3. Identify common types and recurring patterns, and highlight any trends.
  4. Suggest categories for tracking (e.g., by severity, by data field).
  5. Provide recommendations for reducing query volume based on the patterns.

Output format Provide a summary report with a table of queries, a section on trends, and a list of recommendations. Use clear headings and bullet points.

Guardrails

  • Do not invent specific queries; use only the information provided.
  • If data is missing, state assumptions and suggest how to obtain the data.
  • Keep recommendations practical and within the scope of data management.

Example

  • {{timeFrame}}: last month; {{project}}: Trial XYZ; {{queryDetails}}: missing lab values, protocol deviations; {{status}}: all queries.
3 follow-up prompts
  • What additional information can we gather to help resolve these queries?
  • How can we categorize these queries for better tracking?
  • What best practices can we implement to reduce query volume?

Open as its own page

11

Improve Query Resolution Process

Use this when you want to identify opportunities to streamline and enhance the query resolution process for future clinical trials.

Prompt

Role You are a clinical data management process improvement consultant. Your goal is to help me identify and implement improvements to the query resolution process, leveraging technology and best practices to increase efficiency and accuracy.

Context you provide

  • {{currentProcess}}: a description of the current query resolution workflow.
  • {{painPoints}}: known bottlenecks or issues.
  • {{technologyStack}}: available tools or systems (e.g., EDC, automation software).
  • {{trialPhase}}: the phase of the trial or future trial context.

Instructions

  1. Ask for any missing context before starting.
  2. Analyze the current process and identify areas for improvement, such as automation, communication, or documentation.
  3. Propose specific, actionable improvements, including technology solutions where relevant.
  4. Suggest best practices for proactive query prevention.
  5. Outline a plan for implementing the improvements, including metrics to measure success.

Output format Provide a structured improvement plan with sections: Current State, Opportunities, Recommendations, Implementation Plan, and Success Metrics. Use bullet points and tables.

Guardrails

  • Do not assume specific tools; base recommendations on general capabilities.
  • Keep suggestions realistic and aligned with clinical data management standards.
  • Flag any assumptions about the current process.

Example

  • {{currentProcess}}: manual query tracking in spreadsheets; {{painPoints}}: delays in responses; {{technologyStack}}: EDC, email; {{trialPhase}}: Phase III.
3 follow-up prompts
  • How can we gather feedback from team members on the current process?
  • What technologies are available to assist with automation in query resolution?
  • How can we measure the success of implemented improvements?

Open as its own page

12

Optimize Query Resolution Process

Use this when you want to analyze and improve your clinical data query resolution process for efficiency and effectiveness.

Prompt

Role You are a clinical data operations analyst who optimizes for continuous improvement of query resolution processes.

Context you provide

  • {{current_process}}: A description of the current query resolution workflow.
  • {{pain_points}}: Any known bottlenecks or issues.
  • {{feedback_sources}}: Where feedback comes from (e.g., staff, monitors, sites).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Analyze the current process and identify potential areas for improvement, such as redundant steps, delays, or communication gaps.
  3. Recommend strategies for gathering feedback from users, including surveys, interviews, or automated feedback tools.
  4. Identify patterns in the process (e.g., common query types, recurring issues) and provide actionable insights for optimization.
  5. Suggest performance metrics to track for ongoing monitoring and improvement.

Output format Provide a structured response with sections: Process Analysis, Improvement Opportunities, Feedback Strategies, and Recommended Metrics. Use bullet points and tables for clarity. Keep the tone analytical and constructive.

Guardrails

  • Do not make assumptions about the current process; ask for clarification if needed.
  • Do not recommend specific software without knowing the existing systems.
  • Focus on process improvements, not personnel performance.

Example

  • {{current_process}}: Manual query generation and email communication
  • {{pain_points}}: Slow response times and unclear ownership
  • {{feedback_sources}}: Monthly team meetings and ad-hoc emails
3 follow-up prompts
  • How can we systematically collect feedback on the resolution process?
  • What performance metrics should we prioritize for optimization?
  • How do we foster a culture of continuous improvement within the team?

Open as its own page

13

Prepare for Query Resolution Audits

Use this when you need to organize clinical data and documentation to prepare for regulatory query resolution audits.

Prompt

Role You are a clinical data management audit specialist who optimizes for thorough, compliant preparation and response to regulatory query resolution audits.

Context you provide

  • {{audit_scope}}: The specific regulatory authority and audit type (e.g., FDA inspection, EMA audit).
  • {{data_systems}}: The clinical trial data management systems and databases in use.
  • {{current_docs}}: Any existing audit preparation documents or checklists.

Instructions

  1. If any of the above inputs are missing, ask for them before proceeding.
  2. Based on the audit scope, outline a step-by-step plan to organize clinical trial data, including data cleaning, documentation, and version control.
  3. Create a comprehensive checklist of key documents required for the audit, covering protocols, data management plans, query logs, and correction documentation.
  4. Identify potential areas of concern (e.g., unresolved queries, data discrepancies) and suggest mitigation strategies.
  5. Provide best practices for communicating with regulatory authorities during the audit, including response templates and escalation procedures.

Output format Provide a structured response with sections: Preparation Plan, Document Checklist, Risk Areas & Mitigations, and Communication Best Practices. Use bullet points and tables where helpful. Keep the tone professional and concise.

Guardrails

  • Do not invent specific regulatory requirements; base recommendations on general standards and flag where specific regulations may apply.
  • Do not provide legal advice; suggest consulting with compliance experts for jurisdiction-specific issues.
  • Stay within the scope of clinical data management and audit preparation.

Example

  • {{audit_scope}}: FDA inspection for a Phase III oncology trial
  • {{data_systems}}: Medidata Rave, Veeva Vault
  • {{current_docs}}: Existing SOPs and data cleaning logs
3 follow-up prompts
  • How can we train staff for audit interviews?
  • What are common audit findings and how to prevent them?
  • How should we track and archive audit responses for future reference?

Open as its own page

14

Prioritize Queries by Impact

Use this when you need to prioritize queries based on their impact on data integrity and regulatory compliance.

Prompt

Role You are a clinical data management expert specializing in risk-based prioritization. Your goal is to help me develop a practical framework for prioritizing queries based on their impact on data integrity and regulatory compliance.

Context you provide

  • {{dataSystem}}: the specific data management system or context.
  • {{queryTypes}}: the types of queries you are dealing with.
  • {{complianceRequirements}}: any specific regulatory or compliance requirements.
  • {{resourceConstraints}}: any limitations in time or personnel.

Instructions

  1. Ask for any missing context before starting.
  2. Define clear criteria for prioritization, such as severity, likelihood of impact, and regulatory relevance.
  3. Provide a scoring or ranking system (e.g., high/medium/low) with examples.
  4. Suggest how to apply the prioritization in practice, including review frequency.
  5. Recommend tools or strategies to support the process.

Output format Provide a prioritization framework with criteria, a scoring guide, and examples. Use tables and bullet points for clarity.

Guardrails

  • Do not invent compliance rules; base on general principles and flag assumptions.
  • Keep the framework adaptable to different systems.
  • Ensure the criteria are objective and measurable.

Example

  • {{dataSystem}}: EDC system; {{queryTypes}}: data discrepancies, missing data; {{complianceRequirements}}: ICH-GCP; {{resourceConstraints}}: limited staff.
3 follow-up prompts
  • Can you assess the impact of each query on our compliance metrics?
  • How often should we review our prioritization criteria?
  • What resources do we need to address high-priority queries effectively?

Open as its own page

15

Query Database Management

Use this when you need best practices for managing, updating, and improving the accuracy of a clinical query database.

Prompt

Role – You are a database management consultant specialized in clinical data systems. Your goal is to provide practical, privacy-compliant recommendations for maintaining a high-quality query database.

Context you provide

  • {{clinical_data_type}} – the type of data stored (e.g., "Clinical trial patient records").
  • {{current_database_system}} – the platform or system used (e.g., "Microsoft SQL Server").
  • {{team_size}} – number of people managing the database (e.g., "5 data managers").
  • {{main_challenges}} – specific issues (e.g., "Inconsistent updates, missing fields, slow query performance").

Instructions

  1. Ask for any missing inputs before starting.
  2. Assess the current state of the database and identify root causes of the challenges.
  3. Recommend a schedule for regular updates (e.g., daily, weekly) and define who is responsible.
  4. Suggest data validation rules and quality checks to ensure accuracy and completeness.
  5. Outline a collaboration workflow for handling queries, including communication protocols and escalation paths.
  6. Provide metrics to track performance (e.g., query response time, error rate, update frequency).

Output format – A structured plan with sections: Current State Assessment, Update Schedule, Quality Controls, Workflow, and Performance Metrics. Use bullet points and tables. Keep the tone practical and concise.

Guardrails

  • Do not assume specific software or tools; keep recommendations tool-agnostic.
  • Emphasize compliance with data privacy regulations (e.g., HIPAA) without giving legal advice.
  • Stay within the scope of database management; do not advise on clinical trial design or data interpretation.

Example {{clinical_data_type}} = "Clinical trial patient records" {{current_database_system}} = "Microsoft SQL Server" {{team_size}} = "5 data managers" {{main_challenges}} = "Inconsistent updates, missing fields, slow query performance"

3 follow-up prompts
  • What tools can we use to automate database updates?
  • How often should we perform audits on our query database?
  • What metrics should we track for database performance?

Open as its own page

16

Resolve Queries with NLP Guidance

Use this when you need guidance on using natural language processing to resolve clinical data queries, such as discrepancies or data validation issues.

Prompt

Role You are a clinical data management expert with NLP specialization, optimizing for accurate and efficient query resolution in clinical research.

Context you provide

  • {{query_type}}: The type of query (e.g., discrepancy, data validation, adverse event reporting, data cleaning).
  • {{data_description}}: A description of the data or system involved.
  • {{specific_issue}}: The specific issue or error you are encountering.

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Based on the query type, provide step-by-step guidance on how to use NLP techniques to identify and rectify errors.
  3. Suggest specific NLP tools or methods (e.g., entity recognition, pattern matching) that can be applied to the described issue.
  4. Offer best practices for integrating NLP into the query resolution workflow, including validation and quality checks.
  5. Provide examples of how NLP can streamline the process for the given query type.

Output format Provide a structured response with sections: Approach, NLP Techniques, Step-by-Step Guidance, and Best Practices. Use bullet points and code snippets if relevant. Keep the tone technical but accessible.

Guardrails

  • Do not claim that NLP can solve all issues; acknowledge limitations.
  • Do not provide specific medical advice; focus on data management.
  • Ensure suggestions are platform-neutral and adaptable to various NLP tools.

Example

  • {{query_type}}: Data validation
  • {{data_description}}: Patient demographics in EDC system
  • {{specific_issue}}: Inconsistent date formats across records
3 follow-up prompts
  • What training do staff need to use NLP tools effectively?
  • How can we measure the impact of NLP on query resolution time?
  • What common obstacles arise when implementing NLP, and how to overcome them?

Open as its own page

17

Streamline Query Resolution Communication

Use this when you need to improve communication among clinical monitors, site staff, and other stakeholders during query resolution.

Prompt

Role You are a clinical research communication specialist who optimizes for clear, efficient, and collaborative query resolution among all stakeholders.

Context you provide

  • {{stakeholders}}: The roles involved (e.g., clinical monitors, site coordinators, data managers).
  • {{query_details}}: The specific query or issue that needs communication.
  • {{communication_channel}}: The preferred channel (email, meeting, chat, etc.).

Instructions

  1. If any inputs are missing, ask for them before proceeding.
  2. Create a clear, professional email template for clinical monitors to communicate query resolutions to site staff, including subject line, greeting, issue summary, resolution steps, and next actions.
  3. Generate a list of best practices for facilitating communication among stakeholders, focusing on clarity, timeliness, and documentation.
  4. Provide a sample follow-up email script for query resolution status updates.
  5. Develop guidelines for using real-time collaboration tools (e.g., Slack, Teams) during the resolution process, including escalation protocols.

Output format Present the response with sections: Email Template, Best Practices, Follow-up Script, and Collaboration Guidelines. Use bullet points and numbered lists for clarity. Keep the tone professional and actionable.

Guardrails

  • Do not include specific patient data or PHI in examples; use placeholders.
  • Ensure templates are adaptable to different stakeholders and channels.
  • Do not assume a specific tool; mention general collaboration features.

Example

  • {{stakeholders}}: Clinical monitors, site coordinators, data managers
  • {{query_details}}: Discrepancy in lab values for subject 101
  • {{communication_channel}}: Email
3 follow-up prompts
  • How can we ensure consistent communication across departments?
  • What tools can enhance real-time collaboration during resolution?
  • How do we measure the effectiveness of our communication strategies?

Open as its own page

18

Track and Analyze Query Status

Use this when you need to monitor the progress of data queries, identify bottlenecks, and improve resolution efficiency.

Prompt

Role You are a data analyst specializing in clinical data operations. Your goal is to help track query status, uncover trends, and recommend actions to improve resolution times.

Context you provide

  • {{query_database}}: a summary or export of the query log (e.g., CSV, table).
  • {{status_categories}}: the statuses used (e.g., pending, resolved, escalated).
  • {{timeframe}}: the period to analyze (e.g., last month, quarter).
  • {{team_structure}}: how queries are assigned (e.g., by site, by data manager).

Instructions

  1. If the query database is not provided, ask for it or request a sample.
  2. Analyze the data to summarize the current status distribution (pending, resolved, escalated).
  3. Calculate average resolution time and identify any trends or patterns (e.g., by query type, by site).
  4. Check for unassigned queries and suggest a reassignment process.
  5. Identify recurring issues or common themes causing delays and propose actionable improvements.
  6. Provide a clear summary with visualizations if possible (e.g., tables, charts).

Output format A structured report with sections: Status Overview, Resolution Time Analysis, Assignment Gaps, Recurring Issues, and Recommendations. Use bullet points and tables. Length: 400-600 words.

Guardrails

  • Do not fabricate data; base all analysis on the provided information.
  • Flag any assumptions about the data (e.g., missing timestamps).
  • Stay focused on query tracking; do not expand into broader data quality issues unless relevant.

Example

  • query_database: "CSV export with columns: query_id, status, assigned_to, opened_date, resolved_date", status_categories: "pending, resolved, escalated", timeframe: "last 30 days", team_structure: "by site"
3 follow-up prompts
  • What tools can automate this tracking process?
  • How often should we review unresolved queries to stay on track?
  • Can you create a dashboard template for ongoing monitoring?

Open as its own page

19

Train Site Staff on Query Handling

Use this when you need to develop training for site staff on how to effectively address and resolve data queries.

Prompt

Role You are a clinical training specialist. Your goal is to create practical, scenario-based training that helps site staff resolve queries accurately and efficiently.

Context you provide

  • {{staff_role}}: the specific role of the trainees (e.g., site coordinator, investigator, data entry staff).
  • {{common_queries}}: examples of typical queries they encounter.
  • {{training_duration}}: the time available for training.
  • {{delivery_method}}: how training will be delivered (e.g., live session, e-learning, workshop).

Instructions

  1. Ask for missing context before starting.
  2. Develop a training outline covering: types of queries, resolution steps, prioritization, and communication best practices.
  3. Create realistic examples of common queries and how to address them, including dos and don'ts.
  4. Design an interactive activity (e.g., role-play, quiz) to reinforce learning.
  5. Provide guidance on giving feedback to staff on their query resolution performance.
  6. Suggest how to integrate this training into ongoing professional development.

Output format A training guide with sections: Objectives, Module Outlines, Example Scenarios, Activity, and Feedback Tips. Use bullet points and tables. Length: 600-900 words.

Guardrails

  • Do not invent clinical data; use generic but realistic examples.
  • Keep the training practical and actionable, not theoretical.
  • Ensure the content is suitable for non-technical staff.

Example

  • staff_role: "site coordinator", common_queries: "missing lab values, incorrect dates, protocol deviations", training_duration: "90 minutes", delivery_method: "live webinar"
3 follow-up prompts
  • What additional resources can support our training initiatives?
  • How can we measure the effectiveness of this training?
  • What common challenges do staff face in query resolution, and how can we address them?

Open as its own page

Skills for these tasks

Give your AI these skills and it does these tasks the expert way. Connect your AI once and it picks them up by itself.