<< Click to Display Table of Contents >> Navigation:  EQuIS Library > Views > View – WQX.ACTIVITYGROUP

View Name: WQX.ACTIVITYGROUP

 

View Type: WQX

 

Description: WQX.ACTIVITYGROUP returns data detailing the sampling activity group.

 

Language: English

 

Output Columns:

ACTIVITYGROUPID = RT_GROUP.GROUP_CODE

ACTIVITYGROUPNAME = RT_GROUP.GROUP_DESC

ACTIVITYGROUPTYPECODE = RT_GROUP.GROUP_TYPE

ACTIVITYID = RT_GROUP_MEMBER.MEMBER_CODE

ORGID = DT_FACILITY.FACILITY_CODE

 

Tables: DT_FACILITY, RT_GROUP, RT_GROUP_MEMBER  

 

Database Type: SQL

 

Database Schema: WQX Schema

 

Database Version: EQuIS 7.0+

 

Data Requirements: Data must be present in the RT_GROUP and RT_GROUP_MEMBER tables. Both tables should share the same GROUP_CODE value.

 

Output Type: Grid