...
Dataset wrap |
---|
|
Dataset2 |
---|
Row | DOMAIN | STUDYID | SPTOBID | STRFID | IUPACNAM | CASNO | INCAT | INSPFL | INGRADE | INPURTY | INMANUF | INMANUFN | TOBTMRF |
---|
1 | IN | TOB07 | CIG01A | Cocoa Extract |
|
| COMPLEX PURCHASED INGREDIENT | No |
|
| Flavor House A | FLVR1234 | MF5555555 |
---|
2 | IN | TOB07 | CIG01A | Butyric Acid | butanoic acid | 107-92-6 | SINGLE CHEMICAL SUBSTANCE |
| Food | ≥99% |
|
|
|
---|
3 | IN | TOB07 | CIG01A | Cellulose Filter A |
| - | COMPLEX PURCHASED INGREDIENT | No |
|
| MFR A | FIL789 |
|
---|
4 | IN | TOB07 | CIG01A | Cellulose Acetate | cellulose acetate | 9004-35-7 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
---|
5 | IN | TOB07 | CIG01A | Triacetin | 1,3-diacetyloxypropan-2-yl acetate | 102-76-1 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
---|
6 | IN | TOB07 | CIG01A | FSC Paper B |
|
| COMPLEX PURCHASED INGREDIENT | No |
|
| MFR B | FSC123 |
|
---|
7 | IN | TOB07 | CIG01A | Cellulose Pulp | cellulose pulp | 65996-61-4 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
---|
8 | IN | TOB07 | CIG01A | Calcium Carbonate | calcium carbonate | 471-34-1 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
---|
9 | IN | TOB07 | CIG01A | Sodium Alginate | sodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate | 9005-38-3 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
---|
10 | IN | TOB07 | CIG01A | Trisodium Citrate | trisodium;2-hydroxypropane-1,2,3-tricarboxylate | 6132-04-3 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
---|
11 | IN | TOB07 | CIG01A | Cationic Starch | starch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride | 56780-58-6 | SINGLE CHEMICAL SUBSTANCE |
|
|
|
|
|
|
---|
12 | IN | TOB07 | CIG01A | Seam Adhesive |
| - | COMPLEX PURCHASED INGREDIENT | No |
|
| MFR C | ADV123 | MF2345678 |
---|
13 | 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 |
|
|
|
|
|
|
---|
14 | 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 |
|
|
|
|
|
|
---|
|
|
. FinallyFinally, the IQ domain is used to represent the quantity (target, minimum and maximum) of each ingredient listed identified 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. (see note 2) 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 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 equal 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 (See note 3) 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)
...