Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Dataset wrap
Namept
Rowcaps
Row 1:Shows the PTTEST of Nicotine which reflects the percentage of nicotine in the E-Liquid substance for the condition noted in PTTSTCND which is E-Liquid Standard (Long Term) Condition. 
Rows 2, 3:Shows the  pH and Water Activity with the E-Liquid substance for the condition noted in PTTSTCND which is E-Liquid Standard (Long Term) Condition. 
Rows 4, 5, 6:Shows the NNK, NNN, and TSN tests in the E-Liquid substance for the condition noted in PTTSTCND which is E-Liquid Standard (Long Term) Condition. 
Rows 7 - 9:Show the other analytes used in testing (aerobic plate count, mold, and yeast) using the PTTEST and PTTESTCD variables.
Dataset2
RowSTUDYIDDOMAINPTSEQPTREFIDSPTOBIDPTTESTCDPTTESTPTCATPTTSTCNDPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTSPECPTSPCCNDPTMETHODPTLLOQPTREPNUMPTTPTPTTPTNUM
1TOB07PT1VAP77777.1111XXXXXNicotineSTABILITY STUDYE-Liquid Standard (Long Term) Condition%%




E-LIQUID


1Week 01
2TOB07PT2VAP77777.1PH111
pH

Nicotine Degredants

STABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
3TOB07PT3VAP77777.1H2OACT111
Primary Ingredients - Gly / PGWater ActivitySTABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
4TOB07PT4VAP77777.1111
Organic compounds - i.e. acids or RXNSTABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
5TOB07PT6VAP77777.1111
FlavorantSTABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
6TOB07PT8VAP77777.1111
HPHCSTABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
7TOB07PT10VAP77777.1111
Extractables / Leachables STABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
8TOB07PT11VAP77777.1111
Non targeted compoundsNNK4-(N-methyl-N-nitrosoamino)-1-(3-pyridyl)-1-butanone (NNK)STABILITY STUDYE-Liquid Standard (Long Term) Conditionng/gng/g




E-LIQUID


1Week 01
59TOB07PT612VAP77777.1NNN111
Potential Combustion ProductsN-nitrosonornicotineSTABILITY STUDYE-Liquid Standard (Long Term) Conditionng/gng/g




E-LIQUID


1Week 01
610TOB07PT812VAP77777.1TSNA111
Cigarette ReferenceTobacco-specific nitrosaminesSTABILITY STUDYE-Liquid Standard (Long Term) Conditionng/gng/g




E-LIQUID


1Week 01
711TOB07PT1012VAP77777.1AEBPLCT111
aerosol massAerobic Plate CountSTABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
812TOB07PT1112VAP77777.1MOLD111
MoldpHSTABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01
913TOB07PT12VAP77777.1YEAST111
YeastmicrobiologicalSTABILITY STUDYE-Liquid Standard (Long Term) Condition




E-LIQUID


1Week 01

...

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 Potential Combustion Products and Microbial percentage 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.

Dataset wrap
Namept
Rowcaps
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-18:Show the PTTEST of Nicotine for E-Liquid Accelerated Aging Condition across the same timepoints.  The PTGRPID is used to tie together a block of related records in a single domain.
Rows 19-28:Show the PTTEST of MIcrobiological 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 29-36:Show the PTTEST of MIcrobiological 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.
Dataset2
Row

STUDYID

DOMAINPTSEQPTREFIDPTTESTCDPTTESTPTTSTCNDPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTSPECPTSPCCNDPTMETHODPTREPNUMPTTPTPTTPTNUM
1TOB07PT211VAP77777.1XXXXX

Nicotine

E-Liquid Standard (Long Term) Condition
%

%E-LIQUID

1Week 01
2TOB07PT212VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

2Week 01
3TOB07PT213VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

3Week 01
4TOB07PT214VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

1Week 84
5TOB07PT215VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

2Week 84
6TOB07PT216VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

3Week 84
7TOB07PT217VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

1Week 489
8TOB07PT218VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

2Week 489
9TOB07PT219VAP77777.1XXXXXPotential Combustion ProductsNicotineE-Liquid Standard (Long Term) Condition
%

%E-LIQUID

3Week 489
10TOB07PT220VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

1Week 01
11TOB07PT221VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

2Week 01
12TOB07PT222VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

3Week 01
13TOB07PT223VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

1Week 84
14TOB07PT224VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

2Week 84
15TOB07PT225VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

3Week 84
16TOB07PT226VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

1Week 489
17TOB07PT227VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

2Week 489
18TOB07PT228VAP77777.1YYYYYYXXXXXPotential Combustion ProductsNicotineE-Liquid Accelerated Aging Condition
%

%E-LIQUID

3Week 489
19TOB07PT229VAP77777.1AAAAAXXXXXMicrobiological

Nicotine

E-Vapor Standard Aerosol Condition
%

%E-LIQUID

1Week 01
20TOB07PT230VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

2Week 01
21TOB07PT231VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

3Week 01
22TOB07PT232VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

1Week 84
23TOB07PT233VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

2Week 84
24TOB07PT234VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

3Week 84
25TOB07PT235VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

1Week 489
26TOB07PT236VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

2Week 489
27TOB07PT237VAP77777.1AAAAAXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

3Week 489
28TOB07PT238VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Standard Aerosol Condition
%

%E-LIQUID

1Week 01
29TOB07PT239VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

2Week 01
30TOB07PT240VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

3Week 01
31TOB07PT241VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

1Week 84
32TOB07PT242VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

2Week 84
33TOB07PT243VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

3Week 84
34TOB07PT244VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

1Week 489
35TOB07PT245VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

2Week 489
36TOB07PT246VAP77777.1BBBBBBXXXXXMicrobiologicalNicotineE-Vapor Intense Aerosol Condition
%

%E-LIQUID

3Week 489