Design a Query Management System

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"