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
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_BASECODE, C_FULLNAME
FROM =
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.
SELECT C_BASECODE,=
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.