Reinsurance policy data processing method, device, electronic device and storage medium
By screening and summarizing the initial reinsurance data table, adding target fields, and forming a target reinsurance data table, the problem of long reinsurance policy data screening time in the big data architecture system was solved, and more efficient data processing was achieved.
Patent Information
- Application Number
- CN202411712620.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-26
- Publication Date
- 2025-09-30
- Estimated Expiration
- 2044-11-26
AI Technical Summary
In a big data architecture system, the screening time for reinsurance policy data is long, resulting in low screening efficiency.
By filtering and summarizing the initial reinsurance data table, adding target fields, and adding target data to the initial reinsurance data table, a target reinsurance data table is formed, reducing cross-field data scanning.
It improves the efficiency of screening reinsurance policy data, reduces screening time, and increases the speed of data processing.
Smart Images

Figure CN119477570B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a method, device, electronic device, and storage medium for processing reinsurance policy data. Background Art
[0002] Reinsurance, also known as ceding, refers to the transfer of some of the risks and liabilities underwritten by an insurer to another insurer through the signing of a reinsurance policy, based on an insurance contract. Reinsurance policies contain a large amount of data (i.e., reinsurance policy data), such as the insurance contract's policy number, primary and secondary policy number, and policy type number. Currently, reinsurance policy data is typically processed in Oracle databases. To reduce operational and software costs and improve system scalability, shifting reinsurance policy data processing to big data architecture systems has become a new technological trend. However, the reinsurance policy data stored in big data architecture systems typically lacks indexes. Therefore, before performing operations on the reinsurance policy data, all reinsurance policy data must be scanned to filter out the target reinsurance policy data. This process takes a long time and results in low efficiency when filtering out the target reinsurance policy data. Summary of the Invention
[0003] The main purpose of the embodiments of the present application is to provide a reinsurance policy data processing method, apparatus, electronic device, and storage medium, which can obtain a target reinsurance data table by processing an initial reinsurance data table, thereby reducing the time required for subsequent screening of reinsurance policy data and improving the efficiency of screening reinsurance policy data.
[0004] To achieve the above objectives, a first aspect of an embodiment of the present application provides a method for processing reinsurance policy data, the method comprising:
[0005] Obtaining an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values of a plurality of fields;
[0006] screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field;
[0007] Aggregating the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values of a plurality of fields in the data of the plurality of first target insurance policies;
[0008] A target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table.
[0009] In some embodiments, after adding the target data to the target field corresponding to the row containing the data of the first target policy in the initial reinsurance data table to obtain the target reinsurance data table, the method further includes:
[0010] Acquire a second screening rule, where the second screening rule includes a second field among the multiple fields and a field value of the second field;
[0011] screening the target reinsurance data table according to the second screening rule to obtain data of a second target insurance policy;
[0012] Obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table;
[0013] Determining a target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table;
[0014] According to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.
[0015] In some embodiments, when the target operation rule adopts the first operation rule, the target operation rule includes a fourth field among the multiple fields;
[0016] The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target policy is located to obtain the reinsurance data corresponding to the second target policy includes:
[0017] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target policy is located is screened to obtain a first screening result, where the first screening result is determined based on the field value of the fourth field in the data of the second target policy;
[0018] Obtaining a target operation value based on the data arrangement order of the field value of the target field and the first screening result;
[0019] The target operation values are added to obtain reinsurance data corresponding to the second target insurance policy.
[0020] In some embodiments, when the target operation rule adopts the second operation rule, the target operation rule includes a fifth field among the multiple fields;
[0021] The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target policy is located to obtain the reinsurance data corresponding to the second target policy includes:
[0022] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a second screening result, where the second screening result is determined based on the field value of the fifth field in the data of the second target insurance policy;
[0023] Based on the data arrangement order of the field values of the target field, the reinsurance data corresponding to the second target policy is determined according to the second screening result, and the data arrangement order is determined according to the arrangement order of the plurality of the fields in the initial reinsurance data table.
[0024] In some embodiments, when the second field is the same as the first field, obtaining the field value of the target field corresponding to the row containing the data of the second target policy from the target reinsurance data table includes:
[0025] If the number of the second target policy is one, obtaining the field value of the target field corresponding to the row where the data of the second target policy is located in the target reinsurance data table;
[0026] If there are multiple second target policies, the field values of the target fields corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain the field value of the target field corresponding to the row where the data of one second target policy is located.
[0027] In some embodiments, determining the target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table includes:
[0028] Match the field value of the third field in the data of the second target policy with multiple preset field values in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values and the operation rule corresponding to each preset field value.
[0029] In some embodiments, the third field includes a policy type number field and a contract number field, the preset field value includes a preset policy type number and a preset contract number, and matching the field value of the third field in the data of the second target insurance policy with a plurality of preset field values in the algorithm configuration table to obtain a target operation rule corresponding to the field value of the third field in the data of the second target insurance policy includes:
[0030] Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule;
[0031] The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.
[0032] To achieve the above-mentioned objective, a second aspect of an embodiment of the present application provides a reinsurance policy data processing device, the device comprising:
[0033] an acquisition module, configured to acquire an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values of a plurality of fields;
[0034] a data screening module, configured to screen the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field;
[0035] a data aggregation module, configured to aggregate the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values of a plurality of fields in the data of the plurality of first target insurance policies;
[0036] The processing module is configured to add a target field to the initial reinsurance data table, and add the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table.
[0037] To achieve the above-mentioned objective, a third aspect of an embodiment of the present application provides an electronic device, comprising a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the reinsurance policy data processing method described in the first aspect is implemented.
[0038] To achieve the above-mentioned objective, a fourth aspect of embodiments of the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program. When the computer program is executed by a processor, the reinsurance policy data processing method described in the first aspect is implemented.
[0039] The present invention proposes a reinsurance policy data processing method, device, electronic device, and storage medium. The method obtains an initial reinsurance data table containing data on multiple reinsurance policies, then filters the initial reinsurance data table according to a first filtering rule to obtain data on multiple first target policies. The data on the multiple first target policies are then aggregated to obtain target data. Finally, a target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row containing the data on the first target policy in the initial reinsurance data table, thereby obtaining a target reinsurance data table. The present invention also filters the initial reinsurance data table according to the first filtering rule to obtain data on multiple first target policies that meet the first filtering rule, and aggregates the data on the multiple first target policies into the target field corresponding to the row containing the data on the newly added first target policy, thereby obtaining a target reinsurance data table. Thus, when operations are required based on the reinsurance policy data stored in the target reinsurance data table, the target field can be directly scanned, reducing cross-field data scanning, thereby reducing the time required to filter reinsurance policy data and improving the efficiency of reinsurance policy data filtering. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 is a flow chart of a method for processing reinsurance policy data provided by an embodiment of the present application;
[0041] Figure 2 is another flow chart of the reinsurance policy data processing method provided in an embodiment of the present application;
[0042] Figure 3 yes Figure 2 A flowchart of step S209 in FIG.
[0043] Figure 4 yes Figure 2 Another flowchart of step S209 in FIG.
[0044] Figure 5 This is a schematic diagram of the structure of the reinsurance policy data processing device provided in an embodiment of the present application;
[0045] Figure 6 This is a schematic diagram of the hardware structure of the electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0046] In order to make the purpose, technical solutions and advantages of this application more clear, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain this application and are not intended to limit this application.
[0047] It should be noted that although the device schematics illustrate functional module divisions and the flowcharts illustrate logical sequences, in certain circumstances, the steps shown or described may be performed in a sequence that differs from the module divisions in the device or the sequence in the flowcharts. The terms "first," "second," and so on, in the specification, claims, and drawings, are used to distinguish similar items and are not necessarily used to describe a specific sequence or precedence.
[0048] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the art to which this application pertains. The terms used herein are for the purpose of describing the embodiments of this application only and are not intended to limit this application.
[0049] First, let’s analyze some of the terms used in this application:
[0050] Reinsurance: Also known as ceding, it means that an insurer transfers part of the risks and liabilities it insures to other insurers by signing a reinsurance policy based on the insurance contract.
[0051] A data table is a structure used to store and organize data, consisting of rows and columns. Each row represents a separate record or entity, and each column represents a specific attribute or characteristic. This structured approach to rows and columns makes data easy to store, retrieve, and manage.
[0052] Field: A field is a column in a data table that stores a specific type of data. Each field has a unique name (field name) and a data type (such as integer, text, or date) that describes the nature of the data stored in the field. Fields can also contain properties such as field width (maximum storage length), default value, and whether nulls are allowed.
[0053] To solve the problems of the prior art, embodiments of the present application provide a method, apparatus, electronic device, and storage medium for processing reinsurance policy data, aiming to improve the processing efficiency of reinsurance data.
[0054] The reinsurance policy data processing method, device, electronic device, and storage medium provided in the embodiments of the present application are specifically described through the following embodiments. First, the reinsurance policy data processing method in the embodiments of the present application is described.
[0055] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Artificial intelligence (AI) refers to the theories, methods, technologies, and application systems that use digital computers or machines controlled by digital computers to simulate, extend, and expand human intelligence, perceive the environment, acquire knowledge, and use that knowledge to achieve optimal results.
[0056] Fundamental AI technologies generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing, operating / interaction systems, and mechatronics. AI software technologies primarily encompass computer vision, robotics, biometrics, speech processing, natural language processing, and machine learning / deep learning.
[0057] The reinsurance policy data processing method provided in the embodiments of the present application relates to the field of data processing technology. The reinsurance policy data processing method provided in the embodiments of the present application can be applied in a terminal, can also be applied in a server, and can also be software running in a terminal or a server. In some embodiments, the terminal can be a smart phone, tablet computer, laptop computer, desktop computer, etc.; the server can be configured as an independent physical server, or as a server cluster or distributed system composed of multiple physical servers, or as a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can be an application that implements the reinsurance policy data processing method, etc., but is not limited to the above forms.
[0058] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, and the like. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, and the like that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments in which tasks are performed by remote processing devices connected via a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media, including storage devices.
[0059] It should be noted that in each specific embodiment of the present application, when it comes to the need to perform relevant processing based on data related to the user's identity or characteristics, such as user information, user behavior data, user historical data, and user location information, the user's permission or consent will be obtained first, and the collection, use, and processing of such data will comply with relevant laws, regulations, and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or by jumping to a confirmation page. After clearly obtaining the user's separate permission or consent, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.
[0060] Figure 1 This is a flow chart of a method for processing reinsurance policy data provided by an embodiment of the present application. Figure 1 The method may include but is not limited to steps S101 to S104.
[0061] Step S101: obtaining an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values of a plurality of fields.
[0062] The initial reinsurance data table is a data table used to store data for multiple reinsurance policies. Each insurance contract can include at least one insurance product (such as critical illness, accident, and medical), and each insurance product has multiple liability clauses. Based on this, a reinsurance policy can be signed for each insurance product in each insurance contract. Furthermore, based on the liability clause numbers corresponding to the liability clauses under each insurance product, the reinsurance policy data corresponding to each insurance product can be split into multiple rows. The data for each split reinsurance policy is then stored in separate rows in the initial reinsurance data table, thereby generating the initial reinsurance data table. In this way, the electronic device can obtain an initial reinsurance data table containing data for multiple reinsurance policies. Furthermore, the data for each reinsurance policy includes field values for multiple fields. Exemplarily, the multiple fields may include a policy number field (used to store the identifier of the insurance product, i.e., the policy number), a main supplementary contract number field (used to store the identifier of the main contract of the insurance contract and the identifier of the supplementary contract of the insurance contract, i.e., the main supplementary contract number), a liability field (used to store the liability clause number corresponding to the liability clause in the insurance contract), a contract number field (used to store the identifier of the reinsurance policy, i.e., the contract number), a policy number field (used to store the identifier of the insurance contract, i.e., the policy number), a retention amount field (used to store the liability limit data that the original insurer should bear in the reinsurance policy) and a risk coverage amount field (used to store the maximum liability amount that the insurer should bear in the insurance contract), etc.
[0063] Step S102 , screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field.
[0064] According to a first screening rule, the electronic device can screen the initial reinsurance data table to obtain data for multiple first target policies. The first screening rule includes a first field from multiple fields and a field value of the first field. The first field can be any one of the multiple fields, or any multiple fields. The number of fields is not limited and can be adjusted based on actual business needs. For example, assuming that the first field is the customer number field and the field value of the customer number field is C01, then the data of reinsurance policies with a field value of C01 in the customer number field can be screened from the initial reinsurance data table, i.e., the data of the first target policies. Alternatively, assuming that the first field is the policy number field and the field value of the policy number field is A01, then the data of reinsurance policies with a field value of A01 in the policy number field can be screened from the initial reinsurance data table, i.e., the data of the first target policies.
[0065] Step S103: Aggregate the data of the multiple first target insurance policies to obtain target data, where the target data includes field values of multiple fields in the data of the multiple first target insurance policies.
[0066] After obtaining the data of multiple first target insurance policies, the electronic device can aggregate the data of the multiple first target insurance policies to obtain the target data. It can be understood that the target data is a collection of the data of multiple first target insurance policies, including the field values of multiple fields in the data of multiple first target insurance policies. It should be noted that when aggregating the data of multiple first target insurance policies, the data of multiple first target insurance policies are separated by a first preset symbol to distinguish the data of different first target insurance policies. In addition, for the data of each first target insurance policy, the field values of multiple fields in the data of each first target insurance policy are separated by a second preset symbol to distinguish the field values of different fields. The first preset symbol and the second preset symbol are determined according to actual conditions, and the two use different symbols. For example, the first preset symbol can be a semicolon, and the second preset symbol can be a comma.
[0067] Step S104 , a target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table.
[0068] The electronic device can add a new target field to the initial reinsurance data table. The number of target fields is the same as the number of fields included in the first field. That is, if there are two first fields, the number of newly added target fields is also two, to store data for multiple first target policies filtered based on each first field. After adding the target field, the target data can be added to the target field corresponding to the row containing the data for the first target policy in the initial reinsurance data table, thereby generating the target reinsurance data table.
[0069] In steps S101 to S104 of the embodiment of the present application, an initial reinsurance data table including data of multiple reinsurance policies is obtained, and then the initial reinsurance data table is filtered according to a first filtering rule to obtain data of multiple first target policies. The data of the multiple first target policies are then aggregated to obtain target data. Finally, a target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row containing the data of the first target policy in the initial reinsurance data table, thereby obtaining a target reinsurance data table. In the present application, the initial reinsurance data table is filtered according to the first filtering rule to obtain data of multiple first target policies that meet the first filtering rule, and the data of the multiple first target policies are aggregated into the target field corresponding to the row containing the data of the newly added first target policy, thereby obtaining a target reinsurance data table. In this way, when it is necessary to perform operations based on the data of the reinsurance policies stored in the target reinsurance data table, the target field can be directly scanned, thereby reducing the need to scan data across fields, thereby reducing the time required to filter the reinsurance policy data, and improving the efficiency of filtering the reinsurance policy data.
[0070] Figure 2 is another flow chart of the reinsurance policy data processing method provided in an embodiment of the present application. Figure 2 The method may include but is not limited to steps S201 to S209, wherein:
[0071] Step S201: obtaining an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values of a plurality of fields.
[0072] Step S202 , screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field.
[0073] Step S203: Aggregate the data of the multiple first target insurance policies to obtain target data, where the target data includes field values of multiple fields in the data of the multiple first target insurance policies.
[0074] Step S204 , a target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row of the data of the first target policy in the initial reinsurance data table, to obtain a target reinsurance data table.
[0075] The above steps S201 to S204 may be specifically referred to steps S101 to S104 and will not be described in detail here.
[0076] Step S205: obtaining a second screening rule, where the second screening rule includes a second field among the multiple fields and a field value of the second field;
[0077] Step S206: screening the target reinsurance data table according to the second screening rule to obtain data of the second target policy;
[0078] Step S207, obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table;
[0079] Step S208, determining a target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table;
[0080] Step S209, according to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain the reinsurance data corresponding to the second target insurance policy.
[0081] After processing the initial reinsurance data table and obtaining the target reinsurance data table, operations can be performed based on the field values of the target fields in the target reinsurance data table to obtain the reinsurance data corresponding to the reinsurance policy. It should be noted that the reinsurance data here refers to the risk coverage or retention amount calculated according to the target operation rules. Specifically, the electronic device can filter the target reinsurance data table according to a second screening rule to obtain data for a second target policy, i.e., the data for the reinsurance policy requiring reinsurance data calculation. The second screening rule is determined based on business needs and includes a second field from multiple fields, such as a customer number field, a policy number field, a retention amount field, etc., as well as the field value of the second field. Furthermore, the number of second fields is not limited and can be any one of the multiple fields or any multiple fields.
[0082] Subsequently, based on the data of the second target policy, the target field corresponding to the row containing the data of the second target policy in the target reinsurance data table can be determined, and the field value of the target field corresponding to the row containing the data of the second target policy can be obtained. Furthermore, based on actual business needs, the electronic device can pre-build an algorithm configuration table. For example, the algorithm configuration table can consist of a preset field value field (for storing the preset field value) and an operation rule field (for storing the operation rule). The number of preset field value fields can be multiple. For example, the algorithm configuration table can be a data table consisting of a preset insurance type number field, a preset contract number field, and an operation rule field. Alternatively, the algorithm configuration table can also consist of a preset insurance type number field, a preset contract number field, an operation rule field, and an algorithm number field. Thus, based on the data of the second target policy, the electronic device can obtain the field value of the third field in the data of the second target policy. Then, based on the field value of the third field in the data of the second target policy and the algorithm configuration table, determine the operation rule corresponding to the field value of the third field in the data of the second target policy, i.e., the target operation rule. According to the target operation rules, the electronic device can perform calculations based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.
[0083] Through the above-mentioned method, the electronic device can directly scan the field value of the target field corresponding to the row where the data of the second target insurance policy is located, and obtain the data required to calculate the reinsurance data according to the target operation rules, thereby reducing the scanning of cross-field data, improving the data screening efficiency, and thereby improving the calculation speed of the reinsurance data.
[0084] In some embodiments, when the second field is the same as the first field, obtaining the field value of the target field corresponding to the row containing the data of the second target policy from the target reinsurance data table includes:
[0085] If the number of the second target policy is one, obtaining the field value of the target field corresponding to the row where the data of the second target policy is located in the target reinsurance data table;
[0086] If there are multiple second target policies, the field values of the target fields corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain the field value of the target field corresponding to the row where the data of one second target policy is located.
[0087] When obtaining the target field value corresponding to the row containing the data of the second target policy from the target reinsurance data table, if the second field (i.e., the field included in the second screening rule) is the same as the first field (i.e., the field included in the first screening rule), and there are multiple second target policies, the target field values corresponding to the rows containing the data of multiple second target policies can be screened out, and the target field values corresponding to the rows containing the data of multiple second target policies are the same. To reduce the possibility of repeated processing of the same data and reduce computational costs, the target field values corresponding to the rows containing the data of multiple second target policies can be deduplicated, retaining only the target field value corresponding to the row containing the data of one second target policy. Subsequently, based on the target field value corresponding to the row containing the data of the retained second target policy, computations are performed on the reinsurance data corresponding to the multiple second target policies. If there is only one second target policy, the target field value corresponding to the row containing the data of the second target policy in the target reinsurance data table is obtained without deduplication.
[0088] In some embodiments, determining the target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table includes:
[0089] Match the field value of the third field in the data of the second target policy with multiple preset field values in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values and the operation rule corresponding to each preset field value.
[0090] The electronic device can determine a target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table. The algorithm configuration table includes multiple preset field values and an operation rule corresponding to each preset field value. Specifically, the field value of the third field in the data of the second target insurance policy can be matched with the multiple preset field values in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target insurance policy. For example, the multiple preset field values include at least one preset insurance type number. For example, assuming that the field value of the third field is 123 in the data of the second target insurance policy, the field value of the insurance type number field in the data of the second target insurance policy is 123. In this case, the field value 123 of the insurance type number field in the data of the second target insurance policy can be matched with the preset insurance type number in the algorithm configuration table, and the operation rule corresponding to the successfully matched preset insurance type number can be determined as the target operation rule. In this way, the target operation rule can be determined so that the field value of the target field corresponding to the row of the data of the second target insurance policy can be subsequently operated according to the target operation rule.
[0091] In some embodiments, the third field includes a policy type number field and a contract number field, the preset field value includes a preset policy type number and a preset contract number, and matching the field value of the third field in the data of the second target insurance policy with a plurality of preset field values in the algorithm configuration table to obtain a target operation rule corresponding to the field value of the third field in the data of the second target insurance policy includes:
[0092] Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule;
[0093] The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.
[0094] When the third field includes a policy type number field and a contract number field, and the preset field value includes the preset policy type number and the preset contract number, the electronic device may first match the field value of the policy type number field in the data of the second target policy with multiple preset policy type numbers in the algorithm configuration table, and determine the operation rule corresponding to the successfully matched preset policy type number as the initial operation rule. Furthermore, the field value of the contract number field in the data of the second target policy may be matched with the preset contract number corresponding to the initial operation rule, and the successfully matched initial operation rule may be determined as the target operation rule. For example, assuming that the field value of the policy type number field in the data of the second target policy is 123 and the field value of the contract number field in the data of the second target policy is S01, the field value of the policy type number field in the data of the second target policy may be matched with multiple preset policy type numbers in the algorithm configuration table, and the operation rule corresponding to the successfully matched preset policy type number may be determined as the initial operation rule. For example, the initial operation rule may include an operation rule with an algorithm number CA01, an operation rule with an algorithm number CA02, and an operation rule with an algorithm number CA03. The electronic device can further match the field value S01 of the contract number field in the data of the second target insurance policy with the preset contract number corresponding to the initial operation rule (including the preset contract number S01 corresponding to the operation rule with algorithm number CA01, the preset contract number S02 corresponding to the operation rule with algorithm number CA02, and the preset contract number S03 corresponding to the operation rule with algorithm number CA03). At this time, it can be determined that the field value of the contract number field in the data of the second target insurance policy successfully matches the operation rule with algorithm number CA01, and then the operation rule is determined as the target operation rule.
[0095] Furthermore, when determining the target operation rules, the matching order is not limited to the aforementioned order and can be adjusted based on actual circumstances. For example, the field value of the contract number field in the second target policy's data can be matched with multiple preset contract numbers in the algorithm configuration table to obtain the initial operation rules. The field value of the insurance type number field in the second target policy's data can then be matched with the preset insurance type numbers corresponding to the initial operation rules to determine the target operation rules. Furthermore, the third field is not limited to the insurance type number field or the contract number field and can be adjusted, but the third field must match the preset field value in the algorithm configuration table.
[0096] Figure 3 yes Figure 2 For a flow chart of step S209 in Figure 3 In some embodiments, when the target operation rule adopts the first operation rule, the target operation rule includes a fourth field among the multiple fields;
[0097] Step S209, performing calculation according to the target operation rule and the field value of the target field corresponding to the row where the data of the second target policy is located, to obtain reinsurance data corresponding to the second target policy, includes:
[0098] Step S301: Filter the field value of the target field corresponding to the row containing the data of the second target policy according to the target operation rule to obtain a first filtering result, wherein the first filtering result is determined based on the field value of the fourth field in the data of the second target policy;
[0099] Step S302, obtaining a target operation value based on the data arrangement order of the field value of the target field and the first screening result;
[0100] Step S303: Add the target operation values to obtain reinsurance data corresponding to the second target policy.
[0101] The operation rules include the first operation rules. If the target operation rules adopt the first operation rules, the target operation rules at this time include the fourth field and the specific operation method. Therefore, according to the field value of the fourth field in the data of the second target policy, the field value of the target field corresponding to the row where the data of the second target policy is located can be filtered to obtain the first filtering result, and based on the data arrangement order of the field value of the target field and the first filtering result, the target operation value can be obtained. By adding the target operation values, the reinsurance data corresponding to the second target policy can be obtained. It should be noted that the data arrangement order of the field value of the target field mentioned here refers to the arrangement order between the multiple specific data contained in the field value of the target field.
[0102] For example, the first operation rule can be divided into a first sub-rule, a second sub-rule, and a third sub-rule. The first sub-rule is a rule for accumulating the retention amounts in the data of reinsurance policies with the same customer number and contract number, and using the accumulated result as the reinsurance data corresponding to the second target policy. The second sub-rule is a rule for accumulating the risk coverage in the data of reinsurance policies with the same customer number and liability clause number, and using the accumulated result as the reinsurance data corresponding to the second target policy. The third sub-rule is a rule for accumulating the retention amounts in the data of reinsurance policies with the same policy number and a pre-set primary rider number, and using the accumulated result as the reinsurance data corresponding to the second target policy. If the target operation rule adopts the first sub-rule, at this time, the fourth field includes the customer number field and the contract number field. In this way, based on the field value of the customer number field in the data of the second target policy (for example, C01) and the field value of the contract number field in the data of the second target policy (for example, S01), the data of the reinsurance policy containing both C01 and S01 can be obtained from the field value of the target field corresponding to the row where the data of the second target policy is located, and then the retention amount in the data of the reinsurance policy containing both C01 and S01 can be extracted as the target operation value.
[0103] Because after the reinsurance policy data is aggregated into the target field, it's impossible to distinguish which field value each specific data point represents within the reinsurance policy data. Therefore, the electronic device can pre-determine the data sorting order based on the order in which the multiple fields are arranged in the initial reinsurance data table. For example, in the initial reinsurance data table, the multiple fields are arranged in the order of policy number, customer number, primary and secondary policy number, policy type number, contract number, liability clause number, risk coverage, and retention amount. Based on this field sorting order, the electronic device can determine the data sorting order as follows: policy number, customer number, primary and secondary policy number, policy type number, contract number, liability clause number, risk coverage, and retention amount. Thus, based on the data sorting order, after determining the data for reinsurance policies that contain both C01 and S01, the position of the retention amount within the reinsurance policy data can be determined based on the position of C01 and S01 within the reinsurance policy data. This allows the electronic device to obtain the retention amount, i.e., the target calculated value, for all reinsurance policy data containing both C01 and S01.
[0104] In this way, when the target operation rule adopts the first operation rule, calculation can be performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.
[0105] Figure 4 yes Figure 2 For another flowchart of step S209, please refer to Figure 4In some embodiments, when the target operation rule adopts the second operation rule, the target operation rule includes a fifth field among the multiple fields;
[0106] Step S209, performing calculation according to the target operation rule and the field value of the target field corresponding to the row where the data of the second target policy is located, to obtain reinsurance data corresponding to the second target policy, includes:
[0107] Step S401: Filter the field value of the target field corresponding to the row containing the data of the second target policy according to the target operation rule to obtain a second filtering result, wherein the second filtering result is determined based on the field value of the fifth field in the data of the second target policy;
[0108] Step S402 , based on the data arrangement order of the field values of the target field and according to the second screening result, the reinsurance data corresponding to the second target policy is determined, wherein the data arrangement order is determined according to the arrangement order of the plurality of the fields in the initial reinsurance data table.
[0109] The operation rules include the second operation rules. When the target operation rules adopt the second operation rules, the target operation rules include the fifth field and the specific operation method. Therefore, according to the field value of the fifth and fourth fields in the data of the second target insurance policy, the field value of the target field corresponding to the row where the data of the second target insurance policy is located can be filtered to obtain the second filtering result, and based on the data arrangement order of the field value of the target field and the second filtering result, the reinsurance data corresponding to the second target insurance policy can be obtained. It should be noted that the data arrangement order of the field value of the target field mentioned here refers to the arrangement order between the multiple specific data contained in the field value of the target field.
[0110] Exemplarily, the second operation rule can be divided into a fourth sub-rule and a fifth sub-rule. The fourth sub-rule refers to a rule that takes the risk coverage in the data of the reinsurance policy with the same policy number, the same insurance type number, different contract number, and the smallest liability share stipulated in the liability clause corresponding to the liability clause number, and uses the risk coverage as the reinsurance data corresponding to the second target policy. The fifth sub-rule refers to a rule that takes the retention in the data of the second target policy as the reinsurance data corresponding to the second target policy. If the target operation rule adopts the fourth sub-rule, then the fifth field includes the policy number field, the insurance type number field, and the contract number field. Thus, based on the field value of the policy number field in the data of the second target policy (e.g., A01), the field value of the insurance type number field in the data of the second target policy (e.g., 123), and the field value of the contract number field in the data of the second target policy (e.g., S01), the field value of the target field corresponding to the row where the data of the second target policy is located can be obtained that contains both A01 and 123 but does not contain S01. If there are multiple reinsurance policy data that contain A01 and 123 but do not contain S01, compare the field values of the liability fields in the multiple reinsurance policy data that contain A01 and 123 but do not contain S01 to determine the reinsurance policy data with the smallest agreed liability share among the multiple reinsurance policy data that contain A01 and 123 but do not contain S01, and then determine the risk insurance amount in the data of the reinsurance policy with the smallest agreed liability share as the reinsurance data corresponding to the second target policy.
[0111] Furthermore, since after the reinsurance policy data is aggregated into the target field, it's impossible to distinguish which field value within the reinsurance policy data each specific data item represents, the electronic device can pre-determine the data sorting order based on the order in which the multiple fields are arranged in the initial reinsurance data table. For example, in the initial reinsurance data table, the multiple fields are arranged in the order of policy number, customer number, primary and secondary policy number, policy type number, contract number, liability clause number, risk coverage, and retention amount. Based on this field sorting order, the electronic device can determine the data sorting order as follows: policy number, customer number, primary and secondary policy number, policy type number, contract number, liability clause number, risk coverage, and retention amount. Thus, based on the data sorting order, after determining the reinsurance policy data that contains both A01 and 123 but not S01, the position of the liability clause number within the reinsurance policy data and the position of the risk coverage within the reinsurance policy data can be determined based on the positions of A01 and 123 within the reinsurance policy data.
[0112] In this way, when the target operation rule adopts the second operation rule, calculation can be performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.
[0113] Figure 5 This is a schematic diagram of the structure of the reinsurance policy data processing device provided in the embodiment of the present application. Figure 5 The embodiment of the present application further provides a reinsurance policy data processing device 500, which can implement the above reinsurance policy data processing method. The device 500 includes:
[0114] An acquisition module 501 is configured to acquire an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values of a plurality of fields;
[0115] a data screening module 502 configured to screen the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field;
[0116] A data aggregation module 503 is configured to aggregate the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values of a plurality of fields in the data of the plurality of first target insurance policies;
[0117] The processing module 504 is configured to add a target field to the initial reinsurance data table, and add the target data to the target field corresponding to the row containing the data of the first target policy in the initial reinsurance data table, to obtain a target reinsurance data table.
[0118] In some embodiments, the reinsurance policy data processing device 500 further includes a computing module configured to:
[0119] Acquire a second screening rule, where the second screening rule includes a second field among the multiple fields and a field value of the second field;
[0120] screening the target reinsurance data table according to the second screening rule to obtain data of a second target insurance policy;
[0121] Obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table;
[0122] Determining a target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table;
[0123] According to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.
[0124] In some embodiments, the computing module is further configured to:
[0125] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target policy is located is screened to obtain a first screening result, where the first screening result is determined based on the field value of the fourth field in the data of the second target policy;
[0126] Obtaining a target operation value based on the data arrangement order of the field value of the target field and the first screening result;
[0127] The target operation values are added to obtain reinsurance data corresponding to the second target insurance policy.
[0128] In some embodiments, the computing module is further configured to:
[0129] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a second screening result, where the second screening result is determined based on the field value of the fifth field in the data of the second target insurance policy;
[0130] The reinsurance data is determined according to the second screening result based on the data arrangement order of the field values of the target field, wherein the data arrangement order is determined according to the arrangement order of the plurality of fields in the initial reinsurance data table.
[0131] In some embodiments, the computing module is further configured to:
[0132] If the number of the second target policy is one, obtaining the field value of the target field corresponding to the row where the data of the second target policy is located in the target reinsurance data table;
[0133] If there are multiple second target policies, the field values of the target fields corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain the field value of the target field corresponding to the row where the data of one second target policy is located.
[0134] In some embodiments, the computing module is further configured to:
[0135] Match the field value of the third field in the data of the second target policy with multiple preset field values in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values and the operation rule corresponding to each preset field value.
[0136] In some embodiments, the computing module is further configured to:
[0137] Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule;
[0138] The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.
[0139] The specific implementation of the reinsurance policy data processing device 500 is substantially the same as the specific embodiment of the reinsurance policy data processing method described above, and will not be described in detail herein.
[0140] An embodiment of the present application further provides an electronic device comprising a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the aforementioned reinsurance policy data processing method. The electronic device can be any smart terminal, including a tablet computer and an in-vehicle computer.
[0141] Figure 6 This is a hardware structure diagram of the electronic device provided in the embodiment of the present application. Figure 6 . Electronic equipment includes:
[0142] The processor 601 may be implemented as a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is configured to execute relevant programs to implement the technical solutions provided in the embodiments of the present application.
[0143] The memory 602 may be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 602 may store an operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program code is stored in the memory 602 and is called by the processor 601 to execute the reinsurance policy data processing method of the embodiments of this application.
[0144] Input / output interface 603, used to implement information input and output;
[0145] Communication interface 604, used to implement communication interaction between this device and other devices, which can be achieved through wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, Wi-Fi, Bluetooth, etc.);
[0146] Bus 605 , which transmits information between various components of the device (e.g., processor 601 , memory 602 , input / output interface 603 , and communication interface 604 );
[0147] The processor 601 , the memory 602 , the input / output interface 603 and the communication interface 604 are connected to each other in communication within the device via a bus 605 .
[0148] An embodiment of the present application further provides a computer-readable storage medium storing a computer program, which implements the above-mentioned reinsurance policy data processing method when executed by a processor.
[0149] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely arranged relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.
[0150] The present invention proposes a reinsurance policy data processing method, device, electronic device, and storage medium. The method obtains an initial reinsurance data table containing data on multiple reinsurance policies, then filters the initial reinsurance data table according to a first filtering rule to obtain data on multiple first target policies. The data on the multiple first target policies are then aggregated to obtain target data. Finally, a target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row containing the data on the first target policy in the initial reinsurance data table, thereby obtaining a target reinsurance data table. The present invention also filters the initial reinsurance data table according to the first filtering rule to obtain data on multiple first target policies that meet the first filtering rule, and aggregates the data on the multiple first target policies into the target field corresponding to the row containing the data on the newly added first target policy, thereby obtaining a target reinsurance data table. Thus, when operations are required based on the reinsurance policy data stored in the target reinsurance data table, the target field can be directly scanned, reducing cross-field data scanning, thereby reducing the time required to filter reinsurance policy data and improving the efficiency of reinsurance policy data filtering.
[0151] The embodiments described in the embodiments of this application are intended to more clearly illustrate the technical solutions of the embodiments of this application and do not constitute a limitation on the technical solutions provided by the embodiments of this application. Those skilled in the art will appreciate that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided in the embodiments of this application are also applicable to similar technical problems.
[0152] Those skilled in the art will understand that the technical solutions shown in the figures do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than shown in the figures, or a combination of certain steps, or different steps.
[0153] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, i.e., they may be located in one place or distributed across multiple network units. Some or all of the modules may be selected based on actual needs to achieve the objectives of this embodiment.
[0154] Those skilled in the art will appreciate that all or some of the steps in the methods, systems, and functional modules / units in the devices disclosed above may be implemented as software, firmware, hardware, or appropriate combinations thereof.
[0155] The terms "first", "second", "third", "fourth", etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.
[0156] It should be understood that in this application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following items" or similar expressions refers to any combination of these items, including any combination of single items or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.
[0157] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely schematic. For example, the division of the above-mentioned units is only a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.
[0158] The units described above as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0159] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing unit, or each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.
[0160] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including multiple instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of various embodiments of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), disk or optical disk, and other media that can store programs.
[0161] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but are not intended to limit the scope of the present invention. Any modifications, equivalent substitutions, and improvements made by those skilled in the art without departing from the scope and essence of the present invention should be within the scope of the present invention.
Claims
1. A method for processing reinsurance policy data, characterized in that: The method comprises: Obtaining an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values of a plurality of fields; screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field; Aggregating the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values of a plurality of fields in the data of the plurality of first target insurance policies; Adding a target field to the initial reinsurance data table, and adding the target data to the target field corresponding to the row of the data of the first target policy in the initial reinsurance data table, to obtain a target reinsurance data table; Acquire a second screening rule, where the second screening rule includes a second field among the multiple fields and a field value of the second field; screening the target reinsurance data table according to the second screening rule to obtain data of a second target insurance policy; Obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table; Determining a target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table; According to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.
2. The method according to claim 1, characterized in that In a case where the target operation rule adopts the first operation rule, the target operation rule includes a fourth field among the multiple fields; The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target policy is located to obtain the reinsurance data corresponding to the second target policy includes: According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target policy is located is screened to obtain a first screening result, where the first screening result is determined based on the field value of the fourth field in the data of the second target policy; Obtaining a target operation value based on the data arrangement order of the field value of the target field and the first screening result; The target operation values are added to obtain reinsurance data corresponding to the second target insurance policy.
3. The method according to claim 1, characterized in that In a case where the target operation rule adopts the second operation rule, the target operation rule includes a fifth field among the multiple fields; The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target policy is located to obtain the reinsurance data corresponding to the second target policy includes: According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a second screening result, where the second screening result is determined based on the field value of the fifth field in the data of the second target insurance policy; Based on the data arrangement order of the field values of the target field, the reinsurance data corresponding to the second target policy is determined according to the second screening result, and the data arrangement order is determined according to the arrangement order of the plurality of the fields in the initial reinsurance data table.
4. The method according to claim 1, wherein In the case where the second field is the same as the first field, obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table includes: If the number of the second target policy is one, obtaining the field value of the target field corresponding to the row where the data of the second target policy is located in the target reinsurance data table; If there are multiple second target policies, the field values of the target fields corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain the field value of the target field corresponding to the row where the data of one second target policy is located.
5. The method according to claim 1, characterized in that The determining of the target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table includes: Match the field value of the third field in the data of the second target policy with multiple preset field values in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values and the operation rule corresponding to each preset field value.
6. The method according to claim 5, characterized in that The third field includes a policy type number field and a contract number field, the preset field value includes a preset policy type number and a preset contract number, and matching the field value of the third field in the data of the second target insurance policy with a plurality of preset field values in the algorithm configuration table to obtain a target operation rule corresponding to the field value of the third field in the data of the second target insurance policy includes: Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule; The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.
7. A reinsurance policy data processing device, characterized in that: The device comprises: an acquisition module, configured to acquire an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values of a plurality of fields; a data screening module, configured to screen the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field; a data aggregation module, configured to aggregate the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values of a plurality of fields in the data of the plurality of first target insurance policies; A processing module is configured to add a target field to the initial reinsurance data table, and add the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table; Computational modules for: Acquire a second screening rule, where the second screening rule includes a second field among the multiple fields and a field value of the second field; screening the target reinsurance data table according to the second screening rule to obtain data of a second target insurance policy; Obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table; Determining a target operation rule based on the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table; According to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.
8. An electronic device, characterized in that: The electronic device includes a memory and a processor, the memory stores a computer program, and the processor implements the reinsurance policy data processing method according to any one of claims 1 to 6 when executing the computer program.
9. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the reinsurance policy data processing method according to any one of claims 1 to 6 is implemented.