Load new RVU for Allscripts Vision

Worked out some stuff to load RVU’s into Vision Informix database. Figured I’d document what I did.

I grabbed the RVU file from: https://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/PhysicianFeeSched/PFS-Relative-Value-Files-Items/RVU19A.html

In the CSV file I extracted from the CMS site, I deleted a bunch of crud I don’t need. Changed the rbrvs_* columns to 2 decimal format, added an effdate column mm/dd/yyyy and was left with the following columns:

  • rbrvs_table_no
  • proccode
  • effdate
  • code_status
  • rbrvs_work
  • rbrvs_nonfac
  • rbrvs_facprac
  • rbrvs_malprac
  • global_period

I wanted to see what the changes are from 2018 vs 2019, so I unloaded the existing data into a file:

unload to '/tmp/2018rvu' delimiter '|' select rbrvs_table_no,proccode,effdate,rbrvs_work,rbrvs_nonfac,rbrvs_facprac,global_period from proc_rbrvsdet

[compare stuff here]

Load new data

Create proc_rbrvshdr constraint for proc_rbrvsdet.rbrvs_table_no:

insert into proc_rbrvshdr values('2','2019 RVU Load')

Now I can load the data:

load from '/tmp/2019rvu' delimiter ',' insert into proc_rbrvsdet(rbrvs_table_no, proccode, effdate, code_status, rbrvs_work, rbrvs_nonfac, rbrvs_facprac, rbrvs_malprac, global_period)

Data Structure

Column name          Type                                    Nulls

rbrvs_table_no       integer                                 no
proccode             char(10)                                no
effdate              date                                    no
code_status          char(1)                                 yes
rbrvs_work           decimal(6,2)                            yes
rbrvs_nonfac         decimal(6,2)                            yes
rbrvs_facprac        decimal(6,2)                            yes
rbrvs_malprac        decimal(6,2)                            yes
tc_rbrvs_work        decimal(6,2)                            yes
tc_rbrvs_nonfac      decimal(6,2)                            yes
tc_rbrvs_facprac     decimal(6,2)                            yes
tc_rbrvs_malprac     decimal(6,2)                            yes
global_period        char(3)                                 yes
ane_units            decimal(6,2)                            yes

Example RBRVS Work for CPT 99213

rbrvs_table_no    1
proccode          99213
effdate           01/01/2018
code_status
rbrvs_work        0.97
rbrvs_nonfac
rbrvs_facprac
rbrvs_malprac
tc_rbrvs_work
tc_rbrvs_nonfac
tc_rbrvs_facprac
tc_rbrvs_malprac
global_period
ane_units

Allscripts Project

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 Templates

Misys Vision Encounter (Superbill) Templates

SQL Query:

select tmpname,tmpdesc from formtmphdr where allow_edit = 'N' and tmptype = 7
tmpname       tmpdesc
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 LPP STYLE 3)
ENC11         MEDIC ENCOUNTER FORM #11
ENC11LASER    MEDIC #11 LASER ENCOUNT (60LPP STYLE 1)
ENCVIS        VISION STANDARD ENCOUNTER
ENCVISLASE    MEDIC VISION LASER ENC (60LPP STYLE 2)
MICROSCAN3    MICROSCAN ENCOUNTER (3RD VERS) 2.14.4   

These are the non-editable templates. You must copy the template (tmpname) to a new template and modify the new template accordingly.

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 log to logs.org and inbox to inbox.org.

# mv logs logs.org
# mv inbox inbox.org

After that, I created .fast_images directory in the inbox folder and also created .data directory in inbox.

# ls -l inbox
total 16
drwxr-xr-x 2 dev medgrp 512 Dec 5 15:33 .data
drwxr-xr-x 2 dev medgrp 512 Dec 5 15:33 .fast_images

Then, I chown’d the proper permissions.

# chown dev.medgrp inbox
# chown dev.medgrp inbox/.data
# chown dev.medgrp inbox/.fast_images
# chown dev.medgrp logs