Versions Compared

Key

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

...

The IT example below shows tobacco filler and the 4 types of tobacco of which it is comprised listed as tobacco ingredients (IGDCMPID) for the Tobacco Product CIG01A (SPTOBID). The variable ITSPECIF shows the specification (variety) of the first three tobaccos. ITCAT ITIGDPLX is used to indicate that Reconstituted Tobacco is a complex ingredient. (it has two more components) ITCURMTH indicates the cure method. ITSPFL is used to indicate whether complex ingredients were made to the applicant's specification. TPMF indicates the Tobacco Product Master File. Note that there are two varieties of burley tobacco in this tobacco product, thus each is given a unique IGDCMPID value (Burley Tobacco and Burley Tobacco 2).
Note that following the team discussion on 12/13/22, we have added tobacco filler to the IT dataset below, so that all values of IGDCMPID in the IQ dataset have a match in IT (just as the top-level non-tobacco ingredients "FSC Paper B" and "Cellulose Filter A" are listed in the IN dataset). This allows for validation checks that every ingredient listed in the IT and IN datasets is quantified in the IQ data and vice versa. See note 4 in the comments section at the bottom of the page for more info

Dataset wrap
Nameit
Dataset2

Row

DOMAIN

STUDYIDSPTOBIDIGDCMPIDTPMFITSPECIFITCATITIGDPLXITCURMTHITSPFL
1ITTOB07CIG01ATobacco Filler

COMPLEX INGREDIENT

2ITTOB07CIG01ABurley TobaccoMF5555555NC 7LCSINGLE INGREDIENTAir
3ITTOB07CIG01ABright Tobacco
CC 1063SINGLE INGREDIENTFlue
4ITTOB07CIG01AOriental Tobacco
USDA Nicotiana Collection PI 552747SINGLE INGREDIENTSun
5ITTOB07CIG01AReconstituted Tobacco

COMPLEX INGREDIENT
N
6ITTOB07CIG01ABurley Tobacco 2
KT215LCSINGLE INGREDIENTAir

The IN dataset example below shows the list of non-tobacco ingredients used in the tobacco product identified as CIG01A. Each unique ingredient is listed in IGDCMPID. Where applicable, IUPAC name and CAS number are listed (IUPACNAM and CASNO, respectively). INCAT INIGDPLX is used to indicate whether an ingredient is a single ingredient or a complex ingredient. INSPFL indicates whether complex ingredients were made to the applicant's specification. Grade, purity, manufacturer name and ID number, and the Tobacco Product Master File number complete the dataset.

Dataset wrap
NameIN
Dataset2
RowDOMAINSTUDYIDSPTOBIDIGDCMPIDINMANUFINMANUFNTPMFIUPACNAMCASNOINCATINIGDPLXINSPFLINGRADEINPURTY
1INTOB07CIG01ACocoa ExtractFlavor House AFLVR1234MF5555555

COMPLEX INGREDIENTN

2INTOB07CIG01AButyric Acid


butanoic acid107-92-6SINGLE INGREDIENT
Food≥99%
3INTOB07CIG01ACellulose Filter AMFR AFIL789

-COMPLEX INGREDIENTN

4INTOB07CIG01ACellulose Acetate


cellulose acetate9004-35-7SINGLE INGREDIENT


5INTOB07CIG01ATriacetin


1,3-diacetyloxypropan-2-yl acetate102-76-1SINGLE INGREDIENT


6INTOB07CIG01AFSC Paper BMFR BFSC123


COMPLEX INGREDIENTN

7INTOB07CIG01ACellulose Pulp


cellulose pulp65996-61-4SINGLE INGREDIENT


8INTOB07CIG01ACalcium Carbonate


calcium carbonate471-34-1SINGLE INGREDIENT


9INTOB07CIG01ASodium Alginate


sodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate9005-38-3SINGLE INGREDIENT


10INTOB07CIG01ATrisodium Citrate


trisodium;2-hydroxypropane-1,2,3-tricarboxylate6132-04-3SINGLE INGREDIENT


11INTOB07CIG01ACationic Starch


starch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride56780-58-6SINGLE INGREDIENT


12INTOB07CIG01ASeam AdhesiveMFR CADV123MF2345678
-COMPLEX INGREDIENTN

13INTOB07CIG01AMethylcellulose


(5R)-2,3,4-trimethoxy-6-(methoxymethyl)-5-[(2S)-3,4,5-trimethoxy-6-(methoxymethyl)oxan-2-yl]oxyoxane9004-67-5SINGLE INGREDIENT


14INTOB07CIG01A1,3-Butanediol


4,4,4-trifluoro-2-methyl-1-phenyl-3-(trifluoromethyl)butane-1,3-diol34844-08-1SINGLE INGREDIENT


...