Query reports
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 |
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 |
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. |