Pharmacy database structure component
地域：
MI
MI West Bloomfield
摘要
A data structure embodied on a computer-readable medium having a database schema for accessing and managing pharmacy transactions data in a structured query language (SQL) database. The database schema includes a session data schema representing a relational data table for capturing a plurality of sessions for accessing and managing the SQL database and a pharmacy prescription drug transaction results schema representing parameters for relating prescription drug transaction results with requesters, prescribers and the prescription drug. The session data schema and the pharmacy prescription drug transaction results schema used by a pharmacy business logic application to access and manage the pharmacy drug transaction results in the SQL database.
說明書
Aspects disclosed herein generally relate to a pharmacy database structure component.
Pharmacies are frequently faced with the challenge of whether or not to fulfill a request for a prescription drug from a customer. In many instances, the customer may not be authorized to obtain the prescription drug for one or more reasons, such as, the customer has been over-prescribed, the customer's prescription adversely interacts with other prescriptions or medications, and/or the customer does not have a valid prescription for the drug.
In a first illustrative embodiment, a data structure embodied on a computer-readable medium having a database schema for accessing and managing pharmacy transactions data in a structured query language (SQL) database is disclosed. The database schema includes a session data schema representing a relational data table for capturing a plurality of sessions for accessing and managing the SQL database and a pharmacy prescription drug transaction results schema representing parameters for relating prescription drug transaction results with requesters, prescribers and the prescription drug. The session data schema and the pharmacy prescription drug transaction results schema used by a pharmacy business logic application to access and manage the pharmacy drug transaction results in the SQL database.
權(quán)利要求
What is claimed is:1. A computer system comprising:a means for generating a pharmacy database structure component for previous completed requests and previous denied requests for a drug prescribed by a prescriber and requested by a requestor that are stored in at least two different retail pharmacy transaction computer systems including a first retail pharmacy transaction computer system and a second retail pharmacy transaction computer system, the first retail pharmacy transaction computer system including a first database of prescription drug transactions, the second retail pharmacy transaction computer system including a second database of prescription drug transactions, and the first and second retail pharmacy transaction computer systems are not configured to communicate with each other to share data relating to prescription drug transactions; a means for populating information relating to the previous completed requests and previous denied requests for the drug into the pharmacy database structure component; a means for generating a multi-dimensional risk assessment matrix for the requestor, the prescriber and the prescription drug by reference to the previous completed requests and the previous denied requests populated into the pharmacy database structure component; and a means for configuring for display a user interface including the multi-dimensional risk assessment matrix to share data relating to the prescription drug transactions of the first database with the second retail pharmacy transaction computer system and to share data relating to the prescription drug transactions of the second database with the first retail pharmacy transaction computer system, a fulfillment click button and a denial click button, the fulfillment click button is configured to be selected by a pharmacist to fulfill the fulfillment request, and the denial click button is configured to be selected by the pharmacist to deny a fulfillment request for the drug to mitigate over-medication and/or conflicting medication in connection with the fulfillment request. 2. The computer system of claim 1 , further comprising a means for transmitting the pharmacy database structure component and the multi-dimensional risk assessment matrix to a government agency server computer and/or an insurance company server computer for an analysis by the government agency server computer and/or the insurance company server computer in connection with the fulfillment request. 3. A computer system for determining whether a pharmacist should fulfill or deny a fulfillment request by a requester for a drug prescribed by a prescriber, the computer system comprising:a first retail pharmacy transaction computer system including a first database of prescription drug transactions and having a first format and a first data structure; a second retail pharmacy transaction computer system including a second database of prescription drug transactions and having a second format and a second data structure, the first format and/or first data structure of the first database are different than the second format and/or second data structure of the second database, the first and second retail pharmacy transaction computer systems are not configured to communicate with each other to share data relating to the prescription drug transactions of the first and second databases, a server computer having non-transitory memory for storing machine instructions that are to be executed by the server computer, the machine instructions when executed by the server computer causes the server computer to:receive the fulfillment request for the drug prescribed by the prescriber, the fulfillment request includes requester identifying information; transmit a request to the first and second retail pharmacy transaction computer systems for information relating to previous completed requests and previous denied requests for the drug by the requester based on the drug and the requester identifying information; receive from the first and second retail pharmacy transaction computer systems the information relating to the previous completed requests and previous denied requests for the drug, including a date of such previous completed requests and previous denied requests and a location of each previous completed request and previous denied request; generate a pharmacy database structure component for previous completed requests and previous denied requests received from the first and second retail pharmacy transaction computer systems for the drug logically categorizing the previous completed requests and previous denied requests; populate the information relating to the previous completed requests and previous denied requests for the drug into the pharmacy database structure component; generate a multi-dimensional risk assessment matrix for the requestor, the prescriber and the prescription drug by reference to the previous completed requests and the previous denied requests populated into the pharmacy database structure component; and configure for display a user interface including the multi-dimensional risk assessment matrix to share data relating to the prescription drug transactions of the first database with the second retail pharmacy transaction computer system and to share data relating to the prescription drug transactions of the second database with the first retail pharmacy transaction computer system, a fulfillment click button and a denial click button, the fulfillment click button is configured to be selected by the pharmacist to fulfill the fulfillment request, and the denial click button is configured to be selected by the pharmacist to deny the fulfillment request to mitigate over-medication and/or conflicting medication in connection with the fulfillment request. 4. The computer system of claim 3 , wherein the pharmacy database structure component includes the multi-dimensional risk assessment matrix. 5. The computer system of claim 3 , wherein the machine instructions when executed by the server computer causes the server computer to generate the pharmacy database structure component for the previous completed requests and previous denied requests for the drug logically categorizing the previous completed requests and previous denied requests in a chronological order based on the dates of the previous completed requests and previous denied requests. 6. The computer system of claim 3 , wherein the machine instructions when executed by the server computer causes the server computer to:repeat the transmit configuration to obtain updated information relating to the previous completed requests and previous denied requests; and automatically generate an updated pharmacy database component based on the updated information relating to the previous completed requests and previous denied requests. 7. The computer system of claim 6 , wherein the repeat and automatically generate configurations are capable of being executed independent of the first receive configuration. 8. The computer system of claim 3 , wherein the machine instructions when executed by the server computer causes the server computer to:determine whether the requester identifying information is true or false based on the pharmacy database structure component. 9. The computer system of claim 3 , wherein the requester identifying information includes a requester ID number. 10. The computer system of claim 3 , wherein the machine instructions operate whether or not the requester is registered in the first or second retail pharmacy transaction computer system. 11. The computer system of claim 3 , wherein the machine instructions when executed by the computer causes the computer to:transmit the pharmacy database structure component and the multi-dimensional risk assessment matrix to a government agency server computer and/or insurance company server computer for an analysis by the government agency server computer and/or the insurance company server computer for an analysis by the government agency server computer and/or the insurance company server computer in connection with the fulfillment request. 12. The computer system of claim 3 , wherein the prescription drug is a C2-C5 prescription drug. 13. The computer system of claim 3 , wherein the information relating to the previous completed requests and previous denied requests for the prescription drug includes a plurality of relationships between the requester and a plurality of prescribers. 14. The computer system of claim 3 , wherein the machine instructions when executed by the server computer causes the server computer to:transmit the pharmacy database structure component to a third pharmacy computer system. 15. The computer system of claim 3 , wherein the machine instructions when executed by the computer causes the computer to cloak the location of each previous completed request and previous denied request to maintain the confidentiality of the location of each previous completed request and previous denied request of a first retail pharmacy associated with the first retail pharmacy transaction computer system and a second retain pharmacy associated with the second pharmacy transaction computer system. 16. The computer system of claim 3 , wherein the multi-dimensional risk assessment matrix includes different risk levels and a different risk icon for each different risk level. 17. A non-transitory computer-readable medium having computer-readable instructions stored thereon that are configured to be executed by a processor to:receive a fulfillment request for a drug prescribed by a prescriber that includes requester identifying information; transmit a request to first and second retail pharmacy transaction computer systems for information relating to previous completed requests and previous denied requests for the drug by the requester based on the drug and the requester identifying information, the first retail pharmacy transaction computer system including a first database of prescription drug transactions, the second retail pharmacy transaction computer system including a second database of prescription drug transactions, and the first and second retail pharmacy transaction computer systems are not configured to communicate with each other to share data relating to prescription drug transactions; receive from the first and second retail pharmacy transaction computer systems the information relating to the previous completed requests and previous denied requests for the drug by the requester, including previous completed requests and previous denied requests for the drug, a date of each previous completed request and previous denied request, and a location of each previous completed request and previous denied request; generate a pharmacy database structure component for the previous completed requests and previous denied requests received from the first and second retail pharmacy transaction computer systems for the drug logically categorizing the previous completed requests and previous denied requests; populate the information relating to the previous completed requests and previous denied requests for the drug into the pharmacy database structure component; generate a multi-dimensional risk assessment matrix for the requestor, the prescriber and the prescription drug by reference to the previous completed requests and the previous denied requests populated into the pharmacy database structure component; and configure for display a user interface including the multi-dimensional risk assessment matrix to share data relating to the prescription drug transactions of the first database with the second retail pharmacy transaction computer system and to share data relating to the prescription drug transactions of the second database with the first retail pharmacy transaction computer system, a fulfillment click button and a denial click button, the fulfillment click button is configured to be selected by a pharmacist to fulfill the fulfillment request, and the denial click button is configured to be selected by the pharmacist to deny the fulfillment request to mitigate over-medication and/or conflicting medication in connection with the fulfillment request. 18. The non-transitory computer-readable medium of claim 17 , wherein the computer-readable instructions are further configured to be executed by a processor to generate the pharmacy database structure component for the previous completed requests and previous denied requests for the drug logically categorizing the previous completed requests and previous denied requests in a chronological order based on the dates of the previous completed requests and previous denied requests. 19. The non-transitory computer-readable medium of claim 17 , wherein the pharmacy database structure component includes the multi-dimensional risk assessment matrix. 20. The non-transitory computer-readable medium of claim 17 , wherein the computer-readable instructions are further configured to be executed by a processor to:repeat the transmit configuration to obtain updated information relating to the previous completed requests and previous denied requests; and automatically generate an updated pharmacy database component based on the updated information relating to the previous completed requests and previous denied requests. 21. The non-transitory computer-readable medium of claim 17 , wherein the computer-readable instructions are further configured to be executed by a processor to transmit the pharmacy database structure component and the multi-dimensional risk assessment matrix to a government agency server computer and/or an insurance company server computer for an analysis by the government agency server computer and/or the insurance company server computer in connection with the fulfillment request.
意見反饋
使用該功能遇到問題