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. 

This example only shows test results for each constituent for one sample of one product that was tested. The sampling plan and testing plan including the number of samples of the products tested are determined by the sposnor. In reality, sponsors would have multiple product samples tested 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.          

Dataset wrap
Namept
Rowcaps
Rows 1-15:Show the HPHC testing performed on one sample of the product with SPTOBID CIG01a. The test condition are represented in PTTSTND. 
Row 16:Shows the  HPHC testing performed on one sample for one ingredient using the CANDIAN INTENSE test conditions. 
Dataset2
RowSTUDYIDDOMAINSPTOBIDPTSEQPTREFIDSTRFIDPTTESTCDPTTESTPTTSTDTLPTCATPTSCATPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTTSTCNDPTMETHODPTNAMPTLLOQPTREPNUMPTDTC
1TOB07PTCIG01a

1

Sample 175-07-0ACETALD

Acetaldehyde

QUANTITY

HPHC TESTING

SMOKED PRODUCT1639ug/article


ISO INTENSE METHODGC-MSTOBACCO LAB 1
12022-09-30
2TOB07PTCIG01a2Sample 1107-02-8ACROLAcroleinQUANTITYHPHC TESTING
154ug/article


ISO INTENSE METHODGC-MSTOBACCO LAB 1
12022-09-30
3TOB07PTCIG01a3Sample 1107-13-1ACRLONIAcrylonitrile

QUANTITY

HPHC TESTING







ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
4TOB07PTCIG01a4Sample 192-67-1AMNPHEN44-AminobiphenylQUANTITYHPHC TESTING





ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
5TOB07PTCIG01a5Sample 1134-32-7AMNPHTH11-Aminonaphthalene

QUANTITY

HPHC TESTING







ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
6TOB07PTCIG01a6Sample 17664-41-7NH4AmmoniaQUANTITYHPHC TESTING
29.2ug/article


ISO INTENSE METHODICTOBACCO LAB 1
12022-09-30
7TOB07PTCIG01a7Sample 171-43-2BENZBenzene

QUANTITY

HPHC TESTING







ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
8TOB07PTCIG01a8Sample 150-32-8BENZAPBenzo[a]pyreneQUANTITYHPHC TESTING
30.5ug/article


ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
9TOB07PTCIG01a9Sample 1630-08-0COCarbon monoxide

QUANTITY

HPHC TESTING


28.2ug/article


ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
10TOB07PTCIG01a10Sample 14170-30-3CROTALDCrotonaldehydeQUANTITYHPHC TESTING
0.01



ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
11TOB07PTCIG01a11Sample 150-00-0FORMALDFormaldehyde

QUANTITY

HPHC TESTING


83.2ug/article


ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
12TOB07PTCIG01a12Sample 178-79-5ISOPRNIsopreneQUANTITYHPHC TESTING





ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
13TOB07PTCIG01a13Sample 154-11-5NICNicotine

QUANITY

HPHC TESTING


1.71ug/article


ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
14TOB07PTCIG01a14Sample 164091-91-4NNK

Nicotine-derived Nitrosamine Ketone

QUANTITYHPHC TESTING





ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
15TOB07PTCIG01a15Sample 116543-55-8NNNN-nitrosonornicotine

QUANTITY

HPHC TESTING


284ug/article


ISO INTENSE METHOD
TOBACCO LAB 1
12022-09-30
16TOB07PTCIG01a

16

Sample 175-07-0ACETALD

Acetaldehyde

QUANTITY

HPHC TESTING







CANADIAN INTENSE METHOD
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

CASRGTRY  CAS Common Chemistry Registry 


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. 


Dataset wrap
NameTL
Dataset2
RowSTUDYIDDOMAINRDOMAINTLVAR1TLVRVAL1TLVAR2TLVRVAL2TLSEQTLGRPIDTLPARMCDTLPARMTLVALTLVALU
1

TOB07

TLPTPTSTCONDISO INTENSE METHOD

1
ISOSTNUMISO STandard NumberISO 3308
2

TOB07

TLPTPTSTCONDISO INTENSE METHOD

2
PUFFVOLPuff Voume34mg
3

TOB07

TLPTPTSTCONDISO INTENSE METHOD

3
TEMP Temperature 

4

TOB07

TLPTPTMETHODISO INTENSE METHOD

4
PUFFVOLPuff Voume35mg
5

TOB07

TLPTPTMETHODISCEV STANDARD

1
PUFFDURPuff DurationPT10M
6

TOB07

TLPTPTMETHODISCEV STANDARD

2
SMOKMACSmoking MachineBig
7

TOB07

TLPTSTRFID75-07-0PTTESTAcetaldehyde1
UNIIFDA Unique Ingredient NameGO1N1ZPR3B
8

TOB07

TLPTSTRFID75-07-0PTTESTAcetaldehyde2
IUPACNMEIUPAC NAMEacetaldehyde
9

TOB07

TLPTSTRFID75-07-0PTTESTAcetaldehyde3
NCICCDNCI Thesaurs C-CODECode C44328)




Dataset wrap
NameTL