|
|
|
MedAutoExport©
for Medical Manager
|
This Program automates the conversion of Patient Demographic, Billing and Appointment Data from "Legacy" DOS based billing (Medical Manager) systems into an SQL Database. Billing systems typically use comma delimited strings of numbers and words to define the demographic parameters for each patient. MedAutoExport© exports and converts this data on a user defined time interval, to an SQL data table easily accessible by most programs through ODBC controls (in Windows). This allows patient demographic data already entered into your billing system to become the center of a data hub, allowing other programs such as Electronic Medical Records, X-Ray Manager©, or Electronic Medical Outcomes© to utilize the same demographic data. This eases the burden of demographic input, and the risk of errors which occur when entering duplicate data. The same mechanisms can be used for secure logon since the database contains Names and Social Security Number, which may be used as a password. When the Importer is running, this window may be displayed if desired. In Figure 1 above, the DAT files are static file names directly from Medical Manager. Time intervals are set as desired, to provide you with a robust integrated data set. The resulting database is ODBC compliant, allowing any modern database to utilize the resulting imported patient data. In Figure 2 above, Field mapping is demonstrated by a simple "drag and drop method". This assures that the patients demographic data is always correct. In Figure 3 above, we are demonstrating a Database Query tool built into the Importer, which can quickly locate a patient, or a group of patients with the same parameters. This could include all patients in the same Zip Code, or in an age range. Currently, the Importer is configured for Medical Manager. With a mapping list, this may be altered to work with any similar comma delimited database field. In addition, this may be used with UNIX based systems by utilizing SAMBA, a free utility which allows a windows machine to read data from a UNIX server. Currently all Medical Manager files are imported on independent time intervals as you specify, and the data may be easily mapped to your EMR. Billing data may also be analyzed in a robust fashion to create a true Practice Management Capacity out of your current Medical Manager billing system, with low cost.
|
||||
|
|