<< Click to Display Table of Contents >> Navigation: DQM > DQM Data Sources |
Data sources used by each DQM Check are provided in this Excel table. (The DQM Settings tables are outlined in Getting Started with DQM).
The file is organized by DQM check to demonstrate relationships between the DQM checks, tables, parameters, and associations.
During the Start Event process, the SQL query that creates the dataset that is run through every check includes the Global Parameters listed in the attached table. Some checks (e.g. Spike Recovery and Surrogate Recovery) add additional RESULT_TYPE_CODEs. Some checks have an individual check parameter to filter to a specific RESULT_TYPE_CODE.
Table(s) |
Column(s) |
Global Parameter(s) |
DT_RESULT |
REPORTABLE_RESULT |
reportable_result |
RESULT_TYPE_CODE |
result_type_code |
|
DT_TEST_BATCH |
TEST_BATCH_TYPE |
test_batch_type |
Additionally, during the Start Event process, the SQL query that creates the dataset that is run through every DQM check includes looking at DETECT_FLAG in DT_RESULT to determine which qualifier to be applied to results for any Rule exceptions or Associated Results of QC Samples with Rule exceptions. For DQM Checks that the DQM code looks at DETECT_FLAG in DT_RESULT for additional reasons, the DT_RESULT Table and DETECT_FLAG columns are included in the listing for each DQM check in the tables that follow.
The following Reference Tables must be populated with appropriate values in the "Related Columns" in order for DQM to use the "Column(s)" of the same name referenced in a check.
Database Relationship Parent Tables |
Related Columns |
RT_ANALYTIC_METHOD |
ANALYTIC_METHOD |
RT_FRACTION |
FRACTION |
RT_PREP_METHOD |
PREP_METHOD |
RT_PRESERVATIVE |
PRESERVATIVE |
RT_RESULT_TYPE |
RESULT_TYPE_CODE |
RT_SAMPLE_TYPE |
SAMPLE_TYPE_CODE |
RT_TEST_BATCH_TYPE |
TEST_BATCH_TYPE |
Copyright © 2025 EarthSoft, Inc. • Modified: 03 Oct 2025