Page History

The IT example below shows tobacco filler and the 4 types of tobacco of which it is comprised listed as tobacco ingredients (IGDCMPID) for the Tobacco Product CIG01A (SPTOBID). The variable ITSPECIF shows the specification (variety) of the first three tobaccos. ITIGDPLX is used to indicate that Reconstituted Tobacco is a complex ingredient . (it has two more sub-components). ITCURMTH indicates the cure method. ITSPFL is used to indicate whether complex ingredients were made to the applicant's specification. TPMF indicates the Tobacco Product Master File. Note that there are two varieties of burley tobacco in this tobacco product, thus each is given a unique IGDCMPID value (Burley Tobacco and Burley Tobacco 2).

...

Finally, the IQ domain is used to represent the quantity (target, minimum and maximum) of each ingredient identified in IGDCMPID that the product (SPTOBID) is designed to contain, with the units for 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. IQPARENT and IQLEVEL are used to identify the component/ingredient identifies the ingredient or component of which the sub-ingredient/sub-component shown in IDGCMPID is a record is a sub-component part. IQLEVEL is used to identify at what level

• IQPARENT must correspond to a value of IGDCMPID in the same dataset. 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-component ingredients of another ingredient/component listed in the dataset will have IQPARENT value equal to the IGDCMPID of that ingredient/component. IQLEVEL will be set to n +1, where n=the parent record's value of IQLEVEL. 
• Every value of IGDCMPID used in the IQ dataset must have a matching value of IGDCMPID:
  • In the IT dataset (when IQCAT=TOBACCO INGREDIENT) or,
  • In the IN dataset (when IQCAT=NON-TOBACCO INGREDIENT)
  • Therefore, IQCAT is required to relate ingredient quantity records in IQ to the associated ingredient attributes described in either IT or IN.

The use of IQLPARENT IQPARENT and IQLEVEL help make explicit the relationship between complex ingredients/components and their sub-componentsconstituent ingredients, and can assist when totaling the quantities of an ingredient that appears in multiple components of a tobacco product. 
The concept map below illustrates the representation of the hierarchical relationships between a complex ingredient and its sub-component ingredients in the IQ domain structure. 

...