EXAMINATION

<In-house physio>

>= "T-1y" AND READ_CODE = "9NJ3.00 "'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND READ_CODE = "9NJ3.00 "

<History/Symptoms>

>= "T-1y" AND READ_CODE = "1....00 "'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND READ_CODE = "1....00 "

<Examination / Signs>

>= "T-1y" AND READ_CODE = "2....00 "'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND READ_CODE = "2....00 "

<Informed Consent>

<Informed Consent Refused>

>= "T-1y" AND READ_CODE = "892"'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND READ_CODE = "892"

<Red Flags>

Document in the comments box whether there are red flag symptoms, or if there are no red flag symptoms

>= "T-1y" AND READ_CODE = "67DP.00 "'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND READ_CODE = "67DP.00 "

REFERRALS

Referral to Secondary Care

<Orthopaedic Referral>

<Podiatry Referral>

<Orthotic Referral>

<Pain Clinic Referral>

<Neurology Referral>

<Rheumatology Referral>

>= "T-1y" AND (READ_CODE = "8H54.00 " OR READ_CODE = "8H7X.00 " OR READ_CODE = "8H7S.00 " OR READ_CODE = "8H69.00 " OR READ_CODE = "8H4h.00 " OR READ_CODE = "8H4B.00 ")'> All Referrals Records in Descending order Where EVENTDATE >= "T-1y" AND (READ_CODE = "8H54.00 " OR READ_CODE = "8H7X.00 " OR READ_CODE = "8H7S.00 " OR READ_CODE = "8H69.00 " OR READ_CODE = "8H4h.00 " OR READ_CODE = "8H4B.00 ")

Referral to Physio

<Refer to Community Physio>

<Refer to Physio>

>= "T-1y" AND (READ_CODE = "8HHA.00 " OR READ_CODE = "8H77.00 ")'> All Referrals Records in Descending order Where EVENTDATE >= "T-1y" AND (READ_CODE = "8HHA.00 " OR READ_CODE = "8H77.00 ")

Referral to Primary and Community Care

<Refer to GP>

<Refer to Practice Nurse>

<Refer to Healthy Lifestyle Programme>

>= "T-1y" AND (READ_CODE = "8H62.00 " OR READ_CODE = "8H71.00 " OR READ_CODE = "8Hlu.00 ")'> All Referrals Records in Descending order Where EVENTDATE >= "T-1y" AND (READ_CODE = "8H62.00 " OR READ_CODE = "8H71.00 " OR READ_CODE = "8Hlu.00 ")

REFERRALS FOR INVESTIGATIONS

<Refer for X-Ray>

<Refer for MRI>

<Refer for Ultrasound>

<Refer for Nerve Conduction Studies>

<Blood Test Requested>

>= "T-1y" AND (READ_CODE = "8HQ1.00 " OR READ_CODE = "8HQ3.00 " OR READ_CODE = "8HQ2.00 " OR READ_CODE = "8HRE.00 ")'> All Referrals Records in Descending order Where EVENTDATE >= "T-1y" AND (READ_CODE = "8HQ1.00 " OR READ_CODE = "8HQ3.00 " OR READ_CODE = "8HQ2.00 " OR READ_CODE = "8HRE.00 ") >= "T-1y" AND READ_CODE = "41B1.00 "'> All Procedures, Specimens and Samples Records in Descending order Where EVENTDATE >= "T-1y" AND READ_CODE = "41B1.00 "

INTERVENTIONS

<Minor Surgery Done - injection>

<Exercise on Prescription>

<Counselling - general>

<Lifestyle Counselling>

>= "T-1y" AND (READ_CODE = "8Hlu.00 " OR READ_CODE = "8BAH.00 " OR READ_CODE = "671..00 ")'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND (READ_CODE = "8Hlu.00 " OR READ_CODE = "8BAH.00 " OR READ_CODE = "671..00 ") >= "T-1y" AND READ_CODE = "67H..00 "'> All Advice Given Records in Descending order Where EVENTDATE >= "T-1y" AND READ_CODE = "67H..00 "

<Drug Prescription>

<Repeat Prescription>

>= "T-1y" AND (READ_CODE = "8B21.00 " OR READ_CODE = "8B41.00 ")'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND (READ_CODE = "8B21.00 " OR READ_CODE = "8B41.00 ")

PRESENTING STATUS

<Follow Up>

<DNA - No reason>

>= "T-1y" AND (READ_CODE = "9c0H.00 " OR READ_CODE = "9N42.00 ")'> All Medical History Records in Descending order Where EVENTDATE >= "T-1y" AND (READ_CODE = "9c0H.00 " OR READ_CODE = "9N42.00 ")