TWM650648U - Systems for verifying insurance application information - Google Patents
Systems for verifying insurance application information Download PDFInfo
- Publication number
- TWM650648U TWM650648U TW112204411U TW112204411U TWM650648U TW M650648 U TWM650648 U TW M650648U TW 112204411 U TW112204411 U TW 112204411U TW 112204411 U TW112204411 U TW 112204411U TW M650648 U TWM650648 U TW M650648U
- Authority
- TW
- Taiwan
- Prior art keywords
- data
- insurance
- operation expression
- check
- list
- Prior art date
Links
- 230000014509 gene expression Effects 0.000 claims abstract description 70
- 238000004364 calculation method Methods 0.000 claims abstract description 30
- 230000015654 memory Effects 0.000 claims abstract description 26
- 238000007689 inspection Methods 0.000 claims abstract description 10
- 238000012795 verification Methods 0.000 claims description 24
- 230000008030 elimination Effects 0.000 claims description 6
- 238000003379 elimination reaction Methods 0.000 claims description 6
- 238000013461 design Methods 0.000 description 4
- 238000000034 method Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000007774 longterm Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003862 health status Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
本創作提供投保資料檢核系統,包含檢核模組、資料庫及記憶體資料庫。檢核模組依商品資訊判斷檢核類別,取得檢核類別下的至少一運算式,產生一第一運算式列表,並經比對後判斷第一運算式列表中是否有應剔除之運算式,若有則剔除之,得第二運算式列表。檢核模組將商品資訊及第二運算式列表儲存於記憶體資料庫,並基於第二運算式列表中的運算式檢核投保資料。This creation provides an insurance data checking system, including checking modules, databases and memory databases. The inspection module determines the inspection category based on the product information, obtains at least one operation expression under the inspection category, generates a first operation expression list, and determines after comparison whether there is an operation expression that should be eliminated in the first operation expression list. , if there is one, delete it to get the second operational expression list. The checking module stores the product information and the second calculation formula list in the memory database, and checks the insurance application data based on the calculation formula in the second calculation formula list.
Description
本創作係關於一種投保資料檢核系統。This creation is about an insurance information checking system.
人壽保險業者長期發展公司保險業務員行動投保平台及客戶網路投保平台等應用,對於第三方合作夥伴(例如,銀行通路)多數仍仰賴紙本書寫及傳遞,客戶投保過程費工費時,且經常因客戶填寫要保文件內容不清晰或書寫遺漏等,使得核保過程冗長且不利於契約雙方。從系統的角度來看,過往核保檢驗程式開發邏輯太過繁複,且設計扁平導致維護成本偏高。Life insurance companies have long-term development of applications such as mobile insurance platforms for company insurance salesmen and online insurance platforms for customers. For third-party partners (for example, bank channels), most still rely on paper writing and delivery. The customer insurance process is labor-consuming, time-consuming, and often The underwriting process is lengthy and unfavorable to both parties because the content of the insurance documents filled out by the customer is unclear or the writing is omitted. From a system perspective, the development logic of past underwriting inspection programs was too complex, and the flat design resulted in high maintenance costs.
為改善上述缺點,本創作提供一種投保資料檢核系統,包含:一檢核模組,用於依請求檢核一第一投保資料;一資料庫,連接該檢核模組,該資料庫儲存有一主資料、一規則資料、一例外資料及一訊息資料,其中該主資料記錄有特定通路之特定商品應檢核之類別,該規則資料記錄有特定類別下各檢核項目的運算式,該例外資料記錄有特定類別或特定運算式的剔除條件,而該訊息資料則記錄有錯誤訊息資訊;及一記憶體資料庫,連接該檢核模組,該記憶體資料庫為一非關聯式資料庫;其中該檢核模組比對該第一投保資料中的第一商品資訊與該主資料,判斷出一檢核類別,再取得該規則資料中該檢核類別下的至少一運算式,產生一第一運算式列表;該檢核模組比對該第一商品資訊與該例外資料,判斷該第一運算式列表中是否有應剔除之運算式,若有,則剔除之,得到一第二運算式列表;該檢核模組將該第一商品資訊及該第二運算式列表儲存於該記憶體資料庫;該檢核模組基於該第二運算式列表中的運算式,對該第一投保資料進行檢核;若存在檢核未通過的運算式項目,該檢核模組基於該訊息資料取得對應的錯誤訊息。In order to improve the above shortcomings, this invention provides an insurance data checking system, including: a checking module, used to check a first insurance data according to the request; a database, connected to the checking module, the database stores There is one master data, one rule data, one exception data and one message data. The master data records the categories of specific products in specific channels that should be inspected. The rule data records the calculation formulas of each inspection item under the specific category. The The exception data records the elimination conditions of a specific category or a specific operation, and the message data records error message information; and a memory database is connected to the checking module, and the memory database is a non-associative data database; wherein the check module compares the first product information in the first insurance data with the master data, determines a check category, and then obtains at least one operation expression under the check category in the rule data, Generate a first operation expression list; the checking module compares the first product information and the exception data to determine whether there is an operation expression that should be eliminated in the first operation expression list, and if so, remove it to obtain a a second operation formula list; the verification module stores the first product information and the second operation formula list in the memory database; the verification module performs The first insurance data is checked; if there are calculation items that fail the check, the check module obtains the corresponding error message based on the message data.
在本創作的部分具體實施例中,該商品資訊包括一通路代碼及一商品代碼。In some specific embodiments of the invention, the product information includes a channel code and a product code.
在本創作的部分具體實施例中,若後續接獲請求之第二投保資料中的第二商品資料與該記憶體資料庫中儲存的該第一商品資料相同,則該檢核模組直接自該記憶體資料庫取得該第二運算式列表,並基於該第二運算式列表中的運算式,對該第二投保資料進行檢核。In some specific embodiments of this invention, if the second product information in the second insurance information received subsequently is the same as the first product information stored in the memory database, the verification module directly automatically The memory database obtains the second operation expression list, and checks the second insurance data based on the operation expressions in the second operation expression list.
在本創作的部分具體實施例中,該錯誤訊息包括一動態內容,其根據該第一投保資料中的特定資訊呈現。In some embodiments of the invention, the error message includes a dynamic content that is presented based on specific information in the first insurance data.
在本創作的部分具體實施例中,該規則資料中的各運算式為一表達式語言的表達式。根據一些具體實施例,該表達式語言為SpEL。In some specific embodiments of the present invention, each operation expression in the rule data is an expression in an expression language. According to some specific embodiments, the expression language is SpEL.
本創作之其他目的及優點一部分記載於下述說明中,或者可透過本創作的實施例而理解。應了解前文之創作內容及下文之實施方式僅為例示性及闡釋性之說明,而非如申請專利範圍般限定本創作。Other purposes and advantages of the present invention are partly described in the following description, or may be understood through embodiments of the present invention. It should be understood that the foregoing creative content and the following implementation methods are only illustrative and explanatory descriptions, and do not limit the creative content as in the scope of the patent application.
除非另有指明,所有在此處使用的技術性和科學性術語具有如同本創作所屬技藝中之通常技術者一般所瞭解的意義。Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this work belongs.
本文所使用的「一」乙詞,如未特別指明,係指至少一個(一個或一個以上)之數量。The words "one" and "B" used in this article, unless otherwise specified, refer to the quantity of at least one (one or more than one).
本創作係提供一種投保資料檢核系統,包含: 一檢核模組,用於依請求檢核一第一投保資料; 一資料庫,連接該檢核模組,該資料庫儲存有一主資料、一規則資料、一例外資料及一訊息資料,其中該主資料記錄有特定通路之特定商品應檢核之類別,該規則資料記錄有特定類別下各檢核項目的運算式,該例外資料記錄有特定類別或特定運算式的剔除條件,而該訊息資料則記錄有錯誤訊息資訊;及 一記憶體資料庫,連接該檢核模組,該記憶體資料庫為一非關聯式資料庫; 其中: 該檢核模組比對該第一投保資料中的第一商品資訊與該主資料,判斷出一檢核類別,再取得該規則資料中該檢核類別下的至少一運算式,產生一第一運算式列表; 該檢核模組比對該第一商品資訊與該例外資料,判斷該第一運算式列表中是否有應剔除之運算式,若有,則剔除之,得到一第二運算式列表; 該檢核模組將該第一商品資訊及該第二運算式列表儲存於該記憶體資料庫; 該檢核模組基於該第二運算式列表中的運算式,對該第一投保資料進行檢核;及 若存在檢核未通過的運算式項目,該檢核模組基於該訊息資料取得對應的錯誤訊息。 This creative system provides an insurance information verification system, including: A checking module, used to check a first insurance information upon request; A database is connected to the inspection module. The database stores a master data, a rule data, an exception data and a message data. The master data records the categories of specific products in a specific channel that should be inspected. The rule The data records have the operation formulas of each check item under a specific category, the exception data records the elimination conditions of a specific category or a specific operation formula, and the message data records error message information; and A memory database connected to the verification module, the memory database being a non-associative database; in: The check module compares the first product information in the first insurance data with the master data, determines a check category, and then obtains at least one operation expression under the check category in the rule data to generate a first a list of operational expressions; The checking module compares the first product information and the exception data to determine whether there is an operation expression that should be eliminated in the first operation expression list, and if so, remove it to obtain a second operation expression list; The checking module stores the first product information and the second calculation formula list in the memory database; The checking module checks the first insurance information based on the calculation expression in the second calculation expression list; and If there is an operation expression item that fails the check, the check module obtains the corresponding error message based on the message data.
本文中所述的各模組或資料庫可以僅藉由硬體(例如,硬體電路)來實現,或是由軟體配合硬體來實現。Each module or database described in this article can be implemented only by hardware (for example, hardware circuits), or by software combined with hardware.
檢核模組、資料庫及記憶體資料庫可獨立地包含一儲存裝置、一處理器及/或一通訊晶片。儲存裝置之實例包括硬碟、隨身碟、記憶體、記憶卡等。處理器之實例包括積體電路如微控制單元、微處理器、數位訊號處理器、特殊應用積體電路(ASIC)、邏輯電路或其他類似元件或上述元件的組合。通訊晶片可以實施為長期演進系統(LTE)、全球互通微波存取系統(WiMAX)、無線保真系統(Wi-Fi)、藍芽傳輸、全球行動通訊(GSM)或個人手持式電話系統(PHS)等。The verification module, database and memory database may independently include a storage device, a processor and/or a communication chip. Examples of storage devices include hard drives, pen drives, memories, memory cards, etc. Examples of processors include integrated circuits such as microcontroller units, microprocessors, digital signal processors, application specific integrated circuits (ASICs), logic circuits, or other similar components or combinations thereof. Communication chips can be implemented as Long Term Evolution (LTE), Worldwide Interoperability for Microwave Access (WiMAX), Wireless Fidelity (Wi-Fi), Bluetooth transmission, Global Mobile Communications (GSM) or Personal Handheld Phone System (PHS) )wait.
本文中所述之「連接」包括但不限於電性連接、訊號連接及/或通訊連接。The "connection" mentioned in this article includes but is not limited to electrical connection, signal connection and/or communication connection.
線上投保平台可自投保通路接獲使用者的投保資料,將接獲的投保資料存入記錄表(LOG table),並依據一預先決定的格式對該投保資料進行格式轉換。使用者可使用一電子裝置由一投保通路(例如,網路銀行)辦理行動投保。所述電子裝置包括但不限於桌上型電腦、筆記型電腦、平板電腦或智慧型手機。The online insurance platform can receive the user's insurance information from the insurance application channel, store the received insurance information in a log table (LOG table), and perform format conversion on the insurance information according to a predetermined format. Users can use an electronic device to apply for mobile insurance through an insurance channel (for example, online banking). The electronic device includes but is not limited to a desktop computer, a notebook computer, a tablet computer or a smart phone.
或者,本創作之投保資料檢核系統可進一步包含介面模組,用於接收投保資料,將接獲的投保資料存入記錄表(LOG table),並依據預先決定的格式對該投保資料進行格式轉換。在一實例中,介面模組先對投保通路進行分類判斷,例如,判斷其為現有通路A、B、C其中之一,再基於特定通路對應的資料格式,轉換為所述預先決定的格式。Alternatively, the insurance data checking system of this creation can further include an interface module for receiving insurance data, storing the received insurance data in a log table (LOG table), and formatting the insurance data according to a predetermined format. Convert. In one example, the interface module first classifies the insurance channel, for example, determines that it is one of the existing channels A, B, and C, and then converts it into the predetermined format based on the data format corresponding to the specific channel.
根據本創作,檢核模組可藉由Java技術,從客戶承保的資料中萃取出規則檢核需要的商品資訊(可包含通路代碼及商品代碼),以及要保人與被保人的相關資訊息,再基於傳入的訊息,從資料庫搜尋到該次需要被檢核的因子(可包括正向比對及反向剔除)並進行演算,最後得到檢核結果之後回傳給前端系統。According to this invention, the verification module can use Java technology to extract the product information required for rule verification (which may include channel codes and product codes) from the customer's underwriting data, as well as the relevant information of the applicant and the insured. message, and then based on the incoming message, the factors that need to be checked are searched from the database (which can include forward comparison and reverse elimination) and calculated, and the final check results are obtained and then sent back to the front-end system.
資料庫儲存有主資料、規則資料、例外資料及訊息資料。主資料記錄有特定通路之特定商品應檢核之類別,規則資料記錄有特定類別下各檢核項目的運算式,例外資料記錄有特定類別或特定運算式的剔除條件,而訊息資料則記錄有錯誤訊息資訊。The database stores master data, rule data, exception data and message data. The master data records the categories that should be inspected for specific products in specific channels, the rule data records the calculation formulas for each inspection item under the specific category, the exception data records the elimination conditions of specific categories or specific calculation formulas, and the message data records the Error message information.
較佳地,規則資料中的各運算式為一表達式語言(expression language)的表達式。在一些具體實施例中,該表達式語言為SpEL(Spring Expression Language)。Preferably, each operation expression in the rule data is an expression in an expression language. In some specific embodiments, the expression language is SpEL (Spring Expression Language).
首先,比對商品資訊與主資料,以確定該商品通路及該商品代碼下的保險產品應進行檢核的一或多檢核類別。所述檢核類別包括但不限於保單基本訊息、要保人資訊、被保人資訊、受益人資訊、通路資訊、健康狀況類、投資分析問卷、附約資訊、投資標的、風險屬性問卷等。接著依據所述檢核類別,至規則資料中取得所述檢核類別下的至少一運算式,產生第一運算式列表,其包含所述檢核類別下的各檢核運算式。First, compare the product information with the master data to determine one or more inspection categories that should be inspected for the product channel and the insurance products under the product code. The review categories include but are not limited to basic policy information, proposer information, insured information, beneficiary information, access information, health status, investment analysis questionnaires, rider information, investment targets, risk attribute questionnaires, etc. Then, according to the check category, at least one calculation expression under the check category is obtained from the rule data, and a first calculation expression list is generated, which includes each check calculation expression under the check category.
另外,可比對商品資訊與例外資料,以判斷該第一運算式列表中是否有應剔除之運算式,若依據例外資料,在符合該商品資訊的條件下,有應排除的一或多運算式,則自該第一運算式列表中剔除之,得到第二運算式列表(若無,則不進行剔除,以第一運算式列表作為第二運算式列表)。In addition, the product information and exception data can be compared to determine whether there are any calculation expressions in the first calculation expression list that should be excluded. If based on the exception data, there are one or more calculation expressions that should be excluded if the product information is met. , then eliminate it from the first operation expression list to obtain the second operation expression list (if not, it will not be eliminated, and the first operation expression list will be used as the second operation expression list).
最後,檢核模組基於該第二運算式列表中的運算式,對所述投保資料進行檢核。若存在檢核未通過的運算式項目,檢核模組基於訊息資料取得對應的錯誤訊息,並可將檢核結果及錯誤訊息(若有)回傳至前端。Finally, the checking module checks the insurance information based on the calculation expression in the second calculation expression list. If there are calculation items that fail the check, the check module obtains the corresponding error message based on the message data, and can send the check result and error message (if any) back to the front end.
所述記憶體資料庫(in-memory database)較佳為一非關聯式資料庫,例如, Redis資料庫。產生第二運算式列表後,檢核模組可將該商品資訊及該第二運算式列表儲存於記憶體資料庫,若後續接獲之投保資料有相同的商品資料,檢核模組可直接自記憶體資料庫取得該第二運算式列表,並基於該第二運算式列表中的運算式,對該第二投保資料進行檢核。The in-memory database is preferably a non-relational database, such as a Redis database. After generating the second calculation formula list, the verification module can store the product information and the second calculation formula list in the memory database. If the subsequent insurance information received has the same product information, the verification module can directly The second operation expression list is obtained from the memory database, and the second insurance data is checked based on the operation expressions in the second operation expression list.
在一些具體實施中,所述錯誤訊息可包括動態內容,其根據保資料中的特定資訊呈現。例如,該動態內容可為要保人之年齡。In some implementations, the error message may include dynamic content that is presented based on specific information in the protected data. For example, the dynamic content may be the age of the policyholder.
本創作之投保資料檢核系統及方法的特點包括: 1. 動態讀取的檢核公式:有別以往的設計模式,一般開發模式是將各種的檢核判斷式寫於程式中,程式中往往會有數以百行甚至千行的if/else 判斷式,本創作利用表達式語言與資料庫設計之耦合,達成動態及時檢核;若有變更核保規則的需求,可以直接透過變更資料庫的方式調整規則,不需要重新 compile class與重啟服務; 2. 利用記憶體資料庫(例如,Redis)進行核保規則緩存,面對數以萬計的核保規則也僅需數秒的時間即可獲得;及 3. 多維度的資料庫設計 : 將橫跨多通路的資料維度收攏於資料庫中,所有通路的保單皆透過同樣的檢核引擎進行所屬通路規則的檢核行為。 The features of this creative insurance data checking system and method include: 1. Dynamically read verification formulas: Different from the previous design model, the general development model is to write various verification judgment formulas in the program. There are often hundreds or even thousands of lines of if/else judgment formulas in the program. , this creation uses the coupling of expression language and database design to achieve dynamic and real-time verification; if there is a need to change the underwriting rules, the rules can be adjusted directly by changing the database, without recompiling the class and restarting the service; 2. Use a memory database (for example, Redis) to cache underwriting rules, and it only takes a few seconds to obtain tens of thousands of underwriting rules; and 3. Multi-dimensional database design: gather the data dimensions across multiple channels into the database, and the policies of all channels will use the same verification engine to perform the verification behavior of the corresponding channel rules.
現參照圖1說明本創作之投保資料檢核系統的一具體實施例如下。 A specific implementation example of the insurance information checking system of this invention will now be described with reference to Figure 1 as follows.
提供投保資料檢核系統100包含檢核模組110、資料庫120及記憶體資料庫130。資料庫120及記憶體資料庫130分別連接檢核模組110。投保資料檢核系統100與電子裝置200通訊連接。
The insurance
資料庫120儲存有主資料121、規則資料122、例外資料123及訊息資料124。主資料121記錄特定通路之特定商品應檢核之類別,規則資料122記錄特定類別下各檢核項目的運算式,例外資料123記錄有特定類別或特定運算式的剔除條件,訊息資料124則記錄有特定運算式檢核不通過的錯誤訊息資訊。
The
檢核模組110依電子裝置200傳入的請求檢核投保資料,首先比對投保資料中的商品資訊與主資料121,判斷出一或多檢核類別,再取得規則資料122中所述檢核類別下的至少一運算式,產生第一運算式列表。隨後,檢核模組110比對第一商品資訊與例外資料123,判斷第一運算式列表中是否有應剔除之運算式,若有則剔除之,得到第二運算式列表。此外,檢核模組110將商品資訊及第二運算式列表儲存於記憶體資料庫130。
The
接著,檢核模組110基於第二運算式列表中的運算式,對投保資料進行檢核,若有檢核未通過的運算式項目,檢核模組110基於該訊息資料124取得對應的錯誤訊息。
Then, the
最後,檢核模組110將檢核結果及錯誤訊息(若有)回傳予電子裝置200。
Finally, the
100:投保資料檢核系統 110:檢核模組 120:資料庫 121:主資料 122:規則資料 123:例外資料 124:訊息資料 130:記憶體資料庫 200:電子裝置100:Insurance information verification system 110: Check module 120:Database 121:Main data 122:Rule information 123:Exception data 124:Message data 130:Memory database 200:Electronic devices
圖1為本創作之投保資料檢核系統之結構圖。Figure 1 is a structural diagram of the insurance information checking system of this creation.
100:投保資料檢核系統 100:Insurance information verification system
110:檢核模組 110: Check module
120:資料庫 120:Database
121:主資料 121:Main data
122:規則資料 122:Rule information
123:例外資料 123:Exception data
124:訊息資料 124:Message data
130:記憶體資料庫 130:Memory database
200:電子裝置 200:Electronic devices
Claims (6)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW112204411U TWM650648U (en) | 2023-05-08 | 2023-05-08 | Systems for verifying insurance application information |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW112204411U TWM650648U (en) | 2023-05-08 | 2023-05-08 | Systems for verifying insurance application information |
Publications (1)
Publication Number | Publication Date |
---|---|
TWM650648U true TWM650648U (en) | 2024-01-21 |
Family
ID=90456121
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
TW112204411U TWM650648U (en) | 2023-05-08 | 2023-05-08 | Systems for verifying insurance application information |
Country Status (1)
Country | Link |
---|---|
TW (1) | TWM650648U (en) |
-
2023
- 2023-05-08 TW TW112204411U patent/TWM650648U/en unknown
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10153939B2 (en) | Real time event capture, analysis and reporting system | |
WO2016004813A1 (en) | Data storage method, query method and device | |
US8572134B2 (en) | Transforming and storing messages in a database | |
US10158737B2 (en) | Real time event capture and analysis of transient data for an information network | |
CN107292365B (en) | Method, device and equipment for binding commodity label and computer readable storage medium | |
CN102541918A (en) | Method and equipment for identifying repeated information | |
SG186687A1 (en) | Methods and systems for implementing approximate string matching within a database | |
US9292579B2 (en) | Method and system for document data extraction template management | |
US10503750B2 (en) | Real time event capture and transformation of transient data for an information network | |
WO2019051945A1 (en) | Insurance data checking method and apparatus, computer device, and storage medium | |
CN112989791B (en) | Method, system and medium for de-duplication based on text information extraction result | |
US20220229854A1 (en) | Constructing ground truth when classifying data | |
CN112214508A (en) | Data processing method and device | |
CN111815457A (en) | Target object evaluation method and device | |
CN115544991A (en) | Report generation method, device, equipment, medium and program product | |
CN116860856A (en) | Financial data processing method and device, computer equipment and storage medium | |
CN109947797B (en) | Data inspection device and method | |
TWM650648U (en) | Systems for verifying insurance application information | |
US20140046857A1 (en) | System, Method, and Software for Enterprise-Wide Complaint Aggregation | |
US8805795B2 (en) | Identifying duplicate messages in a database | |
CN113609407B (en) | Regional consistency verification method and device | |
CN104318375A (en) | Small supermarket commodity information management system | |
CN111652660A (en) | Advertisement management system and advertisement promotion method | |
CN115115433B (en) | Order data processing method, device, computer equipment and storage medium | |
US20220188838A1 (en) | Automatically monitoring and reporting campaign financial transactions |