Notifications
Clear all
General Discussion
9
Posts
3
Users
0
Reactions
101
Views
Topic starter
Good Morning,
I am looking for someone to assist me with writing an HL7 file to set a large number of accounts as "Inactive". If you can assist us or know of anyone, please let me know.
Thanks,
Etan
Posted : February 14, 2014 12:48 am
etanwalls said:
Good Morning,
I am looking for someone to assist me with writing an HL7 file to set a large number of accounts as "Inactive". If you can assist us or know of anyone, please let me know.
Thanks,
Etan
Are these PM accounts? You could write a script in the database to identify these patients and then set the status to "Inactive".
Posted : February 17, 2014 5:51 am
Topic starter
We deactivated the PM accounts and the message did not deactivate the EMR account.
Posted : February 17, 2014 10:33 pm
etanwalls said:
We deactivated the PM accounts and the message did not deactivate the EMR account.
How did you identify these accounts? Are you on Oracle or SQL?
Posted : February 18, 2014 12:11 am
Topic starter
We have an Analytics tool with criteria to determine based on age band who should be inactive.
Posted : February 18, 2014 12:18 am
etanwalls said:
We have an Analytics tool with criteria to determine based on age band who should be inactive.
Ok but what platform do you run your application from? And what version are you on?
Posted : February 18, 2014 12:22 am
Topic starter
Oracle
Posted : February 18, 2014 12:23 am
etanwalls said:
Oracle
Sorry, we run Sequel. We were able to identify "empty charts" with a query and delete them all at once. Maybe some of the Oracle folks can chime in.
Laurie
Posted : February 18, 2014 12:25 am
Etan, what is your PM product? Did it not generate any HL7 files when you did these account deltetions? If it did generate the HL7 - it may be those just need to be edited so EMR's DTS properly processes them. To generate a new batch you might need a tool like Qvera. It can take a CSV file and from there it is pretty easy to get it to generate your HL7 files.
If you have a programmer, they might be able to script something out if you provide them with a sample of what the HL7 should look like.
Posted : February 18, 2014 3:09 am
