My Engineering people created code X (miscellaneous) to group them all.

Hi guys,

I know this thread is old now but hope you can still help.

The company that i work for has recently decided to buy a new CMMS. Problem is our current asset register is very poor and they want me to expand upon. The asset numbers have no consistancy and make no sense and they want to change them but keep the area code. I have finished gathering all info for the register. There is about 3300 assets recorded and the heirarchy level goes down to 7 in some places but not many. Mostly around 3-4 level.

I dont know what way to go about the numbering scheme. Was thinking just a sequential system that follows the heirarchy structure.
example:
01 Production Line 1 level 1
01-0100 Press level 2
01-0100-01 Press Pusher level 3
01-0100-01-01 Press Pusher Electric Motor level 4
01-0100-01-02 Press Pusher Gearbox level 4
01-0100-02 Press Extractor level 3
01-0200 Ovens level 2
01-0300 Saws level 2
01-0300-01 Grading Line level 3
01-0300-01-01 Grading Line Grading Bin 1 level 4
01-0300-01-01-01 Grading Line Grading Bin 1 Electric Motor Level 5
01-0300-01-02 Grading Line Grading Bin 2 level 4
01-0300-02 Planer Line level 3

It is set up to follow the flow of production.

I was thinking tho if i wanted to add more equipment at the start of the production line i will be starting with higher numbers. This upsets the structure and then the idea is flawed. I want an easy structure to setup as really the asset number has no use in the CMMS program. Its just an unique number. U can search in the CMMS by asset type so theres no real use of it being in the asset number.

Another option was to have a brief description of the asset in the asset number from level 3 onwards.
01-0100-PUSH Press Pusher level 3
01-0100-PUSH-EM Press Pusher Electric Motor level 4
01-0100-PUSH-GBX Press Pusher Gearbox level 4
01-0100-EXTR Press Extractor level 3

01-0300-GL Grading Line level 3
01-0300-GL-GB1 Grading Line Grading Bin 1 level 4
01-0300-GL-GB1-EM Grading Line Grading Bin 1 Electric Motor level 5
01-0300-GL-GB2 Grading Line Grading Bin 2 level 4

I know that you should do whatever works for your business but i would like to get some opinions on these options or give some ideas on how to go about a structure that suits up to level 7 heirarchy structure.

quote:

01-0100-01-01

, don't feel offended but I couldn't resist making a comparison with the early books on computer science, where you had to write something similar to sum 3 and 4 (binary operations)


Some questions:
1) Will you transport your old history to the new system? Sometimes it is better to start over from scratch.

2) How does the crowd out there call/know the equipment? Are there tags punched on the equipment?

3) Who is going to generate the work requests? What is their opinion?

4) Is there an object hierarchy available in the new CMMS? Someting like parent and child asset?

5) I would call PL-01 the parent object, and link the Press Pusher # as a child.

6) Are there any operating/maintenance instructions identifying the assets?

7) Are there drawings, planrt maps etc.. identifying the assets?

8) Can you build a category and class list of the equipment?

Maybe I am biased but there are a lot of fields in the "modern" CMMS that can help you avoiding to make your equipment master list as interesting as a phonebook indexed by telephone number.

9) You are switching from ? to ? , I am not a vendor but maybe some of us already faced this dillema

There 2 things of a pair here ie the tag nos and equipment nos assigned to the tag nos.

I guess the company production line has existing tag nos based on drawings. These tag nos should be arranged in a hierarchical structure which you try to have above.

Now the equipment nos can be internally generated by the CMMS or externally generated. Internal equipment which are sequentailly genreated appears sufficient to me.

svanels

not offended. constructive criticism is good. i understand your point. is a bit binary isnt.

answers to your questions
1) no history will be transported into the new system. starting from scratch

2) i have the terminology used pretty down pat. there are no tags on the equipment.

3) work requests are made from all trades. it is done paper based and they make reference by just naming the equipment not by asset number. the cmms we have has a request module in it n eventually all requests will be done through the system.

4) there is parent/child relationships. i tried showing that in the example given but didnt come out to good. if you look back at my examples at the end of the asset description there is the level it sits in the heirarchy tree.

5) PL-01 is level 1
press is level 2
press pusher is level 3
press pusher electric motor level 4

6) Yes all the pm's have been transferred from old cmms to new one. There is no parent/child relationships in the structure they used in the old cmms. all was a level 1.

7) There are drawings but cant make reference to them via the asset number.

8) Yes. can class equipment by the type of the asset.

9) We are switching from mainpac v3.1 if i recall (was last updated in 99 so very old and they didnt upgrade licences and thus is the reason of changing) to the latest version of MEX.