...
| Info |
|---|
Jon - since we started with using PTREFID for the Smoking Regimen in the Cig. example, The batch number could go in --SPID. It seems like Smoking Regimen is a method for testing and I am not sure --REFID is the right place for the "Smoking Regimen". What do you think of using --GRPID for the smoking regimen? It seems less of a reference identifier and more of a grouping identifier if deemed it has to be an identifier. Add Sample ID for - Batch 1
|
The following references were used as guidance for the example below:
...
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Rows 1-2: | Show the HPHC testing performed for two constituents on Batch 1, Replication 1 for the liquid matrix. The CAS number of the constituent is provided in PTCAS. | | Rows 3-5: | Show the HPHC testing performed for three constituents using the NON-INTENSE SMOKING REGIME for BATCH 1 and Replicate 1. | | Rows 6-7: | Show the HPHC testing performed for three constituents using the INTENSE SMOKING REGIME for BATCH 1 and Replicate 1. |
|
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPTOBID | SPDEVID | PTSEQ | PTREFID |
|---|
PTSPID |
| PTCAS | PTTESTCD | PTTEST | PTCAT | PTSCAT | PTORRES | PTORRESU | PTSTRESC | PTSTRESN | PTSTRESU | PTSPEC |
|---|
PTMETHOD | | PTREPNUM | PTDTC |
|---|
| 1 | TOB08 | PT | ENDS02a |
| 1 |
Batch 101??? -put batch here? |
|
| 75-07-0 | ACETALD | Acetaldehyde | HPHC TESTING | HPHC | 7.9 | µg/mL | 7.9 | 7.9 | µg/mL | E-LIQUID | 1 | 2022-09-30 | | 2 | TOB08 | PT | ENDS02a | PUFFMASTER3K | 2 |
Batch 101| Non-intense |
| 1954-11-05 | NIC | Nicotine | HPHC TESTING | HPHC | 53.5 | µg/puff | 53.5 | 53.5 | µg/puff | AEROSOL |
Non-intense | 1 | 2022-09-30 | | 3 | TOB08 | PT | ENDS02a | PUFFMASTER3K | 3 |
Batch 101| Non-intense |
| 75-07-0 | ACETALD | Acetaldehyde | HPHC TESTING | HPHC | 34.7 | ng/puff | 34.7 | 34.7 | ng/puff | AEROSOL |
Non-intense | 1 | 2022-09-30 | | 4 | TOB08 | PT | ENDS02a | PUFFMASTER3K | 4 |
Batch 101| Non-intense |
| 65-85-0 |
| Benzoic Acid | HPHC TESTING | Other | 43.3 | µg/puff | 43.3 | 43.3 | µg/puff | AEROSOL |
Non-intense | 1 | 2022-09-30 | | 5 | TOB08 | PT | ENDS02a | PUFFMASTER3K | 5 |
Batch 101| Intense |
| 1954-11-05 | NIC | Nicotine | HPHC TESTING | HPHC | 105 | µg/puff | 105 | 105 | µg/puff | AEROSOL |
Intense | 2 | 2022-09-30 | | 6 | TOB08 | PT | ENDS02a | PUFFMASTER3K | 6 |
Batch 101| Intense |
| 75-07-0 | ACETALD | Acetaldehyde | HPHC TESTING | HPHC | 43.5 | ng/puff | 43.5 | 43.5 | ng/puff | AEROSOL |
Intense | 2 | 2022-09-30 | | 7 | TOB08 | PT | ENDS02a | PUFFMASTER3K | 7 |
Batch 101| Intense |
| 65-85-0 |
| Benzoic Acid | HPHC TESTING | Other | 84.1 | µg/puff | 84.1 | 84.1 | µg/puff | AEROSOL |
Intense |
|
The identifying characteristics of the smoking machine are represented in the Device Identifiers reference dataset.
...
Details of the smoking regimen performed by the smoking machine are represented as device in-use properties, linked to the HPHC testing results in PT above by matching values of PTREFID/DUREFID = "Non-intense Regimen".
| Dataset wrap |
|---|
|
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPDEVID | DUSEQ | DUREFID | DUGRPID | DUTESTCD | DUTEST | DUORRES | DUORRESU | DUSTRESC | DUSTRESN | DUSTRESU |
|---|
| 1 | TOB07 | DU | PUFFMASTER3K | 1 | Non-intense Regimen |
| PUFFPROF | Puff Profile | SQUARE |
| SQUARE |
|
| | 2 | TOB07 | DU | PUFFMASTER3K | 2 | Non-intense Regimen |
| PUFFDUR | Puff Duration | 4.25 | sec | 4.25 | 4.25 | sec | | 3 | TOB07 | DU | PUFFMASTER3K | 3 | Non-intense Regimen |
| PUFFINT | Puff Interval | 3 | PUFF/min | 3 | 3 | PUFF/min | | 4 | TOB07 | DU | PUFFMASTER3K | 4 | Non-intense Regimen |
| PUFFBLCK | Puff Block | 25 | % | 25 | 25 | % | | 5 | TOB07 | DU | PUFFMASTER3K | 5 | Non-intense Regimen |
| NUMPUFF | Total Number of Puffs | 200 | PUFF | 200 | 200 | PUFF | | 6 | TOB07 | DU | PUFFMASTER3K | 6 | Non-intense Regimen |
| PUFFVOL | Puff Volume | 10 | mL | 10 | 10 | mL | | 7 | TOB07 | DU | PUFFMASTER3K | 7 | Non-intense Regimen |
| PUFFRNG | Puff Range | 100-200 |
| 100-200 |
|
| | 8 | TOB07 | DU | PUFFMASTER3K | 8 | Non-intense Regimen | 1 | PUFFPAUS | Puff Pause | 60 | s | 60 | 60 | s | | 9 | TOB07 | DU | PUFFMASTER3K | 9 | Non-intense Regimen | 1 | PUFFPINT | Puff Pause Interval | 10 | PUFF | 10 | 10 | PUFF | | 10 | TOB07 | DU | PUFFMASTER3K | 1 | Intense Regimen |
| PUFFPROF | Puff Profile | SQUARE |
| SQUARE |
|
| | 11 | TOB07 | DU | PUFFMASTER3K | 2 | Intense Regimen |
| PUFFDUR | Puff Duration | 4.25 | sec | 4.25 | 4.25 | sec | | 12 | TOB07 | DU | PUFFMASTER3K | 3 | Intense Regimen |
| PUFFINT | Puff Interval | 3 | PUFF/min | 3 | 3 | PUFF/min | | 13 | TOB07 | DU | PUFFMASTER3K | 4 | Intense Regimen |
| PUFFBLCK | Puff Block | 25 | % | 25 | 25 | % | | 14 | TOB07 | DU | PUFFMASTER3K | 5 | Intense Regimen |
| NUMPUFF | Total Number of Puffs | 300 | PUFF | 300 | 300 | PUFF | | 15 | TOB07 | DU | PUFFMASTER3K | 6 | Intense Regimen |
| PUFFVOL | Puff Volume | 10 | mL | 10 | 10 | mL | | 16 | TOB07 | DU | PUFFMASTER3K | 7 | Intense Regimen |
| PUFFRNG | Puff Range | 100-200 |
| 100-200 |
|
| | 17 | TOB07 | DU | PUFFMASTER3K | 8 | Intense Regimen | 1 | PUFFPAUS | Puff Pause | 10 | s | 10 | 10 | s | | 18 | TOB07 | DU | PUFFMASTER3K | 9 | Intense Regimen | 1 | PUFFPINT | Puff Pause Interval | 20 | PUFF | 20 | 20 | PUFF |
|
|