Versions Compared

Old Version 25

changes.mady.by.user Jon Neville

Saved on

compared with

New Version 26

changes.mady.by.user Jon Neville

Saved on

Key

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

...

Dataset wrap
Nameto
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
RowSTUDYIDDOMAINSPTOBIDTOSEQTOPARMCDTOPARMTOVALTOVALU
1TOB07TOCIG01a1TBPRDCATTobacco Product CategoryCigarette
2TOB07TOCIG01a2TBPRSCATTobacco Product SubcategoryFiltered, Combusted
3TOB07TOCIG01a3MANUFManufacturerJoes Cigs USA
4TOB07TOCIG01a4TRADENAMTrade NameTreetop Menthol King Size
5TOB07TOCIG01a5PACKTYPPackage TypeHARD PACK
6TOB07TOCIG01a6PRDQUANProduct Quantity20CIGARETTE
7TOB07TOCIG01a7LENGTHLength86.0mm
8TOB07TOCIG01a8CIRCUMFCircumference26.0mm
9TOB07TOCIG01a9VENTLTNVentilation10.0%
10TOB07TOCIG01a10CHARFLAVCharacterizing FlavorMENTHOL


Option 2 of Steve H's suggestion of combining our  previous product identifiers and product descriptors into a single dataset:


Dataset2
RowSTUDYIDDOMAINSPTOBIDTOSEQTOTESTCDTOTESTTOCATTOSCATTOORRESTOORRESUTOSTRESCTOSTRESNTOSTRESUTOCOLSRT
1TOB07TOCIG01a

1

TBPRDCATTobacco Product Category

Cigarette
Cigarette


2TOB07TOCIG01a2TBPRSCATTobacco Product Subcategory

Filtered, Combusted
Filtered, Combusted


3TOB07TOCIG01a3MANUFManufacturer

Joes Cigs USA
Joes Cigs USA


4TOB07TOCIG01a4TRADENAMTrade Name

Treetop Methol King Size
Treetop Methol King Size


5TOB07TOCIG01a5PACKTYPPackage Type

HARD PACK
HARD PACK


6TOB07TOCIG01a6PRDQUANProduct Quantity

20CIGARETTE2020CIGARETTE
7TOB07TOCIG01a7LENGTHLength

86.0mm86.086.0mm
8TOB07TOCIG01a8CIRCUMFCircumference

26.0mm26.026.0mm
9TOB07TOCIG01a9VENTLTNVentilation

10.0%10.010.0%
10TOB07TOCIG01a10CHARFLAVCharacterizing Flavor

MENTHOL
MENTHOL


11TOB07TOCIG01a11HTSOURCEHeat Source

xxx
xxx

OPtion 2:

...

Nameto

...





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
Namedp
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
RowSTUDYIDDOMAINSPTOBIDDPSEQDPTESTCDDPTESTDPCATDPSCATDPORRESDPORRESUDPSTRESCDPSTRESNDPSTRESUDPCOLSRT
1

TOB07

DPCIG01a

1

...

1

...

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
Namedp
12
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
RowSTUDYIDDOMAINSPTOBIDDPSEQDPTESTCDDPTESTDPCATDPSCATDPORRESDPORRESUDPSTRESCDPSTRESNDPSTRESUDPCOLSRT
1TOB07DPCIG01a

1

TBPRDCATTobacco Product CategoryCigaretteCigarette2TOB07DPCIG01a2TBPRSCATTobacco Product SubcategoryFiltered, CombustedFiltered, Combusted3TOB07DPCIG01a3MANUFManufacturerJoes Cigs USAJoes Cigs USA4TOB07DPCIG01a4TRADENAMTrade NameTreetop Methol King SizeTreetop Methol King Size5TOB07DPCIG01a5PACKTYPPackage TypeHARD PACKHARD PACK6TOB07DPCIG01a6PRDQUANProduct Quantity20CIGARETTE2020CIGARETTE7TOB07DPCIG01a7LENGTHLength86.0mm86.086.0mm8TOB07DPCIG01a8CIRCUMFCircumference26.0mm26.026.0mm9TOB07DPCIG01a9VENTLTNVentilation10.0%10.010.0%10TOB07DPCIG01a10CHARFLAVCharacterizing FlavorMENTHOLMENTHOL11TOB07DPCIG01a11HTSOURCEHeat Sourcexxxxxx12

TOB07

DPCIG01a

LENGTHLengthDESIGN PARAMETER SPECIFICATIONmm




TARGET
13
2TOB07DPCIG01a
13
2LENGTHLengthDESIGN PARAMETER SPECIFICATIONmm




MINIMUM
14
3TOB07DPCIG01a
14
3LENGTHLengthDESIGN PARAMETER SPECIFICATIONmm




MAXIMUM
15
4TOB07DPCIG01a4
15
CIRCUMFCircumference
Cigarette circumference or diameter 2
DESIGN PARAMETER SPECIFICATIONmm




TARGET
16
5TOB07DPCIG01a
16
5CIRCUMFCircumference
Cigarette circumference or diameter 2
DESIGN PARAMETER SPECIFICATIONmm




MINIMUM
17
6TOB07DPCIG01a6
17
CIRCUMFCircumference
Cigarette circumference or diameter 2
DESIGN PARAMETER SPECIFICATIONmm




MAXIMUM
18
7TOB07DPCIG01a7
18
TBFLMASSTobacco Filler
mass
MassDESIGN PARAMETER SPECIFICATIONmg




TARGET
19
8TOB07DPCIG01a8
19
TBFLMASSTobacco Filler
mass
MassDESIGN PARAMETER SPECIFICATIONmg




MINIMUM
20
9TOB07DPCIG01a9
20
TBFLMASSTobacco Filler
mass
MassDESIGN PARAMETER SPECIFICATIONmg




MAXIMUM
21
10TOB07DPCIG01a10
21Tobacco moisture or Oven Volatiles
MOISTUREMoistureDESIGN PARAMETER SPECIFICATION%




TARGET
22
11TOB07DPCIG01a11
22
MOISTUREMoisture
Tobacco moisture or Oven Volatiles
DESIGN PARAMETER SPECIFICATION%




MINIMUM
23
12TOB07DPCIG01a12
23
MOISTUREMoisture
Tobacco moisture or Oven Volatiles
DESIGN PARAMETER SPECIFICATION%




MAXIMUM
24
13TOB07DPCIG01a
24
13TOCUTSIZTobacco
cut size
Cut Size
mm or cuts per inch 2




TARGET
25
14TOB07DPCIG01a14
25
TOCUTSIZTobacco
cut size
Cut Size
mm or cuts per inch 2




MINIMUM
26
15TOB07DPCIG01a15
26
TOCUTSIZTobacco
cut size
Cut Size
mm or cuts per inch 2




MAXIMUM
27
16TOB07DPCIG01a16
27
FLTRVENTFilter Ventilation
%




TARGET
28
17TOB07DPCIG01a
28
17FLTRVENTFilter Ventilation
%




MINIMUM
29
18TOB07DPCIG01a
29
18FLTRVENTFilter Ventilation
%




MAXIMUM
30
19TOB07DPCIG01a19
30
TPNPLGTHTipping Paper Length
mm




TARGET
31
20TOB07DPCIG01a20
31
TPNPLGTHTipping Paper Length
mm




MINIMUM
32
21TOB07DPCIG01a21
32
TPNPLGTHTipping Paper Length
mm




MAXIMUM
33
22TOB07DPCIG01a22
33
CIGBPPORCigarette
base paper
Base Paper Porosity or Permeability
CORESTA Unit (Cu)




TARGET
34
23TOB07DPCIG01a23
34
CIGBPPORCigarette
base paper
Base Paper Porosity or Permeability
CORESTA Unit (Cu)




MINIMUM
35
24TOB07DPCIG01a24
35
CIGBPPORCigarette
base paper
Base Paper Porosity or Permeability
CORESTA Unit (Cu)




MAXIMUM
36
25TOB07DPCIG01a25
36
BNDDIFCigarette Paper
band porosity
Band Porosity or
permeability
Permeability or
band diffusivity
Band Diffusivity
CORESTA Unit (Cu) or cm2/s




TARGET
37
26TOB07DPCIG01a
37
26BNDDIFCigarette Paper
band porosity
Band Porosity or
permeability
Permeability or
band diffusivity
Band Diffusivity
CORESTA Unit (Cu) or cm2/s




MINIMUM
38
27TOB07DPCIG01a27
38
BNDDIFCigarette Paper
band porosity
Band Porosity or
permeability
Permeability or
band diffusivity
Band Diffusivity
CORESTA Unit (Cu) or cm2/s




MAXIMUM
39
28TOB07DPCIG01a28
39
CPBNDWIDCigarette Paper
band width
Band Width
mm




TARGET
40
29TOB07DPCIG01a
40
29CPBNDWIDCigarette Paper
band width
Band Width
mm




MINIMUM
41
30TOB07DPCIG01a30
41
CPBNDWIDCigarette Paper
band width
Band Width
mm




MAXIMUM
42
31TOB07DPCIG01a31
42
CPBNDSPCCigarette Paper
band space
Band Space
mm




TARGET
43
32TOB07DPCIG01a32
43
CPBNDSPCCigarette Paper
band space
Band Space
mm




MINIMUM
44
33TOB07DPCIG01a33
44
CPBNDSPCCigarette Paper
band space
Band Space
mm




MAXIMUM
45
34TOB07DPCIG01a
45
34FLTREFFFilter
efficiency 1
Efficiency
%




TARGET
46
35TOB07DPCIG01a35
46
FLTREFFFilter
efficiency 1
Efficiency
%




MINIMUM
47
36TOB07DPCIG01a36
47
FLTREFFFilter
efficiency 1
Efficiency
%




MAXIMUM
48
37TOB07DPCIG01a
48
37DPFDenier
per
Per Filament
DPF

/filament




TARGET
49
38TOB07DPCIG01a38
49
DPFDenier
per
Per Filament
DPF

/filament




MINIMUM
50
39TOB07DPCIG01a
50
39DPFDenier
per
Per Filament
DPF

/filament




MAXIMUM
51
40TOB07DPCIG01a40
51
DENIER
Total
Denier
g/9000 m




TARGET
52
41TOB07DPCIG01a41
52
DENIER
Total
Denier
g/9000 m




MINIMUM
53
42TOB07DPCIG01a42
53
DENIER
Total Denier
Denier 
g/9000 m




MAXIMUM
54
43TOB07DPCIG01a
54
43FLTRDENFilter Density
g/cm3




TARGET
55
44TOB07DPCIG01a44
55
FLTRDENFilter Density
g/cm3




MINIMUM
56
45TOB07DPCIG01a45
56
FLTRDENFilter Density
g/cm3




MAXIMUM
57
46TOB07DPCIG01a46
57
FLTRLGTHFilter Length
mm




TARGET
58
47TOB07DPCIG01a47
58
FLTRLGTHFilter Length
mm




MINIMUM
59
48TOB07DPCIG01a48
59
FLTRLGTHFilter Length
mm




MAXIMUM
60
49TOB07DPCIG01a
60
49FLTPRDRPFilter Pressure Drop
mm H2O




TARGET
61
50TOB07DPCIG01a
61
50FLTPRDRPFilter Pressure Drop
mm H2O




MINIMUM
62
51TOB07DPCIG01a51
62
FLTPRDRPFilter Pressure Drop
mm H2O




MAXIMUM
63
52TOB07DPCIG01a52
63
TORODDENTobacco Rod Density
g/cm3




TARGET
64
53TOB07DPCIG01a53
64
TORODDENTobacco Rod Density
g/cm3




MINIMUM
65
54TOB07DPCIG01a54
65
TORODDENTobacco Rod Density
g/cm3




MAXIMUM
66
55TOB07DPCIG01a
66
55Cigarette Paper LengthCIGPLGTH
mm




TARGET
67
56TOB07DPCIG01a
67
56Cigarette Paper LengthCIGPLGTH
mm




MINIMUM
68
57TOB07DPCIG01a
68
57Cigarette Paper LengthCIGPLGTH
mm




MAXIMUM
Dataset wrap
Namett
Rowcaps
Rows 1-4:
Row 5:S
Row 6:
Row 7:
Dataset2
RowSTUDYIDDOMAINSPTOBIDTTSEQTTREFIDTTGRPIDTTTESTCDTTTESTTTCATTTORRESTTORRESUTTSTRESCTTSTRESNTTSTRESUTTCOLSRT
1TOB07TTCIG01a1


Tobacco Filler mass

mg

mg


2TOB07TTCIG01a2


Tobacco moisture or Oven Volatiles

%

%
3TOB07TTCIG01a3


Tobacco cut size

mm or cuts per inch 2

mm or cuts per inch 2
4TOB07TTCIG01a4


Tobacco Rod density

g/cm3

g/cm3
5TOB07TTCIG01a5


Filter Ventilation

%

%
6TOB07TTCIG01a6


Cigarette base paper Porosity or Permeability

CORESTA Unit (Cu)

CORESTA Unit (Cu)
7TOB07TTCIG01a7


Cigarette Paper band porosity or permeability or band diffusivity

CORESTA Unit (Cu) or cm2/s

CORESTA Unit (Cu) or cm2/s
8TOB07TTCIG01a8


Filter efficiency 1

%

%
9TOB07TTCIG01a9


Denier per Filament

DPF

DPF
10TOB07TTCIG01a10


Total Denier

g/9000 m

g/9000 m
11TOB07TTCIG01a11


Filter Density

g/cm3

g/cm3
12TOB07TTCIG01a12


Filter Pressure Drop

mm H2O

mm H2O


...