How to Build a Business Rules Engine

subtype in some other table, then all code values in the reference data table would

be expected to be used to identify subtypes.

It is not possible to produce this report by a single SQL SELECT statement. It

requires program logic to be created as follows:

䊏

All reference data tables that are used in any way to identify subtypes need to

be found. This can be done by looking at each value in Subtype Discriminator

Column ID in the Subtype table and finding the parent reference data table.

䊏

Information for each value of Subtype Discriminator Column ID can be

retrieved from the Column table. From this it can be determined if the

Subtype Discriminator Column ID is for an indicator column or represents a

reference data code value. If the latter is the case, ...