Pharmacy system data interface system and method
View Patent ↗A method for receiving prescription data from a pharmacy is provided. The method includes emulating a device, such as using a pseudo TTY feature of a Unix operating system or a pseudo device of a Windows operating system. A prescription authorization system is then set to transmit data to the emulated device when the prescription data is provided to a claims approval agency by the prescription authorization system. The data can be supplemented with data from a secondary source, such as a system that acquires data in accordance with the Health Insurance Portability and Accountability Act or other suitable systems. The prescription data and any supplemental data is then received at the prescription authorization system, and is transmitted to the emulated device. The prescription data is also stored in a local log file, and is transmitted to a data warehouse over a network using the emulated device.
1. A method for receiving prescription data from a pharmacy comprising:
in response to a prescription authorization system of a pharmacy computer at a first network location transmitting prescription data to a claims processor computer, the prescription authorization system transmitting the prescription data to a device emulation system which emulates a modem requiring a dial-up connection, which dial-up connection is currently unavailable to the pharmacy computer;
the pharmacy computer storing the prescription data in a local log file, wherein the local log file is local to the pharmacy computer; and
the pharmacy computer transmitting the prescription data from the device emulation system to a data warehouse computer at a second network location over an Internet connection, the transmitting occurring while a dial-up connection to the data warehouse computer is unavailable.
2. The method of claim 1 wherein transmitting the prescription data from the device emulation system to a data warehouse computer at a second network location over the Internet connection further comprises:
storing a marker in the log file if the Internet connection is unavailable; and
transmitting the contents of the log file starting at the marker and ending at the most recent entry when the Internet connection is available.
3. The method of claim 1 further comprising setting the prescription authorization system to transmit the prescription data to the device emulation system in response to transmitting the prescription data to the claims processor computer.
4. The method of claim 1 further comprising:
receiving the prescription data at the data warehouse computer;
storing the prescription data in a data warehouse log file associated with the pharmacy that transmitted the prescription data.
5. The method of claim 4 further comprising:
transmitting the local log file at an end of day;
comparing the local log file with the data warehouse log file to identify any entries in the local log file that are missing in the data warehouse log file; and
storing the missing entries and the data warehouse log file in the data warehouse computer.
6. The method of claim 1 further comprising:
receiving patient information relating to the prescription data from a secondary source; and
combining the patient information with the prescription data.
7. The method of claim 6 wherein the patient information is received from a Health Insurance Portability and Accountability Act information system.
8. The method of claim 1 wherein the device emulation system operates independently of a device driver.
9. The method of claim 1 wherein the transmitting prescription data comprises:
selecting one of two or more supported modem connections of the prescription authorization system, where the prescription authorization system can transmit the prescription data to each of the two or more supported modem connections in parallel; and
wherein the device emulation system is emulating a modem in one of the selected modem connections.
10. A system for receiving prescription data from a pharmacy comprising:
a pharmacy computer at a first network location, the pharmacy computer having:
device emulation system which emulates a modem requiring a dial-up connection, which dial-up connection is currently unavailable to the pharmacy computer;
a prescription authorization system configured to:
transmit prescription data to a claims processor computer; and
in response to transmitting prescription data to the claims processor computer, transmit prescription data to the device emulation system;
a local log file system configured to store the prescription data in a local log file after the device emulation system receives the prescription data, the local log file local to the pharmacy computer; and
an update system configured to transmit the prescription data from the device emulation system to a data warehouse computer at a second network location over an Internet connection, the transmitting occurring while a dial-up connection to the data warehouse computer is unavailable.
11. The system of claim 10 wherein the local log file system further comprises:
a marker system generating tracking data for the prescription data if the Internet connection is unavailable; and
a delayed update system receiving the tracking data and transmitting the contents of the log file based on the tracking data when the Internet connection is available.
12. The system of claim 10 wherein the prescription authorization system is configured to transmit the prescription data to the device emulation system in parallel with the provision of the prescription data to the claims processor computer.
13. The system of claim 10 further comprising the data warehouse computer, wherein the data warehouse computer is configured to:
receive the prescription data over the Internet connection; and
store the prescription data in a data warehouse log file associated with the pharmacy that transmitted the prescription data.
14. The system of claim 13 further comprising:
an end of day system of the pharmacy computer configured to transmit the local log file at an end of day;
a log file comparison system configured to compare the local log file with the data warehouse log file to identify any entries in the local log file that are missing in the data warehouse log file; and
wherein the data warehouse computer is configured to store the missing entries in the data warehouse log file.
15. The system of claim 10 further comprising:
a secondary source system configured to provide patient information relating to the prescription data; and
a prescription data modification system configured to combine the patient information with the prescription data.
16. The system of claim 15 wherein the secondary source system is a Health Insurance Portability and Accountability Act information system.
17. The system of claim 10 wherein the device emulation system operates independently of a device driver.
18. The system of claim 10 wherein the prescription authorization system further comprises:
two or more modem interface systems; and
wherein the device emulation system emulates a modem receiving data from one of the modem interface systems.