Completing a DQM Event

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Modules > DQM >

Completing a DQM Event

Completing a DQM event saves the qualified updates to the DT_RESULT table and moves the event to the history list. When the DQM event is completed, the APPLY_QUALIFIER column is saved to the VALIDATOR_QUALIFIER and/or INTERPRETED_QUALIFIER columns in DT_RESULT according to the options selected.

 

When the data validation review is complete, click the Complete Event button (from either the Event Review form or the In Process Events form) to open the Complete Event Form.

DQM.Complete.button

 

DQM.Complete.button2

 

Complete Event Form

 

The Complete Event Form provides several options for saving qualifiers to the DT_RESULT table and making other changes to DT_RESULT based on those qualifiers.

 

DQM.Complete.Event.form

 

1.Merge and Save to Interpreted_Qualifiers – The selected Qualifiers are merged and saved to the INTERPRETED_QUALIFIERS column in DT_RESULT. LAB_QUALIFIERS and APPLY_QUALIFIER are selected by default.

2.Merge and Save to Validator_Qualifiers – The selected Qualifiers are merged and saved to the VALIDATOR_QUALIFIER column in DT_RESULT.

3.Validate Results (SET values of following DT_RESULT fields) – There are four options:

a.Mark Results as Validated – VALIDATED_YN is set to "Y". This is selected by default and is a recommended selection.

b.Change Detect Flag – DETECT_FLAG is set to "N" if APPLY_QUALIFIER contains one or more of the values in the Global Parameter "nondetect_result_qualifiers" (default value = "U"). This is a reasonable selection, but it is not a default selection, because it changes the result reported by the lab and some users may have a policy which forbids this action.

c.Change Detected Result Value – RESULT_TEXT and RESULT_NUMERIC is set to the value in Global Parameter "nondetect_detection_limit" column if APPLY_QUALIFIER contains one or more of the values in the Global Parameter "nondetect_result_qualifiers" (default value = "U"). This is a selection that could be used in conjunction with the Detect Flag option to create consistent report output. This is not a default selection, because it changes the result reported by the lab and some users may have a policy which forbids this action.

d.Change Reportable Result – REPORTABLE_RESULT is set to the value in the Global Parameter "reportable_result_no" (default value = "No") when APPLY_QUALIFIER contains one or more of the values in the Global Parameter "reject_result_qualifiers" (default values = "R, X"). If this option is selected, all of the other results have REPORTABLE_RESULT set to the value in the Global Parameter "reportable_result_yes" (default value = "Yes").

4.Save Button – When this button is clicked, the event is completed with the selected changes made to DT_RESULT. If the changes to the database are successful, then the event is moved to the History List (by changing the STATUS_FLAG of the User Report to "R" in ST_USER_REPORT). The records in ST_USER_REPORT_PARAMETERS, DT_NOTE, DT_RESULT_DQM and AT_DQM_RESULT are kept the same to allow the event to be viewed or re-opened.

 

Notes:

The APPLY_QUALIFIER column includes the qualifier(s) suggested by the automated DQM Check process. This column can also be manually edited to provide direct user input. The help article Processing an Event offers more details on making edits to this column.

The selected qualifiers are MERGED together (so that no qualifier is repeated) before they are saved to either the VALIDATOR_QUALIFIERS or INTERPRETED_QUALIFIERS column. Some examples include the following:

If the LAB_QUALIFIERS = "U" and the APPLY_QUALIFIER = "J", the merged value = "UJ".

If the LAB_QUALIFIERS = "U", the VALIDATOR_QUALIFIERS = "J", and the APPLY_QUALIFIER = "UJ", the merged value = "UJ".

If the LAB_QUALIFIERS = "U" and the APPLY_QUALIFIER = "J", the merged value = "UJ".

If the LAB_QUALIFIERS = "U" and the APPLY_QUALIFIER = "UJ", the merged value = "UJ".

If the LAB_QUALIFIERS = "J" and the APPLY_QUALIFIER = "J", the merged value = "J".

If the LAB_QUALIFIERS = "B", the VALIDATOR_QUALIFIERS = "U", and the APPLY_QUALIFIER = "BJ", the merged value = "BJU".

Excluding duplicates from merged values is a DQM default that may be disabled by setting RT_QUALIFIER.DQM_CHECK_RANK = 99. This applies particularly to merging single and combined qualifiers (e.g., U and UJ). Multiple instances of single qualifiers are still not duplicated, for example (assuming DQM_CHECK_RANK = 99 for "J", "U", and "UJ"):

If the LAB_QUALIFIERS = "U" and the APPLY_QUALIFIER = "J", the merged value = "UJ".

If the LAB_QUALIFIERS = "U" and the APPLY_QUALIFIER = "UJ", the merged value = "UUJ".

If the LAB_QUALIFIERS = "J" and the APPLY_QUALIFIER = "J", the merged value = "J".

If the LAB_QUALIFIERS = "B", the VALIDATOR_QUALIFIERS = "U", and the APPLY_QUALIFIER = "BJ", the merged value = "BJU".