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

Export Flowsheet Observation term list?

Trading Post

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

94 Views

RSS

chrishuff1

(@chrishuff1)

Posts: 201

Reputable Member

Topic starter

To make a long story short, we have about 60 custom forms that were built with random observation terms and have been used for the last couple of years. There are about 4,500 observation terms in use. We just started using our state immunization registry electronically and several of the obs terms in our custom forms are using the same obs terms in the vaccination form and are sending out bogus data and creating quite the headache. I've gotten a lot of them cleared up but I want to be sure all of the obs terms we're currently using are not on this list.

The immunization list contains 7,200 obs terms and rather than go through it one by one, I'd like to dump it in excel (like i currently do) and set conditional formatting on the column to highlight any duplicate entries and then clear up the duplicates.

Is this even possible or am I just screwed?

Thanks!

Posted : December 4, 2013 5:59 am

justinbelcher

(@justinbelcher)

Posts: 130

Estimable Member

You want to get the flowsheet OBSHEADs into an excel file? Yes that's possible. This is a late response so let me know if you're still interested.

Posted : December 26, 2013 1:22 pm

chrishuff1

(@chrishuff1)

Posts: 201

Reputable Member

Topic starter

Yes, definitely!

Posted : December 26, 2013 9:47 pm

justinbelcher

(@justinbelcher)

Posts: 130

Estimable Member

I preface this with the reminder to not run scripts from the internet against your production database. Smile This is all in SSMS:

1) Create a helper function like this:

-- =============================================
-- Description:
-- Function to split CDL strings.
--   Performs well for small volumes of data.
--   DO NOT pass in dirty data! use for only known well structured data.
--   source: http://www.sqlperformance.com/.....it-strings
-- =============================================
CREATE FUNCTION [dbo].[temp_SplitStrings_XML]
(
   @List       NVARCHAR(MAX),
   @Delimiter NVARCHAR(255)
)
RETURNS TABLE
WITH SCHEMABINDING
AS
   RETURN
   (
      SELECT Item = y.i.value('(./text())[1]', 'nvarchar(4000)')
      FROM
      (
        SELECT x = CONVERT(XML, '<i>' + REPLACE(@List, @Delimiter, '</i><i>') + '</i>').query('.')
      ) AS a CROSS APPLY x.nodes('i') AS y(i)
   );
GO

2) Run this script using your flowsheet name:

DECLARE @flowsheetName VARCHAR(80)
SET @flowsheetName='Flowsheet name here'

--Pull CDL string of HDIDs from the source flowsheet
DECLARE @hdidList VARCHAR(MAX)
SELECT @hdidList=TEXT
FROM HIEROBJS
WHERE [NAME]=@flowsheetName

--Convert CDL string of HDIDs to table
--Clean up values. Some have .0, some do not.
DECLARE @hdids TABLE (hdid numeric(19))
INSERT INTO @hdids
SELECT LTRIM(Item) FROM dbo.temp_SplitStrings_XML(@hdidList, ',')

SELECT oh.[NAME]
FROM @hdids h
INNER JOIN OBSHEAD oh
ON oh.HDID=h.HDID

3) Copy and paste resulting table to Excel.

Posted : December 29, 2013 7:10 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