Office system with audit history
First Claim
1. An office automation system comprising:
- (a) a computer;
(b) an entry device and a display device, each in communication with the computer;
(c) means for storing, updating and displaying the contents of a database, each of said functions of storing, updating and displaying comprising all or part of a task that the system is capable of performing in response to entries from the entry device, and(d) means for maintaining an audit history of the database comprising;
(1) means for generating an audit history of a plurality of records of said database wherein said means for generating an audit history comprises;
(i) means for retrieving the original active record and delta records associated with a record;
(ii) means for applying to the original active record, the corresponding delta record to create a first chronologically-ordered displayable historical data image record stored in a third temporary memory storage location, said historical data image record comprising data associated with the record after data in the original active record was updated and stored in memory in the first session;
(iii) means for applying each subsequent delta record to the previously created historical data image record until all delta records associated with the record have been applied, whereupon, each sequential displayable historical data image record represents data corresponding to the record each time the record was sequentially stored into the database, and(2) wherein each of said plurality of records has associated therewith;
(i) an original active record stored in a first temporary memory storage location;
(ii) at least one delta record stored in a second temporary memory storage location comprising an identification of each location within the record of data that was changed at a session and a copy of the data changed at said session, and(3) means for displaying said displayable historical data image records.
17 Assignments
0 Petitions
Accused Products
Abstract
A system is disclosed for the automation of virtually all clerical functions in an office, such as for example, an insurance agency. Virtually any document generated by the office may be printed without the need for pre-printed forms, as the system prints such forms on a laser printer near the worker requesting the form, using a page description language (PDL) appropriate to the printer. The clerical activity involved in maintaining, updating, retrieving, displaying and printing information relating to the functions of the office is supported.
A complete audit history of all activity to a specific database (DB) file record is maintained without saving the entire DB record in a historical file. The system also supports a worker when it is desired to interrupt a particular task and execute a different task, without losing information already entered for the first task, but without allowing the worker to exit the system without completing or accounting for the first task.
-
Citations
20 Claims
-
1. An office automation system comprising:
-
(a) a computer; (b) an entry device and a display device, each in communication with the computer; (c) means for storing, updating and displaying the contents of a database, each of said functions of storing, updating and displaying comprising all or part of a task that the system is capable of performing in response to entries from the entry device, and (d) means for maintaining an audit history of the database comprising; (1) means for generating an audit history of a plurality of records of said database wherein said means for generating an audit history comprises; (i) means for retrieving the original active record and delta records associated with a record; (ii) means for applying to the original active record, the corresponding delta record to create a first chronologically-ordered displayable historical data image record stored in a third temporary memory storage location, said historical data image record comprising data associated with the record after data in the original active record was updated and stored in memory in the first session; (iii) means for applying each subsequent delta record to the previously created historical data image record until all delta records associated with the record have been applied, whereupon, each sequential displayable historical data image record represents data corresponding to the record each time the record was sequentially stored into the database, and (2) wherein each of said plurality of records has associated therewith; (i) an original active record stored in a first temporary memory storage location; (ii) at least one delta record stored in a second temporary memory storage location comprising an identification of each location within the record of data that was changed at a session and a copy of the data changed at said session, and (3) means for displaying said displayable historical data image records. - View Dependent Claims (2, 3, 4, 5)
-
-
6. An office automation system comprising:
-
(a) a computer; (b) an entry device and a display device, each in communication with the computer; (c) means for storing, updating and displaying the contents of a database, each of said functions of storing, updating and displaying comprising all or part of a task that the system is capable of performing in response to entries from the entry device, and (d) means for generating an audit history record of a database record for each session data changes to the database record are saved in memory, wherein each database record comprises a current active record stored in memory which records current information, said means for generating an audit history record comprising; (1) means for prompting an operator to select a database record to change existing information in the current active record; (2) means for retrieving the current active record of the selected database record from memory into a location identified as an old record; (3) means for storing in a temporary storage location said current active record and data changes made to said current active record in a session in response to the operator'"'"'s inputs to change data in the current active record; (4) means for comparing the data contents of the old record comprising comparing the current active record of the selected database record with the data contents of the temporary storage location to select for storage said data changes made to said current active record during said session; said means for generating an audit history record further comprising; (5) a change number associated with said session, said change number incremented by one over the change number of the previous session; (6) an identification of each location within the old record that has different data than in the temporary storage location and a copy of the data contained in the old record at that location; (7) means for storing in memory said different data at each said location having said identification within the old record as said audit history record associated with said session, and (8) means for reading the contents of the temporary storage location back into memory as the new current active record; whereby an audit history record is created and stored in memory for each session during which the data in the current active record is changed by the operator. - View Dependent Claims (7, 8, 9, 10, 11, 12, 13)
-
-
14. A method for maintaining an audit history of a plurality of active records of a database residing in memory of a computer, said method comprising:
-
(a) the operation of the computer to perform the following steps; (1) retrieving the original active record and delta records associated with a record; (2) applying to the original active record the corresponding delta record to create a first chronologically-ordered displayable historical data image record stored in a third temporary memory storage location, said historical data image record comprising data associated with the record after data in the original active record was updated and stored in memory in the first session; (3) applying each subsequent delta record to the previously created historical data image record until all delta records associated with the record have been applied, whereupon, each sequential displayable historical data image record represents data corresponding to the record each time the record was sequentially stored into the database, and (4) displaying said displayable historical data images, and (b) each of said plurality of records having associated therewith; (1) an original active record stored in a first temporary memory storage location, and (2) at least one delta record stored in a second temporary memory storage location comprising an identification of each location within the record of data that was changed at a session and a copy of the data changed at said session; - View Dependent Claims (15)
-
-
16. A method for maintaining an audit history of a plurality of active records of a database residing in memory of a computer, wherein each said active record comprises a current active record stored in memory which records current information, said method comprising the operation of the computer to perform the following steps:
-
(a) prompting an operator to select a database record to change existing information in the current active record; (b) retrieving the current active record of the selected database record from memory into a location identified as an old record; (c) storing in a temporary storage location said current active record and data changes made in response to the operator'"'"'s inputs to change data in the current active record; (d) comparing the data contents of the old record comprising the selected database record with the data contents of the temporary storage location to select for storage said data changes made to said current active record; (e) generating an audit history record comprising; (1) a change number associated with said session, said change number incremented by one over the change number of the previous session, and (2) an identification of each location within the old record that has different data than in the temporary storage location and a copy of the data contained in the old record at that location; (3) storing in memory said different data at each said location having said identification within the old record as said audit history record associated with said session, and (4) reading the contents of the temporary storage location back into memory as the new current active record; whereby an audit history record is created and stored in memory for each session during which the data in the current active record is changed by the operator.
-
-
17. An office automation system comprising:
-
(a) a computer; (b) an entry device and a display device, each in communication with the computer; (c) means for storing, updating and displaying the contents of a database, each of said functions of storing, updating and displaying comprising all or part of a task that the system is capable of performing in response to entries from the entry device; (d) means for generating an audit history of a plurality of records of said database, each of said plurality of records having associated therewith; (1) an original active record stored in a first temporary memory storage location, and (2) at least one delta record stored in a second temporary memory storage location comprising an identification of each location within the record of data that was changed at a session and a copy of the data changed at said session; (3) means for retrieving the original active record and delta records associated with the record; (4) means for applying to the original active record, the corresponding delta record to create a first chronologically-ordered displayable historical data image record stored in a third temporary memory storage location, said historical data image record comprising said copy of the data associated with the record after data in the original active record was updated and stored in memory in the first session; wherein said means for generating an audit history further comprises; (1) means for applying each subsequent delta record to the previously created historical data image record until all delta records associated with the record have been applied, whereupon, each sequential displayable historical data image record represents data corresponding to the record each time the record was sequentially updated into the database, and (2) means for displaying said displayable historical data image records. - View Dependent Claims (18, 19)
-
-
20. An office automation system comprising:
-
(a) a computer; (b) an entry device and a display device, each in communication with the computer; (c) means for storing, updating and displaying the contents of a database, each of said functions of storing, updating and displaying comprising all or part of a task that the system is capable of performing in response to entries from the entry device, said database comprising a plurality of active records, where each of said plurality of said active records comprises a current active record and at least one of audit history record associated with said active record; (d) means for generating audit history of said active record comprising; (1) means for retrieving said current active record from said database, (2) means for storing said current active record in a first temporary storage location, and (3) means for retrieving and storing in a second temporary storage location at least one said audit history record associated with said active record as a delta record, said delta record comprising; (i) an audit history change number; (ii) changed data associated with said audit history change number, and (iii) an identifying location in said active record of said changed data; (e) means for applying to said current active record the corresponding delta record to create a first chronologically-ordered displayable historical data image record stored in a third temporary storage location, where said historical data image record comprises said changed data associated with said corresponding delta record, wherein said generating means further comprise applying each previous delta record to the subsequently created displayable historical data image record until all delta records in said audit history record have been applied, whereupon, each sequential displayable historical data image record represents changed data corresponding to each time said active record was sequentially stored in the database; and (f) means for displaying said displayable historical data image records.
-
Specification