Open topic with navigation

Create a Valid Values List from a System Code Table

You can configure a field to contain a list of System Codes defined in a System Code Table. When you create a Valid Values list in this way, the drop-down list of valid values will display any System Codes that are defined in the specified System Code table. The list will be updated automatically to reflect changes made to the System Code table. The Valid Values list created by the using the Behaviors section is restricted (i.e., the users will only be allowed to select from the values that are displayed in the list). They will not be able to enter their own values in the list.

Note: Only active System Codes that are constructed via System Codes and Tables feature will appear in valid values lists.

Steps

1. Access the Fields section.

2. In the Fields section, select .

   The workspace for the selected field appears, displaying the Information section.

3. As needed, enter values in the available fields.

4. Select the Behavior tab, and then in the Valid Value box, select System code and Table.

   The Select Valid Values System Code Table box appears.

5. In the Select Valid Values System Code Table box, select the System Code Table from which you want to build the list of valid values.

   The list of the filter types appear.

6. If you want the list of valid values to include all of the System Codes in the selected System Code table, select the No Filter check box.

   Note: If the System Code table that you selected in the previous step does not contain any references, only the No Filter option is available.

   -or-

   If you want the list of valid values to contain only the System Codes that are referenced from a System Code in another System Code table, then select the Static Filter check box.

   The Choose System Code Table and Choose System Code boxes appears.

   1. In the Choose System Code Table box, select the System Code table that will be used as the filter.

      The list of System Codes appears in the Choose System Code table.

   2. In the Choose System Code box, select the required System Code.

      Note: The list will contain only the System Codes from the source System Code table that are referenced by the System Code that you select here.

7. Select .

   A list of valid values is created.

Example: Filtering System Code List to Display Referenced System Codes

By using the Static Filter option, you can create a valid value list to display System Codes that are referenced from another System Code. Suppose that two System Code Tables: Manufacturer (MFGR) and Equipment Type (EQPT).

• The Equipment Type table contains the following values:

  • Compressor
  • Heat Exchanger
  • Motor
  • Pump Tank

• The Manufacturer table contains the following values:

  • ACME
  • BURNS
  • SMITH

If the manufacturers ACME and BURNS both produce motors, then, in the Equipment Type System Code Table, you can add references to the ACME and BURNS System Codes in the Motor System Code. The references would indicate that the two manufacturers are associated with that equipment type.

Now, assume that you have a family called Motor that will be used to store information about the motors in your company. Also, assume that the Motor family contains the Manufacturer (ASSET_MANUF_CHR) field, which is intended to identify the name of the company that manufactures a given motor. In this case, you could use a Valid Values rule to create a list for this field that contains all values from the Manufacturer (MFGR) System Code Table. But, since only some manufacturers produce motors, it would be better to filter the list to contain only the valid manufacturers: ACME and BURNS.

Assuming that the System Code references described above are already in place, you can use the field behavior to implement this functionality by generating a Valid Values behavior for the Manufacturer (ASSET_MANUF_CHR) field that is built from the Manufacturer System Code Table and contains a Static Filter to include only the values that are referenced by the Motor System Code in the Equipment Type (EQPT) System Code Table.

Copyright © 2018 General Electric Company. All rights reserved.