DF_WFcrfs

DF_WFcrfs
Prev	2.3. Alphabetical Listing, Legacy Reports	Next

DF_WFcrfs — Summary of daily journal transactions for CRF validation

Synopsis

DF_WFcrfs {study} {-u userlist} { [-t yy/mm/dd-yy/mm/dd] | [-t ] } [-p #, #-#] [-x #, #-#] [-v #, #-#] [-f #] [-days] [-status] [-test]

Description

The report output shows the number of CRFs validated to each validation level on each day during the specified time period for the specified user(s). It also shows the hours during which the validation occurred and the amount of time required to perform the validations at each level.

Both -u and -t are required. A separate report is created for each user when multiple users are specified.

The report consists of one line per day, for which there was activity, during the specified date range. Each line shows the number of CRFs validated at each validation level that day. Totals appear at the bottom of the report along with statistics on the amount of time that the user spent validating CRFs at each validation level. If the specified date range spans more than one month, a separate report is created for each month.

The columns of the report appear under the common heading:

                      PRIMARY RECORD VALIDATIONS PERFORMED(1)     FINAL STATUS OF ALL CRFS(2)
DATE   FROM  TO       V1   V2   V3   V4   V5   V6   V7 TOTAL   PRf  PRi  PRp  SEC  DEL TOTAL(3)

(1)

In the columns under PRIMARY RECORD VALIDATIONS PERFORMED each CRF is counted once per day at each validation level, V1 through V7. As a result, some CRFs may be counted more than once on the same day if they were validated to more than one level on that same day.

(2)

In the columns under FINAL STATUS OF ALL CRFS each CRF page is counted only once per day and is counted at the record status last attained on that day.

(3)

The final record status is categorized by:

PRf= primary final
PRi= primary incomplete
PRp= primary pending
SEC= secondary
DEL= deleted
and TOTAL which is the sum of the record statuses shown in that row.

There are 3 different totals shown at the bottom of each validation level column. The first total, labeled TOTAL, represents the total number of different CRF pages validated at that level over all of the days in the date range. The second, labeled FOR VALIDATIONS, is the total number of validations at that level for which it was possible to determine the time required to perform the validation. This total is used to calculate the average amount of time per validation at each validation level. All validations are counted and, as a result, each CRF may be counted more than once in this total. The third total, labeled TOTAL VALIDATIONS, is the total number of times a CRF was validated at each level (and includes those cases for which the time required to perform the validation could not be determined. This total is multiplied by the average time required to validate records at that level to get the EST TOTAL TIME (estimated total time in hours) spent by the user validating records at each level.

	Validations in < 5 seconds
	A separate count is also shown for the number of validations which were performed in less than 5 seconds at each validation level. Large counts in this total would tend to indicate either a very brief review of the CRFs or that the Select > Batch Validate feature in DFexplore was being abused to change the validation level of a group of records without any visual review.

Options

-u userlist	Select records journaled by specified users (required)
-t `yy/mm/dd-yy/mm/dd`, -t	Select records that were journaled in the specified date range, inclusive (required)
-p `#, #-#`	Select specified plate(s)
-x `#, #-#`	Select specified sequence/visit(s)
-v `#, #-#`	Select records validated to specified level(s)
-f `#`	Exclude from the statistics any records that were validated in less than `#` seconds
-days	Omit the day by day statistics from the summary statistics
-status	Omit the final CRF status section of the report
-test	Test mode. Echo the options selected without performing the report.

Examples

Example 2.118. Summarize CRFs validated by user1 during Jan 2016

-u user1 -t 160101~160131

Example 2.119. Summarize CRFs validated by user1 between Dec 1,2015 and Apr 1,2016

The following strings supplied to -t are all equivalent ways of selecting the same records by date range.

-u user1 -t 151201~160401
-u user1 -t 20151201~20160401
-u user1 -t 2015/12/01~2016/04/01

Example 2.120. Summarize CRFs validated by user1 during the first half of June 2015

-u user1 -t 2015/06/01-2015/06/15
DF_WFcrfs: Work Flow - CRFs Validated per Day.    DFstudy 65. Nov 27,2015 14:31

CRF PAGES PROCESSED PER DAY FROM 2015/06/01 to 2015/06/15 BY user1

                      PRIMARY RECORD VALIDATIONS PERFORMED     FINAL STATUS OF ALL CRFS
DATE   FROM  TO       V1   V2   V3   V4   V5   V6   V7 TOTAL   PRf  PRi  PRp  SEC  DEL TOTAL

150605 09:17 15:34   109                                 109        109         1        110
150606 09:05 10:54    60                                  60         59        33         92
150608 08:41 09:23    58                                  58         58         4         62
150609 09:42 12:18    60                                  60         60         1         61
150612 09:02 09:16     9                                   9          7         3         10
150613 11:57 12:44   109                                 109        109         7        116

TOTAL                405                                 405        402        49        451
MEAN / DAY            68                                  68         67         8         75

VALIDATION TIME hrs  3.0                                 3.0
FOR VALIDATIONS      398                                 398
SEC / VALIDATION      27                                  27
VALIDATIONS < 5sec                                          

TOTAL VALIDATIONS    409                                 409
EST TOTAL TIME hrs   3.1                                 3.1

This summary is typical for a user that validates new records to level 1 only.

Prev	Up	Next
DF_SSvisitmap	Home	DF_WFcrfsperwk