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

...

Page tree

Versions Compared

Old Version 97

New Version 98

Key