Method for updating a file

• US 5,586,313 A
• Filed: 02/12/1993
• Issued: 12/17/1996
• Est. Priority Date: 02/12/1993
• Status: Expired due to Fees

• Current Assignee: LIDP Consulting Services, Inc.
• Original Assignee: LIDP Consulting Services, Inc.
• Inventors: Ott, Frank, Berry, David, Ottens, Andrew L., Schnittker, William L.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/017,118
• Time in Patent Office: 1,404 Days
• Field of Search: 395/600, 395/575, 235/379, 235/375, 364/401, 364/413.01
• US Class Current: 1/1
• CPC Class Codes: G06F 16/178 Techniques for file synchronisation in file systems
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A method is disclosed for retroactively inserting a transactional change into a file where the file involves a plurality of images that are recorded (i.e., saved) at preset sequential time intervals. Each image contains all pertinent information relating to the file subject matter, such as an insurance policy or the like, existing at the time of its saving. The image which immediately precedes the effective date of the desired retroactive transactional change is retrieved, updated to the effective date, and then subjected to the program sequences of backing out, applying and reapplying. The resulting corrected image overcomes the prior art processing problems of prorating, policy cancellation and foreign record origin for a file.

Claims

1. In a computerized file record maintenance system of the type where, for each individual one of a plurality of record files, a plurality of stored images are successively individually recorded, each said image being so recorded at a date which is spaced by a prechosen time interval from the other images of said plurality of stored images that comprise one said image plurality for a given one of said record files, and each stored image containing all information relating to the status of its file as of the date of its recordation, and each individual one of said record files also having a recorded associated companion historical file containing recorded accounting records pertaining to that individual record file, the improved method of entering a desired retroactive transactional change at its effective date into a prechosen individual one of said record files comprising the successive steps of:

a) retrieving from among said stored image plurality for said one record file that one image whose recordation date immediately precedes said effective date of said retroactive transactional change;

b) entering all accounting records relevant to said one record file into said one image from the associated companion historical file of said one record file which relevant accounting records occurred during a first time period extending between and including said effective date and said recordation date of said so retrieved one image, thereby to produce a resulting image which represents the status of said one record file as it existed at said effective date;

c) retrieving a selected target date, said target date being a date that occurs between and including the present date and up to said effective date;

d) backing out from said resulting image using reverse arithmetic signs all relevant transactional changes which previously occurred during a second time period extending between and including said effective date and said target date and which were previously interveningly entered into said associated companion historical file so that all said interveningly entered transactional changes are negated, thereby to produce an intermediate image;

e) applying to said intermediate image said desired retroactive transactional change using correct arithmetic signs, thereby to produce an adjusted image;

f) reapplying to said adjusted image all said so backed out interveningly entered transactional changes using correct mathematical signs, thereby to produce a corrected image which represents said one file and which fully incorporates said desired retroactive transactional change; and

g) recording said corrected image as the working record image.

2. The method of claim 1 wherein, in said entering step, each of said relevant accounting transactions is divided into two separate accounting transactions, one said separate transaction covering the time period prior to said effective date, the other said separate transaction covering the time period after said effective date.

3. The method of claim 2 wherein, in addition, in said reapply step, each of said relevant accounting transactions is divided into two separate accounting transactions, one said separate transaction covering the time period prior to said effective date, the other said separate transaction covering the time period after said effective date.

4. The method of claim 2 where said pro-rating is performed on a daily basis thereby to provide quantitative daily information for accounting matters which vary on a daily basis.

5. The method of claim 1 wherein, in said reapply step, each of said relevant accounting transactions is divided into two separate accounting transactions, one said separate transaction covering the time period prior to said effective date, the other said separate transaction covering the time period after said effective date.

6. The method of claim 3 where said pro-rating is performed on a daily basis thereby to provide quantitative daily information for accounting matters which vary on a daily basis.

7. The method of claim 1 wherein said target date is selected manually.

8. The method of claim 1 wherein said target date is selected automatically based on manually input information about said desired retroactive transactional change.

9. The method of claim 1 wherein said one record file is initially converted from a record file that existed previously in a different file record maintenance system.

10. The method of claim 9 wherein said conversion is carried out by the steps of:

a) setting a last save date equal to the date of said conversion;

b) setting a policy image key date equal to said last save date;

c) writing said policy image as of said key date;

d) bringing said policy image current from said key date to the current date thereby to produce a resulting policy; and

e) additionally writing said resulting policy thereby to produce a current image of said one record file.

11. The method of claim 1 wherein each file relates to an insurance policy.

12. The method of claim 1 wherein said one record file is a suspended insurance policy.

13. The method of claim 1 wherein the steps of entering transactional changes, backing out intervening transactional changes and reapplying intervening transactional changes from the historical companion file is executed by a single subroutine.