×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ELLIPSE EQUIPMENT REGISTER - CORRUPT MASTER DATA

ELLIPSE EQUIPMENT REGISTER - CORRUPT MASTER DATA

ELLIPSE EQUIPMENT REGISTER - CORRUPT MASTER DATA

(OP)
Has anyone experienced the issue where the data entered into Ellipse is corrupt? If yes - have you cleansed the data and how did you go about data cleansing.

I am currently studying at CQU for a masters in maintenance management and the corrupt master data and its cleansing is my research topic.

I am employed at a large mining company in Queensland, our equipment register has over 63,000 items loaded

I have categorised the types of data corruption existing in our equipment register below:
.Duplicate assets
.Non-compliance to companies standards (many employees have access to maintain the equipment register)
.Using a generic/miscellaneous equipment class (ie XX)
.Incorrect settings of various flags (ie Active checkbox not activated)
.Orphaned equipment (no productive unit linked)
.Items loaded that are not considered as maintainable assets by companies asset definition(ie domestic appliances)
 

RE: ELLIPSE EQUIPMENT REGISTER - CORRUPT MASTER DATA

It does not appear as data corruption as much as the lack of, or not following, procedures regarding maintaining the data.  It sounds like a free-for-all when it comes to updating the equipment which is a recipe for what you describe.  Clean-up in this case is accomplished by getting a couple of your knowledgeable maintenance folks together with someone who knows the back-end really well and can effectively query the data.  No silver bullets here, just a lot of painstaking work.

On the other hand, if your data was initially loaded into Ellipse and is corrupt, then you need an experienced back-end person with SQL skills working with the maintenance folks to investigate and clean-up (plug) the data.

Good luck.  

RE: ELLIPSE EQUIPMENT REGISTER - CORRUPT MASTER DATA

(OP)
Thanks WiseOldFool - you are spot on with your comments!

Prior to my time with the business a couple of things happened - firstly its a bit of a legacy/cultural issue before MIMS was implemented each maintenance department had their own CMMS (MEX, Engarde, MainPac, etc) that was maintained by their planner(s), including the equipment register, when MIMS was implemented back in the late 90's a heap of the existing legacy systems data was loaded into MIMS and planners (about 60 planners) STILL retained the privilages of being able to maintain the equipment register - the result being a whole heap of corruption in the register. We have a project currently running that will address the corrupt data AND prevent future free-for-all access to the equipment register.

I am still interested in hearing of anyone that has experienced a similar problem with MIMS/Ellipse or any other ERP/EAM or CMMS. And how they resolved the issues.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close