- This topic has 4 replies, 2 voices, and was last updated 4 years, 9 months ago by .
-
Topic
-
I’m looking to do the following:
- When I receive a message that a patient has a status of LOA, I want to send that message to the receiving system, and I also want to store that patient in a database to track them while on LOA.
- If I receive any orders for a patient while on LOA, I want to filter them from going to the receiving system, storing them instead in a database. If an order for a patient is received who is not on LOA, I would send the message, and not store it in a database. (There is no LOA indicator in the ORM message to use, so I’d have to pull the status from the previously mentioned table).
- When I receive a message that a patient has been removed from LOA, I want to send that message to a receiving system, resend all order messages that were received while on LOA, remove those orders from the table, then remove the patient from the table which tracks status.
I don’t have much experience with database functionality inside of Cloverleaf so I’m not entirely sure how to go about each step above. I could build it in TCL, but if I can do it inside of the GUI I’d like to start there.
I can create the tables I need to track a patient with a status of LOA, and the table I’d need for orders received while on LOA. I can create outbound database threads, and translations to insert the data that I need. But, I’m not sure how to do the filtering portion, or how to pull a complete message from a field and send it as a new message.
Would someone be able to give me an example of how to do filtering based off of a sql table? And how to pull a message from a table and resend it? For the latter I was thinking of a table which had MRN, Visit ID, OrderID, OrderMessage (entire message).
- You must be logged in to reply to this topic.