Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: TOBA-497

...

Dataset wrap
Rowcaps
Rows 1-2:Show 2 records for TSPARMCD = "GLPTYP", using TSSEQ to indicate multiple records, since both GLP types apply for this example study. 
Row 8:

Shows that the applicant's

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-356
study reference ID is not applicable.

Rows 9-12:Show that TSGRPID has been used to link records (name, location, country) related to the test facility (TSGRPID = 1). The study director is associated with the test facility.
Rows 14-16:

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

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-56

Dataset2

Row

STUDYID

GNTXAID

DOMAIN

TSSEQ

TSGRPID

TSPARMCD

TSPARM

TSVAL

TSVALNF

1123NRUTS1
GLPTYPGood Laboratory Practice TypeFDA
2123NRUTS2
GLPTYPGood Laboratory Practice TypeOECD
3123NRUTS1
STSTDTCStudy Start Date2022-05-25
4123NRUTS1
STITLEStudy Title

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


5123NRUTS1
SNDIGVERSEND Implementation Guide VersionTOBACCO IMPLEMENTATION GUIDE VERSION 1.0
6123NRUTS1
SNDCTVERSEND Controlled Terminology VersionSEND Terminology 2021-09-30
7123NRUTS1
APPLCNTApplicant OrganizationExample Applicant Inc.
8123NRUTS1
APREFIDApplicant Study Reference ID
NOT APPLICABLE
9123NRUTS11TSTFNAMTest Facility NameExample Test Lab Name
10123NRUTS11TSTFLOCTest Facility Location10 Somewhere Street, Montgomery, AL 10000
11123NRUTS11TFCNTRYTest Facility CountryUSA
12123NRUTS11STDIRStudy DirectorDr. R. Smith
13123NRUTS1
GLPFLGLP FlagY
14123NRUTS14TSTGDNAMTesting Guideline NamePublication No. 07-4519
15123NRUTS14TSTGDORGTesting Guideline OrganizationNIH
16123NRUTS14TSTGDVERTesting Guideline Version2006-11
17123NRUTS1
SSTYPStudy TypeGENOTOXICITY IN VITRO
18123NRUTS1
SSSTYPStudy Sub TypeIn Vitro Neutral Red UptakeIN VITRO NEUTRAL RED UPTAKE
19123NRUTS1
SPECIESSpeciesHUMAN
20123NRUTS1
CELLLNCell LineNHK
Dataset wrap

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-279

Rowcaps
Rows 1-12:Show the test conditions for the set with a short name or SETCD value of ALLNRU. The applicant chose this value to represent test conditions for the entire assay. 
Rows 13-20:Show the test conditions for the set with a short name or SETCD value of CSC-50b. The applicant chose this value to represent plate number 1, well row A, well column 3, with a concentration of 50µg/mLof cigarette smoke condensate as shown in the report table for study 123.
Row 20:Shows the value for Cell Line (CELLLN) is not applicable because the well is a media-only well, having no NHK cells. 

Rows 21-28:

Show the test conditions for the set with a short name or SETCD value of CSC-50. The applicant chose this value to represent plate number 1, well rows B-G, well column 3 and plate number 2, well rows A-H, well column 3. These all have the concentration of 50µg/mLof cigarette smoke condensate as shown in the report table for study 123.
Rows 29-36:Show the test conditions for the set with a short name or SETCD value of SLS-110. The applicant chose this value to represent plate number 1, well rows B-G, well column 10, and plate number 2, well rows A-H, well column 10. These all have the concentration of 110µg/mLof sodium laurel sulfate as shown in the report table for study 123.
Dataset2
RowSTUDYIDGNTXAIDDOMAINSETCDSETTXSEQTXPARMCDTXPARMTXVAL
1123NRUTXALLNRUALLNRU_ASSAY1IVTDMINIn vitro Treatment Duration Minimum47.5
2123NRUTXALLNRUALLNRU_ASSAY

2

IVTDTRGIn vitro Treatment Duration Target48
3123NRUTXALLNRUALLNRU_ASSAY3IVTDMAXIn vitro Treatment Duration Maximum48.5
4123NRUTXALLNRUALLNRU_ASSAY4IVTDUIn vitro Treatment Duration UnitHOURS
5123NRUTXALLNRUALLNRU_ASSAY5INCBTMPIncubation Temperature37
6123NRUTXALLNRUALLNRU_ASSAY6INCBTMPUIncubation Temperature UnitC
7123NRUTXALLNRUALLNRU_ASSAY7SWAVENMSpectrophotometer Wavelength540
8123NRUTXALLNRUALLNRU_ASSAY8ATMRHPAtmospheric Relative Humidity Percent90
9123NRUTXALLNRUALLNRU_ASSAY9ATMCO2PAtmospheric CO2 Percent5
10123NRUTXALLNRUALLNRU_ASSAY10SPDEVIDapplicant defined device identifierPUFFMASTER3k
11123NRUTXALLNRUALLNRU_ASSAY11SMKRGMSmoking RegimenMEDIUM INTENSITY REGIMEN
12123NRUTXALLNRUALLNRU_ASSAY12SPTOBID

Applicant-defined tobacco identifier

CIG01a
13123NRUTXCSC-50bCSC-50-blank13PSETCD

Parent Set Code

ALLNRU
14123NRUTXCSC-50bCSC-50-blank14EXPTYP

Exposure Type

Air Liquid Interface
15123NRUTXCSC-50bCSC-50-blank15SAMTYPSample TypeWhole Smoke Conditioned Media
16123NRUTXCSC-50bCSC-50-blank16ITVNAMName of the Intervention ArticleTobacco ProdA
17123NRUTXCSC-50bCSC-50-blank17ITVTYPEIntervention Article TypePRODUCT
18123NRUTXCSC-50bCSC-50-blank18ITVCONC

Intervention Article Concentration

50
19123NRUTXCSC-50bCSC-50-blank19ITVCONCUIntervention Article Concentration Unitug/ml
20123NRUTXCSC-50bCSC-50-blank20CELLLNCell LineNOT APPLICABLE
21123NRUTXCSC-50CSC-5021PSETCD

Parent Set Code

ALLNRU
22123NRUTXCSC-50CSC-5022EXPTYP

Exposure Type

Air Liquid Interface
23123NRUTXCSC-50CSC-5023SAMTYPSample TypeWhole Smoke Conditioned Media
24123NRUTXCSC-50CSC-5024ITVNAMIntervention Article NameTobacco ProdA
25123NRUTXCSC-50CSC-5025ITVTYPEIntervention Article TypePRODUCT
26123NRUTXCSC-50CSC-5026ITVCONC

Intervention Article Concentration

50
27123NRUTXCSC-50CSC-5027ITVCONCUIntervention Article Concentration Unitug/ml
28123NRUTXCSC-50CSC-5028CELLLNCell LineNHK
29123NRUTXSLS-110SLS-11029PSETCD

Parent Set Code

ALLNRU
30123NRUTXSLS-110SLS-11030EXPTYP

Exposure Type

Air Liquid Interface
31123NRUTXSLS-110SLS-11031SAMTYPSample TypeLiquid
32123NRUTXSLS-110SLS-11032ITVNAMIntervention Article NameSodium Laurel Sulfate
33123NRUTXSLS-110SLS-11033ITVTYPEIntervention Article TypePOSITIVE CONTROL
34123NRUTXSLS-110SLS-11034ITVCONC

Intervention Article Concentration

110
35123NRUTXSLS-110SLS-11035ITVCONCUIntervention Article Concentration Unitug/ml
36123NRUTXSLS-110SLS-11036CELLLNCell LineNHK
Dataset wrap
Namerelref

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTOBA-280

Rowcaps
Row 1:Shows the REFID of 123NRU that indicates the entire assay.
Rows 2, 5, 8, 9:Show the REFIDs at the second level, all within the parent assay of 123NRU (REFID values of 1-3b, 1-3, 1-10, 2-10).
Rows 3-4, 6-7, 10-11: Show REFID values that the applicant chose, in this case, to represent the plate number (1 or 2), column (1 - 12), and row (A-G) of the 96-well plates.
Rows 3-4:Show the REFIDs 1-3-A and 1-3-H that indicate two experimental units within the parent trial set of 1-3b.
Rows 6-7:Show the REFIDs 1-3-B and 1-3-C that indicate two experimental units within the parent trial set of 1-3.
Row 10:Shows the REFID of 1-10-G that indicates the experimental unit within the parent trial set of 1-10.
Row 11: Shows the REFID of 2-10-G that indicates the experimental unit within the parent trial set of 2-10.
Dataset2
tableidrelref

Row

STUDYID

GNTXAID

SETCD

REFID

PARENT

LEVEL

LVLDESC

1123NRUALLNRU123NRU
1ASSAY
2123NRU

CSC-50b

1-3b123NRU2TRIAL SET
3123NRU

CSC-50b

1-3-A1-3b3EXPERIMENTAL UNIT
4123NRU

CSC-50b

1-3-H1-3b3EXPERIMENTAL UNIT
5123NRUCSC-501-3123NRU2TRIAL SET
6123NRUCSC-501-3-B1-33EXPERIMENTAL UNIT
7123NRUCSC-501-3-C1-33EXPERIMENTAL UNIT
8123NRUSLS-1101-10123NRU2TRIAL SET
9123NRUSLS-1102-10123NRU2TRIAL SET
10123NRUSLS-1101-10-G1-103EXPERIMENTAL UNIT
11123NRUSLS-1102-10-G2-103EXPERIMENTAL UNIT

...