Click Groups in the Edit section of the toolbar in EQuIS Professional to open the Groups Form.
Create New Groups in Groups Form
1.Select the group type in the left pane of the Group Maintenance window (e.g., Analyte) by clicking on the type next to the node.
2.Click New > New Group to create a new group with a blank Code field.
3.Enter a new Group Code and click Save.
Group Order
Users can use the Column Chooser to display columns DISPLAY_ORDER and REPORT_ORDER in the Group Members tab, if those fields are hidden. Either or both may be hidden by default for some groups.
Reorder the REPORT_ORDER by clicking on a group member in the Group Members tab and using arrow keys to move entries up and down. Save to preserve the change in the database.
While similar, DISPLAY_ORDER and REPORT_ORDER have different purposes.
DISPLAY_ORDER – Determines the order of group members as they appear on screen. For Analyte Groups, the DISPLAY_ORDER field allows multiple entries with the same CAS_RN for records that have different methods, fractions, etc., which it does by being part of the primary key for the RT_MTH_ANL_GROUP_MEMBER table.
REPORT_ORDER – Determines the order of group members as they appear in reports.
A group created or modified with the Groups interface will save both DISPLAY_ORDER and REPORT_ORDER with identical values. Populating a group through another means (such as an EDD or manually in RT_GROUP_MEMBER) requires unique REPORT_ORDER values to be used for that group. Otherwise, reordering the REPORT_ORDER of group members will not function as expected.
Copy Groups
1.Change the Code (GROUP_CODE) on the Group Details tab.
2.Click Save As on the toolbar.
Create Subgroups and Groups of Groups
1.Create a new group either in the RT_GROUP table or in the Professional Groups User Interface.
2.To create a parent-child relationship, add a new row in the RT_GROUP_MEMBER table with the following:
•GROUP_CODE = [Parent Group Code]
•MEMBER_CODE = [Child Group Code]
•FACILITY_ID = leave blank
•MEMBER_TYPE = GROUP_CODE
•STATUS_FLAG = A
Create Sample Parameter Group
If a GROUP_TYPE = param_code has previously been created in the ST_GROUP_TYPE table, skip to Number 5 below.
1.Open the ST_GROUP_TYPE table 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 the RT_GROUP table.
6.Enter the 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 tables.
9.In the RT_GROUP_MEMBER table, 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 the ST_GROUP_TYPE table, skip to Number 5 below.
1.Open the ST_GROUP_TYPE table 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.
Delete Group
1.Select the group from the left side under the Group type.
2.Once the Group is highlighted, click the toolbar delete icon or right-click and select Delete from the menu.