Method A (Many to many, using PCGRPID and PPGRPID)
RELID 1 | indicates all PC records with GRPID = DY1_DRGX are related to all PP records with GRPID = DY1DRGX. |
$titleHtml
relrec.xpt
Row | STUDYID | RDOMAIN | USUBJID | IDVAR | IDVARVAL | RELTYPE | RELID |
---|
1 | ABC-123 | PC | ABC-123-0001 | PCGRPID | DY1_DRGX |
| 1 |
---|
2 | ABC-123 | PP | ABC-123-0001 | PPGRPID | DY1DRGX |
| 1 |
---|
$warningHtml
Method B (One to many, using PCSEQ and PPGRPID)
RELID 1 | indicates records with PCSEQ values of 1-12 are related to records with PPGRPID = DY1DRGX. |
$titleHtml
relrec.xpt
Row | STUDYID | RDOMAIN | USUBJID | IDVAR | IDVARVAL | RELTYPE | 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 | PPGRPID | DY1DRGX |
| 1 |
---|
$warningHtml
Method C (Many to one, using PCGRPID and PPSEQ)
RELID 1 | indicates records with a PCGRPID value of DY1_DRGX are related to records with PPSEQ values of 1-7. |
RELID 2 | indicates records with a PCGRPID value of DY8_DRGX are related to records with PPSEQ values of 8-14. |
$titleHtml
relrec.xpt
Row | STUDYID | RDOMAIN | USUBJID | IDVAR | IDVARVAL | RELTYPE | RELID |
---|
1 | ABC-123 | PC | ABC-123-0001 | PCGRPID | DY1_DRGX |
| 1 |
---|
2 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 1 |
| 1 |
---|
3 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 2 |
| 1 |
---|
4 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 3 |
| 1 |
---|
5 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 4 |
| 1 |
---|
6 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 5 |
| 1 |
---|
7 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 6 |
| 1 |
---|
8 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 7 |
| 1 |
---|
9 | ABC-123 | PC | ABC-123-0001 | PCGRPID | DY8_DRGX |
| 2 |
---|
10 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 8 |
| 2 |
---|
11 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 9 |
| 2 |
---|
12 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 10 |
| 2 |
---|
13 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 11 |
| 2 |
---|
14 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 12 |
| 2 |
---|
15 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 13 |
| 2 |
---|
16 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 14 |
| 2 |
---|
$warningHtml
Method D (One to one, using PCSEQ and PPSEQ)
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 13-24 are related to records with PPSEQ values of 8-14. |
$titleHtml
relrec.xpt
Row | STUDYID | RDOMAIN | USUBJID | IDVAR | IDVARVAL | RELTYPE | 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 | 4 |
| 1 |
---|
17 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 5 |
| 1 |
---|
18 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 6 |
| 1 |
---|
19 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 7 |
| 1 |
---|
20 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 13 |
| 2 |
---|
21 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 14 |
| 2 |
---|
22 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 15 |
| 2 |
---|
23 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 16 |
| 2 |
---|
24 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 17 |
| 2 |
---|
25 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 18 |
| 2 |
---|
26 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 19 |
| 2 |
---|
27 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 20 |
| 2 |
---|
28 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 21 |
| 2 |
---|
29 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 22 |
| 2 |
---|
30 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 23 |
| 2 |
---|
31 | ABC-123 | PC | ABC-123-0001 | PCSEQ | 24 |
| 2 |
---|
32 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 8 |
| 2 |
---|
33 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 9 |
| 2 |
---|
34 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 10 |
| 2 |
---|
35 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 11 |
| 2 |
---|
36 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 12 |
| 2 |
---|
37 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 13 |
| 2 |
---|
38 | ABC-123 | PP | ABC-123-0001 | PPSEQ | 14 |
| 2 |
---|
$warningHtml