JP2012083837A - Insurance merchandise retrieval system - Google Patents

Insurance merchandise retrieval system Download PDF

Info

Publication number
JP2012083837A
JP2012083837A JP2010227473A JP2010227473A JP2012083837A JP 2012083837 A JP2012083837 A JP 2012083837A JP 2010227473 A JP2010227473 A JP 2010227473A JP 2010227473 A JP2010227473 A JP 2010227473A JP 2012083837 A JP2012083837 A JP 2012083837A
Authority
JP
Japan
Prior art keywords
insurance
amount
insured
database
product
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
JP2010227473A
Other languages
Japanese (ja)
Other versions
JP5595860B2 (en
Inventor
Nobuhiro Katsumoto
伸弘 勝本
Hidemi Baba
英美 馬場
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
IRRC CORP
Original Assignee
IRRC CORP
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by IRRC CORP filed Critical IRRC CORP
Priority to JP2010227473A priority Critical patent/JP5595860B2/en
Publication of JP2012083837A publication Critical patent/JP2012083837A/en
Application granted granted Critical
Publication of JP5595860B2 publication Critical patent/JP5595860B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

PROBLEM TO BE SOLVED: To provide an insurance merchandise retrieval system for incorporated enterprise capable of easily finding out insurance merchandise by targeting a plurality of insured persons under certain conditions.SOLUTION: This insurance merchandise retrieval system is configured to, by targeting a plurality of insured persons, find out the insurance merchandise of (1) the insurance fee and cancellation refund of each insured person who can join by designating his or her desired insurance type, contract content, and insurance sum, (2) the insurance sum, cancellation refund and insurance fee of each insured person who can join by designating his or her desired insurance type, contract content, and the total cancellation refund of whole insured persons, (3) the insurance sum, insurance fee and cancellation refund of each insured person who can join by designating his or her desired insurance type, contract content, and the total annual insurance fee of the whole insured persons, and (4) the insurance fee and cancellation refund of each insured person when the maximum insurance sum can be obtained among the whole insured persons by designating his or her desired insurance type and contract content.

Description

本発明は、複数の被保険者を擁する、例えば法人が加入するための保険商品検索システムに関するものである。   The present invention relates to an insurance product search system having a plurality of insured persons, for example, for a corporation to join.

法人企業においては、役員や社員を被保険者としての福利厚生や節税対策のため、生命保険等の保険商品を探し出すニーズがある。
このような場合において、多くの保険会社とその保険商品の中から、法人企業が希望する条件に合致する保険商品を探し出すためには、従来、保険商品別に契約対象の役員や社員毎の保険料や解約返戻金の算出を行っていた。
In corporations, there is a need to search for insurance products such as life insurance in order to provide benefits and tax savings for officers and employees as insured persons.
In such a case, in order to find out insurance products that meet the conditions desired by corporations from many insurance companies and their insurance products, the insurance premiums for each officer or employee covered by the contract by conventional insurance products And cancellation refunds.

すなわち、法人企業が希望する保険商品の条件としては下記のようなものがあった。
(1)全ての保険契約が、保険金額500万円で加入できる保険商品を探したい。
(2)全ての保険契約の解約返戻金の合計が、10年後に1000万円以上となる保険商品を探したい。
(3)全ての保険契約の年間支払保険料の合計が、200万円以下となる保険商品を探したい。
(4)全ての保険契約が、その商品の最大(上限)保険金額で入れる保険商品を探したい。
In other words, the conditions for insurance products desired by corporations were as follows.
(1) I want to find insurance products that all insurance contracts can cover with an insurance amount of 5 million yen.
(2) I would like to find insurance products that have a total of surrender values for all insurance contracts of 10 million yen or more in 10 years.
(3) I want to search for insurance products whose sum of annual premiums paid for all insurance contracts is 2 million yen or less.
(4) I want to search for insurance products that all insurance contracts can cover with the maximum (upper limit) insurance amount of the product.

但し、その他の条件については全ての保険契約で同一とする。
なお、参考文献として下記のものがある。
However, other conditions are the same for all insurance contracts.
Reference documents include the following.

特開2001−256350号公報JP 2001-256350 A 特開2002−41802号公報JP 2002-41802 A 特開2002−63362号公報JP 2002-63362 A 特開2003−337888号公報JP 2003-337888 A

上記のような希望条件の場合、例えば、保険商品が10商品で社員が50人(性別・年齢の組み合わせが全て異なると想定)とすると、全部で50回分の算出作業を行う必要が有る。
更に、上記(2)のような条件では、全保険契約で同一条件となる保険金額を増加させて条件がクリアされるまで算出を行う必要がある為、さらに多くの作業が必要となり膨大な時間と労力を費やしていた。
In the case of the desired conditions as described above, for example, if there are 10 insurance products and 50 employees (assuming all the combinations of gender and age are different), it is necessary to perform calculation operations for 50 times in total.
Furthermore, under the condition (2) above, since it is necessary to calculate until the condition is cleared by increasing the insurance amount that is the same condition in all insurance contracts, more work is required and enormous time is required. And spent the effort.

そこで、本発明は、或る条件の下で複数の被保険者を対象に保険商品を簡単に探し出せる法人企業向けの保険商品検索システムを提供することを課題とする。   Therefore, an object of the present invention is to provide an insurance product search system for corporate corporations that can easily find insurance products for a plurality of insured persons under certain conditions.

[1]上記の課題を解決するため、本発明の保険商品検索システムは、保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別且つ複数の被保険者属性別に加入可能な保険金額を格納した第2のデータベースと、該保険商品別、該契約内容別、該保険金額別且つ該被保険者属性別の基礎保険料を格納した第3のデータベースと、該保険商品別、該契約内容別、該保険金額別及び該被保険者属性別の基礎解約返戻金を経過年毎に格納した第4のデータベースとを有する記録装置と、指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、検索対象となる複数の被保険者の内の少なくとも一人が、指定した契約内容、保険金額及び被保険者属性に合致する保険商品を該第2のデータベースから抽出し、該抽出された保険商品において該合致した被保険者の属性に対する保険料を該第3のデータベース中の基礎保険料から計算し、該抽出された保険商品において該合致した被保険者の属性に対する解約返戻金を該第4のデータベース中の基礎解約返戻金から経過年毎に計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに出力する演算装置と、該演算装置の出力を画面表示する表示装置とを備えたことを特徴とする。   [1] In order to solve the above-described problem, an insurance product search system according to the present invention includes a first database storing insurance products for each insurance type, a plurality of insured attributes for each insurance product, for each contract content. A second database storing separately insured insurance amounts; a third database storing basic insurance premiums by insurance product, by contract content, by insurance amount and by insured attribute; and Corresponding to a specified insurance type, and a recording device having a fourth database storing basic surrender values for each insurance product, each contract content, each insurance amount, and each insured's attribute An insurance product is extracted from the first database, and among the extracted insurance products, at least one of a plurality of insured persons to be searched matches specified contract contents, insurance amount and insured person attributes. The second insurance product A premium for the attribute of the matched insured in the extracted insurance product is calculated from the basic premium in the third database and the matched insured in the extracted insurance product The surrender value for the attributes of the insurer is calculated for each elapsed year from the basic surrender value in the fourth database, and is output together with the corresponding insurance product, the insurance amount, the insured attributes, and the contract contents. An arithmetic device and a display device that displays an output of the arithmetic device on a screen are provided.

すなわち、本発明では、法人企業等における複数の被保険者(役員、社員)が加入できる保険商品を検索する場合、保険種類、契約内容及び保険金額を指定することにより、その内の少なくとも一人の被保険者の属性が合致する保険商品が抽出されれば、その抽出した保険商品において該当した被保険者の属性に対する保険料と解約返戻金を計算し、上記の対応する保険商品、保険金額、被保険者属性及び契約内容とともに画面表示するようにしている。   That is, in the present invention, when searching for an insurance product that can be joined by a plurality of insured persons (officers, employees) in a corporation, etc., by specifying the insurance type, contract details and insurance amount, at least one of them can be specified. If insurance products that match the attributes of the insured are extracted, the insurance premium and surrender value for the corresponding attributes of the insured in the extracted insurance products are calculated, and the corresponding insurance products, insurance amount, The screen is displayed together with the insured person attributes and contract details.

[2]ここで、上記[1]において、該第2のデータベースの保険金額が、最小保険金額と最大保険金額とで構成され、該演算装置は、該指定した保険金額に一致するか否かを被保険者属性別に該最小保険金額と最大保険金額との範囲に入るか否かで判定することができる。   [2] Here, in [1] above, the insurance amount of the second database is composed of a minimum insurance amount and a maximum insurance amount, and the arithmetic unit determines whether or not it matches the specified insurance amount. Can be determined for each insured attribute by whether or not it falls within the range of the minimum insurance amount and the maximum insurance amount.

[3]また本発明は、保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別、保険金額別及び該被保険者属性別の基礎解約返戻金を経過年毎に格納した第2のデータベースと、該保険商品別、該契約内容別、該保険金額別且つ該複数の被保険者属性別の基礎保険料を格納した第3のデータベースとを有する記録装置と、指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、指定した契約内容で検索対象となる複数の被保険者の属性に対する全ての所定経過年後の解約返戻金の合計が指定金額以上となる保険商品の保険金額を該第2のデータベースから求め、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の解約返戻金を該第2のデータベース中の該全被保険者の属性に対する基礎解約返戻金から計算し、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の保険料を該第3のデータベース中の該全被保険者の属性に対する基礎保険料から計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに出力する演算装置と、該演算装置の出力を画面表示する表示装置とを備えたことを特徴とする保険商品検索システムを提供する。   [3] The present invention also includes a first database storing insurance products for each insurance type, and basic surrender value refunds for each insurance product, each contract content, each insurance amount, and each insured attribute. A recording apparatus comprising: a second database stored for each; and a third database storing basic insurance premiums for each insurance product, each contract content, each insurance amount, and each of the plurality of insured attributes The insurance product corresponding to the designated insurance type is extracted from the first database, and all the predetermined elapsed years for the attributes of a plurality of insured persons to be searched with the designated contract contents among the extracted insurance products. The insurance amount of the insurance product for which the sum of the subsequent cash surrender value is equal to or more than the specified amount is obtained from the second database, and all the insured persons to be searched under the same conditions as the conditions for obtaining the insurance amount Cancel the refund amount to the second database Calculated from the basic surrender value for the attributes of all the insured persons, and the insurance premiums of all the insured persons to be searched under the same conditions as the conditions for obtaining the insurance amount are stored in the third database. Calculation based on the basic premiums for the attributes of all the insured persons, the corresponding insurance product, the insurance amount, the insured person attributes and the contract contents to be output together with the arithmetic device, and the output of the arithmetic device is displayed on the screen There is provided an insurance product search system characterized by comprising a display device.

すなわち、指定した保険種類に対応する保険商品の内、指定した契約内容で検索対象となる複数の被保険者の属性に対する全ての所定経過年後の解約返戻金の合計が指定金額以上となる保険商品の保険金額を求める。そして、この保険金額を求めたときの条件と同一条件で該検索対象の全被保険者の解約返戻金をその属性に対する基礎解約返戻金から計算し、また該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の保険料を全被保険者の属性に対する基礎保険料から計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに画面表示することができる。   In other words, the insurance that corresponds to the specified insurance type, the sum of the surrender value after the specified elapsed years for the attributes of multiple insured persons to be searched with the specified contract details is the specified amount or more Find the insurance amount for a product. Then, the surrender value of all insured persons subject to search is calculated from the basic surrender value for the attribute under the same condition as the condition for obtaining the insurance amount, and the condition for obtaining the insurance amount The insurance premiums of all the insured persons to be searched under the same conditions are calculated from the basic insurance premiums for the attributes of all the insured persons, and the corresponding insurance product, the insurance amount, the insured person attributes, and the contract contents And can be displayed on the screen.

[4]また、上記[3]において、第2のデータベースの保険金額が最小保険金額と最大保険金額とで構成されており、該演算装置は、該解約返戻金の合計が該指定金額以上となる保険商品の保険金額を、各被保険者属性について該最小保険金額から最大保険金額の範囲で一定金額ずつ最大保険金額まで増加させることにより求めることができる。   [4] Also, in [3] above, the insurance amount of the second database is composed of a minimum insurance amount and a maximum insurance amount, and the computing device determines that the sum of the surrender value is not less than the specified amount. The insurance amount of the insurance product can be obtained by increasing the insurance amount for each insured attribute by a certain amount within the range from the minimum insurance amount to the maximum insurance amount.

[5]さらに本発明は、保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別、保険金額別且つ複数の被保険者属性別の基礎保険料を格納した第2のデータベースと、該保険商品別、該契約内容別、該保険金額別且つ該被保険者属性別の基礎解約返戻金を経過年毎に格納した第3のデータベースとを有する記録装置と、指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、指定した契約内容で検索対象となる複数の被保険者の属性に対する年間保険料の合計が指定金額以下となる保険商品の保険金額を該第2のデータベースから求め、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の保険料を該第2のデータベース中の該全被保険者の属性に対する基礎保険料から計算し、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の解約返戻金を該第3のデータベース中の該全被保険者の属性に対する基礎解約返戻金から計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに出力する演算装置と、該演算装置の出力を画面表示する表示装置とを備えたことを特徴とする保険商品検索システムを提供することができる。   [5] Further, the present invention stores a first database storing insurance products by insurance type, and basic insurance premiums by insurance products, contract contents, insurance amounts, and a plurality of insured attributes. A recording device having a second database, and a third database storing basic surrender values for each insurance product, each contract content, each insurance amount, and each insured attribute, for each elapsed year; The insurance product corresponding to the designated insurance type is extracted from the first database, and the sum of the annual premiums for the attributes of a plurality of insured persons to be searched with the designated contract content is obtained from the extracted insurance product. The insurance amount of an insurance product that is equal to or less than the specified amount is obtained from the second database, and the insurance premiums of all the insured persons to be searched under the same conditions as the conditions for obtaining the insurance amount are obtained from the second database. In the attributes of all the insured The surrender value of all insured persons subject to the search under the same conditions as when the insurance amount was calculated is calculated from the basic insurance premiums to be calculated for the attributes of all insured persons in the third database. A calculation device that calculates from the basic surrender value and outputs the insurance product, the insurance amount, the insured person attribute, and the contract contents corresponding to the insurance product, and a display device that displays the output of the calculation device on a screen An insurance product search system characterized by the above can be provided.

すなわち、指定した保険種類に対応する保険商品の内、指定した契約内容で検索対象となる複数の被保険者の属性に対する年間保険料の合計が指定金額以下となる保険商品の保険金額を求め、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の保険料を全被保険者の属性に対する基礎保険料から計算し、さらに該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の解約返戻金を該全被保険者の属性に対する基礎解約返戻金から計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに画面表示することができる。   In other words, out of the insurance products corresponding to the specified insurance type, the insurance amount of the insurance product for which the sum of the annual premiums for the attributes of the insured persons to be searched with the specified contract content is equal to or less than the specified amount is obtained. Conditions for calculating the insurance premiums of all the insured persons to be searched under the same conditions as the conditions for obtaining the insurance amounts from the basic insurance premiums for the attributes of all insured persons, and further obtaining the insurance amounts The surrender value of all the insured persons to be searched under the same condition is calculated from the basic surrender value for the attributes of all the insured persons, and the corresponding insurance product, the insurance amount, and the insured person attributes are calculated. And the contents of the contract can be displayed on the screen.

[6]ここで、上記[5]において、該第2のデータベースの保険金額が最小保険金額と最大保険金額とで構成されており、該演算装置は、該年間保険料の合計が該指定金額以下となる保険商品の保険金額を、各被保険者属性について該最大保険金額から一定金額ずつ最小保険金額まで減少させることにより求めることができる。   [6] Here, in [5] above, the insurance amount of the second database is composed of a minimum insurance amount and a maximum insurance amount, and the computing device is configured such that the sum of the annual insurance premiums is the specified amount. The insurance amount of the following insurance product can be obtained by decreasing the maximum insurance amount from the maximum insurance amount by a certain amount to the minimum insurance amount for each insured attribute.

[7]さらに本発明は、保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別且つ複数の被保険者属性別に加入可能な最小及び最大保険金額を格納した第2のデータベースと、該保険商品別、該契約内容別且つ該複数の被保険者属性別の基礎保険料を格納した第3のデータベースと、該保険商品別、該契約内容別且つ該被保険者属性別の基礎解約返戻金を経過年毎に格納した第4のデータベースとを有する記録装置と、指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、指定した契約内容で検索対象となる複数の被保険者の各々について加入可能な最大保険金額の中で最も大きい保険金額を該第1及び第2のデータベースから抽出し、該抽出された保険金額の条件と同一条件で加入可能な被保険者についてのみ保険料を該第3のデータベース中の基礎保険料から計算し、該抽出された保険金額と同一条件で加入可能な被保険者についてのみ解約返戻金を該第4のデータベース中の基礎解約返戻金から計算して、対応する該保険商品、該保険金額、該検索対象の被保険者属性及び該契約内容とともに出力する演算装置と、該演算装置の出力を画面表示する表示装置とを備えたことを特徴とする保険商品検索システムを提供することができる。   [7] Further, the present invention stores a first database storing insurance products by insurance type, and minimum and maximum insurance amounts that can be enrolled by the insurance products, contract contents, and a plurality of insured attributes. A second database, a third database storing basic premiums for each insurance product, each contract content, and each of the plurality of insured attributes, and each insurance product, each contract content, and each insured An insurance product corresponding to the designated insurance type is extracted from the first database and a recording device having a fourth database that stores basic surrender value refunds for each person attribute for each elapsed year, and the extracted insurance product The largest insurance amount out of the maximum insurance amount that can be enrolled for each of a plurality of insured persons to be searched with the specified contract content is extracted from the first and second databases, and the extracted Insurance amount conditions Only for insured persons who can join under the same conditions, the premium is calculated from the basic premiums in the third database, and the surrender value is refunded only for insured persons who can join under the same conditions as the extracted insurance amount. An arithmetic unit that calculates the basic insurance surrender value in the fourth database and outputs the insurance product, the insurance amount, the insured person attribute to be searched, and the contract details, and the output of the arithmetic unit It is possible to provide an insurance product search system characterized by comprising a display device for displaying

すなわち、指定した保険種類に対応する保険商品の内、指定した契約内容で検索対象となる複数の被保険者の各々について加入可能な最大保険金額の中で最も大きい保険金額を抽出し、該抽出された保険金額の条件と同一条件で加入可能な被保険者についてのみ保険料を基礎保険料から計算し、該抽出された保険金額と同一条件で加入可能な被保険者についてのみ解約返戻金を基礎解約返戻金から計算して、対応する該保険商品、該保険金額、該検索対象の被保険者属性及び該契約内容とともに画面表示することができる。   That is, out of the insurance products corresponding to the specified insurance type, the largest insurance amount is extracted from the maximum insurance amount that can be enrolled for each of a plurality of insured persons to be searched with the specified contract contents, and the extraction is performed. The premium is calculated from the basic premium only for the insured who can join under the same conditions as the insurance amount, and the surrender value is refunded only for the insured who can join under the same conditions as the extracted insurance amount. It can be calculated from the basic surrender value and displayed on the screen together with the corresponding insurance product, the insurance amount, the insured person attribute to be searched, and the contract contents.

[8]ここで、上記[1]、[3]、[5]又は[7]において、該被保険者の属性は、例えば性別及び年齢である。   [8] Here, in the above [1], [3], [5] or [7], the attributes of the insured person are, for example, sex and age.

[9]また、上記[1]、[3]、[5]又は[7]において、該基礎保険料及び基礎解約返戻金が、例えばそれぞれ、基準保険料及び基準解約返戻金とこれに加算される特約固定保険料及び特約固定解約返戻金とで構成され、該計算される保険料及び解約返戻金が、該基準保険料及び基準解約返戻金を、該保険金額とこの保険金額を確定する範囲の上限を示す基準保険金額との比で比例配分し、これに該特約固定保険料及び特約固定解約返戻金をそれぞれ加算した値である。   [9] Also, in the above [1], [3], [5] or [7], the basic premium and basic surrender value are added to the standard premium and standard surrender value, for example, respectively. The premiums and surrender refunds are calculated from the standard premiums and surrender refunds, and the insurance amount and the extent to which the insurance amount is determined. It is a value obtained by proportionally allocating in proportion to the standard insurance amount indicating the upper limit of the amount of insurance, and adding the special contract fixed insurance premium and the special contract fixed surrender value respectively.

このように、本発明による保険商品検索システムでは、複数の被保険者を対象に、(1)希望する保険種類・契約内容・保険金額を指定して加入できる各被保険者の保険料と解約返戻金、(2)希望する保険種類・契約内容・全被保険者の合計解約返戻金を指定して加入可能な各被保険者の保険金額、解約返戻金及び保険料、(3)希望する保険種類・契約内容・全被保険者の合計年間保険料を指定して加入可能な各被保険者の保険金額、保険料及び解約返戻金、(4)希望する保険種類・契約内容を指定して全被保険者の内の最大保険金額が得られる場合の各被保険者の保険料と解約返戻金、の保険商品を簡単に探し出せる効果がある。   As described above, in the insurance product search system according to the present invention, for a plurality of insured persons, (1) the insurance premiums and cancellations of each insured person that can be enrolled by specifying the desired insurance type, contract details, and insurance amount Refund amount, (2) Desired insurance type, contract details, total insured surrender value, insurance amount, surrender value and premium of each insured person that can be enrolled, (3) Desired Insurance type / contract details / Insured amount, insurance premium and surrender value of each insured person who can enroll by specifying the total annual premium for all insured, (4) Specify desired insurance type / contract details Thus, there is an effect that it is possible to easily find an insurance product for each insured person's premium and surrender value when the maximum insured amount is obtained among all insured persons.

本発明に係る保険商品検索システムの構成を示すブロック図である。It is a block diagram which shows the structure of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムにおける記録装置に記憶される法人関連のマスタテーブルを示す図である。It is a figure which shows the corporation related master table memorize | stored in the recording device in the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムにおける記録装置に記憶される保険商品関連のマスタテーブルを示す図である。It is a figure which shows the master table relevant to insurance products memorize | stored in the recording device in the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例1における演算装置のアルゴリズムを示すフローチャート図である。It is a flowchart figure which shows the algorithm of the arithmetic unit in Example 1 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例1における入出力装置で表示される画面を示す図である。It is a figure which shows the screen displayed with the input / output device in Example 1 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例1における演算装置の演算過程で生成されるレコードを示す図である。It is a figure which shows the record produced | generated in the calculation process of the calculating device in Example 1 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例2における演算装置のアルゴリズムを示すフローチャート図である。It is a flowchart figure which shows the algorithm of the arithmetic unit in Example 2 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例2における入出力装置で表示される画面を示す図である。It is a figure which shows the screen displayed with the input / output device in Example 2 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例2における演算装置の演算過程で生成されるレコードを示す図である。It is a figure which shows the record produced | generated in the calculation process of the arithmetic unit in Example 2 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例3における演算装置のアルゴリズムを示すフローチャート図である。It is a flowchart figure which shows the algorithm of the arithmetic unit in Example 3 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例3における入出力装置で表示される画面を示す図である。It is a figure which shows the screen displayed with the input / output device in Example 3 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例3における演算装置の演算過程で生成されるレコードを示す図である。It is a figure which shows the record produced | generated in the calculation process of the calculating device in Example 3 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例4における演算装置のアルゴリズムを示すフローチャート図である。It is a flowchart figure which shows the algorithm of the arithmetic unit in Example 4 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例4における入出力装置で表示される画面を示す図である。It is a figure which shows the screen displayed with the input / output device in Example 4 of the insurance product search system which concerns on this invention. 本発明に係る保険商品検索システムの実施例4における演算装置の演算過程で生成されるレコードを示す図である。It is a figure which shows the record produced | generated in the calculation process of the calculating device in Example 4 of the insurance product search system which concerns on this invention.

以下、本発明に係る保険商品検索システムを、図を参照して詳細に説明する。
図1は、本発明の保険商品検索システムの実施例を概略的に示したもので、表示装置100と入力装置200とデータ処理装置300と記録装置400とで構成される。
この内、データ処理装置300は、後述する検索方法で「保険金額」を指定したときのデータ処理を行う保険商品検索処理部301と、「解約返戻金」を指定したときのデータ処理を行う保険商品検索処理部302と、「合計保険料」を指定したときのデータ処理を行う保険商品検索処理部303と、「最大保険金額」を指定したときのデータ処理を行う保険商品検索処理部304とを備えている。
Hereinafter, an insurance product search system according to the present invention will be described in detail with reference to the drawings.
FIG. 1 schematically shows an embodiment of an insurance product search system according to the present invention, which includes a display device 100, an input device 200, a data processing device 300, and a recording device 400.
Among these, the data processing device 300 includes an insurance product search processing unit 301 that performs data processing when “insurance amount” is designated by a search method that will be described later, and an insurance that performs data processing when “cancellation refund” is designated. A product search processing unit 302, an insurance product search processing unit 303 that performs data processing when "total insurance premium" is specified, and an insurance product search processing unit 304 that performs data processing when "maximum insurance amount" is specified; It has.

また、記録装置400は、法人情報部500と保険商品情報部600とを含み、法人情報部500は、図2(1)及び(2)にそれぞれ示す法人マスタテーブル501と社員マスタテーブル502とを含み、保険商品情報部600は、図3(1)〜(4)にそれぞれ示す保険種類別保険商品マスタテーブル601と最小最大保険金額マスタテーブル602と保険金額別保険料マスタテーブル603と保険金額別解約返戻金マスタテーブル604とを含んでいる。なお、これらのマスタテーブルは、表示装置100及び入力装置200により予めオペレータが作成したものである。   The recording device 400 includes a corporate information unit 500 and an insurance product information unit 600.The corporate information unit 500 includes a corporate master table 501 and an employee master table 502 shown in FIGS. 2 (1) and (2), respectively. The insurance product information section 600 includes an insurance product master table 601, a minimum maximum insurance amount master table 602, an insurance premium master table 603 by insurance amount, and an insurance amount by insurance type shown in FIGS. 3 (1) to 3 (4). A cancellation refund master table 604 is included. Note that these master tables are created in advance by the operator using the display device 100 and the input device 200.

ここで、マスタテーブル601は保険種類と保険会社と保険商品とを対応付けたものである。マスタテーブル602は保険会社と保険商品と契約内容(ハッチングで示す保険期間、払込期間、払方)と診査区分と被保険者の属性(年齢・性別)別に最小・最大保険金額とを対応付けたものであるが、最小・最大保険金額はレコード内容(容量)を簡素化するために範囲化したもので、この範囲を一定金額(例えば1000円)で分割した保険金額を予め設定してもよい。マスタテーブル603は保険会社と保険商品と契約内容と払込経路とマスタテーブル602から得た最小・最大保険金額と基準保険金額(ここでは最大保険金額に相当)と保険金額増分値と属性(年齢・性別)別基準保険料・特約固定保険料とを対応付けたものである。なお、ここでの最小・最大保険金額と基準保険金額も、この範囲内で予め一定金額毎にレコードを用意しておいてもよい。また、基準保険料と特約固定保険料とは加算されて基礎保険料を構成するものである。マスタテーブル604はマスタテーブル603と対応しており、基準保険料が基準解約返戻金となり、特約固定保険料が特約固定解約返戻金となる点が異なっている。但し、解約返戻金の場合には経過年数が必須であるため、マスタテーブル604では、経過年数毎に分かれている。   Here, the master table 601 associates insurance types, insurance companies, and insurance products. Master table 602 correlates insurance companies, insurance products, contract details (insurance period, payment period, payment method indicated by hatching), examination category, and minimum and maximum insurance amounts according to insured attributes (age / gender) However, the minimum and maximum insurance amounts are ranged in order to simplify the record contents (capacity), and an insurance amount obtained by dividing this range by a certain amount (eg 1000 yen) may be set in advance. . The master table 603 is an insurance company, insurance products, contract contents, payment route, minimum / maximum insurance amount obtained from the master table 602, standard insurance amount (equivalent to the maximum insurance amount in this case), insurance amount increment value and attributes (age / Gender) Standard premiums and special contract fixed premiums are associated with each other. In addition, the minimum / maximum insurance amount and the reference insurance amount here may be prepared for each predetermined amount within this range. The basic premium and the special fixed premium are added to form the basic premium. The master table 604 corresponds to the master table 603, and is different in that the standard premium becomes a standard surrender refund and the special contract fixed insurance premium becomes a special contract surrender refund. However, in the case of a cancellation refund, the elapsed years are essential, so the master table 604 is divided for each elapsed year.

以下、各実施例について説明する。なお、実施例1は「保険金額」を指定したときの保険商品検索処理部301によるデータ処理を行うもので、実施例2は「解約返戻金」を指定したときの保険商品検索処理部302によるデータ処理を行うもの、実施例3は「合計保険料」を指定したときの保険商品検索処理部303によるデータ処理を行うもの、そして実施例4は「最大保険金額」を指定したときの保険商品検索処理部304によるデータ処理を行うものである。   Each example will be described below. The first embodiment performs data processing by the insurance product search processing unit 301 when “insurance amount” is designated, and the second example is performed by the insurance product search processing unit 302 when “cancellation refund” is designated. Example 3 performs data processing, Example 3 performs data processing by the insurance product search processing unit 303 when “total insurance premium” is specified, and Example 4 indicates insurance products when “maximum insurance amount” is specified Data processing by the search processing unit 304 is performed.

なお、各実施例において同一箇所・部分には同一符号を付し、実施例1−4間で類似する箇所・部分には、各数字に符号a, b, c, dを付して示す。   In each embodiment, the same reference numerals are given to the same portions / parts, and the similar portions / parts in the first to fourth embodiments are indicated by reference numerals a, b, c, d.

[保険金額を指定する場合]
図4のフローチャートは、実施例1として、データ処理装置300の保険商品検索処理部301によるデータ処理を示しており、以下、各ステップに沿ってその処理動作を説明する。
[When insurance amount is specified]
The flowchart of FIG. 4 shows data processing by the insurance product search processing unit 301 of the data processing device 300 as the first embodiment, and the processing operation will be described along each step below.

*ステップS1:
まず、記録装置400の法人情報部500における法人マスタテーブル501(図2(1)参照)及び社員マスタテーブル502(同図(2)参照)より、表示装置100において作成された図5(1)に示す画面Aのように、保険商品を検索する対象となる被保険者社員を複数人(図示の例では5人)選択する。このステップは各実施例に共通である。
* Step S1:
First, the corporate master table 501 (see FIG. 2 (1)) and the employee master table 502 (see (2) in FIG. 2) in the corporate information unit 500 of the recording device 400, FIG. 5 (1) created in the display device 100. As shown in the screen A shown in FIG. 5, a plurality of insured employees (5 in the example shown) to be searched for insurance products are selected. This step is common to each embodiment.

*ステップS2a:
次に、同図5(2)に示す画面B1により、検索する保険商品の種類や契約内容(保険期間、払込期間、払方、保険金額等)、並びに検索方法を指定する。この実施例では、全ての社員(5人)について、保険金額が10千円の「がん保険」商品を検索するように指定を行う。
* Step S2a:
Next, on the screen B1 shown in FIG. 5 (2), the type of insurance product to be searched, contract details (insurance period, payment period, payment method, insurance amount, etc.) and the search method are designated. In this embodiment, all employees (5) are designated to search for “cancer insurance” products with an insurance amount of 10,000 yen.

*ステップS3:
保険種類別保険商品マスタテーブル601より、画面B1に示す検索条件で指定された保険種類「がん保険商品」に該当するレコード601a(図6(1)参照)を抽出する。このレコード601aの例では、2つの保険商品X1,Y1が抽出されている。このステップは各実施例に共通である。
* Step S3:
A record 601a (see FIG. 6 (1)) corresponding to the insurance type “cancer insurance product” specified by the search condition shown in the screen B1 is extracted from the insurance product-specific insurance product master table 601. In the example of the record 601a, two insurance products X1 and Y1 are extracted. This step is common to each embodiment.

*ステップS4:
ループ処理を示し、対象となった保険商品(X1,Y1)毎に以下のステップS13までの処理を実行する。ここでは、保険商品Y1を先に処理するものとして説明する。このステップは各実施例に共通である。
* Step S4:
A loop process is shown, and the process up to step S13 below is executed for each insurance product (X1, Y1) as a target. Here, description will be made assuming that the insurance product Y1 is processed first. This step is common to each embodiment.

*ステップS5a:
最小最大保険金額マスタテーブル602より、例えば保険商品Y1の場合には、画面B1に示す検索条件で指定された契約内容(保険期間、払込期間、払方)に該当するレコード602a(同図6(2)参照)を抽出する。このレコード602aの例では、常に1件のみが抽出されるようにマスタテーブルが作成されている。なお、診査区分の条件は“指定無し”とする。
* Step S5a:
From the minimum maximum insurance amount master table 602, for example, in the case of the insurance product Y1, a record 602a corresponding to the contract contents (insurance period, payment period, payment method) specified in the search condition shown in the screen B1 (see FIG. 6 ( 2)) is extracted. In the example of the record 602a, the master table is created so that only one record is always extracted. The condition of the examination category is “Not specified”.

*ステップS6a:
ステップS5aで抽出したレコード602aより、検索対象となる社員の属性である性別・年齢に該当する最小保険金額と最大保険金額を全て抽出する。これは、図6(2)において太線枠で5人分が示されている。(以下のレコード603a及び604aにおいても同様である。)
* Step S6a:
From the record 602a extracted in step S5a, all of the minimum insurance amount and the maximum insurance amount corresponding to the gender / age as attributes of the employee to be searched are extracted. This is shown in FIG. 6 (2) for five persons by a thick line frame. (The same applies to the following records 603a and 604a.)

*ステップS7a:
検索対象となる全ての社員(5人)について、抽出した太線枠の最小保険金額と最大保険金額との間に、画面B1で「検索方法」として指定された“保険金額”=10千円が存在するか否かにより、保険商品(Y1)に加入できるか否かを判定する。なお、この「検索方法」は上述の如く実施例により異なっている。
* Step S7a:
For all employees (5 people) to be searched, the “insurance amount” specified as “Search method” on screen B1 = 10 thousand yen between the minimum insurance amount and the maximum insurance amount in the extracted bold line frame It is determined whether or not the insurance product (Y1) can be subscribed depending on whether or not it exists. The “search method” differs depending on the embodiment as described above.

*ステップS8a:
この結果、ステップS7aのレコード602aにおいて、太線枠で示す検索対象社員の中で最低1人は保険に加入できるので(YES)、次のステップS9aに進むが、そうでなければ(NO)、ステップS13に進んで次の保険商品(X1)の検索処理を実行する。
* Step S8a:
As a result, in the record 602a of step S7a, at least one of the search target employees indicated by the bold frame can be insured (YES), so the process proceeds to the next step S9a, but otherwise (NO), step Proceeding to S13, search processing for the next insurance product (X1) is executed.

*ステップS9a:
保険金額別保険料マスタテーブル603より、保険商品(Y1)について、画面B1の検索条件で指定された保険期間、払込期間、払方及び保険金額のレコード603a(図6(3)参照)を抽出する。なお、ここでもレコード603aのように、レコードは常に1件のみ抽出されるように用意されている。また、保険金額の条件は、ステップS7aと同様に最小保険金額以上最大保険金額以下であり、払込経路の条件は“口座振替”とする。
* Step S9a:
For insurance product (Y1), the insurance period, payment period, payment method, and insurance amount record 603a (see Fig. 6 (3)) specified in the search conditions on screen B1 are extracted from insurance amount master table 603 for each insurance amount. To do. In this case as well, like the record 603a, only one record is always extracted. In addition, the insurance amount condition is not less than the minimum insurance amount and not more than the maximum insurance amount as in step S7a, and the payment route condition is “account transfer”.

*ステップS10a:
ステップS9aで抽出したレコード603aより、検索対象社員の中で保険に加入できる社員についてのみ、保険料を算出する。ここで保険料を算出する理由は、レコード603aの状態では、最小−最大保険金額の範囲で社員の属性別に基準の保険料が最大保険金額=基準保険金額として規定されているだけなのでその中間の保険金額については計算する必要があり、指定した保険金額(10千円)を最大保険金額=基準保険金額で正規化して基準保険料を比例配分して求める必要があるためである。但し、このような保険料の算出処理は、上述の如く、マスタテーブル603において保険金額を一定金額(例えば1000円単位)毎にレコードを予め設定しておけば不要となる。
* Step S10a:
From the record 603a extracted in step S9a, the insurance premium is calculated only for employees who can take out insurance among the search target employees. The reason for calculating the premium here is that, in the state of record 603a, the standard premium is defined as the maximum insurance amount = the standard insurance amount for each employee attribute within the range of the minimum-maximum insurance amount. This is because the insurance amount needs to be calculated, and it is necessary to normalize the specified insurance amount (10,000 yen) with the maximum insurance amount = the standard insurance amount and to determine the standard premium proportionally. However, such insurance premium calculation processing is not necessary if the insurance amount is set in advance in the master table 603 for each predetermined amount (for example, in units of 1000 yen) as described above.

すなわち、算出保険料
={画面B1で指定した保険金額(10千円)/レコードの基準保険金額}
×レコードの基準保険料
+レコードの特約固定保険料
※レコード603a における30歳・男性の例
=(10000/14000)×112000+25800=105800 (円)
That is, calculated premium = {insurance amount specified on screen B1 (10 thousand yen) / standard insurance amount of record}
X Record standard premium + Record fixed premium * Example of 30-year-old male in record 603a = (10000/14000) x 112000 + 25800 = 105800 (yen)

*ステップS11a:
上記のステップS10aにおける保険料の考え方を解約返戻金に適用して解約返戻金を算出する。但し、解約返戻金の場合には経過年数が絡むので、経過年数分の解約返戻金レコード604a(図6(4)参照)を全て抽出する。図示の例では経過年は1年と2年である。
* Step S11a:
Applying the insurance premium concept in step S10a above to the surrender value, the surrender value is calculated. However, in the case of a cancellation refund, the elapsed years are involved, so all cancellation cancellation records 604a (see FIG. 6 (4)) for the elapsed years are extracted. In the illustrated example, the elapsed years are 1 year and 2 years.

*ステップS12a:
抽出したレコード604aより、検索対象社員の中で保険に加入できる社員についてのみ、解約返戻金を、上記の保険料と同様にして算出する。
* Step S12a:
From the extracted record 604a, the surrender value is calculated in the same manner as the above premium for only those employees who are eligible for insurance among the search target employees.

すなわち、算出解約返戻金
={画面B1で指定した保険金額(10千円)/レコードの基準保険金額}
×レコードの基準解約返戻金
+レコードの特約固定解約返戻金
※レコード604a における30歳・男性・1年目の例
=(10000/14000)×84000+16990=76990(円)
That is, calculated cancellation refund = {insurance amount specified on screen B1 (10 thousand yen) / standard insurance amount of record}
× Record standard cancellation refund + Record special fixed cancellation refund * Example of 30-year-old male first year in record 604a = (10000/14000) x 84000 + 16990 = 76990 (yen)

*ステップS13:
ループ処理が残っていれば、ステップS4に戻って同じ処理を繰り返す。
* Step S13:
If the loop process remains, the process returns to step S4 and the same process is repeated.

*ステップS14a:
ループ処理が残っていなければ、少なくとも1人以上の社員が加入可能な保険商品の一覧を画面表示する。
* Step S14a:
If there is no loop processing left, a list of insurance products to which at least one employee can join is displayed on the screen.

これが、図5(3)に示されており、画面C1の場合には、上記の各保険商品に対して被保険者数と保険金額と保険料と1年後の解約返戻金とが表示されている。画面D1の場合には各保険商品別に社員情報(属性)と契約内容と保険金額と保険料と解約返戻金とが表示されている。   This is shown in Fig. 5 (3). In the case of screen C1, the number of insured persons, the insurance amount, the insurance premium, and the cancellation refund after one year are displayed for each of the above insurance products. ing. In the case of screen D1, employee information (attribute), contract details, insurance amount, insurance premium, and surrender value are displayed for each insurance product.

なお、この場合に全社員が加入可能とならない保険商品については、警告として赤色表示をしてもよい。   Note that in this case, insurance products that cannot be enrolled by all employees may be displayed in red as a warning.

[解約返戻金を指定する場合]
図7のフローチャートは、実施例2として、データ処理装置300の保険商品検索処理部302によるデータ処理を示しており、以下、各ステップに沿ってその処理動作を説明する。
[When specifying a cancellation refund]
The flowchart of FIG. 7 shows data processing by the insurance product search processing unit 302 of the data processing apparatus 300 as the second embodiment, and the processing operation will be described along each step below.

*ステップS1:
社員マスタ502より、画面Aのように、保険商品を検索する対象となる社員を複数人(5人)選択する。
* Step S1:
From the employee master 502, as shown in screen A, a plurality of employees (5 persons) to be searched for insurance products are selected.

*ステップS2b:
画面B2に示すように、検索する保険商品の種類や契約内容の条件、並びに検索方法とその条件を指定する。この実施例では、「全ての社員(5人)の3年後の解約返戻金の合計が1000万円以上になるがん保険商品」を検索するものとする。
* Step S2b:
As shown in screen B2, the type of insurance product to be searched, the conditions of contract contents, the search method and its conditions are designated. In this embodiment, a search is made for “a cancer insurance product in which the total amount of surrender refunds after three years for all employees (5) is 10 million yen or more”.

*ステップS3:
保険種類別保険商品マスタテーブル601より、画面B2に示す検索条件で指定された保険種類「がん保険商品」に該当するレコード601a(図9(1)参照。これは図6(1)と同じ。)を抽出する。このレコード601aの例では、2つの商品X1,Y1が該当するものとする。
* Step S3:
From the insurance product master table 601 by insurance type, the record 601a corresponding to the insurance type “cancer insurance product” specified by the search condition shown in screen B2 (see FIG. 9 (1). This is the same as FIG. 6 (1). .) Is extracted. In the example of the record 601a, it is assumed that two products X1 and Y1 correspond.

*ステップS4:
ループ処理が開始され、ステップS13との間で、対象となった保険商品毎に行う。
* Step S4:
The loop process is started, and is performed for each insurance product that is the target between step S13.

*ステップS11b:
保険金額別解約返戻金マスタテーブル604より、画面B2に示す検索条件で指定された契約内容(保険期間・払込期間・払方)及び経過年(ここでは3年)のレコード604b(図9(2)参照)を抽出する。この場合、最小保険金額の条件指定は「無し」とし、レコード604bの例では、2つのレコードが該当するものとする。
* Step S11b:
From the cancellation amount master table 604 for each insurance amount, the record 604b of the contract contents (insurance period / payment period / payment method) specified in the search condition shown in screen B2 and the elapsed year (here 3 years) (FIG. 9 (2 )) Is extracted. In this case, the minimum insurance amount condition designation is “none”, and two records correspond to the example of the record 604b.

*ステップS12b:
抽出したレコード604bにおいて、検索対象社員(5人)の解約返戻金の合計がはじめて1000万円以上になる保険金額を、最小保険金額から最大保険金額の範囲で求める。
* Step S12b:
In the extracted record 604b, an insurance amount in which the total amount of cancellation refunds of the search target employees (five) is 10 million yen or more for the first time is obtained in the range from the minimum insurance amount to the maximum insurance amount.

このため、まず同一保険商品毎に最小保険金額の小さいレコード順に処理を行う。そして、保険金額増分値の単位(レコード604bの場合は1000円)で保険金額を増やしていき、解約返戻金の合計が1000万円以上になった時点(レコード604bの場合は保険金額=28000円)で算出処理を終了する。従って、同一保険商品(Y1)の別の未処理レコードの算出処理は行わない。なお、この算出処理は、前述のとおり保険金額を最小保険金額から最大保険金額の範囲で一定金額(例えば1000円)毎に分けてレコードを予め設定しておけば、不要となる。   For this reason, first, processing is performed in the order of records with the smallest insurance amount for each same insurance product. Then, increase the insurance amount in increments of the insurance amount (1000 yen in the case of record 604b), and when the total surrender value is 10 million yen or more (in the case of record 604b, the insurance amount = 28000 yen) ) Ends the calculation process. Therefore, the calculation process of another unprocessed record of the same insurance product (Y1) is not performed. Note that this calculation process is not required if the records are set in advance for each predetermined amount (for example, 1000 yen) within the range from the minimum insurance amount to the maximum insurance amount as described above.

ここで、検索対象社員の該当保険金額における解約返戻金
={求めた保険金額(28000円)/レコードの基準保険金額}
×検索対象社員の属性(年齢・性別)が該当する箇所の基準解約返戻金
+検索対象社員の属性が該当する箇所の特約固定解約返戻金
※レコード604bにおける 30歳・男性・保険金額28000円での解約返戻金
=(28000/30000)×1913610+0=1786036(円)
Here, the surrender value of the applicable insurance amount for the employee to be searched = {the amount of insurance calculated (28,000 yen) / the standard insurance amount of the record}
× Standard cancellation refund for locations where the attributes (age / gender) of the search target employee apply + Special cancellation refund for locations where the attributes of the search target employee apply * For the 30-year-old male in the record 604b, the insurance amount is 28,000 yen Cancellation refund = (28000/30000) x 1913610 + 0 = 1786036 (yen)

*ステップS8b:
解約返戻金の合計が1000万円以上となる保険金額が存在したか否かを判定する。これは、後述する図8(3)の画面D2に示されるように1000万円以上となる状態が示されており、保険金額=28000円で3年後の解約返戻金の合計が1000万円以上となる保険金額が存在したことが判る。
* Step S8b:
It is determined whether there is an insurance amount with a total surrender value of 10 million yen or more. This shows the state of over 10 million yen as shown in the screen D2 in Fig. 8 (3), which will be described later. The insurance amount = 28,000 yen, and the total surrender value after 3 years is 10 million yen. It can be seen that there was an insurance amount of the above amount.

*ステップS9b:
保険金額別保険料マスタテーブル603より、上記の保険金額別解約返戻金抽出レコード604bと同一条件(保険会社・保険商品・保険期間・払込期間・払方・最小保険金額)のレコード603b(図9(3)参照)を抽出する。なお、払込経路の条件は“口座振替”とする。
この場合も、レコード603bの例のように、レコードは常に1件のみ抽出されるようにレコードが用意されている。
* Step S9b:
From the insurance amount master table by insurance amount 603, a record 603b having the same conditions (insurance company / insurance product / insurance period / payment period / payment / minimum insurance amount) as the above-mentioned surrender value withdrawal record 604b by insurance amount (FIG. 9) (Refer to (3)). The payment route condition is “account transfer”.
Also in this case, as in the example of the record 603b, the record is prepared so that only one record is always extracted.

*ステップS10b:
抽出したレコード603bより、全ての検索対象社員(5人)の保険料を算出する。
すなわち、求める保険料
={S12bで求めた保険金額(28000円)/レコードの基準保険金額)
×検索対象社員の属性が該当する箇所の基準保険料
+検索対象社員の属性が該当する箇所の特約固定保険料
※レコード603b における30歳・男性の例
=(28000/30000)×900630+0=840588(円)
* Step S10b:
From the extracted record 603b, insurance premiums for all search target employees (5 persons) are calculated.
In other words, insurance premium to be calculated = (insurance amount calculated in S12b (28000 yen) / standard insurance amount of record)
× Standard premium for locations where the attributes of the search target employees apply + Special fixed premium for locations where the attributes of the search target employees apply * Example of a 30-year-old man in record 603b = (28000/30000) × 900 630 +0 = 840588 (yen)

*ステップS14b:
以上より、ステップS12bで保険金額(28000円)を求めることが出来た保険商品の一覧を図8(3)に示す画面C2、D2で表示する。
その際、全社員が加入可能とならない保険商品については、警告として赤色表示する。すなわち、ステップS10bで求めた保険料が0円の社員は申込不可となる。
* Step S14b:
From the above, a list of insurance products for which the insurance amount (28000 yen) can be obtained in step S12b is displayed on screens C2 and D2 shown in FIG. 8 (3).
At that time, insurance products that are not available to all employees are displayed in red as a warning. That is, an employee whose insurance premium obtained in step S10b is 0 yen cannot be applied.

[合計保険料を指定する場合]
図10のフローチャートは、実施例3として、データ処理装置300の保険商品検索処理部303によるデータ処理を示しており、以下、各ステップに沿ってその処理動作を説明する。
[When specifying the total premium]
The flowchart of FIG. 10 shows data processing by the insurance product search processing unit 303 of the data processing device 300 as Example 3, and the processing operation will be described along each step below.

*ステップS1:
社員マスタ502より、画面Aに示すように、保険商品を検索する対象となる社員を複数人(5人)選択する。
* Step S1:
From the employee master 502, as shown in screen A, a plurality of employees (5 persons) to be searched for insurance products are selected.

*ステップS2c:
画面B3(図11(2)参照)に示すように、検索する保険商品の種類や契約内容の条件、並びに検索方法とその条件を指定する。この例では、「全ての社員(5人)の年間保険料の合計が100万円以下になるがん保険商品」を検索するものとする。
* Step S2c:
As shown in screen B3 (see FIG. 11 (2)), the type of insurance product to be searched, the conditions of contract contents, the search method and its conditions are designated. In this example, a search is made for “a cancer insurance product in which the total annual insurance premiums of all employees (5 people) are 1 million yen or less”.

*ステップS3:
上述した保険種類別保険商品マスタテーブル601より、ステップS2cの検索条件で指定された保険種類に該当するレコード601aを抽出する。レコード601aの例では、この場合も、2つの商品X1,Y1が該当するものとする。
* Step S3:
A record 601a corresponding to the insurance type specified by the search condition in step S2c is extracted from the insurance product master table 601 by insurance type described above. In the example of the record 601a, it is assumed that two products X1 and Y1 are applicable in this case as well.

*ステップS4:
ループ処理が始まり、ステップS13との間で、対象となった保険商品毎に行う。
* Step S4:
The loop process is started, and the process is performed for each insurance product that is the target between step S13.

*ステップS9c:
上記の保険金額別保険料マスタテーブル603より、図11(2)の画面B3に示す検索条件で指定された保険期間・払込期間・払方のレコード603c(図12(2)参照)を抽出する。なお、払込経路の条件は“口座振替”と、最小保険金額の条件指定は無しとする。
このレコード603cの例では、2つのレコードが該当することを示している。
* Step S9c:
The insurance period / payment period / payment record 603c (see FIG. 12 (2)) specified by the search condition shown in the screen B3 of FIG. 11 (2) is extracted from the insurance amount master table 603 for each insurance amount. . It should be noted that the condition of the payment route is “account transfer” and there is no specification of the minimum insurance amount condition.
This example of the record 603c indicates that two records are applicable.

*ステップS10c:
抽出したレコード603cにおいて、検索対象社員(5人)の保険料の合計が初めて100万円以下になる保険金額を、最大保険金額から最小保険金額の範囲で求める。
このため、同一保険商品毎に、最小保険金額の大きいレコード順に処理を行う。そして、保険金額増分値(1000円)の単位で保険金額を減らしていき、合計が100万円以下になった時点(図11(3)の画面D3に示すように保険金額=6000円)で算出処理を終了する。この場合も、同一保険商品の別の未処理レコードの算出処理は行わない。なお、この算出処理は、前述のとおり保険金額を最小保険金額から最大保険金額の範囲で一定金額(例えば1000円)毎に分けてレコードを予め設定しておけば、不要となる。
* Step S10c:
In the extracted record 603c, the amount of insurance for which the total premium for the search target employees (five) is less than 1 million yen for the first time is obtained within the range from the maximum insurance amount to the minimum insurance amount.
For this reason, processing is performed in order of records with the smallest minimum insurance amount for each identical insurance product. Then, reduce the insurance amount in increments of the insurance amount (1000 yen), and when the total falls below 1 million yen (insurance amount = 6000 yen as shown on screen D3 in Fig. 11 (3)) The calculation process ends. Also in this case, the calculation process of another unprocessed record of the same insurance product is not performed. Note that this calculation process is not required if the records are set in advance for each predetermined amount (for example, 1000 yen) within the range from the minimum insurance amount to the maximum insurance amount as described above.

すなわち、検索対象社員の該当保険金額における保険料
={求めた保険金額(6000円)/レコードの基準保険金額}
×検索対象社員の属性が該当する箇所の基準保険料
+検索対象社員の属性が該当する箇所の特約固定保険料
※30歳・男性・保険金額6000円での保険料
=(6000/7000)×197411+0=169209(円)
In other words, the insurance premium at the corresponding insurance amount of the search target employee = {the calculated insurance amount (6000 yen) / the standard insurance amount of the record}
× Standard premium for locations where the attributes of the searchable employees are applicable + Special fixed premium for locations where the attributes of the searchable employees are applicable * Insurance premiums for 30-year-old males with an insurance amount of 6000 yen = (6000/7000) × 197411 + 0 = 169209 (yen)

*ステップS8c:
社員全員の保険料の合計が100万円以下となる保険金額が存在したか否かを判定する。
* Step S8c:
Judge whether there was an insurance amount that would make the total premium for all employees less than 1 million yen.

*ステップS11c:
上記の保険金額別解約返戻金マスタテーブル604より、ステップS9cで求めた保険金額別保険料抽出レコード603cと同一条件(保険会社・保険商品・保険期間・払込期間・払方・最小保険金額)のレコード604c(図12(3)参照)を抽出する。この場合、レコード604cの例のように、経過年数分の解約返戻金レコードを全て取得する。
* Step S11c:
From the above insurance amount cancellation cancellation master table 604, the same conditions (insurance company / insurance product / insurance period / payment period / payment / minimum insured amount) as the insurance fee extraction record 603c by insurance amount obtained in step S9c A record 604c (see FIG. 12 (3)) is extracted. In this case, as in the example of the record 604c, all surrender values for the elapsed years are acquired.

*ステップS12c:
抽出したレコード604cより、全ての検索対象社員の解約返戻金を算出する。
すなわち、求める解約返戻金
={ステップS10cで求めた保険金額(6000円)/レコードの基準解約返戻金}
×検索対象社員の属性が該当する箇所の基準解約返戻金
+検索対象社員の属性が該当する箇所の特約固定解約返戻金
※30歳・男性・1年目の例
=(6000/7000)×118496+0=101568(円)
* Step S12c:
From the extracted record 604c, the surrender value of all search target employees is calculated.
That is, the requested surrender value = {insurance amount obtained in step S10c (6000 yen) / standard surrender value of record}
× Standard cancellation refund for locations where the attribute of the search target employee is applicable + Special contract cancellation refund for locations where the attribute of the search target employee is applicable * Example of 30 years old, male, 1st year = (6000/7000) × 118496 + 0 = 101568 (yen)

*ステップS14c:
以上より、ステップS10cで保険金額6000円を求めることが出来た保険商品の一覧を画面C3, D3(図11(3)参照)表示する。
この場合も、全社員が加入可能とならない保険商品については、警告として赤色表示する。すなわち、ステップS10cで求めた保険料が0円の社員は申込不可となる。
* Step S14c:
As described above, the screens C3 and D3 (see FIG. 11 (3)) display the list of insurance products for which the insurance amount of 6000 yen can be obtained in step S10c.
In this case as well, insurance products that cannot be enrolled by all employees are displayed in red as a warning. That is, an employee whose insurance premium obtained in step S10c is 0 yen cannot be applied.

[最大保険金額を指定の場合]
図13のフローチャートは、実施例4として、データ処理装置300の保険商品検索処理部304によるデータ処理を示しており、以下、各ステップに沿ってその処理動作を説明する。
[If maximum insurance amount is specified]
The flowchart of FIG. 13 shows data processing by the insurance product search processing unit 304 of the data processing device 300 as Example 4, and the processing operation will be described along each step below.

*ステップS1:
社員マスタ502より、図14(1)に示す画面Aのように、保険商品を検索する対象となる社員を複数人(5人)選択する。
* Step S1:
From the employee master 502, as shown in the screen A shown in FIG. 14 (1), a plurality of employees (5 persons) to be searched for insurance products are selected.

*ステップS2d:
図14(2)に示す画面B4のように、検索する保険商品の種類や契約内容の条件、並びに検索方法を指定する。この例では、「全ての社員(5人)について、保険商品毎に加入可能な最大保険金額でがん保険商品」を検索するものとする。
* Step S2d:
As in screen B4 shown in FIG. 14 (2), the type of insurance product to be searched, the condition of the contract contents, and the search method are designated. In this example, it is assumed that “for all employees (5 people), cancer insurance products with the maximum insurance amount that can be purchased for each insurance product” is searched.

*ステップS3:
保険種類別保険商品マスタテーブル601より、検索条件で指定された保険種類に該当するレコード601a(図15(1)参照)を抽出する。レコード601aの例では、2つの商品X1,Y1が該当する。
* Step S3:
A record 601a (see FIG. 15 (1)) corresponding to the insurance type specified by the search condition is extracted from the insurance product-specific insurance product master table 601. In the example of the record 601a, two products X1 and Y1 correspond.

*ステップS4:
ループ処理が開始され、ステップS13との間で、検索対象となった保険商品毎に行う。
* Step S4:
A loop process is started, and this is performed for each insurance product to be searched between step S13.

*ステップS5d:
上記の最小最大保険金額マスタテーブル602より、図14(2)の画面B4で示した検索条件で指定された保険期間・払込期間・払方・診査区分のレコード602a(図15(2)参照)を抽出する。レコード602aの例のように、レコードは常に1件のみ抽出される。
* Step S5d:
From the above minimum and maximum insurance amount master table 602, the record 602a of the insurance period / payment period / payment / inspection category specified by the search condition shown in the screen B4 of FIG. 14 (2) (see FIG. 15 (2)) To extract. As in the example of the record 602a, only one record is always extracted.

*ステップS6d:
ステップS5dで抽出したレコード602aより、検索対象となる社員の属性(性別・年齢)に該当する最小保険金額と最大保険金額を全て抽出する。この例では、5人分が抽出される。
* Step S6d:
From the record 602a extracted in step S5d, all the minimum insurance amount and the maximum insurance amount corresponding to the attribute (gender / age) of the employee to be searched are extracted. In this example, five people are extracted.

*ステップS20:
取得した社員5人分の“最大保険金額”の中で最も大きい値を加入保険金額とする。この例では、30000円とする。
* Step S20:
The largest value of the “maximum insurance amount” for the five employees acquired is taken as the insurance amount. In this example, it is 30000 yen.

*ステップS9d:
上記の保険金額別保険料マスタテーブル603より、画面B4の検索条件で指定された保険期間・払込期間・払方、並びにステップS20で求めた保険金額30000円のレコード603d(図15(3)参照)を抽出する。なお、払込経路の条件は“口座振替”とする。また、保険金額の条件は、最小保険金額以上最大保険金額以下とする。
この場合も、レコード603dの例のように、レコードは常に1件のみ抽出される。
* Step S9d:
From the insurance amount master table 603d by insurance amount above, the insurance period / payment period / payment method specified in the search condition of screen B4 and the record 603d of the insurance amount 30000 yen obtained in step S20 (see FIG. 15 (3)) ) Is extracted. The payment route condition is “account transfer”. In addition, the insurance amount condition is not less than the minimum insurance amount and not more than the maximum insurance amount.
Also in this case, only one record is always extracted as in the example of the record 603d.

*ステップS10d:
抽出したレコード603dより、検索対象社員の中で保険に入れる社員についてのみ、保険料の算出・取得を行う。
* Step S10d:
From the extracted record 603d, insurance premiums are calculated / acquired only for employees to be insured among search target employees.

すなわち、求める保険料
={ステップS20で求めた保険金額(30000円)/レコードの基準保険金額}
×レコードの基準保険料
+レコードの特約固定保険料
※30歳・男性の例
=(30000/30000)×846048+0=846048(円)
In other words, the insurance premium to be calculated = {the insurance amount determined in step S20 (30000 yen) / the standard insurance amount of the record}
X Record standard premium + Record special fixed premium * Example of a 30 year old male = (30000/30000) x 846048 + 0 = 846048 (yen)

*ステップS11d:
上記の保険金額別解約返戻金マスタテーブル604より、画面B4の検索条件で指定された保険期間・払込期間・払方、並びにステップS20で求めた保険金額(30000円)のレコード604d(図15(4)参照)を抽出する。なお、保険金額の条件は、最小保険金額以上最大保険金額以下とする。そして、レコード604dの例のように、経過年数分の解約返戻金レコードを全て抽出する。
* Step S11d:
From the above insurance amount cancellation cancellation master table 604, the insurance period / payment period / payment method specified in the search condition of screen B4, and the record 604d of the insurance amount (30000 yen) obtained in step S20 (FIG. 15 ( 4)) is extracted. The condition for the insurance amount is not less than the minimum insurance amount and not more than the maximum insurance amount. Then, as in the example of the record 604d, all surrender value refund records for the elapsed years are extracted.

*ステップS12d:
抽出したレコード604dより、検索対象社員の中で保険に入れる社員についてのみ、解約返戻金を算出する。
* Step S12d:
Based on the extracted record 604d, the surrender value is calculated only for the employees to be insured among the search target employees.

すなわち、求める解約返戻金
={ステップS20で求めた保険金額(30000円)/レコードの基準保険金額}
×レコードの基準解約返戻金
+レコードの特約固定解約返戻金
※30歳・男性・1年目の例
=(30000/30000)×507840+0=507840(円)
That is, the surrender value to be calculated = {insurance amount obtained in step S20 (30000 yen) / standard insurance amount of record}
X Record standard cancellation refund + Record special fixed cancellation refund * Example of 30-year-old male first year = (30000/30000) x 507840 + 0 = 507840 (yen)

*ステップS14d:
以上より、対象の保険商品一覧を画面に表示する。この例が、図14(3)の画面C4、D4に示されている。
その際、全社員が加入可能とならない保険商品については、警告として赤色表示する。
* Step S14d:
As described above, the target insurance product list is displayed on the screen. This example is shown in screens C4 and D4 in FIG. 14 (3).
At that time, insurance products that are not available to all employees are displayed in red as a warning.

100 表示装置
200 入力装置
300 データ処理装置
301 保険商品検索処理部(保険金額)
302 保険商品検索処理部(解約返戻金)
303 保険商品検索処理部(合計保険料)
304 保険商品検索処理部(最大保険金額)
400 記録装置
500 法人情報部
501 法人マスタテーブル
502 社員マスタテーブル
600 保険商品情報部
601 保険種類別保険商品マスタテーブル
602 最小最大保険金額マスタテーブル
603 保険金額別保険料マスタテーブル
604 保険金額別解約返戻金マスタテーブル
601a 保険種類抽出レコード
602a 最小最大保険金額抽出レコード
603a 保険金額別保険料抽出レコード
604a 保険金額別解約返戻金抽出レコード
図中、同一符号は同一部分を示し、類似符号は相当部分を示す。
100 display devices
200 input devices
300 data processor
301 Insurance product search processing department (insurance amount)
302 Insurance product search processing department (cancellation refund)
303 Insurance product search processing department (total premium)
304 Insurance product search processing department (maximum insurance amount)
400 recorder
500 Corporate Information Department
501 Corporate Master Table
502 employee master table
600 Insurance Product Information Department
601 Insurance product master table by insurance type
602 Minimum and maximum insurance amount master table
603 Premium master table by insurance amount
604 Cancellation refund master table by insurance amount
601a Insurance type extraction record
602a Minimum and maximum insurance amount extraction record
603a Insurance premium extraction record by insurance amount
604a Cancellation refund extraction record by insurance amount In the figure, the same symbols indicate the same parts, and the similar codes indicate the corresponding parts.

Claims (9)

保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別且つ複数の被保険者属性別に加入可能な保険金額を格納した第2のデータベースと、該保険商品別、該契約内容別、該保険金額別且つ該被保険者属性別の基礎保険料を格納した第3のデータベースと、該保険商品別、該契約内容別、該保険金額別及び該被保険者属性別の基礎解約返戻金を経過年毎に格納した第4のデータベースとを有する記録装置と、
指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、検索対象となる複数の被保険者の内の少なくとも一人が、指定した契約内容、保険金額及び被保険者属性に合致する保険商品を該第2のデータベースから抽出し、該抽出された保険商品において該合致した被保険者の属性に対する保険料を該第3のデータベース中の基礎保険料から計算し、該抽出された保険商品において該合致した被保険者の属性に対する解約返戻金を該第4のデータベース中の基礎解約返戻金から経過年毎に計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに出力する演算装置と、
該演算装置の出力を画面表示する表示装置と、
を備えたことを特徴とする保険商品検索システム。
A first database storing insurance products for each insurance type; a second database storing insurance amounts that can be enrolled for each insurance product, for each contract content and for a plurality of insured attributes; and for each insurance product, A third database storing basic insurance premiums by contract contents, insurance amounts and insured attributes, insurance products, contract contents, insurance amounts and insured attributes A recording device having a fourth database in which the basic cancellation refund amount of each is stored for each elapsed year;
The insurance product corresponding to the designated insurance type is extracted from the first database, and at least one of the extracted insurance products among the plurality of insured persons to be searched is the designated contract contents and insurance amount. And the insurance product that matches the insured person attribute is extracted from the second database, and the insurance premium for the attribute of the insured person matched in the extracted insurance product is extracted from the basic insurance premium in the third database. Calculating a surrender value refund for the matched insured's attribute in the extracted insurance product for each elapsed year from a basic surrender value in the fourth database; An arithmetic unit that outputs the insurance amount, the insured attribute, and the contract details;
A display device for displaying the output of the arithmetic device on a screen;
An insurance product search system characterized by comprising:
請求項1において、
該第2のデータベースの保険金額が、最小保険金額と最大保険金額とで構成され、該演算装置は、該指定した保険金額に一致するか否かを被保険者属性別に該最小保険金額と最大保険金額との範囲に入るか否かで判定することを特徴とする保険商品検索システム。
In claim 1,
The insurance amount of the second database is composed of a minimum insurance amount and a maximum insurance amount, and the computing device determines whether or not the insurance amount matches the specified insurance amount according to the insured attribute. An insurance product search system characterized in that the determination is made based on whether or not the insurance amount falls within the range.
保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別、保険金額別及び該被保険者属性別の基礎解約返戻金を経過年毎に格納した第2のデータベースと、該保険商品別、該契約内容別、該保険金額別且つ該複数の被保険者属性別の基礎保険料を格納した第3のデータベースとを有する記録装置と、
指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、指定した契約内容で検索対象となる複数の被保険者の属性に対する全ての所定経過年後の解約返戻金の合計が指定金額以上となる保険商品の保険金額を該第2のデータベースから求め、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の解約返戻金を該第2のデータベース中の該全被保険者の属性に対する基礎解約返戻金から計算し、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の保険料を該第3のデータベース中の該全被保険者の属性に対する基礎保険料から計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに出力する演算装置と、
該演算装置の出力を画面表示する表示装置と、
を備えたことを特徴とする保険商品検索システム。
A first database that stores insurance products by insurance type, and a second database that stores basic surrender values for each insurance product, contract contents, insurance amount, and insured person attributes for each past year A third database storing basic insurance premiums by insurance product, by contract content, by insurance amount, and by the plurality of insured attributes;
After extracting the insurance product corresponding to the designated insurance type from the first database, and after all the predetermined elapsed years for the attributes of a plurality of insured persons to be searched with the designated contract contents in the extracted insurance product The insurance amount of an insurance product for which the total amount of surrender refunds is equal to or more than the specified amount is obtained from the second database, and the cancellation of all insured persons subject to the search under the same conditions as when the insurance amount was obtained A refund is calculated from the basic surrender value for the attributes of all the insured persons in the second database, and the insurance for all the insured persons to be searched under the same conditions as the conditions for obtaining the insurance amount A computing device that calculates a premium from basic insurance premiums for the attributes of all the insured persons in the third database and outputs the insurance premium together with the corresponding insurance product, the insurance amount, the insured person attributes, and the contract details; ,
A display device for displaying the output of the arithmetic device on a screen;
An insurance product search system characterized by comprising:
請求項3において、
該第2のデータベースの保険金額が最小保険金額と最大保険金額とで構成されており、該演算装置は、該解約返戻金の合計が該指定金額以上となる保険商品の保険金額を、各被保険者属性について該最小保険金額から最大保険金額の範囲で一定金額ずつ最大保険金額まで増加させることにより求めることを特徴とする保険商品検索システム。
In claim 3,
The insurance amount of the second database is composed of a minimum insurance amount and a maximum insurance amount, and the computing device calculates the insurance amount of an insurance product for which the sum of the surrender value is equal to or more than the specified amount. An insurance product search system characterized in that an insurer attribute is obtained by increasing a predetermined amount in a range from the minimum insurance amount to a maximum insurance amount, up to a maximum insurance amount.
保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別、保険金額別且つ複数の被保険者属性別の基礎保険料を格納した第2のデータベースと、該保険商品別、該契約内容別、該保険金額別且つ該被保険者属性別の基礎解約返戻金を経過年毎に格納した第3のデータベースとを有する記録装置と、
指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、指定した契約内容で検索対象となる複数の被保険者の属性に対する年間保険料の合計が指定金額以下となる保険商品の保険金額を該第2のデータベースから求め、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の保険料を該第2のデータベース中の該全被保険者の属性に対する基礎保険料から計算し、該保険金額を求めたときの条件と同一条件での該検索対象の全被保険者の解約返戻金を該第3のデータベース中の該全被保険者の属性に対する基礎解約返戻金から計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに出力する演算装置と、
該演算装置の出力を画面表示する表示装置と、
を備えたことを特徴とする保険商品検索システム。
A first database storing insurance products by insurance type, a second database storing basic insurance premiums by insurance products, contract contents, insurance amounts and a plurality of insured attributes, and the insurance A recording device having a third database storing the basic surrender value by product, the contract content, the insurance amount, and the insured person attribute for each elapsed year;
The insurance product corresponding to the designated insurance type is extracted from the first database, and the sum of the annual premiums for the attributes of a plurality of insured persons to be searched with the designated contract content is obtained from the extracted insurance product. The insurance amount of an insurance product that is equal to or less than the specified amount is obtained from the second database, and the insurance premiums of all the insured persons to be searched under the same conditions as the conditions for obtaining the insurance amount are obtained from the second database. Calculated from the basic premiums for the attributes of all the insured persons in the third database, the surrender value refunds of all the insured persons to be searched under the same conditions as when the insurance amount was obtained are stored in the third database. A calculation device that calculates the basic surrender value for the attributes of all the insured persons and outputs together with the corresponding insurance product, the insurance amount, the insured person attributes, and the contract contents;
A display device for displaying the output of the arithmetic device on a screen;
An insurance product search system characterized by comprising:
請求項5において、
該第2のデータベースの保険金額が最小保険金額と最大保険金額とで構成されており、該演算装置は、該年間保険料の合計が該指定金額以下となる保険商品の保険金額を、各被保険者属性について該最大保険金額から一定金額ずつ最小保険金額まで減少させることにより求めることを特徴とする保険商品検索システム。
In claim 5,
The insurance amount of the second database is composed of a minimum insurance amount and a maximum insurance amount, and the computing device calculates the insurance amount of an insurance product for which the sum of the annual insurance premiums is equal to or less than the specified amount. An insurance product search system characterized in that an insurer attribute is obtained by reducing the maximum insurance amount from the maximum insurance amount by a certain amount to a minimum insurance amount.
保険種類別の保険商品を格納した第1のデータベースと、該保険商品別、契約内容別且つ複数の被保険者属性別に加入可能な最小及び最大保険金額を格納した第2のデータベースと、該保険商品別、該契約内容別且つ該複数の被保険者属性別の基礎保険料を格納した第3のデータベースと、該保険商品別、該契約内容別且つ該被保険者属性別の基礎解約返戻金を経過年毎に格納した第4のデータベースとを有する記録装置と、
指定した保険種類に対応する保険商品を該第1のデータベースから抽出し、該抽出した保険商品の内、指定した契約内容で検索対象となる複数の被保険者の各々について加入可能な最大保険金額の中で最も大きい保険金額を該第1及び第2のデータベースから抽出し、該抽出された保険金額の条件と同一条件で加入可能な被保険者についてのみ保険料を該第3のデータベース中の基礎保険料から計算し、該抽出された保険金額と同一条件で加入可能な被保険者についてのみ解約返戻金を該第4のデータベース中の基礎解約返戻金から計算して、対応する該保険商品、該保険金額、該被保険者属性及び該契約内容とともに出力する演算装置と、
該演算装置の出力を画面表示する表示装置と、
を備えたことを特徴とする保険商品検索システム。
A first database storing insurance products for each insurance type; a second database storing minimum and maximum insurance amounts that can be enrolled for each insurance product, each contract content and each of a plurality of insured attributes; and A third database storing basic premiums for each product, each contract content and each of the plurality of insured attributes, and a basic surrender value refund for each insurance product, each contract content and each insured attribute A recording device having a fourth database that stores the data for each elapsed year;
The insurance product corresponding to the designated insurance type is extracted from the first database, and among the extracted insurance products, the maximum insurance amount that can be enrolled for each of a plurality of insured persons to be searched with the designated contract content In the third database, the largest insurance amount is extracted from the first and second databases, and only the insured person who can join under the same conditions as the extracted insurance amount conditions, Calculate from the basic surrender value in the fourth database only for the insured person who can be enrolled under the same conditions as the extracted insurance amount by calculating from the basic insurance premium, and the corresponding insurance product An arithmetic unit that outputs the insurance amount, the insured attribute, and the contract contents;
A display device for displaying the output of the arithmetic device on a screen;
An insurance product search system characterized by comprising:
請求項1、3、5又は7において、
該被保険者の属性が、性別及び年齢であることを特徴とする保険商品検索システム。
In claim 1, 3, 5 or 7,
An insurance product search system, wherein the attributes of the insured are sex and age.
請求項1、3、5又は7において、
該基礎保険料及び基礎解約返戻金が、それぞれ、基準保険料及び基準解約返戻金とこれに加算される特約固定保険料及び特約固定解約返戻金とで構成され、該計算される保険料及び解約返戻金が、該基準保険料及び基準解約返戻金を、該保険金額とこの保険金額を確定する範囲の上限を示す基準保険金額との比で比例配分し、これに該特約固定保険料及び特約固定解約返戻金をそれぞれ加算した値であることを特徴とする保険商品検索システム。
In claim 1, 3, 5 or 7,
The basic premium and basic surrender value are composed of the standard premium and standard surrender value, and the special contract fixed premium and special contract surrender value, which are added to the standard premium and standard surrender value, respectively. Reimbursement distributes the standard premium and standard surrender value in proportion to the ratio between the insurance amount and the standard insurance amount that indicates the upper limit of the range in which the insurance amount is fixed, and the fixed premium and special contract An insurance product search system characterized in that it is a value obtained by adding a fixed surrender value.
JP2010227473A 2010-10-07 2010-10-07 Insurance product search system Active JP5595860B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2010227473A JP5595860B2 (en) 2010-10-07 2010-10-07 Insurance product search system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2010227473A JP5595860B2 (en) 2010-10-07 2010-10-07 Insurance product search system

Publications (2)

Publication Number Publication Date
JP2012083837A true JP2012083837A (en) 2012-04-26
JP5595860B2 JP5595860B2 (en) 2014-09-24

Family

ID=46242660

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2010227473A Active JP5595860B2 (en) 2010-10-07 2010-10-07 Insurance product search system

Country Status (1)

Country Link
JP (1) JP5595860B2 (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2018026100A (en) * 2016-08-01 2018-02-15 パナソニック インテレクチュアル プロパティ コーポレーション オブ アメリカPanasonic Intellectual Property Corporation of America Insurance payment calculation apparatus, insurance payment calculation method and insurance payment calculation program
JP2022124086A (en) * 2021-02-15 2022-08-25 株式会社Finatext Information processing method, information processing device and program

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002063362A (en) * 2000-08-18 2002-02-28 Zaikon Amenity:Kk Insurance retrieval system and recording medium with recorded insurance retrieving program
JP2002222311A (en) * 2001-01-26 2002-08-09 Nri & Ncc Co Ltd Life insurance design system
JP2003085369A (en) * 2001-09-07 2003-03-20 Sumitomo Life Insurance Co Device for providing insurance design information
JP2003337888A (en) * 2002-03-15 2003-11-28 Hoken Service System Kk Information processing apparatus, insurance information management method, information processing method, program for performing the same method, information recording medium in which the same program is recorded, insurance information management system and information processing system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002063362A (en) * 2000-08-18 2002-02-28 Zaikon Amenity:Kk Insurance retrieval system and recording medium with recorded insurance retrieving program
JP2002222311A (en) * 2001-01-26 2002-08-09 Nri & Ncc Co Ltd Life insurance design system
JP2003085369A (en) * 2001-09-07 2003-03-20 Sumitomo Life Insurance Co Device for providing insurance design information
JP2003337888A (en) * 2002-03-15 2003-11-28 Hoken Service System Kk Information processing apparatus, insurance information management method, information processing method, program for performing the same method, information recording medium in which the same program is recorded, insurance information management system and information processing system

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2018026100A (en) * 2016-08-01 2018-02-15 パナソニック インテレクチュアル プロパティ コーポレーション オブ アメリカPanasonic Intellectual Property Corporation of America Insurance payment calculation apparatus, insurance payment calculation method and insurance payment calculation program
JP2022124086A (en) * 2021-02-15 2022-08-25 株式会社Finatext Information processing method, information processing device and program
JP7343196B2 (en) 2021-02-15 2023-09-12 株式会社Finatext Information processing method, information processing device and program

Also Published As

Publication number Publication date
JP5595860B2 (en) 2014-09-24

Similar Documents

Publication Publication Date Title
US9672573B2 (en) Graphical user interface for facilitating allocation of variable compensation
Dyas et al. Process-improvement cost model for the emergency department
Anner Addressing workers’ rights violations in apparel and agricultural supply chains through binding, cost-sharing Accords
Raheem More finance or better finance in Feldstein–Horioka puzzle: Evidence from SSA countries
CN111199308A (en) Client prediction method and device for different overdue stages and electronic equipment
JP5595860B2 (en) Insurance product search system
JP6265871B2 (en) Sales operation support system and sales operation support method
Sultana et al. Housing affordability of ready-made garment workers in the Dhaka Metropolitan Area
Scrivner et al. XD Metrics on Demand Value Analytics: Visualizing the Impact of Internal Information Technology Investments on External Funding, Publications, and Collaboration Networks
Hejazi et al. Performance measurement of a lean product development process
JP5963998B1 (en) Credit office management system and method
US20100106635A1 (en) Client relationship profile
EP4118594A1 (en) Accelerated intelligent enterprise including timely vendor spend analytics
Briody et al. A tale of two career paths: The process of status acquisition by a new organizational unit
JP5300824B2 (en) Information processing system, information processing method, and information processing program
Kittelson et al. Palliative care scorecard
JP6130979B1 (en) Credit management system, method, and program
JP2009134375A (en) Financing examination support system and its method
WO2024095959A1 (en) Information processing system, information processing method, and program
Shayebr et al. Impact of Information Technology on Accounting Systems
Schuster Analyzing use of the serials collection to inform an academic library’s annual subscription renewal/cancelation decisions
Kuhlmann et al. The THESEUS use cases
JP2012018579A (en) Information retrieval device, information retrieval method and program
Kont Using time-driven activity-based costing to support performance measurement in Estonian university libraries: A case study for acquisition process
JP2002015126A (en) Device and method for calculating recoverable amount about compensation claim and medium having program for recoverable amount calculation processing recorded thereon

Legal Events

Date Code Title Description
A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20121218

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20131225

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20140128

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20140310

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20140805

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20140806

R150 Certificate of patent or registration of utility model

Ref document number: 5595860

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250