# Report/Graph page: Query Aging by Site

Subtotals and totals

- Subtotals—By Country.
- Totals—Overall query aging 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.
Total Open | Data type: Numeric Description: For each site, the number of queries with a current status of Open. How calculated: For each site, all queries with a current status of Open are counted, regardless of query type. Note that this total includes queries that were opened, answered, and then reissued. Data source: Derived and stored in the Reporting and Analysis database.
Average Age of Open | Data type: Numeric Description: For each site, the average number of days that a query is in the Open state. How calculated: This calculation only applies to queries with a current status of Open. The number of days is calculated by subtracting the date when a query was last opened from the current date. Data source: Derived for the report; not stored in the Reporting and Analysis database.
Queries Open (% of Total Open for Country) | Data type: Numeric (Percentage) Description: The number of open queries that have been open for specific intervals of time. You specify the aging interval (in days) on the report prompt page. For example, if you specify 7, the resulting report shows the number of queries that have been open for: Seven or fewer days. More than 7 but equal to or fewer than 14 days. More than 14 but equal to or fewer than 21 days. More than 21 but equal to or fewer than 28 days. More than 28 days. How calculated: This value is calculated in multiples of 24 (hours). For example, if the query is opened at 10 AM on day 1 and the report is run 10 days later at 9 AM., the days open is 9. The number of queries in the date range is followed by a percentage of the total open query count per country. For each country, the percentage is calculated as follows: [open queries within aging interval] * 100 / [total number of open queries] Data source: Derived and stored in the Reporting and Analysis database. Percentage derived for display.

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