Versions Compared

Key

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

The IT example below shows tobacco filler and the types of tobacco of which it is composed, each 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 the Tobacco Filler and the Reconstituted Tobacco are complex ingredients (they both have two or more sub-components). The details of which single tobacco ingredients compose these complex ingredients is made explicit in the IQ dataset example further down). 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).

...

The IN dataset example below shows the list of non-tobacco ingredients

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-112
Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-106
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). 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 File number complete the dataset.

Dataset wrap
NameIN
Dataset2
RowDOMAINSTUDYIDSPTOBIDIGDCMPIDINMANUFINMANUFNTPMFIUPACNAMCASNOINIGDPLXINSPFLINGRADEINPURTY
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



9004-67-5SINGLE INGREDIENT


14INTOB07CIG01A1,3-Butanediol


Butane-1,3-diol34844-08-1SINGLE INGREDIENT


Finally, the IQ domain is used to represent the quantity (target, minimum and maximum) of each ingredient identified in IGDCMPID 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 identifies the ingredient or component of which a component or complex ingredient composed of the sub-ingredientcomponents/sub-component ingredients shown in IDGCMPID is a partIDGCMPID. IQLEVEL is used to identify at what level

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-240
in the overall hierarchy the that sub-component/ sub-ingredient appears.
The following implementation rules apply:

...

  • IQPARENT must correspond to a value of IGDCMPID in the same dataset. If parent is null, the ingredient is considered a top-level component and is assigned a an IQLEVEL value of "1" in IQLEVEL.
  • Records describing sub-components/ingredients that compose a parent component listed in the dataset will have IQPARENT value equal to the IGDCMPID of that parent component. IQLEVEL will be set to n +1, where n=the parent record's value of IQLEVEL
  • Every value of IGDCMPID used in the IQ dataset must have a matching value of IGDCMPID:
    • In the IT dataset (when IQCAT=TOBACCO INGREDIENT) or,
    • In the IN dataset (when IQCAT=NON-TOBACCO INGREDIENT)

Therefore, IQCAT is required to relate ingredient quantity records in IQ to the associated ingredient attributes described in either IT or IN.

The use of IQPARENT and IQLEVEL help make explicit the relationship between complex ingredients (or components ) and the sub-components/ingredients of which they are composed, and can assist when totaling the quantities of an ingredient that appears in multiple components of a tobacco product.
 
The concept map below illustrates the representation of the hierarchical relationships between a component and its sub-component components/ingredients in the IQ domain structure. 

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-239

...