DQM Data Sources

<< 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