Versions Compared

Old Version 9

changes.mady.by.user Christine Connolly

Saved on

compared with

New Version Current

changes.mady.by.user Christine Connolly

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Dataset wrap
Nameadlb
Dataset2
tableidadlb
RowSTUDYIDUSUBJID
LBSEQ
TRTPADTADTMAENDTMAVISITAVISITNPARAMCDPARAMPARCAT1AVAL
BASE
ABLFLSAFFL
CHG
TRTSDT
ABLFL
TRTEDTLBSTRESNLBSTRESULBNAMLBLOINCLBSPECLBMETHODLBLOBXFLLBLLOQVISITNUMVISITLBDTCLBENDTCLBSEQ
1TOB777001
Product A17JAN2021

Baseline0
1
NICOTINENicotine (ng/mL)TOBACCO ALKALOID30YY2021-01-202021-12-2030ng/mLTobacco Marker Testing Laboratory3853-9SERUMLC/MS/MSY21BASELINE2021-01-17
1
2TOB777001
2
Product A20JUL2021

Day 180180COTININECotinine (ng/mL)TOBACCO ALKALOID400
Y2021-01-202021-12-20400ng/mLTobacco Marker Testing Laboratory10365-5SERUMLC/MS/MS
23Day 1802021-07-20
2
3TOB777002
Product A21JUN202121JUN2021:08:0022JUN2021:08:00Baseline0
1
CREATCreatinine (ng/mL)24-HOUR URINE TEST0.8YY2021-01-202021-12-200.8ng/mLTobacco Marker Testing Laboratory65634-8URINELC-MS-MSY
1BASELINE2021-06-21T08:002021-06-22T08:001
4TOB777002
Product A21JUN202121JUN2021:08:0022JUN2021:08:00Baseline0
2
VOLUMEVolume (mL)24-HOUR URINE TEST1875YY2021-01-202021-12-201875mLTobacco Marker Testing Laboratory
URINE
Y
1BASELINE2021-06-21T08:002021-06-22T08:002
5TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
3
NICOTINENicotine (ng/mL)TOBACCO ALKALOID45
Y2021-01-202021-12-2045ng/mLTobacco Marker Testing Laboratory3854-7URINELC-MS/MS
0.23Day 1802021-12-15T08:002021-12-16T08:003
6TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
4
NICGLUCNicotine-glucuronide (ng/mL)TOBACCO ALKALOID40
Y2021-01-202021-12-2040ng/mLTobacco Marker Testing Laboratory
URINE

0.23Day 1802021-12-15T08:002021-12-16T08:004
7TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
5
NOXTNicotine-1 N-
oxid 
oxid (ng/mL)TOBACCO ALKALOID113.5
Y2021-01-202021-12-20113.5ng/mLTobacco Marker Testing Laboratory
URINEHPLC-ESI-MS/MS
2.503Day 1802021-12-15T08:002021-12-16T08:005
8TOB777002
6
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180COTININECotinine (ng/mL)TOBACCO ALKALOID300
Y2021-01-202021-12-20300ng/mLTobacco Marker Testing Laboratory10366-3URINELC/MS/MS)
0.053Day 1802021-12-15T08:002021-12-16T08:006
9TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
7
COTGLUCCotinine-glucuronide (ng/mL)TOBACCO ALKALOID275
Y2021-01-202021-12-20275ng/mLTobacco Marker Testing Laboratory
URINE

0.23Day 1802021-12-15T08:002021-12-16T08:007
10TOB777002
8
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180COXTCotinine-n-oxide (ng/mL)TOBACCO ALKALOID117.5
Y2021-01-202021-12-20117.5ng/mLTobacco Marker Testing Laboratory
URINEHPLC-ESI-MS/MS
2.023Day 1802021-12-15T08:002021-12-16T08:008
11TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
9
OHCOT or HCTTTrans-3-hydroxycotinine (ng/mL)TOBACCO ALKALOID2000
Y2021-01-202021-12-202000ng/mLTobacco Marker Testing Laboratory33916-8URINE

0.13Day 1802021-12-15T08:002021-12-16T08:009
12TOB777002
10
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180OHCOTG or 3HC-GlucTrans-3-hydroxycotinine glucuronide (ng/mL)TOBACCO ALKALOID3529
Y2021-01-202021-12-203529ng/mLTobacco Marker Testing Laboratory
URINE
0.03


103Day 1802021-12-15T08:002021-12-16T08:0010
13TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
11
NORNCTN or NNIC
Nornicotine 
Nornicotine (ng/mL)TOBACCO ALKALOID6
Y2021-01-202021-12-206ng/mLTobacco Marker Testing Laboratory33917-6URINELC/MS/MS
2.503Day 1802021-12-15T08:002021-12-16T08:0011
14TOB777002
12
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180ANBS
Anabasine 
Anabasine (ng/mL)TOBACCO ALKALOID5
Y2021-01-202021-12-205ng/mLTobacco Marker Testing Laboratory33915-0URINELC/MS/MS
0.513Day 1802021-12-15T08:002021-12-16T08:0012
15TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
13
NCOT
Norcotinine 
Norcotinine (ng/mL)TOBACCO ALKALOID2
Y2021-01-202021-12-202ng/mLTobacco Marker Testing Laboratory77740-9URINE

1.113Day 1802021-12-15T08:002021-12-16T08:0013
16TOB777002
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 180180
14
ANTBAnatabine (ng/mL)TOBACCO ALKALOID9.1
Y2021-01-202021-12-209.1ng/mLTobacco Marker Testing Laboratory
URINEHPLC-ESI-MS/MS

3Day 1802021-12-15T08:002021-12-16T08:0014
17TOB7772001
Product A15DEC202115DEC2021:08:0016DEC2021:08:00Day 6060
1

OH_2_FLU or 2-FLU

2-Hydroxyfluorene 3‐Hydroxyfluorene (3‐FLU) (ng/mL)POLYNUCLEAR AROMATIC HYDROCARBON30
Y2021-07-152022-06-3030ng/mLTobacco Marker Testing Laboratory3853-9URINELC-MS/MS
3853-9


2Day 602021-09-
15T010
15T10:002021-09-
16T009
16T09:201
18TOB7772001
Product A15AUG202115AUG2021:10:0016AUG2021:10:00Day 6060
2
OH1NAPHT1-Hydroxynaphthalene (ng/mL)POLYNUCLEAR AROMATIC HYDROCARBON400
Y2021-07-152022-06-30400ng/mLTobacco Marker Testing Laboratory10365-5URINELC-MS/MS
10365-5


2Day 602021-09-
15T010
15T10:002021-09-
16T009
16T09:202
19TOB7772001
3
Product A15AUG202115AUG2021:10:0016AUG2021:10:00Day 6060OH1PHE

1-Hydroxyphenanthrene (ng/mL)

POLYNUCLEAR AROMATIC HYDROCARBON45
Y2021-07-152022-06-3045ng/mLTobacco Marker Testing Laboratory3854-7URINELC-MS/MS
3854-7


2Day 602021-09-
15T010
15T10:002021-09-
16T009
16T09:203
20TOB7772001
Product A15AUG202115AUG2021:10:0016AUG2021:10:00Day 6060
4
OH3BAP3-Hydroxybenzo[a]pyrene (ng/mL)POLYNUCLEAR AROMATIC HYDROCARBON300
Y2021-07-152022-06-30300ng/mLTobacco Marker Testing Laboratory10366-3URINELC-MS/MS
10366-3


2Day 602021-09-
15T010
15T10:002021-09-
16T009
16T09:204
21TOB7772001
5
Product A15AUG2021

Day 6060COCarbon Monoxide (%)VARIOUS GASES10
Y

10%Tobacco Marker Testing Laboratory
EXPIRED AIRMultiple Wavelength Spectrophotometer

2Day 602021-09-15
5



Definexmltable
LevelDataset
PurposeAnalysis
NameADLB
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
ADLBLaboratory Analysis DatasetBASIC DATA STRUCTUREOne or more records per subject per analysis parameter per analysis visit per analysis timepointAnalysisSTUDYID, USUBJID, PARAM, PARAMCD, AVISIT,ADLB.xptADLB.SAS/SAP
Definexmltable
DatasetADLB
LevelVariable
PurposeAnalysis
NameADLB
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreCDISC Notes

STUDYID

Study IdentifierChar
ReqLB.STUDYID
USUBJIDUnique Subject IdentifierChar
ReqLB.USUBJID
TRTPPlanned

...

ProductChar
CondADSL.TRT01P
ADTAnalysis DateNum
PermLB.LBDTC captured as a date in numeric format

...

ADTM

...


Num
PermLB.LBDTC captured as a

...

dateTIME in numeric format

...

...

AENDTM

...


Num


PermLB.

...

LBENDTC captured as a datetime in numeric format.
AVISITAnalysis VisitChar
CondLB.VISIT
AVISITNAnalysis Visit (N)Num
PermLB.VISITNUM
PARAMParameterChar
ReqLB.LBTEST concatenated with LB.LBSTRESU
PARAMCDParameter Codetext
ReqLB.LBTESTCD

...

PARCAT1Parameter Category 1Char
PermLB.LBCAT
AVALAnalysis ValueNum
CondLB.LBSTRESN

...

ABLFLBaseline Record FlagCharYCondset to Y for last pre-

...

Product assessment  fir each parameter

...

SAFFL

...

Safety Population FlagChar

...

Y;NCondADSL.

...

SAFFL

...

TRTSDTDate of First Exposure to productNum
PermADSL.

...

TRTSDT

...

TRTEDTDate of Last Exposure to ProductNum

...


PermADSL.

...

TRTEDT
LBSTRESNNumeric
Result/Finding
in Standard
Units

PermLB.LBSTRESN
LBSTRESUStandard Units

...



Perm

...

LB.

...

LBSTRESU

...

LBNAM

...

Vendor NameChar
Perm

...

LB.

...

LBNAM

...

LBLOINCLOINC Code

...

Char

...


PermLB.LBLOINC
LBSPECSpecimen Type

...

Char

...


PermLB.LBSPEC
LBMETHODMethod of Test or ExaminationChar
PermLB.LBMETHOD
LBLOBXFLLast Observation Before Exposure FlagChar
PermLB.LBLOBXFL
LBLLOQLower Limit of Quantitation

...

Num
PermLB.

...

LBLLOQ
VISITVisit NameChar
PermLB.LB.VISIT
VISITNUMVisit NumberNum
PermLB.VISITNUM
LBDTCDate/Time of Specimen CollectionChar
PermLB.LBDTC
LBENDTCEnd Date/Time of Specimen CollectionChar
PermLB.LBENDTC
LBSEQSequence NumberNum
PermLB.LBSEQ