The code_type from the codes table seems to be hard coded for only these CPT4, ICD9, HCPCS. There is also the notion of a Product code, but that appears to be mangled into the Drugs/Pharmacy module versus a generic products table.
I would like to suggest that we move the hard coded code_type to the Lists table and allow for the addition of custom code types, such as dues, supplements, chiropractic appliances, educational material, etc.
That would also allow for SNOMED and ICD.10 to be added as options.
We need a Payment type table that is similar to the Adjustment types as well, right now everything looks like a COPAY.
Frankly there needs to be a product inventory module that is more generic than the drug tables.
I’m working on getting these changes funded, so I wanted to see what feed back I can get from the group.
Code types are "hard coded" only in the sense that globals.php is. The configuration file for them is custom/code_types.inc.php. Also note that each code type has 7 different attributes, so this is not a good candidate for the list_options table… a new solution would be needed.
The drugs/pharmacy feature does also serve for handling sales of non-drug products. Note there is a globals.php option to control that. I’d suggest enhancing it to do what you need, rather than duplicating the effort.
Code types are also related to the different options like IPPF Clinic and Athletic teams.
An on/of toggle system for extra options seem a bit overdone, since once installed users are not expected to make many changes again, except for a learning situation. All tabling in the Medical world has some overlap and consistency. IDC9 is the old version of ICD10. ICPC is like ICD9/10 but relevant for General practitioners.
Every region seems to have their own set of laboratory lists and every day new possibilities are available to ask for a test. X-Ray/Echo/MRI etc has their own set of coding an body parts to examine.
So are laboratory codes and billing codes. The difference comes when these codes are used to make the bill with little parts of one and little parts of a Second/Third/ Fourth table.
Medication and related tables do have a complete different problem. These are not only things that can be taken by special route, but they sometimes have a price an sometimes have interrelated effects and are sometimes unfit special groups and interrelated effects… this complicated thing of medication makes the difference between a good and an average medication system.
We might have to move towards a table for every separate used coding system. I think the coding lists for every separate type are to long to make one list like Admin > List and/or Admin > Layout type of approach.