kuang oon wrote:
Hi David,
Sure. Someone else just asked me this same question a week
ago. Inspect the genus diabm^ for a bountiful harvest of species or
else the following.
Like 'diabm%' => [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED] etc2
Like '[EMAIL PROTECTED]' => [EMAIL PROTECTED] [EMAIL PROTECTED]@backg
[EMAIL PROTECTED]@prolifer [EMAIL PROTECTED] [EMAIL PROTECTED]
[EMAIL PROTECTED]@diabm [EMAIL PROTECTED] [EMAIL PROTECTED] etc2
But if you are shooting for distinction....
Add Like 'diabf%' => diabf (diabetic foot)
Add Like 'nld%' => nld (necrobiosis lipoidica diabeticorum)
Thanks Kuangie
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.
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.
I seem to recall someone (?BEACH) has done mappings between DOCLE, ICPC
and ICD-X. Is this available somewhere?
David
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
