Query Status by User

This report shows CRAs and study managers the raw numbers of queries to date in each query state for one or more sites, by user, with the option to drill down into the list of queries for visits or subjects for a specific site.

Tip: For the best performance, do not select any optional filters on the Selection Criteria page.

Subtotals and totals

Subtotals—None.
Totals—Overall query count totals.

Drill-through reports

This report contains links to two drill-through reports:

Click a value in the Site Mnemonic column to drill down to the Query Status by Site and Visit report for the selected site.
Click a value in the Subject Count column to drill down to the Query Status by Site and Subject report for the subjects included in the count.

Column descriptions

Column	Description
Rights Group	Data type: String Description: The InForm rights group to which the user belongs. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
User Name	Data type: String Description: The user name of the InForm user. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Site Mnemonic	Data type: String Description: An abbreviation that identifies a site, as entered in the InForm Administration interface. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Subject Count	Data type: Numeric Description: The number of subjects who enrolled at the site. How calculated: For each site, counts subjects who enrolled at the site, including subjects who are currently assigned other states. Note: The Enrollment form, designed according to InForm specifications, must be completed for the subject. UUID: PF_SC_COMPLETECTL Data source: Status is determined by the value on the Enrollment form, which is stored in the Reporting and Analysis database. Status is set to 1 when the subject is enrolled. Note: You can use any of the predefined subject filters to further qualify this count.
Avg Queries per Patient	Data type: Numeric Description: The average number of queries associated with each subject at the site. How calculated: Counts the average number of unique queries per subject for the site, regardless of status, by dividing the number of queries for the site by the subject count for the site. This calculation counts manual, automatic, or both types of queries, based on your selection for the Query Types prompt. Data source: Derived for the report; not stored in the Reporting and Analysis database.
Query Count: Candidate	Data type: Numeric Description: For each site, the number of queries with a current status of Candidate. How calculated: Counts queries with the current status of Candidate. Counts manual, automatic, or both types of candidate queries, based on your selection in the Query Type filter on the report prompt page. Data source: Derived and stored in the Reporting and Analysis database.
Query Count: Deleted	Data type: Numeric Description: For each site, the number of queries with a current status of Deleted. How calculated: Counts queries with a current status of Deleted. Counts manual, automatic, or both types of deleted queries, based on your selection in the Query Type filter on the report prompt page. Data source: Derived and stored in the Reporting and Analysis database.
Query Count: Open	Data type: Numeric Description: For each site and visit, the number of queries with a current status of Open. How calculated: Counts all open queries for each site. Counts manual, automatic, or both, based on your selection in the Query Type filter on the report prompt page. Data source: Derived and stored in the Reporting and Analysis database.
Query Count: Answered	Data type: Numeric Description: For each site, the number of queries with a current status of Answered. How calculated: Counts all answered queries for each site. Counts manual, automatic, or both types of answered queries, based on your selection in the Query Type filter on the report prompt page. Data source: Derived and stored in the Reporting and Analysis database.
Query Count: Closed	Data type: Numeric Description: For each site, the number of queries with a current status of Closed. How calculated: Counts all closed queries for each site. Counts automatic, manual, or both types of closed queries, based on your selection in the Query Type filter on the report prompt page. Data source: Derived and stored in the Reporting and Analysis database.
Query Count: Total (% of all Queries)	Data type: Numeric (Percentage) Description: The total number of queries at the site, regardless of status. For each site total, this column also displays the percentage of total queries for the country at the site. How calculated: Counts automatic, manual, or both types of closed queries, based on your selection in the Query Type filter on the report prompt page. The percentage is calculated as follows: [% of total within country] = [query count for the site] 100 / [query count for the country]* Data source: Derived and stored in the Reporting and Analysis database. Percentage derived for display.