DF_CTcrfs — Summary report of records received from each site
DF_CTcrfs
{study}
[-x]
[-c #, #-#]
[-S #, #-#]
[-P #, #-#]
[-i rom]
[-R]
[
[-t yy/mm/dd]
| [-t ]
| [-t yy/mm/dd-yy/mm/dd]
| [-t ]
]
DF_CTcrfs reports a summary of the time required for database processing of records received, during a specified time period, from each study site including the error monitor site. Time periods can be selected:
Only visits and plates defined in the study visit map are included in this report.
The tabular report displays for each site (row) columns that contain:
Activity (since the beginning of the study or since the specified date). The activity is reported by:
Time (mean days) from visit date to first document transmission. If re-submits exist for a plate only the first arrival (earliest document date) is used [2].
Time (mean days) from visit date to data entry (initial record creation). The number of days between the subject visit and the date that the initial data record was created for that CRF, regardless of how many re-submits may have occurred[2].
Time (mean days) from visit date to a final database record.
If re-submits exist only the primary "final" record is used. If the primary record
is not yet a "final" record, the time from the visit date to today's date
is used, and a + is appended to the displayed average to
indicate that it is based on incomplete data, and would be at least the
value shown[2].
How clean is the database? The percentage of records that were final on first arrival and the percentage of records that are final now form the last 2 columns of the report. Clean on first arrival is determined by comparison of the record creation and last modification dates. If a record reaches final status on the same day it was first created, and the data on the record is not subsequently modified, it is considered to be "final on arrival" (Note: changing the validation level on a data record does not result in a change in the modification date stamp unless data fields are changed as well).
-c | Include only the specified site IDs. |
-S | Include only the specified visit or sequence numbers. |
-P | Include only the specified plates. |
-i rom | Include only the specified types of plates;
r=required,
o=optional,
m=missed visit
|
-R | Exclude EDC data entry and imported data. This option results in exclusion of records which were not submitted externally, that is, any EDC data entry records and any imported records in which a null image name (i.e. 0000/0000000) has been used. |
-t | Include records in visits occurring since specified date, inclusive of the specified date |
-t | Include records in visits occurring between specified dates, inclusively |
Only visits & plates defined in the visit map are included. This report focuses on time since each subject visit and thus only includes visits and plates that are defined in the study visit map. Both required and optional plates defined for each visit (or sequence) number are included.
Only records with valid dates are used in the time
calculations.
The denominator for the mean time between visit and image arrival requires both
a visit date and a image arrival date. If either is unavailable that record
will
not be included in the calculation of the mean.
If the site has no subjects with usable visit dates,
N/A is output for the
DB Entry and DB Clean columns.
Similarly, if none of the CRFs for the current site
can be found in
/opt/dfdiscover/work/fax_log,
N/A is output for the
Fax In column.
[2] The number of records used in this calculation may be less than the total number of primary records received if some of the records do not have a visit date.