ProEHR Refill Status Codes

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 →

FastClaims for Tiger in AIX

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 →

#aix

Misys Vision Slow to Load Fast Services Screen

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 total 264 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 →