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. 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

STUDYIDSPTOBIDIGDCMPIDTPMFITSPECIFITIGDPLXITCURMTHITSPFL
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

...