...
| Dataset wrap |
|---|
|
| Dataset2 |
|---|
| | STUDYID | SPTOBID | STRFID | ITSPECIF | ITCAT | ITCURMTH | ITSPFL | RTOBMF |
|---|
| 1 | IT | TOB07 | CIG01A | Burley Tobacco | NC 7LC |
| Air |
| MF5555555 |
|---|
| 2 | IT | TOB07 | CIG01A | Bright Tobacco | CC 1063 |
| Flue |
|
|
|---|
| 3 | IT | TOB07 | CIG01A | Oriental Tobacco | USDA Nicotiana Collection PI 552747 |
| Sun |
|
|
|---|
| 4 | IT | TOB07 | CIG01A | Reconstituted Tobacco |
| COMPLEX PURCHASED INGREDIENT |
| No |
|
|---|
|
|
The IN dataset example below shows the list of non-tobacco ingredients used in the tobacco product identified as CIG01A. Each unique ingredient is listed in STRFID. Where applicable, IUPAC name and CAS number are listed (IUPACNAM and CASNO, respectively). INCAT is used to indicate whether an ingredient is a single chemical substance or a complex purchased ingredient. INSPFL indicates whether complex purchased ingredients were made to the applicant's specification. Grade, purity, manufacturer name and ID number, and the reference tobacco master file number complete the dataset.
...
Finally, the IQ domain is used to represent the quantity (target, minimum and maximum) of each ingredient identified in STRFID 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. (see note 3) IQPARENT and IQLEVEL are used to identify the component to /ingredient of which the record applies ingredient in a record is a constituent component, and and at which level in the overall hierarchy the constituent ingredient appears, with the . The following implementation rules apply:
- IQPARENT must correspond to a value of STRFID 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 constituent ingredients of another ingredient/component listed in the dataset will have IQPARENT set value equal to the STRFID of that ingredient/component. IQLEVEL will be set to n +1, where n=the parent record's value of IQLEVEL.
- Every value of STRFID used in this the IQ dataset that has an IQLEVEL >1 (See note 4) must have a matching value of STRFID in either:
- The IT dataset (when IQCAT=TOBACCO INGREDIENT) or,
- 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 concept map below illustrates the representation of the hierarchical relationships between a complex ingredient and its constituent ingredients 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.
...
The IQ dataset example illustrates these the principles discussed above using a cigarette tobacco product.:
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Rows 1, 10, 13: | Show three top-level components of a cigarette product: tobacco filler, filter and cigarette paper, respectively. Their target, minimum and maximum quantities expressed in units of mg/cigarette are shown in IQTARG, IQMIN, IQMAX and IQUNIT. Because there is no parent component other than the finished product itself, IQPARENT is null, and IQLEVEL = 1, indicating that these are top-level ingredients/components of the finished product. | | Rows 2-5: | Show the quantities of four types of tobacco used in the product. IQPARENT=Tobacco Filler and IQLEVEL=2, together indicating that these are constituents of the tobacco filler, a top level-component of the cigarette product. | | Rows 6-7: | Show the quantities of Methylcellulose and 1,3-Butanediol, Both are constituent ingredients of Reconstituted Tobacco as indicated by IQPARENT. IQFUNCT shows that Methylcellulose functions as a binder and 1,3-Butanediol functions as a humectant. IQLEVEL=3 to show that these ingredients are at the 3rd level of the hierarchy. | | Rows 8-9: | Show the quantities of two constituent ingredients that both function as a flavorant in the tobacco filler (as indicated by IQPARENT=Tobacco Filler). | | Rows 11-12: | Show the quantities of two constituent ingredients that function as filtration and binder, respectively in the filter portion of the cigarette (Cellulose Filter A, a top-level component). | | Rows 14-19: | Show the quantities and function of five constituent ingredients of the top-level component FSC Paper B (the cigarette paper). |
|
| Dataset2 |
|---|
| Row | DOMAIN | STUDYID | SPTOBID | STRFID | IQCAT | IQPARENT | IQLEVEL | IQFUNCT | IQTARG | IQMIN | IQMAX | IQUNIT |
|---|
| 1 | IQ | TOB07 | CIG01A | Tobacco Filler | TOBACCO INGREDIENT |
| 1 |
| 672.5 | 661.3 | 683.7 | mg/cigarette | | 2 | IQ | TOB07 | CIG01A | Burley Tobacco | TOBACCO INGREDIENT | Tobacco Filler | 2 |
| 19 | 17 | 21 | mg/cigarette | | 3 | IQ | TOB07 | CIG01A | Bright Tobacco | TOBACCO INGREDIENT | Tobacco Filler | 2 |
| 300 | 295 | 305 | mg/cigarette | | 4 | IQ | TOB07 | CIG01A | Oriental Tobacco | TOBACCO INGREDIENT | Tobacco Filler | 2 |
| 115 | 113 | 117 | mg/cigarette | | 5 | IQ | TOB07 | CIG01A | Reconstituted Tobacco | TOBACCO INGREDIENT | Tobacco Filler | 2 |
| 231 | 229 | 233 | mg/cigarette | | 6 | IQ | TOB07 | CIG01A | Methylcellulose | NON-TOBACCO INGREDIENT | Reconstituted Tobacco | 3 | Binder | 20 | 19 | 21 | mg/cigarette | | 7 | IQ | TOB07 | CIG01A | 1,3-Butanediol | NON-TOBACCO INGREDIENT | Reconstituted Tobacco | 3 | Humectant | 24 | 23 | 25 | mg/cigarette | | 8 | IQ | TOB07 | CIG01A | Cocoa Extract | NON-TOBACCO INGREDIENT | Tobacco Filler | 2 | Flavor | 7 | 6.75 | 7.25 | mg/cigarette | | 9 | IQ | TOB07 | CIG01A | Butyric Acid | NON-TOBACCO INGREDIENT | Tobacco Filler | 2 | Flavor | 0.5 | 0.55 | 0.45 | mg/cigarette | | 10 | IQ | TOB07 | CIG01A | Cellulose Filter A | NON-TOBACCO INGREDIENT |
| 1 | Filter | 164 | 163 | 165 | mg/cigarette | | 11 | IQ | TOB07 | CIG01A | Cellulose Acetate | NON-TOBACCO INGREDIENT | Cellulose Filter A | 2 | Filtration | 155 | 154 | 156 | mg/cigarette | | 12 | IQ | TOB07 | CIG01A | Triacetin | NON-TOBACCO INGREDIENT | Cellulose Filter A | 2 | Plasticizer | 9 | 8 | 10 | mg/cigarette | | 13 | IQ | TOB07 | CIG01A | FSC Paper B | NON-TOBACCO INGREDIENT |
| 1 | Cigarette Paper (Wrapper) | 50 | 49 | 51 | mg/cigarette | | 14 | IQ | TOB07 | CIG01A | Cellulose Pulp | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Fiber | 30 | 29 | 31 | mg/cigarette | | 15 | IQ | TOB07 | CIG01A | Calcium Carbonate | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Filler | 15 | 14 | 16 | mg/cigarette | | 16 | IQ | TOB07 | CIG01A | Sodium Alginate | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Reduced ignition propensity | 2 | 1.75 | 2.25 | mg/cigarette | | 17 | IQ | TOB07 | CIG01A | Trisodium Citrate | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Combustion Modifier | 0.5 | 0.45 | 0.55 | mg/cigarette | | 18 | IQ | TOB07 | CIG01A | Cationic Starch | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Binder | 0.5 | 0.45 | 0.55 | mg/cigarette | | 19 | IQ | TOB07 | CIG01A | Seam Adhesive | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Adhesive | 2 | 1.75 | 2.25 | mg/cigarette |
|
|
...