The IT example below shows tobacco filler and the types of tobacco of which it is composed, each 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 the Tobacco Filler and the Reconstituted Tobacco are complex ingredients (they both have two or more sub-components). The details of which single tobacco ingredients compose these complex ingredients is made explicit in the IQ dataset example further down). 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).
...
The IN dataset example below shows the list of non-tobacco ingredients
Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-112 |
---|
|
Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-106 |
---|
|
used in the tobacco product identified as CIG01A. Each unique ingredient is listed in IGDCMPID. Where applicable, IUPAC name and CAS number are listed (IUPACNAM and CASNO, respectively). INIGDPLX is used to indicate whether an ingredient is a single ingredient or a complex ingredient. INSPFL indicates whether complex ingredients were made to the applicant's specification. Grade, purity, manufacturer name and ID number, and the
Tobacco Product Master File number File number complete the dataset.
Dataset wrap |
---|
|
Dataset2 |
---|
Row | DOMAIN | STUDYID | SPTOBID | IGDCMPID | INMANUF | INMANUFN | TPMF | IUPACNAM | CASNO | INIGDPLX | INSPFL | INGRADE | INPURTY |
---|
1 | IN | TOB07 | CIG01A | Cocoa Extract | Flavor House A | FLVR1234 | MF5555555 |
|
| COMPLEX INGREDIENT | N |
|
|
---|
2 | IN | TOB07 | CIG01A | Butyric Acid |
|
|
| butanoic acid | 107-92-6 | SINGLE INGREDIENT |
| Food | ≥99% |
---|
3 | IN | TOB07 | CIG01A | Cellulose Filter A | MFR A | FIL789 |
|
| - | COMPLEX INGREDIENT | N |
|
|
---|
4 | IN | TOB07 | CIG01A | Cellulose Acetate |
|
|
| cellulose acetate | 9004-35-7 | SINGLE INGREDIENT |
|
|
|
---|
5 | IN | TOB07 | CIG01A | Triacetin |
|
|
| 1,3-diacetyloxypropan-2-yl acetate | 102-76-1 | SINGLE INGREDIENT |
|
|
|
---|
6 | IN | TOB07 | CIG01A | FSC Paper B | MFR B | FSC123 |
|
|
| COMPLEX INGREDIENT | N |
|
|
---|
7 | IN | TOB07 | CIG01A | Cellulose Pulp |
|
|
| cellulose pulp | 65996-61-4 | SINGLE INGREDIENT |
|
|
|
---|
8 | IN | TOB07 | CIG01A | Calcium Carbonate |
|
|
| calcium carbonate | 471-34-1 | SINGLE INGREDIENT |
|
|
|
---|
9 | IN | TOB07 | CIG01A | Sodium Alginate |
|
|
| sodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate | 9005-38-3 | SINGLE INGREDIENT |
|
|
|
---|
10 | IN | TOB07 | CIG01A | Trisodium Citrate |
|
|
| trisodium;2-hydroxypropane-1,2,3-tricarboxylate | 6132-04-3 | SINGLE INGREDIENT |
|
|
|
---|
11 | IN | TOB07 | CIG01A | Cationic Starch |
|
|
| starch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride | 56780-58-6 | SINGLE INGREDIENT |
|
|
|
---|
12 | IN | TOB07 | CIG01A | Seam Adhesive | MFR C | ADV123 | MF2345678 |
| - | COMPLEX INGREDIENT | N |
|
|
---|
13 | IN | TOB07 | CIG01A | Methylcellulose |
|
|
|
| 9004-67-5 | SINGLE INGREDIENT |
|
|
|
---|
14 | IN | TOB07 | CIG01A | 1,3-Butanediol |
|
|
| Butane-1,3-diol | 34844-08-1 | SINGLE INGREDIENT |
|
|
|
---|
|
|
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 identifies the ingredient or component of which a component or complex ingredient composed of the sub-ingredientcomponents/sub-component ingredients shown in IDGCMPID is a partIDGCMPID. IQLEVEL is used to identify at what level
Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-240 |
---|
|
in the overall hierarchy
the that sub-component/
sub-ingredient appears.
The following implementation rules apply:
...
- 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 an IQLEVEL value of "1" in IQLEVEL.
- Records describing sub-components/ingredients that compose a parent component listed in the dataset will have IQPARENT value equal to the IGDCMPID of that parent 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 IQPARENT and IQLEVEL help make explicit the relationship between complex ingredients (or components ) and the sub-components/ingredients of which they are composed, 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 component and its sub-component components/ingredients in the IQ domain structure.
Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-239 |
---|
|
...