I have been trying to do a SQL or CSV load of Lab Orders in to the procedure_type table based on information from clients. This has proven time consuming and error prone as the clients cannot provide comprehensive information that maps onto the procedure_type table and the three tier structure in OpenEMR.
I would prefer to create a standard load that can be done once and for all for all clients. I looked at LOIN Codes but they do not map very well onto the OpenEMR data structure.
I have two questions:
1 - Does anyone have experience adapting the LOIN Codes to procedure_type format? We are willing to invest some effort if this can be done.
2 - Is there any other source of lab order data that is available for such a purpose?
Thanks in advance for any ideas on how to solve this problem.
1 Like