Method And System For A User-Customizable Interactive Physician Recall Message Database
Techniques for analyzing physician pharmaceutical product recall messages are disclosed. In a preferred embodiment, a method is presented which involves receiving physician recall messages and inputting the messages into a searchable database. A computer program allows a user to define customized message categories. The user definitions include full-text search strings for the messages. The messages are then sorted into the customized message categories based on the definitions. Finally, the sorted messages are presented to the user.
1 . A method for analyzing product recall messages and sorting the messages into categories, comprising:
(a) receiving one or more recall messages;
(b) inputting the one or more messages into one or more searchable databases;
(c) defining one or more customized message categories, each comprising full-text search strings for the one or more messages; and
(d) sorting the one or more messages into the one or more customized message categories based on the definitions.
2 . The method of claim 1 wherein said inputting the messages into a searchable database comprises:
(e) inputting the messages into a data entry database;
(f) transferring the messages into staging tables in a searchable database; and
(g) updating production tables in the searchable database with the messages stored in the staging tables.
3 . The method of claim 2 further comprising:
(h) providing a data table for each of the preceding 10 years; and
(i) copying each of the messages into a data table based on the year the message was sent.
4 . The method of claim 1 wherein the messages are pharmaceutical product recall messages.
5 . The method of claim 4 wherein the pharmaceutical product recall messages are physician pharmaceutical product recall messages.
6 . The method of claim 1 wherein the messages include a doctor identification number.
7 . The method of claim 1 wherein the messages include a product identification code.
8 . The method of claim 1 wherein the messages include a specialty identification code.
9 . The method of claim 1 wherein the full-text search strings include boolean operators.
10 . The method of claim 1 wherein said defining one or more customized message categories is conducted by one or more users, each user having an associated pharmaceutical market and message date range.
11 . The method of claim 10 wherein the user is restricted to searching only those messages associated with the user's pharmaceutical market and message date range.
12 . The method of claim 1 wherein the database is an SQL database.
13 . The method of claim 1 wherein the wherein said defining one or more customized message categories is conducted by one or more users through a web-based interface.
14 . A system for analyzing product recall messages and sorting the messages into categories, comprising:
(a) at least one input device for transferring one or more recall messages into one or more searchable databases;
(b) at least one database coupled to the at least one input device for storing the one or more messages;
(c) at least one processor coupled to the at least one database; and
(d) a computer readable medium coupled to the at least one processor, having stored thereon instructions which when executed cause the at least one processor to:
allow a user to define one or more customized message categories, each comprising full-text search strings for the one or more messages; and
sort the one or more messages into the one or more customized message categories based on the definitions.
15 . The system of claim 14 wherein the database further comprises:
(e) a data entry database for receiving messages from the input device and transferring the messages to a searchable database; and
(f) a searchable database including staging tables for receiving the messages from the data entry database and production tables, the staging tables updating the production tables with the messages received from the data entry database;
transferring the messages into staging tables in a searchable database.
16 . The system of claim 15 wherein the searchable database includes data tables for each of the preceding 10 years, the database allowing copying of each of the messages into a data table based on the year the message was sent.
17 . The system of claim 14 wherein the messages are pharmaceutical product recall messages.
18 . The system of claim 17 wherein the pharmaceutical product recall messages are physician pharmaceutical product recall messages.
19 . The system of claim 14 wherein the messages include a doctor identification number.
20 . The system of claim 14 wherein the messages include a product identification code.
21 . The system of claim 14 wherein the messages include a specialty identification code.
22 . The system of claim 14 wherein the full-text search strings include boolean operators.
23 . The system of claim 14 wherein each user has an associated pharmaceutical market and message date range.
24 . The system of claim 14 wherein the user is restricted to searching only those messages associated with the user's pharmaceutical market and message date range.
25 . The system of claim 14 wherein the database is an SQL database.
26 . The system of claim 14 wherein the user accesses the system through a web-based interface.