<< Click to Display Table of Contents >> Navigation:  Professional > Groups > 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.

 

 

 

Example Combined Analyte Group

 

To group analytes as displayed in the table below with headers (General Parameters, Inorganic Analytes, Metals, etc.) and 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.

 

 

1.Create the individual analyte groups with REPORT_ORDER populated to be the order of analytes expected 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 section of the Professional Home ribbon.

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

3.Click Add ST_GROUP_TYPE at bottom of window.

4.Click in new field in GROUP_TYPE = column and 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 the RT_GROUP and RT_GROUP_MEMBER tables.

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 the combined group. This should not be the same name as the 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.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 (e.g., individual analyte group) to be added:

a.GROUP_CODE column – Select the name for the combined group (e.g., 'Landfill Qrt Analysis grouped') from the drop-down menu. This should not be the same name as the 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 that individual analyte groups should 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 are now ready for use in reports that support Combined Analyte Groups.