computer method and apparatus maintains multiple versions of software programs. Included are a data store of different portions of each version and a generator coupled to the data store. The data store holds the program portions in a base-exception hierarchy. According to user command, the generator forms the desired program version by selecting a base portion and exception portions from the different levels of the hierarchy.
|
11. A method for maintaining a plurality of versions of a software program in a computer system, comprising the steps of:
storing different portions of each version of the software program in a base-exception hierarchy such that (i) basic portions that are common to each version are stored at a first level of the hierarchy, and (ii) exception portions that are common to less than all versions are logically coupled to affected basic portions and stored at succeeding levels of the hierarchy in order of decreasing commonality, said exception portions taking precedence over said basic portions by at least one of supplementing, replacing or modifying said basic portions; and
upon user command, forming a desired version of the software program by selecting basic portions and exception portions from the different levels of the hierarchy in response to the user command.
1. computer apparatus for maintaining a plurality of versions of a software program, comprising:
a data store for storing different portions of each version of the software program, the data store using a base-exception hierarchy such that (i) basic portions that are common to each version are stored at a first level of the hierarchy, and (ii) exception portions that are common to less that all versions are logically coupled to affected basic portions and stored at succeeding levels of the hierarchy in order of decreasing commonality, said exception portions taking precedence over said basic portions by at least one of supplementing, replacing or modifying said basic portions; and
a generator coupled to the data store for producing a desired version of the software program upon user command, the generator forming the desired version by selecting basic portions and exception portions from the different levels of the hierarchy in response to the user command.
2. computer apparatus as claimed in
3. computer apparatus as claimed in
4. computer apparatus as claimed in
5. computer apparatus as claimed in
6. computer apparatus as claimed in
7. computer apparatus as claimed in
8. computer apparatus as claimed in
9. computer apparatus as claimed in
10. computer apparatus as claimed in
12. The method as claimed in
13. The method as claimed in
14. The method of
15. The method of
16. The method of
17. The method of
18. The method of
19. The method of
20. The method of
|
Computer programs or generally software is utilized in a variety of ways throughout many industries. In one example, user interactive application programs are employed for accomplishing specific tasks such as word processing, accounting/bookkeeping, email or messaging or the like. In another example, database applications are employed where a common storage of data (i.e., the database) is shared among plural users.
It is becoming common for application programs and database programs/applications to be customized for a specific company (set of end users). For example, in the insurance industry there are many types of insurance (property and casualty, automobile, homeowner, etc.) For each type of insurance, various regulations and statutes (federal and/or state) may apply. Further, individual insurance agencies or companies may impose certain limits or conditions per insurance policy or as a function of the type of insurance. Because of the wide variety of combinations of these factors (insurance type, jurisdiction, specific insurance company), most insurance application software programs (for creating insurance policies or quoting policy rates, for example) are highly customized.
The ability of software writers/programmers to supply leveraged software solutions to the respective industries, such as the insurance industry, is complicated by companies' desires to differentiate themselves within their industry by providing variations to the industry-standard products and/or services offered in the marketplace. This company imposed requirement must be balanced with the need to develop automated processes that provide economies of scale to the development and maintenance of software programs. With respect to insurance software programs, this means that a single change to the base software program may or may not need to be reflected across all states and companies when and where it applies.
To date there is a lack of such economies of scale in the development and maintenance of software programs per a given industry. This is especially true in the insurance industry.
The present invention overcomes the shortcomings of the prior art. In particular, the present invention provides a cost and time saving method and system for developing and maintaining software programs/products without restriction to industry standards or fixed software programs.
For insurance software, the present invention manages the individual company deviations—particularly their unique data elements, UI (user interface) pages, rate deviations and external data sources such as Motor Vehicle Records (MVR's) within a standard fixed software program offering.
Toward that end, the present invention provides a computer method and apparatus for maintaining a plurality of versions of a software program. The method and apparatus include (a) a data store for storing different portions of each version of the software program and (b) a generator coupled to the data store for producing a desired version of the software program upon user command. The data store uses (stores data in) a base-exception hierarchy such that (i) basic portions that are common to each version are stored at a first level of the hierarchy, and (ii) exception portions that are common to less than all versions are stored at succeeding levels of the hierarchy in order of decreasing commonality.
The generator forms the desired program version by selecting basic portions and exception portions from the different levels of the hierarchy in response to the user command.
In accordance with one aspect of the present invention, the exception portions have effective date indicators and the generator is responsive to the effective date indicators in forming the desired program version.
In a preferred embodiment, the data store uses object oriented programming techniques to represent the basic portions and the exception portions such that inheritance applies across different portions.
In the case of insurance software, the invention method and apparatus generates and maintains software programs for prospecting insurance policies, for different companies, in different lines of business and different states or jurisdictions (e.g., province, county). In that case, the first level of the data store hierarchy corresponds to insurance terms that are acceptable countrywide. Succeeding levels of the hierarchy correspond to insurance terms according to industry standards bureaus, states (province) and/or specific insurance company requirements. Further, for the desired version, the generator outputs rating engine files for use as input to a rating engine. In one embodiment, the rating engine files include rate tables and/or rules files.
In accordance with another aspect of the present invention, for the desired version, the generator outputs (a) a user interface, (b) an application database storing data for the desired version, (c) a rules file, and (d) a mapping file describing structure of the application database. The generator output further includes a program file enabling importing and/or exporting of the desired version over a global network.
The present invention method carries out the functional steps of the invention apparatus mentioned above.
The foregoing and other objects, features and advantages of the invention will be apparent from the following more particular description of preferred embodiments of the invention, as illustrated in the accompanying drawings in which like reference characters refer to the same parts throughout the different views. The drawings are not necessarily to scale, emphasis instead being placed upon illustrating the principles of the invention.
A description of preferred embodiments of the present invention follows. Embodiments specific to the insurance industry are described for purposes of illustration and not limitation of the present invention.
The insurance products/services offered by Property and Casualty (P & C) carriers are generally similar, thus creating a “quasi-standard” or industry standard. These standards are created within the industry based on organizations or a “Rating Bureau” such as ISO (Insurance Services Office). Moreover, state insurance departments standards include statistical and accounting requirements, input and output forms, MVR's and rating.
The P & C insurance standard is first established at the countrywide level. Insurance companies then choose a rating bureau to follow. It is common for many states to have exceptions to countrywide rules and guidelines, which override the countrywide standards. Insurance companies may also choose to deviate from countrywide rating bureau standards or state standards to differentiate their products/services in the marketplace, or choose to not embrace a particular standards organization or information supplier.
For each of multiple companies, the present invention enables the creation of a company-specific version of industry software, which in this example is insurance application programs, that is further deployed by an effective date of change. More generally, the present invention provides generation and maintenance of multiple versions of each of different software programs. That is, the present invention enables maintenance of different software programs together with respective versions of the software programs. To accomplish this, the present invention employs a base-exception approach. For a given software program, the present invention provides/stores a basic or base version of the program. For each of different versions of the given software program, the present invention stores different portions that are exceptions to corresponding portions in the base program. In a preferred embodiment, the base and exception portions are stored in a hierarchy that enables efficient retrieval (production) of the desired version of the software program (discussed further below).
The DMS 18 houses the following relationships for information provided by external sources 30:
The DMS 18 is formed of a database 12 and a product generator 16. Although database 12 is preferably a relational database, other types of databases (e.g., network database, etc.) are suitable.
External sources 30 provide the data stored in database 12. This includes standard insurance client data (from individual insurance companies 30c or third party systems 30b, e.g., MVR, etc.), general policy information (for example, from standards bureaus 30a), state regulatory specific data (from state regulations 30d) and company-specific data (from individual insurance companies 30c).
At a second or succeeding level 22, database 12 stores industry standards or guidelines according to bureaus or standards organizations (shown as Bureau 1 and Bureau 2). To the extent that a standard or guideline corresponds to (takes precedence over, supplements, replaces or otherwise modifies) a piece of data (regulation, statutory limit, etc.) at the countrywide level 14, the standard or guideline is related to the affected countrywide level 14 data. That is, the records at level 22 of the bureau (Bureau 1 or Bureau 2) issuing that standard/guideline are logically coupled to the affected data at the countrywide level 14.
At a third level 24, database 12 stores indications of state or other jurisdiction exceptions (S1, S2, S3, etc.) to the Bureau 1, Bureau 2 standards or guidelines of level 22. A given state, say S1, may require, for example, stricter standards than a bureau (say Bureau 1) guideline of hierarchy level 22 or the countrywide level 14. Database 12 stores the state data (of level 24) in a manner that provides correspondence or logical coupling to the affected bureau data of level 22. State exceptions S1, S2, S3 . . . include state regulations, statutory limits, thresholds and the like.
In one embodiment of the present invention, data of the countrywide level 14 and the Bureau level 22 are combined. This reduces complexity of the database 12.
It is understood that province, county or other jurisdictional definition may be used instead of state for the level 24 data. As used herein the term “state” is thus meant generically to refer to a geographical or locational jurisdiction (e.g., province, county, etc.), agency jurisdiction or other governing jurisdiction.
At the highest hierarchy level 26, database 12 stores company-specific data according to company (labeled Co1, Co2, . . . Con in
The company-specific data (Co1, Co2 . . . ) of level 26 overrides or modifies state exceptions (S1, S2, S3 . . . ) of hierarchy level 24, bureau exceptions of hierarchy level 22 and/or countrywide data at hierarchy level 14. Database 12 stores the company-specific data of level 26 in a manner that provides correspondence or logical reference to the affected state level 24 data.
Time stamps 28 indicate effective date and time of a set of data in the various levels 14, 22, 24, 26 of database 12. So a given state may have different exceptions depending on the policy or operative date. S1 and S1′ in
Likewise company Co2 of level 26 may modify state exceptions of S1 and S1′ when respectively applicable to their time stamps 28. Company Co2's data does not affect state level 24 data until the company's effective date/time as indicated by Co2's time stamp 28.
Bureau 1 may have multiple sets of standards with respective effective dates each indicated with a respective time stamp 28. Further, it is understood that standards of a bureau (Bureau 1 for example) may apply to all fifty states during one time period, and at a different time period, standards of a different bureau (Bureau 2) may apply to a subset of the states (S1, S2 . . . ) according to time stamps 28 at the bureau level 22.
Further, the data structure of
Returning to
In response to the user's command, product generator 16 searches database 12. In particular, utilizing the indicated line of business and insurance type, generator 16 generator 16 traverses the obtained hierarchy of data and effectively collects the corresponding data (program portions). The collected data serves as the exception portions to the base portion (or basic workbook program 64 in
The results are the base-exception program portions for forming the desired software program version 20 in response to the user command. The resulting program version portions are as up to date as maintained by database 12. In this way, if there is a change in governmental rules 30d or standards organizations data 30a, or the like, the present invention system 18 enables all affected product programs 20 to be efficiently updated. Similarly, if an insurance company changes its particular requirements (represented at 30c), the present invention system 18 enables each affected product program 20 to be efficiently updated.
The resulting product programs 20 are executable or computer application usable code. In the insurance application example, product programs 20 are so called “published” as a computer generated report and used as input (in the form of electronic spreadsheet workbooks) to rating engines and other software applications discussed later.
As mentioned above, the result produced by generator 16 is a version of a company-specific software program 20 as stored and maintained in database 12. Each such resulting company-specific software program 20 comprises multiple components. In general, in
The rating components 40 include company ratebooks 34 and a series of rule sets 36 and rate tables 38 that provide the interpretation of a company manual to underwrite and rate a line of business within a rating engine. In one embodiment, Compu-quote tables or similar tables are included.
The user interface components 42 include, for example, Web-based user interfaces (e.g., Web pages and forms), used to capture and present information. This may include a content component 46, a style component 48 and a control component 49. In a preferred embodiment, Java-scripts for client side editing are included here.
The third party interface components 44 include pertinent data streams 32, that is a data collection from external sources of information (such as MVR's) and the process to acquire this data. An interface file layout (such as fields, domains/constraints) and messages and translations (
The application database 120 contains standard client information/data 122. standard policy information 124 and company-specific data 126 as illustrated in
Surrounding the domain management system 18 of
Use of the tool sets 60 with database 12 is outlined in the flow diagrams of
At Step 2 in
At Step 3 in
Briefly, client computer 150 and server computer 160 provide processing, storage, and input/output devices for the invention DMS 18 system with tool sets 60. The client computers 150 can also be linked through a communications network 170 to other computing devices, including other client computers 150 and server computers 160. The communications network 170 can be part of a global network (e.g., the Internet), a worldwide collection of computers, networks and gateways that currently use the TCP/IP suite of protocols to communicate with one another. The Internet provides a backbone of high-speed data communication lines between major nodes or host computers, consisting of thousands of commercial, government, educational, and other computer networks, that route data and messages. In another embodiment of the present invention, the DMS 18 system with tool sets 60 can be implemented on a stand-alone computer.
Referring to
The following examples further illustrate the functional efficiencies of the present invention method and system 18. The examples are for purposes of illustration, not limitation of the present invention.
Company X provides geographic data to the insurance industry. The majority of insurance companies utilize data from X in some of their premium development; therefore, X is considered a standards organization to the insurance industry. Based on the zip code of a geographic area, X provides a measurement of the groundwater pollution prevalent in the area. Company A translates the measurement into a rating factor that is applied to the pollution of a Commercial General Lines (CGL) policy, which is typical among most insurance companies. Company B chooses to not utilize the groundwater pollution measurement in determining the pollution premium; however, they want to capture the information for risk management purposes only. The present invention system 18 may electronically feed an independent risk management firm (RM1) to inspect prospective risks for some of the client base of database 12; the firm uses the groundwater pollution information to help insured's develop risk management programs. Company B uses RM1 to provide risk management services, while Company A does not.
The following steps are required with respect to groundwater pollution:
The domain management system 18 maintains the following relationships related to groundwater pollution:
It is important to note that these relationships may change over time; thus the DMS 18 maintains an audit trail of the relationships as changes occur.
The following example is intended to serve as a high level walkthrough of the DMS concepts, using an example that resembles common insurance industry practices.
Assume that the existing countrywide rule related to Homeowners Medical Payments Coverage for the ACE Rating Bureau is as follows: $1000 Medical Payments Coverage is available at no charge. This coverage may be increased for an additional charge as follows:
Limit
Premium
$5,000
$10
$10,000
$15
The state of Maine was consistent with the countrywide rule until Jan. 1, 2001 when the following exception applies to the ACE countrywide rule for Medical Payments:
Medical Payment Limits of $7,500 are available for a premium of $13.
Company ZZZ, a subscriber to ACE, deviates (effective Jun. 1, 2001) from the Maine Medical Payments premiums as follows:
Limit
Premium
$1,000
$3
$7,500
$12
$10,000
$14
The $5,000 coverage is not available. In addition, a $2,000 limit is available for a charge of $6.
The database 12 portion of the DMS 18 identifies the raw data recognized by an external source (standards organization or unique insurance company information) 30. This information is comprised of two sections, field definition and field choice definition.
Field Definition
Table Name=Home
Table Name—Home
Field Choice Definition
Table Name=Home
Table Name=Home
Table Name=Home
Table Name=Home
Note—The Field Choice Definitions are indexed to the Field Definitions, to establish a relationship between the entries of the two tables.
In the invention DMS 18, the hierarchy (country, line of business, state and company) to which the database 12 information belongs is maintained as in the below table:
Field
Table
Field
Choice
External
Line of
Date and
Name
Name
Name
Source
Business
Country
State
Company
Time
Deletion
Premium
Home
MedPay
$1,000
ACE
HO
US
Jan. 1, 1900
$3
Limit
12:00 am
Home
MedPay
$2,000
ACE
HO
US
ME
ZZZ
Jun. 1, 2001
$6
Limit
12:00 am
Home
MedPay
$5,000
ACE
HO
US
Jan. 1, 1900
$10
Limit
12:00 am
Home
MedPay
$5,000
ACE
HO
US
ME
ZZZ
Jun. 1, 2001
Y
Limit
12:00 am
Home
MedPay
$7,500
ACE
HO
US
ME
ZZZ
Jun. 1, 2001
$12
Limit
12:00 am
Home
MedPay
$7,500
ACE
HO
US
ME
Jan. 1, 2001
$13
Limit
12:00 am
Home
MedPay
$10,000
ACE
HO
US
Jan. 1, 1900
$15
Limit
12:00 am
Each record within the database 12 is flagged with the external source's 30 effective date and time for the information. A record no longer in use by an external source 30 is flagged as a deletion.
Rating 40, one of the developed product 20 components may be broken down into two areas: rating rule sets 36 and rating tables 38. A rating rule set 36 may be defined as a series of rules that provide rating/underwriting functions using messaging, algorithmic, conditional or rate table lookup functions. Each rule set 36 consists of one or more data elements which can be found within the database 12 of the DMS 18.
For example, the Medical Payments Coverage rule set looks as follows within a rating engine that receives and processes the given product 20:
The Homeowners Medical Payments rule set 36 is saved with attributes embracing the hierarchy of deviation for the ACE Rating Bureau. The following attributes are stored with the rule set 36 in that example:
NewBiz
Renewal
Rating
Company
Base
Sub-
Effective
Effective
Bureau
LOB
Country
State
Company
Code
—
Rule
Rule
Date
Date
ACE
HO
US
XX
1
XXX
—
ME
XX
20010101
20010101
DE
The rule set 36 also gets saved within a company ratebook 34, a series of rating and underwriting rules and rate table lookups that provide the interpretation of a company manual. The relationship between the ratebook 34 and the rule set 36 is stored within database 12 tables of DMS 18.
Company
Ratebook
Rule Set
ZZZ
ZZZHO20000101.rbk
ACEHOUSXX1XXX—
MEDPXX20010101.rul
The ratebook 34 is also defined with attributes that uniquely identify each company product 20:
Rating
Company
New Biz
Renewal
Bureau
LOB
Country
State
Code
—
Effective Date
Effective Date
ACE
HO
US
ME
ZZZ
—
20010101
20010101
The attributes associated with each rule set 36 and ratebook 34 are defined within the hierarchy in which they are stored.
Additional entries in the rating rule set 36 may include:
Rating Rule Set
Table Name
Field Name
ACEHOUSXX1XXX—
Home
MedPayLimit
MEDPXX20010101.rul
ACEHOUSXX1XXX—
Home
MedPayPremium
MEDPXX20010101.rul
A rating table 38 may be defined as an individual rule within a rule set 36 where a lookup is performed, based on variables passed to the rating engine from the calling application. The governing rules for a rule set 36 do not necessarily correspond to those of a rate table 38; for example, a company may deviate from rate table values without deviating from the actual rule set 36. Therefore, the cataloging and tracking of rating tables 38 should be independent of rule sets 36.
The Company ZZZ Maine Homeowners Medical Payments rate table 38 is saved with attributes that embrace the hierarchy of deviation for the ACE Rating Bureau. The attributes are as follows:
Rate
NewBiz
Renewal
Rating
Company
Table
Effective
Effective
Bureau
LOB
Country
State
Company
Code
—
Name
Date
Date
ACE
HO
US
ME
2
ZZZ
—
MEDPAY
20010601
20010601
where:
It is very important to note that, in the above example, the rule set 36 is saved at the countrywide level and the rate table 38 at the state level. The reason for this is that the field choice names are updated for the state of Maine, but the actual algorithmic calculation not altered. The construct of the rate tables is altered for Maine (due to the changes in the field choices), but the method for obtaining a premium (performing a rate table lookup) is not. The rate tables 38 are saved within a hierarchy in a similar fashion as the ratebooks 34 and rule sets 36, with a naming convention that contains the rate table name and effective date.
The rate table 38 catalogs database fields that serve as elements of the rate table lookup. In addition, the rate table 38 identifies the rule set 36 to which the rating table 38 is attached:
Rating Table
Rule Set
ACEHOUSMA2ZZZ_MEDPAY20010601.tbl
ACEHOUSXX1XX—
MEDPXX20010101.rul
One preferred embodiment separates its user interface product components 42 into three component parts: content component 46, style component 48 and control component 49 (
Preferably, three UI components 46, 48, 49 are stored within Visual Source Safe, a version control system that enables the management of individual and team projects regardless of file type. The file structure defined in VSS for the content component 46 is based on the hierarchy of deviation. The parent folder is the line of business; for example, business owners (BOP), homeowners (HO) or personal auto (PA). Once one is within a line of business, the structure follows the same logic:
##STR00001##
This storage structure allows for a quick and easy build of Company ZZZ's product by housing a standard set of UI's 42 with LOB and state combinations. Therefore, when Company ZZZ deviates from the state of Maine's exception to Medical Payment limits, the Maine homeowners content 46 template is taken from VSS and developed into a customer-specific solution.
Global control 49 functionality (conditional logic, validations and navigation) is included in the Maine homeowners product 20. If Company ZZZ has specific company logic that needs to be followed, this too will be stored in VSS in a folder structure that notes the control files 49 as a company deviation.
Lastly, the style component 48 or look and feel of the UI, is a standard template provided by the preferred embodiment unless otherwise requested by Company ZZZ. All deviations from the standard style 48 are also stored in VSS.
Standard naming conventions are created based on the blend of files used to create a company-specific UI 42. For example, Company ZZZ's file reference would contain the following attributes:
Screen
Controls
Style #
LOB
State
Company
Name
Applied
Applied
HO
ME
ZZ
Policy
ABC
1
Continuing with the above Medical Payments Coverage example, the following situations discuss how the DMS 18 addresses changes that may occur with customer (insurance company) products.
Changes to Rules or Guidelines of a Standards Organization
Assume that the countrywide medical payments rule is updated, effective Sep. 1, 2001, to include an additional factor in the calculation. The new rule states to multiply the rate table lookup by an IRPM factor to derive the premium. The State of Maine chooses not to adopt the countrywide rule.
The invention database 12 is updated for the IRPM factor:
The source relationship table 14 is updated to include the IRPM factor:
Field
Table
Field
Choice
External
Line of
Date &
Name
Name
Name
Source
Client
Country
Business
State
Company
Time
Deletion
Home
IRPM
ACE
US
HO
Sep. 1, 2000
Factor
12:00 a.m.
The Medical Payments Coverage rule set 36 is updated to include the IRPM factor in its calculation.
The ACE homeowner medical payments rule set 36 is saved with an updated effective date. The attributes of this rule set 36 are as follows:
NewBiz
Renewal
Rating
Company
Base
Sub-
Effective
Effective
Bureau
LOB
Country
State
Company
Code
—
Rule
Rule
Date
Date
ACE
HO
US
XX
1
XXX
—
MEDP
XX
20010901
20010901
The new entries in the rating rule set 36 are as follows:
Rating Rule Set
Table Name
Field Name
ACEHOUSXX1XXX—
Home
MedPayLimit
MEDPXX20010901.rul
ACEHOUSXX1XXX—
Home
MedPayPremium
MEDPXX20010901.rul
It now becomes necessary to identify all clients affected by the change to the countrywide ACE homeowner medical payment rule set 36. This is accomplished by scanning the rating rule set file 36 to identify all insurance company's ratebooks 34 where this rule set 36 is in use. These insurance companies can then be contacted to initiate the change process.
Changes to Company-Specific Rules or Guidelines
The steps involved with changing a company-specific rule is similar to that of a rule change provided by a standards organization, with one exception: there is no need to search the rating rule set file 36 to identify all insurance company ratebooks 34 affected by the change.
Changes to Choices (Picklist)
Assume that the Maine medical payments rule is updated, effective Sep. 1, 2001, to allow for a $20,000 limit of coverage. The premium associated with this limit is $17. Company ZZZ adopts this new limit, however, their premium charge is $16.
Database 12 is updated to include the new choice for Medical Payments Limit:
Field
Table
Field
Choice
External
Line of
Date &
Name
Name
Name
Source
Client
Country
Business
State
Company
Time
Deletion
Home
Medical
$20,000
ACE
US
HO
ME
Sep. 1, 2000
Paymts.
12:00 a.m.
Limit
A new rate table is required to capture the company-specific premiums related to the updated medical payments limits of coverage. The company ZZZ Maine Homeowners Medical Payments rate table is saved with an updated effective date. The file attributes are as follows:
Rating
Line of
Company
Rate Table
Effective
Bureau
Business
Country
State
Company
Code
—
Name
Date
ACE
HO
US
ME
2
ZZZ
—
MEDPAY
20010901
Company Decides to Deviate from Standards Organization Rule
Assume that the “MOD” Insurance Company chooses not to adopt the countrywide rule for medical payments, effective Sep. 1, 2001. Instead of using the RPM factor seen in the countrywide calculation, MOD multiplies the rate table lookup by a constant rate, 0.75, to derive the premium.
The invention database 12 is updated for the Maine factor:
The database 12 is updated to include the MOD med pay factor:
Field
Table
Field
Choice
External
Line of
Date &
Name
Name
Name
Source
Client
Country
Business
State
Company
Time
Deletion
Home
Medpay
?
ACE
US
HO
XX
MOD
Sep. 1, 2000
Factor
12:00 a.m.
The Medical Payments Coverage rule set 36 is updated to include the MOD medical pay factor in its calculation.
The ACE homeowner medical payments rule set 36 for MOD is saved with an updated effective date. The attributes of the rule set are as follows:
NewBiz
Renewal
Rating
Company
Base
Sub-
Effective
Effective
Bureau
LOB
Country
State
Company
Code
—
Rule
Rule
Date
Date
ACE
HO
US
XX
2
MOD
—
MEDP
XX
20010901
20010901
The new entries in the rating rule set 36 are as follows:
Rating Rule Set
Table Name
Field Name
ACEHOUSXX2MOD—
Home
ModMedPayFactor
MEDPXX20010901.rul
It now becomes necessary to identify all clients affected by the change to the countrywide ACE homeowner medical payment rule set 36. This is accomplished by scanning the rating rule set files 36 to identify all insurance companies ratebooks 34 where this rule set 36 is in use. These insurance companies can then be contacted to initiate the change process.
Company Decides to Move from Company Deviation to Embracing Standards Organization
After using the company specific medical payments rule for a year, MOD moves back to the original countrywide medical payments rule, effective Sep. 1, 2002.
The database 12 is updated to indicate that the MOD Med Pay factor is no longer in use, by flagging the field as a deletion:
Field
Table
Field
Choice
External
Line of
Date &
Name
Name
Name
Source
Client
Country
Business
State
Company
Time
Deletion
Home
Medpay
ACE
US
HO
XX
MOD
Sep. 1, 2002
X
Factor
12:00 a.m.
The ACE homeowner medical payments rule set 36 for MOD is also flagged as deleted:
Deleted Effective Aug. 31, 2002
NewBiz
Renewal
Rating
Company
Base
Sub-
Effective
Effective
Bureau
LOB
Country
State
Company
Code
—
Rule
Rule
Date
Date
ACE
HO
US
XX
2
MOD
—
MEDP
XX
20010901
20010901
A new homeowner ratebook 34 is created for MOD effective Sep. 1, 2002. The countrywide medical payments rule set 36 will replace the MOD company-specific medical payments rule set 36 in the new ratebook 34:
Customer
Ratebook
Rule Set
MOD
MODH020020901.rbk
ACEHOUSXX1XXX—
MEDPXX20010901.rul
All MOD homeowner policies with policy effective dates prior to Sep. 1, 2002 will access the old ratebook 34 containing company-specific medical payments rating algorithms; all policies effective on or after Sep. 1, 2002 will access the new ratebook 34 with countrywide medical payments rating algorithms.
The following example demonstrates how the domain management system 18 is utilized in the creation of new company program products 20.
Developing New Company Rate Books—First Company for a Given LOB/Rating Bureau
Recall that there is a hierarchy used for storing ratebooks 34, rule sets 36 and rate tables 38:
As the first rating product 40 is built for a line of business, each rule set 36 and rate table 38 represented in the rating manual is saved within the directory representing the appropriate hierarchical level (company, state or country) for the LOB/rating bureau. A ratebook 34 is saved at each hierarchical level, thus creating a countrywide, state and company ratebook 34 for the LOB/rating bureau. The state ratebook 34 contains all countrywide rules for which there is no state exception; the company ratebook 34 contains all company deviations from the state ratebook 34. In the above example, a United States, Maine and Company ZZZ ratebook 34 exists for Rating Bureau I/homeowners when rating development for Company ZZZ is complete.
Developing New Company Rate Books—Second Company for a Given LOB/Rating Bureau
The ratebooks 34, rule sets 36 and rate tables 38 previously saved at the countrywide and state levels all become available for subsequent product 20 development. Using the above example, assume that Company YYY (a subscriber to Rating Bureau 1) requests programmers to develop their Maine homeowner product 20. The Maine ratebook 34 previously created for Rating Bureau 1/homeowners will now be available as a starting point for development of the Company YYY product. Once the countrywide and state ratebooks 34 have been finalized for a LOB/rating bureau combination, only the company-specific deviations need to be developed for each subsequent customer (insurance company).
One of the toughest challenges met by Applicants' is how to stratify the product 20 content into base/exception layers in a way that provides the greatest long-term maintenance efficiency and is consistent across products.
The underlying premise of the base exception development approach is that insurance companies' products 20 are generally quite similar by line of business due to the influence of various regulatory bodies and rating bureaus that contribute to defining the product requirements.
The next most important premise is that the true cost of P&C product and rating solution management is not in the initial implementation but rather the long-term maintenance costs.
Applicants' base/exception strategy is based on a rating service making a single change that automatically updates multiple companies products 20. This lowers labor costs, reduces errors and shortens implementation timeframes.
Those companies that elect to use the tools of the present invention directly will benefit from the availability of the base product(s) 20 and the tool sets that minimize errors and streamline the process. They will lose the benefits of a single change being done for multiple companies lowering overall maintenance costs.
Inheritance:
The use of the inheritance capability within object-oriented programming is the technology that makes the base exception process work in the present invention system 18. It is important to understand the concept of inheritance as used in system design to understand how and why items can be placed at specific levels. The following is meant to provide sufficient knowledge to determine how inheritance works in the present invention environment.
The rules defining inheritance are:
Determining what is placed in each level is often a compromise. As a result, it is as much of an art as it is a science. However consistency across lines is important, and one can predetermine some rules for placing content at different levels and as a result define a standard way of building templates.
As a Primary Rule, the base exception architecture is to allow policy structures and rates to be maintained (not created) at the lowest possible cost and effort.
Present Invention Structures:
One extreme structure would be to make all products 20 a single level placing every line of business, state and company item in one level, but then the potential for sharing common characteristics—being all common to one level of inheritance they can't be passed on—is lost.
Example: A, B, C, D, E, 1, 2, 3, !, @, #
The other extreme is making everything in the system 18 a unique level. This makes for very flexible changes—every change is always reflected to everyone that inherits the item—but results in no logical grouping of items that can be understood and managed together. As a result little or no maintenance efficiency is gained.
Example:
Applicants discovered that there is a need to develop a logical way to stratify the system content into layers that organize like things together in layers that are maintained together. Thus, Applicants devise and utilize a structure between the above extremes as follows.
The most common structure for the invention products 20 is, by way of example:
Company
Concord Company
State
Maine
Bureau
ISO
Line of Business
Personal Auto
System Wide
XX
This basic structure can and will be varied to handle other policy structures such as homeowners/mobile home:
Another special view is the Package Policy where a layer exists between the systemwide layer and the Line of business layer.
Typically in each level are the following.
The system wide level contains characteristics/data that are common to all policy types across all lines of business. For example,
The LOB (product) level contains items that are typical to a line of business without regard to the state. Examples are:
The bureau level contains items that are defined by the bureau:
The State level contains items that are state specific for a particular LOB (line of business). For example, algorithms and rate table content that is specific to a state, are state level items.
The Company Level contains items requested by a specific insurance company. Often these items will be deletions (nullifications) of items specified in the more standard lower levels. Examples of company level items are:
In the preferred embodiment, the product 20 content is separated into a number of discrete steps that define specific sub-sets of processing. These discrete steps or subsets are stored in the DMS system 18 and include the below (a) through (j).
(a) Database Tables
The database tables define the structure of each data element used by the system 18. The database table elements and structure are the only items that are not and will not be in a base/exception structure. This is because a single database structure is used by all workbooks. The database table elements and structure are defined as a single level by Line of Business (LOB) and later combined by the system 18 into a single database schema.
Although all the data elements for a LOB are defined, only those fields used in a particular LOB, state and company that are referenced appear in the workbooks.
(b) Rate Table Structures
Rate Table Structures are the definition of rate tables 38 but do not contain any of the content. This allows the rate table 38 whose content varies by state and/or company to have its structure defined once at the lowest level and the contents later defined at a separate appropriate level such as state or company. Rate tables 38 that are only used at a specific state or company should be defined and populated at that level.
(c) Rate Table Content
Rate table content is the actual table entries and should be defined at the lowest common level. For example if a rate table 38 is common at the state level, it should be defined at the state level. If a company chooses to add, delete or modify specific information in a table 38, this should be overridden with an entry at the company level. This allows a single change to update all companies that have not overridden the table entry and for those insurance companies that have overridden the state defaults, the ability to recognize such and notify those companies that they have a conflict.
(d) Domain/Constraints Table Structures
Domain/Constraints Table Structures are the definition of various domain/constraint tables such as “pick lists” and automobile “makes/models”. Domain/Constraint table structures do not contain the table's actual contents. This allows a domain table that varies by state and/or company to be defined once at the lowest level and the contents defined at a separate, appropriate level such as state or company.
(e) Domain/Constraints Table Content
Domain/Constraints table content is the actual table entries and should be defined at the lowest common level. For example if a table is common to all auto policies, it should be defined in the LOB Level. If a company chooses to add, delete or modify specific makes or models, this should be overridden with an entry at the company level. This allows a single change to update all companies that have not overridden the table entry and for those customers that have overridden the state defaults, the ability to recognize such and notify those customers that they have a conflict.
(f) Rating Algorithms
In one embodiment, rating algorithms are entered using a tool set that does not allow the algorithms to be separated into various levels. Instead the algorithms must all be built into a single LOB/Company/Bureau/State level. However the ratebooks 34 should be created separating the formulas into the appropriate levels.
In another embodiment, an algorithm tool is utilized and it manages algorithms on a base exception level directly from the ratebook entries.
The rating formulas should be stored at the appropriate level based upon whether they are maintained on a countrywide, bureau, state basis or company specific basis.
(g) User Interface Structure and Content
The user interface structure and content will generally be defined at the line of business level and adjusted through the addition or deletion of fields at the bureau, state and company level. The design should always consider the potential future need to add information to the initial user interface (UI) design.
(h) User Interface Navigation
The user interface navigation sequences the order in which the UI is presented. The present invention standard navigation should be defined at the LOB level with the potential for customer overrides at the company level.
(i) User Interface Edits Using JavaScript
The user interface edits provides the capability to add edits at the field and page level beyond the standard system edits. These can be placed at any level from the systemwide level to the Company level. They should preferably be placed at the lowest level possible. For example, an edit that defines the relationship between the UM/UN coverage on an auto policy should be at the LOB level, an edit that defines whether or not something is numeric is at the systemwide level, and an edit that is unique to a specific company belongs at the Company level.
(j) Policy Forms
Policy Forms such as HO-3 are assigned at the LOB level.
While this invention has been particularly shown and described with references to preferred embodiments thereof, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the scope of the invention encompassed by the appended claims.
For example, when standards organization rules or guidelines, third party interfaces or unique company requirements change, embodiments of the present invention may provide:
In another example, the present invention system 18 enables management of multiple lines of business, multiple time ranges and multiple insurance companies in generating software products 20.
In addition, the above examples pertain to embodiments of the invention applied to the insurance industry. Other applications and use of the present invention in different industries are contemplated.
Although computer network architecture and configuration are illustrated and discussed in
Boodro, Charles J., Kaplan, Jonathan L., Grey, Christopher J., Stillman, John R., Tringali, Joseph
Patent | Priority | Assignee | Title |
10037204, | Apr 22 2014 | Silicon Valley Bank | Version control of applications |
10055792, | Nov 04 2009 | Michael, Price | System and method for automated risk management appraisal |
10540173, | Apr 22 2014 | Delphix Corporation | Version control of applications |
10600124, | Sep 24 2015 | HARTFORD FIRE INSURANCE COMPANY | Hybrid electronic record ordering system |
10810678, | Nov 04 2009 | Vitesco Technologies USA, LLC | System and method for automated risk management appraisal |
10904126, | Oct 25 2013 | Tata Consultancy Services Limited | Automated generation and dynamic update of rules |
7856617, | Apr 25 2006 | XEROX STATE & LOCAL SOLUTIONS, INC | Method, system and computer program product for creating software for processing an insurance claim |
8065168, | Apr 25 2006 | Conduent Business Services, LLC | Method, system and computer program code for automatically generating software for reformatting incoming data |
8453138, | Apr 13 2004 | RED BEND LTD | Method and apparatus for generating an update package |
8904349, | Sep 20 2009 | International Business Machines Corporation | Selectively applying changes to a version of a component |
9262786, | Jan 31 2013 | GUIDEWIRE SOFTWARE, INC | Configuring composite ratebooks |
9858623, | Jan 31 2013 | Guidewire Software, Inc. | Configuring composite ratebooks |
Patent | Priority | Assignee | Title |
4975840, | Jun 17 1988 | Swiss Reinsurance Company | Method and apparatus for evaluating a potentially insurable risk |
5706510, | Mar 15 1996 | HEWLETT-PACKARD DEVELOPMENT COMPANY, L P | Zymbolic history management system |
5950169, | May 19 1993 | CCC INFORMATION SERVICES INC | System and method for managing insurance claim processing |
6023578, | May 09 1997 | International Business Machines Corporation | Systems, methods and computer program products for generating an object oriented application for an object oriented environment |
6560620, | Aug 03 1999 | APLIX RESEARCH, INC | Hierarchical document comparison system and method |
7003482, | Dec 10 1999 | Computer Sciences Corporation | Middleware for business transactions |
20020002475, | |||
20030158760, | |||
20040103124, | |||
WO217197, |
Executed on | Assignor | Assignee | Conveyance | Frame | Reel | Doc |
Jun 09 2003 | ISO Strategic Solutions, Inc. | (assignment on the face of the patent) | / | |||
Jul 21 2003 | TRINGALI, JOSEPH | ISO STRATEGIC SOLUTIONS, INC | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 014391 | /0043 | |
Jul 22 2003 | BOODRO, CHARLES J | ISO STRATEGIC SOLUTIONS, INC | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 014391 | /0043 | |
Jul 23 2003 | GREY, CHRISTOPHER J | ISO STRATEGIC SOLUTIONS, INC | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 014391 | /0043 | |
Aug 12 2003 | KAPLAN, JONATHAN L | ISO STRATEGIC SOLUTIONS, INC | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 014391 | /0043 | |
Aug 12 2003 | STILLMAN, JOHN R | ISO STRATEGIC SOLUTIONS, INC | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 014391 | /0043 | |
Oct 28 2008 | ISO STRATEGIC SOLUTIONS, INC | AQS, INC | ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS | 021824 | /0674 | |
Mar 01 2013 | AQS, INC | Wells Fargo Bank, National Association | PATENT SECURITY AGREEMENT | 029940 | /0118 | |
Oct 31 2014 | Wells Fargo Bank, National Association, As Agent | AQS, INC | RELEASE BY SECURED PARTY SEE DOCUMENT FOR DETAILS | 034087 | /0671 | |
Oct 31 2014 | AQS, INC | TPG SPECIALTY LENDING, INC , AS COLLATERAL AGENT | SECURITY INTEREST SEE DOCUMENT FOR DETAILS | 034087 | /0828 | |
Jul 31 2019 | TPG SPECIALTY LENDING, INC | AQS, INC | RELEASE OF THE SECURITY INTEREST RECORDED AT REEL FRAME 034087 0828 | 049925 | /0038 | |
Jul 31 2019 | AQS, INC | BANK OF AMERICA, N A | SECOND LIEN SECURITY AGREEMENT | 049924 | /0548 | |
Jul 31 2019 | AQS, INC | JEFFERIES FINANCE LLC | FIRST LIEN SECURITY AGREEMENT | 049924 | /0538 | |
Sep 30 2020 | AQS, INC | AQS HOLDINGS, INC | MERGER SEE DOCUMENT FOR DETAILS | 057025 | /0684 | |
Sep 30 2020 | AQS HOLDINGS, INC | INSURITY, INC | MERGER SEE DOCUMENT FOR DETAILS | 057025 | /0851 | |
Sep 30 2020 | INSURITY, INC | INSURITY LLC | ENTITY CONVERSION | 057031 | /0750 | |
Nov 03 2021 | BANK OF AMERICA, N A | INSURITY LLC | RELEASE OF SECURITY INTEREST RECORDED AT R F 049924 0548 | 058524 | /0712 | |
Nov 03 2021 | JEFFRIES FINANCE LLC | CODEOBJECTS INC | RELEASE OF SECURITY INTEREST RECORDED AT 049924 0538 | 058304 | /0060 | |
Nov 03 2021 | JEFFRIES FINANCE LLC | INSURITY LLC | RELEASE OF SECURITY INTEREST RECORDED AT 049924 0538 | 058304 | /0060 | |
Nov 03 2021 | CODEOBJECTS INC | ARES CAPITAL CORPORATION, AS COLLATERAL AGENT | SECURITY INTEREST SEE DOCUMENT FOR DETAILS | 058004 | /0980 | |
Nov 03 2021 | INSURITY LLC | ARES CAPITAL CORPORATION, AS COLLATERAL AGENT | SECURITY INTEREST SEE DOCUMENT FOR DETAILS | 058004 | /0980 | |
Nov 03 2021 | BANK OF AMERICA, N A | CODEOBJECTS INC | RELEASE OF SECURITY INTEREST RECORDED AT R F 049924 0548 | 058524 | /0712 |
Date | Maintenance Fee Events |
Feb 03 2009 | ASPN: Payor Number Assigned. |
Jul 15 2011 | M1551: Payment of Maintenance Fee, 4th Year, Large Entity. |
Sep 04 2015 | REM: Maintenance Fee Reminder Mailed. |
Jan 21 2016 | M1552: Payment of Maintenance Fee, 8th Year, Large Entity. |
Jan 21 2016 | M1555: 7.5 yr surcharge - late pmt w/in 6 mo, Large Entity. |
Jul 18 2019 | M1553: Payment of Maintenance Fee, 12th Year, Large Entity. |
Date | Maintenance Schedule |
Jan 22 2011 | 4 years fee payment window open |
Jul 22 2011 | 6 months grace period start (w surcharge) |
Jan 22 2012 | patent expiry (for year 4) |
Jan 22 2014 | 2 years to revive unintentionally abandoned end. (for year 4) |
Jan 22 2015 | 8 years fee payment window open |
Jul 22 2015 | 6 months grace period start (w surcharge) |
Jan 22 2016 | patent expiry (for year 8) |
Jan 22 2018 | 2 years to revive unintentionally abandoned end. (for year 8) |
Jan 22 2019 | 12 years fee payment window open |
Jul 22 2019 | 6 months grace period start (w surcharge) |
Jan 22 2020 | patent expiry (for year 12) |
Jan 22 2022 | 2 years to revive unintentionally abandoned end. (for year 12) |