Transferring configured asset types
If you’re transferring agency-defined asset types, it is important to be aware that the asset type keys in the source may not match the keys used for the same asset types in the destination.
Each asset type 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.
The comptypes for the standard asset types are set by Infor (such as 44 for water pumps
and 110 for fleet equipment), and are therefore consistent across all instances of
Infor Public Sector.
When you create your own asset types, Infor Public Sector assigns each new asset type the next available comptype key, starting with 1001. Because these keys are assigned automatically as asset types are added, they only apply to a particular instance. For example, the first asset type added in one instance might be IT equipment, and in another it might be public sculpture, but both would have comptype 1001.
Comptypes are used in several places in Infor Public Sector, so mismatched keys will cause errors. You might need to update comptypes manually after a transfer. The comptypes must be updated in these locations:
- In the AssetManagement configuration in the Configuration Editor. The node under 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 datafiltervalue attribute specifies the comptype key.
- 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.