View – WQX.ACTIVITYMETRIC

View Name: WQX.ACTIVITYMETRIC

View Type: WQX

Description: WQX.ACTIVITYMETRIC returns data detailing the metrics of a sampling activity.

Language: English

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

MONLOCID = DT_SAMPLE.SYS_LOC_CODE

ACTIVITYID = DT_SAMPLE_PARAMETER.SYS_SAMPLE_CODE

METRICTYPEID = DT_SAMPLE_PARAMETER.PARAM_CODE

METRICTYPEIDCONTEXT = RT_SAMPLE_PARAM_TYPE.CONTEXT

METRICTYPENAME = RT_SAMPLE_PARAM_TYPE.PARAM_DESC

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

METRICTYPESCALE = RT_SAMPLE_PARAM_TYPE.SCALE

METRICTYPEFORMULADESC = RT_SAMPLE_PARAM_TYPE.FORMULA

METRICVALUEMEASURE = DT_SAMPLE_PARAMETER.PARAM_VALUE

METRICVALUEMEASUREUNIT = DT_SAMPLE_PARAMETER.PARAM_UNIT

METRICSCORE = DT_SAMPLE_PARAMETER.SCORE

METRICCOMMENT = DT_SAMPLE_PARAMETER.REMARK

METRICINDEXID = DT_SAMPLE_PARAMETER.IDENTIFIER

Tables: DT_FACILITY, DT_FILE, DT_SAMPLE, DT_SAMPLE_PARAMETER, RT_SAMPLE_PARAM_TYPE

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: Data must be present in the DT_SAMPLE_PARAMETER table to be generated in WQX.ACTIVITYMETRIC.

Output Type: Grid