Page History

...

Dataset wrap

Name	SU

Rowcaps

Row 1:	Shows that the subject used this tobacco product. SUCAT and SUSCAT categorize the product used. The dates of use were not know, but SUSTTPT, SUSTRTPT, SUENTPT and SUENRTPT indicate that the use started before the visit and was still ongoing,
Row 2:	Shows that the subject used this smokeless tobacco product. This was not the subject usual brand of smokeless tobacco product.

Dataset2

tableid	SU

Row	STUDYID	DOMAIN	USUBJID	SPTOBID	SUSEQ	SUTRT	SUCAT	SUSCAT	SUOCCUR	SUSTAT	SUREASND	SUDOSE	SUDOSU	SUDOSFRQ	SUSTDTC	SUENDTC	SUSTTPT	SUSTRTPT	SUENTPT	SUENRTPT
1	TB901	SU	TB901005	BAND XYZ	1	BRAND XYZ CIGARTTES	SMOKED TOBACCO PRODUCT	USUAL BRAND	Y			2	PACK	QD			2006-01-01	BEFORE	2006-01-01	ONGOING
2	TB901	SU	TB901006	BRAND ZZZ	1	SNUS TOBACCO BRAND ZZZ	SMOKELESS TOBACCO PRODUCT	NOT USUAL BRAND	Y						2002	2006-01-01

In this situation, the sponsor maintained an in-house dictionary of tobacco brands. This allowed this sponsor to study products across studies using the same tobacco product code for each brand of tobacco product. These codes were used to create a TO domain. This domain provided details on the brand of tobacco product used by the subject. Data for two brands of tobacco are shown.

Dataset wrap

Name	TO

Dataset2

tableid	SU

Row	STUDYID	DOMAIN	SPTOBID	TOSEQ	TOTESTCD	TOTEST	TOCAT	TOORRES	TOSTRESC
1	TB901	TO	BRAND XYZ	1	TBPRDCAT	Tobacco Product Category	PRODUCT IDENTIFIER	Cigarettes	Cigarettes
2	TB901	TO	BRAND XYZ	2	TBPRSCAT	Tobacco Product Subcategory	PRODUCT IDENTIFIER	Filtered, Combusted	Filtered, Combusted
3	TB901	TO	BRAND XYZ	3	MANUF	Manufacturer	PRODUCT IDENTIFIER	Brand XYZ Company	Brand XYZ Company
4	TB901	TO	BRAND XYZ	4	TRADENAM	Trade Name	PRODUCT IDENTIFIER	XYZ Menthol King Size	XYZ Menthol King Size
1	TB901	TO	BRAND ZZZ	1	TBPRDCAT	Tobacco Product Category	PRODUCT IDENTIFIER	Smokeless Tobacco Product	Smokeless Tobacco Product
2	TB901	TO	BRAND ZZZ	2	TBPRSCAT	Tobacco Product Subcategory	PRODUCT IDENTIFIER	Snus, portioned	Snus, portioned
3	TB901	TO	BRAND ZZZ	3	MANUF	Manufacturer	PRODUCT IDENTIFIER	ZZZ Smokeless	ZZZ Smokeless

Page tree

Versions Compared

Old Version 19

New Version 20

Key