Group Types

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Groups and Action Levels > Group Maintenance >

Group Types

Group types appear in the left pane of the Group Maintenance window.

 

Group Type

Definition

Related Tables

Analyte

Groups containing different analytes or chemicals, from RT_ANALYTE. An

example of an analyte group in the Springfield Database is the _PERC

Daughters group. This group combines Tetrachloride, cis-1-2-DCE and Vinyl chloride into a group of Perchlorate, and three of Perchlorate's daughter compounds. By creating the PERC Daughter analyte group, reports can be run by selecting this group, rather than all five group members.

RT_MTH_ANL_GROUP

RT_MTH_ANL_GROUP_MEMBER

Location

Groups of locations from DT_LOCATION. An example of a location group in the Springfield Database is the MonitWells group. This group allows you to query all the monitoring wells in a facility included in this group. Other examples of Location Groups are shallow aquifer and deep aquifer.

RT_GROUP

RT_GROUP_MEMBER

Material

Groups of materials from RT_MATERIAL. Within the Material Groups, Group Maintenance allows you to modify the color and pattern of materials. These groups can be used in Lithology Lithology-Mountain-03-WF or ArcGIS 15155-ArcGIS.

RT_GROUP

RT_GROUP_MEMBER

Facility

Groups of facilities from DT_FACILITY. Note that when connecting to EQuIS Professional via Application Level Security, users must be subscribed to all facilities in a particular group in order to edit the Facility Group. Facility Groups are assigned a negative FACILITY_ID in RT_GROUP.

RT_GROUP

RT_GROUP_MEMBER

Subfacility

Groups of subfacilities from DT_SUBFACILITY.

RT_GROUP

RT_GROUP_MEMBER

 

Create Additional Group Types and Groups

 

Users can create location parameter and sample parameter groups that are used in the standard Location Parameter and Sample Parameter reports. Other custom groups may be created that can be used in custom reporting (EDGE, SPM, EQuIS Alive, etc.).

 

Create Sample Parameter Group

 

If a GROUP_TYPE = param_code has previously been created in ST_GROUP_TYPE, skip to number five below.

 

1.Open ST_GROUP_TYPE and follow the steps below.

a.Click on Data Tables.

b.In the upper-left corner, click System Tables.

c.Select ST_GROUP_TYPE.

2.Click Add... ST_GROUP_TYPE.

3.Enter param_code in the GROUP_TYPE and GROUP_TYPE_DESC fields.

4.Save.

5.Open RT_GROUP.

6.Enter your values for the new group name in GROUP_CODE with a GROUP_TYPE of param_code.

7.Save.

8.Open RT_SAMPLE_PARAM_TYPE and RT_GROUP_MEMBER.

9.In RT_GROUP_MEMBER, enter the values as indicated below.

a.GROUP_CODE: the group name created in number six above.

b.MEMBER_CODE: select the group member from RT_SAMPLE_PARAM_TYPE.PARAM_CODE.

c.MEMBER_TYPE: PARAM_CODE

 

For group members, the RT_GROUP_MEMBER.MEMBER_TYPE should typically be the same value as the parent group's RT_GROUP.GROUP_TYPE.

 

10.Save.

 

Create Location Parameter Group

 

If a GROUP_TYPE = param_code has previously been created in ST_GROUP_TYPE, skip to number five below.

 

1.Open ST_GROUP_TYPE and follow the steps below.

a.Click Data Tables.

b.In the upper-left corner, click System Tables.

c.Select ST_GROUP_TYPE.

2.Click Add... ST_GROUP_TYPE.

3.Enter param_code in the GROUP_TYPE and GROUP_TYPE_DESC fields.

4.Save.

5.Open RT_GROUP.

6.Enter values for the new group name in GROUP_CODE with a GROUP_TYPE of param_code.

7.Save.

8.Open RT_LOCATION_PARAM_TYPE and RT_GROUP_MEMBER.

9.In RT_GROUP_MEMBER, enter the values as indicated below.

a.GROUP_CODE: the group name created in number six above.

b.MEMBER_CODE: select the group member from RT_LOCATION_PARAM_TYPE.PARAM_CODE.

c.MEMBER_TYPE: PARAM_CODE

10.Save.

 

General Process for Other Custom Groups

 

1.Add the common type/parameter/code in ST_GROUP_TYPE.GROUP_TYPE.

2.Name the new group in RT_GROUP.GROUP_CODE with the GROUP_TYPE previously defined.

3.Create group members in RT_GROUP_MEMBER with the above GROUP_CODE and MEMBER_CODE defined in the appropriate table.

4.The MEMBER_CODE: definition is unlimited.

5.The MEMBER_TYPE: should typically be the same value as the GROUP_TYPE.