Query reports

  • Published by Viedoc System 2024-10-10
  • Print

Query reports

The query reports show query data and statuses at different levels across the studies. They provide details on query metrics for Manual and Validation queries, Manual queries, Validation queries, and Pre-queries.

Manual and validation queries

You can sort the data to focus on query status by country, site, event, subject, form or query table, with the following columns showing, respectively:

by Country

  • Study, Country, Total
  • # of Manual and Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)
  • Number of Subjects
  • Queries/Subject
  • % of Queries in Trial

by Site

  • Study, Country, Site Code, Site Name, Total
  • # of Manual and Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)
  • Number of Subjects
  • Queries/Subject
  • % of Queries in Trial
  • Number of Queries in Country

By Event

  • Study, Country, Site Code, Site Name, Event, Total
  • # of Manual and Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

By Subject

  • Study, Country, Site Code, Site Name, Subject,Total
  • # of Manual and Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

By Form

  • Study, Country, Site Code, Site Name
  • Event, Event Sequence, Subject, Form, Form Sequence, Total
  • # of Manual and Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

Query Table

Note! Query table is the sub-report previously named Queries with the following columns showing:

  • Study, Country, Site Code, Site Name,
  • Query Sequence, Subject, Event, Event Sequence
  • ActivityId, Activity Name, Form, Form Sequence, Item,
  • Query Type, Query Text, Query Status, Query resolution
  • Time to (days)
  • Time of Query Cycle (days)
  • Age of (days)
  • Raised By
  • Raised On
  • Latest Action By
  • Latest Action On
  • History

Note! The Raised By column shows the queries raised by the Viedoc system or the name of the user who raised the query. The Raised On column shows the time and date the query was raised.

Manual queries

You can sort the data to focus on manual queries by country, site, event, subject, form or most manually queried items, with the following columns showing, respectively:

by Country

  • Study, Country, Total
  • # of Manual Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)
  • Number of Subjects
  • Queries/Subject
  • % of Queries in Trial

by Site

  • Study, Country, Site Code, Site Name, Total
  • # of Manual Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)
  • Number of subjects
  • Queries/Subject
  • % of Queries in Trial
  • % of Queries in Country

By Event

  • Study, Country, Site Code, Site Name, Event, Total
  • # of Manual Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

By Subject

  • Study, Country, Site Code, Site Name, Subject,Total
  • # of Manual Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

By Form

  • Study, Country, Site Code, Site Name
  • Event, Event Sequence, Subject, Form, Form Sequence, Total
  • # of Manual Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

Most manually Queried Items

  • Study
  • FormId, Form,
  • ItemId, Item
  • Total # of Raised Queries
  • # of Open Queries
  • # of Queries Resulting in Data Change

Validation queries

by Country

  • Study, Country, Total
  • # of Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)
  • Number of Subjects
  • Queries/Subject
  • % of Queries in Trial

by Site

  • Study, Country, Site Code, Site Name, Total
  • # of Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)
  • Number of Subjects
  • Queries/Subject
  • % of Queries in Trial
  • Number of Queries in Country

By Event

  • Study, Country, Site Code, Site Name, Event, Total
  • # of Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

By Subject

  • Study, Country, Site Code, Site Name, Subject,Total
  • # of Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

By Form

  • Study, Country, Site Code, Site Name
  • Event, Event Sequence, Subject, Form, Form Sequence, Total
  • # of Validation Queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Queries Open
  • Average time to (days)

Most Triggered Validation Queries

  • Study
  • FormId, Form,
  • ItemId, Item
  • Range check OID
  • Edit Check
  • Total # of Raised Queries
  • # of Open Queries
  • # of Queries Resulting in Data Change

Pre-queries

by Country

  • Study, Country, Total
  • # of Pre-queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Pre-queries not Released
  • Average Time to Release (days)
  • Number of Subjects
  • Pre-queries/ Subject
  • % of Pre-queries in Trial

by Site

  • Study, Country, Site Code, Site Name, Total
  • # of Pre-queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Pre-queries not Released
  • Average Time to Release (days)
  • Number of Subjects
  • Pre-queries/ Subject
  • % of Pre-queries in Trial
  • % of Pre-queries in Country

By Event

  • Study, Country, Site Code, Site Name, Event, Total
  • # of Pre-queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Pre- queries not Released
  • Average Time to Release (days)

by Subject

  • Study, Country, Site Code, Site Name, Subject,Total
  • # of Pre-queries
  • Ratio (%)
  • # of Pre-queries not Released
  • Average Time to Release (days)

By Form

  • Study, Country, Site Code, Site Name
  • Event, Event Sequence, Subject, Form, Form Sequence, Total
  • # of Pre-queries
  • Resulting in Data Changes
  • Ratio (%)
  • # of Pre-queries not Released
  • Average Time to Release (days)

Most Pre-queried items

  • Study
  • FormId, Form
  • ItemId, Item
  • Total # of Raised Pre-queries
  • # of Unreleased Pre-Queries
  • # of Open Queries
  • # of Pre-queries Resulting in Data Change

Column descriptions

Below you will find detailed descriptions of the different columns in the sub reports:

# of manual and malidation/manual/validation/pre-queries

Sub report Field Description
Country, Site, Event, Subject, Form Raised Number of queries/pre-queries in the raised state.
Country, Site, Event, Subject, Form Rejected Number of queries/pre-queries in the rejected state.
Country, Site, Event, Subject, Form Approved Number of queries in the approved state.
Country, Site, Event, Subject, Form Closed Number of queries in the closed state.
Country, Site, Event, Subject, Form Removed Number of queries/pre-queries in the removed state.
Country, Site, Event, Subject, Form Promoted Number of pre-queries in the promoted state.
Country, Site, Event, Subject, Form Released Number of pre-queries in the released state.

Total

Sub report Description
Country, Site, Event, Subject, Form Total number of manual and validation queries/manual/validation/pre-queries

Resulting in data changes

Sub report Description
Country, Site, Event, Subject, Form Number of times a query/pre-query is resolved due to a data edit.

Ratio (%)

Sub report Field Description
Country, Site, Event, Subject, Form Updates / Query Queries resulting in data changes / resolved+rejected+approved+closed queries.
Country, Site, Event, Subject, Form Queries / Item Number of total queries / Number of items entered in the CRF.
Country, Site, Event, Subject, Form Updates / Pre-query Number of times a pre-query is resolved due to a data edit
/ Number of raised pre-queries in a pre-query rejected/query resolved/query approved/query rejected/ query closed state.
Country, Site, Event, Subject, Form Released / Pre-query Number of released pre-queries for that subject / Total number of pre-queries for that subject.
Country, Site, Event, Subject, Form Modification / Pre-query Count of when a text is modified / Total number of pre-queries for that subject.
Country, Site, Event, Subject, Form Pre-queries / Item Total number of pre-queries for that subject / Total number of items entered in the CRF for that subject.

# of queries open

Sub report Field Description
Country, Site, Event, Subject, Form > 7 days Open queries with the duration in days of >7 and not >14.
Country, Site, Event, Subject, Form > 14 days Open queries with the duration in days of >14 and not >21.
Country, Site, Event, Subject, Form > 21 days Open queries with the duration in days of >21.

# of pre-queries not released

Sub report Field Description
Country, Site, Event, Subject, Form > 7 days Number of raised or promoted pre-queries, with the difference between the date the pre-query was raised raised and the system date > 7 and not >14.
Country, Site, Event, Subject, Form > 14 days Number of raised or promoted pre-queries, with the difference between the date the pre-query was raised raised and the system date > 14 and not >21.
Country, Site, Event, Subject, Form > 21 days Number of raised or promoted pre-queries, with the difference between the date the pre-query was raised raised and the system date >21.

Average time to (days)

Sub report Field Description
Country, Site, Event, Subject, Form Resolution The amount of time between a Query Raised to a Query resolved or Query closed.
Country, Site, Event, Subject, Form Approval The amount of time between a Query Resolved to a Query Approved or Query Rejected.

Note!

  • This column is empty if no queries have the approved status.
  • This column has a 0 if a query has been approved and resolved on the same date.

Average time to release (days)

Sub report Description
Country, Site, Event, Subject, Form The average time to release for all pre-queries in the form if the pre-query is either released as query, rejected, or removed.

Note!

  • This column is empty if no queries have the approved status.
  • This column has a 0 if a query has been approved and resolved on the same date.

Number of subjects

Sub report Description
Country Total number of subjects in that country.
Site Total number of subjects in that site.

Queries/subject

Sub report Description
Country, Site The total number of manual and validation/manual/validation queries in a country/site / the total number of subjects in a country/site.

Pre-queries/subject

Sub report Description
Country, Site The total number of pre-queries / the total number of subjects.

% of queries in trial

Sub report Description
Country, Site The total number of manual and validation/manual/validation queries in a country/site / the total number of queries in the study.

% of pre-queries in trial

Sub report Description
Country, Site The total number of pre-queries in a country/site / the total number of pre-queries in the study.

% of queries in country

Description
The total number of manual and validation/manual/validation queries in a site / the total number of queries in the country.

% of pre-queries in country

Description
The total number of pre-queries in a site / the total number of pre-queries in the country.

Query sequence

Description
The query study sequence number.

Query type

Type Description
Manual and Validation Queries Defines manually raised queries and automatically raised queries as a result of validation.
Validation Defines automatically raised queries as a result of validation.
Manual Defines manually raised queries.

Query status

Sub report Field Description
Country, Site, Event, Subject, Form, Query table, Pre-queries Raised Includes Raised queries
Country, Site, Event, Subject, Form, Query table, Pre-queries Removed Includes Removed queries
Country, Site, Event, Subject, Query table, Form Approved Includes Approved queries
Country, Site, Event, Subject, Form, Pre-queries Rejected Includes Rejected queries
Country, Site, Event, Subject, Query table, Form Resolved Includes Resolved queries
Country, Site, Event, Subject, Query table, Form Closed Includes Closed queries
Pre-queries Promoted Includes Promoted queries
Pre-queries Released Includes Released queries

Query text

Description
The text of the query message, applicable for both validation and manual queries.

Raised by

Description
The username and user ID of the user who raised the query.

Raised on

Description
The time in UTC (Coordinated Universal Time)
when the query was raised.

Latest action by

Description
The username and user ID of the user who performed an action on the query.

Latest action on

Description
The time in UTC (Coordinated Universal Time) when the action was taken on the query.

History

Description

Current query state, the name of the user who performed the changes, followed by the user ID in parentheses, and the text explaining a resolution, if one was entered.

Note! Each query can have one or more rows.

Time of query cycle (days)

Sub report Description
Query table The amount of time between a Query Raised to a Query Approved or a Query Rejected or a Query Closed.

Age of open query (days)

Sub report Description
Query table The amount of days since a query was Raised (with no action taken on the query) to the current date.

Age of resolved query (days)

Sub report Description
Query table The amount of days since a query was Resolved. The amount of days between when the query is resolved until the current date for all queries that are Resolved, that is, not yet actioned by the query reviewer.

Query resolution

Sub report Description
Query table The Query Resolution text from the current Query Status.

Time to resolution (days)

Sub report Description
Query table The amount of time between a Query Raised to a Query resolved or Query closed.

Time to approval (days)

Sub report Description
Query table The amount of time between a Query Resolved to a Query Approved or Query Rejected.

Item

Description
The item on which a query is raised.

Total # of raised queries

Sub report Description
Most Manually Queried Items
Most Triggered Validation Queries
Total number of queries.

Total # of raised pre-queries

Sub report Description
Most Pre-queried Items Total number of prequeries

# of unreleased pre-queries

Sub report Description
Most Pre-queried Items Number of prequeries in the raised and promoted state

# of open queries

Sub report Description

Most Manually Queried Items
Most Triggered Validation Queries

Number of queries with the status Raised.

Most Pre-queried Items Number of pre-queries in raised state which are released from prequery state

# of queries resulting in data change

Sub report Description

Most Manually Queried Items
Most Triggered Validation Queries
Most Pre-queried Items

Number of times a query/pre-query is resolved due to a data edit.

Edit check

Sub report Description
Most Triggered Validation Queries Consists of the actual query text.