Yes, this is almost certainly possible using this construct:

UPDATE tablea

set ... case statements here for each field with proper code table

FROM tablea

LEFT JOIN to various code tables

It is pretty complex and to me goes beyond the simple nature of forum posts. Hopefully you can figure it out from above or someone else will jump in and take the time to build it out for you. Or you can get a consultant to help.