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

Discarding/Closing a Document using SQL

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

84 Views

RSS

Crow

(@dustincrowell)

Posts: 104

Estimable Member

Topic starter

Hello,

I have a document that was opened as an Append, I can't see the append from the Documents view, but I can see it in the Documents for Edit Window and I can see the information through a SQL Query. I am unable to select the Edit button or do anything with this document. I have tried corrupted document and locked fixes from the toolbox.
Does anyone have any ideas or SQL queries to get rid of this document or sign off on it?

Running CPS 12

Thanks in Advance.

Posted : December 29, 2014 8:27 am

acantu

(@acantu)

Posts: 722

Prominent Member

I recommend you just Filing it Error, or if you cannot do that via the interface, you can run this script to do it for you:

UPDATE DOCUMENT
SET DOCTYPE = 24, DOCSTATE = 0, STATUS = 'S'
WHERE SDID = INPUT THE SDID HERE

This will mark that document as a Filed In Error Document, this will not show the contributor of who filed it in error, if you need that, I will have to write a more in-depth script.

Posted : December 29, 2014 9:12 am

Crow

(@dustincrowell)

Posts: 104

Estimable Member

Topic starter

Acantu,

I ran this script and there is now text in the document that says filed in error, but the document is still showing in the documents for edit window and on the providers desktop.
When I try to remove it, it says document not signed.
Also the document type is now named Error: .......
Any other ideas?
I appreciate the help.

Posted : December 29, 2014 10:42 am

acantu

(@acantu)

Posts: 722

Prominent Member

can you email me at [email protected]

Posted : December 29, 2014 11:05 am

Crow

(@dustincrowell)

Posts: 104

Estimable Member

Topic starter

This worked. I had to change the Document status to S after running this script and then it worked
(Probably should have done beforehand).

Thank You Acantu!

Posted : December 29, 2014 11:10 am

acantu

(@acantu)

Posts: 722

Prominent Member

No problem, glad it was resolved, I have updated the script for your vote, to show it with an 'S' for status.

Posted : December 29, 2014 11:18 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