fsediqi wrote on Wednesday, April 15, 2009:
Hi Everybody,
OpenEMR is a perfect application.
Soon i’ll install this application in Afghanistan, Kabul.
The main reason is Open Source. Because The Hospitals in Afghanistan do not have enough budget.
The Perfect Solution.
Question:
How can I add an extra Services Type?
Greets from Holland,
Faeq Sediqi
blankev wrote on Wednesday, April 15, 2009:
Hello Feaq,
you seem to have found the right track. I am a General Physician in Curacao Netherlands Antilles and love the possibilities that are included in OpenEMR.
There are some issues:
It is a USA dominated invented program, this is to say, all text is in US English medical term. But since there is flexibility you might be able to find by now a lot translated in different languages.
The financial part is working with American standard Insurance regulations, but you can add your own declaration rules.
Now if you find this all disappointing, you might have to look at:
OpenEPR the Dutch translated version used in Utrecht at a Psychiatry Clinic. This versions works with the Dutch DBC "Diagnose Behandel Codes".
I for myself adapted OpenEMR for the General Physician setting as valid for Curacao.
I still want to include ICPC codes, but that is just a matter of time and energy to be directed towards that effort.
Anyway, welcome abord and I wish you to stay as enthusiastic as in your introduction. After some minor changes to the system and as soon as you understand the structures OpenEMR uses, it is a program with great potentials. Be sure to understand the import functionn of the different tables used in MySQL becaus next to all kind of Security rules MySQL is the beating heart of OpenEMR.
Let me know if I can be of any help, Being Dutch, Caribbean Dutch and a Physician very interested in solutions that have to do with Ineternet and dektop computing in Medical sttings. I must warn you I am not a programmer, but I can follow intsructions as to what is needed to be changed.
What do you mean with EXTRA SERVICE TYPES? Where can I find this back in OpenEMR screens? I might be of help…
Pimm
blankev wrote on Wednesday, April 15, 2009:
Since yesterday I was working on the following part of Services. But I do no completely understand the connections made in this file, but half way down in that file you find hard coded:
openemr/interface/patient_file/encounter/superbill_custom_full.php
ICD9 CPT4 HCPCS these are coded as values 1, 2, 3 and these values are used to store this information in MySQL. So it is hard to find back the connection with ICD9 etc.
If you change the Tree view to Radio button view, and include CAMOS- or FEES-forms, and you are set to include your own price Service model.
Let me know if this was what you were looking for and how you solved it. I still do not understand the MOD and connections used in this part of the financial part of OpenEMR.
Pimm
fsediqi wrote on Wednesday, April 15, 2009:
HI Pimm,
Thanks for the introduction and usfull info.
Please click here to see the screenshot.
http://image.arianahospital.com/openemr.png
I would like just add some more Service types.
fsediqi wrote on Wednesday, April 15, 2009:
HI Pimm,
Thanks for the introduction and usfull info.
Please click here to see the screenshot.
http://image.arianahospital.com/openemr.png
I would like just add some more Service types.
ideaman911 wrote on Wednesday, April 15, 2009:
Faeq;
Welcome aboard ;-) If I read correctly what you are asking, you want to add other code types besides "CPT4", "ICD9" and "HCPCS".
Please note my discovery that "COPAYS" is also listed, though it is not shown in the drop-down, and that the spelling of each is used as a logic in the encounters Billing column listing, so I urge caution.
I do not (yet) know where that drop-down list is compiled.
My brother spent a year in Kabul which ended in early 2008. I hope you are well and safe.
Joe Holzer Idea Man
http://www.holzerent.com
sunsetsystems wrote on Wednesday, April 15, 2009:
Service code types are defined in openemr/custom/code_types.inc.php. You can easily customize them there.
blankev wrote on Wednesday, April 15, 2009:
Rod, TNX for the advise.
Now I found the following:
// IPPF: (What is IPPF???)
$code_types = array(
‘ICD9’ => array(‘id’ => 2, ‘fee’ => 0, ‘mod’ => 0, ‘just’ => ‘’, ‘rel’ => 0, ‘nofs’ => 0),
‘MA’ => array(‘id’ => 12, ‘fee’ => 1, ‘mod’ => 0, ‘just’ => ‘’, ‘rel’ => 1, ‘nofs’ => 0),
‘IPPF’ => array(‘id’ => 11, ‘fee’ => 0, ‘mod’ => 0, ‘just’ => ‘’, ‘rel’ => 0, ‘nofs’ => 1),
‘CPT4’ => array(‘id’ => 1, ‘fee’ => 0, ‘mod’ => 0, ‘just’ => ‘’, ‘rel’ => 0, ‘nofs’ => 1),
‘ACCT’ => array(‘id’ => 13, ‘fee’ => 0, ‘mod’ => 0, ‘just’ => ‘’, ‘rel’ => 0, ‘nofs’ => 1),
What do us supposed to be done with ‘mod’ and what effects does this have on trhe rest of OpenEMR?
‘just’=>’ ’ is for justification, but what code and where do I find the result of this justification?
‘rel’ => ’ ’ seems so logic that I can’t find the relevance and effects that it might have in our Fee structure on Curacao?
, ‘nofs’ => 0 or 1 and when do you want a code, but don’t want o see it in the Fee sheet?
And please give me some info on what connections are made between CPT4 and ICD9 and HCPCS
else {
// USA Clinics:
$code_types = array(
‘REK’ => array(‘id’ => 2, ‘fee’ => 0, ‘mod’ => 2, ‘just’ => ‘’ , ‘rel’ => 0, ‘nofs’ => 0),
‘SVB’ => array(‘id’ => 1, ‘fee’ => 1, ‘mod’ => 2, ‘just’ => ‘REK’, ‘rel’ => 0, ‘nofs’ => 0),
‘BZV’ => array(‘id’ => 3, ‘fee’ => 1, ‘mod’ => 2, ‘just’ => ‘REK’, ‘rel’ => 0, ‘nofs’ => 0),
I changed this part into my wanted Fee schedules, would this do the job if there are no connections between the different fee schedules?
Tnx in advance, Pimm
sunsetsystems wrote on Wednesday, April 15, 2009:
IPPF is the International Planned Parenthood Federation. They have graciously sponsored many recent improvements, including the elimination of our dependence on SQL-Ledger.
You noticed the comments at the top of code_types.inc.php, right? The modifier (‘mod’) is mainly just for CPT code modifiers… if used, the modifier effectively becomes an extension of the code. ‘just’ currently is only relevant for insurance billing in the U.S. You probably don’t need ‘rel’ either.
As far as what will do the job, like so many things it depends on the details of what you need to accomplish. If you want to dive into it yourself, you might start by searching the code for references to ‘$code_types’. That will give you various examples of how the array of types is currently used.
sunsetsystems wrote on Wednesday, April 15, 2009:
By the way for new code types, you should pick ‘id’ values that are not already being used.
whimmel wrote on Wednesday, April 15, 2009:
Is there a central list of these IDs somewhere outside of the code?
If I add some different types of codes locally I would like to keep from conflicting from office OpenEMR codes that may be added in the future.
sunsetsystems wrote on Wednesday, April 15, 2009:
No there’s no central list other than that source module. But I can add notes in there about what others are using, if you tell me.
blankev wrote on Thursday, April 16, 2009:
Feaq,
just go: "up and down" for a while between: "Lay-out" and "Lists" and "Fee" and "Service" and there you will find lots of "mark points" that should give some info of where to go from there.
I changed some lists with my personal local information and then suddenly it becomes clearer and I think… now I know a bit better what Rod meant… better understanding of how this works.
Remember this product was made for the US but thanks to a lot of good thoughts/programmers it is possible to rearrange almost everything and make it work for any setting. And if you know your way around in Apache, MySQL, PHP, Java, Perl etc… you can do whatever you like.
I am just a stubborn General Physician who don’t want to give up, when I see a good product. Took me two years before I got it running and now I am finally in a state of euphoria. After reading beginners books on programming I NOW finally realize that I don’t need any programmers books. It helps but you can manage OpenEMR without any programmers knowledge. Just use plain computer common sense.
And since most Countries have their own billing problems in the medical fields you have to find a solution that will fit your needs.
What I usualy do if I don’t understand a table structure, I start filling in a couple of officail straight forward information. Via OpenEMR, not in phpMyAdmin. Then I export that small table to a CSV-Excel file via pohoMyAdmin. Sometimes it is easy to use the XAMMP phpMyAdmin, sometimes you can go strait to the DATABASE in OpenEMR to see your changes.
After that I use my own spreadsheet and with trial and error I get to know what can and what can not be imported and what needs to have a default number. Then I make the total folder and import this as a CSV file in the table.
This can only be done when there are no related tables involved. So it works most of the time on a virgin start of OpenEMR. Don’t EMPTY/DROP/DELETE the OpenEMR USER tablel!!!!!!! That is the part where the Login and password is located. Once you deleted the “logged in person” it stops working and you can not get back in. Unless you have a working backup CSV file. Than via phpMyAdmin external you can import this file and you should be save. But my advise is don’t take the risque and don’t delete by mistake the structure of the MySQL tables!
NEVER DELETE THE USER!
I just did it and was so frustrated that I almost reinstalled everything.
I am still looking for a way to print a recipe on a A6 size piece of paper, with more than one medication per A6.
And when all works, there might come some free time to get laboratory request and results to work for Curacao in OpenEMR.
Today was the day of the Address book and that was done. Not as nice as in my other program, but it works and I have all data transferred. Now I can do some refinement within OpenEMR.
Pimm
Pimm
fsediqi wrote on Thursday, April 16, 2009:
Hi Joe,
Thanks for the info.
I’m still safe in The Netherlands. 
I do everything remotely.