Page History

Day 8 relationships are the same as those shown in Example 1.

Dataset wrap

Name	relrec

Rowcaps

RELID 1	Indicates records with PCSEQ values of 1-12 are related to records with PPSEQ values of 1-7.
RELID 2	Indicates records with PCSEQ values of 1-7 and 10-12 are related to records with PPSEQ values of 4 and 5.

Dataset2

Row	STUDYID	RDOMAIN	USUBJID	IDVAR	IDVARVAL	RELID
1	ABC-123	PC	ABC-123-0001	PCSEQ	1	1
2	ABC-123	PC	ABC-123-0001	PCSEQ	2	1
3	ABC-123	PC	ABC-123-0001	PCSEQ	3	1
4	ABC-123	PC	ABC-123-0001	PCSEQ	4	1
5	ABC-123	PC	ABC-123-0001	PCSEQ	5	1
6	ABC-123	PC	ABC-123-0001	PCSEQ	6	1
7	ABC-123	PC	ABC-123-0001	PCSEQ	7	1
8	ABC-123	PC	ABC-123-0001	PCSEQ	8	1
9	ABC-123	PC	ABC-123-0001	PCSEQ	9	1
10	ABC-123	PC	ABC-123-0001	PCSEQ	10	1
11	ABC-123	PC	ABC-123-0001	PCSEQ	11	1
12	ABC-123	PC	ABC-123-0001	PCSEQ	12	1
13	ABC-123	PP	ABC-123-0001	PPSEQ	1	1
14	ABC-123	PP	ABC-123-0001	PPSEQ	2	1
15	ABC-123	PP	ABC-123-0001	PPSEQ	3	1
16	ABC-123	PP	ABC-123-0001	PPSEQ	6	1
17	ABC-123	PP	ABC-123-0001	PPSEQ	7	1
18	ABC-123	PC	ABC-123-0001	PCSEQ	1	2
19	ABC-123	PC	ABC-123-0001	PCSEQ	2	2
20	ABC-123	PC	ABC-123-0001	PCSEQ	3	2
21	ABC-123	PC	ABC-123-0001	PCSEQ	4	2
22	ABC-123	PC	ABC-123-0001	PCSEQ	5	2
23	ABC-123	PC	ABC-123-0001	PCSEQ	6	2
24	ABC-123	PC	ABC-123-0001	PCSEQ	7	2
25	ABC-123	PC	ABC-123-0001	PCSEQ	10	2
26	ABC-123	PC	ABC-123-0001	PCSEQ	11	2
27	ABC-123	PC	ABC-123-0001	PCSEQ	12	2
28	ABC-123	PP	ABC-123-0001	PPSEQ	4	2
29	ABC-123	PP	ABC-123-0001	PPSEQ	5	2

Page tree