Create Combined Analyte Groups

<< Click to Display Table of Contents >>

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

Create Combined Analyte Groups

Combined Analyte Groups are a combination of existing analyte groups. These can be used to create groupings within an analyte group.

 

Warning: Combined Analyte Groups are available in custom reports only.

 

For example, to group analytes as displayed in the table below with headers and {General Parameters, Inorganic Analytes, Metals, etc.) each section under the header containing a specific list of analytes with a specific report order (as shown below), complete the steps that follow the table.

 

General Parameters

pH

Electrical Conductivity

Total Suspended Solids

Temperature

Redox Potential

Turbidity

BOD - (5 Day)

Dissolved Oxygen (Field)

Total Organic Carbon

Inorganic Analytes

Total Alkalinity as CaCO3

Chloride

Fluoride

Sulfate

Ammonia as N

Nitrate — N

Dissolved Phosphorous

Metals

Sodium

Potassium

Calcium

Magnesium

Iron

Aluminum

Cadmium

Lead

Zinc

 

1.Create the individual analyte groups with REPORT_ORDER populated as you would expect to see analytes in the report. This is accomplished by clicking Groups (button in Edit group on Home tab).

2.After the analyte groups have been created, create combined analyte groups using the steps below. The combined analyte groups are created in the General Group tables (not in the method analyte tables).

 

Create Combined Analyte Group

 

The analyte group type will be recognized when selecting a report.

 

1.Click Tables in the Open group of the EQuIS Ribbon's Home tab.

2.Click System Tables in Open window; select ST_GROUP_TYPE.

3.Click Add ST_GROUP_TYPE at bottom of window.

4.Click in new field in GROUP_TYPE = column; type combined analyte.

5.In GROUP_TYPE_DESC, type combined analyte groups.

6.Click Save to commit data to database.

7.Repeat Step 1 and click Reference Tables in the Open window.

8.Open RT_GROUP and RT_GROUP_MEMBER.

9.Click RT_GROUP in Workspace pane, then click Add RT_GROUP.

10.Fill in the following:

a.GROUP_CODE column - enter the name for your combined group. This should not be the same name as your individual analyte groups (e.g. use a name like 'Landfill Qrt Analysis grouped' if there is an individual analyte group called 'Landfill Qrt Analysis').Open a Data Table

b.GROUP_TYPE column - select Combined Analyte from the drop-down menu.

c.STATUS_FLAG column - should be A.

d.Other fields can be populated, if desired.

11.Click Save to commit data to database.

12.Click RT_GROUP_MEMBER in the Workspace pane, then click Add RT_GROUP_MEMBER.

13.Fill in the following for each group member (i.e. individual analyte group) you wish to add:

a.GROUP_CODE column - select the name for your combined group (e.g. 'Landfill Qrt Analysis grouped') from the drop-down menu. This should not be the same name as your individual analyte groups (e.g. use a name like 'Landfill Qrt Analysis grouped' if there is an individual analyte group called 'Landfill Qrt Analysis').

b.MEMBER_CODE column - name of individual analyte group. For example, if using the Springfield facility, it is possible to combine Nasty VOCs, PAHs, and PCBs.

c.MEMBER_TYPE column - Combined Analyte.

d.FACILITY_ID column - enter same facility for each member (e.g. 1 for Springfield).

e.REPORT_ORDER column - number to represent the order you want that individual analyte group to appear in the report. For example, Nasty VOCs = 1, PAHs = 2, and PCBs = 3.

f.MEMBER_CODE column - add name of individual analyte group.

g.STATUS_FLAG column - should be A.

h.Other fields can be populated, if desired.

14.Click Save to commit data to database.

 

The data is now ready for use in reports that support Combined Analyte Groups.