Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 TL below. 
  2.  I wonder if the Tobacco Master File has the tobacco belends used included , or each type of tobacco incldued. 

...

  1. IS Tobacco Blend the parent row we need. 
  2. Should we include MANUF variabes - if we include  ILCOMPLEX.  Not sure  Reconstituted Tobacco belongs in this table?? 
  3. 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. 
  4. Shoudl we think about IQ has a FA type domian- in struture of a new class of IL. 


dataset2IL
Dataset wrap
Dataset wrap
NameIL
Row DOMAINSTUDYIDSPTOBIDSTRFID
IUPACNAM
ILSPECIF
TOBACCO TYPE
ILCURMTH
CASNO
ILCMPLX
ILCAT
ILSPFL
ILSPEC
RTOBMF
ILGRADE




TOBACCO BLEND
ILPURTY
XX
ILMETHOD
XX
ILCMPLX
XX
ILMANUF
Xx
ILMANUFN
XX
ILSPFL
1
TOBTMRF
XXTOB07CIG01ABurley Tobacco
Blend
TOBACCO PRODUCTComplex SubstanceCIGAR MANU A Y1
NC 7LCAir

MF5555555
2XX
IL
TOB07CIG01A
 Tobacco   Burle

8037-19-2

TOBACCO PRODUCTAirNC 7LCSingle Substance
Bright TobaccoCC 1063Flue


3IXTOB07CIG01AOriental TobaccoUSDA Nicotiana Collection PI 552747Sun


4XX
2IL
TOB07CIG01AReconstituted Tobacco

CPINo


   

Dataset wrap
NameIL
Dataset2
Row DOMAINSTUDYIDSPTOBIDSTRFIDIUPACNAMTOBACCO TYPECASNOILCATILSPECILGRADEILPURTYILMETHODILCMPLXILMANUFILMANUFNILSPFLTOBTMRF
1Bright

8037-19-2

TOBACCO PRODUCTFlueCC 1063Single Substance3ILTOB07CIG01ATobaccoOrienta8037-19-2TOBACCO PRODUCTSunUSDA Nicotiana Collection PI 552747Single Substance4ILTOB07CIG01AReconstituted Tobacco

?????TOBACCO PRODUCT



Single Substance



52ILTOB07CIG01ABright Tobacco

8037-19-2TOBACCO PRODUCTFlue

CC 1063Single Substance



63ILTOB07CIG01AOriental Tobacco

8037-19-2TOBACCO PRODUCTSun

USDA Nicotiana Collection PI 552747Single Substance



74ILTOB07CIG01ABurley Tobacco

8037-19-2TOBACCO PRODUCTAir

NC 7LCSingle Substance



85ILTOB07CIG01ACocoa Extract


NON TOBACCO PRODUCT



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

≥99%
Single Substance



107ILTOB07CIG01ACellulose Filter A

-NON TOBACCO PRODUCT



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



Single Substance



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



Single Substance



1310ILTOB07CIG01AFSC Paper B


NON TOBACCO PRODUCT



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



Single Substance



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



Single Substance



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



Single Substance



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



Single Substance



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



Single Substance



1916ILTOB07CIG01ASeam Adhesive

-NON TOBACCO PRODUCT



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



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



Single Substance





...