DF_WFfaxes — Summary of elapsed time to 1st validation
DF_WFfaxes
{study}
{
[-t yy/mm/dd-yy/mm/dd]
| [-t ]
}
[-i #]
[-s]
This report summarizes the time required to validate new records (to validation level 1) for all documents received during the specified, required time period.
All CRF pages and returned Query Reports received by fax are included. Records that subsequently attain either primary or secondary status are included independent of their status.
The information provided for each fax (or EDC data entry set) is displayed under the following columns:
FAX#(1) #PAGES(2) FAX ARRIVAL(3) DATA ENTRY(4) DELAY(hr)(5) ENTRY(min)(6) Min/Page(7)
|
The identification of the fax using DFdiscover notation.
The identification is in the form | |
|
The number of pages from that fax that were entered into the study database. | |
|
The date and time of fax arrival. | |
|
The date and time that the first page from the fax was validated. | |
|
The difference, expressed in hours, between the date and time of fax arrival, and the date and time of first page validated. | |
|
The total entry time, in minutes, for all of the pages in the fax [8]. | |
|
The average entry time, in minutes per page, for each page in the fax. |
In addition to the per fax information, the report also displays per
plate information under the heading
SUMMARY BY PLATE.
For each defined plate, a summary is displayed showing:
PLATE PAGES(1) ENTRY( N(2), MEAN MIN/PAGE(3) )
|
The total number of fax pages received. | |
|
The number of these pages which contribute to the calculation of data entry time. | |
|
The average number of minutes required to validate each new record for that plate. |
These statistics are useful for comparing the amount of time required to enter different CRF plates.
-t | Select period when documents were received, inclusive (required) |
-i # | Ignore lapse times >= #min (default=5) |
-s | Create plate summary statistics only (mean data entry time by plate) |
Example 2.124. Summarize processing time for documents received in the first half of November 2017
-t 17/11/01-17/11/15
DF_WFfaxes: 00/11/01-00/11/15 DFstudy 65. Nov 27,2017 20:10 Page 1
FAX# #PAGES FAX ARRIVAL DATA ENTRY DELAY(hr) ENTRY(min) Min/Page
17460004 11 17/11/13 11:11 17/11/14 08:51 21.7 9.7 1.0
17460005 13 17/11/13 11:21 17/11/14 09:02 21.7 7.7 0.6
17460006 1 17/11/13 11:43 17/11/14 09:08 21.4 (1)
17460007 46 17/11/13 13:28 17/11/14 09:12 19.7 34.7 0.8
17460008 2 17/11/13 15:03 17/11/14 10:16 19.2 1.5 1.5
17460009 27 17/11/14 10:08 17/11/14 10:55 0.8 2.4 0.1
17460010 3 17/11/15 17:33 17/11/16 08:53 15.3 1.4 0.7
SUMMARY BY PLATE
PLATE PAGES ENTRY( N, MEAN MIN/PAGE )
1: 13 11 0.46
4: 1 1 1.00
5: 12 10 0.55
7: 6 4 0.77
8: 3 3 0.64
9: 4 4 0.27
10: 20 18 1.32
11: 7 6 0.68
12: 1 1 0.55
14: 3 2 0.86
15: 5 5 1.30
50: 1 1 0.64
501: 27 26 0.09
TOTAL: 103 92 0.62
|
As previously noted, the entry time is calculated from the inter-page difference in creation time stamps. For this reason, single page documents cannot be calculated. |
The report assumes that data management staff will validate one fax at a time, validating all pages in the fax before taking a break or getting another fax. It will fail to report accurate statistics if staff do not proceed in this way.
To overcome some of the inaccuracies created when the pages in a fax are not
all validated at the same time, or when staff take breaks or stop to answer a
phone call, the report can ignore pages which appear to have
taken an unreasonable amount of time to validate.
This is done by supplying -i.
The default interval is 5 minutes.
If the elapsed time from the creation time of the preceding page to the
creation time of the current one is greater than this, it
will not be added to the total elapsed time for that fax, and will not be
included in the reported total entry time, or in the calculation of the mean
number of minutes required per page.
To include all entries, however long, simply specify a very large number
(e.g., -i 999999 which translates to 694 days),
but remember that documents which were partially processed one day and completed
days later will appear to have taken many hours to validate per page.
[8] When new records are validated in DFexplore they receive a record creation time stamp, which records the completion of validation, not the start. Thus, for one page documents there is only one time stamp and hence the time required to enter that page can not be calculated. For documents with more than one page the time elapsed between the creation time stamps on successive pages is summed for all pages in the fax (except the first one entered). This is used to calculate the average amount of time spent validating new records.