...
The initial table shows the all a number of the analytes and test conditions used in Shelf Life studies for tobacco products for one testing condition at one timepoint and one replicate.
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Row 1: | Shows the LBTEST of Product Moisture which reflects the percentage of moisture in the substance for the condition noted in LBTSTCND which is Condition 1 (X°C/ Z% RH). Product Moisture is sometimes referred to as "Oven Volatiles". | | Rows 2-12: | Show the analytes used in testing. | |
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | LBSEQ | LBREFID | LBSPID | LBTESTCD | LBTEST | LBTSTCND | LBORRES | LBORRESU | LBSTRESC | LBSTRESN | LBSTRESU | LBMETHOD | LBANMETH | LBTMTHSN | LBSTNRC | LBREPNUM | LBTPT | LBTPTNUM |
|---|
| 1 | TOB07 | LB | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 1 | Week 1 | 1 | | 2 | TOB08 | LB | 2 |
|
|
| pH | Condition 1 (X°C/ Z% RH) |
|
|
|
|
|
|
|
|
| 1 | Week 1 | 1 | | 3 | TOB09 | LB | 3 |
|
|
| Water Activity | Condition 1 (X°C/ Z% RH) |
|
|
|
|
|
|
|
|
| 1 | Week 1 | 1 | | 4 | TOB10 | LB | 4 |
|
|
| NNK-as is | Condition 1 (X°C/ Z% RH) |
| ng/g |
|
| ng/g |
|
|
|
| 1 | Week 1 | 1 | | 5 | TOB11 | LB | 5 |
|
|
| NNK-DWB* | Condition 1 (X°C/ Z% RH) |
| ng/g |
|
| ng/g |
|
|
|
| 1 | Week 1 | 1 | | 6 | TOB12 | LB | 6 |
|
|
| NNN-as is | Condition 1 (X°C/ Z% RH) |
| ng/g |
|
| ng/g |
|
|
|
| 1 | Week 1 | 1 | | 7 | TOB13 | LB | 7 |
|
|
| NNK-DWB | Condition 1 (X°C/ Z% RH) |
| ng/g |
|
| ng/g |
|
|
|
| 1 | Week 1 | 1 | | 8 | TOB14 | LB | 8 |
|
|
| TSNA -as is | Condition 1 (X°C/ Z% RH) |
| ng/g |
|
| ng/g |
|
|
|
| 1 | Week 1 | 1 | | 9 | TOB15 | LB | 9 |
|
|
| TSNA -DWB | Condition 1 (X°C/ Z% RH) |
| ng/g |
|
| ng/g |
|
|
|
| 1 | Week 1 | 1 | | 10 | TOB16 | LB | 10 |
|
|
| Aerobic Plate Count | Condition 1 (X°C/ Z% RH) |
|
|
|
|
|
|
|
|
| 1 | Week 1 | 1 | | 11 | TOB17 | LB | 11 |
|
|
| Mold | Condition 1 (X°C/ Z% RH) |
|
|
|
|
|
|
|
|
| 1 | Week 1 | 1 | | 12 | TOB18 | LB | 12 |
|
|
| Yeast | Condition 1 (X°C/ Z% RH) |
|
|
|
|
|
|
|
|
| 1 | Week 1 | 1 |
|
|
...
Make sure LOQ is in the dataset - it is important.
The shelf life A Shelf Life study dataset would shows analytes done over in different test conditions with replicates over time points. In the interest of brevity in an for this example, this only shows the moistureonly Product Moisture (also known as Oven Volatile) percentage is shown in a sample of timepoints in two conditions with replicates.
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Rows 1-9: | Show the LBTEST of Product Moisture for Condition 1 (X°C/ Z% RH) which is shown in LBTSTCND. The sample of various timepoints that may be used in the testing for product moisture is reflected in LBTPT. The LBTPTNUM shows the numerical version of the planned timepoint. The REPNUM shows the incidence number of a test that is repeated within a given timeframe for the same test. | | Rows 10-18: | Show the LBTEST of Product Moisture for Condition 2 Condition 2 (A °C/ B %RH) across the same timepoints shown for Condition 1. The LBGRPID is used to tie together a block of related records in a single domain. | |
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | LBSEQ | LBGRPID | LBREFID | LBSPID | LBTESTCD | LBTEST | LBTSTCND | LBORRES | LBORRESU | LBSTRESC | LBSTRESN | LBSTRESU | LBMETHOD | LBANMETH | LBTMTHSN | LBSTNRC | LBREPNUM | LBTPT | LBTPTNUM |
|---|
| 1 | TOB07 | LB | 1 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 1 | Week 0 | 1 | | 2 | TOB07 | LB | 2 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 2 | Week 0 | 1 | | 3 | TOB07 | LB | 3 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 3 | Week 0 | 1 | | 4 | TOB07 | LB | 4 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 1 | Week 8 | 4 | | 5 | TOB07 | LB | 5 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 2 | Week 8 | 4 | | 6 | TOB07 | LB | 6 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 3 | Week 8 | 4 | | 7 | TOB07 | LB | 7 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 1 | Week 48 | 9 | | 8 | TOB07 | LB | 8 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 2 | Week 48 | 9 | | 9 | TOB07 | LB | 9 | 1 |
|
|
| Product Moisture | Condition 1 (X°C/ Z% RH) |
| % |
|
| % |
|
|
|
| 3 | Week 48 | 9 | | 10 | TOB07 | LB | 10 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 1 | Week 0 | 1 | | 11 | TOB07 | LB | 11 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 2 | Week 0 | 1 | | 12 | TOB07 | LB | 12 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 3 | Week 0 | 1 | | 13 | TOB07 | LB | 13 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 1 | Week 8 | 4 | | 14 | TOB07 | LB | 14 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 2 | Week 8 | 4 | | 15 | TOB07 | LB | 15 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 3 | Week 8 | 4 | | 16 | TOB07 | LB | 16 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 1 | Week 48 | 9 | | 17 | TOB07 | LB | 17 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 2 | Week 48 | 9 | | 18 | TOB07 | LB | 18 | 2 |
|
|
| Product Moisture | Condition 2 (A °C/ B %RH) |
| % |
|
| % |
|
|
|
| 3 | Week 48 | 9 |
|
|