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

Deleting MT Codes - What are the implications?

Deleting MT Codes - What are the implications?

Deleting MT Codes - What are the implications?

Does anyone know of any issues with deleting codes from the (MT) Maintenance Type table file? These MT codes are also in a number of cross reference tables. Do the cross reference entries need to be deleted at the same time? If so, what is the recommended way to do that?



RE: Deleting MT Codes - What are the implications?

As a matter of principle you should not delete any MSF010 table codes, as long as there are any other records in the system (eg work orders), that point to them. Or your system will become more or less inconsistent. On the least severe scale, you won't be able to review the MT code's  Description, when you review work order online or in reports. At the other end, the system will malfunction if the codes play a role in system logic: noting that there are Associated Values defined for the MT code, which indicates that they are not simply used for Descriptive purpose, but could drive some functionality in the system.

If codes are no longer required, an alternative would be to alter the Descriptions and insert 'DO NOT USE', leaving the old description also in place. That would allow to review history of work orders, as well as stop users from using these codes in the future.
The cross reference records may serve various purposes and it is even riskier to delete. The only safe approach is to use a system archiving facility if one were available for  work orders, in order to remove older work orders/ cross references, then check if any work order still exist with the MT codes, and if not, then manually delete the MT codes (as an archiving routine would not delete MSF010)

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