Appendix: Select Lists (Codelists) - Intergraph Smart 3D - Help

Intergraph Smart 3D Catalog

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Help
Version_S3D
12.1(2019)

This appendix contains information about the select lists that you see under the main Select Lists node in the tree view. The select lists in this appendix are listed in alphabetical order.

  • Select lists are called codelists in the delivered bulkload workbooks. A select list number is the same thing as a codelist number.

  • The Select lists (Codelists) delivered with the software (AllCodeLists.xls) might be different than the codelists provided on the customer support web site. The most recent codelists available on the customer support web site should be used for the most current functionality.

A select list (codelist) is a set of predefined acceptable values for a particular attribute. For example, the Fluid Code list defines all the acceptable fluid names that you can use. You can only select fluids that are defined in the Fluid Code list. Generally, each entry in a list has a unique number to identify that value, a short description, and a long description. Depending on where the software is using the list, you can select the short description to select the list item. However, when defining parts and piping specification rules, you may be required to identify the list item that you want by using the list number.

The delivered select lists can be categorized into these types: simple, hierarchical, and system.

  • Simple - Map numbers with descriptions.

  • Hierarchical - Group the mappings in multiple levels. If you set a lower-level value in this type of select list, all values above this level are also set. For example, in the Equipment Types select list, if you set ProcessEqTypes5 to 370, the higher-level values are also set: ProcessEqTypes4 to 360, ProcessEqTypes3 to 325, and so forth.

  • System - Contain values that users must not change.

You can modify most select lists to reflect your own practices, terminology, and language. You can make revisions to a select list set by editing the AllCodeLists.xls workbook (or other select list workbook) and then bulk loading. You can also add or edit select lists in the Catalog task.

When you add an entry to a select list, the number for the entry must be between 10,000 - 40,000. Numeric values less than 10,000 and greater than 40,000 are reserved for use by the software.

Here are some important points to remember about deleting and modifying select lists. You cannot delete a select list after it is loaded into the Catalog database. However, you can delete values in certain select lists. The Bulkload utility supports delete and replace for select lists.

You can rename select lists. The name for a select list corresponds to the column name on the sheet, not necessarily the sheet name in the workbook. The name for each select list must be unique in the database.

You can edit the lowest level in a hierarchical select list, but you must not edit any higher levels in the select list. You can edit simple select lists (without a hierarchy) unless otherwise specified on the sheet.

  • For quick links to all the select lists, see the Index sheet in the AllCodeLists.xls workbook.

  • The namespace for user-defined select lists is UDP. This designation is placed in the CodeListTableNamespace column on the Custom Interfaces sheet. For more information about select lists and namespaces, see Select List (Codelist) Namespaces.

  • The limit for select list names is 205 characters for Microsoft SQL Server and 210 characters for Oracle databases. You cannot use blanks or special characters in these names.

  • The limit for the long and short descriptions in a select list is 255 characters.

  • All values in the short description column for a select list must be unique for that list.

  • For more information on naming limitations, see Appendix: Name Limitations in Reference Data.