Built a data validation engine for a customer, one of the requirements that certain attributes are only allowed a predefined set of values. This is all running of a mapping table as the configuration input.
Yet I already have another mapping table that contain all the building codes and descriptions, and etc. Thus, instead of providing a list of all building codes, I used the column in the already defined building mapping table as the possible predefined values.
In the data validation configuration mapping table the configuration for the predefined values are :, i.e.: \[root]\Org\OU\Driver Set\Library\Building Information:BuildingCodes
Thus, no duplicate maintenance of building code mapping table and the possible predefined values for the building codes.