View Source

This example demonstrates a case where masses converge and diverge.

Rows 1-15:	Reflect a case where subject 00540101 has 2 masses at day 7. The next week, these are observed as a single mass ("MASS 3"). The following week, the masses separate and are again observed as 2 single masses. All of the records are given a PMGRPID of 1, to establish their association.
Rows 1-6:	Reflect the findings for mass 1 and mass 2 on the first week of the study, observed on the mid tail. Rows 1-3 list the findings for mass 1, and rows 4-6 list the findings for mass 2.
Rows 7-9:	Reflect the findings for mass 3 (the convergence of mass 1 and mass 2 from the previous week) on the second week of the study.
Rows 10-15:	Reflect the findings for mass 4 and mass 5 (the divergence of mass 3 from the previous week) on the third week of the study.

Row	STUDYID	DOMAIN	USUBJID	PMSEQ	PMGRPID	PMSPID	PMTESTCD	PMTEST	PMORRES	PMORRESU	PMSTRESC	PMSTRESN	PMSTRESU	PMLOC	PMDY	PMNOMDY
1	1A412-Z	PM	00540101	23	1	MASS 1	LENGTH	Length	2.1	mm	2.1	2.1	mm	MID TAIL	7	7
2	1A412-Z	PM	00540101	24	1	MASS 1	WIDTH	Width	2.1	mm	2.1	2.1	mm	MID TAIL	7	7
3	1A412-Z	PM	00540101	25	1	MASS 1	ULCER	Ulceration	NON-ULCERATED					MID TAIL	7	7
4	1A412-Z	PM	00540101	65	1	MASS 2	LENGTH	Length	1.3	mm	1.3	1.3	mm	MID TAIL	7	7
5	1A412-Z	PM	00540101	66	1	MASS 2	WIDTH	Width	0.9	mm	0.9	0.9	mm	MID TAIL	7	7
6	1A412-Z	PM	00540101	67	1	MASS 2	ULCER	Ulceration	ULCERATED					MID TAIL	7	7
7	1A412-Z	PM	00540101	91	1	MASS 3	LENGTH	Length	3.3	mm	3.3	3.3	mm	MID TAIL	14	14
8	1A412-Z	PM	00540101	92	1	MASS 3	WIDTH	Width	3.1	mm	3.1	3.1	mm	MID TAIL	14	14
9	1A412-Z	PM	00540101	93	1	MASS 3	ULCER	Ulceration	NON-ULCERATED					MID TAIL	14	14
10	1A412-Z	PM	00540101	155	1	MASS 4	LENGTH	Length	1.9	mm	1.9	1.9	mm	MID TAIL	21	21
11	1A412-Z	PM	00540101	156	1	MASS 4	WIDTH	Width	1.8	mm	1.8	1.8	mm	MID TAIL	21	21
12	1A412-Z	PM	00540101	157	1	MASS 4	ULCER	Ulceration	NON-ULCERATED					MID TAIL	21	21
13	1A412-Z	PM	00540101	170	1	MASS 5	LENGTH	Length	1.5	mm	1.5	1.5	mm	MID TAIL	21	21
14	1A412-Z	PM	00540101	171	1	MASS 5	WIDTH	Width	1.2	mm	1.2	1.2	mm	MID TAIL	21	21
15	1A412-Z	PM	00540101	172	1	MASS 5	ULCER	Ulceration	ULCERATED					MID TAIL	21	21

This example demonstrates relating palpable mass findings to other domains, such as in the case of tumor findings.

Rows 1-5:	Reflect a relationship between the PM, CL, MA, MI, and TF domains, specifying that subject 001-0329's findings are related for matching --SPID values across the domains. This example would be defined for each animal and relevant domain where the --SPID field has been populated.
Rows 6-10:	Reflect an example where the related clinical signs for a mass were not a mass observation (e.g., a lump, a swelling). In this case, the clinical signs are grouped under a CLGRPID of 44 and related to the other domains --SPID of "MASS 2".
Rows 11-12:	Reflect an example of a relationship set up to relate a tumor finding (TFSEQ = "43") with its onset record (PMSEQ = "104").
Rows 13-19:	Reflect an example of a relationship between a number of specific observations across the domains. For example, the 2 tumor findings referenced (TFSEQ="23" and TFSEQ="24") pertain to 2 convergent tumors (similar to Example 4), so a collection of findings from palpable masses and clinical findings are related, with 1 macroscopic finding.

Row	STUDYID	RDOMAIN	USUBJID	IDVAR	IDVARVAL	RELID
1	F012-007	PM	001-0329	PMSPID	MASS 3	34
2	F012-007	CL	001-0329	CLSPID	MASS 3	34
3	F012-007	MA	001-0329	MASPID	MASS 3	34
4	F012-007	MI	001-0329	MISPID	MASS 3	34
5	F012-007	TF	001-0329	TFSPID	MASS 3	34
6	F012-007	PM	001-0450	PMSPID	MASS 2	76
7	F012-007	CL	001-0450	CLGRPID	44	76
8	F012-007	MA	001-0450	MASPID	MASS 2	76
9	F012-007	MI	001-0450	MISPID	MASS 2	76
10	F012-007	TF	001-0450	TFSPID	MASS 2	76
11	F012-007	PM	001-0501	PMSEQ	104	89
12	F012-007	TF	001-0501	TFSEQ	43	89
13	F012-007	PM	001-0563	PMGRPID	17	91
14	F012-007	CL	001-0563	CLGRPID	7	91
15	F012-007	MA	001-0563	MASEQ	26	91
16	F012-007	MI	001-0563	MISEQ	47	91
17	F012-007	MI	001-0563	MISEQ	48	91
18	F012-007	TF	001-0563	TFSEQ	23	91
19	F012-007	TF	001-0563	TFSEQ	24	91