Versions Compared

Key

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

...

Dataset wrap
Namept
Rowcaps
Row 1:Shows the PTTEST of Product Moisture which reflects the percentage of moisture in the substance for the condition noted in PTTSTCND STOCONID which is Condition 1.  Product Moisture is sometimes referred to as "Oven Volatiles".
Rows 4, 6, 8:Show the NNK, NNN, and TSN tests with the tobacco product "AS-IS" using the PTSPCCND to show that the tobacco is "FRESH".
Rows 5, 7, 9:Show the NNK, NNN, and TSN tests with the tobacco product as "DRY WEIGHT BASIS" (DWB) using the PTSPCCND to show that the tobacco is "DRIED".
Rows 2-1211:Show the other analytes used in testing (pH, water activity, NNK, NNN, TSNA, etc.) using the PTTEST and PTTESTCD variables.
Dataset2
RowSTUDYIDDOMAINSPTOBIDSTOCONIDPTSEQPTREFIDPTTESTCDPTTESTPTCATPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTSPECPTSPCCNDPTMETHODPTLLOQPTREPNUMPTTPTPTTPTNUM
1TOB07PTSmokeless01Condition 11TOB77777.1PRODMSTProduct MoistureSTABILITY STUDY52.0%52.052.0%TOBACCO


1Week 01
2TOB07PTSmokeless01Condition 12TOB77777.1PHpHSTABILITY STUDY8.06
8.068.06
TOBACCO


1Week 01
3TOB07PTSmokeless01Condition 13TOB77777.1H2OACTWater ActivitySTABILITY STUDY0.86
0.860.86
TOBACCO


1Week 01
4TOB07PTSmokeless01Condition 14TOB77777.1NNKNicotine-Derived Nitrosamine KetoneSTABILITY STUDY1.0225ug/g1.02251.0225ug/gTOBACCO, FRESHAS-IS

1Week 01
5TOB07PTSmokeless01Condition 15TOB77777.1NNKNicotine-Derived Nitrosamine KetoneSTABILITY STUDY0.4908ug/g0.49080.4908ug/gTOBACCO, DRIEDDRY WEIGHT

1Week 01
6TOB07PTSmokeless01Condition 16TOB77777.1NNNN-NitrosonornicotineSTABILITY STUDY4.4633ug/g4.46334.4633ug/gTOBACCO, FRESHAS-IS

1Week 01
7TOB07PTSmokeless01Condition 17TOB77777.1NNNN-NitrosonornicotineSTABILITY STUDY2.1424ug/g2.14242.1424ug/gTOBACCO, DRIEDDRY WEIGHT

1Week 01
10TOB07PTSmokeless01Condition 18TOB77777.1AEBPLCTAerobic Plate CountSTABILITY STUDY154000CFU/g154000154000CFU/gTOBACCO


1Week 01
11TOB07PTSmokeless01Condition 19TOB77777.1TYMCTotal Yeast and/or Mold CountSTABILITY STUDY<10CFU/g<10<10CFU/gTOBACCO


1Week 01

...

Dataset wrap
Namept
Rowcaps
Rows 1-9:Show the PTTEST of Product Moisture for Condition 1 which is shown in PTTSTCNDSTOCONID. The sample of various timepoints that may be used in the testing for product moisture 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 Product Moisture for Condition 2 across the same timepoints shown for Condition 1.  The PTGRPID is used to tie together a block of related records in a single domain.
Dataset2
RowSTUDYIDDOMAINSPTOBIDSTOCONIDPTSEQPTREFIDPTTESTCDPTTESTPTORRESPTORRESUPTSTRESCPTSTRESNPTSTRESUPTSPECPTSPCCNDPTMETHODPTREPNUMPTTPTPTTPTNUM
1TOB07PTSmokeless01Condition 1111TOB77777.1PRODMSTProduct Moisture51.93%51.9351.93%TOBACCOAS-IS
1Week 01
2TOB07PTSmokeless01Condition 1112TOB77777.1PRODMSTProduct Moisture51.96%51.9651.96%TOBACCOAS-IS
2Week 01
3TOB07PTSmokeless01Condition 1113TOB77777.1PRODMSTProduct Moisture51.98%51.9851.98%TOBACCOAS-IS
3Week 01
4TOB07PTSmokeless01Condition 1114TOB77777.1PRODMSTProduct Moisture51.75%51.7551.75%TOBACCOAS-IS
1Week 84
5TOB07PTSmokeless01Condition 1115TOB77777.1PRODMSTProduct Moisture51.75%51.7551.75%TOBACCOAS-IS
2Week 84
6TOB07PTSmokeless01Condition 1116TOB77777.1PRODMSTProduct Moisture51.67%51.6751.67%TOBACCOAS-IS
3Week 84
7TOB07PTSmokeless01Condition 1117TOB77777.1PRODMSTProduct Moisture52.05%52.0552.05%TOBACCOAS-IS
1Week 489
8TOB07PTSmokeless01Condition 1118TOB77777.1PRODMSTProduct Moisture52.68%52.6852.68%TOBACCOAS-IS
2Week 489
9TOB07PTSmokeless01Condition 1119TOB77777.1PRODMSTProduct Moisture52.21%52.2152.21%TOBACCOAS-IS
3Week 489
10TOB07PTSmokeless01Condition 2120TOB77777.1PRODMSTProduct Moisture51.93%51.9351.93%TOBACCOAS-IS
1Week 01
11TOB07PTSmokeless01Condition 2121TOB77777.1PRODMSTProduct Moisture51.96%51.9651.96%TOBACCOAS-IS
2Week 01
12TOB07PTSmokeless01Condition 2122TOB77777.1PRODMSTProduct Moisture51.98%51.9851.98%TOBACCOAS-IS
3Week 01
13TOB07PTSmokeless01Condition 2123TOB77777.1PRODMSTProduct Moisture51.80%51.8051.80%TOBACCOAS-IS
1Week 84
14TOB07PTSmokeless01Condition 2124TOB77777.1PRODMSTProduct Moisture51.77%51.7751.77%TOBACCOAS-IS
2Week 84
15TOB07PTSmokeless01Condition 2125TOB77777.1PRODMSTProduct Moisture51.84%51.8451.84%TOBACCOAS-IS
3Week 84
16TOB07PTSmokeless01Condition 2126TOB77777.1PRODMSTProduct Moisture52.18%52.1852.18%TOBACCOAS-IS
1Week 489
17TOB07PTSmokeless01Condition 2127TOB77777.1PRODMSTProduct Moisture52.21%52.2152.21%TOBACCOAS-IS
2Week 489
18TOB07PTSmokeless01Condition 2128TOB77777.1PRODMSTProduct Moisture51.87%51.8751.87%TOBACCOAS-IS
3Week 489

...