Problem List Improvements/Fee sheet imrovement issue

OpenEMR Development
1

yehster wrote on Friday, July 12, 2013:


Brady,
I loaded the ICD9 codes onto the demo site using the external load function, but after doing so the “problem checkboxes” on the fee sheet enhancements don’t show up.
Is there an additional setup step required or is this a bug?
I think it’s better if the checkboxes are displayed regardless of the code types settings, so that would be my approach if it’s a bug.

2

bradymiller wrote on Saturday, July 13, 2013:

Hi,
I remember this testing well when I did this. I’ll retest it.
-brady
OpenEMR

3

bradymiller wrote on Saturday, July 13, 2013:

Hi,
Yep, a bug is there. No matter what, the P checkbox is being hidden. The underlying functionality is working (ie. the ability to go from diagnosis code to medical problem, which is controlled via the code_types Medical Problem flags in Administration->Lists->Code Types).
-brady
OpenEMR

4

bradymiller wrote on Saturday, July 13, 2013:

Hi,
Odd, if I create the diagnosis on the fee sheet the original way (via search button at top) and then Click on the Type link (CPT to show the justification/P box), I then see the P selection box. So, bringing in items via the search in the new method is where the bug seems to be coming in.
-brady
OpenEMR

5

blankev wrote on Sunday, July 14, 2013:

Brady and Kevin,

since you are on top of this feature, you might be willing to give me some insight info on Administration => Code_types and => Services. I try to include ICPC, the coding set for General Practitioners for as proposed by WONCA, World Organisation for Family Doctors ( http://www.globalfamilydoctor.com/ ) and this coding set is very much related to ICD 9 and 10 for Doctors working in in-hospital clinical settings.

In Administration => List, => codes-types, I see a couple of options. Where can I find an explanation or what/how should I do with and is my interpretation of the available choices correct of the following options: (for this example I used the Demo Development of Open-EMR V.1.3.0 as shown in its Database)

  1. Active: toggles between YES it is included in the options or NOT included?
  2. Key: The connection to other tables in characters. Should be unique?
  3. ID: short interpretation of Key in numbers, so I assume it is also for connection of tables, suppose this should be unique too?
  4. Label: It show on the screen and in reports generated by OpenEMR report files, a more easy reading version of Key and also available for translations?
  5. Seq: How the code_types are sorted.
  6. ModLength: The length of the field for Mod in the different screens and what can be used in the Mod field and when is this option available?
  7. Justify: The option to make a connection with another Code_type option.
  8. Mask: a predefined option to show “something” in a consistent predefined way like +1-###-###-#### for telephone numbers?
  9. Claims: it does show in claims screen and printed claim reports for amounts to be claimed or paid claims?
  10. Fees: It belongs to a table where fees can be accepted as normal payment for given/rendered services?
  11. Relations: Somewhat confusing since it can only be some kind of connection to ONE other table?
  12. Hide: It is visible or invisible on input screens?
  13. Procedure: It is to be included in the Procedure tables and options?
  14. Diagnosis: It is to be included as a Diagnosis in the different patient options as a Diagnosed option.
  15. Clinical Term: No idea what to do with this option?
  16. Medical Problem: to be included in the Medical Problem list for a patient?

Please give me an indication: if I am correct in my assumptions and please correct me if I have the wrong interpretation!

I want to include this as a WIKI page for OpenEMR if nothing of this kind is available, or correct the info if needed.

6

blankev wrote on Sunday, July 14, 2013:

Oops, I see now that the name Services (V.1.1.13) is changes into Codes (Demo V.1.3)

I also forgot Externals.

17. Externals: Gives the options of making “with little or specific extra programming,” connection with external resources available.

7

bradymiller wrote on Sunday, July 14, 2013:

Hi Pimm,

Check out the current documentation on this:
http://www.open-emr.org/wiki/index.php/Code_Types

I’ve just modified the page a little and just placed a link to this in the Upcoming 4.1.2 User Guide Wiki page:
http://www.open-emr.org/wiki/index.php/OpenEMR_4.1.2_Users_Guide

The thing that would be super helpful would be showing how to add your new code set using both the External ‘No’ option and also using the ‘External’ option. Let me know if your interested in documenting this and will walk you through it.

-brady
OpenEMR

8

blankev wrote on Monday, July 15, 2013:

That is quite a lot of documentation! But worth the challenge. If time permits I think I can do something with your help.

There are differences between the Demo versions “V.1.1 or V 1.2” differ from “V.1.3” Obvious difference is the name Services is changed into Codes. There are also some extra tables for ICD9 and ICD 10.

I am the man of CSV of import, so huge tables like ICD10 might be to much for OpenEMR, but I am sure you might be willing to get a beter solution if problems arise. Yesterday I started will putting some Codes of ICPC into the Codes table and they were just appended at the end in version V.1.1.13. But that is different for next versions of OpenEMR. ICD9 and ICD10 are not only stored in Codes but also somewhere else. What i did is copy ICD9 tables, renamed them in ICPC tabels and started the manual add new items in Services. This new copied ICPC were empty and did not fill wit my new input.

So please give me the hints you suggested to get me going. LET ME Start the walk. As soon as V.1.2 is proven stable I promise to upgrade. Just for now I do work with V.1.1.13 patch 13 in included.

Gr, Pimm

9

bradymiller wrote on Monday, July 15, 2013:

Hi,

First suggest getting External “No” option working. Just need to do the following to do this:

  1. Create an entry for your ICPC code type in Adminsitration->Lists->Code Types (suggest basically copying all the same settings from the ICD9 (Except 1. set key to ICPC 2. set the ID to be 1 greater than whatever the maximum set value is there 3. Set External to No).
  2. Then just copy your codes into the ‘codes’ table and use the ID (it is a number) that you set in the code types in the ‘code_type’ column (fill the code_text and code columns with your codes; also can place short descriptions in code_text_short if they exist).

You will then be able to use your codes.

Once you do this, then can walk you through how to set it up as External(note the codes in this situation, they are not stored in the codes table). Note it is only worth doing this in 4.1.2(not yet released), since it is way to complicated in 4.1.1.

-brady
OpenEMR

10

blankev wrote on Monday, July 15, 2013:

Please help: In Demo Open-EMR, I can find V.1.1 official stable release and V.1.3 official developers demo not for daily practice. But NOT V.1.2, is this an error, or should I wait till official release?

Should I look at another place to find V.1.2 released for testing and almost available for stable release…, etc.

11

blankev wrote on Tuesday, July 16, 2013:

In the Demo Develop V.1.3 I go to phpMyAdmin and try to import CSV file into the tabel Codes. But it gives the following error:

=============================================
Error in Processing Request
Error code: 500
Error text: Internal Server Error

Q1. Suppose this is something specific for this Demo and the new PhpMyAdmin update? How can I do any import without getting this error message?

Q2. In the FEE SHEET in V.1.3. there is only a search option to see the Codes. Is there a wildcard for search? See them all like thing *** or ?ye* for differentiation…

12

bradymiller wrote on Tuesday, July 16, 2013:

Hi Pimm,
Can you attach the csv file here (or if copyright issues, send them to my email).
thanks,
-brady
OpenEMR

13

blankev wrote on Tuesday, July 16, 2013:

Ok, I need to continue and do a lot of finetuning. But I can start with files that seem to be acceptable for Demo V.1.1.1 AND Demo V.1.1.3

Demo V1.1.3 I can not ypload any table content, so please be so kind to include them in the daily updates.

Demo V.1.1.1 I will upload and download CSV files and that is no problem, but if these are OK, you are welcome to include the accepted tables in V.1.1. also. As long as it is for personal use, there is no Copyright conflict. (See the link in WIKI on Code Type.

14

bradymiller wrote on Monday, July 22, 2013:

Hi Pimm,
I’ve never really used the csv import thing, but does that file really drop right into the codes table (on previous OpenEMR versions)?
(note my real goal here is to make sure that the csv importing functionality in the new embedded phpmyadmin is not broken)
Here’s the error i get when try to import above into the codes table:
“Invalid column count in CSV input on line 1.”
-brady
OpenEMR

15

blankev wrote on Monday, July 22, 2013:

This was just a start so I could try to continue with developing the connections. When I made this CSV file it was OK for import in V4.1.1, but there might be a column missing since PhpMyAdmin does not lie.

I will look into it and try to find the mistake.

Why is the option to import CSV files blocked in V 4.3? It is a new PhpMyAdmin and might need some finetuning?

Tnx for the effort,

Pimm

16

bradymiller wrote on Tuesday, July 23, 2013:

Hi Pimm,
It’s a new version of phpmyadmin, so may be that some things that have changed (ie. some fine tuning may be needed).
-brady
OpenEMR

17

yehster wrote on Thursday, August 01, 2013:

The code addressing the original bug being discussed has been pushed to master.

18

blankev wrote on Wednesday, August 28, 2013:

I am very much interested in INFO about external and Internal Code import. But this month I have busy schedule and can not concentrate on this for me new issue for computer programming.

I get in contact if I can spare some extra hours for this project. Or you might see me on the Forum with comments and ideas.

19

blankev wrote on Monday, April 07, 2014:

The month took some more days this time, but I got interest in including ICPC codes into OpenEMR again. Need a lot of Developer-support, but at least I got tables, official tables from Norwegean maintainer of the most recent ICPC codes. I also got a breakdown for straight forward CSV oploading in the correct DB tables with long and shot names.

Brady, do you still offer to give advise where needed if time permits… from your side.

I wanted to start with the External Data Load page. Discovered that there are strange not straight forward table inclusion magic transforms for ICD9 and also different for ICD10.

ICPC is also a coding system with Diagnosis an Procedures more or less comparable to ICD coding.

You still want me to send you the original file? I got a version downgraded to a CSV import file like what I see for ICD9 in Database. Looks a lot easier to do what is done with the ZIP file of ICD9.

Please give some advise on how to attack the different steps to be taken…

20

bradymiller wrote on Friday, April 11, 2014:

Hi Pimm,

Attach the data files here to get an idea of things. For starting point here, a key goal is to use the official file as a starting point(ie. don’t manipulate it), so then will be much easier to upgrade to newer codes in future. For example, is there an official website that produces the data file(s)?

-brady
OpenEMR