Identify and Document Queries

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.