I recently had a project similar (in some respects) to this one. I didn't anything to do with maintaining the translation tables. So I wrote a module that would read an Excel spreadsheet (via Spreadsheet::ParseExcel) and generates the required code. So they only had to edit the spreadsheet to generate the desired data transform. It worked very nicely, as I required a particular format.

--roboticus