You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 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. For example,. The same Iingredient from different manufacturers would be listed on separate lines.  


  1. Should  this domain be IT  like for Tobacco Ingredient. We need different Domain letters, since we use IL below. We cannot use TL  
  2.  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. 
  3. Should we include MANUF variabes - if we include  ILCOMPLEX.  Not sure  Reconstituted Tobacco belongs in this table?? 
  4. 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. 
  5. Shoudl we think about IQ has a FA type domian- in struture of a new class of IL. 


$titleHtml

xx.xpt

Row DOMAINSTUDYIDSPTOBIDSTRFIDILSPECIFILCURMTHILCMPLXILSPFLRTOBMF




TOBACCO BLENDXXXXXXXxXX
1XXTOB07CIG01ABurley TobaccoNC 7LCAir

MF5555555
2XXTOB07CIG01ABright TobaccoCC 1063Flue


3IXTOB07CIG01AOriental TobaccoUSDA Nicotiana Collection PI 552747Sun


4XXTOB07CIG01AReconstituted Tobacco

CPINo
$warningHtml




   

il.xpt

il.xpt

Row DOMAINSTUDYIDSPTOBIDSTRFIDIUPACNAMTOBACCO TYPECASNOILCATILSPECILGRADEILPURTYILMETHODILCMPLXILMANUFILMANUFNILSPFLTOBTMRF
1ILTOB07CIG01AReconstituted Tobacco

?????TOBACCO PRODUCT



Single Substance



2ILTOB07CIG01ABright Tobacco

8037-19-2TOBACCO PRODUCTFlue

CC 1063Single Substance



3ILTOB07CIG01AOriental Tobacco

8037-19-2TOBACCO PRODUCTSun

USDA Nicotiana Collection PI 552747Single Substance



4ILTOB07CIG01ABurley Tobacco

8037-19-2TOBACCO PRODUCTAir

NC 7LCSingle Substance



5ILTOB07CIG01ACocoa Extract


NON TOBACCO PRODUCT



Complex Substance Purchased Flavor House AFLVR1234NoMF5555555
6ILTOB07CIG01AButyric Acidbutanoic acid
107-92-6NON TOBACCO PRODUCT

≥99%
Single Substance



7ILTOB07CIG01ACellulose Filter A

-NON TOBACCO PRODUCT



Complex Substance Purchased MFR AFIL789No
8ILTOB07CIG01ACellulose Acetatecellulose acetate
9004-35-7 NON TOBACCO PRODUCT



Single Substance



9ILTOB07CIG01ATriacetin1,3-diacetyloxypropan-2-yl acetate
102-76-1 NON TOBACCO PRODUCT



Single Substance



10ILTOB07CIG01AFSC Paper B


NON TOBACCO PRODUCT



Complex Substance Purchased MFR BFSC123No
11ILTOB07CIG01ACellulose Pulpcellulose pulp
65996-61-4 NON TOBACCO PRODUCT



Single Substance



12ILTOB07CIG01ACalcium Carbonatecalcium carbonate
471-34-1 NON TOBACCO PRODUCT



Single Substance



13ILTOB07CIG01ASodium Alginatesodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate
9005-38-3NON TOBACCO PRODUCT



Single Substance



14ILTOB07CIG01ATrisodium Citratetrisodium;2-hydroxypropane-1,2,3-tricarboxylate
6132-04-3NON TOBACCO PRODUCT



Single Substance



15ILTOB07CIG01ACationic Starchstarch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride
56780-58-6 NON TOBACCO PRODUCT



Single Substance



16ILTOB07CIG01ASeam Adhesive

-NON TOBACCO PRODUCT



Complex Substance Purchased MFR CADV123NoMF2345678
17ILTOB07CIG01AMethylcellulose(5R)-2,3,4-trimethoxy-6-(methoxymethyl)-5-[(2S)-3,4,5-trimethoxy-6-(methoxymethyl)oxan-2-yl]oxyoxane
9004-67-5NON TOBACCO PRODUCT



Single Substance



18ILTOB07CIG01A1,3-Butanediol4,4,4-trifluoro-2-methyl-1-phenyl-3-(trifluoromethyl)butane-1,3-diol
34844-08-1NON TOBACCO PRODUCT



Single Substance



Dataset Debug Message

There are ten leading, trailing, or non-breaking spaces in the dataset.



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

RowDOMAINSTUDYIDSPTOBIDSTRFIDIQCATIQPARENTIQLEVELIQFUNCTIQTARGIGMINIQMAXIQUNIT
1IQTOB07CIG01ATobacco FillerTOBACCO INGREDIENT
1
672.5661.3683.7mg/cigarette
2IQTOB07CIG01ABurley TobaccoTOBACCO INGREDIENTTobacco Filler2
191721mg/cigarette
3IQTOB07CIG01ABright TobaccoTOBACCO INGREDIENTTobacco Filler2
300295305mg/cigarette
4IQTOB07CIG01AOriental TobaccoTOBACCO INGREDIENTTobacco Filler2
115113117mg/cigarette
5IQTOB07CIG01AReconstituted TobaccoTOBACCO INGREDIENTTobacco Filler2
231229233mg/cigarette
6IQTOB07CIG01AMethylcelluloseNON-TOBACCO INGREDIENTReconstituted Tobacco3Binder201921mg/cigarette
7IQTOB07CIG01A1,3-ButanediolNON-TOBACCO INGREDIENTReconstituted Tobacco3Humectant242325mg/cigarette
8IQTOB07CIG01ACocoa ExtractNON-TOBACCO INGREDIENTTobacco Filler2Flavor76.757.25mg/cigarette
9IQTOB07CIG01AButyric AcidNON-TOBACCO INGREDIENTTobacco Filler2Flavor0.50.550.45mg/cigarette
10IQTOB07CIG01ACellulose Filter ANON-TOBACCO INGREDIENT
1Filter164163165mg/cigarette
11IQTOB07CIG01ACellulose AcetateNON-TOBACCO INGREDIENTCellulose Filter A2Filtration155154156mg/cigarette
12IQTOB07CIG01ATriacetinNON-TOBACCO INGREDIENTCellulose Filter A2Plasticizer9810mg/cigarette
13IQTOB07CIG01AFSC Paper BNON-TOBACCO INGREDIENT
1Cigarette Paper (Wrapper)504951mg/cigarette
14IQTOB07CIG01ACellulose PulpNON-TOBACCO INGREDIENTFSC Paper B2Fiber302931mg/cigarette
15IQTOB07CIG01ACalcium CarbonateNON-TOBACCO INGREDIENTFSC Paper B2Filler151416mg/cigarette
16IQTOB07CIG01ASodium AlginateNON-TOBACCO INGREDIENTFSC Paper B2Reduced ignition propensity21.752.25mg/cigarette
17IQTOB07CIG01ATrisodium CitrateNON-TOBACCO INGREDIENTFSC Paper B2Combustion Modifier0.50.450.55mg/cigarette
18IQTOB07CIG01ACationic StarchNON-TOBACCO INGREDIENTFSC Paper B2Binder0.50.450.55mg/cigarette
19IQTOB07CIG01ASeam AdhesiveNON-TOBACCO INGREDIENTFSC Paper B2Adhesive21.752.25mg/cigarette
$warningHtml






  • No labels