Example

This example shows masses with additional tests collected.

TOBA-54 - Getting issue details... STATUS

Rows 1-10:Reflect the findings for the third mass of subject A0001043, observed on the lower abdomen.
Rows 11-20:Reflect the findings for the first mass of subject A0001201, observed on the mid tail.

pm.xpt

pm.xpt

RowSTUDYIDDOMAINUSUBJIDPMSEQPMSPIDPMTESTCDPMTESTPMORRESPMORRESUPMSTRESCPMSTRESNPMSTRESUPMLOCPMDTCPMDYPMNOMDY
1123456-APMA0001043102MASS 3SHAPEShapeRound
Round

LOWER ABDOMEN2001-09-16T09:59:044242
2123456-APMA0001043103MASS 3DEPTHDepth0.4mm0.40.4mmLOWER ABDOMEN2001-09-16T09:59:044242
3123456-APMA0001043104MASS 3DIAMETERDiameter4.7mm4.74.7mmLOWER ABDOMEN2001-09-16T09:59:044242
4123456-APMA0001043105MASS 3LENGTHLength1.6mm1.61.6mmLOWER ABDOMEN2001-09-16T09:59:044242
5123456-APMA0001043106MASS 3WIDTHWidth1.4mm1.41.4mmLOWER ABDOMEN2001-09-16T09:59:044242
6123456-APMA0001043107MASS 3CONSISTConsistencyHard
Hard

LOWER ABDOMEN2001-09-16T09:59:044242
7123456-APMA0001043108MASS 3COLORColorYellow
Yellow

LOWER ABDOMEN2001-09-16T09:59:044242
8123456-APMA0001043109MASS 3HAIRCOVHair CoverY
Y

LOWER ABDOMEN2001-09-16T09:59:044242
9123456-APMA0001043110MASS 3ULCERUlcerationNON-ULCERATED
NON-ULCERATED

LOWER ABDOMEN2001-09-16T09:59:044242
10123456-APMA0001043111MASS 3DESCRDescriptionScabbed, Red
Scabbed, Red

LOWER ABDOMEN2001-09-16T09:59:044242
11123456-APMA0001201256MASS 1SHAPEShapeOval
Oval

MID TAIL2001-09-23T11:23:514949
12123456-APMA0001201257MASS 1DEPTHDepth1.0mm1.01mmMID TAIL2001-09-23T11:23:514949
13123456-APMA0001201258MASS 1DIAMETERDiameter6.1mm6.16.1mmMID TAIL2001-09-23T11:23:514949
14123456-APMA0001201259MASS 1LENGTHLength2.1mm2.12.1mmMID TAIL2001-09-23T11:23:514949
15123456-APMA0001201260MASS 1WIDTHWidth1.6mm1.61.6mmMID TAIL2001-09-23T11:23:514949
16123456-APMA0001201261MASS 1CONSISTConsistencySoft
Soft

MID TAIL2001-09-23T11:23:514949
17123456-APMA0001201262MASS 1COLORColorBrown
Brown

MID TAIL2001-09-23T11:23:514949
18123456-APMA0001201263MASS 1HAIRCOVHair CoverNo
N

MID TAIL2001-09-23T11:23:514949
19123456-APMA0001201264MASS 1ULCERUlcerationULCERATED
ULCERATED

MID TAIL2001-09-23T11:23:514949
20123456-APMA0001201265MASS 1DESCRDescriptionScratch marks around base of mass.
Scratch marks around base of mass.

MID TAIL2001-09-23T11:23:514949
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Example

This example shows tests where the observations were collected as single descriptions in the collection system.

Row 1:Reflects the finding for the first mass of subject ABC0013, observed on the left thoracic region. The collected result of the mass is the description of its size, along with additional information collected on the ulceration. Note that the PMORRES field contains all originally collected text, and that the PMSTRESC field has the location removed and submitted in PMLOC.
Row 2:Reflects the finding for the first mass of subject ABC0016, observed on the dorsal side of the tail. The collected result of the mass is a description of its size, along with some additional information collected on the color and ulceration.
Row 3:Reflects the finding for the second mass of subject ABC0016, observed on the right hind limb. The collected result of the mass is just a description of its size.

pm.xpt

pm.xpt

RowSTUDYIDDOMAINUSUBJIDPMSEQPMSPIDPMTESTCDPMTESTPMORRESPMORRESUPMSTRESCPMSTRESNPMSTRESUPMLOCPMDTCPMDYPMNOMDY
1ABC-123PMABC001317MASS 1DESCRDescription2.0 mm x 1.1 mm, Ulcerated, Left Thoracic Region
2.0 mm x 1.1 mm, Ulceration

LEFT THORACIC REGION2000-03-114242
2ABC-123PMABC001619MASS 1DESCRDescription3.5 mm x 3.4 mm, Red, Ulcerated, Dorsal Tail
3.5 mm x 3.4 mm, Red, Moderate Ulceration

Dorsal TAIL2000-03-124343
3ABC-123PMABC001625MASS 2DESCRDescription1.1 mm x 0.9 mm, Right Hind Limb
1.1 mm x 0.9 mm

RIGHT HIND LIMB2000-03-144545
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Example

This example shows masses with additional tests collected.

TOBA-54 - Getting issue details... STATUS

Rows 1-10:Reflect the findings for the third mass of subject A0001043, observed on the lower abdomen.
Rows 11-20:Reflect the findings for the first mass of subject A0001201, observed on the mid tail.

pm.xpt

pm.xpt

RowSTUDYIDDOMAINUSUBJIDPMSEQPMSPIDPMTESTCDPMTESTPMORRESPMORRESUPMSTRESCPMSTRESNPMSTRESUPMLOCPMDTCPMDYPMNOMDY
1123456-APMA0001043102MASS 3SHAPEShapeRound
Round

LOWER ABDOMEN2001-09-16T09:59:044242
2123456-APMA0001043103MASS 3DEPTHDepth0.4mm0.40.4mmLOWER ABDOMEN2001-09-16T09:59:044242
3123456-APMA0001043104MASS 3DIAMETERDiameter4.7mm4.74.7mmLOWER ABDOMEN2001-09-16T09:59:044242
4123456-APMA0001043105MASS 3LENGTHLength1.6mm1.61.6mmLOWER ABDOMEN2001-09-16T09:59:044242
5123456-APMA0001043106MASS 3WIDTHWidth1.4mm1.41.4mmLOWER ABDOMEN2001-09-16T09:59:044242
6123456-APMA0001043107MASS 3CONSISTConsistencyHard
Hard

LOWER ABDOMEN2001-09-16T09:59:044242
7123456-APMA0001043108MASS 3COLORColorYellow
Yellow

LOWER ABDOMEN2001-09-16T09:59:044242
8123456-APMA0001043109MASS 3HAIRCOVHair CoverY
Y

LOWER ABDOMEN2001-09-16T09:59:044242
9123456-APMA0001043110MASS 3ULCERUlcerationNON-ULCERATED
NON-ULCERATED

LOWER ABDOMEN2001-09-16T09:59:044242
10123456-APMA0001043111MASS 3DESCRDescriptionScabbed, Red
Scabbed, Red

LOWER ABDOMEN2001-09-16T09:59:044242
11123456-APMA0001201256MASS 1SHAPEShapeOval
Oval

MID TAIL2001-09-23T11:23:514949
12123456-APMA0001201257MASS 1DEPTHDepth1.0mm1.01mmMID TAIL2001-09-23T11:23:514949
13123456-APMA0001201258MASS 1DIAMETERDiameter6.1mm6.16.1mmMID TAIL2001-09-23T11:23:514949
14123456-APMA0001201259MASS 1LENGTHLength2.1mm2.12.1mmMID TAIL2001-09-23T11:23:514949
15123456-APMA0001201260MASS 1WIDTHWidth1.6mm1.61.6mmMID TAIL2001-09-23T11:23:514949
16123456-APMA0001201261MASS 1CONSISTConsistencySoft
Soft

MID TAIL2001-09-23T11:23:514949
17123456-APMA0001201262MASS 1COLORColorBrown
Brown

MID TAIL2001-09-23T11:23:514949
18123456-APMA0001201263MASS 1HAIRCOVHair CoverNo
N

MID TAIL2001-09-23T11:23:514949
19123456-APMA0001201264MASS 1ULCERUlcerationULCERATED
ULCERATED

MID TAIL2001-09-23T11:23:514949
20123456-APMA0001201265MASS 1DESCRDescriptionScratch marks around base of mass.
Scratch marks around base of mass.

MID TAIL2001-09-23T11:23:514949
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Example

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.

pm.xpt

pm.xpt

RowSTUDYIDDOMAINUSUBJIDPMSEQPMGRPIDPMSPIDPMTESTCDPMTESTPMORRESPMORRESUPMSTRESCPMSTRESNPMSTRESUPMLOCPMDTCPMDYPMNOMDY
11A412-ZPM00540101231MASS 1LENGTHLength2.1mm2.12.1mmMID TAIL
77
21A412-ZPM00540101241MASS 1WIDTHWidth2.1mm2.12.1mmMID TAIL
77
31A412-ZPM00540101251MASS 1ULCERUlcerationNON-ULCERATED



MID TAIL
77
41A412-ZPM00540101651MASS 2LENGTHLength1.3mm1.31.3mmMID TAIL
77
51A412-ZPM00540101661MASS 2WIDTHWidth0.9mm0.90.9mmMID TAIL
77
61A412-ZPM00540101671MASS 2ULCERUlcerationULCERATED



MID TAIL
77
71A412-ZPM00540101911MASS 3LENGTHLength3.3mm3.33.3mmMID TAIL
1414
81A412-ZPM00540101921MASS 3WIDTHWidth3.1mm3.13.1mmMID TAIL
1414
91A412-ZPM00540101931MASS 3ULCERUlcerationNON-ULCERATED



MID TAIL
1414
101A412-ZPM005401011551MASS 4LENGTHLength1.9mm1.91.9mmMID TAIL
2121
111A412-ZPM005401011561MASS 4WIDTHWidth1.8mm1.81.8mmMID TAIL
2121
121A412-ZPM005401011571MASS 4ULCERUlcerationNON-ULCERATED



MID TAIL
2121
131A412-ZPM005401011701MASS 5LENGTHLength1.5mm1.51.5mmMID TAIL
2121
141A412-ZPM005401011711MASS 5WIDTHWidth1.2mm1.21.2mmMID TAIL
2121
151A412-ZPM005401011721MASS 5ULCERUlcerationULCERATED



MID TAIL
2121
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

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.
$titleHtml

relrec.xpt

RowSTUDYIDRDOMAINUSUBJIDIDVARIDVARVALRELTYPERELID
1F012-007PM001-0329PMSPIDMASS 3
34
2F012-007CL001-0329CLSPIDMASS 3
34
3F012-007MA001-0329MASPIDMASS 3
34
4F012-007MI001-0329MISPIDMASS 3
34
5F012-007TF001-0329TFSPIDMASS 3
34
6F012-007PM001-0450PMSPIDMASS 2
76
7F012-007CL001-0450CLGRPID44
76
8F012-007MA001-0450MASPIDMASS 2
76
9F012-007MI001-0450MISPIDMASS 2
76
10F012-007TF001-0450TFSPIDMASS 2
76
11F012-007PM001-0501PMSEQ104
89
12F012-007TF001-0501TFSEQ43
89
13F012-007PM001-0563PMGRPID17
91
14F012-007CL001-0563CLGRPID7
91
15F012-007MA001-0563MASEQ26
91
16F012-007MI001-0563MISEQ47
91
17F012-007MI001-0563MISEQ48
91
18F012-007TF001-0563TFSEQ23
91
19F012-007TF001-0563TFSEQ24
91
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

  • No labels