View – WQX.RESULTDETECTQUANTLIMIT

View Name: WQX.RESULTDETECTQUANTLIMIT

View Type: WQX

Description: WQX.RESULTDETECTQUANTLIMIT returns data detailing the detection and/or quantitation limit of a sampling activity.

Language: English

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

PARENTID = DT_TEST.TEST_ID AND DT_RESULT.CAS_RN

ACTIVITYID = DT_SAMPLE.SYS_SAMPLE_CODE

CAS_RN = DT_RESULT.CAS_RN

CHARACTERISTICNAME = RT_ANALYTE.CHEMICAL_NAME

LABANALYSISSTARTDATE = DT_TEST.ANALYSIS_DATE

LABANALYSISSTARTTIME = DT_TEST.ANALYSIS_DATE

RESULTSAMPFRACTION = DT_TEST.FRACTION

ANALYTICALMETHODID = DT_TEST.ANALYTIC_METHOD

DETECTQUANTLIMITTYPE = DT_RESULT.REPORTING_DETECTION_LIMIT

DETECTQUANTLIMITMEASURE = DT_RESULT.METHOD_DETECTION_LIMIT

DETECTQUANTLIMITMEASUREUNIT = DT_RESULT.DETECTION_LIMIT_UNIT

Tables: DT_FACILITY, DT_RESULT, DT_SAMPLE , DT_TEST, RT_ANALYTE

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: ‘N’ must be the value for DT_RESULT.DETECT_FLAG.

Output Type: Grid