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

Flowsheet View

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

84 Views

RSS

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

Topic starter

Hi All,

I'm having some difficulty writing a report that displays the observations associated to flowsheets in the EMR, has anyone done this? Basically all I want to do is HEIROBJS name be my targeted flowsheet and then have it display each OBSHEAD.NAME that makes that report up (I don't care about the values recorded just the content that makes up the flowsheet). For some reason I cannot seem to do this no matter what combination of HEIROBJS/HEIRGRPS/OBSHEAD/FLOWSHEETLABELS I use (or even just the Flowsheet View).

I'm trying to set up a "not" list of lab result (observations) not to pull into the CCD-A with the Qvera interface but when I use it I'm getting an error. I think this is because my flowsheet is not classified as they want it to be but I want to be able to pull all the relevant fields to help troubleshoot; without reproducing it in crystal I'm having trouble diagnosing the gap.

Thanks

Mike

Posted : July 22, 2015 4:40 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

This took me forever to figure out but I think I got it. This works in Oracle/EMR 9.8.9. You would replace "Diagnostic Results" with any Flowsheet name and it would return all of the obs from that flowsheet. Your query can only match one flowsheet at a time.

SELECT obshead.name From obshead where hdid in (SELECT * from Table(ML.F_NUMBER_TABLE((SELECT OBJECTID from hierobjs where name like 'Diagnostic Results'))))

Posted : July 22, 2015 10:30 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Here is one more for you that will join HIEROBJS to OBSHEAD. You could make this a view to create a report on it or you could possibly make it into a Crystal reports SQL Command.
SELECT HIEROBJS.OBJECTID, HIEROBJS.NAME, OBSHEAD.* FROM ML.HIEROBJS, TABLE(ML.F_NUMBER_TABLE(HIEROBJS.OBJECTID)) t INNER JOIN ML.OBSHEAD ON OBSHEAD.HDID IN t.COLUMN_VALUE WHERE HIEROBJS.PRTATTRID = 1000 ORDER BY HIEROBJS.NAME

Posted : July 22, 2015 11:35 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

Topic starter

Awesome, thank you very much! I ended up figuring out that for the Qvera "Not" lists they can deliver as part of the TOC Outbound channel the flow sheets have to be built under the "Interfaces" folder and then (inside this folder) under a folder called CCDA. So effectively:

Chart -> Flowsheet views -> Enterprise -> Interfaces -> CCDA -> "Flowsheet"

For it to work, that is how they set it up. However what you did will help us immensely, being able to report on the Observations associated to flowsheets (for building/maintenance purposes) will be huge.

Thanks

Mike

Posted : July 23, 2015 3:49 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Here is the view I ended up creating in our system with it. I figured I would need it in the future so I better put it in there while it is fresh in my memory: (IMA is the name of our practice so all of my customizations start with IMA_)

CREATE OR REPLACE FORCE VIEW "ML"."IMA_FLOWSHEET" ("OBJECTID", "FLOWSHEET_NAME", "HDID", "GROUPID", "XID", "NAME", "DESCRIPTION","UNIT", "OBSTYPE", "MLCODE", "CPTCODE", "ICDCODE", "LOINCCODE", "SNOMEDCODE", "OTHERCODE", "FACTORID", "ENCODEFMT", "DECODEFMT", "FMTLIB", "POSTEXPR", "PREEXPR", "ACTIVE", "KEYWORD", "DB_CREATE_DATE", "DB_UPDATED_DATE") AS


  SELECT HIEROBJS.OBJECTID, HIEROBJS.NAME FLOWSHEET_NAME,

OBSHEAD."HDID",OBSHEAD."GROUPID",OBSHEAD."XID",OBSHEAD."NAME",

OBSHEAD."DESCRIPTION",OBSHEAD."UNIT",OBSHEAD."OBSTYPE",

OBSHEAD."MLCODE",OBSHEAD."CPTCODE",OBSHEAD."ICDCODE",

OBSHEAD."LOINCCODE",OBSHEAD."SNOMEDCODE",OBSHEAD."OTHERCODE",

OBSHEAD."FACTORID",OBSHEAD."ENCODEFMT",OBSHEAD."DECODEFMT",

OBSHEAD."FMTLIB",OBSHEAD."POSTEXPR",OBSHEAD."PREEXPR",

OBSHEAD."ACTIVE",OBSHEAD."KEYWORD",OBSHEAD."DB_CREATE_DATE",

OBSHEAD."DB_UPDATED_DATE"

FROM ML.HIEROBJS, TABLE(ML.F_NUMBER_TABLE(HIEROBJS.OBJECTID)) t

INNER JOIN ML.OBSHEAD ON OBSHEAD.HDID IN t.COLUMN_VALUE 
WHERE

HIEROBJS.PRTATTRID = 1000 ORDER BY HIEROBJS.NAME;

GRANT SELECT ON "ML"."IMA_FLOWSHEET" TO "REPORT";

EDIT: I switched it to an exported version from SQL Developer instead of the initial query I wrote which makes it more explicit on which rows and also adds the grant statement.

Posted : July 23, 2015 4:45 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

Topic starter

Thank you very much!

Posted : July 23, 2015 8:45 am

24 Forums
9,940 Topics
39.9 K Posts
3 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