Page History

...

Finally, the IQ dataset example shows the quantity (target, minimum and maximum) of each ingredient listed in STRFID that the product (SPTOBID) is designed to contain, with the units for each of these values represented in IQUNIT. The function of each ingredient is described in IQFUNCT. Ingredients that appear in more than one component of the tobacco product are quantified separately for each component. (we need examples of this to illustrate. I created one but not sure how valid it is) IQPARENT and IQLEVEL are used to identify the component to which the record applies and and at which level in the overall hierarchy the ingredient appears, with the following implementation rules:

• IQPARENT must correspond to a value of STRFID in the same table. If parent is null, the ingredient is considered a top-level component and is assigned a value of "1" in IQLEVEL.
• Records describing ingredients that are sub-components of another ingredient listed will have IQPARENT set to equal the STRFID of that ingredient. IQLEVEL will be set to n +1, where n=the parent record's value of IQLEVEL.

The concept map below illustrates the representation of the hierarchical relationships between a complex ingredient and its subcomponents in the IQ domain structure. The hypothetical parent ingredient has two constituent components, A and B. Additionally, B consists of two constituent components, B1 and B2. Therefore, there are a total of 5 ingredient records to be represented in the IQ domain: the parent ingredient, its two constituent components A and B, and B's two constituent components, B1 and B2. . This map is provided for illustration purposes as no ingredient in the IQ dataset example that follows has this complexity of composition.

...