Drug document production system

• US 5,963,967 A
• Filed: 03/26/1998
• Issued: 10/05/1999
• Est. Priority Date: 04/27/1995
• Status: Expired due to Term

• Current Assignee: Michael UMEN & Company Incorporated
• Original Assignee: Michael UMEN & Company Incorporated
• Inventors: Wilson, Phillip C., Martin, Erik A., Umen, Michael J., Nomides, Kathy J.
• Primary Examiner(s): Choules, Jack M.
• Application Number:
  US09/048,744
• Time in Patent Office: 558 Days
• Field of Search: 707/1, 707/3, 707/104, 707/531, 707/513
• US Class Current: 715/236
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G16H 10/20 for electronic clinical trials or questionnaires
• CPC Class Codes: G16H 15/00 ICT specially adapted for medical reports, e.g. generation or transmission thereof
• CPC Class Codes: G16H 40/63 for local operation
• CPC Class Codes: G16H 70/40 relating to drugs, e.g. their side effects or intended usage
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A document production system is provided for preparing documents and managing a database of information pertaining to investigational studies of medical products. The document production system includes a data management user interface for providing user access to the database and for retrieving information from the database as specified by selected document templates for placement into word processor-compatible documents. Additionally, the data management user interface is capable of updating information stored within the database in accordance with information specified within a previously-prepared document.

Claims

1. A method for producing a document for regulatory review of a medical product, comprising the steps of:

a) conducting a plurality of investigational studies of the medical product;

b) entering and storing data objects pertaining to the studies into a computer database;

c) providing a data management user interface configured to produce a status display identifying data objects pertaining to any of said studies for which incomplete information has been entered and stored;

d) providing at least one medical product document template specifying a predetermined order and format for at least a subset of said data objects, and having standard text portions;

e) retrieving said subset of data objects from the database;

f) reproducing, in a document compatible with a word processing system, said retrieved data objects and said standard text portions in the order and format specified within the template;

g) editing the document with the word processor; and

h) updating the database to reflect changes made to a data object during said editing step.

2. The method of claim 1 wherein said step of providing at least one medical product document template comprises providing a plurality of first templates and arranging said first templates in accordance with a first format prescribed in accordance with a first regulatory requirement.

3. The method of claim 2 wherein said step of providing at least one medical product document template comprises providing a plurality of second templates and arranging the second templates in accordance with a second predetermined format prescribed in accordance with a second regulatory requirement.

4. The method of claim 3 wherein said step of entering and storing data objects comprises:

a) defining at least two categories of alternative contents of at least one of said data objects according to the respective first and second regulatory requirements; and

b) specifying alternative contents of said at least one data object in accordance with said defined categories;

wherein said reproducing step comprises selecting one of said first and second templates; and

wherein said step of retrieving said subset of data objects comprises the step of retrieving a corresponding one of said alternative contents to be retrieved for each instance of said at least one data object throughout the document in accordance with the selected template.

5. The method of claim 1, wherein said editing step comprises step of

consulting the status display to identify an incomplete data object;

and

entering informational content corresponding to the incomplete data object into the document.

6. The method of claim 1, wherein said reproducing step comprises the step of providing delimiter codes in said document identifying the location of data objects therein, said editing step comprises editing the document at the location defined by the delimiter codes, and said updating step comprises identifying data objects within the delimiter codes in order to locate data objects to be updated in the database.

7. The method of claim 6 comprising the step of updating the status display to identify data objects stored in the database and data objects entered during said editing step.

8. A method for producing a document pertaining to a study of a medical product, comprising the steps of:

a) entering and storing data objects pertaining to the study into a computer database;

b) providing at least one medical product document template specifying a predetermined order and format for at least a subset of said data objects, and having standard text portions;

c) retrieving said subset of data objects from the database; and

d) reproducing, in a document compatible with a word processing system, said retrieved data objects and said standard text portions in the order and format specified within the template; and

wherein said step of entering and storing data objects comprises;

a) defining at least a first and second type of data object;

b) embedding a data object of said first type within at least one of said data objects of said second type; and

c) storing said one data object of said second type in said database with a coded reference to said embedded data object of said first type.

9. An apparatus for computer-aided composition and generation of a document for regulatory review of a medical product, comprising:

a word processor for editing the document;

a data storage and retrieval system comprising a database structured to provide access to at least two classes of information pertaining to plurality of medical product investigational studies, the classes including a class of detail objects and a class of test objects, the database being structured for storing references to detail objects embedded within the text objects;

a data management user interface operable concurrently with the word processor for providing a plurality of executable procedures for manipulating information within the database;

at least one medical document template for specifying the structure of a respective medical product document, the template included coded references in detail to objects and text objects for use in the medical product document in accordance with a selected format; and

document generation means accessible by the data management user interface for retrieving detail objects and text objects specified within the template, and for arranging the retrieved detail objects and text objects into a medical product document compatible with the word processor in accordance with the template.

10. The apparatus of claim 9 wherein the data management user interface is configured to provide a status display identifying detail objects required to complete the document that have not been entered into the database.

11. The apparatus of claim 9 wherein the document generation means includes non-printed code insertion means for inserting non-printed code characters into the medical product document for indicating the presence and class of each retrieved data object in the medical product document.

12. The apparatus of claim 9 including a plurality of the medical product templates for specifying the structure of respective medical product documents, each of the templates including coded references to detail objects and to text objects for use in a respective one of the medical product documents in accordance with a selected format, and wherein the document generation means selects one of said templates, retrieves detail objects and text objects specified within the selected template and arranges the retrieved detail objects and text objects into a respective medical product document compatible with the word processor in accordance with the selected template.

13. A method for producing hierarchically related documentation for regulatory review of a medical product, comprising the steps of:

a) conducting a plurality of investigational studies of the medical product;

b) creating data objects pertaining to the studies in at least one computer database;

c) providing at least one medical product documentation template specifying a predetermined order and format for at least a subset of said data objects, and having standard text portions;

d) retrieving said subset of data objects from the database;

e) generating, in documentation compatible with a word processor, said retrieved data objects and said standard text portions in the order and format specified within the template;

f) labeling objects in the generated documentation with non-printable delimiter codes;

g) editing the generated documentation with the word processor; and

h) updating the database to reflect changes made to labeled data objects during said editing step.

14. The method of claim 13 wherein said updating step comprises:

(a) retrieving objects of at least a first and second data type from the documentation, wherein said data types are identified by the non-printable delimiter codes;

(b) consulting a selected index of data object locations, according to the identified data type of each retrieved object, to obtain an index value defining a location in the database for each data object of the identified type; and

(c) replacing each data object at said location in the database with each corresponding data object retrieved from the documentation.

15. The method of claim 14 wherein said consulting step comprises obtaining, from said selected index, a reference to a second index of data objects, the second index defining the location of the data object in the database.

16. The method of claim 13 wherein said generating step comprises the steps of:

(a) determining whether a retrieved data object of a first data type includes an embedded data object of a second data type;

(b) consulting an index of data objects of the second data type;

(c) retrieving a data object of the second data type; and

(d) reproducing said data object of the second data type within the retrieved data object of the first data type.

17. An apparatus for computer-aided composition and generation of a document for regulatory review of a medical product, comprising:

a word processor for editing the document;

a data storage and retrieval system comprising a database structured to provide access to data objects pertaining to a plurality of medical product investigational studies;

a data management user interface adapted to be loaded into executable memory of a computer for providing a plurality of executable procedures for manipulating information within the database;

at least one medical document template for specifying the structure of a respective medical product document, the template including coded references to data for use in the medical product document in accordance with a selected format; and

document generation means accessible by the data management user interface for retrieving data objects according to the structure of a medical product document specified within the template, and for arranging the retrieved data objects into the medical product document in a format compatible with the word processor in accordance with the template;

wherein the data management user interface is adapted to be co-resident in the executable memory with the word processor to permit operation of the word processor independent of operation of the data management user interface.

18. The apparatus of claim 17 wherein the data management user interface is configured to provide a status display identifying data objects required to complete the document that have not been entered into the database prior to document generation.

19. The apparatus of claim 17 wherein the document generation means includes non-printed code insertion means for inserting non-printed code characters into the medical product document for indicating the presence each retrieved data object when the medical product document is provided to the word processor.

20. The apparatus of claim 17, wherein the data objects comprise a class of detail objects and a class of text objects, and wherein the database is structured to permit storage of a coded reference to a detail object embedded within at least one text object.

21. The apparatus of claim 20, including a plurality of medical product templates for specifying the structure of respective medical product documents, each of the templates including coded references to detail objects and to text objects for use in a respective one of the medical product documents in accordance with a selected format, and wherein the document generation means selects one of said templates, retrieves detail objects and text objects specified within the selected template and arranges the retrieved detail objects and text objects into a respective medical product document compatible with the word processor in accordance with the selected template.

22. The apparatus of claim 20, wherein the data management user interface is adapted for storing specified alternative versions of at least one data object, and wherein the document generation means is configured to associate one of said alternative versions of said at least one data object with the selected template, and to retrieve the associated alternative version for use in generating the document according to the selected template.

23. A method for producing a document for regulatory review of a medical product, comprising the steps of:

a) storing data objects pertaining to investigational studies of the medical product in a database;

b) retrieving the data objects into an electronic document compatible with a word processor;

c) placing delimiter codes in the electronic document for identifying the presence of retrieval data objects in the document and for identifying the corresponding data object location in the database;

d) editing the document with the word processor, including the step of editing data objects retrieved into the word processor;

e) updating the database to reflect changes made to data objects during said editing step; and

f) retrieving edited data objects into the electronic document.

24. The method of claim 23 wherein said editing step comprises the step of inserting a coded reference to a first data object into a second data object being edited.