Query Status by Site and Visit
This report is a drill-down report and uses the Subject Count as the link from the Query Status by Site and Query Status by User reports. It can also be run as a stand-alone report.
This report shows CRAs and study managers the number of queries to date in each query state for one or more visits for selected sites. CDMs use this report to review current query status by visit to help close out open queries in advance of an interim analysis or other study milestone.
Tip: For the best performance, do not select any optional filters on the Selection Criteria page.
Subtotals and totals
- Subtotals—By Site and Country.
- Totals—Overall query count totals.
Column descriptions
Column descriptions
Column |
Description |
---|---|
Country |
Data type: String Description: The country in which a site is located, as entered in the InForm Administration interface. 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. |
Visit Mnemonic |
Data type: String Description: An abbreviation of the visit title, as specified in the study design. For CRF visits, this title appears at the top of a collection of forms in the visit timeline and may not be a unique identifier. Data source: Replicated from the InForm transactional database to 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: Opened |
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 (% Queries within Country) |
Data type: Numeric (Percentage) Description: The total number of queries at the site, regardless of status. This count is a sum of Candidate, Deleted, Open, Answered, and Closed queries plus the count of Conflict queries (which are not part of this report). 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. Note: A conflict query is a query that the InForm application automatically generates when it detects a discrepancy between different copies of the same study when users synchronize them. This query type exists when the InForm application is used with the CIS application. Conflict queries can also be entered using the InForm Adapter query interface. |