...
| Dataset wrap |
|---|
|
| Option 1 of Steve H's suggestion of combining our previous product identifiers and product descriptors into a single dataset:
| Rowcaps |
|---|
| Rows 1-4: | Show the records for a tobacco product given SPTOBID of CIG01a. | | Rows 3-4: | Show the tobacco product is a filtered, combusted type of cigarette. | |
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPTOBID | TOSEQ | TOPARMCD | TOPARM | TOVAL | TOVALU |
|---|
| 1 | TOB07 | TO | CIG01a | 1 | TBPRDCAT | Tobacco Product Category | Cigarette |
| | 2 | TOB07 | TO | CIG01a | 2 | TBPRSCAT | Tobacco Product Subcategory | Filtered, Combusted |
| | 3 | TOB07 | TO | CIG01a | 3 | MANUF | Manufacturer | Joes Cigs USA |
| | 4 | TOB07 | TO | CIG01a | 4 | TRADENAM | Trade Name | Treetop Menthol King Size |
| | 5 | TOB07 | TO | CIG01a | 5 | PACKTYP | Package Type | HARD PACK |
| | 6 | TOB07 | TO | CIG01a | 6 | PRDQUAN | Product Quantity | 20 | CIGARETTE | | 7 | TOB07 | TO | CIG01a | 7 | LENGTH | Length | 86.0 | mm | | 8 | TOB07 | TO | CIG01a | 8 | CIRCUMF | Circumference | 26.0 | mm | | 9 | TOB07 | TO | CIG01a | 9 | VENTLTN | Ventilation | 10.0 | % | | 10 | TOB07 | TO | CIG01a | 10 | CHARFLAV | Characterizing Flavor | MENTHOL |
|
|
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPTOBID | DPSEQ | DPTESTCD | DPTEST | DPCAT | DPSCAT | DPORRES | DPORRESU | DPSTRESC | DPSTRESN | DPSTRESU | DPCOLSRT |
|---|
| 1 | TOB07 | DP | CIG01a | | TBPRDCAT | Tobacco Product Category |
|
| Cigarette |
| Cigarette |
|
|
| | 2 | TOB07 | DP | CIG01a | 2 | TBPRSCAT | Tobacco Product Subcategory |
|
| Filtered, Combusted |
| Filtered, Combusted |
|
|
| | 3 | TOB07 | DP | CIG01a | 3 | MANUF | Manufacturer |
|
| Joes Cigs USA |
| Joes Cigs USA |
|
|
| | 4 | TOB07 | DP | CIG01a | 4 | TRADENAM | Trade Name |
|
| Treetop Methol King Size |
| Treetop Methol King Size |
|
|
| | 5 | TOB07 | DP | CIG01a | 5 | PACKTYP | Package Type |
|
| HARD PACK |
| HARD PACK |
|
|
| | 6 | TOB07 | DP | CIG01a | 6 | PRDQUAN | Product Quantity |
|
| 20 | CIGARETTE | 20 | 20 | CIGARETTE |
| | 7 | TOB07 | DP | CIG01a | 7 | LENGTH | Length |
|
| 86.0 | mm | 86.0 | 86.0 | mm |
| | 8 | TOB07 | DP | CIG01a | 8 | CIRCUMF | Circumference |
|
| 26.0 | mm | 26.0 | 26.0 | mm |
| | 9 | TOB07 | DP | CIG01a | 9 | VENTLTN | Ventilation |
|
| 10.0 | % | 10.0 | 10.0 | % |
| | 10 | TOB07 | DP | CIG01a | 10 | CHARFLAV | Characterizing Flavor |
|
| MENTHOL |
| MENTHOL |
|
|
| | 11 | TOB07 | DP | CIG01a | 11 | HTSOURCE | Heat Source |
|
| xxx |
| xxx |
|
|
|
|
|
OPtion 2:
| Dataset wrap |
|---|
|
| Option 1 of Steve H's suggestion of combining our previous product identifiers and product descriptors into a single dataset:
| Rowcaps |
|---|
| Rows 1-4: | Show the records for a tobacco product given SPTOBID of CIG01a. | | Rows 3-4: | Show the tobacco product is a filtered, combusted type of cigarette. | |
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPTOBID | TOSEQ | TOPARMCD | TOPARM | TOVAL | TOVALU |
|---|
| 1 | TOB07 | TO | CIG01a | 1 | TBPRDCAT | Tobacco Product Category | Cigarette |
| | 2 | TOB07 | TO | CIG01a | 2 | TBPRSCAT | Tobacco Product Subcategory | Filtered, Combusted |
| | 3 | TOB07 | TO | CIG01a | 3 | MANUF | Manufacturer | Joes Cigs USA |
| | 4 | TOB07 | TO | CIG01a | 4 | TRADENAM | Trade Name | Treetop Menthol King Size |
| | 5 | TOB07 | TO | CIG01a | 5 | PACKTYP | Package Type | HARD PACK |
| | 6 | TOB07 | TO | CIG01a | 6 | PRDQUAN | Product Quantity | 20 | CIGARETTE | | 7 | TOB07 | TO | CIG01a | 7 | LENGTH | Length | 86.0 | mm | | 8 | TOB07 | TO | CIG01a | 8 | CIRCUMF | Circumference | 26.0 | mm | | 9 | TOB07 | TO | CIG01a | 9 | VENTLTN | Ventilation | 10.0 | % | | 10 | TOB07 | TO | CIG01a | 10 | CHARFLAV | Characterizing Flavor | MENTHOL |
| | 11 | TOB07 | TO | CIG01a | 11 | HTSOURCE | Heat Source | xxx |
|
| Row | STUDYID | DOMAIN | SPTOBID | DPSEQ | DPTESTCD | DPTEST | DPCAT | DPSCAT | DPORRES | DPORRESU | DPSTRESC | DPSTRESN | DPSTRESU | DPCOLSRT |
|---|
| 1 | TOB07 | DP | CIG01a | | TBPRDCAT | Tobacco Product Category |
|
| Cigarette |
| Cigarette |
|
|
| | 2 | TOB07 | DP | CIG01a | 2 | TBPRSCAT | Tobacco Product Subcategory |
|
| Filtered, Combusted |
| Filtered, Combusted |
|
|
| | 3 | TOB07 | DP | CIG01a | 3 | MANUF | Manufacturer |
|
| Joes Cigs USA |
| Joes Cigs USA |
|
|
| | 4 | TOB07 | DP | CIG01a | 4 | TRADENAM | Trade Name |
|
| Treetop Methol King Size |
| Treetop Methol King Size |
|
|
| | 5 | TOB07 | DP | CIG01a | 5 | PACKTYP | Package Type |
|
| HARD PACK |
| HARD PACK |
|
|
| | 6 | TOB07 | DP | CIG01a | 6 | PRDQUAN | Product Quantity |
|
| 20 | CIGARETTE | 20 | 20 | CIGARETTE |
| | 7 | TOB07 | DP | CIG01a | 7 | LENGTH | Length |
|
| 86.0 | mm | 86.0 | 86.0 | mm |
| | 8 | TOB07 | DP | CIG01a | 8 | CIRCUMF | Circumference |
|
| 26.0 | mm | 26.0 | 26.0 | mm |
| | 9 | TOB07 | DP | CIG01a | 9 | VENTLTN | Ventilation |
|
| 10.0 | % | 10.0 | 10.0 | % |
| | 10 | TOB07 | DP | CIG01a | 10 | CHARFLAV | Characterizing Flavor |
|
| MENTHOL |
| MENTHOL |
|
|
| | 11 | TOB07 | DP | CIG01a | 11 | HTSOURCE | Heat Source |
|
| xxx |
| xxx |
|
|
|
|
|
The Tobacco Product Design Parameters (DP) is (similar to the Device Properties (DO) domain) represents properties of the tobacco product as used. This is a findings domain and defines important characteristics of a product that the sponsor manufacturer (tobacco researcher) wishes to include in the submission but do not form part of the unique sponsor-defined identification of the product. Each property is identified using controlled terminology and is stored in TTTESTCD/TTTEST.
...