DF_PTcrfs — Display available CRF information for subjects
DF_PTcrfs
{study}
[-c #, #-#]
[-i #, #-#]
[-p]
[-x]
[-l #]
DF_PTcrfs lists all assessments received for each subject with the date of the assessment and the status of all pages of the CRF received for that visit, including both required and optional pages.
Each row of the output displays the subject ID, the visit number, the visit
date if known, and a list of plate numbers received for that subject ID
and visit.
Each plate number has an optional suffix that identifies the highest
priority problem on that plate, if any.
The code and meaning of each suffix is shown in the figure.
Those in the first column are not mutually exclusive
and are listed in priority order.
For example, a plate which has both an unresolved Q&A note and
an unresolved internal query will have the suffix ?
because the Q&A note takes precedence.
A plate number that has no suffix is considered to be final.
Figure 2.1. Legend of suffix codes and their meaning
QUERY CODES (ordered by priority): OTHER CODES:
r = outstanding refax request - = missing page
? = unresolved Q&A note x = registered as missed
i = unresolved internal query * = error status (missing keys)
+ = incomplete but no unresolved queries p = pending status
NA = visit date is coded Not Available
The - suffix used to identify missing plates is
determined from the Query database where missing plate queries are inserted
by DF_QCupdate.
DF_QCupdate must be executed to update the Query database before running DF_PTcrfs
if the status of missing plates is likely to have changed, generally
because new records have been validated since DF_QCupdate was last run, or
the visit map was changed.
-c | Select only subjects from specified sites. By default, subjects from all sites, including the error monitor site, appear in the output. |
-i | Select only subjects with specified IDs. By default, all subjects from all sites, including the error monitor site, appear in the output. |
-p | Execute DF_XXkeys, but only list plates with problems. With this option, plates that would otherwise have no suffix are not displayed. |
-l | Set maximum length of output line to
#chars
(default # = 80) |
Example 2.19. List CRF information for all subjects at site 99
-c 99
DF_PTcrfs: CRFs Received at Each Visit. DFstudy 254. Dec 09,2014 14:39
Complete CRF Log by Subject : Acceptance Test Kit
QRY CODES (ordered by priority): OTHER CODES:
r = outstanding refax request - = missing page
? = unresolved Q&A note x = registered as missed
i = unresolved internal query * = error status (missing keys)
+ = incomplete but no unresolved queries p = pending status
NA = visit date is coded Not Available
SUBJECT VISIT DATE CRF PLATES
99001 0 03/03/97 1
99001 1 06/03/97 2 3 4
99001 21 06/04/97 5
99001 22 06/05/97 5
99001 23 06/06/97 5
99001 24 06/07/97 5
99001 30 06/07/97 6- 7
99001 51 8
99001 201 11
99001 1011 9
99002 0 04/01/97 1
99002 1 08/01/97 2 3 4
99002 21 08/02/97 5
99002 22 09/03/97 5
99002 23 10/04/97 5
99002 24 07/05/97 5
99002 30 07/05/97 6 7
99002 40 12/06/97 10
99002 51 8
99002 1011 9p
99003 0 07/01/97 1
99004 0 01/06/97 1
99004 1 03/06/97 2 3 4
99004 21 04/07/97 5
99004 22 05/08/97 5
99004 23 06/09/97 5
99004 24 06/10/97 5
99004 30 06/10/97 6 7
99004 201 11
99006 201 11
99007 0 23/04/97 1
99007 1 25/04/97 2p 3 4x