...
Dataset wrap |
---|
|
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 |
---|
| 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 | 2012-05-10 | 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 | 2012-10-08 | 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 | 2012-04-30 |
|
|
Dataset wrap |
---|
|
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 | VISITNUM | VISIT | LBDTC | 1 | 1001 | LB | 1001-001 | 1 | 1 | CHOL | Cholesterol | 8.7 | mmol/L | 8.7 | 8.7 | mmol/L | 1 | Visit 1 | 2012-05-10 | 2 | 1001 | LB | 1001-001 | 2 | 1 | CHOLHDL | HDL Cholesterol | 1.7 | mmol/L | 1.7 | 1.7 | mmol/L | 1 | Visit 1 | 2012-05-10 | 3 | 1001 | LB | 1001-001 | 3 | 2 | CHOL | Cholesterol | 8.3 | mmol/L | 8.3 | 8.3 | mmol/L | 5 | Visit 5 | 2012-10-08 | 4 | 1001 | LB | 1001-001 | 4 | 2 | CHOLHDL | HDL Cholesterol | 2 | mmol/L | 2 | 2 | mmol/L | 5 | Visit 5 | 2012-10-08 | 5 | 1001 | LB | 1001-002 | 1 | 1 | CHOL | Cholesterol | 6.5 | mmol/L | 6.5 | 6.5 | mmol/L | 1 | Visit 1 | 2012-04-30 | 6 | 1001 | LB | 1001-002 | 2 | 1 | CHOLHDL | HDL Cholesterol | 2.1 | mmol/L | 2.1 | 2.1 | mmol/L | 1 | Visit 1 | 2012-04-30 |
|
|
Dataset wrap |
---|
|
Rowcaps |
---|
Row 1: | Represents sex and age values used to calculate the risk scores for subject 1001-001 shown in the RS domain above. | Row 2: | Represents sex and age values used to calculate the risk score for subject1001-002 shown in the RS domain above. |
|
Dataset2 |
---|
| Row | STUDYID | DOMAIN | USUBJID | SUBJID | SEX | BRTHDTC | AGE | AGEU | 1 | 1001 | DM | 1001-001 | 1 | F | 1972-06-24 | 39 | YEARS | 2 | 1001 | DM | 1001-002 | 2 | M | 1947-02-02 | 65 | |
|
|
Dataset wrap |
---|
|
Rowcaps |
---|
Rows 1-2: | Represent blood pressure values used to calculate the risk scores for subject 1001-001 shown in the RS domain above. | Row 3: | Represents blood pressure values used to calculate the risk score for subject 1001-002 shown in the RS domain above. |
|
Dataset2 |
---|
| | STUDYID | DOMAIN | USUBJID | VSSEQ | VSLNKID | VSTESTCD | VSTEST | VSORRES | VSORRESU | VSORRESC | VSSTRESN | VSSTRESU | VISITNUM | VISIT | VSDTC |
---|
1 | 1001 | VS | 1001-001 | 1 | 1 | SYSBP | Systolic Blood Pressure | 140 | mmHg | 140 | 140 | mmHg | 1 | VISIT 1 | 2012-05-10 | 2 | 1001 | VS | 1001-001 | 2 | 2 | SYSBP | Systolic Blood Pressure | 145 | mmHg | 145 | 145 | mmHg | 5 | VISIT 5 | 2012-10-08 | 3 | 1001 | VS | 1001-002 | 1 | 1 | SYSBP | Systolic Blood Pressure | 142 | mmHg | 142 | 142 | mmHg | 1 | VISIT 1 | 2012-04-30 |
|
|
Dataset wrap |
---|
|
Rowcaps |
---|
Rows 1-4: | Represent diabetes and rheumatoid arthritis medical history used to calculate the risk scores for subject 1001-001 shown in the RS domain above. | Rows 5-6: | Represent diabetes and rheumatoid arthritis medical history used to calculate the risk score for subject 1001-002 shown in the RS domain above. |
|
Dataset2 |
---|
| Row | STUDYID | DOMAIN | USUBJID | MHSEQ | MHLNKID | MHTERM | MHPRESP | MHOCCUR | VISITNUM | VISIT | MHDTC | 1 | 1001 | MH | 1001-001 | 1 | 1 | DIABETES | Y | N | 1 | Visit 1 | 2012-05-10 | 2 | 1001 | MH | 1001-001 | 2 | 1 | RHEUMATOID ARTHRITIS | Y | N | 1 | Visit 1 | 2012-05-10 | 3 | 1001 | MH | 1001-001 | 3 | 2 | DIABETES | Y | Y | 5 | Visit 5 | 2012-10-08 | 4 | 1001 | MH | 1001-001 | 4 | 2 | RHEUMATOID ARTHRITIS | Y | N | 5 | Visit 5 | 2012-10-08 | 5 | 1001 | MH | 1001-002 | 1 | 1 | DIABETES | Y | Y | 1 | Visit 1 | 2012-04-30 | 6 | 1001 | MH | 1001-002 | 2 | 1 | RHEUMATOID ARTHRITIS | Y | N | 1 | Visit 1 | 2012-04-30 |
|
|
Dataset wrap |
---|
|
Rowcaps |
---|
Rows 1-4: | Represent family history of stroke and coronary heart disease used to calculate the risk scores for subject 1001-001 shown in the RS domain above. | Rows 5-6: | Represent family history of stroke and coronary heart disease used to calculate the risk score for subject 1001-002 shown in the RS domain above. |
|
Dataset2 |
---|
| Row | STUDYID | DOMAIN | RSUBJID | MHSEQ | MHLNKID | SREL | MHTERM | MHPRESP | MHORSUR | VISITNUM | VISIT | MHDTC | 1 | 1001 | APMH | 1001-001 | 1 | 1 | FAMILY MEMBER, BIOLOGICAL | STROKE | Y | N | 1 | Visit 1 | 2012-05-10 | 2 | 1001 | APMH | 1001-001 | 2 | 1 | FAMILY MEMBER, BIOLOGICAL | CORONARY HEART DISEASE | Y | N | 1 | Visit 1 | 2012-05-10 | 3 | 1001 | APMH | 1001-001 | 3 | 2 | FAMILY MEMBER, BIOLOGICAL | STROKE | Y | N | 5 | Visit 5 | 2012-10-08 | 4 | 1001 | APMH | 1001-001 | 4 | 2 | FAMILY MEMBER, BIOLOGICAL | CORONARY HEART DISEASE | Y | N | 5 | Visit 5 | 2012-10-08 | 5 | 1001 | APMH | 1001-002 | 1 | 1 | FAMILY MEMBER, BIOLOGICAL | STROKE | Y | Y | 1 | Visit 1 | 2012-04-30 | 6 | 1001 | APMH | 1001-002 | 2 | 1 | FAMILY MEMBER, BIOLOGICAL | CORONARY HEART DISEASE | Y | Y | 1 | Visit 1 | 2012-04-30 |
|
|
Dataset wrap |
---|
|
Rowcaps |
---|
Rows 1-2: | Represent smoking information used to calculate the risk scores for subject 1001-001 shown in the RS domain above. | Row 3: | Represents smoking information used to calculate the risk score for subject 1001-002 shown in the RS domain above. |
|
Dataset2 |
---|
| Row | STUDYID | DOMAIN | USUBJID | SUSEQ | SULNKID | SUTRT | SUCAT | SUDOSE | SUDOSU | SUDOSFQ | SUSTRTPT | SUSTTPT | SUENRTPT | SUENTPT | SUPRESP | SUOCCUR | VISITNUM | VISIT | SUDTC |
---|
1 | 1001 | SU | 1001-001 | 1 | 1 | CIGARETTES | TOBACCO | 0 | CIGARETTE | PER DAY |
|
|
|
| Y | N | 1 | VISIT 1 | 2012-05-10 | 2 | 1001 | SU | 1001-001 | 2 | 2 | CIGARETTES | TOBACCO | 5 | CIGARETTE | PER DAY | BEFORE | 2012-10-08 | ONGOING | 2012-10-08 | Y | Y | 5 | VISIT 5 | 2012-10-08 | 3 | 1001 | SU | 1001-002 | 1 | 1 | CIGARETTES | TOBACCO | 20 | CIGARETTE | PER DAY | BEFORE | 2012-04-30 | ONGOING | 2012-04-30 | Y | Y | 1 | VISIT 1 | |
|
|
The RELREC table below shows how to define the one-to-one relationship (as defined in RELTYPE), or the one-to-many relationship between the RS domain and the LB, VS, SU, and the MH domains for the ASSIGN Risk Score.
...