Creating Supplier ID's

The first step in populating tables for organization data is to create Supplier ID's. The SKB uses a classification-instance (ID's) approach for data modeling. Therefore the ID's must be unique and start with the appropriate characters for the classification.

Note: Supplier IDs are not visible in the Selector.

To enter Supplier ID's:

1. In the navigation tree, open the organization data folder .

2. In the data manager, click on the table tab to display the table which to populate.

3. In the table, simply click in a cell under the Supplier ID column and type in an ID. (Avoid all capital letters.) Copy and paste can also be used to populate this information.

To view examples of Supplier ID's for a particular table, click on the links below:

• Industry Table

   

  Supplier ID	Order	Description [English]	Description [Germany]	Description [French]	Description [Spanish]
  Ind-All	0	All	All	All	All
  Ing-Ag	10	Agriculture	Agriculture	Agriculture	Agriculture
  Ind-Chem	15	Chemical	Chemical	Chemical	Chemical
  Ind-O&G	20	Oil & Gas	Oil & Gas	Oil & Gas	Oil & Gas

  Note: A Supplier ID Ind-All is highly recommended. This will provide an "all" search criteria selection for the Selector user.

• Product Classification Table

   

  Supplier ID	Order	Description [English]	Description [Germany]	Description [French]	Description [Spanish]
  Prod-All	0	All	All	All	All
  Prod-Sub	10	Submersible	Submersible	Submersible	Submersible
  Prod-Rot	15	Rotary	Rotary	Rotary	Rotary
  Prod-Slurry	20	Slurry or abrasive	Slurry or abrasive	Slurry or abrasive	Slurry or abrasive

  Note: A Supplier ID Prod-All is highly recommended. This will provide an "all" search criteria selection for the Selector user.

• Orientation Table

   

  Supplier ID	Order	Description [English]	Description [Germany]	Description [French]	Description [Spanish]
  Orient-All	0	All	All	All	All
  Orient-Horiz	10	Horizontal	Horizontal	Horizontal	Horizontal
  Orient-Vert	15	Vertical	Vertical	Vertical	Vertical

  Note: A Supplier ID Orient-All is highly recommended. This will provide an "all" search criteria selection for the Selector user.

• Construction Specification Table

   

  Supplier ID	Order	Description [English]	Description [Germany]	Description [French]	Description [Spanish]
  CSpec-None	0	All	All	All	All
  CSpec-API 8th	10	API 610 8th Edition	API 610 8th Edition	API 610 8th Edition	API 610 8th Edition

  Note: A Supplier ID CSpec-None is highly recommended. This will provide an "all" search criteria selection for the Selector user.

• Liquid Table

   

  Supplier ID	Order	Description [English]	Description [Germany]	Description [French]	Description [Spanish]
  Liq-Wat	10	Water	Water	Water	Water
  Liq-HC	15	Hydrocarbon	Hydrocarbon	Hydrocarbon	Hydrocarbon
  Liq-Chem	20	Chemical	Chemical	Chemical	Chemical

   

• Minimum Required Material Table

   

  Supplier ID	Order	Description [English]	Description [Germany]	Description [French]	Description [Spanish]
  MatMin-All	0	All	All	All	All
  MatMin-CI	10	Cast iron	Cast iron	Cast iron	Cast iron
  MatMin-SS	15	Stainless steel	Stainless steel	Stainless steel	Stainless steel
  MatMin-NM	20	Non-metallic	Non-metallic	Non-metallic	Non-metallic

  Note: A Supplier ID MatMin-All is highly recommended. This will provide an "all" search criteria  selection for the Selector user.

• Viscosity Specifications

   

  The viscosity specification table contains viscosity corrections supported by the Selector. The corrections are hard coded to control specific functionality in the Selector. The following corrections are supported:

  • HI 2010

  • HI 2004

  • HI 1994

  • Karassik

  Additionally three custom viscosity correction selections are available:

  • ViscositySpec-Custom_1

  • ViscositySpec-Custom_2

  • ViscositySpec-Custom_3

  This allows for custom viscous specifications to be defined for specific liquids. These can be used in defining corrections for efficiency/power, head, and flow. See the Adjustments page for performance correction details.

4. Click  to save changes.