David Guest wrote:
I think this identifies the patients we are after:-
SELECT DISTINCT CM_PATIENT.SURNAME, CM_PATIENT.FIRST_NAME,
CM_PATIENT.DOB, MD_HISTORY.CONDITION, MD_HISTORY.HISTORY_CODE
FROM CM_PATIENT INNER JOIN
MD_HISTORY ON CM_PATIENT.PATIENT_ID =
MD_HISTORY.PATIENT_ID
WHERE (MD_HISTORY.HISTORY_CODE LIKE '%diabm%' OR
MD_HISTORY.HISTORY_CODE LIKE 'diabf%' OR
MD_HISTORY.HISTORY_CODE LIKE 'nld%') AND (NOT
(MD_HISTORY.HISTORY_CODE IN ('[EMAIL PROTECTED]', '[EMAIL PROTECTED]'))) AND
(CM_PATIENT.DECEASED_DATE IS NULL) AND
(CM_PATIENT.STATUS_CODE = 'A')
ORDER BY CM_PATIENT.SURNAME, CM_PATIENT.FIRST_NAME
since they don't want pre-diabetic or gestational diabetes patients.
Next task is to convert a list of vertical results (HbA1c, smokes, BP,
weight, feet, Urinary MA, claimed SIP and Care Plan in < 2 months, etc.)
into a table by patient row.
Great SQL. I assume you're running it on MD3?
I was shocked to find that some of our secondary pathology providers are
not sending us HL7 and so following up on Greg's point from this
morning, if anyone is thinking of getting into Care Plans, etc. they
should ensure that their pathology is coming in as HL7. Start now so you
have a year's worth of data by the time you get going.
Praise the lord!
Some of us have been trying to promote this stuff for two years or more,
but very few people further up the food chain seem to see it worthy of
promotion, despite all the new emphasis on data extraction for the
Divisions outcomes framework
Two weeks ago the penny dropped for one SBO's IM&T guy. He finally put
it all together and realised how important HL7 results are to any NPI or
other diabetes/cardiac data extraction. The gathered Division IM&T
people down there apparently all knew, but the 'people making the
decisions' are only gradually becoming aware of the impact this can have
on data quality in practices.
The aborted Divisions Network IM Project consultation was another arena
where I tried to shout this from the rafters, but with minimal apparent
effect. At one point I had to explain to an official from a certain
government department what a HbA1C was, and why getting summary values
from a pathology provider with a practice's permission was no different
from extracting the same data from a practice computer system, except it
was unlikely to be present in the latter in most cases.
Getting GPs to record in their software all the asthmatics who are
smokers is another matter, of course.
Greg
--
Greg Twyford
Information Management & Technology Program Officer
Canterbury Division of General Practice
E-mail: [EMAIL PROTECTED]
Ph.: 02 9787 9033
Fax: 02 9787 9200
PRIVATE & CONFIDENTIAL
***********************************************************************
The information contained in this e-mail and their attached files,
including replies and forwarded copies, are confidential and intended
solely for the addressee(s) and may be legally privileged or prohibited
from disclosure and unauthorised use. If you are not the intended
recipient, any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication or any action taken or
omitted to be taken in reliance upon this message or its attachments is
prohibited.
All liability for viruses is excluded to the fullest extent permitted by
law.
***********************************************************************
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
