View – WQX.ACTIVITY

View Name: WQX.ACTIVITY

View Type: WQX

Description: WQX.ACTIVITY returns data that details a sampling activity or observation.

Language: English

Output Columns:

ORGID = DT_FACILITY.FACILITY_CODE

ACTIVITYID = DT_SAMPLE.SYS_SAMPLE_CODE

ACTIVITYTYPECODE = DT_SAMPLE.SAMPLE_TYPE_CODE

ACTIVITYMEDIA = DT_SAMPLE.MEDIUM_CODE

ACTIVITYMEDIASUBDIVISION = DT_SAMPLE.MATRIX_CODE

ACTIVITYSTARTDATE = DT_SAMPLE.SAMPLE_DATE

ACTIVITYSTARTTIME = DT_SAMPLE.SAMPLE_DATE

ACTIVITYSTARTTIMEZONE = DT_SAMPLE.SAMPLE_DATE_TIMEZONE

ACTIVITYENDDATE = DT_SAMPLE.SAMPLE_END_DATE

ACTIVITYENDTIME = DT_SAMPLE.SAMPLE_END_DATE

ACTIVITYENDTIMEZONE = DT_SAMPLE.SAMPLE_DATE_TIMEZONE

RELATIVEDEPTH = DT_SAMPLE.RELATIVE_DEPTH

DEPTHHEIGHTMEASURE = DT_SAMPLE.START_DEPTH

DEPTHHEIGHTMEASUREUNIT = DT_SAMPLE.DEPTH_UNIT

TOPDEPTHHEIGHTMEASURE = DT_SAMPLE.START_DEPTH

TOPDEPTHHEIGHTMEASUREUNIT = DT_SAMPLE.DEPTH_UNIT

BOTTOMDEPTHHEIGHTMEASURE = DT_SAMPLE.END_DEPTH

BOTTOMDEPTHHEIGHTMEASUREUNIT = DT_SAMPLE.DEPTH_UNIT

DEPTHALTITUDEREFPOINT = DT_SAMPLE.DEPTH_REFERENCE

PROJID = DT_SAMPLE.TASK_CODE

CONDUCTINGORGANIZATION = DT_SAMPLE.DATA_PROVIDER

MONLOCID = DT_SAMPLE.SYS_LOC_CODE

ACTIVITYCOMMENT = DT_SAMPLE.REMARK

LATITUDEMEASURE = DT_COORDINATE.Y_COORD

LONGITUDEMEASURE = DT_COORDINATE.X_COORD

SOURCEMAPSCALE = DT_COORDINATE.SOURCE_SCALE

HORIZACCURACYMEASURE = DT_COORDINATE.HORZ_ACCURACY_VALUE

HORIZACCURACYMEASUREUNIT = DT_COORDINATE.HORZ_ACCURACY_UNIT

HORIZCOLLMETHOD = DT_COORDINATE.HORZ_COLLECT_METHOD_CODE

HORIZCOORDREFSYSDATUM = DT_COORDINATE.HORZ_DATUM_CODE

BIOACTIVITYASSEMBLAGESAMPD = DT_BIOLOGICAL_SAMPLE.ASSEMBLAGE

BIOHABCOLLDURATIONMEASURE = DT_SAMPLE.DURATION

BIOHABCOLLDURATIONMEASUREUNIT = DT_SAMPLE.DURATION_UNIT

BIOHABSAMPCOMP = DT_BIOLOGICAL_SAMPLE.COMPONENT_NAME

BIOHABSAMPCOMPPLACEINSERIES = DT_BIOLOGICAL_SAMPLE.COMPONENT_SEQUENCE

BIOHABREACHLENGTHMEASURE = DT_BIOLOGICAL_SAMPLE.REACH_LENGTH

BIOHABREACHLENGTHMEASUREUNIT = DT_BIOLOGICAL_SAMPLE.REACH_LENGTH_UNIT

BIOHABREACHWIDTHMEASURE = DT_BIOLOGICAL_SAMPLE.REACH_WIDTH

BIOHABREACHWIDTHMEASUREUNIT = DT_BIOLOGICAL_SAMPLE.REACH_WIDTH_UNIT

BIOHABPASSCOUNT = DT_BIOLOGICAL_SAMPLE.PASS_COUNT

BIOHABNETTYPE = DT_BIOLOGICAL_SAMPLE.NET_TYPE

BIOHABNETSURFACEAREAMEASURE = DT_BIOLOGICAL_SAMPLE.NET_SURFACE_AREA

BIOHABNETSURFACEMEASUREUNIT = DT_BIOLOGICAL_SAMPLE.NET_SURFACE_AREA_UNIT

BIOHABNETMESHSIZEMEASURE = DT_BIOLOGICAL_SAMPLE.NET_MESH_SIZE

BIOHABNETMESHMEASUREUNIT = DT_BIOLOGICAL_SAMPLE.NET_MESH_SIZE_UNIT

BIOHABNETBOATSPEEDMEASURE = DT_BIOLOGICAL_SAMPLE.BOAT_SPEED

BIOHABNETBOATSPEEDMEASUREUNIT = DT_BIOLOGICAL_SAMPLE.BOAT_SPEED_UNIT

BIOHABNETCURRSPEEDMEASURE = DT_BIOLOGICAL_SAMPLE.CURRENT_SPEED

BIOHABNETCURRSPEEDMEASUREUNIT = DT_BIOLOGICAL_SAMPLE.CURRENT_SPEED_UNIT

BIOACTIVITYTOXICITYTESTTYPE = DT_BIOLOGICAL_SAMPLE.TOXICITY_TYPE

SAMPCOLLMETHODID = DT_SAMPLE.SAMPLE_METHOD

SAMPCOLLMETHODIDCONTEXT = RT_SAMPLE_METHOD.CONTEXT

SAMPCOLLMETHOD = RT_SAMPLE_METHOD.METHOD_DESC

SAMPCOLLMETHODIDQUALIFIER = NULL

SAMPCOLLMETHODDESC = NULL

SAMPCOLLEQUIPMENT = DT_SAMPLE.EQUIPMENT_TYPE

SAMPCOLLEQUIPMENTCOMMENT = DT_SAMPLE.EQUIPMENT_DESC

SAMPPREPID = DT_FIELD_SAMPLE.PREP_METHOD

SAMPPREPIDCONTEXT = RT_PREP_METHOD.CONTEXT

SAMPPREP = RT_PREP_METHOD.PREFERRED_NAME

SAMPPREPQUALIFIERTYPE = NULL

SAMPPREPDESC = RT_PREP_METHOD.REMARK

SAMPPREPCONTTYPE = DT_TEST.CONTAINER_TYPE

SAMPPREPCONTCOLOR = DT_TEST.CONTAINER_COLOR

SAMPPREPCONTCHEMPRESERVUSED = DT_TEST.PRESERVATIVE

SAMPPREPCONTTHERMALPRESERVUSED = DT_TEST.TEMP_PRESERVE_TYPE

SAMPPREPCONTSAMPTRANSSTORDESC = DT_TEST.CUSTOM_FIELD_1

RESULTCOUNT = NULL

Tables: DT_BIOLOGICAL_SAMPLE, DT_COORDINATE, DT_FACILITY, DT_FIELD_SAMPLE, DT_SAMPLE, DT_TEST, RT_PREP_METHOD, RT_SAMPLE_METHOD

Database Type: SQL

Database Schema: WQX Schema

Database Version: EQuIS 7.0+

Data Requirements: Data must be present in the DT_SAMPLE table to be generated in WQX.ACTIVITY.

Output Type: Grid