...
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. For example,. The same Iingredient from different manufacturers would be listed on separate lines.
- Should this domain be IT like for Tobacco Ingredient. We need different Domain letters, since we use TL below.
- I wonder if the Tobacco Master File has the tobacco belends used included , or each type of tobacco incldued.
...
- IS Tobacco Blend the parent row we need.
- Should we include MANUF variabes - if we include ILCOMPLEX. Not sure Reconstituted Tobacco belongs in this table??
- I think we need to make STREFID domain specific. I worry that in HPHC different IDs are used. We could make this a rule. We have to check that HPHC tables are ok then.
- Shoudl we think about IQ has a FA type domian- in struture of a new class of IL.
Dataset wrap |
---|
Dataset wrap |
---|
|
dataset2 |
---|
Row | DOMAIN | STUDYID | SPTOBID | STRFID |
---|
IUPACNAMTOBACCO TYPECASNOILCATILSPECILGRADEILPURTYILMETHODILCMPLXILMANUFILMANUFNILSPFL | TOBTMRF | ILXX | TOB07 | CIG01A | Burley Tobacco |
BlendTOBACCO PRODUCT | Complex Substance | CIGAR MANU A | Y | 1 | IL Tobacco | Burle | 8037-19-2 | TOBACCO PRODUCT | Air | NC 7LC | Single Substance | | Bright Tobacco | CC 1063 | Flue |
|
|
|
3 | IX | TOB07 | CIG01A | Oriental Tobacco | USDA Nicotiana Collection PI 552747 | Sun |
|
|
|
---|
4 | XX |
---|
2 | IL | TOB07 | CIG01A | Reconstituted Tobacco |
|
| CPI | No |
|
---|
Dataset wrap |
---|
|
Dataset2 |
---|
Row | DOMAIN | STUDYID | SPTOBID | STRFID | IUPACNAM | TOBACCO TYPE | CASNO | ILCAT | ILSPEC | ILGRADE | ILPURTY | ILMETHOD | ILCMPLX | ILMANUF | ILMANUFN | ILSPFL | TOBTMRF |
---|
1 | Bright | 8037-19-2 | TOBACCO PRODUCT | Flue | CC 1063 | Single Substance | 3 | IL | TOB07 | CIG01A | Tobacco | Orienta | 8037-19-2 | TOBACCO PRODUCT | Sun | USDA Nicotiana Collection PI 552747 | Single Substance | 4 | IL | TOB07 | CIG01A | Reconstituted Tobacco |
|
| ????? | TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
| 52 | IL | TOB07 | CIG01A | Bright Tobacco |
|
| 8037-19-2 | TOBACCO PRODUCT | Flue |
|
| CC 1063 | Single Substance |
|
|
|
| 63 | IL | TOB07 | CIG01A | Oriental Tobacco |
|
| 8037-19-2 | TOBACCO PRODUCT | Sun |
|
| USDA Nicotiana Collection PI 552747 | Single Substance |
|
|
|
| 74 | IL | TOB07 | CIG01A | Burley Tobacco |
|
| 8037-19-2 | TOBACCO PRODUCT | Air |
|
| NC 7LC | Single Substance |
|
|
|
| 85 | IL | TOB07 | CIG01A | Cocoa Extract |
|
|
| NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | Flavor House A | FLVR1234 | No | MF5555555 |
---|
96 | IL | TOB07 | CIG01A | Butyric Acid | butanoic acid |
| 107-92-6 | NON TOBACCO PRODUCT |
|
| ≥99% |
| Single Substance |
|
|
|
|
---|
107 | IL | TOB07 | CIG01A | Cellulose Filter A |
|
| - | NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | MFR A | FIL789 | No |
|
---|
118 | IL | TOB07 | CIG01A | Cellulose Acetate | cellulose acetate |
| 9004-35-7 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
|
---|
129 | IL | TOB07 | CIG01A | Triacetin | 1,3-diacetyloxypropan-2-yl acetate |
| 102-76-1 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
|
---|
1310 | IL | TOB07 | CIG01A | FSC Paper B |
|
|
| NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | MFR B | FSC123 | No |
|
---|
1411 | IL | TOB07 | CIG01A | Cellulose Pulp | cellulose pulp |
| 65996-61-4 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
|
---|
1512 | IL | TOB07 | CIG01A | Calcium Carbonate | calcium carbonate |
| 471-34-1 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
|
---|
1613 | IL | TOB07 | CIG01A | Sodium Alginate | sodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate |
| 9005-38-3 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
|
---|
1714 | IL | TOB07 | CIG01A | Trisodium Citrate | trisodium;2-hydroxypropane-1,2,3-tricarboxylate |
| 6132-04-3 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
|
---|
1815 | IL | TOB07 | CIG01A | Cationic Starch | starch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride |
| 56780-58-6 | NON TOBACCO PRODUCT |
|
|
|
| Single Substance |
|
|
|
|
---|
1916 | IL | TOB07 | CIG01A | Seam Adhesive |
|
| - | NON TOBACCO PRODUCT |
|
|
|
| Complex Substance Purchased | MFR C | ADV123 | No | MF2345678 |
---|
2017 | 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 |
|
|
|
|
---|
2118 | 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 |
|
|
|
|
---|
|
|
...