Page History

...

Dataset wrap

Name	rs

Rowcaps

Rows 1-2:	Represent one subject who had a risk score calculated at two different visits.
Row 3:	Represents one subject who had a risk score calculated at only one visit.

Dataset2

tableid	rs.xpt

Row	STUDYID	DOMAIN	USUBJID	RSSEQ	RSLNKID	RSTESTCD	RSTEST	RSCAT	RSORRES	RSORRESU	RSSTRESC	RSSTRESN	RSSTRESU	RSBLFL	RSEVAL	VISITNUM	VISIT	RSDTC
1	1001	RS	1001-001	1	1	ASSG0101	ASSG01-ASSIGN CVD Risk Score	ASSIGN CVD 10-YEAR RISK	3	%	3	3	%	Y	INVESTIGATOR	1	Visit 1	5/10/12
2	1001	RS	1001-001	2	2	ASSG0101	ASSG01-ASSIGN CVD Risk Score	ASSIGN CVD 10-YEAR RISK	8	%	8	8	%		INVESTIGATOR	5	Visit 5	10/8/12
3	1001	RS	1001-002	1	1	ASSG0101	ASSG01-ASSIGN CVD Risk Score	ASSIGN CVD 10-YEAR RISK	55	%	55	55	%	Y	INVESTIGATOR	1	Visit 1	4/30/12

The following dataset represents source-data GCS scores which were input into the APACHE II. Note that RSSEQ is set to start at 101 for each subject within this split RS domain as APACHE II is only collected once during the study (at VISITNUM=1). RSGRPID in the split domain below matches RSGRPID for the corresponding record in the preceding RS domain example.

Dataset wrap

Name	dm

Dataset2

tableid	dm.xpt

Row	STUDYID	DOMAIN	USUBJID	SUBJID	SEX	BRTHDTC	AGE	AGEU
1	1001	DM	1001-001	1	F	6/24/1972	39	YEARS
2	1001	DM	1001-002	2	M	2/2/1947	65	YEARS

The following dataset represents source-data vital signs tests that were input into the APACHE II. Note that the result values fall within the ranges contained in RSORRES in the corresponding RS record. VSLNKID matches RSLNKID for each corresponding record in the RS domain example above.

Dataset wrap

Name	lb

Rowcaps

Rows 1-4:	Represent lab values used to calculate the risk scores for subject 1001-001 shown in the RS domain above.
Rows 5-6:	Represent lab values used to calculate the risk score for subject 1001-002 shown in the RS domain above.

Dataset2

Row	STUDYID	DOMAIN	USUBJID	LBSEQ	LBLNKID	LBTESTCD	LBTEST	LBORRES	LBORRESU	LBSTRESC	LBSTRESN	LBSTRESU	LBSPEC	LBBLFL	VISITNUM	LBDTC
1	STUDYX	LB	P0001	1	AP05	PO2	Partial Pressure Oxygen	65	mmHg	65	65	mmHg	ARTERIAL BLOOD	Y	1	2014-06-24
2	STUDYX	LB	P0001	2	AP06	PH	pH	7.12		7.12	7.12		ARTERIAL BLOOD	Y	1	2014-06-24
3	STUDYX	LB	P0001	3	AP07	SODIUM	Sodium	150	mmol/L	150	150	mmol/L	SERUM	Y	1	2014-06-24
4	STUDYX	LB	P0001	4	AP08	K	Potassium	3.7	mmol/L	3.7	3.7	mmol/L	SERUM

Dataset wrap

Name	vs

Dataset2

Row	STUDYID	DOMAIN	USUBJID	VSSEQ	VSLNKID	VSTESTCD	VSTEST	VSORRES	VSORRESU	VSSTRESC	VSSTRESN	VSSTRESU	VSLOC	VSBLFL	VISITNUM	VSDTC
1	STUDYX	VS	P0001	1	AP01	TEMP	Temperature	38.9	C	38.9	38.9	C	RECTUM	Y	1	2014-06-24
25	STUDYX	VSLB	P0001	5	2AP09	AP02CREAT	MAP	Mean Arterial Pressure	117	mmHg	117	117	Creatinine	0.5	mg/dL	0.5	0.5	mg/dL	SERUMmmHg	Y	1	2014-06-24
36	STUDYX	VSLB	P0001	36	AP03AP10	HRHCT	Heart Rate	98	beats/min	98	98	Hematocrit	24.6	%	24.6	24.6	%beats/min		Y	1	2014-06-24
47	STUDYX	VSLB	P0001	47	AP04AP11	RESPWBC	Respiratory RateLeukocytes	5442	breaths10^9/minL	544254	42	breaths10^9/minL		Y	1	2014-06-24

The following dataset represents the 7 source-data lab tests that GCS scores which were input into the APACHE II. Note that the result values fall within the ranges contained in RSORRES in the corresponding RS record. LBLNKID matches RSLNKID for each RSSEQ is set to start at 101 for each subject within this split RS domain as APACHE II is only collected once during the study (at VISITNUM=1). RSGRPID in the split domain below matches RSGRPID for the corresponding record in the preceding RS domain example.

Dataset wrap

Name	lbdm

Dataset2

tableid	dm.xpt

LBSEQLBLNKIDLBTESTCDLBTESTLBORRESLBORRESULBSTRESCLBSTRESNLBSTRESULBSPEC

Row	STUDYID	DOMAIN	USUBJID	SUBJID	SEX	BRTHDTC	AGE	AGEU
1	1001	DM	1001-001	1	LBBLFL	VISITNUM	LBDTC	F	6/24/1972	39	YEARS
2	1001	DM	1001-002	2	M	2/2/1947	65	YEARS

The following dataset represents source-data vital signs tests that were input into the APACHE II. Note that the result values fall within the ranges contained in RSORRES in the corresponding RS record. VSLNKID matches RSLNKID for each corresponding record in the RS domain example above.

Dataset wrap

Name	vs

Dataset2

Row	STUDYID	DOMAIN	USUBJID	VSSEQ	VSLNKID	VSTESTCD	VSTEST	VSORRES	VSORRESU	VSSTRESC	VSSTRESN	VSSTRESU	VSLOC	VSBLFL	VISITNUM	VSDTC
1	STUDYX	VS	P0001	1	AP01	TEMP	Temperature	38.9	C	38.9	38.9	C	RECTUM
1	STUDYX	LB	P0001	1	AP05	PO2	Partial Pressure Oxygen	65	mmHg	65	65	mmHg	ARTERIAL BLOOD	Y	1	2014-06-24
2	STUDYX	LB	P0001	2	AP06	PH	pH	7.12	7.12	7.12	ARTERIAL BLOOD	Y	1	2014-06-24
3	STUDYX	LB	P0001	3	AP07	SODIUM	Sodium	150	mmol/L	150	150	mmol/L	SERUM	Y	1	2014-06-24
4	STUDYX	LB	P0001	4	AP08	K	Potassium	3.7	mmol/L	3.7	3.7	mmol/L	SERUM	Y	1	2014-06-24
52	STUDYX	LBVS	P0001	52	AP09AP02	CREATMAP	Creatinine	0.5	mg/dL	0.5	0.5	mg/dL	Mean Arterial Pressure	117	mmHg	117	117	mmHgSERUM		Y	1	2014-06-24
63	STUDYX	LBVS	P0001	63	AP10AP03	HCTHR	Hematocrit	24.6	%	24.6	24.6	Heart Rate	98	beats/min	98	98	beats/min%		Y	1	2014-06-24
74	STUDYX	LBVS	P0001	74	AP11AP04	WBCRESP	LeukocytesRespiratory Rate	4254	10^9breaths/Lmin	425442	54	10^9breaths/Lmin		Y	1	2014-06-24

The following dataset represents the 7 source-data lab tests that were input into the APACHE II. Note that the result values fall within the ranges contained in RSORRES in the corresponding RS record. LBLNKID matches RSLNKID for each corresponding record in the preceding RS domain example.

The following dataset represents the one-to-one relationship (as defined in RELTYPE) between the RS and VS domains and between the RS and LB domains for the APACHE II.

...

Page tree

Versions Compared

Old Version 12

New Version 13

Key