...
| Dataset wrap |
|---|
|
| Dataset2 |
|---|
| Row | DOMAIN | STUDYID | SPTOBID | STRFID | IUPACNAM | CASNO | INCAT | INSPFL | INGRADE | INPURTY | INMANUF | INMANUFN | TOBTMRF |
|---|
| 8 | IN | TOB07 | CIG01A | Cocoa Extract |
|
| COMPLEX PURCHASED INGREDIENT | No |
|
| Flavor House A | FLVR1234 | MF5555555 |
|---|
| 9 | IN | TOB07 | CIG01A | Butyric Acid | butanoic acid | 107-92-6 | SINGLE CHEMICAL SUBSTANCE |
| Food | ≥99% |
|
|
|
|---|
| 10 | IN | TOB07 | CIG01A | Cellulose Filter A |
| - | COMPLEX PURCHASED INGREDIENT | No |
|
| MFR A | FIL789 |
|
|---|
| 11 | IN | TOB07 | CIG01A | Cellulose Acetate | cellulose acetate | 9004-35-7 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 12 | IN | TOB07 | CIG01A | Triacetin | 1,3-diacetyloxypropan-2-yl acetate | 102-76-1 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 13 | IN | TOB07 | CIG01A | FSC Paper B |
|
| COMPLEX PURCHASED INGREDIENT | No |
|
| MFR B | FSC123 |
|
|---|
| 14 | IN | TOB07 | CIG01A | Cellulose Pulp | cellulose pulp | 65996-61-4 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 15 | IN | TOB07 | CIG01A | Calcium Carbonate | calcium carbonate | 471-34-1 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 16 | IN | TOB07 | CIG01A | Sodium Alginate | sodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate | 9005-38-3 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 17 | IN | TOB07 | CIG01A | Trisodium Citrate | trisodium;2-hydroxypropane-1,2,3-tricarboxylate | 6132-04-3 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 18 | IN | TOB07 | CIG01A | Cationic Starch | starch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride | 56780-58-6 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 19 | IN | TOB07 | CIG01A | Seam Adhesive |
| - | COMPLEX PURCHASED INGREDIENT | No |
|
| MFR C | ADV123 | MF2345678 |
|---|
| 20 | IN | TOB07 | CIG01A | Methylcellulose | (5R)-2,3,4-trimethoxy-6-(methoxymethyl)-5-[(2S)-3,4,5-trimethoxy-6-(methoxymethyl)oxan-2-yl]oxyoxane | 9004-67-5 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
| 21 | IN | TOB07 | CIG01A | 1,3-Butanediol | 4,4,4-trifluoro-2-methyl-1-phenyl-3-(trifluoromethyl)butane-1,3-diol | 34844-08-1 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
|---|
|
|
.
Finally, the IQ dataset example shows is used to represent 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. We have polyvinyl acetate used at two different levels in two different components from a Phillip Morris example, but 1) We don't have both of those components–sideseam adhesive and filter adhesive in our table. We only have "Adhesive".) 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 tabledataset. 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 constituent ingredients of another ingredient/component listed in the dataset will have IQPARENT set to equal 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 dataset that has an IQLEVEL >1 (needs discussion) 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)
The concept map below illustrates the representation of the hierarchical relationships between a complex ingredient and its subcomponents 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. This map is provided for illustration purposes as no ingredient in the IQ dataset example that follows has this complexity of composition.
Image Added
The IQ dataset example illustrates these principles using a cigarette tobacco product.Image Removed
| 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 |
|
|
...