Versions Compared

Key

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

...

Dataset wrap
Nameto
Rowcaps
Rows 1-4:Show the records for a tobacco product given SPTOBID of the Smokeless Tobacco Product, portioned SNUS.
Rows 1-3:Show the tobacco product is Joes Smokeless, Happy Dog Snus.
Rows 5-11:Show the package type is a Plastic Can and Plastic Lid that is a package of 24 with a portion mass of 1g each. in 30 mm x 10 mm x 5 mm cans.
Rows 12-1312:Show the attributes or characteristics of the content of the SNUS.
Dataset2
RowSTUDYIDDOMAINSPTOBIDTOSEQTOPARMCDTOPARMTOCATTOVALTOVALU
1

TOB17

TOSNUS-771TBPRDCATTobacco Product CategoryPRODUCT IDENTIFIERSmokeless Tobacco Product
2TOB17TOSNUS-772TBPRSCATTobacco Product SubcategoryPRODUCT IDENTIFIERSnus, portioned
3TOB17TOSNUS-773MANUFManufacturerPRODUCT IDENTIFIERJoes Smokeless
4TOB17TOSNUS-774TRADENAMTrade NamePRODUCT IDENTIFIERHappy Dog Snus
5TOB17TOSNUS-775PACKTYPPackage TypePRODUCT DESCRIPTORPlastic can and plastic lid
6TOB17TOSNUS-776PACKQUANPackage QuantityPRODUCT DESCRIPTOR24g
7TOB17TOSNUS-777PORTMASSPortion MassPRODUCT DESCRIPTOR1g
8TOB17TOSNUS-778PORTCONTPortion countPRODUCT DESCRIPTOR24
9
TOSNUS-779PRTLENGPortion lengthPRODUCT DESCRIPTOR30mm
10TOB17TOSNUS-7710PRTWDTHPortion widthPRODUCT DESCRIPTOR10mm
11TOB17TOSNUS-7711PRTTHICKPortion thicknessPRODUCT DESCRIPTOR5mm
12TOB17TOSNUS-7712CHARFLAVCharacterizing FlavorPRODUCT DESCRIPTORMint13TOB17TOSNUS-7713ADDPROPAdditional propertyPRODUCT DESCRIPTORn/a

The Product Design Parameters (PD) domain is used to represent design specification parameters of the tobacco product. Each property is identified using controlled terminology and is stored in PDPARMCD/PDPARM.

Dataset wrap
Namepd
Dataset2
RowSTUDYIDDOMAINSPTOBIDPDSEQPDPARMCDPDPARMPDVALTRGPDVALMINPDVALMAXPDVALU
1

TOB17

PDSNUS-77

1

TOCUTSIZTobacco Cut Size

70

65

75

cuts per inch/in

2

TOB17

PDSNUS-77

1

TOPRTSIZTobacco Particle Size

70

65

75

mm

3TOB17PDSNUS-772TOMOISTRTobacco Moisture32.23134%
4TOB17PDSNUS-773PRTLENGPortion Length3836.539.5mm
5TOB17PDSNUS-774PRTWDTHPortion Width161517mm
6TOB17PDSNUS-775PRTMASSPortion Mass10009001100mg
7TOB17PDSNUS-776PRTTHICKPortion (pouch) material thickness (if applicable)Material Thickness0.060.0550.065mm
8TOB17PDSNUS-777PRTMWGTPouch material basis weight (if applicable)Material Basis Weight161517g/m^2m2
9TOB17PDSNUS-778PRTMPORPouch material porosity (permeability) (if applicable)Material Porosity185016002200L/m^2m2/s
10TOB17PDSNUS-779NICTDSRTNicotine dissolution rateDissolution Rate15522%/min

The Tobacco Product Testing (PT) (similar to the Laboratory Test Results (LB) domain) dataset shows the tobacco product test demonstrating the actual tests and test results for the specified Design Parameter Specification as noted in the DU dataset (??? PD dataset).

...

Dataset wrap
Namept
Rowcaps
Rows 1-6:Show the tobacco design parameter specification test and the result in ORRES for the SNUS. (needs populated).
Row 3:Shows the design parameter specification for the portion mass.
Dataset2
RowSTUDYIDDOMAINSPTOBIDPTSEQPTREFIDPTTESTCDPTTESTPTTSTCNDPTCATPTSCATPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTREPNUMPTTPTPTTPTNUM
1TOB17PTSNUS-771
TOCUTSIZTobacco Cut Size
DESIGN PARAMETER TESTING

70

cuts per inch

70

70

mm or cuts per inch/in1Week 01
2TOB17PTSNUS-771
TOPRTSIZTobacco Particle Size
DESIGN PARAMETER TESTING

70

mm

70

70

mm or cuts per inch1Week 01
3TOB17PTSNUS-772
TOMOISTRTobacco Moisture
DESIGN PARAMETER TESTING
31.8%31.831.8%1Week 01
4TOB17PTSNUS-773
PRTMASSPortion Mass
DESIGN PARAMETER TESTING
998mg998998mg1Week 01
5TOB17PTSNUS-774
PRTMWGTPouch material basis weightMaterial Basis Weight
DESIGN PARAMETER TESTING
15.3g/m^2m215.315.3g/m^2m21Week 01
6TOB17PTSNUS-775
PRTMPORPouch material porosity (permeability)Material Porosity
DESIGN PARAMETER TESTING
1900L/m^2m2/s19001900L/m^2m2/s1Week 01
7TOB17PTSNUS-776
NICTDSRTNicotine dissolution rateDissolution Rate
DESIGN PARAMETER TESTING
18%/min1818%/min1Week 01