# Report/Graph page: Query Cycle Times by User

Subtotals and totals

- Subtotals—By User Name and Rights Group.
  - Min—Lowest minimum value for any site for this user.
  - Max—Highest maximum value for any site for this user.
  - Median—No value.
- Totals—Overall query cycle time totals.
  - Min—Lowest minimum value for any site for this user.
  - Max—Highest maximum value for any site for this user.
  - Median—No value.

Column descriptions

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.
Query Count | Data type: Numeric Description: The total number of number of open, answered, and closed queries. How calculated: This calculation counts all open, closed, and answered queries, based on your selection in the Query Type filter on the report prompt page. This count does not include queries that have never been opened (candidate queries or deleted candidate queries). Data source: Derived and stored in the Reporting and Analysis database.
Open to Answered (Days): Min, Max, Median | Data type: Numeric Description: Data on the number of days from when queries are opened to when they are answered. For each user, columns display: Minimum—The fewest number of days for an opened query to be answered for this user. Maximum—The greatest number of days for an opened query to be answered for this user. Median—The median of the opened-to-answered range for all answered queries for this user. How calculated: The calculation begins on the first day when the status of a query was set to Open and ends on the most recent day when the status of a query was set to Answered. This value is calculated in multiples of 24 (hours) and is rounded down to the nearest whole number. For example, if a query is opened on day 1 at 10 AM and answered on day 3 at 9 AM, the Open to Answered value is 2 days. Data source: Derived for the report; not stored in the Reporting and Analysis database.
Answered to Closed (Days): Min, Max, Median | Data type: Numeric Description: Data on the number of days from when queries are answered to when they are closed. For each user, columns display: Minimum—The fewest number of days for an answered query to be closed for this user. Maximum—The greatest number of days for an answered query to be closed for this user. Median—The median of the answered-to-closed range for all closed queries for this user. How calculated: The calculation begins on the first day when the status of a query was set to Answered and ends on the most recent day when the status of a query was set to Closed. This value is calculated in multiples of 24 (hours) and is rounded down to the nearest whole number. For example, if a query is answered on day 1 at 10 AM and closed on day 3 at 9 AM, the Answered to Closed value is 2 days. Data source: Derived for the report; not stored in the Reporting and Analysis database.
Open to Closed (Days): Min, Max, Median | Data type: Numeric Description: Data on the number of days from when queries are opened to when they are closed. For each user, columns display: Minimum—The fewest number of days for an opened query to be closed for this user. Maximum—The greatest number of days for an opened query to be closed for this user. Median—The median of the opened- to-closed range for all closed queries for this user. How calculated: The calculation begins on the first day when the status of a query was set to Open and ends on the most recent day when the status of a query was set to Closed. This value is calculated in multiples of 24 (hours) and is rounded down to the nearest whole number. For example, if a query is opened on day 1 at 10 AM and closed on day 3 at 9 AM, the Answered to Closed value is 2 days. Data source: Derived for the report; not stored in the Reporting and Analysis database.

Copyright © 2013 Oracle and/or its affiliates. All rights reserved.