This example illustrates how the list of ingredients of a tobacco product would be represented.
The unique tobacco product substances interest would be assigned a STRFID identifier in the (IL) Ingredient List domain. The SPTOBID identifier is included in this IL domain to identify the tobacco product to which these ingredient data pertain. INCAT is used to differentiate the different categories of ingredient. INSCAT may be used to further differentiates sub categorize these ingredients. INCAT/INSCAT categories would be detemined by the sponosr and typically depend on the type of tobacco product being described. STRFID indicates the Reference ID assigned to the substance/ingredient by the sponosr. Each ingredient/substance record must be unique. Hence, the mu In this example the FDA UNII number was used. This was used since not all ingredients have a CAS Number, but usually have have UNII numbers. The information on what dictionary/code list was associated with STRID is provided in the define.xml that is submitted with the data. For example,. The same Iingredient from different manufacturers would be listed on separate lines.
Dataset wrap |
---|
|
Dataset2 |
---|
Row | DOMAIN | STUDYID | SPTOBID | STRFID | IUPACNAM | CASNO | ILCAT | ILSPEC | ILGRADE | ILPURTY | ILMETHOD | ILCMPLX | ILMANUF | ILMANUFN | ILSPFL |
---|
ILGRADEILPURTYILCMPLXILSPFLTOBTMRFCIG01A | Burley Tobacco |
| 8037-19-2 | TOBACCO PRODUCT | Air |
|
| NC 7LC | Single Substance |
|
|
|
| 2 | IL | TOB07 | CIG01A | Bright Tobacco |
| 8037-19-2 | TOBACCO PRODUCT | Flue |
|
| CC 1063 | Single Substance |
|
|
|
| 3 | IL | TOB07 | CIG01A | Oriental Tobacco |
| 8037-19-2 | TOBACCO PRODUCT | Sun |
|
| USDA Nicotiana Collection PI 552747 | Single Substance |
|
|
|
| 4 | IL | TOB07 | CIG01A | Reconstituted Tobacco |
| ????? | TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
| 5 | IL | TOB07 | CIG01A | Bright Tobacco |
| 8037-19-2 | TOBACCO PRODUCT | Flue |
|
| CC 1063 | Single Substance |
|
|
|
| 6 | IL | TOB07 | CIG01A | Oriental Tobacco |
| 8037-19-2 | TOBACCO PRODUCT | Sun |
|
| USDA Nicotiana Collection PI 552747 | Single Substance |
|
|
|
| 7 | IL | TOB07 | CIG01A | Burley Tobacco |
| 8037-19-2 | TOBACCO PRODUCT | Air |
|
| NC 7LC | Single Substance | 1
|
|
|
| 8 | IL | TOB07 | CIG01A | Cocoa Extract |
|
| NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | Flavor House A | FLVR1234 |
---|
Complex Substance Purchased | 29 | IL | TOB07 | CIG01A | Butyric Acid | butanoic acid | 107-92-6 | NON TOBACCO PRODUCT |
---|
Food3
|
|
|
| 10 | IL | TOB07 | CIG01A | Cellulose Filter A |
| - | NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | MFR A | FIL789 |
---|
Complex Substance Purchased 4
| 11 | IL | TOB07 | CIG01A | Cellulose Acetate | cellulose acetate | 9004-35-7 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
5
|
|
|
| 12 | IL | TOB07 | CIG01A | Triacetin | 1,3-diacetyloxypropan-2-yl acetate | 102-76-1 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
6
|
|
|
| 13 | IL | TOB07 | CIG01A | FSC Paper B |
|
| NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | MFR B | FSC123 |
---|
Complex Substance Purchased 7
| 14 | IL | TOB07 | CIG01A | Cellulose Pulp | cellulose pulp | 65996-61-4 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
8
|
|
|
| 15 | IL | TOB07 | CIG01A | Calcium Carbonate | calcium carbonate | 471-34-1 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
9
|
|
|
| 16 | IL | TOB07 | CIG01A | Sodium Alginate | sodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate | 9005-38-3 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
10
|
|
|
| 17 | IL | TOB07 | CIG01A | Trisodium Citrate | trisodium;2-hydroxypropane-1,2,3-tricarboxylate | 6132-04-3 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
11
|
|
|
| 18 | IL | TOB07 | CIG01A | Cationic Starch | starch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride | 56780-58-6 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
12
|
|
|
| 19 | IL | TOB07 | CIG01A | Seam Adhesive |
| - | NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | MFR C | ADV123 |
---|
Complex Substance Purchased | 1320 | IL | 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 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
---|
14
|
|
|
| 21 | IL | TOB07 | CIG01A | 1,3-Butanediol | 4,4,4-trifluoro-2-methyl-1-phenyl-3-(trifluoromethyl)butane-1,3-diol | 34844-08-1 | NON TOBACCO PRODUCT |
|
|
|
| Single 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 (IL) domain. IQUNIT is the unot assoicated with the target, min, and max.
Dataset wrap |
---|
|
Dataset2 |
---|
RowROW | DOMAIN | STUDYID | SPTOBID | STRFID | IQCAT | IQCOMP IQPARENT | IQSCOMP IQLEVEL | IQFUNCT | IQTARGET | IQLL | IGUL | IQUNIT |
---|
1 | IQ | TOB07 | CIG01A | TOBACCO BLEND | TOBACCO INGREDIENT |
| 1 |
|
|
|
|
|
| IQ | TOB07 | CIG01A | Burley Tobacco | TOBACCO INGREDIENT | TOBACCO BLEND | 2 |
| 19 | 21 | 17 | mg/article |
| IQ | TOB07 | CIG01A | Bright Tobacco | TOBACCO INGREDIENT | TOBACCO BLEND | 2 |
| 300 | 305 | 295 | mg/article |
| IQ | TOB07 | CIG01A | Oriental Tobacco | TOBACCO INGREDIENT | TOBACCO BLEND | 2 |
| 115 | 117 | 113 | mg/article |
| IQ | TOB07 | CIG01A | Reconstituted Tobacco | TOBACCO INGREDIENT | TOBACCO BLEND | 2 |
| 231 | 233 | 229 | mg/article |
| IQ | TOB07 | CIG01A | TOBACCO FILLER | TOBACCO INGREDIENT |
| 1 |
|
|
|
|
|
| IQ | TOB07 | CIG01A | Cocoa Extract | NON-TOBACCO INGREDIENT | TOBACCO FILLER | 2Tobacco Filler | Flavor | 7 |
|
| mgmg/cigarette | 2article |
| IQ | TOB07 | CIG01A | Butyric Acid | NON-TOBACCO INGREDIENT | TOBACCO FILLER | 2Tobacco Filler | Flavor | 0.5 |
|
| mgmg/cigarette | 3article |
| IQ | TOB07 | CIG01A | Cellulose Filter AFilter | NON-TOBACCO INGREDIENT |
| 1 | Filter | 164 |
|
| mgmg/cigarette | 4article |
| IQ | TOB07 | CIG01A | Cellulose AcetateFilter | NON-TOBACCO INGREDIENT | Cellulose Filter A | 2 | Filtration | 155 |
|
| mg/cigarette | 5article |
| IQ | TOB07 | CIG01A | TriacetinFilter | NON-TOBACCO INGREDIENT | Cellulose Filter A | 2 | Plasticizer | 9 |
|
| mg/cigarette | 6article |
| IQ | TOB07 | CIG01A | FSC Paper BCigarette Paper | NON-TOBACCO INGREDIENT |
| 1 | Wrapper | 50 |
|
| mg/cigarette | 7article |
| IQ | TOB07 | CIG01A | Cellulose PulpCigarette Paper | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Fiber | 30 |
|
| mg/cigarette | 8article |
| IQ | TOB07 | CIG01A | Calcium CarbonateCigarette Paper | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Filler | 15 |
|
| mg/cigarette | 9article |
| IQ | TOB07 | CIG01A | Sodium AlginateCigarette Paper | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Reduced ignition propensity | 2 |
|
| mg/cigarette | 10article |
| IQ | TOB07 | CIG01A | Trisodium CitrateCigarette Paper | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Combustion Modifier | 0.5 |
|
| mg/cigarette | 11article |
| IQ | TOB07 | CIG01A | Cationic StarchCigarette Paper | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Binder | 0.5 |
|
| mg/cigarette | 12article |
| IQ | TOB07 | CIG01A | Seam AdhesiveCigarette Paper | NON-TOBACCO INGREDIENT | FSC Paper B | 2 | Adhesive | 2 |
|
| mgmg/cigarettearticle |
| 13 | IQ | TOB07 | CIG01A | MethylcelluloseTobacco Filler | NON-TOBACCO INGREDIENT | Reconstituted Tobacco | 3 | Binder | 20 |
|
| mgmg/cigarette | 14article |
---|
| IQ | TOB07 | CIG01A | 1,3-Butanediol | Tobacco FillerNON-TOBACCO INGREDIENT | Reconstituted Tobacco | 3 | Humectant | 24 |
|
| mgmg/cigarettearticle |
|
|