DF_XXkeys — Export keys and visit dates from required plates
DF_XXkeys extracts all visit dates and key fields from required plates in the database to create summary files used by other standard report programs. Data records with status final, incomplete, missed or pending are included. DF_XXkeys also checks for date inconsistencies (i.e. multiple dates for the same visit number), illegal dates, and duplicate primary database records. If any of these problems are found a warning message is displayed and a DFdiscover retrieval file is created.
DF_XXkeys creates summary files in the study WORKING_DIR directory
which are used by other standard report programs including:
DF_QCupdate, DF_QCreports, DF_XXtime, DF_ICvisitdates, and DF_PTcrfs.
Typically, DF_XXkeys is not run by itself as it creates no report output.
Its value is in the summary files that it creates in preparation for other
reports to run.
The summary files created by DF_XXkeys are:
DFX_keys (one record from each required plate that
contains: ID,plate,visit,status,valid)When checking for illegal and inconsistent dates, DF_XXkeys first determines which dates are illegal or invalid and includes them in the DRF file . Next, DF_XXkeys evaluates all valid VisitDates for inconsistencies. If a VisitDate is not a valid date, it will not be reported in but will appear in only.
DF_ICvisitdates reports the information found in the last 3 DRFs, namely , , and .
DF_XXkeys is run automatically by DF_QCupdate, DF_PTcrfs and DF_XXtime
to update the summary files if the database or any of the relevant
study configuration files (DFschema, DFvisit_map, DFcplate_map
or DFcterm_map) have changed since DF_XXkeys was last executed.