Global Code Change Program

The Global Code Change Program is a tool that can be used to change data on a system level for all records. It is recommended to copy live to demo and do any global changes in the demo database first since any global changes are irreversible. 

This program uses a comma separated file as an import with the following format.

     Table Name,Old Key Value,New Key Value

     purpose,add,addf

     gifttype,ins,inkd

     granteetype,ED-1,ED

     region,Town,D1

The first column, Table Name is the FIMS Code Table Name. The second and third columns are the Old and New Key Values.

The program changes all of the records for all of the tables associated with the code table from the old value to the new value.

For the above example Region, it will change all of the region codes in Application, AppHistory, Grants and Fund Distributions that are "Town" to "D1".