...
| 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 |
|
|
|
|
|
|
|---|
|
|
. This example represents the target and max and minimum quanity of each unique ingredients in each compoment of a tobacco product. STRFID must be represented using the identical value defined by the sponosr in the Ingredient (IN) domain. IQUNIT is the unot assoicated with the target, min, and max.
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:
- 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 complex ingredients and their subcomponents in the IQ domain structure.
Image Added
| Dataset wrap |
|---|
|
| Dataset2 |
|---|
| Row | DOMAIN | STUDYID | SPTOBID | STRFID | IQCAT | IQPARENT | IQLEVEL | IQFUNCT | IQTARG | IGMIN | 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 |
|
|
...