i2b2 - GEM data load for GENVASC

Patient Request

UHLDWH.DWBRICCS.dbo.UVW_GENVASC_PATIENTS_GEM => UHLDBSQLCORP02.LLR_CSS.dbo.BRICCS_GENVASC_PATIENTS

Data Response

UHLDBSQLCORP02.LLR_CSS.dbo.Genvasc_Clinical_ReadCode => UHLDWH.DWBRICCS.dbo.Genvasc_Clinical_ReadCode

UHLDBSQLCORP02.LLR_CSS.dbo.Genvasc_Ethnic_ReadCode => UHLDWH.DWBRICCS.dbo.Genvasc_Ethnic_ReadCode

Health Check Read Codes

Field Name	Read Code v3	Concept Code
Cardiovascular disease risk assessment declined	XaN8t	HCK:0000486
Cardiovascular disease risk assessment offered	XaPl0	HCK:0000490
Informed consent given	XaLQR	HCK:0000485
Patient informed about research study	9Q...	HCK:0000466
Cigarette consumption	Ub1tI	HCK:0000470
Smoking cessation advice	Ua1Nz	HCK:0000468
Health education - smoking	6791.	HCK:0000463
Referral to smoking cessation advisor	XaItC	HCK:0000482
Not interested in stopping smoking	XaIkY	HCK:0000480
Cigar consumption	Ub1tJ	HCK:0000471
Loose tobacco consumption	Y01e6	HCK:0000999
Smoker	137R.	HCK:0000449
Ex-smoker	Ub1na	HCK:0000469
Never smoked tobacco	XE0oh	HCK:0000492
Current non-smoker	137L.	HCK:0000448
Ethnic groups (census)	9S...	HCK:0000467
Ethnic category - 2001 census	XaJQu	HCK:0000483
FH: Cardiovascular disease 1st degree female reltve < 65 yrs	XaP9M	HCK:0000488
FH: Cardiovascular disease 1st degree male relative < 55 yrs	XaP9K	HCK:0000487
Alcohol intake	136..	HCK:0000447
Advice on alcohol consumption	Xa1dA	HCK:0000476
Enjoys light exercise	1383.	HCK:0000450
Enjoys moderate exercise	1384.	HCK:0000451
Enjoys heavy exercise	1385.	HCK:0000452
Body mass index - observation	22K..	HCK:0000455
O/E - height	229..	HCK:0000453
O/E - weight	22A..	HCK:0000454
Waist circumference	Xa041	HCK:0000475
Ideal body weight	66CB.	HCK:0000462
Advice about weight	XaADJ	HCK:0000477
Dietary advice	8CA4.	HCK:0000464
Refer to weight management programme	XaJSu	HCK:0000484
Referral to dietitian	XaBSz	HCK:0000478
Pulse rate	X773s	HCK:0000473
Pulse regular	XM02J	HCK:0000495
Pulse irregular	X76JE	HCK:0000472
O/E - Systolic BP reading	2469.	HCK:0000456
O/E - Diastolic BP reading	246A.	HCK:0000457
Fasting	X78x9	HCK:0000474
Serum cholesterol level	XE2eD	HCK:0000493
Serum HDL cholesterol level	44P5.	HCK:0000459
Serum triglyceride levels	XE2q9	HCK:0000494
Serum LDL cholesterol level	44P6.	HCK:0000460
Serum glucose level	44f..	HCK:0000458
Total cholesterol:HDL ratio	44PF.	HCK:0000461
HbA1c level (DCCT aligned)	XaERp	HCK:0000479
Cardiovascular event risk	XaIpv	HCK:0000481
Cardiovascular disease risk assessment done	XaPkZ	HCK:0000489
Follow-up arranged	8H8..	HCK:0000465
High risk of diabetes mellitus	XaZLG	HCK:0000491