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

Tables/Flowsheets in Crystal

Trading Post

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

64 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Does anyone know how to pull a flowsheet into Crystal?

THANKS!!!

Posted : November 19, 2013 12:05 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Are you referring to getting the data from the screren: Settings -> Chart -> Flowsheet views -> Change??

If so that was exactly what I was trying to do this week. I managed to find the related tables but the problem is how the data is stored.

The sql query I came up with (which doesn't work)

SELECT OBSHEAD.NAME, OBSHEAD.DESCRIPTION

FROM OBSHEAD WHERE TO_CHAR(OBSHEAD.HDID) IN

(SELECT TEXT from HIEROBJS where OBJECTID = 1655728761756170)

The problem is that HEIROBJS.TEXT is a CLOB field and not a varchar or integer. The field

consists of HDID values separated by commas. It is possible that the above query or something

like it would possible work on a smaller dataset than the particular text field I was trying to pull

which was 3500 entries consisting of 32000 characters in the field. The person who was asking

for the data ended up taking groups of screenshots of all 3500 entries.

Posted : November 19, 2013 7:39 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

We are trying to use FLOWSHEET VIEWS to pull it into a report to view a custom flowsheet within the report....

Not sure how else to do this other than using a sub report maybe within the main report and pulling in the obs terms we want in a cross-tab format?

Do you know the best way to pull i n a cross tab report?

Posted : November 21, 2013 3:04 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Faerie_Autumn said:

We are trying to use FLOWSHEET VIEWS to pull it into a report to view a custom flowsheet within the report....

Not sure how else to do this other than using a sub report maybe within the main report and pulling in the obs terms we want in a cross-tab format?

Do you know the best way to pull i n a cross tab report?

I just stumbled across a solution to my problem and I think it might help you.

The list of Flowsheets is in HIEROBJS. The Relevant fields HIEROBJS.NAME and HIEROBJS.OBJECTID.

If you want a report of the name and description of all of the obs terms in a flowsheet you can use a query like this:

SELECT OBSHEAD.NAME, OBSHEAD.DESCRIPTION
FROM OBSHEAD WHERE OBSHEAD.HDID IN
(SELECT HDID from LINKLOGIC_EXPORT_FLOWSHEET where OBJECTID = 1655728761756170)

If you actually want to report on the value of the obs terms from the flowsheet in patient records, use the view called FLOWSHEET_OBSERVATION. It has a column called flowsheetid which is the OBJECTID from HIEROBJS. If you just pull it on a particular flowsheetid you will probably get way too much info.

Posted : November 26, 2013 2:02 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

I will try this out and see what happens!

You don't happen to have a problems, meds, allergies report by patient do you? If so, could you share?

THANKS!

Posted : November 27, 2013 12:37 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

No I don't. Sorry.

Posted : November 27, 2013 1:48 am

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