Versions Compared

Key

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

ISSUE: 

  1. I think we need to make STRFID domain specific . That is use PTSTRID.  This allow different reference Id to be used across domains. I think here you can use CAS, but in ingredients this does not work.  IS it ok to keep , this meta example for the REFID. WE need to confirm with Richard how to describe.  
  2. Need to clean up TL.  SHould , we allow the ability to create look ups for UNI, etc. or delete and jsut show test condition for now. 
  3. Neew to agree that PT is product testing domain name, and not Tobacco Product Testing. Should we create a model class of Product testing- and then allow domains by product in the future. .  

The following example illustrates how to represent results from HPHC testing of a tobacco product under study using the Product Testing (PT) domain. This testing is conduct on samples of the product of interest, and if applicable samples of comparison products. Each product tested would have it's own unique sponsor-defined value for SPTOBID to identify the product. Tobacco product HPHC testing results are represented in the PT domain. This example illustrates HPHC testing and smoking regimens for a cigarette product. The example assumes testing at a single time point, not serial testing over multiple timepoints as in stability studies. See Section 3.1.4, Stability Studies, for more information and examples illustrating how to represent those data.

This example only shows test results for each constituent for one 1 replicate of 1 sample of one 1 product that was tested . The sampling plan (PTREPNUM = 1 for all records). Details of the sampling and testing plan, including the number of samples of the products tested, are determined by the sposnor. In reality, sponsors would applicant or by regulatory requirement.  Applicants would likely have multiple product samples tested in multiple replicates, and those would be distinguished in the dataset . These sample identification information may be represented in PTREFID, and/ or PTSPID. In this example, SPTOBID indicated the product identification, and each sample of that product was numbered as Sample 1 thru Sample n. Many sponsor may use more specific codes to identify the source of product sample.          by values of PTREPNUM being set to 1 through n, where n = the number of replicates being performed.

Note the use of the PTXFN (external file name) to indicate that the lab methodology was submitted as separate documentation.

Dataset wrap
Namept
Rowcaps
Rows 1-1517:

Show

the

HPHC testing performed

on one sample of the product with SPTOBID CIG01a. The test condition are represented in PTTSTND. 

in smoke produced by a smoking machine from the tobacco product identified in SPTOBID (CIG01a). Note of the use of SPDEVID as the device identifier for the smoking machine and the use of PTREFID to identify the smoking regimen (non-intense regimen). PTSPEC=SMOKE to indicate the specimen type is smoke.

Row 18:Shows 1 analyte was tested with a different smoking regimen (PTREFID=INTENSE REGIMEN) using the same smoking machine.
Row 19:Shows 1 analyte was tested in the tobacco filler (PTSPEC). Thus SPDEVID and PTREFID are null.Row 16:Shows the  HPHC testing performed on one sample for one ingredient using the CANDIAN INTENSE test conditions. 
Dataset2
RowSTUDYIDDOMAINSPTOBIDSPDEVIDPTSEQPTREFID
STRFID
PTTESTCDPTTEST
PTTSTDTL
PTCATPTSCATPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESU
PTTSTCND
PTXFN
PTMETHOD
PTNAM
PTLLOQ
PTSPECPTREPNUMPTDTC
1TOB07PTCIG01a
1
PUFFMASTER3K
Sample
1
75-07-0ACETALD
NON-INTENSE REGIMENACTALDAcetaldehyde
QUANTITY
HPHC TESTINGHPHC
TESTINGSMOKED PRODUCT1639
522ug/cigarette522522ug/
articleISO INTENSE METHODGC-MS
cigaretteTL001_V5.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
2TOB07PTCIG01aPUFFMASTER3K2
Sample 1107-02-8ACROL
NON-INTENSE REGIMENACROLEINAcrolein
QUANTITY
HPHC TESTINGHPHC
TESTING154
43ug/cigarette4343ug/
articleISO INTENSE METHODGC-MS
cigaretteTL002_V3.6.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
3TOB07PTCIG01aPUFFMASTER3K3
Sample 1107-13-1ACRLONI
NON-INTENSE REGIMENACRYNTRLAcrylonitrile

QUANTITY

HPHC TESTING

ISO INTENSE METHOD
HPHC TESTINGHPHC7ug/cigarette77ug/cigaretteTL006_V6.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
4TOB07PTCIG01aPUFFMASTER3K4
Sample 192-67-1
NON-INTENSE REGIMENABP4
AMNPHEN4
4-Aminobiphenyl
QUANTITY
HPHC TESTINGHPHC
TESTINGISO INTENSE METHOD
1.2ng/cigarette1.21.2ng/cigaretteTL008_V3.pdfTPT LABCOSMOKE
TOBACCO LAB 1134-32-7
12022-09-30
5TOB07PTCIG01aPUFFMASTER3K5
Sample 1
NON-INTENSE REGIMENAMNPHTH11-Aminonaphthalene

QUANTITY

HPHC TESTING

ISO INTENSE METHOD
HPHC TESTINGHPHC14ng/cigarette1414ng/cigaretteTL003_V1.4.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
6TOB07PTCIG01aPUFFMASTER3K6
Sample 17664-41-7NH4AmmoniaQUANTITYHPHC TESTING29.2ug/articleISO INTENSE METHODIC
NON-INTENSE REGIMENAMNPHTH22-AminonaphthaleneHPHC TESTINGHPHC8ng/cigarette88ng/cigaretteTL003_V1.4.pdfTPT LABCOSMOKE12022-09-30
7TOB07PTCIG01aPUFFMASTER3K7NON-INTENSE REGIMENAMMONIAAmmoniaHPHC TESTINGHPHC9ug/cigarette99ug/cigaretteTL020_V4.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
7
8TOB07PTCIG01a
7
PUFFMASTER3K
Sample 1
8
71-43-2BENZ
NON-INTENSE REGIMENBENZENEBenzene
QUANTITY
HPHC TESTINGHPHC
TESTINGISO INTENSE METHODTOBACCO LAB 1
33ug/cigarette3333ug/cigaretteTL017_V1.1.pdfTPT LABCOSMOKE12022-09-30
8
9TOB07PTCIG01a
8
PUFFMASTER3K
Sample 1
9
50-32-8
NON-INTENSE REGIMENBZAPYR
BENZAP
Benzo[a]pyrene
QUANTITY
HPHC TESTINGHPHC
TESTING
30
6.
5
8
ug/articleISO INTENSE METHOD
ng/cigarette6.86.8ng/cigaretteTL017_V1.1.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
9
10TOB07PTCIG01a
9
PUFFMASTER3K
Sample 1
10
630-08-0CO
NON-INTENSE REGIMENCMONOXCarbon
monoxide
Monoxide
QUANTITY
HPHC TESTINGHPHC
TESTING
28
10.
2
1
ug
mg/
articleISO INTENSE METHODTOBACCO LAB 1
cigarette10.110.1mg/cigaretteTL019_V3.pdfTPT LABCOSMOKE12022-09-30
10
11TOB07PTCIG01a
10
PUFFMASTER3K
Sample 1
11
4170-30-3CROTALD
NON-INTENSE REGIMENCROTNALDCrotonaldehyde
QUANTITY
HPHC TESTINGHPHC
TESTING0.01ISO INTENSE METHOD
11ug/cigarette1111ug/cigaretteTL001_V5.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
11
12TOB07PTCIG01a
11
PUFFMASTER3K
Sample 1
12
50-00-0
NON-INTENSE REGIMENFORMALDFormaldehyde
QUANTITY
HPHC TESTINGHPHC
TESTING83.2
27ug/cigarette2727ug/
articleISO INTENSE METHOD
cigaretteTL001_V5.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
12
13TOB07PTCIG01a
12
PUFFMASTER3K
Sample 1
13
78-79-5ISOPRN
NON-INTENSE REGIMENISOPRENEIsoprene
QUANTITYHPHC TESTINGISO INTENSE METHOD
HPHC TESTINGHPHC320ug/cigarette320320ug/cigaretteTL041_V1.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
13
14TOB07PTCIG01a
13
PUFFMASTER3K
Sample 1
14
54-11-5NIC
NON-INTENSE REGIMENNICOTINENicotine
QUANITY
HPHC TESTINGHPHC
TESTING
1
0.
71
721
ug/articleISO INTENSE METHODTOBACCO LAB 1
mg/cigarette0.7210.721mg/cigaretteTL007_V2.1.pdfTPT LABCOSMOKE12022-09-30
14
15TOB07PTCIG01a
14
PUFFMASTER3K
Sample 1
15
64091-91-4
NON-INTENSE REGIMENNNKNicotine-
derived
Derived Nitrosamine Ketone
QUANTITYHPHC TESTINGISO INTENSE METHOD
HPHC TESTINGHPHC71ng/cigarette7171ng/cigaretteTL026_V12.2.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
15
16TOB07PTCIG01a
15Sample 116543-55-8NNNN-nitrosonornicotine

QUANTITY

HPHC TESTING

284ug/articleISO INTENSE METHOD
PUFFMASTER3K16NON-INTENSE REGIMENNNNN-NitrosonornicotineHPHC TESTINGHPHC85ng/cigarette8585ng/cigaretteTL026_V12.2.pdfTPT LABCOSMOKE12022-09-30
17TOB07PTCIG01aPUFFMASTER3K17NON-INTENSE REGIMENTOLUENETolueneHPHC TESTINGHPHC53ug/cigarette5353ug/cigaretteTL011_V3.3.pdfTPT LABCOSMOKE
TOBACCO LAB 1
12022-09-30
16
18TOB07PTCIG01a

16

Sample 175-07-0ACETALD

Acetaldehyde

QUANTITY

HPHC TESTING

CANADIAN INTENSE METHOD
PUFFMASTER3K18INTENSE REGIMENACTALDAcetaldehydeHPHC TESTINGHPHC1552ug/cigarette15521552ug/cigaretteTL009_V4.3.pdfTPT LABCOSMOKE12022-09-30
19TOB07PTCIG01a
19
AMMONIAAmmoniaHPHC TESTINGHPHC956ug/g956956ug/cigaretteTL016_V1.2.pdfTPT LABCOTOBACCO FILLER
TOBACCO LAB 1
12022-09-30

This is the example meta data needed describe the published references used to report PTCSREFID. 

Example PT  Variable Metadata

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-11

Variable Label Type Codelist
PTCSREFIDChemical Substance Reference ID textCASREG  

Example External Dictionaries

...

Codelist

...

External Dictionary Name

...

Dictionary Version

...

Reference

The identifying characteristics of the smoking machine are represented in the Device Identifiers reference dataset. DI is the source of the applicant-defined device ID variable (SPDEVID) used in the PT dataset to indicate the smoking machine used to perform the smoking regimen.

Dataset wrap
titlelb.xpt
Namedi
Dataset2
RowSTUDYIDDOMAINSPDEVIDDISEQDIPARMCDDIPARMDIVAL
1TOB07DIPUFFMASTER3K1DEVTYPEDevice TypeSmoking Machine
2TOB07DIPUFFMASTER3K2MANUFManufacturerAcme
3TOB07DIPUFFMASTER3K3TRADENAMTrade NamePuffMaster 3000

Details of the smoking regimen performed by the smoking machine are represented as device in-use properties (such as settings) of the smoking machine. They are linked to the HPHC testing results in PT by matching values of PTREFID/DUREFID.

Dataset wrap
Namedu

...

https://commonchemistry.cas.org/?_ga=2.83414614.1907131087.1666302103-2054498898.1664568918

The Trial Lookup table can be used to provide additional details on any test conditions or methods used to perform the testing. 

 Additionally, TL can be used to provide different chemical reference information  that may  be used associated with the the substance ingredient. These different chemical substance reference numbers/codes are available in many published dictionaries, and may not be needed. This was used by the sponsors convenience only. 

mg
Dataset wrap
NameTL
Rowcaps
Rows 1-9:Show the parameters of the non-intense smoking regimen.
Rows 8-9:Note the use of DUGRPID to group these records together to indicate that puff pause and puff pause interval are related records. Taken together, they indicate that this smoking regimen pauses for 60 seconds every 10 puffs.
Rows 10-18:Show the parameters of the intense smoking regimen.
Rows 17-18:Note the use of DUGRPID to group these records together to indicate that puff pause and puff pause interval are related records. Taken together, they indicate that this smoking regimen pauses for 30 seconds every 10 puffs.
ISO 3308
Dataset2

Row

STUDYIDDOMAIN
RDOMAIN
SPDEVID
TLVAR1
DUSEQ
TLVRVAL1
DUREFID
TLVAR2
DUGRPID
TLVRVAL2
DUTESTCD
TLSEQ
DUTEST
TLGRPID
DUORRES
TLPARMCD
DUORRESU
TLPARM
DUSTRESC
TLVAL
DUSTRESN
TLVALU
DUSTRESU
1

TOB07

TL
DU
PT
PUFFMASTER3K
PTSTCOND
1
ISO
NON-INTENSE
METHOD
REGIMEN
1

PUFFPROF
ISOSTNUMISO STandard Number
Puff ProfileSQUARE
SQUARE

2

TOB07

TL
DU
PT
PUFFMASTER3K
PTSTCOND
2
ISO INTENSE METHOD2PUFFVOLPuff Voume34
NON-INTENSE REGIMEN

PUFFDUR

Puff Duration

1.25

sec

1.25

1.25

sec

3

TOB07

TL
DU
PT
PUFFMASTER3K
PTSTCOND
3
ISO INTENSE METHOD
NON-INTENSE REGIMEN

PUFFINT

Puff Interval

3

PUFF/min

3

TEMP 
3
Temperature 

PUFF/min

4

TOB07

TL
DU
PT
PUFFMASTER3K
PTMETHOD
4
ISO INTENSE METHOD4PUFFVOLPuff Voume35
NON-INTENSE REGIMEN

PUFFBLCK

Puff Block

25

%

25

25

%

mg

5

TOB07

TLPTPTMETHODISCEV STANDARD1PUFFDURPuff DurationPT10M
DUPUFFMASTER3K5NON-INTENSE REGIMEN

PUFFNUM

Number of Puffs

200

PUFF

200

200

PUFF

6

TOB07

TLPTPTMETHODISCEV STANDARD2SMOKMACSmoking MachineBig

DUPUFFMASTER3K6NON-INTENSE REGIMEN
PUFFVOLPuff Volume

10

mL

10

10

mL

7

TOB07

TLPTSTRFID75-07-0PTTESTAcetaldehyde1UNIIFDA Unique Ingredient NameGO1N1ZPR3B8

TOB07

TLPTSTRFID75-07-0PTTESTAcetaldehyde2IUPACNMEIUPAC NAMEacetaldehyde9

TOB07

TLPTSTRFID75-07-0PTTESTAcetaldehyde3NCICCDNCI Thesaurs C-CODECode C44328)
Dataset wrap
DUPUFFMASTER3K7NON-INTENSE REGIMEN
PUFFRNGPuff Range

100-200


100-200



8

TOB07

DUPUFFMASTER3K8NON-INTENSE REGIMEN1PUFFPAUSPuff Pause

60

s

60

60

s

9TOB07DUPUFFMASTER3K9NON-INTENSE REGIMEN1PUFFPINTPuff Pause Interval

10

PUFF

10

10

PUFF

10

TOB07

DUPUFFMASTER3K1INTENSE REGIMEN
PUFFPROFPuff ProfileSQUARE
SQUARE

11

TOB07

DUPUFFMASTER3K2INTENSE REGIMEN

PUFFDUR

Puff Duration

2.25

sec

2.25

2.25

sec

12

TOB07

DUPUFFMASTER3K3INTENSE REGIMEN

PUFFINT

Puff Interval

3

PUFF/min

3

3

PUFF/min

13

TOB07

DUPUFFMASTER3K4INTENSE REGIMEN

PUFFBLCK

Puff Block

30

%

30

30

%

14

TOB07

DUPUFFMASTER3K5INTENSE REGIMEN
PUFFNUMNumber of Puffs

100

PUFF

100

100

PUFF

15

TOB07

DUPUFFMASTER3K6INTENSE REGIMEN
PUFFVOLPuff Volume

20

mL

20

20

mL

16

TOB07

DUPUFFMASTER3K7INTENSE REGIMEN
PUFFRNGPuff Range

50-150


50-150



17

TOB07

DUPUFFMASTER3K8INTENSE REGIMEN2PUFFPAUSPuff Pause

30

s

30

30

s

18TOB07DUPUFFMASTER3K9INTENSE REGIMEN2PUFFPINTPuff Pause Interval

10

PUFF

10

10

PUFF

NameTL