DF_QCsent

DF_QCsent — Mark Query Reports as sent

Synopsis

DF_QCsent {study} { [-s] | [-u] } [ [report(s)] | [-f name] ]

Description

DF_QCsent is used to register successfully faxed Query Reports in the Query database. Invoked with -s, it sets the status of all queries included in the specified reports to "sent" and moves the reports to the QC/sent directory. Invoked with -u, it resets the status of all queries included in the specified reports to "unsent" and moves the reports from the QC/sent directory back to the QC directory. The latter option is commonly used to fix errors and undo a previous, incorrect -s invocation. As DF_QCsent modifies the Query database by changing the status of queries, it will not be possible to execute DF_QCsent when the study server is in read-only access mode.

If you use DF_QCfax to fax Query Reports, it is not necessary to subsequently run DF_QCsent as DF_QCfax will automatically run DF_QCsent, marking queries in all faxed Query Reports as sent. However, if you send out Query Reports manually (via paper fax, surface mail, etc), DF_QCsent must be run manually to register Query Reports which are successfully transmitted to the study sites.

[Important]Important

Use of DF_QCsent (either automatically via DF_QCfax or manually) is critical if -o is being used in DF_QCreports. The option gives the clinical sites a chance to respond to a previous Query Report before reasking about a problem. If a successful fax is not registered DFdiscover assumes that it was not sent and thus all unresolved queries from that report will reappear on the next Query Report, regardless of how soon it is created.

In addition to DF_QCreports, other DFdiscover applications depend on the registration of successfully transmitted documents. These include:

  • DFexplore The status of queries displayed by DFexplore distinguishes among 3 types of new queries: "not in any report", "in a report which has not been sent", and "sent". Queries will only be marked sent if their Query Reports are registered.

  • DF_QCstatus The report status will not be correctly listed unless sent reports are registered.

  • DF_QCprint DF_QCprint requires the specification of report status (sent, unsent, internal).

Registering most (but not all) newly created reports as successfully sent

This section offers two solutions to the problem of marking a large subset of the current set of new reports as being sent.

Method 1.  This first solution requires some text editing skills.

  1. Copy the QC_NEW file to a new file e.g., temp.

    cp QC/QC_NEW temp
    
  2. Edit temp to remove the 2 unsuccessful Query Reports.

    vi temp
    
  3. Execute DF_QCsent with -f temp to register the successful documents as sent.

    -s -f temp
    

Method 2.  An alternative solution is to first register all of the newly created reports followed by registering the 2 unsuccessful reports as unsent.

  1. Register all of the newly created reports as sent.

    -s
    
  2. Register the 2 unsuccessful reports (011-990415 and 022-990415 in this example) as unsent.

    -u 011-990415 022-990415
    
[Important]Important

There is a drawback to this approach that may not be immediately apparent. Following these two steps, the audit trail would show that all of the queries in reports 011-990415 and 022-990415 were first marked as sent and then shortly thereafter marked as unsent. This has no effect on the database but may not be seen as a desirable part of the audit trail.

Options

-s, -u

Register the selected Query Reports as sent or unsent, respectively (required).

Invoked with -s, the status of all queries included in the specified reports are set to "sent" and the reports are moved to the QC/sent directory. Invoked with -u, the status of all queries included in the specified reports are reset to "unsent" and reports from the QC/sent directory are moved back to the QC directory.

report(s), -f name

Select the reports to be registered.

It is possible to use UNIX wild-card characters in the specification of reports but in this case the specification must be enclosed in quotes, like this "*-980622".

The name specified in -f name may be an absolute or relative pathname. If it is relative, it is assumed to be relative to the study's QC directory.

If report numbers are specified, they are selected. If no reports are specified, and -f name is not present, all reports listed in QC_NEW are selected. If no Query Reports are specified, and -f name is present, all reports listed in name are selected. It is an error to specify reports and -f name in the same invocation. However this can be easily achieved by two invocations of DF_QCsent.

Examples

Example 2.81. Register 2 specified Query Reports as sent

-s 023-910815 024-910815

Example 2.82. Register as sent all of the unsent reports created on September 22, 2017

-s "*-170922"

See Also

DF_QCreports
DF_QCfax
DF_QCstatus
DF_QCprint