Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Body:

...

Attributes:

...

The

...

Query

...

Contained in:

...

The Query element represents a request for clarification on a data item collected for a clinical trial; , specifically a request from a sponsor or sponsor’s representative to an investigator to resolve an error or inconsistency discovered during data review. Queries can be created manually by roles individuals such as site monitors or data managers or automatically by systems. The full text of the Query exists in the Value child element. The optional Name attribute provide the means to provide a short identifier that can be included in listing or user interfaces.

Include Page
Query Element
Query Element

Include Page
Query Attributes
Query Attributes

Query Workflow

A Query must be in one 1 of the states listed for the State attribute, and the state diagram below highlights how states can transition through the query workflow. An audit record of the query may be generated as the Query transitions through the workflow. In the Query workflow Open and Candidate are valid start states while Closed, Resolved and Cancelled are valid end states.

Gliffy Diagram
nameQuery Workflow Copy
pagePin1

Query Workflow

In order to represent the state of a query in a system-independent fashion, then we need to define the workflow of a query needs to be defined in a standard way.

Query State

Definition

CandidateQuery visible to
Sponsor Staff
sponsor staff, not visible to
Site Staff
site staff; if the Candidate
Query
query is deemed actionable then it can be sent to the
Site
site (
Status
status goes to Open); otherwise the
Query
query is Cancelled.
OpenQuery has been raised by initiator to
Site Staff
site staff
AnsweredResponse provided by
Site Staff
site staff, ready for review by
Data Management or System Software
data management or system software
ClosedQuery for which response has been provided, which has been subsequently reviewed by
Data Management
data management or by automated review of response (which may be changing the conflicting data point so it is no longer
non-conformant
nonconformant)
CancelledQuery has been removed without requiring response
ResolvedQuery has a response and no further action is required on it

Using these definitions;

  • Open and Candidate are valid start states
  • Closed, Resolved, and Cancelled are valid end states

Transitions are shown in the diagram above, but are not currently modelled in the ODM Schema.  The correct location for this would be on the AuditRecord element.  In a future release there will be an element added to the AuditRecord that enumerates the state transition (eg Candidate → Open).  

Query Transaction

Used to representation data Query workflow in data-management processes and systems

...

; for example, sample milestones:

  • Create
  • Update (e.g., add comment) 
  • Close (e.g., data marked as correct)
  • Resolve (

...

  • e.g., response provided and data changed) 
  • Delete

Query Snapshot

Current state of

...

1 or more Queries at a point of time

Query Sources

Types of Queries 

Query Source

Query Type

Definition

System to SiteSystemQuery
Raised
raised automatically by
Data Capture System
data capture system in response to
Data Quality Issue
data quality issue (for example)
Data Management to SiteManualQuery
Raised
raised by
Data Manager
data manager for
Address
address by
Site Personnel
site personnel
Site Monitor to SiteManualQuery
Raised
raised by
Site Monitor
site monitor for
Address
address by
Site Personnel
site personnel
Coding System to SiteManual
/
| SystemQuery raised by
Coding System
coding system requiring clarification from
Site
site
Safety Reviewer to SiteManualQuery raised by
Safety Reviewer
safety reviewer (often in relation to addressing a
SAE)
serious adverse event)
Example
titleOpening a Query

Include Page
Clinical Data Query Examples - Opening a Query
Clinical Data Query Examples - Opening a Query

Example
titleQuery with Transaction History

Include Page
Clinical Data Query Examples - Transaction History
Clinical Data Query Examples - Transaction History

Pagenav2