Adjusting table processing method and system, electronic device and storage medium

Abstract

The application provides a kind of adjustment table processing method, system, electronic equipment and storage medium, including based on index library configuration adjustment table style and configuration adjustment table in each cell Index formula;Based on calculation dimension and adjustment table style, the style set and index formula set of target adjustment table are determined;Based on the style set and index formula set of target adjustment table, index linked list is constructed;Based on index linked list, the index value of each cell in target adjustment table under calculation dimension is calculated.It can support multi-dimensional and multi-data source performance cash flow and contract service marginal balance adjustment table and unexpired liability and occurred adjustment table The calculation and disclosure of claim adjustment table, fully reflect the changes of insurance contract book value;At the same time, the index calculation speed is accelerated by using linked list structure.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a method, system, electronic device, and storage medium for processing adjustment tables. Background Technology

[0002] In 2017, the International Accounting Standards Board (IASB) released IFRS 17, "Insurance Contracts," which aims to provide a unified standard for accounting for insurance business. This standard seeks to unify the accounting treatment of insurance contracts globally, accurately and completely reflect the financial position and operating results of insurance companies, and improve the comparability of financial statements in the insurance industry.

[0003] The standard requires companies to separately disclose reconciliation statements for unearned premium liabilities (or reinsurance recovery of unearned premium assets) and incurred claims liabilities (or reinsurance recovery of incurred claims assets) in the notes to the financial statements for both issued insurance contracts and ceded reinsurance contracts, to reflect information related to changes in the carrying amount of insurance contracts. For insurance contracts not using the premium allocation method, companies must separately disclose reconciliation statements for performance cash flows and contract service margin balances in the notes to reflect information related to changes in the carrying amount of insurance contracts. To accurately disclose changes in the carrying amount of insurance contracts, a complete and accurate measurement method for the multi-dimensional reconciliation of insurance contract balances is needed.

[0004] Therefore, there is an urgent need for a method to measure the multi-dimensional adjustment of insurance contract balances in order to disclose the changes in insurance contract balances. Summary of the Invention

[0005] In order to overcome the shortcomings of the prior art, the main objective of the present invention is to provide a method, system, electronic device and storage medium based on adjustment table processing to solve the above-mentioned technical problems of the prior art.

[0006] To achieve the above objectives, in a first aspect, the present invention provides a method for processing a baseline adjustment table, the method comprising:

[0007] Configure the adjustment table style based on the indicator library and configure the indicator formulas for each cell in the adjustment table;

[0008] Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table;

[0009] Construct an indicator linked list based on the style set and indicator formula set of the target adjustment table;

[0010] Based on the indicator linked list, calculate the indicator value of each cell in the target adjustment table under the calculation dimension.

[0011] In some embodiments, the adjustment table style is configured based on the indicator library and the indicator formulas of each cell in the adjustment table are configured.

[0012] Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table;

[0013] Construct an indicator linked list based on the style set and indicator formula set of the target adjustment table;

[0014] Based on the indicator linked list, calculate the indicator value of each cell in the target adjustment table under the calculation dimension.

[0015] In some embodiments, before constructing the style of the adjustment table based on the indicator library and configuring the indicator formulas for each cell in the adjustment table, the method further includes:

[0016] Based on the definition of insurance contract guidelines, indicator items that conform to the insurance contract guidelines are defined;

[0017] Each of the aforementioned indicator items is coded to generate a unique indicator code;

[0018] The indicator items and their corresponding indicator codes are stored in the indicator library.

[0019] In some embodiments, the step of constructing the style of the adjustment table based on the indicator library and configuring the indicator formulas for each cell in the adjustment table includes:

[0020] Based on the indicator items, indicator codes and the type of the adjustment table in the indicator library, the adjustment table styles are constructed respectively, wherein the adjustment table includes a first adjustment table and a second adjustment table.

[0021] The adjustment table format includes indicator items and their corresponding indicator codes and row and column numbers;

[0022] The indicator formula is determined based on the data source and applicable model of each cell in the adjustment table;

[0023] Each cell's indicator formula is configured with a corresponding formula executor.

[0024] In some embodiments, determining the set of styles and the set of indicator formulas for the target adjustment table based on the calculation dimension and the adjustment table style includes:

[0025] The calculation dimension is determined based on the input conditions, and the calculation dimension includes the calculation date, adjustment table type, applicable model, data source, business dimension, and time dimension;

[0026] Based on the adjustment table type and the adjustment table style, determine the set of target adjustment table styles and the set of indicator formulas corresponding to the calculation dimension;

[0027] The style set includes adjustment table type, indicator code, indicator item, and row and column number;

[0028] The set of formulas includes indicator codes, indicator formulas, and calculation order, with the calculation order set according to the row and column numbers.

[0029] In some embodiments, constructing an indicator linked list based on the style set and the indicator formula set of the target adjustment table includes:

[0030] The style set and the indicator formula set are associated based on the indicator code;

[0031] Extract the index items, index codes, and index formulas from the associated style set and index formula set, and use them as the numerical field of the index linked list.

[0032] The row and column numbers in the style set and the calculation order in the indicator formula set are integrated and used as reference variables in the indicator linked list.

[0033] In some embodiments, calculating the indicator value of each cell in the target adjustment table under the calculation dimension based on the indicator linked list includes:

[0034] According to the reference variables in the indicator chain, the indicator formula of the corresponding cell in the target adjustment table is obtained, and the corresponding formula executor is called to calculate the indicator value of the cell.

[0035] Secondly, this application provides a regulation table processing system, the system comprising:

[0036] The configuration module is used to configure the style of the adjustment table based on the indicator library and to configure the indicator formulas of each cell in the adjustment table.

[0037] The analysis module is used to determine the set of styles and the set of indicator formulas for the target adjustment table based on the calculation dimension and the adjustment table style.

[0038] The processing module is used to construct an indicator linked list based on the style set and the indicator formula set of the target adjustment table;

[0039] The calculation module is used to calculate the indicator value of each cell in the target adjustment table under the calculation dimension based on the indicator linked list.

[0040] Thirdly, this application provides an electronic device, the electronic device comprising:

[0041] One or more processors;

[0042] and a memory associated with the one or more processors, the memory being used to store program instructions that, when read and executed by the one or more processors, perform the following operations:

[0043] Configure the adjustment table style based on the indicator library and configure the indicator formulas for each cell in the adjustment table;

[0044] Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table;

[0045] Construct an indicator linked list based on the style set and indicator formula set of the target adjustment table;

[0046] Based on the indicator linked list, calculate the indicator value of each cell in the target adjustment table under the calculation dimension.

[0047] Fourthly, this application also provides a computer-readable storage medium storing a computer program that causes a computer to perform the following operations:

[0048] Configure the adjustment table style based on the indicator library and configure the indicator formulas for each cell in the adjustment table;

[0049] Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table;

[0050] Construct an indicator linked list based on the style set and indicator formula set of the target adjustment table;

[0051] Based on the indicator linked list, calculate the indicator value of each cell in the target adjustment table under the calculation dimension.

[0052] The beneficial effects achieved by this application are as follows:

[0053] This application provides a method for processing reconciliation tables, including configuring reconciliation table styles based on an indicator library and configuring indicator formulas for each cell within the reconciliation table; determining a set of styles and a set of indicator formulas for a target reconciliation table based on the calculation dimension and the reconciliation table style; constructing an indicator linked list based on the set of styles and the set of indicator formulas for the target reconciliation table; and calculating the indicator values ​​for each cell within the target reconciliation table under the calculation dimension based on the indicator linked list. It can support the calculation and disclosure of reconciliation tables for performance cash flows and contract service margin balances, as well as reconciliation tables for unearned premium liabilities and incurred claims, from multiple dimensions and multiple data sources. This application improves disclosure accuracy by flexibly configuring indicator formulas for indicator items according to data sources and applicable models, while also being compatible with multiple formula executors. Furthermore, this application uses a linked list structure to accelerate indicator calculation; this application can configure multiple business dimensions and time dimensions for the same measurement model, comprehensively reflecting various changes in the book value of insurance contracts. Attached Figure Description

[0054] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort, wherein:

[0055] Figure 1 This is a schematic diagram of the calculation process for the company-wide assessment cycle adjustment table provided in the embodiments of this application;

[0056] Figure 2 This is a schematic diagram of the index value calculation process provided in the embodiments of this application;

[0057] Figure 3 This is a schematic diagram of the assembly of the index linked list provided in the embodiments of this application;

[0058] Figure 4 This is a schematic diagram of the actuator calculation process provided in an embodiment of this application;

[0059] Figure 5 This is a schematic diagram of a general-purpose processor executor calculation provided in an embodiment of this application.

[0060] Figure 6 This is a flowchart of the adjustment table processing method provided in the embodiments of this application;

[0061] Figure 7 This is a schematic diagram of the adjustment table processing system provided in the embodiments of this application;

[0062] Figure 8 This is a structural diagram of an electronic device provided in an embodiment of this application. Detailed Implementation

[0063] To make the objectives, technical solutions, and advantages of this application clearer, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments in this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0064] It should be understood that, in the description of this application, unless the context explicitly requires it, the words "comprising," "including," and similar terms throughout the specification and claims should be interpreted as encompassing rather than being exclusive or exhaustive; that is, meaning "including but not limited to."

[0065] It should also be understood that the terms "first," "second," etc., are used for descriptive purposes only and should not be construed as indicating or implying relative importance. Furthermore, in the description of this application, unless otherwise stated, "a plurality of" means two or more.

[0066] It should be noted that the terms "S1," "S2," etc., are used only for descriptive purposes and do not specifically refer to the order or sequence, nor are they intended to limit this application. They are merely for the convenience of describing the method of this application and should not be construed as indicating the sequential order of the steps. Furthermore, the technical solutions of the various embodiments can be combined with each other, but this must be based on the ability of those skilled in the art to implement them. When the combination of technical solutions is contradictory or impossible to implement, it should be considered that such a combination of technical solutions does not exist and is not within the scope of protection claimed in this application.

[0067] Example 1

[0068] like Figure 1 As shown in the figure, this application embodiment provides a method for calculating the company-wide assessment cycle adjustment table; specifically, it includes the following steps:

[0069] S10. Define and compile an indicator database and adjustment table template that meet the requirements of insurance contracts.

[0070] Specifically, based on IFRS 17 insurance contract standards, 140 indicators need to be calculated, such as beginning insurance contract liabilities, beginning insurance contract liabilities - unearned premium liabilities, beginning insurance contract liabilities - unearned premium liabilities - excluding losses, beginning insurance contract liabilities - unearned premium liabilities - losses, etc. Although different companies may have slight differences in the naming of these indicators, all indicator names and definitions are based on the provisions of the insurance contract standards and are essentially consistent. Each indicator is coded to generate a unique indicator code, meaning one indicator item corresponds to one indicator code. The indicator codes and their corresponding indicator items are stored in an indicator database for later retrieval.

[0071] Based on the type of reconciliation table, select appropriate indicator items and indicator codes from the indicator library and bind them to the corresponding cells (distinguished by row and column numbers) to define the reconciliation table style; the reconciliation table style must at least include indicator items and their corresponding indicator codes and row and column numbers. The types of reconciliation tables include: a first reconciliation table (i.e., the reconciliation table of performance cash flow and contract service margin balance), used to reflect the reconciliation of performance cash flow and contract service margin balance; and a second reconciliation table (i.e., the reconciliation table of unearned premium liabilities and incurred claims), used to reflect the reconciliation of the balances of matured liability liabilities (or reinsurance recovery of unearned premium assets) and incurred claims liabilities (or reinsurance recovery of incurred claims assets).

[0072] S20. Configure the indicator formulas for each cell in the first adjustment table and the second adjustment table.

[0073] Specifically, according to the row and column order in the reconciliation table style, the indicator formulas are configured for each indicator item in the cell of the reconciliation table. Multiple sets of indicator formulas can be flexibly set for the indicator items in the cell based on different data sources and applicable models. Data sources include, but are not limited to, the measurement system and the sub-ledger system. The measurement system is a measurement and analysis platform provided to meet IFRS 17 financial standards and general applicability, focusing on aspects such as premium income recognition, reserve breakdown, initial recognition, expense allocation, cash flow calculation, and rolling calculation of measurement models related to insurance contracts. The sub-ledger system, on the other hand, meets IFRS 17 financial standards and general applicability, supports multi-standard accounting and reconciliation analysis, and is used to process business data for insurance companies to prepare and disclose reports, accurately and completely reflecting the financial position and operating results of insurance companies. Applicable models include, but are not limited to: general applicable models, premium allocation method models, and variable cost method models. Based on the data source and applicable model, at least six scenarios can be matched. This application supports configuring indicator formulas for cells in each scenario. For example, for the same indicator item, in scenario 1, the possible indicator formula is "Item A"; in scenario 2, the possible indicator formula is "Item B"; or in scenario 3, the possible indicator formula is "Item C". The indicator formula configuration is different for each scenario. The specific method for setting the indicator formula for each indicator item in each scenario is determined by the company's financial actuarial staff based on the contractual disclosure requirements, specifying the items involved in the indicator item, and then combining this with specific data. The logic (i.e., the value formula) for determining the indicator is determined based on the source and applicable model. For example, the value formula for the indicator "Current period claims and other related expenses - incurred claims liabilities for contracts not applicable to the premium sharing method / incurred claims liabilities for contracts applicable to the premium sharing method - present value of future cash flows" can be configured as follows: If the data source for the indicator item is the logic of the measurement system combined with the general model, then if the current service period is defined as the current fiscal year, the configuration formula for this indicator item can be set as: Current period claims and other related expenses (current accident month) + changes related to past services (Current AY_PastAM, current year, not current month) + LIC (Liability for Incurred Claims) risk adjustment current period new business (NB) - RA (Risk Adjustment) release (Current AY_PastAM) - current period paid investment component. If the current service period is defined as the current month, then the indicator formula for this indicator item can be configured as: claims and other related expenses incurred in the current period (current accident month) + LIC risk-adjusted current period new additions - NB - current period actual investment component. To obtain the specific value of each cell indicator item, each indicator formula will be configured with a corresponding executor to execute the indicator formula.

[0074] S30. Based on the input conditions, calculate the data of each cell indicator in the corresponding target adjustment table.

[0075] like Figure 2 As shown, the above process specifically includes the following:

[0076] S301. Determine the calculation dimensions based on the input conditions, including the calculation date, adjustment table type, applicable model, data source, business dimension, and time dimension. Data meeting the conditions can be filtered based on the calculation date, business source, and time dimension.

[0077] S302. Determine the type of the target adjustment table based on the adjustment table type and obtain the style set corresponding to the target adjustment table based on the adjustment table style defined in step S1. This mainly includes the adjustment table type, indicator code, indicator item, and row and column number. Then, determine the corresponding indicator formula set based on the indicator code and / or indicator item. This mainly includes the indicator code, indicator formula, and calculation order. The calculation order is determined by the row and column number in the style set, which refers to the calculation order of the cell indicators.

[0078] S303, the indicator chain list corresponding to the assembly target adjustment table: see details below. Figure 3 Based on the indicator code, associate the style set and the indicator formula set; extract the indicator items, indicator codes and indicator formulas from the associated indicator formula set and style set as the numerical field of the indicator linked list, that is, as the data of the linked list node; integrate the row and column numbers in the style set and the calculation order in the indicator formula set as the reference variables of the indicator linked list, that is, as the next indicator reference of the linked list node; add them to the linked list in sequence to form the indicator linked list.

[0079] S304. Calculate the index value using the formula executor, specifically, as follows: Figure 4 As shown, based on the order of the next indicator references in the indicator chain, the corresponding formula executor is called sequentially to calculate the indicator values ​​of the indicator items in the cells of the target adjustment table, and the indicator chain is parsed to determine the next indicator item to be calculated. This application supports various types of formula executors, such as ordinary processor executors, Spring Spel expression executors, custom function executors, default value executors, summary subtotal executors, and open-source evaluation expression executors, etc. The process of calling different formula executors to process the corresponding indicator formulas is similar, such as... Figure 5 As shown, this application uses a common processor executor for illustration: First, the index formula information is obtained, then the processor and parameters are checked for non-emptiness. If the processor and parameters are empty, the index value is returned directly as 0; if the processor and parameters are not empty, the processor is instantiated or loaded, then the executor context is loaded, and finally the processor's calculation method is called to obtain the index value.

[0080] S305. Summarize the index values ​​calculated by all formula executors based on the target adjustment table style, mark the relationship between the calculation dimension and the target adjustment table, and store the index values ​​of the target adjustment table under the calculation dimension.

[0081] S40. Calculate the adjustment table under the company-wide evaluation cycle.

[0082] Specifically, this involves obtaining all business dimensions for the entire company during the current assessment period. Business dimensions are contract portfolios such as credit insurance and short-term health insurance. Each business dimension further includes multiple sub-dimensions; for example, the credit insurance business dimension includes sub-dimensions such as 2017 personal consumer loan credit insurance and 2016 personal consumer loan credit insurance. This application can start from the business sub-dimensions and obtain all calculation dimensions under each sub-dimension, considering all different combinations of calculation dates, reconciliation table types, applicable models, data sources, and time dimensions.

[0083] For each calculation dimension under a business sub-dimension, execute the process as in step S3 to calculate the indicator value of the target reconciliation table corresponding to each calculation dimension. Summarize the target reconciliation tables with calculated indicator values ​​according to the calculation date, reconciliation table type, and indicator code to obtain the assessment cycle reconciliation table indicator data for the current business sub-dimension. Then, summarize the business sub-dimensions to determine the assessment cycle reconciliation table indicator data for the business dimensions described in the business sub-dimensions; finally, by summarizing the assessment cycle reconciliation table indicator data for all business dimensions, the assessment cycle reconciliation table indicator data for the company dimension can be obtained.

[0084] This application supports the calculation and disclosure of performance cash flows and contract service margin balance reconciliation statements, as well as unearned premium and incurred claims reconciliation statements from multiple dimensions and data sources. It allows for flexible configuration of indicator formulas for indicator items based on data sources and applicable models, while also being compatible with multiple formula executors. This improves the accuracy of disclosure and reflects various changes in the book value of insurance contracts.

[0085] Example 2

[0086] Corresponding to Embodiment 1 above, this application also provides a method for processing adjustment tables, such as... Figure 6 As shown, the details are as follows:

[0087] 6100. Configure the adjustment table style based on the indicator library and configure the indicator formulas for each cell in the adjustment table;

[0088] Preferably, before constructing the style of the adjustment table based on the indicator library and configuring the indicator formulas for each cell in the adjustment table, the method further includes:

[0089] 6110. Define indicator items that conform to the insurance contract guidelines based on the insurance contract guidelines;

[0090] 6120. Encode each of the aforementioned indicator items to generate a unique indicator code;

[0091] 6130. Store the indicator items and their corresponding indicator codes in the indicator library.

[0092] Preferably, the step of constructing the style of the adjustment table based on the indicator library and configuring the indicator formulas for each cell in the adjustment table includes:

[0093] 6140. Based on the indicator items, indicator codes and the type of the adjustment table in the indicator library, construct the adjustment table styles respectively, wherein the adjustment table includes a first adjustment table and a second adjustment table;

[0094] 6150. The adjustment table style includes indicator items and corresponding indicator codes and row and column numbers;

[0095] 6160. Determine the indicator formula based on the data source and applicable model of each cell in the adjustment table;

[0096] Each cell's indicator formula is configured with a corresponding formula executor.

[0097] 6200. Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table;

[0098] Preferably, determining the set of styles and the set of indicator formulas for the target adjustment table based on the calculation dimension and the adjustment table style includes:

[0099] 6210. Determine the calculation dimension based on the input conditions. The calculation dimension includes the calculation date, adjustment table type, applicable model, data source, business dimension, and time dimension.

[0100] 6220. Based on the adjustment table type and the adjustment table style, determine the set of target adjustment table styles and the set of indicator formulas corresponding to the calculation dimension;

[0101] The style set includes adjustment table type, indicator code, indicator item, and row and column number;

[0102] The set of formulas includes indicator codes, indicator formulas, and calculation order, with the calculation order set according to the row and column numbers.

[0103] 6300. Construct an indicator linked list based on the style set and the indicator formula set of the target adjustment table;

[0104] Preferably, the step of constructing an indicator linked list based on the style set and the indicator formula set of the target adjustment table includes:

[0105] 6310. Associating the style set and the indicator formula set based on the indicator code;

[0106] 6320. Extract the index items, index codes, and index formulas from the associated style set and index formula set, and use them as the numerical field of the index linked list;

[0107] 6330. Integrate the row and column numbers in the style set and the calculation order in the indicator formula set, and use them as reference variables in the indicator linked list.

[0108] 6400. Based on the indicator linked list, calculate the indicator value of each cell in the target adjustment table under the calculation dimension.

[0109] Preferably, the step of calculating the indicator value of each cell in the target adjustment table under the calculation dimension based on the indicator linked list includes:

[0110] 6410. Obtain the indicator formula of the corresponding cell in the target adjustment table according to the reference variable pointing order in the indicator chain list, and call the corresponding formula executor to calculate the indicator value of the cell.

[0111] Preferably, the method further includes:

[0112] 6420. Obtain all business dimensions under the company's evaluation cycle, as well as all calculation dimensions under each of the aforementioned business dimensions;

[0113] 6430. Calculate the indicator values ​​of each cell in the target adjustment table corresponding to each calculation dimension under each business dimension and summarize them to determine the company's evaluation cycle adjustment table.

[0114] Example 3

[0115] like Figure 7 As shown, corresponding to Embodiments 1 and 2 above, this application provides an adjustment table processing system, the system comprising:

[0116] Configuration module 710 is used to configure the style of the adjustment table based on the indicator library and configure the indicator formula of each cell in the adjustment table;

[0117] Analysis module 720 is used to determine the set of styles and the set of indicator formulas for the target adjustment table based on the calculation dimension and the adjustment table style.

[0118] Processing module 730 is used to construct an indicator linked list based on the style set and the indicator formula set of the target adjustment table;

[0119] The calculation module 740 is used to calculate the indicator value of each cell in the target adjustment table under the calculation dimension based on the indicator linked list.

[0120] In some embodiments, the calculation module 740 is further configured to obtain all business dimensions under the company's evaluation cycle and all calculation dimensions under each business dimension; the calculation module 740 is further configured to calculate the indicator values ​​of each cell in the target adjustment table corresponding to each calculation dimension under each business dimension and summarize them to determine the company's evaluation cycle adjustment table.

[0121] In some embodiments, the configuration module 710 is further configured to define indicator items that conform to the insurance contract criteria based on the insurance contract criteria; the configuration module 710 is further configured to encode each indicator item to generate a unique indicator code; the configuration module 710 is further configured to store the indicator item and the corresponding indicator code in the indicator library.

[0122] In some embodiments, the configuration module 710 is further configured to construct adjustment table styles based on the indicator items, indicator codes, and adjustment table types in the indicator library, wherein the adjustment table includes a first adjustment table and a second adjustment table; the adjustment table style includes indicator items and corresponding indicator codes and row and column numbers; the analysis module 720 is further configured to determine indicator formulas according to the data source and applicable model of each cell in the adjustment table; wherein each cell's indicator formula is configured with a corresponding formula executor.

[0123] In some embodiments, the analysis module 720 is further configured to determine the calculation dimension based on input conditions, the calculation dimension including calculation date, adjustment table type, applicable model, data source, business dimension, and time dimension; the analysis module 720 is further configured to determine the style set and indicator formula set of the target adjustment table corresponding to the calculation dimension based on the adjustment table type and the adjustment table style; wherein, the style set includes adjustment table type, indicator code, indicator item, and row and column number; the formula set includes indicator code, indicator formula, and calculation order, the calculation order being set according to the row and column number.

[0124] In some embodiments, the processing module 730 is further configured to associate the style set and the indicator formula set based on the indicator code; the processing module 730 is further configured to extract the indicator items, indicator codes and indicator formulas in the associated style set and indicator formula set as the numerical fields of the indicator linked list; the processing module 730 is further configured to integrate the row and column numbers in the style set and the calculation order in the indicator formula set as reference variables of the indicator linked list.

[0125] In some embodiments, the calculation module 740 is further configured to obtain the indicator formula of the corresponding cell in the target adjustment table according to the reference variable pointing order in the indicator chain and call the corresponding formula executor to calculate the indicator value of the cell.

[0126] Example 4

[0127] Corresponding to all the above embodiments, this application provides an electronic device, including:

[0128] One or more processors; and memory associated with the one or more processors, the memory storing program instructions that, when read and executed by the one or more processors, perform the following operations:

[0129] Configure the adjustment table style based on the indicator library and configure the indicator formula for each cell in the adjustment table;

[0130] Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table;

[0131] Construct an indicator linked list based on the style set and indicator formula set of the target adjustment table;

[0132] Based on the indicator linked list, calculate the indicator value of each cell in the target adjustment table under the calculation dimension.

[0133] in, Figure 8 An exemplary architecture of an electronic device is shown, which may specifically include a processor 810, a video display adapter 811, a disk drive 812, an input / output interface 813, a network interface 814, and a memory 820. The processor 810, video display adapter 811, disk drive 812, input / output interface 813, network interface 814, and memory 820 can communicate with each other via a bus 830.

[0134] The processor 810 can be implemented using a general-purpose CPU (Central Processing Unit), microprocessor, application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to achieve the technical solution provided in this application.

[0135] The memory 820 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory), static storage device, dynamic storage device, etc. The memory 820 can store the operating system 821 for controlling the execution of the electronic device 800, and the basic input / output system (BIOS) 822 for controlling the low-level operations of the electronic device 800. Additionally, it can store a web browser 823, a data storage management system 824, and an icon font processing system 825, etc. The aforementioned icon font processing system 825 can be the application program that specifically implements the aforementioned steps in this embodiment. In summary, when implementing the technical solution provided in this application through software or firmware, the relevant program code is stored in the memory 820 and is called and executed by the processor 810.

[0136] The input / output interface 813 is used to connect input / output modules to enable information input and output. Input / output modules can be configured as components within the device (not shown in the figure) or externally connected to the device to provide corresponding functions. Input devices may include keyboards, mice, touchscreens, microphones, various sensors, etc., while output devices may include displays, speakers, vibrators, indicator lights, etc.

[0137] Network interface 814 is used to connect a communication module (not shown in the figure) to enable communication between this device and other devices. The communication module can communicate via wired means (such as USB, Ethernet cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.).

[0138] Bus 830 includes a pathway for transmitting information between various components of the device, such as processor 810, video display adapter 811, disk drive 812, input / output interface 813, network interface 814, and memory 820.

[0139] In addition, the electronic device 800 can also obtain information on specific claim conditions from the virtual resource object claim condition information database for use in condition judgment, etc.

[0140] It should be noted that although the above-described device only shows the processor 810, video display adapter 811, disk drive 812, input / output interface 813, network interface 814, memory 820, bus 830, etc., in specific implementations, the device may also include other components necessary for normal operation. Furthermore, those skilled in the art will understand that the above-described device may only include the components necessary for implementing the solution of this application, and does not necessarily include all the components shown in the figures.

[0141] Example 6

[0142] Corresponding to all the above embodiments, this application also provides a computer-readable storage medium, characterized in that it stores a computer program that causes a computer to operate as follows:

[0143] Configure the adjustment table style based on the indicator library and configure the indicator formula for each cell in the adjustment table;

[0144] Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table;

[0145] Construct an indicator linked list based on the style set and indicator formula set of the target adjustment table;

[0146] Based on the indicator linked list, calculate the indicator value of each cell in the target adjustment table under the calculation dimension.

[0147] As can be seen from the above description of the embodiments, those skilled in the art can clearly understand that this application can be implemented by means of software plus necessary general-purpose hardware platforms. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, a cloud server, or a network device, etc.) to execute the methods described in various embodiments or some parts of the embodiments of this application.

[0148] The various embodiments in this specification are described in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on describing the differences from other embodiments. In particular, for system or system embodiments, since they are basically similar to method embodiments, the description is relatively simple, and relevant parts can be referred to the descriptions in the method embodiments. The systems and system embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. 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 the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without creative effort.

[0149] The above description is only a preferred embodiment of this application and is not intended to limit this application. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the protection scope of this application.

Claims

1. A method for processing adjustment tables, characterized in that, The method includes: Configure the adjustment table style based on the indicator library and configure the indicator formulas for each cell in the adjustment table; Based on the calculation dimension and the adjustment table style, determine the style set and indicator formula set of the target adjustment table; Constructing an indicator linked list based on the style set and indicator formula set of the target adjustment table includes: The style set and the indicator formula set are associated based on the indicator code; The index items, index codes, and index formulas in the associated style set and index formula set are extracted and used as the numerical field of the index linked list, that is, as the numerical field of the linked list node. The row and column numbers in the style set and the calculation order in the indicator formula set are integrated and used as reference variables of the indicator linked list, that is, as reference variables of the linked list nodes, and added to the linked list in sequence to form the indicator linked list. Based on the indicator linked list, the indicator values ​​of each cell in the target adjustment table under the calculation dimension are calculated, including: According to the reference variables in the indicator chain, the indicator formulas of the corresponding cells in the target adjustment table are obtained in sequence, and the corresponding formula executor is called to calculate the indicator values ​​of the cells. The indicator chain is parsed to determine the next indicator item to be calculated, and the corresponding formula executor is called to calculate the indicator values ​​of the indicator items in the cells of the target adjustment table in turn.

2. The method according to claim 1, characterized in that, The method further includes: Obtain all business dimensions under the company's monthly assessment, as well as all calculation dimensions under each of the aforementioned business dimensions; Calculate the indicator values ​​of each cell in the target adjustment table corresponding to each calculation dimension under each business dimension, and summarize them to determine the company's monthly assessment adjustment table.

3. The method according to claim 1, characterized in that, Before constructing the adjustment table style based on the indicator library and configuring the indicator formulas for each cell in the adjustment table, the method further includes: Based on the definition of indicators that conform to the insurance contract guidelines; Each of the aforementioned indicator items is coded to generate a unique indicator code; The indicator items and their corresponding indicator codes are stored in the indicator library.

4. The method according to claim 3, characterized in that, The process of constructing an adjustment table style based on an indicator library and configuring the indicator formulas for each cell within the adjustment table includes: Based on the type of the adjustment table, the adjustment table styles are constructed respectively, wherein the adjustment table includes a first adjustment table and a second adjustment table; The adjustment table format includes indicator items and their corresponding indicator codes and row and column numbers; The indicator formula is determined based on the data source and applicable model of each cell in the adjustment table. Each cell's indicator formula is configured with a corresponding formula executor.

5. The method according to claim 4, characterized in that, Based on the calculation dimension and the adjustment table style, the set of style and the set of indicator formulas for the target adjustment table are determined, including: The calculation dimension is determined based on the input conditions, and the calculation dimension includes the calculation date, adjustment table type, applicable model, data source, business dimension, and time dimension; Based on the adjustment table type and the adjustment table style, determine the set of target adjustment table styles and the set of indicator formulas corresponding to the calculation dimension; The style set includes adjustment table type, indicator code, indicator item, and row and column number; The set of formulas includes indicator codes, indicator formulas, and calculation order, with the calculation order set according to the row and column numbers.

6. A control table processing system for the control table processing method according to any one of claims 1-5, characterized in that, The system includes: The configuration module is used to configure the style of the adjustment table based on the indicator library and to configure the indicator formulas of each cell in the adjustment table. The analysis module is used to determine the set of styles and the set of indicator formulas for the target adjustment table based on the calculation dimension and the adjustment table style. The processing module is used to construct an indicator linked list based on the style set and the indicator formula set of the target adjustment table; The calculation module is used to calculate the indicator value of each cell in the target adjustment table under the calculation dimension based on the indicator linked list.

7. An electronic device, characterized in that, The electronic device includes: One or more processors; And a memory associated with the one or more processors, the memory being used to store program instructions that, when read and executed by the one or more processors, perform the method of any one of claims 1-5.

8. A computer-readable storage medium, characterized in that, It stores a computer program that causes the computer to perform the method described in any one of claims 1-5.

Images