Message-ID: <1485719977.8688.1711722015124.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8687_736082658.1711722015122" ------=_Part_8687_736082658.1711722015122 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Query Sample for Diagnoses

Query Sample for Diagnoses


ICD-9 code is known:
= Use this query to lookup the _C_BASECODE_ and _C_FULLNAME_ for ICD-9 diagn= osis code 346.0
SELECT C_BASECODEFROM = RPDR
WHERE C_BASECODE =3D '3460'
The _C_BASECODE_ r= eturned in the results can then be joined to the CONCEPT_CD in the= OBSERVATION_FACT table to find all patients diagnosed with ICD-9 code 346.= 0. Note that the C_BASECODE 3460 has no decimal point, these are removed. <= br class=3D"atl-forced-newline">
ICD-9 code is unknown, but the diagnosi= s description is known:
Use this q= uery to lookup the _C_BASECODE_ and _C_FULLNAME_ for the diagnosis of migra= ines.
,= C_FULLNAME
FROM RPDR
<= span style=3D"color: rgb(0,0,255);">WHERE C_FULLNAME like = '%diagnoses%migraine%'
The C_BASEC= ODEs returned in the results could then be joined to the CONCEPT_CD in the = OBSERVATION_FACT table to find all patients diagnosed with migraines.


------=_Part_8687_736082658.1711722015122--