Computerized system for customizing and managing benefits

• US 20020069077A1
• Filed: 03/23/2001
• Published: 06/06/2002
• Est. Priority Date: 05/19/1997
• Status: Abandoned Application

• Current Assignee: Westport Benefits LLC
• Original Assignee: Westport Benefits LLC
• Inventors: Smith, Robert E., Brophy, John T., Lyndon, Ann, Foley, A. Michael, Crevier, Philip R.
• Application Number:
  US09/816,541
• Publication Number:
  US 20020069077A1
• Time in Patent Office: Days
• US Class Current: 705/1
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 10/1057 Benefits or employee welfare, e.g. insurance, holiday or retirement packages

Abstract

The present invention is directed to a computer system for administering employee benefits. The computer system comprises a first tier. The first tier includes a plurality of users. At least one user is a workstation having a processor and memory. At least one other user is a system processing means. The workstation is configured for inputting rules into the computer system. The rules are for controlling the computer system. The system processing means is configured to generate and execute transactions based upon the rules. A second tier includes memory configured to store the rules. The rules are organized into tables within the memory of the second tier. A third tier includes memory configured to store benefit data. The benefit data is organized into tables in the third tier memory. The benefit data can be manipulated only by the system processing means executing the rule-based transactions.

Claims

1. A computer system for administering employee benefits, the computer system comprising:

a first tier, the first tier including a plurality of users, at least one user being a workstation having a processor and memory, and at least one other user being system processing means, wherein

a) the workstation is configured for inputting rules into the computer system, the rules for controlling the computer system; and

b) the system processing means is configured to generate and execute transactions based upon the rules;

a second tier, the second tier including memory, the memory configured to store the rules, the rules being organized into tables; and

a third tier, the third tier including memory, the memory configured to store benefit data, the benefit data being organized into tables, wherein the benefit data can be manipulated only by the system processing means executing the rule-based transactions.

2. The computer system of claim 1 wherein:

the workstations in the first tier are configured to download rules from the second tier;

at least a portion of the workstation memory is configured to form a temporary database for storing some rules for a session, the rules being downloaded from the second tier; and

the processor of the workstation is configured to erase the temporary database from the workstation memory after the session is complete.

3. The computer system of claim 1 wherein the system processing means is further configured to select rules from the second-tier memory and organize the rules into transactions.

4. The computer system of claim 1 wherein the system processing means is configured to automatically:

load generated transactions into a queue, the transactions being scheduled for execution at a predetermined time;

scan the queue for transactions scheduled for execution at a predetermined time; and

execute the scheduled transactions at the predetermined time.

5. The computer system of claim 1 wherein the transactions loaded in the queue are configured to access benefit data from the third tier, and the system processing means is further configured to:

verify validity of scheduled transactions and availability of benefit data required to execute scheduled transactions;

generate an error when required rules or benefit data is not available; and

place scheduled transactions which fail into a suspended state.

6. The computer system of claim 5 wherein the system processing means is configured to remove a scheduled transaction from the suspended state when all of the required rules are validated and benefit data is available and the error is cleared.

7. The computer system of claim 1 wherein at least some of the rules are data attributes and the first tier further includes a parsing engine, the parsing engine being configured to:

generate rules for conforming data to the format of the import file; and

generate rules for conforming data in the format of the import file to the format of benefit data stored in the third-tier memory based upon the data attributes.

8. The computer system of claim 7 wherein the import file has a plurality of records, each record having discrete portions corresponding to data attribute rules, the parsing engine being configured to:

generate a user interface, the user interface having a portion configured to display at least some of the records, each record having a plurality of fields, corresponding fields for each record being organized into columns; and

select and highlight a field.

9. The computer system of claim 7 wherein the parsing engine is further configured to:

import data from an import file to the third-tier memory;

format data from the input file to conform to data attribute rules;

export data from the third-tier memory to first tier memory; and

format data from the third-tier memory to conform to data attribute rules.

10. The computer system of claim 1 wherein the first tier further includes a reporting engine, the reporting engine being configured to:

load a word-processing document;

embed rules within the document for selecting data from the third tier;

embed rules within the document for conforming data to the format of a report; and

store such rules in the second tier.

11. The computer system of claim 10 wherein the third tier has a plurality of tables, each table having a plurality of records, each record having a plurality of fields, the reporting engine being configured to generate a document, the document having a portion configured to display at least some of the fields from some of the records from some of the tables.

12. The computer system of claim 10 wherein the reporting engine is further configured to:

export data from the third-tier memory to the first tier in conformance with rules;

format data from the third tier to conform to rules; and

generate a report to a word-processing document.

13. The computer system of claim 1 wherein the tables in the third tier include on-line history tables and rules in the second tier include history rules, the history rules including:

a first set of rules that define which benefit data from a particular table should be archived to the on-line history tables;

a second set of rules that define when benefit data is archived to the on-line history tables; and

a third set of rules that define what benefit data from a predetermined identifying key is archived to the on-line history tables.

14. The computer system of claim 13 further comprising means for writing data to an external storage medium, the external storage medium being configured to store an off-line history table, the rules in the second-tier further including:

a first set of rules that define which benefit data from a particular table should be archived to the off-line history tables;

a second set of rules that define when benefit data is archived to the off-line history tables; and

a third set of rules that define what benefit data from a predetermined identifying key is archived to the off-line history tables.

16. The method of claim 15 wherein each transaction has a predetermined execution date, the method comprising the additional steps of:

placing the transaction in a scheduling queue a predetermined amount of time before the predetermined execution date;

moving the transaction from the scheduling queue to a pending queue; and

then executing the transaction on the predetermined execution date;

17. The method of claim 16 wherein the transaction is a template used to generate additional transactions, the method further comprising the steps of adding additional rules to the transaction during the step of moving the transaction from the scheduling queue to the pending queue.

18. The method of claim 16 wherein the transaction is a template used to generate additional transactions, the method further comprising the step of adding additional rules to the transaction during the step of executing the transaction.

19. The method of claim 16 wherein the transaction is a template configured to consolidate two or more transactions, the method further comprising the step of adding additional rules to the transaction during the step of executing the transaction.

20. The method of claim 15 wherein the step of executing the transaction manipulates benefit data, and the step of executing the transaction includes the step of adding additional rules to the transaction, the additional rules defining the level of detail at which the manipulated benefit data is stored in the third tier.

21. The method of claim 20 wherein the manipulated benefit data is stored in first and second tables, and the level of detail at which the benefit data is stored in the first table differs from the level of detail at which the benefit data is stored in the second table.

15. A method of operating a computer system for administering benefits, the computer system having first, second, and third tiers, the first tier including users, the second tier storing rules, the rules being organized into tables, the third tier storing benefit data organized into tables, wherein benefit data in the third tier can be manipulated only by execution of a transaction, the transaction being formed from rules, the method comprising the steps of:

selecting a plurality of rules from tables in the second tier;

organizing the selected rules to form the transaction; and

executing the transaction, wherein execution of the transaction causes manipulation of benefit data in the third tier.