How to Update Existing QAPPs

<< Click to Display Table of Contents >>

Navigation:  Professional > DQM >

How to Update Existing QAPPs

DQM Update QAPP EDDs

How to Update An Existing DQM QAPP Using the Update QAPP EDD

How to Update the New Columns in RT_HOLDING_TIME for an Existing QAPP

 

DQM Update QAPP EDDs

 

DQM QAPP Updates v6.6.1 - 7.20.1

DQM QAPP Updates 7.20.3

DQM QAPP Updates 7.20.4

DQM QAPP Updates v7.21.1

 

There are significant updates to the DQM-refvals format and DQM Starter QAPP.xlsx EDD installed at /EQuIS/Formats/DQM in build 7.20.4. The updates support new DQM functionality in build 7.20.4 and include:

 

A new RT_HOLDING_TIME_V2 section replaces the old. The new tab includes a reordering of all fields, a new column-DQM_PRESERVED_YN, a removed column-CALCULATION_UNIT, and three new holding time intervals:

collect_preserve

preserve_prep

preserve_analysis

The RT_HOLDING_TIME.CALCULATION_UNIT are now automatically populated during the EDD upload as the singular (e.g. "Day") version of the plural RT_HOLDING_TIME.HT_UNIT (e.g. "Days").

A new Batch Completeness check, with three rules, three reason codes, and five check parameters.

Parameters additions: Nine new parameters for RPD check, Six new parameters for Spike Recovery 2 check, three new parameters for Field RPD check, two new parameters for the Required Detection Limit check, and one new parameter for the Holding Time check.

 

Note that since the DQM-refvals format is restructured, EDDs of the previous version must be updated to load successfully.

 

How to Update An Existing DQM QAPP Using the Update QAPP EDD

 

For initial configuration of DQM QAPP Settings, use the “DQM Starter QAPP” EDD and the “Getting Started with DQM” instructions.

 

Follow the instructions below to update existing DQM QAPP Settings configured with a previous version of EQuIS\DQM to a newer version.  

 

A “DQM QAPP Updates vX.XX.X” EDD has been created for each new DQM version for which changes were made that included new DQM QAPP Settings, commencing with version 6.6.1 (there were no such additions made for v7.20.2, so no EDD exists for that update). Each new “DQM QAPP Updates” EDD file only contains the new settings associated with the new DQM version, whereas each new “DQM Starter QAPP” EDD contains all of the DQM configuration data for a completely new QAPP.

 

Note: If you are updating to a version more than one step up, you must use the “DQM QAPP Updates” EDD files in successive order of DQM version to prevent errors from trying to upload new rules and parameters associated with a check that does not yet exist in your current DQM QAPP.

 

1.Download the “DQM QAPP Updates” EDD or EDDs that you will be using from the links above.

 

Tips: If you have a DQM Starter QAPP EDD that was used to create the DQM QAPP needing updates, this original EDD may include useful version details on the Format Information tab. Review the Format Information tab of the new DQM QAPP Updates EDD for comparison and to review details of the updates.

 

2.Open EQuIS Professional and connect to any facility in the target database, with the EQuIS (including DQM) Schema updated to the current/target version.

3.Open the RT_DQM_QAPP table and copy the name of the DQM_QAPP_CODE you desire to update.

4.Open the version of the “DQM QAPP Updates” file that you are preparing to upload in Excel.

5.Use the Excel Find and Replace function in the DQM QAPP Updates file (found in the Home tab of Excel or by selecting “Ctrl” and the “F” key simultaneously).

a.Enter: “Your_QAPP_Code” in the “Find what” text box.

b.Paste the DQM_QAPP_Code from RT_DQM_QAPP in the “Replace with” text box.

c.Select “Within: Workbook” for the Options tab.

d.Click Replace All.
 

Tip: As you update your existing QAPP, consider revising the QAPP_CODE_DESCRIPTION and/or QAPP_CODE_REMARK to reflect the update(s) for future reference.

 

6.Review and revise any of the default settings contained in the Excel file in the worksheets for:

a.RT_HOLDING_TIME, tab name = rt_holding_time_v2, see special instructions below;

b.RT_DQM_REASON, change the Reason Codes and Descriptions to your own values for the new rules;

c.RT_DQM_RULE, change the Qualifiers and Reason Codes to your own values for the new rules;

d.RT_DQM_CHECK_PARAM, the new check parameters have been set to values that turn the new functionalities OFF, so review them all carefully and change the values for the functionalities that you want to turn ON.
 

Note: Delete any of the rows in the various workbooks in the DQM QAPP Updates file that pertain to checks that you do not desire to include in your existing QAPP. For example, if one of the DQM QAPP Updates files contains new RT_DQM_RULEs and/or RT_DQM_CHECK_PARAMs for a check that was never included in your DQM QAPP, delete these rows to avoid getting errors when uploading the file to the database.

 

7.Save the Excel file or Save As (with a name that indicates which DQM QAPP you are updating) to an appropriate location.

8.Close Excel.

9.From EQuIS Professional, open EDP.

a.Select the DQM-refvals format from the EQuIS\Formats\DQM folder.

b.Locate and select the EDD saved in Step 6 above.

c.Check for and resolve any errors.

d.Proceed to Create and Commit the EDD with the appropriate Commit Type.

 

How to Update the New Columns in RT_HOLDING_TIME for an Existing QAPP

 

1.From EQuIS Professional version 7.20.4 or higher, open EDP.

2.Select the DQM-refvals format from the EQuIS\Formats\DQM folder.

3.Select the Home tab and ensure that the “errors only” box is not selected.

4.Select the Professional tab.

5.Click the EDD drop-down in the Export section and select RT_HOLDING_TIME_V2.

6.Select the QAPP to update and click the Green Arrow button.

7.Make the desired changes and Save the EDD, then Create and Commit the EDD using the appropriate Commit Type.

 

How to Update the New Columns in RT_CONTROL LIMITS for an Existing QAPP

 

1.From EQuIS Professional version 7.21.1 or higher, open EDP.

2.Select the DQM-refvals format from the EQuIS\Formats\DQM folder.

3.Select the Home tab and ensure that the “errors only” box is not selected.

4.Select the Professional tab.

5.Click the EDD drop-down in the Export section and select RT_CONTROL_LIMITS_V2.

6.Select the QAPP to update and click the Green Arrow button.

7.Make the desired changes and Save the EDD, then Create and Commit the EDD using the appropriate Commit Type.