API to retrieve Value Set internal value from visible value and vice versa

Hi,

We have embarked on a data migration project and aiming to create a generic data migration program for each entity (e.g. HR Person, Assignment, Extra Information Types, Payment Methods etc) that can easily be adapted at our various sites with minimal change in code. The solution is highly meta-data driven e.g. all mapping rules, transformation rules and inputs will be held in custom tables which will be implementation specific - and the framework will use the data in these tables to derive the values that will be passed to the relevant APIs.

In order to make the solution to be truly generic I require an API that will accept a Value Set Name and the Code (i.e. the value that is saved the database table e.g. for Table type Value Set this will be the Table Column ID, or for Independent Value Sets this will the Value) and return the displayed value e.g. Table Column Value for