DF_PTqcs — Summary report of external queries for each subject
DF_PTqcs
{study}
{-I #, #-#}
[-x]
[-a]
[
[-t yy/mm/dd]
| [-t ]
| [-t yy/mm/dd-yy/mm/dd]
| [-t ]
]
DF_PTqcs is identical in function to DF_CTqcs but it groups data by subject id range (required) whereas DF_CTqcs groups data by site.
DF_PTqcs reports a summary of the user-created, external queries added during data validation. queries are selected by their creation date from a specified time period that may include one of:
The following queries are not included in the report:
The summary is in the form of two tabular reports. The first report displays for each subject (row), columns that contain:
Example 2.34. First Tabular Report
SUBJECT TOTAL TOTAL RATE/ RESOLVED QRYS STATUS & TIME TO RESOLUTION
ID# RECORDS QRYS 100 REC # % Correct N.A. Irrel. DAYS Pending
(1) (2) (3) (4) (5) (6) (7)
|
Number of primary records created | |
|
Number of external queries created during validation | |
|
QRY rate = number of queries created per 100 primary records created | |
|
Number and percentage of these queries which have been resolved | |
|
Number of each resolution type from the list:
| |
|
Mean time (in days) from the creation of the queries to their resolution | |
|
Number of queries that have replies that are pending review |
The second table displays for each subject (row), columns that contain:
Example 2.35. Second Tabular Report
SUBJECT AGE (DAYS) NEW/UNSENT QUERIES(1) AGE (DAYS) SENT/UNRESOLVED QUERIES(2) ID# 00-10 11-20 21-30 31-60 > 60 00-10 11-20 21-30 31-60 > 60
|
Categorical time (in days) from query creation to today's date, for unresolved queries that have not been sent to the sites in a Query Report. | |
|
Categorical time (in days) from query creation to today's date, for unresolved queries that have been sent to the clinical sites. Queries with status pending are included in this category. |
An alternative report format can be requested with -a.
This format displays results in a single table that is a hybrid of the two
tables described above.
Figure 2.2. Alternative Report from -a
SUBJECT TOTAL TOTAL RATE/ RESOLVED QRYS AGE (DAYS) OF UNRESOLVED QRYS ID# RECORDS QRYS 100 REC # % <=10 11-20 21-30 31-60 >60
DF_PTqcs uses summary file which
is created by DF_XXtime.
DF_PTqcs will run DF_XXtime first, if necessary, to update unless
-x is used, in which case the results will reflect the state of
the database on the last time that DF_XXtime was run.
-I | Include only specified subjects (required) |
-a | Alternative format shows age of unresolved queries (instead of query status) |
-t | Include records and queries created since specified date, inclusive of the specified date |
-t | Include records and queries created between specified dates, inclusively |
This report cannot be used to obtain the status of internal queries or external queries created for missing pages and overdue visits.
Mean days from creation to resolution is based on those queries that have been resolved so far and thus may not reflect the true average time if there are many unresolved queries of long duration.