Show comments related to parent records in the Body Weights (BW), Laboratory Test Results (LB), Clinical Observations (CL), and Food and Water Consumption (FW) domains.
Row 1:
Shows a comment related to a single BW record having its BWSEQ = 1.
Row 2:
Shows a comment related to a single LB record having its LBSEQ = 2516.
Row 3:
Shows a comment related to a single CL record having its CLSEQ = 5642.
Row 4:
Shows a comment related to a single CL record having its CLSEQ = 7541.
Row 5:
Shows a comment related to a single FW record having its FWSEQ = 6542.
Row 6:
Shows a comment related to a single FW record having its FWSEQ = 5621.
Row 7:
Shows how to incorporate comments that are longer than 200 characters.
Row 8:
Shows a comment related to the entire study (no particular domain); note that RDOMAIN is null and USUBJID is null.
Row 9:
Shows how to add a comment from a logbook not related to a domain; IDVAR and IDVARVAL are null and COREF is populated.
Row 10:
Shows how to add a comment related to a specific domain, but unrelated to a specific subject or record; USUBJID, IDVAR, and IDVARVAL are null.
co.xpt
co.xpt
Row
STUDYID
DOMAIN
RDOMAIN
USUBJID
COSEQ
IDVAR
IDVARVAL
COREF
COVAL
COVAL1
COVAL2
COEVAL
CODTC
CODY
1
ABC123
CO
BW
ABC123-1001
1
BWSEQ
1
animal reweighed
TECH
2
ABC123
CO
LB
ABC123-1001
3
LBSEQ
2516
sample taken peri-mortem
3
ABC123
CO
CL
ABC123-1001
4
CLSEQ
5642
during mortality check
4
ABC123
CO
CL
ABC123-1003
5
CLSEQ
7541
fur wet pre-rx
5
ABC123
CO
FW
ABC123-1001
6
FWSEQ
6542
100g warm water add to 400g of pmi certified 5007
6
ABC123
CO
FW
ABC123-1002
7
FWSEQ
5621
food supplement
7
ABC123
CO
TF
ABC123-1002
8
TFSEQ
88530
Interstitial fibrosis and inflammatory infiltrates and dilated tubules filled with protein casts. Pigment and mineralization is seen in tubular epithelial cells. The glomerulus shows an increased
mesangial proliferation with basement membrane thickening and adhesions are present between the glomerular tuft and capsular wall. There is a slight increase in the size and number of parietal cells
in Bowman's capsule.
8
ABC123
CO
11
HVAC failure so the animals didn't have cooling
TECH
2006-07-19T08:30
84
9
ABC123
CO
12
Logbook page 650
Comment for logbook.
STUDY DIRECTOR
2006-07-19
84
10
ABC123
CO
BW
13
The scale was not calibrated as scheduled in week 2