How do I delete a code from a code table?

How can I delete a code from a code table if there are historical records attached to it?
If the code is associated with any records, you will want to change all the historical records or leave the code in the code table.  You will receive an error message on those records if you remove a code from the code table that is still in use.  

Changing Code Schemes: Over time you may decide that you want to change a particular coding scheme to be more meaningful.   Perhaps you have some old codes that you would like to change into newer codes.   This can be done with assistance from FIMS Support staff and the Global Change program in FIMS.   Global changes can also be done with some limited selection criteria.  

For example, if the County Code is 'xyz' then change the Region Code to 'abc'.   Also, codes can be globally removed from fields to leave the field blank.   It is important not to delete old codes out of a code table .   If you do that, then when you go to an old record that has that code, you will be prompted to enter a valid code from the code table, and will not be able to leave that record until you do so.   You should:
  1. Add the new codes into the code table
  2. Have FIMS Support staff help you do the global change
  3. Then it is safe to remove the old codes from the code table.  
Note that the Global Change program should only be used with assistance from FIMS Support staff.   There is no recycle bin or undo button to reverse the procedure.  A backup of data is always strongly recommended before performing a global change.  If you are thinking you would like to do a global change, please contact FIMS Support to discuss the options.    



Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.