Fusion storage method and device for counting and extracting data and actual payment data in reinsurance

Abstract

The embodiment of the invention discloses a fusion storage method and device for counting and extracting data and actual payment data in reinsurance. The method comprises the following steps: acquiring a fusion bill detail table and a bill adjustment log table in fusion storage of counting and extracting data and actual payment data in reinsurance business processing; determining a target control displayed in the fused bill detail table according to service attribute information in the fused bill detail table and auditing state information in the bill adjustment log table; and displaying the calculation and extraction data in the reinsurance service and the adjustment data corresponding to the actual payment data in the fused bill detail table, and displaying the target control at the adjustment data. According to the method, the calculation and extraction data and the actual payment data are fused and stored in the same data table, and the target control is added in the data table, so that the data in the table can be adjusted, the type of the data is distinguished according to the target control, and the effects of fusion storage and type distinguishing of the calculation and extraction data and the actual payment data are achieved.

Description

Technical Field

[0001] This invention relates to the field of financial technology, and in particular to a method and device for the integrated storage of accrual data and actual payment data in reinsurance. Background Technology

[0002] Reinsurance refers to a form of insurance where the original insurer transfers part or all of its underwritten insurance business to a reinsurer. Reinsurance typically involves two stages: monthly accrual and final payment settlement.

[0003] In the traditional reinsurance actual payment invoice process, modifications are usually made directly to the monthly accrual invoice details. This method of direct modification undermines the integrity of the monthly accrual invoices, making it impossible to trace historical data and reconcile historical details, thus increasing the difficulty of reconciliation for reinsurance personnel.

[0004] Therefore, in order to maintain the independence and integrity of accrual invoices and actual payment invoices, and to improve the convenience of operation for business personnel, there is an urgent need to provide a method for splitting and merging the storage of accrual data and actual payment data in reinsurance. Summary of the Invention

[0005] This invention provides a method and apparatus for the integrated storage of accrued data and actual payment data in reinsurance, so as to integrate and store accrued data and actual payment data separately.

[0006] According to one aspect of the present invention, a method for fusing and storing accrued data and paid-in data in reinsurance is provided, the method comprising:

[0007] Obtain the merged bill details table and bill adjustment log table, which are stored together with the accrued data and actual payment data in the reinsurance business processing.

[0008] Based on the business attribute information in the integrated bill details table and the audit status information in the bill adjustment log table, determine the target controls to be displayed in the integrated bill details table;

[0009] The accrual data and corresponding adjustment data in the reinsurance business are displayed in the merged bill details table, and the target control is displayed in the adjustment data section.

[0010] According to another aspect of the present invention, a fusion storage device for accrued data and paid-in data in reinsurance is provided, the device comprising:

[0011] The data table acquisition module is used to acquire the merged bill details table and the bill adjustment log table, which are stored together with the accrued data and actual payment data in the reinsurance business processing.

[0012] The target control determination module is used to determine the target control to be displayed in the integrated billing details table based on the business attribute information in the integrated billing details table and the audit status information in the billing adjustment log table.

[0013] The converged storage module is used to display the accrual data and corresponding adjustment data in the reinsurance business in the converged bill details table, and to display the target control in the adjustment data section.

[0014] According to another aspect of the present invention, an electronic device is provided, the electronic device comprising:

[0015] At least one processor; and a memory communicatively connected to the at least one processor; wherein,

[0016] The memory stores a computer program that can be executed by at least one processor, such that the at least one processor is able to execute the method for merging and storing accrued data and paid-in data in reinsurance according to any embodiment of the present invention.

[0017] According to another aspect of the present invention, a computer-readable storage medium is provided, which stores computer instructions for causing a processor to execute and implement the method for merging and storing accrued data and paid-in data in reinsurance according to any embodiment of the present invention.

[0018] According to another aspect of the present invention, a computer program product is provided, comprising a computer program that, when executed by a processor, implements a method for merging and storing accrued data and paid-in data in reinsurance according to any embodiment of the present invention.

[0019] The technical solution of this invention obtains a merged bill detail table and a bill adjustment log table that integrate and store accrued data and actual payment data in reinsurance business processing; determines the target control to be displayed in the merged bill detail table based on the business attribute information in the merged bill detail table and the audit status information in the bill adjustment log table; displays the accrued data and the corresponding adjustment data in the reinsurance business in the merged bill detail table, and displays the target control at the adjustment data location. This solves the problem of merging and storing accrued data and actual payment data in reinsurance business. By merging and storing accrued data and actual payment data in the same data table and adding a target control to the data table, the data in the table can be adjusted, and the data type can be distinguished according to the target control, achieving the effect of both merging and storing accrued data and actual payment data and distinguishing their types.

[0020] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of the present invention, nor is it intended to limit the scope of the invention. Other features of the invention will become readily apparent from the following description. Attached Figure Description

[0021] To more clearly illustrate the technical solutions in the embodiments of the present invention, 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 the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0022] Figure 1 This is a flowchart of a method for fusing and storing accrued data and actual payment data in reinsurance according to Embodiment 1 of the present invention;

[0023] Figure 2 This is a flowchart of a method for fusing and storing accrued data and actual payment data in reinsurance according to Embodiment 2 of the present invention;

[0024] Figure 3 This is a schematic diagram illustrating the control in a fused bill detail table according to Embodiment 3 of the present invention;

[0025] Figure 4 This is a schematic diagram of the structure of a fusion storage device for accrued data and actual payment data in reinsurance provided according to Embodiment 3 of the present invention;

[0026] Figure 5 This is a schematic diagram of the structure of an electronic device that implements the method for fusing and storing accrued data and actual payment data in reinsurance according to embodiments of the present invention. Detailed Implementation

[0027] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0028] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0029] Example 1

[0030] Figure 1 This is a flowchart illustrating a method for fusing and storing accrued and paid-in data in reinsurance according to Embodiment 1 of the present invention. This embodiment is applicable to situations where accrued and paid-in data are stored in reinsurance business. This method can be executed by a fusing and storing device for accrued and paid-in data in reinsurance. This fusing and storing device can be implemented in hardware and / or software, and can be configured in electronic devices such as computers or mobile phones. Figure 1 As shown, the method includes:

[0031] Step 110: Obtain the merged bill details table and bill adjustment log table, which are stored together with the accrued data and actual payment data in the reinsurance business processing.

[0032] The accrual data can be the monthly accrual data in reinsurance business. Monthly accrual refers to the financial operation at the end of each accounting month, whereby the original insurer, based on the reinsurance contract signed with the reinsurer and preliminary data and incomplete information, estimates and accrues the reinsurance premium payable to the reinsurer for the month, as well as the reinsurance claims recoverable from the reinsurer. Reinsurance premium accrual can be based on the proportion or formula stipulated in the reinsurance contract, and on the preliminary underwritten premium income or risk amount for the month, to estimate the reinsurance premium to be ceded to the reinsurer. For example, a reinsurance contract stipulates a 50% ceding. If the original insurer's preliminary premium income for the month is 10 million yuan, then the reinsurance premium accrual expenditure would be 10 million yuan × 50% = 5 million yuan. Claims recovery accrual can be based on the preliminary reported or filed claims information for the month, and on the proportion stipulated in the reinsurance contract, to estimate the amount of claims recoverable from the reinsurer. For example, if a case with an estimated payout of 1 million yuan occurs in the current month, and the reinsurance ratio is 50%, then the income from the claim recovery is 1 million yuan × 50% = 500,000 yuan.

[0033] However, the accrued data is based on incomplete data and is not the final amount. It is merely for financial reporting and internal management purposes before closing the books, and does not represent actual payments. Actual payment data can be data from billing settlement. Billing settlement refers to the process at the end of a billing period (e.g., quarter) where the original insurer prepares a detailed reinsurance bill based on complete and accurate actual business data for that period, and then verifies, confirms, and completes the final fund transfer with the reinsurer. Actual payment data is precise settlement data for reinsurance business over a period of time, representing actual fund payments and receipts between the original insurer and the reinsurer. Billing settlements are confirmed by both parties and are legally valid settlement documents.

[0034] In this embodiment of the invention, accrued data and actual payment data can be stored together in a merged billing details table. The merged billing details table may include current period debit items (payable by the original insurer to the reinsurer): premiums, premium taxes, adjustment items, etc.; current period credit items (payable by the reinsurer to the original insurer): recovered claims, recovered expenses, commissions, adjustment items, etc.; ending balance: the net amount after offsetting debits and credits in the current period, indicating the direction and amount of payment.

[0035] In reinsurance business, when a provision occurs, the provision data can be stored in the merged billing details table. When a payment occurs, the payment data and the corresponding target control can be stored in the merged billing details table. This allows the merged billing details table to store both payment data and allow for the traceability of provision data.

[0036] The billing adjustment log table is used to record data adjustments from accrual data to actual payment data. It facilitates business auditing and data backtracking. Different reinsurance transactions can be identified using the reinsurance transaction sequence number (NEW_SERIAL_NO), which can be a variable-length string with a maximum storage capacity of 40 characters.

[0037] In this embodiment of the invention, the accrual data and actual payment data are obtained only after authorization from the users involved in the reinsurance business, and the method of obtaining them is reasonable and legal.

[0038] Step 120: Based on the business attribute information in the integrated bill details table and the audit status information in the bill adjustment log table, determine the target control to be displayed in the integrated bill details table.

[0039] Business attribute information can include accrual transactions and actual payment transactions. For example, a business attribute information value of 0 or empty can represent an accrual transaction, while 1 represents an actual payment transaction. In the integrated billing details table, business attribute information can be a variable-length character type, with a maximum storage capacity of 2 characters. The review status information can be the review status of adjustments or modifications to accrual data. For example, a review status value of 0 or empty indicates that the adjustment or modification of accrual data has not been reviewed, while 1 indicates that the adjustment or modification of accrual data has been reviewed.

[0040] When the business attribute information in the integrated billing details table differs, the type of target control can be different. For example, in accrual transactions, accrual data can be adjusted, and the target control can be an accrual adjustment control or a one-time adjustment control, etc. Similarly, in payment transactions, payment data can be modified, and the target control can be an adjustment modification control or a multiple adjustment control, etc.

[0041] The decision to display a target control can be determined based on the review status information in the bill adjustment log table. In this embodiment of the invention, the business attribute information in the merged bill details table and the review status information in the bill adjustment log table can be combined to determine which target control to display and whether to display the target control at all.

[0042] Based on the target controls in the merged billing details table, the data in the merged billing details table can be distinguished to determine the accrued data and the actual payment data. This enables the merging and separate storage of accrued and actual payment data. The merged billing details table allows for the traceability of accrued data, solving the problem in existing technologies where actual payment data is directly modified based on accrued bills, resulting in the inability to trace accrued data. Furthermore, since more than 99% of the data in accrued and actual payment data is the same, merged storage can avoid excessive storage resource consumption and solve the data redundancy problem caused by separate storage.

[0043] Step 130: Display the accrual data and corresponding adjustment data in the reinsurance business in the merged bill details table, and display the target control in the adjustment data section.

[0044] The adjustment data can be an adjustment value between the actual payment data and the accrued data. The actual payment data can be data determined by the original insurer based on the reinsurance business. Optionally, before displaying the accrued data and the corresponding adjustment data in the reinsurance business in the merged billing details table, and before displaying the target control at the adjustment data location, the process also includes: obtaining the actual payment data when the reinsurance business involves actual payment; determining the accrued data corresponding to the actual payment data based on the business identification information corresponding to the actual payment data; and determining the adjustment data based on the actual payment data and the accrued data. For example, the adjustment data can be determined by performing logical operations, such as calculating the difference, based on the actual payment data and the accrued data in the merged billing details table.

[0045] The integrated billing details table displays accrued and adjusted data, with a target control displayed at the adjustment data section. The target control allows for the identification of adjusted data, providing a clear visual representation of accrued and adjusted data within the details table. Actual payment data can be derived from the accrued and adjusted data, achieving integrated storage and differentiation of accrued and actual payment data. This avoids the problem of untraceable accrued data caused by directly modifying it.

[0046] Optionally, when determining the accrual data and actual payment data based on the integrated billing details, the method further includes: using the data in the integrated billing details that does not identify the target control as the accrual data; and performing logical operations on the adjustment data in the integrated billing details that identifies the target control and the accrual data to obtain the actual payment data.

[0047] Over 99% of the accrued and actual payment data are repetitive. In the integrated billing details table, accrued data can be used by default, with target controls marked in the adjustment data section. Actual payment data is determined by performing logical operations between the adjustment data and the corresponding accrued data. For example, for the same business sequence number corresponding to accrued and adjustment data, the accrued and adjustment data under the same parameter are added to obtain the actual payment data corresponding to that parameter under that business.

[0048] The technical solution of this invention, by adding a target control to the integrated billing details table, can realize the integrated storage of accrued data and actual payment data, and can distinguish data types. It solves the problem that the existing technology directly modifies the accrued data to generate actual payment data, resulting in the inability to trace the accrued data. It can achieve the distinction between accrued data and actual payment data while saving storage space, and can trace the accrued data, thus achieving the independence and integrity of accrued data and actual payment data, which is convenient for auditing.

[0049] Example 2

[0050] Figure 2 This is a flowchart of a method for fusing and storing accrued data and actual payment data in reinsurance according to Embodiment 2 of the present invention. This embodiment is a further refinement of the above technical solution, and the technical solution in this embodiment can be combined with various optional solutions in one or more of the above embodiments.

[0051] Optionally, based on the business attribute information in the merged bill details table and the audit status information in the bill adjustment log table, the target control to be displayed in the merged bill details table is determined, including: when the business attribute information in the merged bill details table is accrual business, the status of the accrual adjustment control to be displayed in the merged bill details table is determined based on the audit status information in the bill adjustment log table.

[0052] Optionally, based on the business attribute information in the integrated bill details table and the audit status information in the bill adjustment log table, the target control to be displayed in the integrated bill details table can be determined, including: when the business attribute information in the integrated bill details table is actual payment business, determining whether to display the adjustment and modification control in the integrated bill details table based on the audit status information in the bill adjustment log table.

[0053] like Figure 2 As shown, the method includes:

[0054] Step 210: Obtain the merged bill details table and bill adjustment log table, which are stored together with the accrued data and actual payment data in the reinsurance business processing.

[0055] Step 220: When the business attribute information in the integrated billing details table is accrual business, determine the status of the accrual adjustment control displayed in the integrated billing details table based on the audit status information in the billing adjustment log table.

[0056] Accrual adjustment controls can be displayed in the merged billing details table to indicate whether accrual data can be adjusted to generate actual payment data, and to distinguish between accrual data and actual payment data. For example, for accrual data in the merged billing details table that can be adjusted to generate actual payment data, the same parameter items as the accrual data and data value boxes can be added to the merged billing details table, and accrual adjustment controls with different states can be set in the data value boxes.

[0057] When the accrual adjustment control is in an adjustable state, the accrual data for the same parameter item can be adjusted. Adjusted data can be entered in the data value box, and the actual payment data can be obtained based on the accrual data and the adjusted data. When the accrual adjustment control is in a non-adjustable state, the accrual data for the same parameter item cannot be adjusted. However, if an instruction to adjust the accrual data for the same parameter item exists in this state, the data adjustment can be intercepted.

[0058] Another use of the accrual adjustment control is to distinguish data types. Specifically, when an accrual adjustment control is set in a data frame, it indicates that the data is the adjustment data corresponding to the actual payment data. That is, the adjustment data is logically operated on with the corresponding accrual data to obtain the actual payment data. When no accrual adjustment control is set in a data frame, it indicates that the data is accrual data.

[0059] The status of the accrual adjustment control can depend on the review status information in the billing adjustment log table. This review status information can indicate whether the adjustment data has been reviewed. When the review status information indicates that the adjustment data does not exist or has not been reviewed, the accrual adjustment control with an adjustable data status can be displayed in the merged billing details table. When the review status information indicates that the adjustment data has been reviewed, the accrual adjustment control with an unadjustable data status can be displayed in the merged billing details table to intercept any further adjustment operations.

[0060] By determining the status of the accrual adjustment control based on the audit status information in the bill adjustment log table, the accrual data can be accurately adjusted based on the distinction between accrued data and actual payment data, thus avoiding data storage anomalies caused by continuous adjustments.

[0061] Optionally, when the business attribute information in the integrated billing details table is accrual business, the status of displaying the accrual adjustment control in the integrated billing details table is determined based on the review status information in the billing adjustment log table. This includes: when the business attribute information in the integrated billing details table is accrual business and the review status information in the billing adjustment log table is "review incomplete", determining that a first accrual adjustment control is displayed in the integrated billing details table; adjusting the corresponding data and distinguishing the data type through the first accrual adjustment control; when the business attribute information in the integrated billing details table is accrual business and the review status information in the billing adjustment log table is "review completed", determining that a second accrual adjustment control is displayed in the integrated billing details table; and distinguishing the type of the corresponding data through the second accrual adjustment control.

[0062] The first accrual adjustment control can be an accrual adjustment control that allows adjustment of data status. Through this control, the corresponding data can be adjusted and data types can be distinguished. For example, the first accrual adjustment control can be a control with a specific color attribute, such as a blue control, to indicate that the data can be adjusted.

[0063] The second accrual adjustment control can be an accrual adjustment control that does not adjust the data state. While the corresponding data cannot be adjusted through the second accrual adjustment control, it can distinguish data types. For example, the second accrual adjustment control can be a control with a specific color attribute; such as a gray control, to indicate that the data cannot be adjusted.

[0064] Step 230: When the business attribute information in the integrated bill details table is actual payment business, determine whether to display the adjustment and modification control in the integrated bill details table based on the audit status information in the bill adjustment log table.

[0065] In the actual payment transaction, the accrued data in the integrated billing details table has already been adjusted to obtain the actual payment data. At this point, the adjusted data can be modified to confirm its accuracy. The adjustment modification control can be used to modify the adjusted data again. The adjustment modification control can be displayed in the integrated billing details table to indicate that the adjusted data can be modified again. Furthermore, the adjustment modification control can distinguish between accrued data and actual payment data. That is, data in the integrated billing details table without a control is accrued data, and data with an adjustment modification control is adjusted data. Performing logical operations on the accrued data and adjusted data with the same parameter item yields the actual payment data. The adjustment modification control indicates whether the adjusted data can be modified and distinguishes data types.

[0066] Optionally, when the business attribute information in the integrated billing details table is an actual payment transaction, the system determines whether to display the adjustment / modification control in the integrated billing details table based on the review status information in the billing adjustment log table. This includes: if the business attribute information in the integrated billing details table is an actual payment transaction and the review status information in the billing adjustment log table is "review incomplete," then the system determines to display the adjustment / modification control in the integrated billing details table; if the business attribute information in the integrated billing details table is an actual payment transaction and the review status information in the billing adjustment log table is "review completed," then the system determines to display the adjustment / modification control in the integrated billing details table and deletes the adjusted data that has been reviewed and approved in the billing adjustment log table.

[0067] When displaying the adjustment control, the adjustment data can be modified. If the adjustment data's approval status in the bill adjustment log table is "approved," the data can be modified again to update it. However, at this point, the approved adjustment data in the bill adjustment log table must be deleted to avoid data rollback errors. The updated adjustment data can be logically processed with the corresponding accrual data to obtain the actual payment data.

[0068] For example, Table 1 is a display mapping table of target controls in a merged bill detail table according to Embodiment 2 of the present invention. As shown in Table 1, when the business attribute information (data_source) in the merged bill detail table is accrual business (empty or 0), and the audit status information in the bill adjustment log table is incomplete audit (empty or 0), a first accrual adjustment control can be displayed to add adjustment data to the accrual data in the merged bill detail table to obtain the actual payment data in the actual payment business. When data_source is empty or 0, and the audit status information in the bill adjustment log table is completed audit (1), a second accrual adjustment control can be displayed to intercept the secondary update of adjustment data when no actual payment data has been generated.

[0069] As shown in Table 1, when the data_source in the merged billing details table is a paid transaction (1), and the audit status information in the billing adjustment log table is empty or 0, an adjustment modification control can be displayed to modify the adjustment data corresponding to the generated paid transaction data. When the data_source in the merged billing details table is a paid transaction (1), and the audit status information in the billing adjustment log table is 1, the adjustment modification control can be displayed, and the audited adjustment data in the billing adjustment log table can be deleted to avoid errors in accrual data tracing caused by multiple records in the billing adjustment log table.

[0070] Table 1

[0071]

[0072] Step 240: Display the accrual data and corresponding adjustment data in the reinsurance business in the merged bill details table, and display the corresponding controls in the adjustment data section.

[0073] Depending on the specific circumstances, the controls displayed in the data section can be adjusted to include a first provision adjustment control, a second provision adjustment control, or an adjustment modification control. For example, Figure 3 This is a schematic diagram illustrating a control in a fused bill detail table according to Embodiment 3 of the present invention. Figure 3 As shown, the integrated billing details table can contain information such as reinsurance business serial number, time code, policy type number, reinsurance individual, reinsurance contract, type of insurance, policy number, insured number, billing date, reinsurance premium, reinsurance commission, claims recovery, event type, institution, channel, ceded liability, effective date, termination date, and source. Among these, it allows for the inclusion of details such as... Figure 3 The data values ​​for reinsurance premiums, reinsurance commissions, and claims recovery are adjusted to generate actual payment data.

[0074] Specifically, Figure 3 In China, the data frames corresponding to reinsurance premiums, reinsurance commissions, and claims recovery are marked with target controls such as the first provision adjustment control, the second provision adjustment control, or adjustment modification controls, to adjust the provision data or modify and update the adjusted data to obtain the actual payment data. For example, in Figure 3The system contains three rows with identical parameter items: reinsurance premium, reinsurance commission, and claims recovery. The first row, containing reinsurance premium, reinsurance commission, and claims recovery, does not have a target control; this data represents accrual data. The second row, containing reinsurance premium, reinsurance commission, and claims recovery, has an accrual adjustment control; this data represents adjustment data and can be added to the first row's accrual data to obtain the actual payment data. The third row has an adjustment modification control; this data represents updated adjustment data and can be used to update the second row's adjustment data. This allows adding the first row's accrual data to the third row's updated adjustment data to obtain the actual payment data. If the adjustment data in the billing adjustment log has already been approved, the second row's adjustment data can be deleted from the billing adjustment log.

[0075] In practical applications, the adjusted data and the updated data of the adjusted data in the integrated billing details table can be displayed separately, and only the latest data can be displayed.

[0076] Optionally, before displaying the accrual data and corresponding adjustment data in the reinsurance business in the merged bill details table, and displaying the corresponding controls in the adjustment data section, the method further includes: obtaining the actual payment data when the reinsurance business makes an actual payment; determining the accrual data corresponding to the actual payment data based on the business identification information corresponding to the actual payment data; and determining the adjustment data based on the actual payment data and the accrual data.

[0077] Step 250: Use the data without identified controls in the merged bill details table as accrual data.

[0078] Step 260: Perform logical operations on the adjustment data of the identification control in the merged bill details table and the accrual data to obtain the actual payment data.

[0079] In addition, it should be noted that, in Figure 3 Parameters that do not have identical parameters are used as accrual data in accrual transactions, but can be directly used as actual payment data in actual payment transactions. However, in... Figure 3 For parameters with the same parameter item, the adjustment data is the accrued data when the target control is not identified, and the actual payment data when the target control is identified. Logical operations such as addition can be performed between the adjustment data and the corresponding accrued data to obtain the actual payment data for that parameter item.

[0080] In the technical solution of this invention embodiment, the fused bill detail table and bill adjustment log table, which are stored together in the reinsurance business processing, are obtained. When the business attribute information in the fused bill detail table is accrual business, the status of displaying the accrual adjustment control in the fused bill detail table is determined according to the review status information in the bill adjustment log table. When the business attribute information in the fused bill detail table is actual payment business, the status of displaying the adjustment modification control in the fused bill detail table is determined according to the review status information in the bill adjustment log table. The accrual data and actual payment data in the reinsurance business are compared... The corresponding adjustment data is displayed in the integrated billing details table, and the corresponding controls are displayed at the adjustment data location; data without controls identified in the integrated billing details table is used as accrual data; logical operations are performed on the adjustment data with identified controls in the integrated billing details table and the accrual data to obtain the actual payment data. This solves the problem of existing technologies directly modifying accrual data to generate actual payment data, resulting in the inability to trace accrual data. It can distinguish between accrual data and actual payment data while saving storage space, enabling accrual data traceability, achieving independent and complete storage of accrual data and actual payment data, and facilitating auditing.

[0081] Example 3

[0082] Figure 4 This is a schematic diagram of the structure of a fusion storage device for accrued data and actual payment data in reinsurance, provided according to Embodiment 3 of the present invention. Figure 4 As shown, the device includes: a data table acquisition module 410, a target control determination module 420, and a fusion storage module 430. Wherein:

[0083] The data table acquisition module 410 is used to acquire the fused bill detail table and the bill adjustment log table, which are stored together with the accrued data and actual payment data in the reinsurance business processing.

[0084] The target control determination module 420 is used to determine the target control to be displayed in the integrated bill details table based on the business attribute information in the integrated bill details table and the audit status information in the bill adjustment log table.

[0085] The converged storage module 430 is used to display the accrual data and the corresponding adjustment data in the reinsurance business in the converged bill details table, and to display the target control in the adjustment data section.

[0086] Optionally, the device may also include:

[0087] The accrual data determination module is used to use data without a target control in the integrated billing details as accrual data when determining accrual data and actual payment data based on the integrated billing details.

[0088] The actual payment data determination module is used to perform logical operations on the adjustment data and accrual data of the target control identified in the integrated bill details table to obtain the actual payment data.

[0089] Optional, the target control determination module includes:

[0090] The accrual adjustment control status determination unit is used to determine the status of the accrual adjustment control displayed in the integrated billing details table based on the audit status information in the billing adjustment log table when the business attribute information in the integrated billing details table is accrual business.

[0091] Optional, the target control determination module includes:

[0092] The adjustment and modification control determination unit is used to determine whether to display the adjustment and modification control in the integrated billing details table when the business attribute information in the integrated billing details table is actual payment business, based on the audit status information in the billing adjustment log table.

[0093] Optionally, the accrual adjustment control state determination unit includes:

[0094] The first provision adjustment control is used to determine the display of the first provision adjustment control in the integrated bill details table when the business attribute information in the integrated bill details table is provision business and the audit status information in the bill adjustment log table is incomplete audit; the first provision adjustment control is used to adjust the corresponding data and distinguish the data type.

[0095] The second accrual adjustment control determination subunit is used to determine the display of the second accrual adjustment control in the integrated billing details table when the business attribute information in the integrated billing details table is accrual business and the audit status information in the billing adjustment log table is "audit completed"; the second accrual adjustment control is used to distinguish the type of corresponding data.

[0096] Optionally, adjust and modify the control's determining unit, including:

[0097] The first unit of the adjustment and modification control is used to determine the display of the adjustment and modification control in the integrated bill details table when the business attribute information in the integrated bill details table is actual payment business and the review status information in the bill adjustment log table is incomplete review.

[0098] The second determination unit of the adjustment and modification control is used to determine that the adjustment and modification control is displayed in the integrated bill details table when the business attribute information in the integrated bill details table is actual payment business and the review status information in the bill adjustment log table is completed review, and to delete the adjustment data that has been reviewed in the bill adjustment log table.

[0099] Optionally, the device may also include:

[0100] The actual payment data acquisition module is used to acquire actual payment data when reinsurance business is carried out, before displaying the accrual data and corresponding adjustment data in the integrated bill details table and the target control in the adjustment data section.

[0101] The accrual data determination module is used to determine the accrual data corresponding to the actual payment data based on the business identification information corresponding to the actual payment data.

[0102] The adjustment data determination module is used to determine the adjustment data based on the actual payment data and the accrued data.

[0103] The reinsurance accrual data and actual payment data fusion storage device provided in the embodiments of the present invention can execute the reinsurance accrual data and actual payment data fusion storage method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0104] In the technical solutions of this invention, the collection, storage, use, processing, transmission, provision, and disclosure of user data (such as accrual data and actual payment data in reinsurance business) all comply with the provisions of relevant laws and regulations and do not violate public order and good morals.

[0105] Example 4

[0106] Figure 5 A schematic diagram of an electronic device 10, which can be used to implement embodiments of the present invention, is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the invention described and / or claimed herein.

[0107] like Figure 5As shown, the electronic device 10 includes at least one processor 11 and a memory, such as a read-only memory (ROM) or random access memory (RAM), communicatively connected to the at least one processor 11. The memory stores computer programs executable by the at least one processor. The processor 11 can perform various appropriate actions and processes based on the computer program stored in the ROM 12 or loaded into the RAM 13 from the storage unit 18. The RAM 13 can also store various programs and data required for the operation of the electronic device 10. The processor 11, ROM 12, and RAM 13 are interconnected via a bus 14. Input / output (I / O) interfaces are also connected to the bus 14.

[0108] Multiple components in electronic device 10 are connected to I / O interface 15, including: input unit 16, such as keyboard, mouse, etc.; output unit 17, such as various types of displays, speakers, etc.; storage unit 18, such as disk, optical disk, etc.; and communication unit 19, such as network card, modem, wireless transceiver, etc. Communication unit 19 allows electronic device 10 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0109] Processor 11 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of processor 11 include, but are not limited to, central processing unit (CPU), graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, digital signal processors (DSPs), and any suitable processor, controller, microcontroller, etc. Processor 11 performs the various methods and processes described above, such as the fusion storage method of accrued data and paid-in data in reinsurance.

[0110] In some embodiments, the method for merging and storing reinsurance accrual data and actual payment data can be implemented as a computer program tangibly contained in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program can be loaded and / or installed on electronic device 10 via ROM 12 and / or communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the method for merging and storing reinsurance accrual data and actual payment data described above can be performed. Alternatively, in other embodiments, processor 11 can be configured to perform the method for merging and storing reinsurance accrual data and actual payment data by any other suitable means (e.g., by means of firmware).

[0111] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), payload-programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0112] Computer programs used to implement the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when executed by the processor, the computer programs cause the functions / operations specified in the flowcharts and / or block diagrams to be performed. The computer programs may be executed entirely on a machine, partially on a machine, or as a standalone software package, partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0113] In the context of this invention, a computer-readable storage medium can be a tangible medium that may contain or store a computer program for use by or in conjunction with an instruction execution system, apparatus, or device. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, RAM, ROM, erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0114] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0115] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as data servers), or middleware components (e.g., application servers), or frontend components (e.g., user computers with graphical user interfaces or web browsers through which users can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., communication networks). Examples of communication networks include local area networks (LANs), wide area networks (WANs), blockchain networks, and the Internet.

[0116] A computing system can include clients and servers. Clients and servers are generally located far apart and typically interact through communication networks. The client-server relationship is created by computer programs running on the respective computers and having a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a hosting product within the cloud computing service system to address the shortcomings of traditional physical hosts and VPS services, such as high management difficulty and weak business scalability.

[0117] It should be understood that the various forms of processes shown above can be used, with steps reordered, added, or deleted. For example, the steps described in this invention can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution of this invention can be achieved, and this is not limited herein.

[0118] The specific embodiments described above do not constitute a limitation on the scope of protection of this invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this invention.

Claims

1. A method for fusing and storing accrued data and actual payment data in reinsurance, characterized in that, include: Obtain the merged bill details table and bill adjustment log table, which are stored together with the accrued data and actual payment data in the reinsurance business processing. Based on the business attribute information in the integrated bill details table and the audit status information in the bill adjustment log table, determine the target control to be displayed in the integrated bill details table; The accrual data and corresponding adjustment data in the reinsurance business are displayed in the fused bill details table, and the target control is displayed in the adjustment data section.

2. The method according to claim 1, characterized in that, When determining the accrual data and actual payment data based on the integrated billing details, the method further includes: Data in the integrated billing details table that does not identify the target control will be used as accrual data; The adjustment data identifying the target control in the integrated billing details table is logically processed with the accrual data to obtain the actual payment data.

3. The method according to claim 1, characterized in that, Based on the business attribute information in the integrated billing details table and the review status information in the billing adjustment log table, the target controls displayed in the integrated billing details table are determined, including: When the business attribute information in the integrated billing details table is accrual business, the status of the accrual adjustment control displayed in the integrated billing details table is determined according to the audit status information in the billing adjustment log table.

4. The method according to claim 1, characterized in that, Based on the business attribute information in the integrated billing details table and the review status information in the billing adjustment log table, the target controls displayed in the integrated billing details table are determined, including: When the business attribute information in the integrated bill details table is actual payment business, determine whether to display the adjustment and modification control in the integrated bill details table based on the review status information in the bill adjustment log table.

5. The method according to claim 3, characterized in that, When the business attribute information in the integrated billing details table is accrual business, the status of the accrual adjustment control displayed in the integrated billing details table is determined based on the audit status information in the billing adjustment log table, including: When the business attribute information in the integrated bill detail table is accrual business, and the audit status information in the bill adjustment log table is "audit incomplete", the first accrual adjustment control is determined to be displayed in the integrated bill detail table; the corresponding data is adjusted and the data type is distinguished through the first accrual adjustment control; When the business attribute information in the integrated billing details table is accrual business, and the audit status information in the billing adjustment log table is "audit completed", the second accrual adjustment control is determined to be displayed in the integrated billing details table; the second accrual adjustment control is used to distinguish the type of corresponding data.

6. The method according to claim 4, characterized in that, When the business attribute information in the integrated bill details table is a paid transaction, the system determines whether to display adjustment / modification controls in the integrated bill details table based on the review status information in the bill adjustment log table, including: When the business attribute information in the integrated bill details table is actual payment business, and the review status information in the bill adjustment log table is incomplete review, it is determined that the adjustment and modification control will be displayed in the integrated bill details table; When the business attribute information in the integrated bill details table is actual payment business, and the review status information in the bill adjustment log table is completed, the adjustment modification control is displayed in the integrated bill details table, and the adjustment data that has been reviewed is deleted from the bill adjustment log table.

7. The method according to claim 1, characterized in that, Before displaying the accrual data and corresponding adjustment data for reinsurance transactions in the merged billing details table, and before displaying the target control at the adjustment data location, the process also includes: When conducting actual payment transactions in reinsurance business, obtain actual payment data; Determine the accrual data corresponding to the actual payment data based on the business identification information corresponding to the actual payment data; The adjustment data is determined based on the actual payment data and the accrual data.

8. An electronic device, characterized in that, The electronic device includes: At least one processor; and a memory communicatively connected to said at least one processor; wherein, The memory stores a computer program executable by the at least one processor, which enables the at least one processor to perform the method for merging and storing accrued data and paid-in data in reinsurance as described in any one of claims 1-7.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions that, when executed by a processor, implement the method for merging and storing accrued data and paid-in data in reinsurance as described in any one of claims 1-7.

10. A computer program product, characterized in that, The computer program product includes a computer program that, when executed by a processor, implements a method for merging and storing accrued data and paid-in data in reinsurance according to any one of claims 1-7.

Images