Allscripts page 1 of 1 for 8 posts
A quick Powershell script I hacked together that will enumerate all Active Directory users, and build an XML file for an application I wrote that generates user reports for a specific application.
The output file format is similar to:
<report name=Organizational Unit>
foreach ($usr in Get-ADUser -Filter * | select Continue Reading...
Follow the steps below against correct EHR database in SQL Management Studio if you want to change the pointers yourself.
select * from HPSITE.SCAN_DOCUMENTPAGEUpdate the Document Page from the old Server to the new Server:
SET FILELOCATION = REPLACE(FILELOCATION,'\OLDserver\Hmscan','\NEWserver\hmscan')
Update the Scan Job from the old Server to the new Server:
SET DIRECTORY= REPLACE(DIRECTORY,'\OLDserver\Hmscan','\NEWserver\hmscan')
Update Continue Reading...
A utility I wrote to show locked user accounts in the Allscripts Professional EHR database and allow the user to unlock selected accounts.
Last week I worked on one of my projects for Allscripts Vision accounting to add a few enhancements.
The major enhancement was the ability to export a detailed report for all users to Excel and create a Pivot table with chart of users' logins over the report's timeline.
You can read more on my project page for this project.
Allscripts ProEHR 9.10.3 database table and column extended properties text: ProEHR 9.10.3 - Table and Column Extended Properties
Misys Vision Encounter (Superbill) Templates
select tmpname,tmpdesc from formtmphdr where allow_edit = 'N' and tmptype = 7
CODESCAN1S MICROSCAN ENCOUNTER 1 (8 LPI - STYLE 2)
CODESCAN3S MICROSCAN ENCOUNTER 3 (8 LPI - STYLE 2)
ENC09 MEDIC ENCOUNTER FORM #9
ENC09LASER MEDIC #9 LASER ENCOUNT (60 LPP STYLE 3)
ENC10 MEDIC ENCOUNTER FORM #10
ENC10LABEL MEDIC LABEL ENCOUNTER FORM #10 (STYLE 3)
ENC10LASER MEDIC #10 LASER ENCOUNT (60 Continue Reading...
I have been working on a report to indicate which refill requests will be coming in the future and I've had to do some digging in the database. Found this little nugget of information while working in the HPSITE.REFILL table.
This is HPSITE.REFILL table description followed by HPSITE.REFILL.RFL_STATUS description.
HPSITE.REFILL: This table stores the data related to ordering a refill of a patient's medication.
HPSITE.REFILL.RFL_STATUS: This column indicates the current status of the refill. Continue Reading...
So I've discovered that FastClaims in Allscripts Tiger AIX servers are stored in the following location.
When a receipts are batched, they are stored in /m2/MF01/CLAIM499
When clicking on "Batch" -> Fast Claims, it then copies /m2/MF01/CLAIM499 to /src/APPS/ECONNECT/ARCHIVE/TS/CLAIM499_1.3101165443_20120131165507385. You will notice this filename is comprised of CLAIM499_[companynumber].ddmmhhmmss.yyyymmddhhmmssnnnn in gzip format.
The original /m2/MF01/CLAIM499 is renamed to /m2/MF01/oldCLAIM499.
The Continue Reading...
I've seen that it takes >1hr to load the FastServices window after clicking on the FastServices button.
Here's what I did to make this take less than 10 seconds to load. It appears as though it does some type of parsing/processing of old log and inbox files.
# cd /Medic/APPS/fastsvc
# ls -l
drwxr-xr-x 4 dev medgrp 512 Dec 5 15:33 inbox
drwxr-xr-x 2 dev medgrp 512 Dec 5 15:31 logs
drwxrwxrwx 2 dev medgrp 512 Dec 5 15:14 outbox
drwxrwxrwx 2 dev medgrp 512 Dec 5 15:23 tmp
I moved Continue Reading...