Group Types

The following group types appear in the left pane of the Groups Form window (click Groups in the Edit section of the Home tab on the EQuIS Professional ribbon to access).

Note: Group Members (RT_GROUP.MEMBER_CODE) and Group Names (RT_GROUP.GROUP_CODE) should be unique names, and group members should not have the same name as the group they belong to. Doing so may result in unexpected behavior. For instance, making a Facility a member of a Facility Group with the same name (RT_GROUP.MEMBER_CODE=RT_GROUP.GROUP_CODE) may cause users to be unable to log in to EQuIS Professional or adding a subfacility to a location group with the same name will cause that location group to be unusable in reports.

Group Type	Definition	Related Tables
*	The "*" group type can contain multiple types of members as well as files and is not displayed in the Groups Form in EQUIS Professional. Any combination of MEMBER_TYPES are acceptable members. Folders created in the Enterprise Explorer Widget will create an entry of this type, and vice versa, using the group_desc as the folder name. Files (RT_GROUP_MEMBER.MEMBER_TYPE = "file_id") loaded via the Enterprise Explorer Widget will automatically appear in a group of this type. Other group types, e.g. Facilities, that have other objects added (such as by moving a report or file to that facility in the Explorer Widget) will automatically be converted to this group type. This is by design, as the group is no longer object-specific.	RT_GROUP RT_GROUP_MEMBER
Analyte	Groups containing different analytes or chemicals, from RT_ANALYTE. Reports can be run by selecting an analyte group (also known as a Method Analyte Group [MAG]) rather than individual group members. Different names can be assigned to analytes, reporting units can be assigned, or entries can be separated by method, fraction, or matrix.	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. Location groups are NOT facility specific. Each group needs to have a unique name regardless of what facility it is in, and each group can contain members from different facilities. For example, a single location group "Monitoring Wells" could be created that contained all monitoring wells in every facility, but a "Monitoring Wells" group could not be created for each facility (unless given a unique name like "Facility A Monitoring Wells"). Changing the FACILITY_ID of a location group (RT_GROUP.FACILITY_ID) will NOT change the FACILIITY_ID for group members (RT_GROUP_MEMBER.FACILITY_ID).	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 or 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. The name of the facility group cannot be the same as one of its members.	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.

Groups of the type RT_GROUP.GROUP_TYPE = "*" can contain multiple types of members as well as files. Any combination of MEMBER_TYPES are acceptable members. Folders created in the Enterprise Explorer Widget will create an entry of this type, and vice versa, using the group_desc as the folder name. Files (RT_GROUP_MEMBER.MEMBER_TYPE = "file_id") loaded via the Enterprise Explorer Widget will automatically appear in a group of this type. Groups of this type will not be displayed in the Groups Form in EQuIS Professional.