Page History

...

Dataset wrap

Name	relref

Rowcaps

Row 1:	Shows the value of REFID=A, This REFID refers to the trial set with a SETCD of 'SetA', as defined in the trial set dataset, tx.xpt. LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 2-6:	Show the values of five observational units 0_1 through 0_5 that are within the parent experimental unit, REFID=A
Row 7:	Shows the value of REFID=F, This REFID refers to the trial set with a SETCD of 'SetF', as defined in the trial set dataset, tx.xpt. LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 8-10:	Show the values of three observational units 6_1 through 6_3 that are within the parent experimental unit, REFID=F
Row 11:	Shows the value of REFID=G, This REFID refers to the trial set with a SETCD of 'SetG', as defined in the trial set dataset, tx.xpt. LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 12-14:	Show the values of three observational units 7_1 through 7_3 that are within the parent experimental unit, REFID=F
Row 15:	Shows the value of REFID=R. This REFID refers to the trial set with a SETCD of 'SetG', as defined in the trial set dataset, tx.xpt. LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 16-18:	Show the values of three observational units 18_1 through 18_3 that are within the parent experimental unit, REFID=F

Dataset2

tableid	relref.xpt

1.For each Unique GNTXAID (For each unique value in Parent, there must be one and only one record in REFID column with a value matching that Parent value.)

"For each PARENT value within the same GNTXAID value there must be one and only one record with REFID = the value in PARENT"

2. The value of level for a record with Parent populated, that level must be one greater than it’s parent record.

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	8325064	Ames	SetA	0_3	A	2	OBSERVATIONAL UNIT
5	8325064	Ames	SetA	0_4	A	2	OBSERVATIONAL UNIT
6	8325064	Ames	SetA	0_5	A	2	OBSERVATIONAL UNIT
7	8325064	Ames	SetF	F		1	TRIAL SET
8	8325064	Ames	SetF	6_1	F	2	OBSERVATIONAL UNIT
9	8325064	Ames	SetF	6_2	F	2	OBSERVATIONAL UNIT
10	8325064	Ames	SetF	6_3	F	2	OBSERVATIONAL UNIT
11	8325064	Ames	SetG	G		1	TRIAL SET
12	8325064	Ames	SetG	7_1	G	2	OBSERVATIONAL UNIT
13	8325064	Ames	SetG	7_2	G	2	OBSERVATIONAL UNIT
14	8325064	Ames	SetG	7_3	G	2	OBSERVATIONAL UNIT
15	8325064	Ames	SetG	R		1	TRIAL SET
16	8325064	Ames	SetR	18_1	R	2	OBSERVATIONAL UNIT
17	8325064	Ames	SetR	18_2	R	2	OBSERVATIONAL UNIT
18	8325064	Ames	SetR	18_3	R	2	OBSERVATIONAL UNIT

Dataset wrap

Name	gt

Rowcaps

Rows 1-5:	Show the number of revertant colonies per plate collected for each of five observational units GTREFID=0_1 through 0_5 (see description in the relref dataset).
Rows 6, 7:	Show summary values collected (MEAN, STANDARD DEVIATION) for GTREFID=A that apply to the entire trial set, SetA, as indicated by LEVEL=1 and LVLDESC=TRIAL SET for this REFID as shown in the relref dataset.
Rows 8-13:	Revertent colonies were counted for each of three plates/observational units (GTREFID=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 GTREFID=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 (GTREFID=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 (GTREFID=18_1 through 18_3).
Rows 23-25:	Show summary values collected (MEAN, STANDARD DEVIATION, and FOLD INCREASE) for GTREFID=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

Row	STUDYID	GNTXAID	DOMAIN	GTSEQ	GTREFID	GTTESTCD	GTTEST	GTORRES	GTORRESU	GTCOLSRT	GTSTRESC	GTSTRESN	GTSTRESU	GTSTAT	GTREASND	GTMETHOD	GTDTC
1	8325064	Ames	GT	1	0_1	RPP	Revertant Colony Numbers Per Plate	26	NOT APPLICABLE		26	26	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
2	8325064	Ames	GT	2	0_2	RPP	Revertant Colony Numbers Per Plate	35	NOT APPLICABLE		35	35	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
3	8325064	Ames	GT	3	0_3	RPP	Revertant Colony Numbers Per Plate	39	NOT APPLICABLE		39	39	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
4	8325064	Ames	GT	4	0_4	RPP	Revertant Colony Numbers Per Plate	35	NOT APPLICABLE		35	35	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
5	8325064	Ames	GT	5	0_5	RPP	Revertant Colony Numbers Per Plate	30	NOT APPLICABLE		30	30	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
6	8325064	Ames	GT	6	A	RPP	Revertant Colony Numbers Per Plate	33.0	NOT APPLICABLE	MEAN	33.0	33.0	NOT APPLICABLE				2015-08-03
7	8325064	Ames	GT	7	A	RPP	Revertant Colony Numbers Per Plate	5.0	NOT APPLICABLE	STANDARD DEVIATION	5.0	5.0	NOT APPLICABLE				2015-08-03
8	8325064	Ames	GT	1	6_1	RPP	Revertant Colony Numbers Per Plate	8	NOT APPLICABLE		8	8	NOT APPLICABLE			MANUALLY COUNTED	2015-08-03
9	8325064	Ames	GT	2	6_1	CYTOTOX	Cytotoxicity	Very thin background bacterial lawn			V						2015-08-03
10	8325064	Ames	GT	3	6_2	RPP	Revertant Colony Numbers Per Plate	10	NOT APPLICABLE		10	10	NOT APPLICABLE			MANUALLY COUNTED	2015-08-03
11	8325064	Ames	GT	4	6_2	CYTOTOX	Cytotoxicity	Very thin background bacterial lawn			V						2015-08-03
12	8325064	Ames	GT	5	6_3	RPP	Revertant Colony Numbers Per Plate	12	NOT APPLICABLE		12	12	NOT APPLICABLE			MANUALLY COUNTED	2015-08-03
13	8325064	Ames	GT	6	6_3	CYTOTOX	Cytotoxicity	Very thin background bacterial lawn			V						2015-08-03
14	8325064	Ames	GT	7	F	RPPMEAN	Mean Rev Colony Num Per Plate	10.0	NOT APPLICABLE	MEAN	10.0	10.0	NOT APPLICABLE				2015-08-03
15	8325064	Ames	GT	8	F	RPPSTDDV	Std Dev Rev Colony Num Per Plate	2.0	NOT APPLICABLE	STANDARD DEVIATION	2.0	2.0	NOT APPLICABLE				2015-08-03
16	8325064	Ames	GT	9	F	RPPFLDIC	Fold Increase Rev Colony Num Per Plate	0.3	NOT APPLICABLE	FOLD INCREASE	0.3	0.3	NOT APPLICABLE				2015-08-03
17	8325064	Ames	GT	1	5_1	CYTOTOX	Cytotoxicity	Toxic No Revertant Colonies			T			NOT DONE	TOO MUCH CYTOTOXICITY		2015-08-03
18	8325064	Ames	GT	2	5_2	CYTOTOX	Cytotoxicity	Toxic No Revertant Colonies			T			NOT DONE	TOO MUCH CYTOTOXICITY		2015-08-03
19	8325064	Ames	GT	3	5_3	CYTOTOX	Cytotoxicity	Toxic No Revertant Colonies			T			NOT DONE	TOO MUCH CYTOTOXICITY		2015-08-03
20	8325064	Ames	GT	1	18_1	RPP	Revertant Colony Numbers Per Plate	812	NOT APPLICABLE		812	812	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
21	8325064	Ames	GT	2	18_2	RPP	Revertant Colony Numbers Per Plate	912	NOT APPLICABLE		912	912	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
22	8325064	Ames	GT	3	18_3	RPP	Revertant Colony Numbers Per Plate	839	NOT APPLICABLE		839	839	NOT APPLICABLE			INSTRUMENT COUNTED	2015-08-03
23	8325064	Ames	GT	4	R	RPPMEAN	Mean Rev Colony Num Per Plate	854.3	NOT APPLICABLE	MEAN	854.3	854.3	NOT APPLICABLE				2015-08-03
24	8325064	Ames	GT	5	R	RPPSTDDV	Std Dev Rev Colony Num Per Plate	51.7	NOT APPLICABLE	STANDARD DEVIATION	51.7	51.7	NOT APPLICABLE				2015-08-03
25	8325064	Ames	GT	6	R	RPPFLDIC	Fold Increase Rev Colony Num Per Plate	6.4	NOT APPLICABLE	FOLD INCREASE	6.4	6.4	NOT APPLICABLE				2015-08-03

...

Page tree

Versions Compared

Old Version 102

New Version 103

Key