Maximo Open Forum

Hi,

I need to load asset data into maximo.
Are there any important issues to take into account if I have to increase the size of the ASSETNUM field from 12 (actual value) to 16 and also use an alphanumeric codification (actually autonumber).

thank you.

Length changes should be done through Database Configuration and it will go through all the attributes that have the sameas configured to ensure it cascades to all the appropriate child tables. One thing to be aware of is any custom attributes that your organization has defined may not have configured the same as relationships like they should have. For a column like this I would try and query the database to see if there are any attributes that you think might store an assetnum that doesn't have the necessary sameas relationship.

As for the assetnum, I typically recommend leaving the assetnum an unintelligent number. I've seen customers try to make the assetnum meaningful but then something changes. You can never update the assetnum in a supported way so if your standards change in the future you're going to be stuck with a mixture of new and old way of numbering assets. Use other fields like serialnum or new custom fields if necessary.