Note: An Event must be saved initially, before it can be processed and/or completed. See the description of the initial save here.
A DQM event can be re-saved repeatedly during the validation process and re-opened to continue the review. This can be critical for data sets with numerous records that may require multiple days to review.
After changes have been made to an event, the Save Event button turns red again (see image below).
Click this button to re-save these event elements to the following tables so they can be recalled when the event is re-opened:
•Changes to the Exceptions, including Manually Applied Qualifiers:
▪All of the exceptions and associated results are stored in DT_RESULT_DQM.
▪The Event's Created Date is stored in the DT_RESULT_DQM.DQM_DATE column to allow these records to be retrieved.
▪The DQM suggested qualifier is saved in the DT_RESULT_DQM.QUALIFIER column.
▪The APPLY_QUALIFIER and APPLY_REMARK are saved in the DT_RESULT_DQM columns of the same name.
▪The EX_OR_ASSO column tracks whether the result was an exception or an associated result.
•Changes to Sample DQM Status:
▪The DQM_STATUS and DQM_STATUS_REMARK are saved in the existing records of DT_SAMPLE.
These values are saved in the above tables when the event is saved to allow an event to be re-opened. DT_RESULT is not updated until the event is completed.
Note: The initial event input dataset (saved in RT_USER_REPORT, DT_NOTE, and AT_DQM_RESULT) is maintained throughout event processing. Additions to Sample\Test\Result data after the event was created are not reflected in a re-opened event.
Click the Back Arrow button to send or return the user to the DQM Event Review Form.
In Process Events for the facility are listed in the upper section of the DQM In Process Events Form in a table that can be sorted and/or filtered by clicking the filter button at the top of any column.
The bottom of the DQM In Process Events Form shows the "Event Summary" and the "SDG Status" from the selected Event.
Note: The bottom section of the form updates automatically as the user selects a new row in the top section.
The “SDG Status” tab is an editable form that allows the user to select an “SDG Status”, “Date”, and “Reviewer” to assist DQM users in recording the status of the In Process event, based on the DQM workflow in use.
If DT_SDG.SDG_STATUS is not already populated, DQM automatically populates "Validation Begun" for the selected SDGs after saving a DQM Event. Since "Validation Begun" is auto-generated, it populates based on the current local language setting when the Event is saved. Therefore, if events are saved by different users in multiple languages, the SDG_STATUS column will be populated with various translations of "Validation Begun".
To configure client-specific “SDG Status” functionality:
A.Populate the desired “SDG Status” in RT_LOOKUP with LOOKUP_TYPE = sdg_status and the LOOKUP_CODE being the desired unique status.
B.Populate the “Reviewer” in DT_PERSON by populating the person_name, company_code, first_name, last_name, and custom_field_1=data reviewer. Note that company_code must be populated in RT_COMPANY.
1.The Re-Open Event button will open the selected event in the Event Review Form in edit mode.
2.The Start Event button will open the Start Event Form with nothing selected.
3.The Complete Event button will open the selected event in the Complete Event Form.
4.The Export Event button will open the selected event in the Export Event Form.
5.The Delete Event button will delete the selected event from ST_USER_REPORT.
6.The History button will open the DQM Completed Events Form.
When returning to work on an event, click DQM In Process Events from the Data tab to open the form (and select event from in-process list).
Symptoms: Message received when selecting the Review All Results tab or saving an event:
Specified argument was out of the range of valid values.
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
at Syncfusion.Grouping.RecordsInTableCollectionBase.get_Item(Int32 index)
at ProcessEvent.TabControl1_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.TabControl.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.TabControl.WndProc(Message& m)
Cause/Details: This error occurs when there are no results for the specified data set. One possible cause why 0 results are being returned is that DT_TEST_BATCH.TEST_BATCH_TYPE does not match the RT_DQM_CHECK_PARAM.TEST_BATCH_TYPE.
Resolution/Workaround: Please confirm the data set does contain results that match the QAPP values.
Symptoms: Message received when saving an event:
ERROR: # Exception Rows failed to Save! This will cause the entire transaction to be Rolled Back and no part of the Event will be Saved.
Cause/Details: There are several possible causes for this error:
•Prior to Build 19214, a single quote/apostrophe in the remark field. This was resolved in release note 171884. For example, “The parent sample’s recovery was within limits” or “spike recoveries couldn’t be resolved”. If using a pre-19214 Build, please check that the remarks fields in the QAPP do not include a single quote.
•RT_DQM_RULE.QUALIFIER or ND_QUALIFIER columns are NULL. In the cases where a qualifier is not appropriate, you may add the qualifier "NQ" to the qualifier field in the RT_DQM_RULE table. DQM does have an option to handle these NQ qualifiers by using the parameter set_NQ_to_NULL in the Global Parameters.
•In builds prior to 18.104.22.16800, multiple values TEST_BATCH_TYPE parameter in the Global Parameters Check of the QAPP were not allowed.
•RT_QUALIFIER does not contain a record for 'NQ'.
Resolution/Workaround: Please see the list of causes above to review the QAPP settings, along with data and reference tables.
Copyright © 2021 EarthSoft, Inc • Modified: 25 Jan 2021