DQM Global Parameters

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Modules > DQM >

DQM Global Parameters

One of the checks on the DQM Settings Checks tab is Global Parameters. This is a special "Check" that holds the parameters used by all of the other checks within a given QAPP.

Every DQM QAPP Code must have a Global Parameters "Check".

The Global Parameters "Check" is not listed in the Check drop-down list on the DQM Create Event Form, because it does not run an actual check.

 

The Global Parameters check has one Rule = Manually Entered Apply Qualifier. This rule exists to assign the required DQM_RULE_ID when saving Apply Qualifiers that were manually added to results with no other (DQM-generated) Apply Qualifiers.

DQM.Global.Rule

 

The Global Parameters check holds the parameters used by all of the other checks within a given QAPP. This allows these parameters to be easily modified for all checks in the Parameters tab of the DQM Settings Form.

DQM.Global.Parameters

 

The parameters of the Global Parameter Check are described below. As noted, most of these parameters determine if/what updates are applied when DQM events are completed using the Complete Event Form.

 

DEFAULT_DQM_STATUS – This is the value used by the Complete Event function to fill in records when DT_SAMPLE.DQM_STATUS = NULL.

The default value is “default”.

This is a single string parameter.

 

DEFAULT_EVENT_NAME – This parameter determines if the Event Name suggested by the Save Event function is based on the DateTime the Event is Created or on the Selection used to Create the Event (e.g., Task Code=DQM Demo). Input the event name in RT_DQM_CHECK_PARAM to use after DQM is run. Suggestions for naming include the COC, SDG, or Test Batch ID that was selected for creating the DQM event.

This defaults to DateTime.

This is a single string parameter used for exact matches.

 

NONDETECT_DETECTION_LIMIT – This parameter identifies which detection limit column from DT_RESULT will be used to populate DT_RESULT.RESULT_VALUE when the Apply Qualifier contains the value from the NONDETECT_RESULT_QUALIFIERS parameter and the related option is selected on the Complete Event Form. Input the default for what detection limit column is used when setting non-detect results = detection limit in RT_DQM_CHECK_PARAM (e.g., MDL, RDL, quantitation limit).

Default value = "reporting_detection_limit".

Other valid values = "method_detection_limit" or "quantitation_limit".

This is a single string parameter used for exact matches.

 

NONDETECT_RESULT_QUALIFIERS – The qualifier(s) that determine whether DQM updates DT_RESULT.DETECT_FLAG = "N" and/or DT_RESULT.RESULT_VALUE = NONDETECT_DETECTION_LIMIT column when the related option(s) are selected on the Complete Event Form. Input the qualifier that DQM will utilize to update the DT_RESULT.DETECT_FLAG to “N” in RT_DQM_CHECK_PARAM.

Default value = "U".

This is a single string parameter used for exact matches.

 

REJECT_RESULT_QUALIFIERS – The qualifier(s) that determine whether DQM writes the REPORTABLE_RESULT_NO parameter value to DT_RESULT.REPORTABLE_RESULT when this option is selected on the Complete Event Form. Input the list of qualifiers for DQM to set REPORTABLE_RESULT = “N” in RT_DQM_CHECK_PARAM.

Default value = "R, X".

This is a list of strings parameter which can contain one or more strings separated by a comma or commas.

 

REPORTABLE_RESULT – The DQM Create Event query will include results with DT_RESULT.REPORTABLE_RESULT equal to a value in this list. Note that results with REPORTABLE_RESULT = NULL are also included in DQM Events. Set the default value to be input into DT_RESULT.REPORTABLE_RESULT in RT_DQM_CHECK_PARAM.  

Default value = "Yes, Y".

This is a list of strings parameter which can contain one or more strings separated by a comma or commas.

 

REPORTABLE_RESULT_YES – This is the value written to DT_RESULT.REPORTABLE_RESULT by the Complete Event function for all results WITHOUT an Apply Qualifier from the REJECT_RESULT_QUALIFIERS list when this option is selected on the Complete Event Form.

Default value = "Yes".

This is a single string parameter.

 

REPORTABLE_RESULT_NO – This is the value written to DT_RESULT.REPORTABLE_RESULT by the Complete Event function when the Apply Qualifier includes one of the qualifiers listed in the REJECT_RESULT_QUALIFIERS list when this option has been selected on the Complete Event Form.

Default value = "No".

This is a single string parameter.

 

RESULT_TYPE_CODE – The DQM Create Event query will include results with DT_RESULT.RESULT_TYPE_CODE equal to a value in this list. In RT_DQM_CHECK_PARAM, input the default value to be used during the DQM Create Event query.

Default value = "TRG".

This is a list of strings parameter which can contain one or more strings separated by a comma or commas.

 

TEST_BATCH_TYPE – The DQM Create Event query will include results with AT_TEST_BATCH_ASSIGN.TEST_BATCH_TYPE equal to this value or NULL. In RT_DQM_CHECK_PARAM, input the default value to be used during the DQM Create Event query for which results are to be included.

Default value = "ANALYSIS".

This is a single string parameter used for exact matches.

 

Notes:

The default value is used if there is no record in RT_DQM_CHECK_PARAM for an input parameter.

The default value is used if the PARAM_VALUE is NULL for this parameter in RT_DQM_CHECK_PARAM.

The columns for Analytic Method, Analyte and MAG are not considered when DQM retrieves the Global Parameters. If more than one of these parameters is entered, then the first one (when sorted alphabetically) will be used.