...
This example only shows test results for each constituent for one replicate of one sample of one product that was tested (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 sponsor or by regulatory requirement. Sponsors would likely have multiple product samples tested in multiple replicates, and those would be distinguished in the dataset by values of PTREPNUM being set to 1 through n, where n = the number of replicates being performed.
The following references were used as guidance for the example below:
1. https://www.ecigstats.org/docs/research/CoA_1R6F.pdf
2. https://open.canada.ca/data/en/dataset/71394df3-aee8-4117-92cb-a035360972a2/resource/7e6b0457-051e-4620-befc-8e4f50b75345
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Rows 1-17: | Show the HPHC testing performed on one sample of the product with SPTOBID CIG01a. The test condition is represented in STOCONID. | | Rows 5-6: | Show the same analyte from two different sources | | Rows 14-16: | Show three analytes that were tested in smoke produced by a smoking machine. SPDEVID indicates the smoking machine identified in the DI dataset example below. The smoking regimen is shown in PTREFID. The parameters of the smoking regimen are represented in the DU domain (example below) and are matched by using the same value of DUREFID). Note that PTSPEC (Matrix Type) is "SMOKE" for these 3 records (vs "TOBACCO") for all other records in this dataset. | | Rows 18-19: | Show the HPHC testing performed on one sample for two ingredients using the CANDIAN INTENSE test conditions. Row 18 Specimen is Smoke and Row 19 Specimen is Filler. |
|
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPTOBID | SPDEVID | PTSEQ | PTREFID | PTCAS | PTTESTCD | PTTEST | PTCAT | PTSCAT | PTORRES | PTORRESU | PTSTRESC | PTSTRESN | PTSTRESU | PTNAM | PTSPEC | PTMETHOD | PTREPNUM | PTDTC |
|---|
| 1 | TOB07 | PT | CIG01a |
| 1 |
| 75-07-0 | ACTALD | Acetaldehyde | HPHC TESTING | HPHC | 522 | µg/cigarette | 522 | 522 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 2 | TOB07 | PT | CIG01a |
| 2 |
| 107-02-8 | ACROLEIN | Acrolein | HPHC TESTING | HPHC | 43 | µg/cigarette | 43 | 43 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 3 | TOB07 | PT | CIG01a |
| 3 |
| 107-13-1 | ACRYNTRL | Acrylonitrile | HPHC TESTING | HPHC | 7 | µg/cigarette | 7 | 7 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 4 | TOB07 | PT | CIG01a |
| 4 |
| 92-67-1 | ABP4 | 4-Aminobiphenyl | HPHC TESTING | HPHC | 1.2 | ng/cigarette | 1.2 | 1.2 | ng/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 5 | TOB07 | PT | CIG01a |
| 5 |
| 134-32-7 | AMNPHTH1 | 1-Aminonaphthalene | HPHC TESTING | HPHC | 14 | ng/cigarette | 14 | 14 | ng/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 6 | TOB07 | PT | CIG01a |
| 6 |
| 134-32-7 | AMNPHTH2 | 2-Aminonaphthalene | HPHC TESTING | HPHC | 8 | ng/cigarette | 8 | 8 | ng/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 7 | TOB07 | PT | CIG01a |
| 7 |
| 7664-41-7 | AMMONIA | Ammonia | HPHC TESTING | HPHC | 9 | µg/cigarette | 9 | 9 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 8 | TOB07 | PT | CIG01a |
| 8 |
| 71-43-2 | BENZENE | Benzene | HPHC TESTING | HPHC | 33 | µg/cigarette | 33 | 33 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 9 | TOB07 | PT | CIG01a |
| 9 |
| 50-32-8 | BZAPYR | Benzo[a]pyrene | HPHC TESTING | HPHC | 6.8 | ng/cigarette | 6.8 | 6.8 | ng/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 10 | TOB07 | PT | CIG01a |
| 10 |
| 630-08-0 | CMONOX | Carbon Monoxide | HPHC TESTING | HPHC | 10.1 | mg/cigarette | 10.1 | 10.1 | mg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 11 | TOB07 | PT | CIG01a |
| 11 |
| 4170-30-3 | CROTNALD | Crotonaldehyde | HPHC TESTING | HPHC | 11 | µg/cigarette | 11 | 11 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 12 | TOB07 | PT | CIG01a |
| 12 |
| 50-00-0 | FORMALD | Formaldehyde | HPHC TESTING | HPHC | 27 | µg/cigarette | 27 | 27 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 13 | TOB07 | PT | CIG01a |
| 13 |
| 78-79-5 | ISOPRENE | Isoprene | HPHC TESTING | HPHC | 320 | µg/cigarette | 320 | 320 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 14 | TOB07 | PT | CIG01a | PUFFMASTER3K | 14 | Medium Intensity Regimen | 1954-11-05 | NICOTINE | Nicotine | HPHC TESTING | HPHC | 0.721 | mg/cigarette | 0.721 | 0.721 | mg/cigarette | TPT LABCO | SMOKE | ISO METHOD | 1 | 2022-09-30 | | 15 | TOB07 | PT | CIG01a | PUFFMASTER3K | 15 | Medium Intensity Regimen | 64091-91-4 | NNK | Nicotine-Derived Nitrosamine Ketone | HPHC TESTING | HPHC | 71 | ng/cigarette | 71 | 71 | ng/cigarette | TPT LABCO | SMOKE | ISO METHOD | 1 | 2022-09-30 | | 16 | TOB07 | PT | CIG01a | PUFFMASTER3K | 16 | Medium Intensity Regimen | 16543-55-8 | NNN | N-Nitrosonornicotine | HPHC TESTING | HPHC | 85 | ng/cigarette | 85 | 85 | ng/cigarette | TPT LABCO | SMOKE | ISO METHOD | 1 | 2022-09-30 | | 17 | TOB07 | PT | CIG01a |
| 17 |
| 108-88-3 | TOLUENE | Toluene | HPHC TESTING | HPHC | 53 | µg/cigarette | 53 | 53 | µg/cigarette | TPT LABCO | TOBACCO | ISO METHOD | 1 | 2022-09-30 | | 18 | TOB07 | PT | CIG01a |
| 18 |
| 75-07-0 | ACTALD | Acetaldehyde | HPHC TESTING | HPHC | 1552 | µg/cigarette | 1552 | 1552 | µg/cigarette | TPT LABCO | TOBACCO | CANADIAN INTENSE METHOD | 1 | 2022-09-30 | | 19 | TOB07 | PT | CIG01a |
| 19 |
| 7664-41-7 | AMMONIA | Ammonia | HPHC TESTING | HPHC | 956 | µg/g | 956 | 956 | µg/cigarette | TPT LABCO | FILLER | CANADIAN INTENSE METHOD | 1 | 2022-09-30 |
|
|
...