You are viewing an old version of this page. View the current version .
Compare with Current
View Page History
« Previous
Version 8
Next »
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.
il.xpt
$titleHtml
il.xpt
Row DOMAIN STUDYID SPTOBID STRFID IUPACNAM TOBACCO TYPE CASNO ILCAT ILSPEC ILGRADE ILPURTY ILMETHOD ILCMPLX ILMANUF ILMANUFN ILSPFL TOBTMRF IL TOB07 CIG01A Tobacco Blend
TOBACCO PRODUCT Complex Substance CIGAR MANU A Y 1 IL TOB07 CIG01A Tobacco Burle 8037-19-2
TOBACCO PRODUCT Air NC 7LC Single Substance 2 IL TOB07 CIG01A Tobacco 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 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 8 IL TOB07 CIG01A Cocoa Extract NON TOBACCO PRODUCT Complex Substance Purchased Flavor House A FLVR1234 No MF5555555 9 IL TOB07 CIG01A Butyric Acid butanoic acid 107-92-6 NON TOBACCO PRODUCT ≥99% Single Substance 10 IL TOB07 CIG01A Cellulose Filter A - NON TOBACCO PRODUCT Complex Substance Purchased MFR A FIL789 No 11 IL TOB07 CIG01A Cellulose Acetate cellulose acetate 9004-35-7 NON TOBACCO PRODUCT Single Substance 12 IL TOB07 CIG01A Triacetin 1,3-diacetyloxypropan-2-yl acetate 102-76-1 NON TOBACCO PRODUCT Single Substance 13 IL TOB07 CIG01A FSC Paper B NON TOBACCO PRODUCT Complex Substance Purchased MFR B FSC123 No 14 IL TOB07 CIG01A Cellulose Pulp cellulose pulp 65996-61-4 NON TOBACCO PRODUCT Single Substance 15 IL TOB07 CIG01A Calcium Carbonate calcium carbonate 471-34-1 NON TOBACCO PRODUCT Single Substance 16 IL TOB07 CIG01A Sodium Alginate sodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate 9005-38-3 NON TOBACCO PRODUCT Single Substance 17 IL TOB07 CIG01A Trisodium Citrate trisodium;2-hydroxypropane-1,2,3-tricarboxylate 6132-04-3 NON TOBACCO PRODUCT Single Substance 18 IL TOB07 CIG01A Cationic Starch starch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride 56780-58-6 NON TOBACCO PRODUCT Single Substance 19 IL TOB07 CIG01A Seam Adhesive - NON TOBACCO PRODUCT Complex Substance Purchased MFR C ADV123 No MF2345678 20 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 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
$warningHtml
.
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.
iq.xpt
iq.xpt
iq.xpt
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
$warningHtml