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 sub-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  FileFile.   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).

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

...