Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

returning absent entries or no obsvalue

Trading Post

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

71 Views

RSS

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

I have a report that returns the latest HGBA1C results within a certain date range, for a specific Diabetic population defined in the report. Any ideas on how to report the base population including those with most recent HGBA1C results in past year. So if part of the population has not had an HGBA1C entry made within the past year I see which patients those are. I usually run a series of reports and compile the information in excel. I'd just like to streamline my efforts. I thought maybe using isnull might work, but it seems that a "blank" entry needs to have been made.

Any thoughts/suggestions is very much appreciated. Thanks in advance!

Posted : June 6, 2013 12:28 am

jesran

(@jesran)

Posts: 13

Active Member

Ever consider a command? I typically use a command to view the base population; i.e. diabetics seen by these folks in this time frame. Then I link that table of PIDs to the obs term table and any ob term(s) that you are interested in. Shows all patient's in base population regardless of if they have the obs term associated with them or not. Patient's without the obs term show blanks in the obs term value and date columns of the report.

Posted : June 6, 2013 5:18 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Right! A command... I have seen them in use before, but have never written one myself. Great pointer. Thanks!

Posted : June 6, 2013 7:54 am

jesran

(@jesran)

Posts: 13

Active Member

PID command example:

SELECT "DOCUMENT"."PID"
FROM (("ML"."DOCUMENT" "DOCUMENT" INNER JOIN "ML"."DOCTYPES" "DOCTYPES" ON "DOCUMENT"."DOCTYPE"="DOCTYPES"."DTID") INNER JOIN "ML"."LOCREG" "LOCREG" ON "DOCUMENT"."LOCOFCARE"="LOCREG"."LOCID") INNER JOIN "ML"."PROBLEM" "PROBLEM" ON "DOCUMENT"."PID"="PROBLEM"."PID"

WHERE "PROBLEM"."STOPDATE">={ts '2013-06-07 00:00:00'} AND ("PROBLEM"."CODE">='ICD-249.999' AND "PROBLEM"."CODE"<='ICD-251.000') AND ("LOCREG"."SEARCHNAME"='FAMILY PRACTICE') AND "DOCTYPES"."DESCRIPTION"='Office Visit'
AND "DOCUMENT"."STATUS"='S'
AND "DOCUMENT"."DB_CREATE_DATE">={ts '2012-01-01 00:00:00'}

Let me know if you have question as to what I was trying to capture.

Gerald Neale, RN

[email protected]

Posted : June 6, 2013 11:55 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

One approach that I have used is to select records where the OBS Code is in ["BP SYSTOLIC", "HGBA1C"] and then use a variable to store the A1C date. My thought being that a blood pressure should be recorded at every visit and be indicative of active patients, and then get the latest A1C also. (I often do this with the LASTLABS view.)

So, my selection logic is like:

{PERSON.PSTATUS} = "A" and
{PERSON.ISPATIENT} = "Y" and

{LASTLABS.HDID} in [28.00, 53.00]

and then I just define a variable to store the last A1C

if {LASTLABS.HDID} = 28.00 then {LASTLABS.MAXLABDATE}

Posted : June 9, 2013 11:22 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0