Page History

...

SPTOBID... ?SPTOBID - should it be SPTOBID for Sponsor Tobacco Product Identifier???

Dataset wrap

Name	to

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	DPORRES	DPORRESU	DPSTRESC	DPSTRESN	DPSTRESU
1	TOB07	DP	CIG01a	1	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.

Dataset wrap

Name	dp

Rowcaps

Rows 1-4:	Show the package type is a hard pack that each contain 20 cigarettes that are 86.0 mm long and 26.0 mm in circumference.
Row 5:	Shows the ventilation flow expressed as a percentage. Ventilation is the aspiration of atmospheric air in an unlit cigarette. (ISO 9512:2019) - 1
Row 6:	Shows the characterizing flavor is menthol for this package of cigarettes.
Row 7:	Shows the heat source is xxx.

Dataset2

Row	STUDYID	DOMAIN	SPTOBID	DPSEQ	DPTESTCD	DPTEST	DPCAT	DPSCAT	DPORRES	DPORRESU	DPSTRESC	DPSTRESN	DPSTRESU	DPCOLSRT
1	TOB07	DP	CIG01a	1	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	59	VENTLTN	Ventilation			10.0	%	10.0	10.0	%
10	TOB07	DP	CIG01a	610	CHARFLAV	Characterizing Flavor			MENTHOL		MENTHOL
11	TOB07	DP	CIG01a	711	HTSOURCE	Heat Source			xxx		xxx
12	TOB07	DP	CIG01a	12	LENGTH	Length	DESIGN PARAMETER SPECIFICATION	mm						TARGET
13	TOB07	DP	CIG01a	13	LENGTH	Length	DESIGN PARAMETER SPECIFICATION	mm						MINIMUM
14	TOB07	DP	CIG01a	14	LENGTH	Length	DESIGN PARAMETER SPECIFICATION	mm						MAXIMUM
15	TOB07	DP	CIG01a	15	Cigarette circumference or diameter ²		DESIGN PARAMETER SPECIFICATION	mm						TARGET
16	TOB07	DP	CIG01a	16	Cigarette circumference or diameter ²		DESIGN PARAMETER SPECIFICATION	mm						MINIMUM
17	TOB07	DP	CIG01a	17	Cigarette circumference or diameter ²		DESIGN PARAMETER SPECIFICATION	mm						MAXIMUM
18	TOB07	DP	CIG01a	18	Tobacco Filler mass		DESIGN PARAMETER SPECIFICATION	mg						TARGET
19	TOB07	DP	CIG01a	19	Tobacco Filler mass		DESIGN PARAMETER SPECIFICATION	mg						MINIMUM
20	TOB07	DP	CIG01a	20	Tobacco Filler mass		DESIGN PARAMETER SPECIFICATION	mg						MAXIMUM
21	TOB07	DP	CIG01a	21	Tobacco moisture or Oven Volatiles		DESIGN PARAMETER SPECIFICATION	%						TARGET
22	TOB07	DP	CIG01a	22	Tobacco moisture or Oven Volatiles		DESIGN PARAMETER SPECIFICATION	%						MINIMUM
23	TOB07	DP	CIG01a	23	Tobacco moisture or Oven Volatiles		DESIGN PARAMETER SPECIFICATION	%						MAXIMUM
24	TOB07	DP	CIG01a	24	Tobacco cut size			mm or cuts per inch ²						TARGET
25	TOB07	DP	CIG01a	25	Tobacco cut size			mm or cuts per inch ²						MINIMUM
26	TOB07	DP	CIG01a	26	Tobacco cut size			mm or cuts per inch ²						MAXIMUM
27	TOB07	DP	CIG01a	27	Filter Ventilation			%						TARGET
28	TOB07	DP	CIG01a	28	Filter Ventilation			%						MINIMUM
29	TOB07	DP	CIG01a	29	Filter Ventilation			%						MAXIMUM
30	TOB07	DP	CIG01a	30	Tipping Paper Length			mm						TARGET
31	TOB07	DP	CIG01a	31	Tipping Paper Length			mm						MINIMUM
32	TOB07	DP	CIG01a	32	Tipping Paper Length			mm						MAXIMUM
33	TOB07	DP	CIG01a	33	Cigarette base paper Porosity or Permeability			CORESTA Unit (Cu)						TARGET
34	TOB07	DP	CIG01a	34	Cigarette base paper Porosity or Permeability			CORESTA Unit (Cu)						MINIMUM
35	TOB07	DP	CIG01a	35	Cigarette base paper Porosity or Permeability			CORESTA Unit (Cu)						MAXIMUM
36	TOB07	DP	CIG01a	36	Cigarette Paper band porosity or permeability or band diffusivity			CORESTA Unit (Cu) or cm²/s						TARGET
37	TOB07	DP	CIG01a	37	Cigarette Paper band porosity or permeability or band diffusivity			CORESTA Unit (Cu) or cm²/s						MINIMUM
38	TOB07	DP	CIG01a	38	Cigarette Paper band porosity or permeability or band diffusivity			CORESTA Unit (Cu) or cm²/s						MAXIMUM
39	TOB07	DP	CIG01a	39	Cigarette Paper band width			mm						TARGET
40	TOB07	DP	CIG01a	40	Cigarette Paper band width			mm						MINIMUM
41	TOB07	DP	CIG01a	41	Cigarette Paper band width			mm						MAXIMUM
42	TOB07	DP	CIG01a	42	Cigarette Paper band space			mm						TARGET
43	TOB07	DP	CIG01a	43	Cigarette Paper band space			mm						MINIMUM
44	TOB07	DP	CIG01a	44	Cigarette Paper band space			mm						MAXIMUM
45	TOB07	DP	CIG01a	45	Filter efficiency¹			%						TARGET
46	TOB07	DP	CIG01a	46	Filter efficiency ¹			%						MINIMUM
47	TOB07	DP	CIG01a	47	Filter efficiency¹			%						MAXIMUM
48	TOB07	DP	CIG01a	48	Denier per Filament			DPF						TARGET
49	TOB07	DP	CIG01a	49	Denier per Filament			DPF						MINIMUM
50	TOB07	DP	CIG01a	50	Denier per Filament			DPF						MAXIMUM
51	TOB07	DP	CIG01a	51	Total Denier			g/9000 m						TARGET
52	TOB07	DP	CIG01a	52	Total Denier			g/9000 m						MINIMUM
53	TOB07	DP	CIG01a	53	Total Denier			g/9000 m						MAXIMUM
54	TOB07	DP	CIG01a	54	Filter Density			g/cm³						TARGET
55	TOB07	DP	CIG01a	55	Filter Density			g/cm³						MINIMUM
56	TOB07	DP	CIG01a	56	Filter Density			g/cm³						MAXIMUM
57	TOB07	DP	CIG01a	57	Filter Length			mm						TARGET
58	TOB07	DP	CIG01a	58	Filter Length			mm						MINIMUM
59	TOB07	DP	CIG01a	59	Filter Length			mm						MAXIMUM
60	TOB07	DP	CIG01a	60	Filter Pressure Drop			mm H2O						TARGET
61	TOB07	DP	CIG01a	61	Filter Pressure Drop			mm H2O						MINIMUM
62	TOB07	DP	CIG01a	62	Filter Pressure Drop			mm H2O						MAXIMUM
63	TOB07	DP	CIG01a	63	Tobacco Rod Density			g/cm³						TARGET
64	TOB07	DP	CIG01a	64	Tobacco Rod Density			g/cm³						MINIMUM
65	TOB07	DP	CIG01a	65	Tobacco Rod Density			g/cm³						MAXIMUM
66	TOB07	DP	CIG01a	66	Cigarette Paper Length			mm						TARGET
67	TOB07	DP	CIG01a	67	Cigarette Paper Length			mm						MINIMUM
68	TOB07	DP	CIG01a	68	Cigarette Paper Length			mm						MAXIMUM

...

Page tree

Versions Compared

Old Version 22

New Version 23

Key