...
Dataset wrap |
---|
|
Rowcaps |
---|
Rows 1-14: | Show trial conditions that are common to all trial sets with the species S. typhimurium. Similar rows are present in each of the trial sets. | Row 10: | SPTOBID (Applicant-Defined Tobacco Product ID) is used to uniquely identify the tobacco product. The value of SPTOBID, in this case CIG01a, matches the value for SPTOBID in all the TOPARMCD-TOVAL pairs in the Tobacco Product Identifiers and Descriptors (TO) dataset example in Section 3.1.2, Product Design Parameters and Conformance Testing, Example 1. The TOPARMCD-TOVAL pairs identify this unique product, CIG01a. The TO domain is described in Section 2.8.8.1, Tobacco Product Identifiers and Descriptors (TO). | Row 13: | SPDEVID is the applicant-defined device identifier that is used to uniquely identify the device in the Unique Device Identification (DI) dataset (see also Section 2.8.9.7, SEND Device Identifiers (DI)). The value of SPDEVID, in this case PUFFMASTER3K, matches the value of SPDEVID in all the DIPARMCD-DIVAL pairs that identify this unique device in the DI dataset. This is shown in the DI dataset in Section 3.1.3.2, HPHCs, Other Constituents, and Smoking/Vaping Regimens, Example 1. | Row 14: | Shows a value for SMKRGM. SMKRGM serves as a link to the Device-In Use Properties (DU) domain (see also Section 2.8.9.8, SEND Device-In-Use (DU)), where a matching value of SMKRGM indicates parameters of the smoking regimen performed by the smoking machine, as in the DU dataset in Section 3.1.3.2, HPHCs, Other Constituents, and Smoking/Vaping Regimens, Example 2. | Rows | 15, 24, 33, 42:Show that SetA, SetF, SetG, and SetR each have a parent set code of SetSTM. As a child set of SetSTM, each of these sets inherit the test conditions of SetSTM. | Rows 15-231-22: | Show trial set parameters and trial set values that are the test conditions specific to set SetA which is the vehicle control (i.e., Strain of TA98, vehicle control with concentration value of 0). SetA is associated with the first row, labeled "SetA", in the report table for example study 8325064. Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-666 |
---|
|
| Rows | 243244: | Show trial set parameters and trial set values that comprise the test conditions for the set SetF which is the strain of TA98 with a concentration value of 500 µg/plate. SetF is associated with the sixth row, labeled "SetF", in the report table for example study 8325064. Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-667 |
---|
|
| Rows | 334166: | Show trial set parameters and trial set values that comprise the test conditions for the set SetG which is the | data for the strain of TA98 with a concentration value of 1600 µg/plate. SetG is associated with the seventh row, labeled "SetG", in the report table for example study 8325064. | Rows | 425088: | Show trial set parameters and trial set values that comprise the test conditions for the set SetR which is the | data for the strain of TA100, positive control with a concentration value of 2 µg/plate. SetR is associated with the eighteenth row, labeled "SetR", in the report table for example study 8325064. |
|
Dataset2 |
---|
Row | STUDYID | DOMAIN | SETCD | SET | TXSEQ | TXPARMCD | TXPARM | TXVAL |
---|
1 | 8325064 | TX | SetA | A-TA98-C0 | 1 | SPECIES | Species | SALMONELLA TYPHIMURIUM | 2 | 8325064 | TX | SetA | A-TA98-C0 | 2 | IVTDMIN | In vitro Treatment Duration Minimum | 71.5 | 3 | 8325064 | TX | SetA | A-TA98-C0 | 3 | IVTDTRG | In vitro Treatment Duration Target | 72 | 4 | 8325064 | TX | SetA | A-TA98-C0 | 4 | IVTDMAX | In vitro Treatment Duration Maximum | 72.5 | 5 | 8325064 | TX | SetA | A-TA98-C0 | 5 | IVTDU | In vitro Treatment Duration Unit | HOURS | 6 | 8325064 | TX | SetA | A-TA98-C0 | 6 | INCBTMP | Incubation Temperature | 37 | 7 | 8325064 | TX | SetA | A-TA98-C0 | 7 | INCBTMPU | Incubation Temperature Unit | C | 8 | 8325064 | TX | SetA | A-TA98-C0 | 8 | ATMRHP | Atmospheric Relative Humidity Percent | 50 | 9 | 8325064 | TX | SetA | A-TA98-C0 | 9 | ATMCO2P | Atmospheric CO2 Percent | 5 | 10 | 8325064 | TX | SetA | A-TA98-C0 | 10 | SPTOBID | Applicant-defined tobacco identifier | CIG01a | 11 | 8325064 | TX | SetA | A-TA98-C0 | 11 | EXPTYP | | Submerged | 12 | 8325064 | TX | SetA | A-TA98-C0 | 12 | SAMTYP | Sample Type | Total Particulate Matter in PBS | 13 | 8325064 | TX | SetA | A-TA98-C0 | 13 | SPDEVID | Applicant-defined device identifier | PUFFMASTER3K | 14 | 8325064 | TX | SetA | A-TA98-C0 | 14 | SMKRGM | Smoking Regimen | NON-INTENSE REGIMEN | 1516 | 16 | 8325064 | TX | SetA | A-TA98-C0 | 15 | | 15 | 8325064 | TX | SetA | A-TA98-C0 | 15 |
PSETCD | Parent Set Code | SetSTM | 17STRAIN | Strain/Substrain | TA98 |
17 | 16 | 8325064 | TX | SetA | A-TA98-C0 | 16 | METACTIND | Metabolic Activating Agent Name | NOT APPLICABLE | 1818 | 8325064 | TX | SetA | A-TA98-C0 | 17 | METACTFL | Presence of Metabolic Activation Flag | N | 1919 | 208325064 | TX | SetA | A-TA98-C0 | 18 | ITVNAM | Intervention Article Name | DMSO |
20 | 19 | 8325064 | TX | SetA | A-TA98-C0 | 19 | ITVTYPE | Intervention Article Type | VEHICLE | 2121 | 8325064 | TX | SetA | A-TA98-C0 | 20 | ITVCONC | Intervention Article Concentration | 100 | 2222 | 238325064 | TX | SetA | A-TA98-C0 | 21 | ITVCONCU | Intervention Article Concentration Unit | % |
23 | 22 | 8325064 | TX | SetA | A-TA98-C0 | 22 | TRTV | Treatment Vehicle | DMSO | 2423 | 8325064 | TX | SetF | F-TA98-C500 | 23 | SPECIES | Species | SALMONELLA TYPHIMURIUM | 2524 | 8325064 | TX | SetF | F-TA98-C500 | 24 | IVTDMIN | In vitro Treatment Duration Minimum | 71.5 | 2625 | 8325064 | TX | SetF | F-TA98-C500 | 25 | IVTDTRG | In vitro Treatment Duration Target | 72 | 2726 | 8325064 | TX | SetF | F-TA98-C500 | 26 | IVTDMAX | In vitro Treatment Duration Maximum | 72.5 | 2827 | 8325064 | TX | SetF | F-TA98-C500 | 27 | IVTDU | In vitro Treatment Duration Unit | HOURS | 2928 | 8325064 | TX | SetF | F-TA98-C500 | 28 | INCBTMP | Incubation Temperature | 37 | 3029 | 8325064 | TX | SetF | F-TA98-C500 | 29 | INCBTMPU | Incubation Temperature Unit | C | 3130 | 8325064 | TX | SetF | F-TA98-C500 | 30 | ATMRHP | Atmospheric Relative Humidity Percent | 50 | 3231 | 8325064 | TX | SetF | F-TA98-C500 | 31 | ATMCO2P | Atmospheric CO2 Percent | 5 | 3332 | 8325064 | TX | SetF | F-TA98-C500 | 32 | SPTOBID | Applicant-defined tobacco identifier | CIG01a | 3433 | 8325064 | TX | SetF | F-TA98-C500 | 33 | EXPTYP | | Submerged | 3534 | 8325064 | TX | SetF | F-TA98-C500 | 34 | SAMTYP | Sample Type | Total Particulate Matter in PBS | 3635 | 8325064 | TX | SetF | F-TA98-C500 | 35 | SPDEVID | Applicant-defined device identifier | PUFFMASTER3K | 372436 | 8325064 | TX | SetF | F-TA98-C500 | 36 | SMKRGM | Smoking Regimen | NON-INTENSE REGIMEN |
38 | 37 | 8325064 | TX | SetF | F-TA98-C500 | jirashowSummaryfalseserver | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-485 |
---|
TA98 | 38 | 8325064 | TX | SetF | F-TA98-C500 | 38 | METACTIND | Metabolic Activating |
23 | PSETCD | Parent Set Code | SetSTM | 39 | 25 | 8325064 | TX | SetF | F-TA98-C500 | 24 | STRAIN | Strain/Substrain | TA98 | 40 | 26 | 8325064 | TX | SetF | F-TA98-C500 | 25 | METACTIND | Metabolic Activating 2741 | 39 | 8325064 | TX | SetF | F-TA98-C500 | 2639 | METACTFL | Presence of Metabolic Activation Flag | N | 4228 | 272940 | ITVNAM | Intervention Article Name | TA1 |
43 | 41 | 8325064 | TX | SetF | F-TA98-C500 | 2841 | ITVTYPE | Intervention Article Type | PRODUCT | 4430 | 293142 | ITVCONC | Intervention Article Concentration | 500 |
45 | 43 | 8325064 | TX | SetF | F-TA98-C500 | 3043 | ITVCONCU | Intervention Article Concentration Unit | ug/plate | 46832506432 | 3144 | TRTV | Treatment Vehicle | DMSO | 4745 | 8325064 | TX | SetG | G-TA98-C1600 | 45 | SPECIES | Species | SALMONELLA TYPHIMURIUM | 4846 | 8325064 | TX | SetG | G-TA98-C1600 | 46 | IVTDMIN | In vitro Treatment Duration Minimum | 71.5 | 4947 | 8325064 | TX | SetG | G-TA98-C1600 | 47 | IVTDTRG | In vitro Treatment Duration Target | 72 | 5048 | 8325064 | TX | SetG | G-TA98-C1600 | 48 | IVTDMAX | In vitro Treatment Duration Maximum | 72.5 | 5149 | 8325064 | TX | SetG | G-TA98-C1600 | 49 | IVTDU | In vitro Treatment Duration Unit | HOURS | 5250 | 8325064 | TX | SetG | G-TA98-C1600 | 50 | INCBTMP | Incubation Temperature | 37 | 5351 | 8325064 | TX | SetG | G-TA98-C1600 | 51 | INCBTMPU | Incubation Temperature Unit | C | 5452 | 8325064 | TX | SetG | G-TA98-C1600 | 52 | ATMRHP | Atmospheric Relative Humidity Percent | 50 | 5553 | 8325064 | TX | SetG | G-TA98-C1600 | 53 | ATMCO2P | Atmospheric CO2 Percent | 5 | 5654 | 8325064 | TX | SetG | G-TA98-C1600 | 54 | SPTOBID | Applicant-defined tobacco identifier | CIG01a | 5755 | 8325064 | TX | SetG | G-TA98-C1600 | 55 | EXPTYP | | Submerged | 5856 | 8325064 | TX | SetG | G-TA98-C1600 | 56 | SAMTYP | Sample Type | Total Particulate Matter in PBS | 5957 | 8325064 | TX | SetG | G-TA98-C1600 | 57 | SPDEVID | Applicant-defined device identifier | PUFFMASTER3K | 6058 | 8325064 | TX | SetG | G-TA98-C1600 | 58 | SMKRGM | Smoking Regimen | NON-INTENSE REGIMEN | 6133 | 8325064 | TX | SetG | G-TA98-C1600 | 31PSETCD | Parent Set Code | SetSTM | STRAIN | Strain/Substrain | TA98 | 60 |
62 | 34 | 8325064 | TX | SetG | G-TA98-C1600 | 32STRAIN | Strain/Substrain | TA98 | 63 | 35 | 8325064 | TX | SetG | G-TA98-C1600 | 33 | METACTIND | Metabolic Activating Agent Name | NOT APPLICABLE | 6436 | 8325064 | TX | SetG | G-TA98-C1600 | 3461 | METACTFL | Presence of Metabolic Activation Flag | N | 6537 | 8325064 | TX | SetG | G-TA98-C1600 | 353862 | ITVNAM | Intervention Article Name | TA1 |
66 | 63 | 8325064 | TX | SetG | G-TA98-C1600 | 3663 | ITVTYPE | Intervention Article Type | Product | 6739 | 8325064 | TX | SetG | G-TA98-C1600 | 374064 | ITVCONC | Intervention Article Concentration | 1600 |
68 | 65 | 8325064 | TX | SetG | G-TA98-C1600 | 3865 | ITVCONCU | Intervention Article Concentration Unit | ug/plate | 6941 | 8325064 | TX | SetG | G-TA98-C1600 | 3966 | TRTV | Treatment Vehicle | DMSO | 7067 | 8325064 | TX | SetR | R-TA100-C2 | 67 | SPECIES | Species | SALMONELLA TYPHIMURIUM | 7168 | 8325064 | TX | SetR | R-TA100-C2 | 68 | IVTDMIN | In vitro Treatment Duration Minimum | 71.5 | 7269 | 8325064 | TX | SetR | R-TA100-C2 | 69 | IVTDTRG | In vitro Treatment Duration Target | 72 | 7370 | 8325064 | TX | SetR | R-TA100-C2 | 70 | IVTDMAX | In vitro Treatment Duration Maximum | 72.5 | 7471 | 8325064 | TX | SetR | R-TA100-C2 | 71 | IVTDU | In vitro Treatment Duration Unit | HOURS | 7572 | 8325064 | TX | SetR | R-TA100-C2 | 72 | INCBTMP | Incubation Temperature | 37 | 7673 | 8325064 | TX | SetR | R-TA100-C2 | 73 | INCBTMPU | Incubation Temperature Unit | C | 7774 | 8325064 | TX | SetR | R-TA100-C2 | 74 | ATMRHP | Atmospheric Relative Humidity Percent | 50 | 7875 | 8325064 | TX | SetR | R-TA100-C2 | 75 | ATMCO2P | Atmospheric CO2 Percent | 5 | 7976 | 8325064 | TX | SetR | R-TA100-C2 | 76 | SPTOBID | Applicant-defined tobacco identifier | CIG01a | 8077 | 8325064 | TX | SetR | R-TA100-C2 | 77 | EXPTYP | | Submerged | 8178 | 8325064 | TX | SetR | R-TA100-C2 | 78 | SAMTYP | Sample Type | Total Particulate Matter in PBS | 8279 | 8325064 | TX | SetR | R-TA100-C2 | 79 | SPDEVID | Applicant-defined device identifier | PUFFMASTER3K | 8380 | 8325064 | TX | SetR | R-TA100-C2 | 80 | SMKRGM | Smoking Regimen | NON-INTENSE REGIMEN | 8442 | 85 | 43 | 8325064 | TX | SetR | R-TA100-C2 | 40 | 39 | PSETCD | Parent Set Code | SetSTM | 44STRAIN | Strain/Substrain | TA100 |
86 | 82 | 8325064 | TX | SetR | R-TA100-C2 | 4182 | METACTIND | Metabolic Activating Agent Name | NOT APPLICABLE | 8745 | 424683 | METACTFL | Presence of Metabolic Activation Flag | N |
88 | 84 | 8325064 | TX | SetR | R-TA100-C2 | 4384 | ITVNAM | Intervention Article Name | NaN3 | 89832506447 | 4485 | ITVTYPE | Intervention Article Type | Positive Control | 9048 | 454986 | ITVCONC | Intervention Article Concentration | 2 |
91 | 87 | 8325064 | TX | SetR | R-TA100-C2 | 4687 | ITVCONCU | Intervention Article Concentration Unit | ug/plate | 9250 | 4788 | TRTV | Treatment Vehicle | DMSO |
|
|
REFID values are defined by the applicant to uniquely identify the observational unit within an experimental unit. In the simplified diagram of an assay procedure (below), the test tube that contains the possible mutagen is an example of an entity that would have a REFID indicating information at the level of trial set. The petri plate created from that test tube and used to count revertant numbers is an example of an entity that would be at an observational level.
...
Dataset wrap |
---|
|
Rowcaps |
---|
Row 1: | Shows the value of REFID=STM. This REFID refers to the trial set with a SETCD of "SetSTM" Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-489 |
---|
|
, as defined in the TX dataset. LEVEL=1 and LVLDESC="TRIAL SET" indicates this identifier relates to the entire trial set. | Rows 1, 2, 8, 12, 16: | Show that the trial set SetSTM is the parent of set codes SetA, SetF, SetG, and SetR. | Row 2: | Shows the value of REFID=A. This REFID refers to the trial set with a SETCD of "SetA", as defined in the TX dataset. LEVEL=2 and LVLDESC="EXPERIMENTAL UNIT/TRIAL SET". TRIAL SET indicates this identifier relates to the entire trial set. EXPERIMENTAL UNIT indicates this identifier received the intervention article, DMSO. | Rows 3-7: | Show the values of 5 observational units (1_1 through 1_5) that are within the parent experimental unit, REFID=A. | Row 8: | Shows the value of REFID=F. This REFID refers to the trial set with a SETCD of "SetF", as defined in the TX dataset. LEVEL=2 and LVLDESC="EXPERIMENTAL UNIT/TRIAL SET". TRIAL SET indicates this identifier relates to the entire trial set. EXPERIMENTAL UNIT indicates this identifier received the intervention article, TA1. | Rows 9-11: | Show the values of 3 observational units (6_1 through 6_3) that are within the parent experimental unit, REFID=F. | Row 12: | Shows the value of REFID=G. This REFID refers to the trial set with a SETCD of "SetG", as defined in the TX dataset. LEVEL=2 and LVLDESC="EXPERIMENTAL UNIT/TRIAL SET". TRIAL SET indicates this identifier relates to the entire trial set. EXPERIMENTAL UNIT indicates this identifier received the intervention article, TA1. | Rows 13-15: | Show the values of 3 observational units (7_1 through 7_3) that are within the parent experimental unit, REFID=G. | Row 16: | Shows the value of REFID=R. This REFID refers to the trial set with a SETCD of "SetG", as defined in the TX dataset. LEVEL=2 and LVLDESC="EXPERIMENTAL UNIT/TRIAL SET". TRIAL SET indicates this identifier relates to the entire trial set. EXPERIMENTAL UNIT indicates this identifier received the intervention article, NaN3. | Rows 17-19: | Show the values of 3 observational units (18_1 through 18_3) that are within the parent experimental unit, REFID=R. Jira |
---|
showSummary | false |
---|
server | Issue Tracker (JIRA) |
---|
serverId | 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 |
---|
key | TOBA-668 |
---|
|
|
|
Dataset2 |
---|
| OLD TABLE (prior to flattening Parent/Child in TX dataset) When this table is removed, remove SetSTM from TX. Row | STUDYID | SETCD | REFID | PARENT | LEVEL | LVLDESC |
---|
1 | 8325064 | SetSTM | STM | 1 | TRIAL SET |
---|
2 | 8325064 | SetA | A | STM | 2 | EXPERIMENTAL UNIT/TRIAL SET |
---|
3 | 8325064 | SetA | 1_1 | A | 3 | OBSERVATIONAL UNIT |
---|
4 | 8325064 | SetA | 1_2 | A | 3 | OBSERVATIONAL UNIT |
---|
5 | 8325064 | SetA | 1_3 | A | 3 | OBSERVATIONAL UNIT |
---|
6 | 8325064 | SetA | 1_4 | A | 3 | OBSERVATIONAL UNIT |
---|
7 | 8325064 | SetA | 1_5 | A | 3 | OBSERVATIONAL UNIT |
---|
8 | 8325064 | SetF | F | STM | 2 | EXPERIMENTAL UNIT/TRIAL SET |
---|
9 | 8325064 | SetF | 6_1 | F | 3 | OBSERVATIONAL UNIT |
---|
10 | 8325064 | SetF | 6_2 | F | 3 | OBSERVATIONAL UNIT |
---|
11 | 8325064 | SetF | 6_3 | F | 3 | OBSERVATIONAL UNIT |
---|
12 | 8325064 | SetG | G | STM | 2 | EXPERIMENTAL UNIT/TRIAL SET |
---|
13 | 8325064 | SetG | 7_1 | G | 3 | OBSERVATIONAL UNIT |
---|
14 | 8325064 | SetG | 7_2 | G | 3 | OBSERVATIONAL UNIT | 15 | 8325064 | SetG | 7_3 | G | 3 | OBSERVATIONAL UNIT | 16 | 8325064 | SetG | R | STM | 2 | EXPERIMENTAL UNIT/TRIAL SET | 17 | 8325064 | SetR | 18_1 | R | 3 | OBSERVATIONAL UNIT | 18 | 8325064 | SetR | 18_2 | R | 3 | OBSERVATIONAL UNIT | 19 | 8325064 | SetR | 18_3 | R | 3 | OBSERVATIONAL UNIT | NEW (remain AFTER we flatten TX dataset) | Row | STUDYID | SETCD | REFID | PARENT | LEVEL | LVLDESC |
---|
1 | 8325064 | SetA | A |
| 1 | EXPERIMENTAL UNIT/TRIAL SET |
---|
2 | 8325064 | SetA | 1_1 | A | 2 | OBSERVATIONAL UNIT |
---|
3 | 8325064 | SetA | 1_2 | A | 2 | OBSERVATIONAL UNIT |
---|
4 | 8325064 | SetA | 1_3 | A | 2 | OBSERVATIONAL UNIT |
---|
5 | 8325064 | SetA | 1_4 | A | 2 | OBSERVATIONAL UNIT |
---|
6 | 8325064 | SetA | 1_5 | A | 2 | OBSERVATIONAL UNIT |
---|
7 | 8325064 | SetF | F |
| 1 | EXPERIMENTAL UNIT/TRIAL SET |
---|
8 | 8325064 | SetF | 6_1 | F | 2 | OBSERVATIONAL UNIT |
---|
9 | 8325064 | SetF | 6_2 | F | 2 | OBSERVATIONAL UNIT |
---|
10 | 8325064 | SetF | 6_3 | F | 2 | OBSERVATIONAL UNIT |
---|
11 | 8325064 | SetG | G |
| 1 | EXPERIMENTAL UNIT/TRIAL SET |
---|
12 | 8325064 | SetG | 7_1 | G | 2 | OBSERVATIONAL UNIT |
---|
13 | 8325064 | SetG | 7_2 | G | 2 | OBSERVATIONAL UNIT |
---|
14 | 8325064 | SetG | 7_3 | G | 2 | OBSERVATIONAL UNIT | 15 | 8325064 | SetG | R |
| 1 | EXPERIMENTAL UNIT/TRIAL SET | 16 | 8325064 | SetR | 18_1 | R | 2 | OBSERVATIONAL UNIT | 17 | 8325064 | SetR | 18_2 | R | 2 | OBSERVATIONAL UNIT | 18 | 8325064 | SetR | 18_3 | R | 2 | OBSERVATIONAL UNIT |
|
|
...