= 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 ||