Learning Disability Health Assessment

Last 3 All other Clinical Data Records Where READ_CODE = "9HB3.00 "
<Learning Disability Health Assessment>

Health Education

Last 1 All other Clinical Data Records Where READ_CODE = "6795.00 " Last 1 All other Clinical Data Records Where READ_CODE = "679B.00 " Last 1 All other Clinical Data Records Where READ_CODE = "679K.00 " Last 1 All other Clinical Data Records Where READ_CODE = "611..00 " Last 2 Advice Given Records Where READ_CODE = "679K.00 " OR READ_CODE = "679B.00 "
<Health Education - Breast Examination> <Health Education - Sexual Health>
<Health Education - Testicular Examination> <General Contraceptive Advice>

Weight & Height

Last 4 Weight Records Last 4 Height Records
<O/E Weight> <O/E - Height>

BMI

Last 4 All other Clinical Data Records Where READ_CODE = "22K"
<BMI - Less than 20> <BMI - 20-24 - Normal> <BMI - 25-29 - Overweight>
<BMI - 30+ - Obesity> <BMI - 40+ - Severly obese>

Blood Pressure

Last 4 Blood pressure Records
<Blood Pressure>

Pulse Rate

Last 1 Pulse (CVS/BP) Records Last 1 All other Clinical Data Records Where READ_CODE = "243" Last 1 Heart sounds/Femoral pulses Records Last 1 Heart examination Records
<O/E Pulse Rate>
<O/E Pulse rhythm regular> <O/E Pulse irregularly irregular> <O/E Pulse regularly irregular>
<O/E No gallop rhythm>

Tests

Last 2 Urinalysis - Glucose Records Last 1 Urine test Records Last 1 Other Laboratory tests Records Where READ_CODE = "4668.00 " Last 1 All other Clinical Data Records Where READ_CODE = "4668.00 " Last 1 Thyroid Stimulating Hormone Records
Urine test for glucose
<Urine test for glucose> <Glycosuria>
Serum TSH Level
<Serum TSH Level>

Smoking Status

Last 1 Smoking Records Where READ_CODE = "1371.00 " OR READ_CODE = "137H.00 " OR READ_CODE = "137I.00 " OR READ_CODE = "137J.00 " OR READ_CODE = "137K.00 " OR READ_CODE = "137L.00 " OR READ_CODE = "137M.00 " OR READ_CODE = "137P.00 " OR READ_CODE = "137R.00 " OR READ_CODE = "137S.00 " OR READ_CODE = "137W.00 " Last 1 Passive smoking Records Last 1 All other Clinical Data Records Where READ_CODE = "13p1.00 "
<Never Smoked> <Current Non-Smoker> <Current Smoker> <Ex Smoker>
<Stopped Smoking> <Passive Smoker>
<Cigarette Smoker> <Pipe Smoker> <Rolls own cigarettes> <Chews tobacco>
<Smoking status at 4 weeks>

Health Education - Smoking

Last 1 All other Clinical Data Records Where READ_CODE = "137G.00 " Last 1 All other Clinical Data Records Where READ_CODE = "6791.00 " OR READ_CODE = "67A3.00 " Last 1 All other Clinical Data Records Where READ_CODE = "8CAL.00 " Last 1 All other Clinical Data Records Where READ_CODE = "8H7i.00 " OR READ_CODE = "8HTK.00 " Last 1 All other Clinical Data Records Where READ_CODE = "8B2B.00 " All Advice Given Records in Descending order Where READ_CODE = "6791.00 " OR READ_CODE = "67A3.00 "
<Trying to give up smoking>
<Health education - smoking> <Pregnancy smoking advice> <Smoking cessation advice>
<Referral to smoking cessation advisor> <Referral to stop-smoking clinic> <Nicotine replacement therapy>

Alcohol

Last 1 Alcohol Records Last 1 All other Clinical Data Records Where READ_CODE = "8CAM.00 "
<Alcohol consumption> <Patient advised about alcohol>

Diet

Last 1 Diet Records Last 1 All other Clinical Data Records Where READ_CODE = "8CA4.00 " Last 1 All other Clinical Data Records Where READ_CODE = "1FA..00 " OR READ_CODE = "1FB..00 " OR READ_CODE = "1FC..00 "
<Diet Good> <Diet Average> <Diet Poor>
<Patient advised about diet>

Exercise grading

Last 1 All other Clinical Data Records Where READ_CODE = "1381.00 " OR READ_CODE = "1382.00 " OR READ_CODE = "1383.00 " OR READ_CODE = "1384.00 " OR READ_CODE = "1385.00 "
<Exercise physically impossible> <Avoids even trivial exercise> <Enjoys light exercise>
<Enjoys moderate exercise> <Enjoys heavy exercise>

Behaviour

Last 1 All other Clinical Data Records Where READ_CODE = "3AB3.00 "
<Change in behaviour>

Speech problems

Last 1 All other Clinical Data Records Where READ_CODE = "1B9"
<No speech problems> <Has a stammer/stutter> <Has difficulty with speech> <Speech limited>

Visual problems

Last 1 All other Clinical Data Records Where READ_CODE = "1B71.00 " Last 1 All other Clinical Data Records Where READ_CODE = "1B7A.00 "
<No visual symptom> <Patient concerned about eyesight>

Hearing

Last 1 All other Clinical Data Records Where READ_CODE = "1C11.00 " OR READ_CODE = "1C12.00 " Last 1 All other Clinical Data Records Where READ_CODE = "2DG..00 " Last 1 All other Clinical Data Records Where READ_CODE = "2D6..00 " OR READ_CODE = "2D63.00 "
<Hearing normal> <Hearing difficulty> <Hearing aid worn>
<O/E - discharge from ear> <O/E - waxy ear discharge>

Mobility

Last 1 All other Clinical Data Records Where READ_CODE = "13C1.00 " OR READ_CODE = "13CA.00 " OR READ_CODE = "13CE.00 " OR READ_CODE = "13CG.00 "
<Fully mobile> <Mobility fair> <Mobility poor> <Housebound>

Bowels & Bladder - assessment

Last 1 All other Clinical Data Records Where READ_CODE = "3930.00 " OR READ_CODE = "3931.00 " OR READ_CODE = "3932.00 " Last 1 All other Clinical Data Records Where READ_CODE = "3940.00 " OR READ_CODE = "3941.00 " OR READ_CODE = "3942.00 "
<Bowels - fully continent> <Bowels - occasional accident> <Bowels - incontinent>
<Bladder - fully continent> <Bladder - occasional accident> <Bladder - incontinent>

Referrals

Last 1 All other Clinical Data Records Where READ_CODE = "8H7R.00 " Last 1 All other Clinical Data Records Where READ_CODE = "8H72.00 "
<Refer to chiropodist> <Refer to district nurse>

Learning disability action plan

Last 1 All other Clinical Data Records Where READ_CODE = "9HB0.00 " OR READ_CODE = "9HB1.00 " OR READ_CODE = "9HB2.00 "
<Learning disabilities health action plan offered> <Learning disabilities health action plan reviewed>
<Learning disabilities health action plan declined>