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

Compare with Current View Page History

« Previous Version 4 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

il.xpt

Row DOMAINSTUDYIDSPTOBIDSTRFIDIUPACNAM CASNOILCATILSPECILGRADEILPURTYILMETHODILCMPLXILMANUFILMANUFNILSPFLTOBTMRF
1ILTOB07CIG01ABurley Tobacco 

8037-19-2

TOBACCO PRODUCTAir

NC 7LCSingle Substance



2ILTOB07CIG01ABright Tobacco

8037-19-2

TOBACCO PRODUCTFlue

CC 1063Single Substance



3ILTOB07CIG01AOriental Tobacco
8037-19-2TOBACCO PRODUCTSun

USDA Nicotiana Collection PI 552747Single Substance



4ILTOB07CIG01AReconstituted Tobacco
?????TOBACCO PRODUCT



Single Substance



5ILTOB07CIG01ABright Tobacco
8037-19-2TOBACCO PRODUCTFlue

CC 1063Single Substance



6ILTOB07CIG01AOriental Tobacco
8037-19-2TOBACCO PRODUCTSun

USDA Nicotiana Collection PI 552747Single Substance



7ILTOB07CIG01ABurley Tobacco
8037-19-2TOBACCO PRODUCTAir

NC 7LCSingle Substance



8ILTOB07CIG01ACocoa Extract

NON TOBACCO PRODUCT



Complex Substance Purchased Flavor House AFLVR1234NoMF5555555
9ILTOB07CIG01AButyric Acidbutanoic acid107-92-6NON TOBACCO PRODUCT

≥99%
Single Substance



10ILTOB07CIG01ACellulose Filter A
-NON TOBACCO PRODUCT



Complex Substance Purchased MFR AFIL789No
11ILTOB07CIG01ACellulose Acetatecellulose acetate9004-35-7 NON TOBACCO PRODUCT



Single Substance



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



Single Substance



13ILTOB07CIG01AFSC Paper B

NON TOBACCO PRODUCT



Complex Substance Purchased MFR BFSC123No
14ILTOB07CIG01ACellulose Pulpcellulose pulp65996-61-4 NON TOBACCO PRODUCT



Single Substance



15ILTOB07CIG01ACalcium Carbonatecalcium carbonate471-34-1 NON TOBACCO PRODUCT



Single Substance



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



Single Substance



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



Single Substance



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



Single Substance



19ILTOB07CIG01ASeam Adhesive
-NON TOBACCO PRODUCT



Complex Substance Purchased MFR CADV123NoMF2345678
20ILTOB07CIG01AMethylcellulose(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



21ILTOB07CIG01A1,3-Butanediol4,4,4-trifluoro-2-methyl-1-phenyl-3-(trifluoromethyl)butane-1,3-diol34844-08-1NON TOBACCO PRODUCT



Single Substance



Dataset Debug Message

There are 17 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.      


$titleHtml

iq.xpt

ROWDOMAINSTUDYID SPTOBID STRFID IQCATIQPARENTIQLEVELIQFUNCTIQTARGETIQLL IGULIQUNIT 
1IQTOB07CIG01ATOBACCO BLENDTOBACCO INGREDIENT
1





IQTOB07CIG01ABurley TobaccoTOBACCO INGREDIENTTOBACCO BLEND2
192117mg/article

IQTOB07CIG01ABright TobaccoTOBACCO INGREDIENTTOBACCO BLEND2
300305295mg/article

IQTOB07CIG01AOriental TobaccoTOBACCO INGREDIENTTOBACCO BLEND2
115117113mg/article

IQTOB07CIG01AReconstituted TobaccoTOBACCO INGREDIENTTOBACCO BLEND2
231233229mg/article

IQTOB07CIG01ATOBACCO FILLERTOBACCO INGREDIENT
1





IQTOB07CIG01ACocoa ExtractNON-TOBACCO INGREDIENTTOBACCO FILLER2Flavor

mg/article

IQTOB07CIG01AButyric AcidNON-TOBACCO INGREDIENTTOBACCO FILLER2Flavor0.5 

mg/article

IQTOB07CIG01ACellulose Filter ANON-TOBACCO INGREDIENT
1Filter164 

mg/article

IQTOB07CIG01ACellulose AcetateNON-TOBACCO INGREDIENTCellulose Filter A2Filtration155 

 mg/article

IQTOB07CIG01ATriacetinNON-TOBACCO INGREDIENTCellulose Filter A2Plasticizer

mg/article

IQTOB07CIG01AFSC Paper BNON-TOBACCO INGREDIENT
1Wrapper50 

mg/article

IQTOB07CIG01ACellulose PulpNON-TOBACCO INGREDIENTFSC Paper B2Fiber30 

mg/article

IQTOB07CIG01ACalcium CarbonateNON-TOBACCO INGREDIENTFSC Paper B2Filler15 

mg/article

IQTOB07CIG01ASodium AlginateNON-TOBACCO INGREDIENTFSC Paper B2Reduced ignition propensity 

mg/article

IQTOB07CIG01ATrisodium CitrateNON-TOBACCO INGREDIENTFSC Paper B2Combustion Modifier0.5 

 mg/article

IQTOB07CIG01ACationic StarchNON-TOBACCO INGREDIENTFSC Paper B2Binder0.5 

 mg/article

IQTOB07CIG01ASeam AdhesiveNON-TOBACCO INGREDIENTFSC Paper B2Adhesive

mg/article

IQTOB07CIG01AMethylcelluloseNON-TOBACCO INGREDIENTReconstituted Tobacco3Binder20 

mg/article

IQTOB07CIG01A1,3-ButanediolNON-TOBACCO INGREDIENTReconstituted Tobacco3Humectant24 

mg/article
$warningHtml






  • No labels