You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

NOTE TO TEAM REVIEWERS:

The example below demonstrates the required data structure of one record per analyte per replicate per test condition per timepoint to accurately represent data from a stability study.
The resulting structure would require 648 rows to illustrate the 12 analytes shown in the example study we received, done in triplicate under two test conditions at the number of timepoints in the example study.

For conciseness, we have abbreviated the examples below to demonstrate the concepts as follows:

First- we show all 12 analytes as a single replicate, at one time point and one test condition in order to illustrate the variables and terminology required to put together a stability study with assays  done in replicate at different time points and varying test conditions, even though only one record per analyte is illustrated.

Second- We show ONE analyte (moisture) in triplicate, over a series of time points and two test conditions to give a sense of what the complete data would look like.

Hopefully users could combine the information shown in both examples to construct a complete dataset containing all the records for each analyte-replicate-test condition-time point group.

Tobacco domains

DI = TO for Tobacco Product Identifiers and Descriptors

SPDEVID = SPTOBID for Sponsor Tobacco Product Identifier

DO/DU = Tobacco Product Design Parameters (PD)

LB = Tobacco Product Testing (PT) - [Would Findings be better?]


Shelf life study has a protocol and provides the results of shelf life studies of Vapes products over time with different conditions and analytes.  Generally there are many conditions with at least two with varying temperature, humidity, etc.

The initial table shows the a number of the analytes and test conditions used in Shelf Life studies for Vapes products for one testing condition at one timepoint and one replicate.


Tobacco Product Testing (TT) is a Findings domain similar to the Laboratory Test Results domain.


Rows 1-12:Shows several analytes (as noted in the PTTEST) in the E-Liquid substance for the condition noted in PTTSTCND which is E-Liquid Standard (Long Term) Condition.
Row 13:Show microbials used in testing (aerobic plate count, mold, and yeast) using the PTTEST and PTTESTCD variable in the E-Liquid substance for the condition noted in PTTSTCND which is E-Liquid Standard (Long Term) Condition.

Row Captions Debug Message

Remember to keep number agreement between labels and captions.

pt.xpt

pt.xpt

RowSTUDYIDDOMAINPTSEQPTREFIDSPTOBIDPTTESTCDPTTESTPTCATPTSCATPTTSTCNDPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTSPECPTSPCCNDPTMETHODPTLLOQPTREPNUMPTTPTPTTPTNUM
1TOB07PT

1

VAP77777.1111NICNicotineSTABILITY STUDY
E-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
2TOB07PT2VAP77777.1111XXXXX

Nornicotine


STABILITY STUDYNicotine DegredantE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
3TOB07PT3VAP77777.1111XXXXX

Anabasine


STABILITY STUDYNicotine DegredantE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
4TOB07PT4VAP77777.1111XXXXXGlycerolSTABILITY STUDYPrimary IngredientE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
5TOB07PT5VAP77777.1111XXXXXPropylene GlycolSTABILITY STUDYPrimary IngredientE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
6TOB07PT6VAP77777.1111XXXXXBenzoic AcidSTABILITY STUDYOrganic compoundsE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
7TOB07PT7VAP77777.1111 RXNReaction ProductSTABILITY STUDYOrganic compoundsE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
8TOB07PT8VAP77777.1111XXXXXMenthol
STABILITY STUDYFlavorantE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
9TOB07PT9VAP77777.1111XXXXXVanillin
STABILITY STUDYFlavorantE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
10TOB07PT10VAP77777.1111XXXXXX

Nicotine salt solution

STABILITY STUDYFlavorantE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
11TOB07PT11VAP77777.1111NNK4-(N-methyl-N-nitrosoamino)-1-(3-pyridyl)-1-butanone (NNK)STABILITY STUDYHPHCE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
12TOB07PT12VAP77777.1111NNNN-nitrosonornicotineSTABILITY STUDYHPHCE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
13TOB07PT13VAP77777.1111XXXXXMetals - NickelSTABILITY STUDYExtractables / Leachables E-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
14TOB07PT14VAP77777.1111XXXXXAntioxidantsSTABILITY STUDYExtractables / Leachables E-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
15TOB07PT15VAP77777.1111XXXXXNon targeted compoundsSTABILITY STUDY
E-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
16TOB07PT16VAP77777.1111XXXXXPotential Combustion ProductsSTABILITY STUDY
E-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
17TOB07PT17VAP77777.1111PHpHSTABILITY STUDY
E-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
18TOB07PT18VAP77777.1111XXXXXEndotoxinSTABILITY STUDYToxinsE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
19TOB07PT19VAP77777.1111XXXXXTAMCSTABILITY STUDYMicrobiologicalE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
20TOB07PT20VAP77777.1111XXXXXTYMCSTABILITY STUDYMicrobiologicalE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01

Dataset Debug Messages

  • There are three leading, trailing, or non-breaking spaces in the dataset.
  • Please remove all paragraph and/or line breaks.
  • Please remove all formatting (see How to Clear Formatting).

Dataset Wrapper Debug Message

Please add a row column to your dataset.

*DWB=Dry weight basis. The DWB normalizes the results since starting moisture may vary.


A Shelf Life study dataset would shows analytes done in different test conditions with replicates over time points.  In the interest of brevity for this example, only portions of the content using the TEST of Nicotine is shown in a sample of timepoints in two conditions with replicates. The weeks reflective of Week 1,  Week 2, Week 3, etc. which would align with the PTTPTNUM of 2,3, etc. are not shown for visual viewing purposes. This is an example, this provides possible tests that might be used to demonstrate how to use the datasets and variables to show what was done for the shelf-life stability study. It shows what timepoint and what type of data follows. It is important to show different test conditions for each analyte. For aerosol a machine similutaion is use so mg/cartridge is valid.

Rows 1-9:Show the PTTEST of Nicotine for E-Liquid Standard (Long Term) Condition which is shown in PTTSTCND. The sample of various timepoints that may be used in the testing for Nicotine is reflected in PTTPT. The PTTPTNUM 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-19:Show the PTTEST of Nicotine for E-Vapor Standard Aerosol Condition across the same timepoints. The PTGRPID is used to tie together a block of related records in a single domain.
Rows 20-27:Show the PTTEST of Nicotine for E-Vapor Intense Aerosol Condition across the same timepoints. The PTGRPID is used to tie together a block of related records in a single domain.

pt.xpt

pt.xpt

Row

STUDYID

DOMAINPTSEQPTREFIDPTGRPIDPTTESTCDPTTESTPTTSTCNDPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTSPECPTSPCCNDPTMETHODPTREPNUMPTTPTPTTPTNUM
1TOB07PT211VAP77777.11NIC

Nicotine

E-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

1Week 01
2TOB07PT212VAP77777.11

NIC

NicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

2Week 01
3TOB07PT213VAP77777.11NICNicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

3Week 01
4TOB07PT214VAP77777.11NICNicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

1Week 244
5TOB07PT215VAP77777.11NICNicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

2Week 244
6TOB07PT216VAP77777.11NICNicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

3Week 244
7TOB07PT217VAP77777.11NICNicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

1Week 529
8TOB07PT218VAP77777.11NICNicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

2Week 529
9TOB07PT219VAP77777.11NICNicotineE-Liquid Standard (Long Term) Condition
mg/mL

mg/mLE-LIQUID

3Week 529
10TOB07PT220VAP77777.13NIC

Nicotine

E-Vapor Standard Aerosol Condition
mg/cartridge

mg/puffE-LIQUID

1Week 01
11TOB07PT221VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

2Week 01
12TOB07PT222VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

3Week 01
13TOB07PT223VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

1Week 244
14TOB07PT224VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

2Week 244
15TOB07PT225VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

3Week 244
16TOB07PT226VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

1Week 529
17TOB07PT227VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

2Week 529
18TOB07PT228VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

3Week 529
19TOB07PT229VAP77777.13NICNicotineE-Vapor Standard Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

1Week 01
20TOB07PT230VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

2Week 01
21TOB07PT231VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

3Week 01
22TOB07PT232VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

1Week 244
23TOB07PT233VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

2Week 244
24TOB07PT234VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

3Week 244
25TOB07PT235VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

1Week 529
26TOB07PT236VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

2Week 529
27TOB07PT237VAP77777.14NICNicotineE-Vapor Intense Aerosol Condition
mg/cartridge

mg/cartridgeE-LIQUID

3Week 529
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

  • No labels