Versions Compared

Key

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

This example shows a sample report table, trial design, and results data dataset for Study #123 study 123 for the determination of the in vitro genotoxicity potential of tobacco products in using the in vitro Micronucleus Assaymicronucleus assay.

Expand
titleSample Report Table for Study 123

Dataset wrap
Rowcaps
8 the sponsor's study reference ID is not applicable 9
Rows 1-2:Show two 2 records for TSPARMCD = "GLPTYP", using TSSEQ to indicate multiple records, since both GLP Types types apply for this example study. 
Row
3:Shows that
this study was conducted as a GLP study.
Rows 4-5:Show the study start date and study title.
Rows
6-7:Show the version of SEND Implementation Guide and version of Controlled Terminology used in this study.
Row 8:Shows the applicant's organization.
Row 9:Shows that the applicant's study reference ID is not applicable.
Rows 10-13:Show that TSGRPID has been used to 12:Show that TSGRPID has been used to link records (name, location, country) related to the test facility (TSGRPID = 1). The Study Director study director is associated with the Test Facility.test facility.
Rows 14-16:

Show that TSGRPID (TSGRPID=2) has been used to link the information on the testing guideline followed on this study (TSTGDNAM, TSTGDORG, TSTGDVER).

Row 17:

Shows the study type for this study.

Row 18:

Shows that this study includes a Mammalian Cell Micronucleus Assay.
Rows 19-20:Show that the species is human and the cell line is TK6 lymphoblastoid in this study.
Dataset2
Dataset2

Row

STUDYID

ASSAYID
Row

STUDYID

DOMAIN

TSSEQ

TSGRPID

TSPARMCD

TSPARM

TSVAL

TSVALNF

1123
NRU
TS1
GLPTYPGood Laboratory Practice TypeFDA
2123
NRU
TS2
GLPTYPGood Laboratory Practice TypeOECD
3123
TS1
GLPFLGLP FlagY
4123
NRU
TS1
STSTDTCStudy Start Date2022-05-25
4

5123
NRU
TS1
STITLEStudy Title

Determination of the in vitro genotoxicity potential using the in vitro Neutral Red Uptake assay

5

6123
NRU
TS1
SNDIGVERSEND Implementation Guide VersionTOBACCO IMPLEMENTATION GUIDE VERSION 1.0
6

7123
NRU
TS1
SNDCTVERSEND Controlled Terminology VersionSEND Terminology 2021-09-30
7

8123
NRU
TS1
SSPONSOR

APPLCNT
Sponsor Organization

Applicant

Example
Sponsor
Applicant, Inc.
8

9123
NRU
TS1
SPREFID

APREFID
Sponsor
Study Reference ID
NOT APPLICABLE
9
10123
NRU
TS11TSTFNAMTest Facility NameExample Test Lab Name
10

11123
NRU
TS11TSTFLOCTest Facility Location10 Somewhere Street, Montgomery, AL 10000
11

12123
NRU
TS11TFCNTRYTest Facility CountryUSA
12

13123
NRU
TS11STDIRStudy DirectorDr. R. Smith
13

14123
NRU
TS1
GLPFL
2
GLP FlagY
TSTGDNAMTesting Guideline NameGUIDELINE FOR THE TESTING OF CHEMICALS No. 487
15
14
123
NRU
TS12
ASTDAssay StandardNIH Publication No. 07-4519
TSTGDORGTesting Guideline OrganizationOECD
16123
15123NRU
TS12
ASTDV
TSTGDVER
Assay Standard
Testing Guideline Version
2006
29-July-
11
2016
16

17123
NRU
TS1
SSTYPStudy TypeGENOTOXICITY IN VITRO
17

18123
NRU
TS1
SSSTYPStudy Sub TypeIn Vitro Neutral Red Uptake

GNTXAIDGenetic Toxicology Assay IdentifierMNvit
19123
18123NRU
TS1
SPECIESSpecies
Hamster
HUMAN
19

20123
NRU
TS1
TESTSYS

CELLLN
Test SystemCHO
Cell Line

TK6 LYMPHOBLASTOID


This example trial set dataset, tx.xpt, Trial Sets dataset shows information about the test conditions for set A1 and A2 in this example study, 123. Set Sets A1 and A2 can be seen in the first and second rows respectively of the sample report Table 1 in the Sample Report table for Study 123 (above).   For brevity, the trial sets dataset, tx.xpt, and TX dataset and the findings dataset, gt.xpt (GT) dataset do not show information for any other sets.   Fully formed datasets for this example study would include information about the test conditions and findings for all sets. 

Dataset wrap
Nametx.xpt
Rowcaps
Rows 1-
24
23:

Show trial set parameters and

trial set

values that comprise the test conditions for trial set A1. Set A1 is the data for the negative control (concentration 0) with short-term exposure and metabolic activation S9.  The applicant has chosen to given a long name (SET) equal to "ST+S9_C0".

Set A1 is associated with the first row in the sample report table for study 123.

Rows
25
24-
47
46:

Show trial set parameters and

trial set

values that comprise the test conditions for trial set A2. Set A2 is the data for the short-term exposure with metabolic activation S9 at a concentration of 1250 ug/ml.

 

The applicant has chosen to give the set a long name (SET) equal to "ST+S9_C1250".

Set A2 is associated with the second row in the sample report table for study 123.

Dataset2
RowSTUDYID
GNTXAID
DOMAINSETCDSETTXSEQTXPARMCDTXPARMTXVAL
1123
MNvit
TXA1ST+S9_C0
2
1
METACT
MTACTINDMetabolic
Activation
Activating Agent Name+S9
2123
MNvit
TXA1ST+S9_C0
3
2METACTFL
Y/N presence of metabolic activation
Presence of Metabolic Activation FlagY
3123
MNvit
TXA1ST+S9_C0
4
3
TRTDMIN

IVTDMIN

In vitro Treatment Duration Minimum3
4123
MNvit
TXA1ST+S9_C0
5
4
TRTDTRG
IVTDTRGIn vitro Treatment Duration Target3.5
5123
MNvit
TXA1ST+S9_C0
6
5
TRTDMAX
IVTDMAXIn vitro Treatment Duration Maximum4
6123
MNvit
TXA1ST+S9_C0
7
6
TRTDU
IVTDUIn vitro Treatment Duration UnitHOURS
7123
MNvit
TXA1ST+S9_C0
8
7RCVDMINRecovery Duration Minimum23.5
8123
MNvit
TXA1ST+S9_C0
9
8RCVDTRGRecovery Duration Target24
9123
MNvit
TXA1ST+S9_C0
10
9RCVDMAXRecovery Duration Maximum24.5
10123
MNvit
TXA1ST+S9_C0
11
10RCVDURecovery Duration UnitHOURS
11123
MNvit
TXA1ST+S9_C0
12
11INCBTMPIncubation Temperature37
12123
MNvit
TXA1ST+S9_C0
13
12INCBTMPUIncubation Temperature UnitC
13123
MNvit
TXA1ST+S9_C0
14
13
HUMID
ATMRHPAtmospheric Relative Humidity Percent50
14123
MNvit
TXA1ST+S9_C0
15
14
ATMCO2
ATMCO2PAtmospheric CO2 Percent5
15123
MNvit
TXA1ST+S9_C0
16
15

SPTOBID

Sponsor

Applicant-defined tobacco identifier

CIG01a
16123
MNvit
TXA1ST+S9_C0
17
16EXPTYP

Exposure Type

Submerged
17123
MNvit
TXA1ST+S9_C0
18
17SAMTYP

Sample Type

Total Particulate Matter in DMSO
18123
MNvit
TXA1ST+S9_
C0
CO
19
18
INTRVN
ITVNAM
Name of the

Intervention Article Name

Tobacco ProdA
19123
MNvit
TXA1ST+S9_C0
20
19ITVTYPE
type of intervention article

Intervention Article Type

Negative Control
20123
MNvit
TXA1ST+S9_C0
21
20ITVCONCIntervention Article Concentration
of intervention article
0
21123
MNvit
TXA1ST+S9_C0
22
21ITVCONCUIntervention Article Concentration Unitug/ml
22123
MNvit
TXA1ST+S9_C0
23
22

SPDEVID

Sponsor
Applicant-defined device identifierPUFFMASTER3K
23123
MNvit
TXA1ST+S9_C0
24
23
DUREFID

SMKRGM

Smoke
Smoking Regimen
Medium Intensity Regimen
MEDIUM INTENSITY REGIMEN
24123
MNvit
TXA2ST+S9_C1250
2
24
METACT
MTACTINDMetabolic
Activation
Activating Agent Name+S9
25123
MNvit
TXA2ST+S9_C1250
3
25METACTFL
Y/N presence of metabolic activation
Presence of Metabolic Activation FlagY
26123
MNvit
TXA2ST+S9_C1250
4
26
TRTDMIN

IVTDMIN

In vitro Treatment Duration Minimum3
27123
MNvit
TXA2ST+S9_C1250
5
27
TRTDTRG
IVTDTRGIn vitro Treatment Duration Target3.5
28123
MNvit
TXA2ST+S9_C1250
6
28
TRTDMAX
IVTDMAXIn vitro Treatment Duration Maximum4
29123
MNvit
TXA2ST+S9_C1250
7
29
TRTDU
IVTDUIn vitro Treatment Duration UnitHOURS
30123
MNvit
TXA2ST+S9_C1250
8
30RCVDMINRecovery Duration Minimum23.5
31123
MNvit
TXA2ST+S9_C1250
9
31RCVDTRGRecovery Duration Target24
32123
MNvit
TXA2ST+S9_C1250
10
32RCVDMAXRecovery Duration Maximum24.5
33123
MNvit
TXA2ST+S9_C1250
11
33RCVDURecovery Duration UnitHOURS
34123
MNvit
TXA2ST+S9_C1250
12
34INCBTMPIncubation Temperature37
35123
MNvit
TXA2ST+S9_C1250
13
35INCBTMPUIncubation Temperature UnitC
36123
MNvit
TXA2ST+S9_C1250
14
36
HUMID
ATMRHPAtmospheric Relative
Humidity 
Humidity Percent50
37123
MNvit
TXA2ST+S9_C1250
15
37
ATMCO2
ATMCO2PAtmospheric CO2 Percent5
38123
MNvit
TXA2ST+S9_C1250
16
38

SPTOBID

Sponsor

Applicant-defined tobacco identifier

CIG01a
39123
MNvit
TXA2ST+S9_C1250
17
39EXPTYP

Exposure Type

Submerged
40123
MNvit
TXA2ST+S9_C1250
18
40SAMTYP

Sample Type

Total Particulate Matter in DMSO
41123
MNvit
TXA2ST+S9_C1250
19
41
INTRVN
ITVNAM
Name of the

Intervention Article Name

Tobacco ProdA
42123
MNvit
TXA2ST+S9_C1250
20
42ITVTYPE
type of intervention article

Intervention Article Type

Product
43123
MNvit
TXA2ST+S9_C1250
21
43ITVCONCIntervention Article Concentration
of intervention article
1250
44123
MNvit
TXA2ST+S9_C1250
22
44ITVCONCUIntervention Article Concentration Unitug/ml
45123
MNvit
TXA2ST+S9_C1250
23
45SPDEVID
Sponsor defined device identifier
Applicant-defined Device IdentifierPUFFMASTER2023
46123
MNvit
TXA2ST+S9_C1250
24
46
DUREFID

SMKRGM

Smoke
Smoking Regimen
High Intensity Regimen
Dataset2
tableidrelref.xpt

Row

STUDYID

GNTXAID

SETCD

REFID

PARENT

LEVEL

LVLDESC

1

8325064

Ames

SetA

A

1

TRIAL SET

2

8325064

Ames

SetA

0_1

A

2

OBSERVATIONAL UNIT

3

8325064

Ames

SetA

0_2

A

2

OBSERVATIONAL UNIT

4

18 Expand
titleou.xpt
RowSTUDYIDASSAYIDDOMAINSETCD EUIDOBUID1123MNvitEIA1C02123MNvitEIA2C1250 Dataset wrap
Namegt.xpt
HIGH INTENSITY REGIMEN
Dataset wrap
Namerelref
Rowcaps
Row 1:Shows the value of REFID=C0. This REFID refers to the trial set with a SETCD of "A1", as defined in the TX dataset. LEVEL=1 and LVLDESC="EXPERIMENTAL UNIT/TRIAL SET" indicates this identifier is referring to both the experimental unit and the unit to which the treatment is applied, and to the entire trial set.
Rows 2-5:Show the values of 4 observational units (C0_Count1 through C0_Count4) that are within the parent experimental unit, REFID=C0. In this example assay, these observational units are also all within the same trial set, as defined in the TX dataset.
Row 6:Shows the value of REFID=C1250. This REFID refers to the trial set with a SETCD of "A2", as defined in the TX dataset. LEVEL=1 and LVLDESC="EXPERIMENTAL UNIT/TRIAL SET" indicates this identifier is referring to both the experimental unit and the unit to which the treatment is applied, and to the entire trial set.
Rows 7-10:

Show the values of 4 observational units (C1250_Count1 through C1250_Count4) that are within the parent experimental unit, REFID=C1250. In this example assay, these observational units are also all within the same trial set, as defined in the TX dataset.

Dataset2
tableidrelref

Row

STUDYID

SETCD

REFID

PARENT

LEVEL

LVLDESC

1

123

A1

C0
1

EXPERIMENTAL UNIT/TRIAL SET

2

123

A1

C0-Count1C02OBSERVATIONAL UNIT

3

123

A1

C0-Count2C02OBSERVATIONAL UNIT

4

123

A1

C0-Count3C02OBSERVATIONAL UNIT

5

123

A1

C0-Count4C02OBSERVATIONAL UNIT

6

123A2C1250
1EXPERIMENTAL UNIT/TRIAL SET
7123A2C1250-Count1C12502OBSERVATIONAL UNIT
8123A2C1250-Count2C12502OBSERVATIONAL UNIT
9123A2C1250-Count3C12502OBSERVATIONAL UNIT
10123A2C1250-Count4C12502OBSERVATIONAL UNIT

OBUID

OBUID

Dataset wrap
Namegt
Rowcaps

Rows 1-3, 8:

Show percentage result values that apply to GTREFID=C0. REFID=C0, as shown in the RELREF dataset, relates this data to the trial set in the first row of table 1 in the sample report table for study 123.
Rows 4-7:Show the 4 micronucleated cell counts for the observational units with GTREFID from C0-Count1 through C0-Count4, for which their relationship to test conditions (in tx.xpt) and experimental units (in relref.xpt) are shown in the RELREF dataset.

Rows 9-11, 16:

Show percentage result values that apply to GTREFID=C1250. REFID=C1250, as shown in the RELREF dataset, relates this data to the trial set in the second row of table 1 in the sample report table for study 123.
Rows 12-15:Show the 4 micronucleated cell counts for the observational units with GTREFID from C1250-Count1 through C1250-Count4, for which their relationship to test conditions (in tx.xpt) and experimental units (in relref.xpt) are shown in the RELREF dataset.
Rowcaps
Rows 1-5:Show the number of revertant colonies per plate collected for each of five observational units ( REFID=0_1 through 0_5 as described in the relref dataset).
Rows 6, 7:Show summary values collected (MEAN, STANDARD DEVIATION) for REFID=A that apply to the entire trial set, SetA, as indicated by LEVEL=1 and LVLDESC=TRIAL SET for this REFID in the relref dataset. 
Rows 8-13: Revertent colonies were counted for each of three plates/observational units (REFID=6_1 through 6_3) and each value is associated with a record to show a postfix code of "V" = "Very thin background bacterial lawn"
Rows 14-16:Show summary values collected (MEAN, STANDARD DEVIATION, and FOLD INCREASE) for REFID=F that apply to the entire trial set, SetF, as indicated by LEVEL=1 and LVLDESC=TRIAL SET for this REFID in the relref dataset. 
Rows 17-19:Show three plates/observational units (REFID=5_1 through 5_3) where no revertant colonies were counted due to too much cytotoxicity and a postfix code of "T".
Rows 20-22:Show the number of revertant colonies per plate collected for each of three observational units (REFID=18_1 through 18_3 as described in the relref dataset).
Rows 23-25:Show summary values collected (MEAN, STANDARD DEVIATION, and FOLD INCREASE) for REFID=R that apply to the entire trial set, SetR, as indicated by LEVEL=1 and LVLDESC=TRIAL SET for this REFID in the relref dataset. 
Dataset2
RowSTUDYIDGNTXAIDDOMAINEUID

REFID

GTSEQGTTESTCDGTTESTGTCELLEV
(cells evaluated)
GTORRESGTORRESU

GTCOLSRT

???

GTSTRESCGTSTRESNGTSTRESUGTDTC1123MNvitGTC01RICCRelative Increase in Cell Count1540%00%2022-05-252123MNvitGTC02RCCRelative Cell Count1540%00%2022-05-253123MNvitGTC03RPDRelative Population Doubling1540%00%2022-05-254123MNvitGTC04MNCELLSMicronucleated Cells220515Cells1515Cells2022-05-255123MNvitGTC05MNCELLSMicronucleated Cells247413Cells1313Cells2022-05-256123MNvitGTC06MNCELLSMicronucleated Cells275817Cells1717Cells2022-05-257123MNvitGTC07MNCELLSMicronucleated Cells266912Cells1212Cells2022-05-258123MNvitGTC08AVGRELAverage Relative MN Frequency0.57%0.570.57%2022-05-259123MNvitGTC12501RICCRelative Increase in Cell Count13415.7%15.715.7%2022-05-2510123MNvitGTC12502RCCRelative Cell Count13413.0%13.013.0%2022-05-2511123MNvitGTC12503RPDRelative Population Doubling1347.9%7.97.9%2022-05-2512123MNvitGTC12504MNCELLSMicronucleated Cells326620Cells2020Cells2022-05-2513123MNvitGTC12505MNCELLSMicronucleated Cells219017Cells1717Cells2022-05-2514123MNvitGTC12506MNCELLSMicronucleated Cells275813Cells1313Cells2022-05-2515123MNvitGTC12507MNCELLSMicronucleated Cells271421Cells2121Cells2022-05-2516123MNvitGTC12508AVGRELAverage Relative MN Frequency0.66%0.660.66%2022-05-25
Expand
titlegt.xpt (similar to LB)

A1: Image Removed

A2:                                   Image Removed

RowSTUDYIDGNTXAIDDOMAINEUID

REFID

GTSEQGTTESTCDGTTESTGTCELLEV
(cells evaluated)
GTORRESGTORRESU

GTCOLSRT

???

Dataset2
RowSTUDYIDDOMAINGTSEQ

GTREFID

GTTESTCDGTTESTGTCELLEVGTORRESGTORRESU

GTCOLSRT

GTSTRESCGTSTRESNGTSTRESUGTDTC
1123
MNvit
GT1C0
1

RICC

Relative Increase in Cell Count1540%
00%2022-05-25
2123
MNvit
GT
GT
2C0
2
RCCRelative Cell Count1540%
00%2022-05-25
3123
MNvit
GT
GT
3C0
3
RPDRelative Population Doubling1540%
00%2022-05-25
4123
MNvit
GT
GT
4C0-Count1
4MNCELLS
MNCEMicronucleated Cells220515
Cells



1515
Cells

2022-05-25
5123
MNvit
GT
GT
5C0-Count2
5
MNCE
MNCELLS
Micronucleated Cells247413
Cells


1313
Cells

2022-05-25
6123
MNvit
GT
GT
6C0-Count3
6
MNCE
MNCELLS
Micronucleated Cells275817
Cells


1717
Cells

2022-05-25
7123
MNvitMNCELLS
GT7C0-Count4
7
MNCEMicronucleated Cells266912
Cells


1212
Cells

2022-05-25
8123
MNvit
GT
GT
8C0
8AVGRELAverage Relative MN Frequency
MNCECEMicronucleated Cells/Total Cells
0.57%
0.570.57%2022-05-25
9123
MNvit
GT
GT
1C1250
1
RICCRelative Increase in Cell Count13415.7%
15.715.7%2022-05-25
10123
MNvit
GT
GT
2C1250
2
RCCRelative Cell Count13413.0%
13.013.0%2022-05-25
11123
MNvit
GT
GT
3C1250
3
RPDRelative Population Doubling1347.9%
7.97.9%2022-05-25
12123
MNvit
GT
GTMNCELLS
4C1250-Count1
4
MNCEMicronucleated Cells326620
Cells


2020
Cells

2022-05-25
13123
MNvit
GT
GTMNCELLS
5C1250-Count2
5
MNCEMicronucleated Cells219017
Cells


1717
Cells

2022-05-25
14123
MNvit
GT
GT
6C1250-Count3
6
MNCE
MNCELLS
Micronucleated Cells275813
Cells


1313
Cells

2022-05-25
15123
MNvit
GT
GT
7C1250-Count4
7
MNCE
MNCELLS
Micronucleated Cells271421
Cells


2121
Cells

2022-05-25
16123
MNvit
GT
GT
8C1250
8AVGREL
MNCECE

Micronucleated Cells/Total Cells

Average Relative MN Frequency


0.66%
0.660.66%2022-05-25