Difference between ASSETID and ASSETUID

Difference between ASSETID and ASSETUID

I got confused when I saw ASSET table having extra unique column ASSETUID. Now, I could see 3 unique identifiers for Asset Number in Asset Table in Maximo (v6 onwards).

• ASSETNUM - is SITE specific and Unique at Site Level (well known, nothing new)
• ASSETID - default field, created by DB Configuration in Maximo when you create an MBO, associated with a Sequence
• ASSETUID - this is ACTUALLY the UNIQUE field of ASSET table in Maximo, this is also associated with a Sequence

Key things which I noticed in Maximo:

• When you add a Long Description to an Asset record, it's ASSETUID is copied to LDKEY attribute of LONGDESCRIPTION table. (in other objects e.g. LOCATIONS, LOCATIONSID is copied to LDKEY)
• When you Move/Modify any Asset from one Site to another, Asset record gets copied to the other Site and the existing one is set to DECOMMISSIONED. In this case, ASSETID value of both the records will be same but ASSETUID for the new (moved) Asset record will be changed.

So, it can be said that ASSETUID is the UNIQUE field of ASSET table.

thanks for reading...