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 (INGCMPID) for the Tobacco Product CIG01A (SPTOBID). The variable ITSPECIF shows the specification (variety) of the first three tobaccos. ITCAT is used to indicate that Reconstituted Tobacco is a complex ingredient. (it has two more components) ITCURMTH indicates the cure method. ITCPISP ITSPFL is used to indicate whether complex purchased 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 INGCMPID 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 INGCMPID 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

STUDYIDSPTOBIDINGCMPIDTPMFITSPECIFITCATITCURMTHITCPISPTPMFITSPFL
1ITTOB07CIG01ATobacco Filler

COMPLEX INGREDIENT

2ITTOB07CIG01ABurley TobaccoMF5555555NC 7LCSINGLE INGREDIENTAirMF5555555
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 INGCMPID. Where applicable, IUPAC name and CAS number are listed (IUPACNAM and CASNO, respectively). INCAT is used to indicate whether an ingredient is a single chemical substance single  ingredient or a complex purchased ingredient. INSPFL indicates whether complex purchased 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
RowDOMAINSTUDYIDSPTOBIDINGCMPIDIUPACNAMCASNOINCATINSPYNINSPFLINGRADEINPURTYINMANUFINMANUFNTPMF
1INTOB07CIG01ACocoa Extract

COMPLEX PURCHASED INGREDIENTN

Flavor House AFLVR1234MF5555555
2INTOB07CIG01AButyric Acidbutanoic acid107-92-6SINGLE CHEMICAL SUBSTANCEINGREDIENT
Food≥99%


3INTOB07CIG01ACellulose Filter A
-COMPLEX PURCHASED INGREDIENTN

MFR AFIL789
4INTOB07CIG01ACellulose Acetatecellulose acetate9004-35-7SINGLE CHEMICAL SUBSTANCEINGREDIENT





5INTOB07CIG01ATriacetin1,3-diacetyloxypropan-2-yl acetate102-76-1SINGLE CHEMICAL SUBSTANCEINGREDIENT





6INTOB07CIG01AFSC Paper B

COMPLEX PURCHASED INGREDIENTN

MFR BFSC123
7INTOB07CIG01ACellulose Pulpcellulose pulp65996-61-4SINGLE CHEMICAL SUBSTANCEINGREDIENT





8INTOB07CIG01ACalcium Carbonatecalcium carbonate471-34-1SINGLE CHEMICAL SUBSTANCEINGREDIENT





9INTOB07CIG01ASodium Alginatesodium;3,4,5,6-tetrahydroxyoxane-2-carboxylate9005-38-3SINGLE CHEMICAL SUBSTANCEINGREDIENT





10INTOB07CIG01ATrisodium Citratetrisodium;2-hydroxypropane-1,2,3-tricarboxylate6132-04-3SINGLE CHEMICAL SUBSTANCEINGREDIENT





11INTOB07CIG01ACationic Starchstarch, 2-hydroxy-3-(trimethylammonio)propyl ether, chloride56780-58-6SINGLE CHEMICAL SUBSTANCEINGREDIENT





12INTOB07CIG01ASeam Adhesive
-COMPLEX PURCHASED INGREDIENTN

MFR CADV123MF2345678
13INTOB07CIG01AMethylcellulose(5R)-2,3,4-trimethoxy-6-(methoxymethyl)-5-[(2S)-3,4,5-trimethoxy-6-(methoxymethyl)oxan-2-yl]oxyoxane9004-67-5SINGLE CHEMICAL SUBSTANCEINGREDIENT





14INTOB07CIG01A1,3-Butanediol4,4,4-trifluoro-2-methyl-1-phenyl-3-(trifluoromethyl)butane-1,3-diol34844-08-1SINGLE CHEMICAL SUBSTANCEINGREDIENT





Finally, the IQ domain is used to represent the quantity (target, minimum and maximum) of each ingredient identified in INGCMPID that the product (SPTOBID) is designed to contain, with the units for these values represented in IQUNIT. The function of each ingredient is described in IQFUNCT. Ingredients that appear in more than one component of the tobacco product are quantified separately for each component. IQPARENT and IQLEVEL are used to identify the component/ingredient of which the ingredient in a record is a constituent component, and and at which level in the overall hierarchy the constituent ingredient appears. The following implementation rules apply:

...