Create Table ENUMERATIONS(
Enumeration_Category	Varchar2(128) Not Null,
Enumerated_Value	Varchar2(128),
Converted_Value		Varchar2(128)
)

Data can look something like this:

Enumeration_Category		Enumerated_Value		Converted_Value
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CITY				1000				CITYA
CITY				2000				CITYB
CITY				3000				CITYC
CITY				4000				CITYD
CITY				5000				CITYE
STATE				AAAA				STATEA
STATE				BBBB				STATEB
STATE				CCCC				STATEC
STATE				DDDD				STATED
STATE				EEEE				STATEE