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
Cardiovascular disease risk assessment declined	XaN8t
Cardiovascular disease risk assessment offered	XaPl0
Informed consent given	XaLQR
Patient informed about research study	9Q...
Cigarette consumption	Ub1tI
Smoking cessation advice	Ua1Nz
Health education - smoking	6791.
Referral to smoking cessation advisor	XaItC
Not interested in stopping smoking	XaIkY
Cigar consumption	Ub1tJ
Loose tobacco consumption	Y01e6
Smoker	137R.
Ex-smoker	Ub1na
Never smoked tobacco	XE0oh
Current non-smoker	137L.
Ethnic groups (census)	9S…
Ethnic category - 2001 census	XaJQu
FH: Cardiovascular disease 1st degree female reltve < 65 yrs	XaP9M
FH: Cardiovascular disease 1st degree male relative < 55 yrs	XaP9K
Alcohol intake	136..
Advice on alcohol consumption	Xa1dA
Enjoys light exercise	1383.
Enjoys moderate exercise	1384.
Enjoys heavy exercise	1385.
Body mass index - observation	22K..
O/E - height	229..
O/E - weight	22A..
Waist circumference	Xa041
Ideal body weight	66CB.
Advice about weight	XaADJ
Dietary advice	8CA4.
Refer to weight management programme	XaJSu
Referral to dietitian	XaBSz
Pulse rate	X773s
Pulse regular	XM02J
Pulse irregular	X76JE
O/E - Systolic BP reading	2469.
O/E - Diastolic BP reading	246A.
Fasting	X78x9
Serum cholesterol level	XE2eD
Serum HDL cholesterol level	44P5.
Serum triglyceride levels	XE2q9
Serum LDL cholesterol level	44P6.
Serum glucose level	44f..
Total cholesterol:HDL ratio	44PF.
HbA1c level (DCCT aligned)	XaERp
Cardiovascular event risk	XaIpv
Cardiovascular disease risk assessment done	XaPkZ
Follow-up arranged	8H8..
High risk of diabetes mellitus	XaZLG