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.
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.
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.
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.
pt.xpt
pt.xpt
Row
STUDYID
DOMAIN
SPTOBID
PTSEQ
PTREFID
STRFID
PTTESTCD
PTTEST
PTTSTDTL
PTCAT
PTSCAT
PTORRES
PTORRESU
PTSTRESC
PTSTRESN
PTSTRESU
PTTSTCND
PTMETHOD
PTNAM
PTLLOQ
PTREPNUM
PTDTC
1
TOB07
PT
CIG01a
1
Sample 1
75-07-0
ACETALD
Acetaldehyde
QUANTITY
HPHC TESTING
SMOKED PRODUCT
1639
ug/article
ISO INTENSE METHOD
GC-MS
TOBACCO LAB 1
1
2022-09-30
2
TOB07
PT
CIG01a
2
Sample 1
107-02-8
ACROL
Acrolein
QUANTITY
HPHC TESTING
154
ug/article
ISO INTENSE METHOD
GC-MS
TOBACCO LAB 1
1
2022-09-30
3
TOB07
PT
CIG01a
3
Sample 1
107-13-1
ACRLONI
Acrylonitrile
QUANTITY
HPHC TESTING
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
4
TOB07
PT
CIG01a
4
Sample 1
92-67-1
AMNPHEN4
4-Aminobiphenyl
QUANTITY
HPHC TESTING
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
5
TOB07
PT
CIG01a
5
Sample 1
134-32-7
AMNPHTH1
1-Aminonaphthalene
QUANTITY
HPHC TESTING
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
6
TOB07
PT
CIG01a
6
Sample 1
7664-41-7
NH4
Ammonia
QUANTITY
HPHC TESTING
29.2
ug/article
ISO INTENSE METHOD
IC
TOBACCO LAB 1
1
2022-09-30
7
TOB07
PT
CIG01a
7
Sample 1
71-43-2
BENZ
Benzene
QUANTITY
HPHC TESTING
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
8
TOB07
PT
CIG01a
8
Sample 1
50-32-8
BENZAP
Benzo[a]pyrene
QUANTITY
HPHC TESTING
30.5
ug/article
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
9
TOB07
PT
CIG01a
9
Sample 1
630-08-0
CO
Carbon monoxide
QUANTITY
HPHC TESTING
28.2
ug/article
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
10
TOB07
PT
CIG01a
10
Sample 1
4170-30-3
CROTALD
Crotonaldehyde
QUANTITY
HPHC TESTING
0.01
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
11
TOB07
PT
CIG01a
11
Sample 1
50-00-0
FORMALD
Formaldehyde
QUANTITY
HPHC TESTING
83.2
ug/article
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
12
TOB07
PT
CIG01a
12
Sample 1
78-79-5
ISOPRN
Isoprene
QUANTITY
HPHC TESTING
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
13
TOB07
PT
CIG01a
13
Sample 1
54-11-5
NIC
Nicotine
QUANITY
HPHC TESTING
1.71
ug/article
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
14
TOB07
PT
CIG01a
14
Sample 1
64091-91-4
NNK
Nicotine-derived Nitrosamine Ketone
QUANTITY
HPHC TESTING
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
15
TOB07
PT
CIG01a
15
Sample 1
16543-55-8
NNN
N-nitrosonornicotine
QUANTITY
HPHC TESTING
284
ug/article
ISO INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
16
TOB07
PT
CIG01a
16
Sample 1
75-07-0
ACETALD
Acetaldehyde
QUANTITY
HPHC TESTING
CANADIAN INTENSE METHOD
TOBACCO LAB 1
1
2022-09-30
$warningHtml
Dataset Wrapper Debug Message
Please add a row column to your dataset.
This is the example meta data that the sponosr would include to describe the published references used to report STRFID.
Example PT Variable MetadataTOBA-11
-
Getting issue details...STATUS
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.
tl.xpt
tl.xpt
Row
STUDYID
DOMAIN
RDOMAIN
TLVAR1
TLVRVAL1
TLVAR2
TLVRVAL2
TLSEQ
TLGRPID
TLPARMCD
TLPARM
TLVAL
TLVALU
1
TOB07
TL
PT
PTSTCOND
ISO INTENSE METHOD
1
ISOSTNUM
ISO STandard Number
ISO 3308
2
TOB07
TL
PT
PTSTCOND
ISO INTENSE METHOD
2
PUFFVOL
Puff Voume
34
mg
3
TOB07
TL
PT
PTSTCOND
ISO INTENSE METHOD
3
TEMP
Temperature
4
TOB07
TL
PT
PTMETHOD
ISO INTENSE METHOD
4
PUFFVOL
Puff Voume
35
mg
5
TOB07
TL
PT
PTMETHOD
ISCEV STANDARD
1
PUFFDUR
Puff Duration
PT10M
6
TOB07
TL
PT
PTMETHOD
ISCEV STANDARD
2
SMOKMAC
Smoking Machine
Big
7
TOB07
TL
PT
STRFID
75-07-0
PTTEST
Acetaldehyde
1
UNII
FDA Unique Ingredient Name
GO1N1ZPR3B
8
TOB07
TL
PT
STRFID
75-07-0
PTTEST
Acetaldehyde
2
IUPACNME
IUPAC NAME
acetaldehyde
9
TOB07
TL
PT
STRFID
75-07-0
PTTEST
Acetaldehyde
3
NCICCD
NCI Thesaurs C-CODE
Code C44328)
Dataset Debug Message
There are two leading, trailing, or non-breaking spaces in the dataset.