Assets

There are several dozen different asset types in Infor Public Sector, ranging in size and complexity from street signs and water valves to buildings and water treatment plants. If your agency has purchased the Agency Defined Asset module, you can also create your own asset types.

All asset types are grouped in three general classes, each representing a different way of identifying assets.

• Simple assets are stand-alone entities that can be identified by a single identification code. Simple asset types range from pipe joints and valves to buildings and water treatment plants.
• Network assets are used to define such asset types where the asset is a portion of a network between two other assets. For example, a sewer main is identified as the section of pipe between two manholes. Note that the two endpoints for network assets must be simple assets.
• A segment asset follows the model of a street segment, which is identified by a street ID and a segment ID.

In the database, each asset has records in two different tables:

• The COMP table is a central table that stores information on all assets in the database, regardless of the asset type.
• Each asset type also has its own concrete table, such as COMPVEH for vehicles. The COMP table stores basic identifying information for the asset, and the concrete table stores information that is specific to the asset type. For example, the COMPVEH table stores information such as a vehicle's model number, engine type, and transmission type. The two records are linked through the asset key (COMPKEY column).