Database forms with attached audit history

• US 6,070,177 A
• Filed: 03/06/1998
• Issued: 05/30/2000
• Est. Priority Date: 03/06/1998
• Status: Expired due to Fees

• Current Assignee: Vita Systems Incorporated
• Original Assignee: Vita Systems Incorporated
• Inventors: Kao, James Wei-Ching, Wu, David Tze-Si, Hill, Mark, Ichnowski, Jeffrey G.
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US09/036,314
• Time in Patent Office: 816 Days
• Field of Search: 707/901, 707/512, 707/10, 707/102
• US Class Current: 715/207
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system for associating an audit history with a database form is disclosed. In one embodiment of the present invention, a database document is displayed on a first portion of a display on network client computer. An audit history is displayed on a second portion of the display. The audit history contains information describing the transmission history of the document and any action taken with regard to the document. The audit history is updated automatically as the document is transmitted from one user to another user in the network.

Claims

1. A computer-implemented method for displaying an audit trail of a document on a display device, said method comprising the steps of:

displaying said document on a first portion of said display device;

displaying said audit trail on a second portion of said display device; and

automatically updating said audit trail when information relating to transmission of said document from one user to another user in a network changes.

2. The method according to claim 1 further comprising the steps of

storing in a first data field in said audit trail, data specifying a first user, said first user causing said document to be transmitted to a second user over said network;

storing in a second data field in said audit trail, data specifying said second user; and

storing in a third data field in said audit trail, data specifying any action taken with regard to said document by said first or second user.

3. The method according to claim 2 wherein said audit trail is displayed as a chronological log.

4. The method according to claim 3 wherein said document comprises a database object, said database object comprising a database form description file, and a data file, said data file comprising data entered by said first user into a form described by said database form description file.

5. The method according to claim 4 wherein said action taken by said first or second user comprises one or more of approving said document, disapproving said document, or forwarding said document to a third user.

6. The method according to claim 5 wherein said action taken by said first or second user further comprises modifying one or more items of data within said data file.

7. The method according to claim 6 wherein data modified by said second user is displayed differently than data originally entered by said first user.

8. The method according to claim 4 wherein said audit trail comprises a data array containing:

user data specifying said first user and any other user in said network to which said document has been transmitted; and

action data specifying said any activity taken on said document by a corresponding user of said document, and wherein said user data and corresponding action data is stored in said data array in a predetermined order.

9. The method according to claim 8 wherein predetermined order is determined by the order in which said document is received by users in said network.

10. The method according to claim 8 wherein data contents of said data array for said audit trail is provided automatically by a server computer coupled to said network, and wherein said data contents may not be modified by any user client in said network.

11. An apparatus for displaying an audit trail of a document on a display device, said apparatus comprising:

means for displaying said document on a first portion of said display device; and

means for displaying said audit trail on a second portion of said display device, said audit trail being automatically updated when information relating to transmission of said document from one user to another user in a network changes.

12. The apparatus according to claim 11 further comprising:

means for storing in a first data field in said audit trail, data specifying a first user, said first user causing said document to be transmitted to a second user over said network;

means for storing in a second data field in said audit trail, data specifying said second user; and

means for storing in a third data field in said audit trail, data specifying any action taken with regard to said document by said first or second user.

13. The apparatus according to claim 12 wherein said document comprises a database object, said database object comprising a database form description file, and a data file, said data file comprising data entered by said first user into a form described by said database form description file.

14. The apparatus according to claim 13 wherein said audit trail comprises a data array containing:

user data specifying said first user and any other user in said network to which said document has been transmitted; and

action data specifying said any activity taken on said document by a corresponding user of said document, and wherein said user data and corresponding action data is stored in said data array in a predetermined order.

15. A user interface for display on a computer, said user interface comprising:

a first display area containing a document capable of being transmitted between a first user and a second user in a computer network; and

a second display area containing an audit trail, said audit trail comprising data relating to identification of senders and receivers of said document, and data relating to any activity undertaken by any of said senders and receivers of said document in relation to said document.

16. The user interface according to claim 15 wherein said audit trail is displayed as a transmission history presented as a chronological log listing the identity of users in said network in the order in which they receive said document.

17. The user interface according to claim 16 wherein said audit trail is automatically updated when information relating to transmission of said document from one user to another user in said network changes.

18. An article of manufacture embodying a program of instructions executable by a machine, said program of instructions including instructions for:

displaying a document on a first portion of a display device, said document capable of being transmitted from one computer to another computer in a network; and

displaying an audit trail on a second portion of said display device; and

automatically updating said audit trail when information relating to transmission of said document from one user to another user in said network changes.

19. The article of manufacture according to claim 18 further including instructions for:

storing in a first data field in said audit trail, data specifying a first user, said first user causing said document to be transmitted to a second user over said network;

storing in a second data field in said audit trail, data specifying said second user; and

storing in a third data field in said audit trail, data specifying and action taken with regard to said document by said first or second user.