Page History

...

The IT example below shows tobacco filler and the 4 types of tobacco of which it is comprised listed as tobacco ingredients (STRFID) 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 is used to indicate whether complex purchased ingredients were made to the applicant's specification. TMRF indicates the Tobacco Master Reference File. Note that there are two varieties of burley tobacco in this tobacco product, thus each is given a unique STRFID 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 STRFID 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

...

• IQPARENT must correspond to a value of STRFID in the same dataset. If parent is null, the ingredient is considered a top-level component and is assigned a value of "1" in IQLEVEL.
• Records describing ingredients that are constituent ingredients of another ingredient/component listed in the dataset will have IQPARENT value equal to the STRFID of that ingredient/component. IQLEVEL will be set to n +1, where n=the parent record's value of IQLEVEL. 
• Every value of STRFID used in the IQ dataset that has an IQLEVEL >1 must must have a matching value of STRFID in either:
  • The In the IT dataset (when IQCAT=TOBACCO INGREDIENT) or,
  • The 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.

...