Transferring configured asset types
Infor Public Sector Asset Management includes tools that agencies can use to create their own asset types. If you’re transferring agency-defined asset types, it is important to be aware that the asset type keys in the source database may not match the keys used for the same asset types in the target instance of Infor Public Sector.
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 to the database, they only apply to a particular instance. 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 1001.
Comptypes are used in several places in Infor Public Sector, so mismatched keys will cause errors. With careful planning you can ensure that the comptypes of agency assets are consistent within the agency, but there may be cases where you must 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 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.