Deleting MT Codes - What are the implications?
Deleting MT Codes - What are the implications?
(OP)
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?
Regards,
JS
RE: Deleting MT Codes - What are the implications?
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)