I was playing with the fee sheet in Librehealth EHR and got an SQL error. Here is a screen shot. I apologize if someone already discussed this. I did a quick search but didn’t find any other references.
eAdd these fields.
ordering_physician
INT(11) DEFAULT ‘0’ COMMENT ‘ordering provider , if any, for this visit’,
referring_physician
INT(11) DEFAULT ‘0’ COMMENT ‘referring provider, if any, for this visit’,
contract_physician
INT(11) DEFAULT ‘0’ COMMENT ‘contract provider, if any, for this visit’,
We need an upgrade script @tony
Still sort of wish these fields said “clinician” vs “Physician”. Either way, we really need that upgrade system going.
Make a commit changing them
Oh, I am afraid that it would take a whole lot to revise the application to hit that naming bias everywhere…and would require a lot of stuff for migration as well. I am just sensitive to it, as most of my users are not MD’s. The important point is the upgrade piece, and I don’t mean to distract from that.
Agree, so we either write one, re-add the old one or use the example I provided from Ken which is pretty much identical, but wrapped in a date stamping process.
I have no time in my schedule right now, next month I can do it, if someone hasn’t done it by them.