System Codes are the codes defined in a System Code Table. Each table can have an unlimited number of codes. For example: System Code Table named Activity may contain all the System Codes related to activities such as High, Low, Medium, and None.
A System Code reference is a way of associating a System Code in one System Code Table with a System Code in another System Code table.
Consider an example where you have two System Code Tables: Equipment Type (EQPT) and Manufacturer (MFGR). The Equipment Type table contains the following values:
The Manufacturer table contains the following values:
If the manufacturer ACME produces only motors and pumps, within the Manufacturer System Code Table, you can add a reference to the ACME System Code that references the Pump and Motor System Codes in the Equipment Type System Code table. This indicates that only the equipment types Pump and Motor are associated with the manufacturer ACME.
System Code references can be useful for developing Valid Values rules, where the values available in a given field are filtered based upon references to other System Codes. Keep in mind that the direction of the references will have an impact on how they can be used in rules. Before you begin creating references, you will want to think about how you plan to use them for developing rules so that you set them up properly.
Copyright © 2018 General Electric Company. All rights reserved.