Comptypes

Each asset type in Infor Public Sector is identified by a unique key in the COMPTYPE column of the COMPTYPE table. Based on the column name, these asset type keys are commonly referred to as comptypes.

Comptypes are important for configuring Infor Public Sector, so you must know the values for the asset types that you create. The comptypes for the standard asset types are set by Infor, such as 44 for water pumps and 110 for fleet equipment. (See the Configuration Editor help for a list of the standard comptypes.) When you create your own asset types, Infor Public Sector assigns each new asset type the next available comptype key, starting with 1000. Infor Public Sector shows each configured asset type's comptype in the Asset Type # field at the top of the Asset Type InfoViewer.

Note: Because the comptypes for agency-defined asset types are assigned automatically as records are added to the database, they only apply to a particular instance of Infor Public Sector. For example, the first agency asset type added in one instance might be IT equipment, and in another it might be public sculpture, but both would have comptype 1000. It is important to keep this in mind if you're planning to use the Configuration Transfer tool to transfer asset types from a test server to a production server, because mismatched comptypes will cause errors. See the Infor Public Sector Configuration Transfer Tool Administration Guide for more information.

Comptypes are used in these places:

  • In the AssetManagement configuration in the Configuration Editor. The ConfiguredAssetTypes node under Families has a node for each agency-defined asset type. The TypeID attribute for each asset type specifies the comptype.
  • In the MapDrawerDatasets configuration, comptypes are often used to filter asset data, such as showing only sewer manholes from a dataset that also includes sewer pumps and valves. The datafilterfield attribute of the dataset specifies comptype as the field to filter on, and the actual comptype key is displayed in the datafiltervalue attribute.
  • In GeoAdministrator, comptype is one of the fields that are used to link records between the Infor Public Sector database and the geodatabase.
  • Comptypes might also be used in formulas, reports, mapping files, import/export templates, and data filters in the Schema Manager.