Analyze query summary details
In the Study Analytics dashboard, you can view different charts to get an instant insight into the current state of the EDC processes and entities, such as sites, subjects' phases, opened/answered queries, and so on. In the Query Summary bar chart, you instantly get information about the total number of manual and system queries existing in the following phases: Open Queries, Answered Queries, and Closed Queries.
If you want to view a detailed analysis of the queries, then using this functionality, you can get information about each query, such as which site and study the particular query exists at, the form in which the query is added, the query type: system or manual, and so on.
-
In the EDC application header, select the DASHBOARD tab.
-
On the page that opens, select the Study Analytics tab.
-
From the Query Summary bar chart, select Go Details
.
Figure 1. Selecting option to view query summary details
-
On the page that opens, in the Query Summary table, analyze the subject details as explained in the following table.
Figure 2. Query summary details
Tip
From the page shown in the preceding figure, you can navigate to any of the following tables to view the corresponding elaborative summary of the chart:
Element
Details
Record ID
Represents the record identification number of a query that is based on the total count of the queries that are ever created or exist in the EDC application.
For example, before you added your query, there already existed three queries in EDC. Regardless of whether the existing queries are closed, answered, or opened, the newly created query will be assigned the Record ID "4."
Site Code
Represents the site code in which the query exists.
Subject ID
Represents the identification code of the subject in which the query exists.
Visit Name
Represents the visit name in which the query exists.
Form Name
Represents the name of the eCRF in which the query is added.
Record SN
Represents the serial number of the eCRF form in which the query is added.
Question
Represents the eCRF question to which the query is added.
Variable
Represents the question variable in which the query is added, such as AETERM (adverse event term), TYPESEQ (type of sequelae), and others.
Type
Represents the query type that can be as follows:
-
System: signifies that the query is system-generated as a result/consequence of a process.
-
Manual: signifies that the query is created manually by a user.
Status
Represents the status of a query that can be any of the following:
-
Open: signifies that the query is not answered by assigned personnel.
-
Answered: signifies that the query is answered by assigned personnel.
-
Close: signifies that the query is answered and now closed by the user who created the query.
Overdue
Represents whether the query has passed its deadline as set at the time of query creation.
Query Topic
Represents the query inquired by the system or the system user.
-
Once you have analyzed the query details, from the workspace toolbar, select 
to go back to the Study Analytics page.