recreate the data table - clean up, add "S" to the first set A
move assumptions out of all of the examples
add row captions to highlight exceptions/assumptions
This is an example showing trial design and results from the in vitro bacterial reverse mutation test of Study #8325064.
The bacterial reverse mutation test uses amino acid-requiring strains of Salmonella typhimurium (S. typhimurium) and Escherichia coli (E. coli) to detect point mutations, which involve substitution, addition or deletion of one or a few DNA base pairs. The principle of this bacterial reverse mutation test is that it detects chemicals that induce mutations which revert mutations present in the tester strains and restore the functional capability of the bacteria to synthesize an essential amino acid. The revertant bacteria are detected by their ability to grow in the absence of the amino acid required by the parent tester strain.
Assumption: When the experimental unit is derived from the species and strain, such as a cell line, then TESTSYS should be supplied.
Row
STUDYID
ASSAYID
DOMAIN
TSSEQ
TSGRPID
TSPARMCD
TSPARM
TSVAL
TSVALNF
1
8325064
Ames
TS
1
GLPTYP
Good Laboratory Practice Type
FDA
2
8325064
Ames
TS
2
GLPTYP
Good Laboratory Practice Type
OECD
3
8325064
Ames
TS
1
STSTDTC
Study Start Date
2015-07-29
4
8325064
Ames
TS
1
STITLE
Study Title
The Bacterial Reverse Mutation Test, Study 8325064-1
5
8325064
Ames
TS
1
SNDIGVER
SEND Implementation Guide Version
TOBACCO IMPLEMENTATION GUIDE VERSION 1.0
6
8325064
Ames
TS
1
SNDCTVER
SEND Controlled Terminology Version
SEND Terminology 2021-09-30
7
8325064
Ames
TS
1
SSPONSOR
Sponsor Organization
Example Sponsor Inc.
8
8325064
Ames
TS
1
SPREFID
Sponsor's Study Reference ID
NOT APPLICABLE
9
8325064
Ames
TS
1
1
TSTFNAM
Test Facility Name
Example Tox Lab Name
10
8325064
Ames
TS
1
1
TSTFLOC
Test Facility Location
10 Somewhere Street, Montgomery, AL 10000
11
8325064
Ames
TS
1
1
TFCNTRY
Test Facility Country
USA
12
8325064
Ames
TS
1
1
STDIR
Study Director
Dr. R. Smith
13
8325064
Ames
TS
1
GLPFL
GLP Flag
N
14
8325064
Ames
TS
1
ASTD
Assay Standard
OECD Test No. 471
15
8325064
Ames
TS
1
ASTDV
Assay Standard Version
2020-06-29
16
8325064
Ames
TS
1
SSTYP
Study Type
GENOTOXICITY IN VITRO
17
8325064
Ames
TS
1
SSSTYP
Study Sub Type
Bacterial Reverse Mutation Test
18
8325064
Ames
TS
1
2
SPECIES
Species
Salmonella
19
8325064
Ames
TS
1
2
STRAIN
Strain
TA98
20
8325064
Ames
TS
1
2
STRAIN
Strain
TA100
21
8325064
Ames
TS
1
2
STRAIN
Strain
TA1535
22
8325064
Ames
TS
1
2
STRAIN
Strain
TA1537
23
8325064
Ames
TS
1
3
SPECIES
Species
Escherichia coli
24
8325064
Ames
TS
1
3
STRAIN
Strain
WP2 uvrA pKM101
Dataset Wrapper Debug Message
Row captions have been provided, but there doesn't seem to be a dataset to which the row captions would apply.
How do we handle "toxic, no revertant colonies"? (LAK will add 6 records with GTSTAT = NOT DONE, GTREASND = "TOO MUCH CYTOTOXICITY,"
Condition of background bacterial lawn? Slight thinning, Very thin? - refer to SEND team's marked-up table.
new Test code of Cytotoxicity with GTORRES = S, V (controlled terms)
Each plate we would have one result record for Revertent count and another for the lawn evaluation (NORMAL, SLIGHT THINNING, VERY THIN)
When "-" in Mean, Std Dev, Fold Inc - refer to SEND team's marked-up table (GTSTAT = NOT DONE; variety of REASND)
Rows 1-22:
Shows trial set parameters and trial set values that comprise the test conditions for the set SetA. SetA is the first row of the raw data table, see the row labeled "SetA" in the table, Raw Data for Study 8325064.
Rows 2-4:
Show two records for Alkaline Phosphatase that were collected 1 day apart and are expected to be reported together. Row 4 shows how to create a derived record (average of the Rows 2 and 3) and flag it as Derived (LBDRVFL = "Y") as well as the record to use as baseline (LBBLFL = "Y").
Rows 6-7:
Show a suggested use of the LBSCAT variable. It could be used to further classify types of tests within a laboratory panel (e.g., "DIFFERENTIAL").
Row 9:
Shows the proper use of the LBSTAT variable to indicate "NOT DONE," when the fact that the test was done was documented.
Row 12:
The subject had Cholesterol measured. The normal range for this test is <200 mg/dL. The value <200 may not be used in the normal range variables LBORNRHI or LBSTNRHI; however, a sponsor may decide, e.g., to enter "0" into LBORNRLO and "199" in LBORNRHI. The sponsor must define the appropriate value for all of the normal range variables.
Row 13:
Shows the use of LBUSCHFL to indicate that the test result was obtained from an unscheduled blood collection. In this case, the subject was moribund and a blood sample was taken prior to sacrifice.
Rows 1, 6:
Use records in the SUPPLB dataset example to show biological significance assigned by the investigator for test results.
Row Captions Debug Message
Remember to keep number agreement between labels and captions.
Row
STUDYID
ASSAYID
DOMAIN
SETCD
SET
TXSEQ
TXPARMCD
TXPARM
TXVAL
1
8325064
Ames
TX
SetA
A-TA98-C0
1
SPECIES
Species
Salmonella typhimurium
2
8325064
Ames
TX
SetA
A-TA98-C0
2
STRAIN
Strain/Substrain
TA98
3
8325064
Ames
TX
SetA
A-TA98-C0
3
METACT
Metabolic Activation
4
8325064
Ames
TX
SetA
A-TA98-C0
4
METACTFL
Y/N presence of metabolic activation
N
5
8325064
Ames
TX
SetA
A-TA98-C0
5
TRTDMIN
Treatment Duration Minimum
71.5
6
8325064
Ames
TX
SetA
A-TA98-C0
6
TRTDTRG
Treatment Duration Target
72
7
8325064
Ames
TX
SetA
A-TA98-C0
7
TRTDMAX
Treatment Duration Maximum
72.5
8
8325064
Ames
TX
SetA
A-TA98-C0
8
TRTDU
Treatment Duration Unit
HOURS
9
8325064
Ames
TX
SetA
A-TA98-C0
9
INCBTMP
Incubation Temperature
37
10
8325064
Ames
TX
SetA
A-TA98-C0
10
INCBTMPU
Incubation Temperature Unit
C
11
8325064
Ames
TX
SetA
A-TA98-C0
11
HUMID
Atmospheric Relative Humidity Percent
50
12
8325064
Ames
TX
SetA
A-TA98-C0
12
ATMCO2
Atmospheric CO2 Percent
5
13
8325064
Ames
TX
SetA
A-TA98-C0
13
SPTOBID
Sponsor defined tobacco identifier
CIG01a
14
8325064
Ames
TX
SetA
A-TA98-C0
14
EXPTYP
Exposure Type (See TIG NC workstream minutes 30-Jan here: Nonclinical)
Submerged
15
8325064
Ames
TX
SetA
A-TA98-C0
15
SAMTYP
Sample Type
Total Particulate Matter in PBS
16
8325064
Ames
TX
SetA
A-TA98-C0
16
INTRVN
name of the intervention article
TA1
17
8325064
Ames
TX
SetA
A-TA98-C0
17
ITVTYPE
type of intervention article
Vehicle Control
18
8325064
Ames
TX
SetA
A-TA98-C0
18
ITVCONC
Concentration of intervention article
0
19
8325064
Ames
TX
SetA
A-TA98-C0
19
ITVCONCU
Concentration Unit
ug/plate
20
8325064
Ames
TX
SetA
A-TA98-C0
20
TRTV
Treatment Vehicle
DMSO
21
8325064
Ames
TX
SetA
A-TA98-C0
21
SPDEVID
Sponsor defined device identifier
PUFFMASTER3K
22
8325064
Ames
TX
SetA
A-TA98-C0
22
DUREFID
Smoke Regimen
Medium Intensity Regimen
23
8325064
Ames
TX
SetF
(row 6)
F-TA98-C500
1
SPECIES
Species
24
8325064
Ames
TX
SetF
F-TA98-C500
2
STRAIN
Strain/Substrain
25
8325064
Ames
TX
SetF
F-TA98-C500
3
METACT
Metabolic Activation
26
8325064
Ames
TX
SetF
F-TA98-C500
4
METACTFL
Y/N presence of metabolic activation
N
27
8325064
Ames
TX
SetF
F-TA98-C500
TRTDRTOL
Treatment Duration Tolerance
28
8325064
Ames
TX
SetF
F-TA98-C500
TRTDURU
Treatment Duration Unit (this is for both TRTDURT, TRTDURTOL)
8325064
Ames
TX
SetF
F-TA98-C500
INTRVN
name of the intervention article
(Tobacco ProdA, Bleomycin or Cyclophosphamid A)
TA1
8325064
Ames
TX
SetF
F-TA98-C500
ITVTYPE
type of intervention article
choices of values: product; negative control; positive control
Product
8325064
Ames
TX
SetF
F-TA98-C500
ITVCONC
Concentration of intervention article
500
8325064
Ames
TX
SetF
F-TA98-C500
ITVCONCU
Concentration Unit
ug/plate
8325064
Ames
TX
SetF
F-TA98-C500
STRAIN
Strain/Substrain
TA98
8325064
Ames
TX
SetF
F-TA98-C500
REGIME
Smoking Regime
ISO Regime
...
8325064
Ames
TX
SetG (row 7) do G not I!!!
METACT
Metabolic Activation (should there be two parms? Presence, type)?
None
8325064
Ames
TX
SetG
TRTDRTRG
Treatment Duration target. (how do we show 3-6 hour range? start/end, target and tolerance?, one text field not-analyzable)
8325064
Ames
TX
SetG
TRTDRTOL
Treatment Duration Tolerance
8325064
Ames
TX
SetG
TRTDURU
Treatment Duration Unit (this is for both TRTDURT, TRTDURTOL)
8325064
Ames
TX
SetG
INTRVN
name of the intervention article
(Tobacco ProdA, Bleomycin or Cyclophosphamid A)
2-Nitrofluorine
8325064
Ames
TX
SetG
ITVTYPE
type of intervention article
choices of values: product; negative control; positive control
Positive Control
8325064
Ames
TX
SetG
ITVCONC
Concentration of intervention article
5
8325064
Ames
TX
SetG
ITVCONCU
Concentration Unit
ug/plate
8325064
Ames
TX
SetG
REGIME
Smoking Regime
ISO
...
SetG
8325064
Ames
TX
SetR
(Row 18)
METACT
Metabolic Activation (should there be two parms? Presence, type)?
None
8325064
Ames
TX
SetR
TRTDRTRG
Treatment Duration target. (how do we show 3-6 hour range? start/end, target and tolerance?, one text field not-analyzable)
8325064
Ames
TX
SetR
TRTDRTOL
Treatment Duration Tolerance
8325064
Ames
TX
SetR
TRTDURU
Treatment Duration Unit (this is for both TRTDURT, TRTDURTOL)
8325064
Ames
TX
SetR
INTRVN
name of the intervention article
(Tobacco ProdA, Bleomycin or Cyclophosphamid A)
4-Nitroquinoline-1-oxide
8325064
Ames
TX
SetR
ITVTYPE
type of intervention article
choices of values: product; negative control; positive control
Positive Control
8325064
Ames
TX
SetR
ITVCONC
Concentration of intervention article
2
8325064
Ames
TX
SetR
ITVCONCU
Concentration Unit
ug/plate
8325064
Ames
TX
SetR
STRAIN
Strain/Substrain
TA98
8325064
Ames
TX
SetR
REGIME
Smoking Regime
ISO
Dataset Wrapper Debug Message
Row captions have been provided, but there doesn't seem to be a dataset to which the row captions would apply.
Row 1:
Shows values collected for the set, SetA, as shown in the
Rows 2-4:
Show two records for Alkaline Phosphatase that were collected 1 day apart and are expected to be reported together. Row 4 shows how to create a derived record (average of the Rows 2 and 3) and flag it as Derived (LBDRVFL = "Y") as well as the record to use as baseline (LBBLFL = "Y").
Rows 6-7:
Show a suggested use of the LBSCAT variable. It could be used to further classify types of tests within a laboratory panel (e.g., "DIFFERENTIAL").
Row 9:
Shows the proper use of the LBSTAT variable to indicate "NOT DONE," when the fact that the test was done was documented.
Row 12:
The subject had Cholesterol measured. The normal range for this test is <200 mg/dL. The value <200 may not be used in the normal range variables LBORNRHI or LBSTNRHI; however, a sponsor may decide, e.g., to enter "0" into LBORNRLO and "199" in LBORNRHI. The sponsor must define the appropriate value for all of the normal range variables.
Row 13:
Shows the use of LBUSCHFL to indicate that the test result was obtained from an unscheduled blood collection. In this case, the subject was moribund and a blood sample was taken prior to sacrifice.
Rows 1, 6:
Use records in the SUPPLB dataset example to show biological significance assigned by the investigator for test results.
Unable to render dataset table
Please move all content other than the table outside of the macro.
ou.xpt. Observational and Experimental Units domain
Experimental unit - The unit to which the treatment is applied, eg. Test tube
Observational unit - The unit on which the response is measured. (This may not be the same as the experimental unit.)
Row
STUDYID
ASSAYID
DOMAIN
SETCD (in TX)
EUID
OBUID
1
8325064
Ames
OU
SetA
VC1
2
123
MLA
OU
A1
4_-S9_C31.3_B
VC2
3
123
MLA
OU
A1
4_-S9_C31.3_B
VC3
4
123
MLA
OU
A1
4_-S9_C31.3_B
TFT1
5
123
MLA
OU
A1
4_-S9_C31.3_B
TFT2
6
123
MLA
OU
A1
4_-S9_C31.3_B
TFT3
7
123
MLA
OU
A2
4_-S9_C500_B
VC1
8
123
MLA
OU
A2
4_-S9_C500_B
VC2
9
123
MLA
OU
A2
4_-S9_C500_B
VC3
10
123
MLA
OU
A2
4_-S9_C500_B
TFT1
11
123
MLA
OU
A2
4_-S9_C500_B
TFT2
12
123
MLA
OU
A2
4_-S9_C500_B
TFT3
Rows 1-7:
Show values collected for the set, SetA.
Rows 8-15:
Shows values collected for the set, SetF.
Rows 6-7:
Show a suggested use of the LBSCAT variable. It could be used to further classify types of tests within a laboratory panel (e.g., "DIFFERENTIAL").
Rows 6,7,12,13, x,x,x,x:
Show values collected (e.g., MEAN, STANDARD DEVIATION, and/or FOLD INCREASE) that apply to all of the observational units within the experimental unit, as show by OBUID = "ALL".
Row 9:
Shows the proper use of the LBSTAT variable to indicate "NOT DONE," when the fact that the test was done was documented.
Row 12:
The subject had Cholesterol measured. The normal range for this test is <200 mg/dL. The value <200 may not be used in the normal range variables LBORNRHI or LBSTNRHI; however, a sponsor may decide, e.g., to enter "0" into LBORNRLO and "199" in LBORNRHI. The sponsor must define the appropriate value for all of the normal range variables.
Row 13:
Shows the use of LBUSCHFL to indicate that the test result was obtained from an unscheduled blood collection. In this case, the subject was moribund and a blood sample was taken prior to sacrifice.
Rows 1, 6:
Use records in the SUPPLB dataset example to show biological significance assigned by the investigator for test results.
Row Captions Debug Messages
Remember to keep number agreement between labels and captions.
Please construct row caption labels as instructed in <ac:link><ri:page ri:content-title="Constructing labels for row captions" ri:space-key="TTD"/></ac:link>.