View – WQX.RESULT

View Name: WQX.RESULT

View Type: WQX

Description: WQX.RESULT returns data detailing the results of a sampling activity or observation.

Language: English

Output Columns:

RECORDID = DT_TEST.TEST_ID, DT_RESULT.CAS_RN

ORGID = DT_FACILITY.FACILITY_CODE

MONLOCID = DT_SAMPLE.SYS_LOC_CODE

ACTIVITYID = DT_SAMPLE.SYS_SAMPLE_CODE

DATALOGGERLINENAME = DT_RESULT_PARAMETER.PARAM_VALUE

RESULTDETECTIONCONDITION = DT_RESULT.CUSTOM_FIELD_2

CAS_RN = DT_RESULT.CAS_RN

CHARACTERISTICNAME = RT_ANALYTE.CHEMICAL_NAME

METHODSPECIATIONNAME = DT_RESULT.METHOD_SPECIATION

RESULTSAMPFRACTION = DT_TEST.FRACTION

RESULTMEASURE = DT_RESULT.RESULT_NUMERIC

RESULTMEASUREUNIT = DT_RESULT.RESULT_UNIT

RESULTMEASUREQUALIFIERCODE = DT_RESULT.INTERPRETED_QUALIFIERS

STATUSID = DT_RESULT.APPROVAL_CODE

STATISTICALBASECODE = DT_RESULT.STAT_TYPE

VALUETYPE = DT_RESULT.VALUE_TYPE

WEIGHTBASIS = dt_test.basis

TIMEBASIS = DT_TEST.DURATION_BASIS

TEMPERATUREBASIS = DT_TEST.TEMP_BASIS

PARTICLESIZEBASIS = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'ResultParticleSize'

PRECISIONVALUE = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'Precision'

BIASVALUE = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'Bias'

CONFIDENCEINTERVALVALUE = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'ConfidenceInterval'

UPPERCONFIDENCELIMITVALUE = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'UpperConfidenceLimit'

LOWERCONFIDENCELIMITVALUE = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'LowerConfidenceLimit'

RESULTCOMMENT = DT_RESULT.REMARK

RESULTSAMPLINGPOINTNAME = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'ResultSamplingPoint'

DEPTHHEIGHTMEASURE = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'ResultDepth'

DEPTHHEIGHTMEASUREUNIT = DT_RESULT_PARAMETER.PARAM_UNIT where PARAM_CODE = 'ResultDepth'

DEPTHALTITUDEREFPOINT = DT_RESULT_PARAMETER.REMARK where PARAM_CODE = 'ResultDepth'

BIOLRESULTINTENT = DT_BIOLOGICAL_RESULT.BIOLOGICAL_INTENT

BIORESULTINDIVIDUALID = DT_BIOLOGICAL_RESULT.INDIVIDUAL_ID

BIORESULTSUBJECTTAXONOMIC = DT_BIOLOGICAL_RESULT.TAXON

BIORESULTUNIDENTIFIEDSPECIESID = DT_BIOLOGICAL_RESULT.UNKNOWN_SPECIES_IDENTIFIER

BIORESULTSAMPTISSUEANATOMY = DT_BIOLOGICAL_RESULT.TISSUE_ANATOMY

GRPSUMMCOUNTWEIGHTMEASURE = DT_BIOLOGICAL_RESULT.GROUP_SUMMARY_VALUE

GRPSUMMCOUNTWEIGHTMEASUREUNIT = DT_BIOLOGICAL_RESULT.GROUP_SUMMARY_UNIT

TAXDETAILSCELLFORM = DT_BIOLOGICAL_RESULT.CELL_FORM

TAXDETAILSCELLSHAPE = DT_BIOLOGICAL_RESULT.CELL_SHAPE

TAXDETAILSHABITNAME_1 = DT_BIOLOGICAL_RESULT.HABIT_1

TAXDETAILSHABITNAME_2 = DT_BIOLOGICAL_RESULT.HABIT_2

TAXDETAILSHABITNAME_3 = DT_BIOLOGICAL_RESULT.HABIT_3

TAXDETAILSVOLTINISM = DT_BIOLOGICAL_RESULT.VOLTINISM

TAXDETAILSPOLLTOLERANCE = DT_BIOLOGICAL_RESULT.POLLUTION_TOLERANCE

TAXDETAILSPOLLTOLERANCESCALE = DT_BIOLOGICAL_RESULT.POLLUTION_TOLERANCE_SCALE

TAXDETAILSTROPHICLEVEL = DT_BIOLOGICAL_RESULT.TROPHIC_LEVEL

TAXDETAILSFUNCFEEDINGGRPNAME_1 = DT_BIOLOGICAL_RESULT.FEEDING_GROUP_1

TAXDETAILSFUNCFEEDINGGRPNAME_2 = DT_BIOLOGICAL_RESULT.FEEDING_GROUP_2

TAXDETAILSFUNCFEEDINGGRPNAME_3 = DT_BIOLOGICAL_RESULT.FEEDING_GROUP_3

RESOURCETITLE = DT_FILE.TITLE

RESOURCECREATOR = DT_FILE.AUTHOR

RESOURCESUBJECT = DT_FILE.REMARK

RESOURCEPUBLISHER = DT_FILE.PUBLISHER

RESOURCEDATE = DT_FILE.FILE_DATE

RESOURCEID = DT_FILE.FILE_NAME

FREQCLASSDESCCODE_1 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_1

FREQCLASSDESCUNIT_1 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_1_UNIT

FREQCLASSLOWERBOUNDVALUE_1 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_1_LBND

FREQCLASSUPPERBOUNDVALUE_1 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_1_UBND

FREQCLASSDESCCODE_2 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_2

FREQCLASSDESCUNIT_2 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_2_UNIT

FREQCLASSLOWERBOUNDVALUE_2 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_2_LBND

FREQCLASSUPPERBOUNDVALUE_2 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_2_UBND

FREQCLASSDESCCODE_3 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_3

FREQCLASSDESCUNIT_3 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_3_UNIT

FREQCLASSLOWERBOUNDVALUE_3 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_3_LBND

FREQCLASSUPPERBOUNDVALUE_3 = DT_BIOLOGICAL_RESULT.FREQUENCY_CLASS_3_UBND

ANALYTICALMETHODID = DT_TEST.ANALYTIC_METHOD

ANALYTICALMETHODIDCONTEXT = RT_ANALYTIC_METHOD.CONTEXT

ANALYTICALMETHODNAME = RT_ANALYTIC_METHOD.PREFERRED_NAME

ANALYTICALMETHODQUALIFIERTYPE = NULL

ANALYTICALMETHODDESC = RT_ANALYTIC_METHOD.REMARK

LABNAME = DT_TEST.LAB_NAME_CODE

LABANALYSISSTARTDATE = DT_TEST.ANALYSIS_DATE

LABANALYSISSTARTTIME = DT_TEST.ANALYSIS_DATE

LABANALYSISSTARTTIMEZONECODE = DT_TEST.ANALYSIS_DATE_TIMEZONE

LABANALYSISENDDATE = DT_TEST.ANALYSIS_END_DATE

LABANALYSISENDTIME = DT_TEST.ANALYSIS_END_DATE

LABANALYSISENDTIMEZONECODE = DT_TEST.ANALYSIS_DATE_TIMEZONE

RESULTLABCOMMENTCODE = DT_TEST.REMARK

LABACCIND = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'LabAccredited'

LABACCAUTHORITYNAME = DT_RESULT_PARAMETER.REMARK where PARAM_CODE = 'LabAccredited'

LABTAXACCIND = DT_RESULT_PARAMETER.PARAM_VALUE where PARAM_CODE = 'TaxonomistAccredited'

LABTAXACCAUTHORITYNAME = DT_RESULT_PARAMETER.REMARK where PARAM_CODE = 'TaxonomistAccredited'

LABPREPMETHODID = DT_TEST.PREP_METHOD

LABPREPMETHODIDCONTEXT = rt_prep_method.context

LABPREPMETHODNAME = rt_prep_method.preferred_name

LABPREPMETHODQUALIFIERTYPE = rt_prep_method.qualifier_type

LABPREPMETHODDESC = RT_PREP_METHOD.REMARK

LABPREPSTARTDATE = DT_TEST.PREP_DATE

LABPREPSTARTTIME = DT_TEST.PREP_DATE

LABPREPSTARTTIMEZONECODE = DT_TEST.PREP_DATE_TIMEZONE

LABPREPENDDATE = DT_TEST.PREP_END_DATE

LABPREPENDTIME = DT_TEST.PREP_END_DATE

LABPREPENDTIMEZONECODE = DT_TEST.PREP_DATE_TIMEZONE

SUBSTANCEDILUTIONFACTOR = DT_TEST.DILUTION_FACTOR

Tables: DT_BIOLOGICAL_RESULT, DT_FACILITY, DT_FILE, DT_RESULT, DT_RESULT_PARAMETER, DT_SAMPLE, DT_TEST, RT_ANALYTIC_METHOD, RT_ANALYTE, RT_PREP_METHOD

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: Data must be present in the DT_RESULT and DT_RESULT_PARAMETER tables to be generated in WQX.RESULT.

Output Type: Grid