TPUU to MP

In accordance to the AMT model, to deduce the Medicinal Product (MP) from the Trade Product Unit of Use (TPUU), simple heirarchial traversal is needed.

Example

For example, we want to find that paracetamol + codeine is the Medicinal Product of Rapideine uncoated tablet.

(
 (>> 54016011000036103|Rapideine uncoated tablet| AND ^ 929360061000036106|Medicinal product reference set|)
 MINUS
 (>(>> 54016011000036103|Rapideine uncoated tablet| AND ^ 929360061000036106| Medicinal product reference set |))
)

In this example, Rapideine is a multi-component substance and contains paracetamol and codeine. The first query returns all ancestors of Rapideine uncoated tablet that are members of the MP reference set. The issue with simply executing thie query is that in addition to paracetamol + codeine being returned, both paracetamol and codeine are returned as individual concepts as they are also ancestors.

In order to eliminate these other ancestors and only return the most proximal result to Rapideine, a MINUS constraint is used. It works by removing the second result set from the first result set, where the second query finds all the ancestors of the concepts returned from the first query. This leaves only concepts that are returned by the first query that are not also ancestors of other concepts returned by the first query.