A method for verifying submitted data and submitted documents based on regulatory data standards

Abstract

The present invention provides a method for verifying submitted data and submitted documents based on regulatory data standards, comprising the following steps: S1: obtaining submitted data and saving it in a database; S2: verifying submitted data; S3: verifying submitted documents; S4: submitting submitted documents; the method for verifying submitted data and submitted documents based on regulatory data standards proposed in the present invention can cover all submitted data and submitted documents through a combination of computer verification and manual verification, thereby saving manpower and improving efficiency; it can timely discover submitted data and submitted documents that do not meet regulatory specifications, improve the accuracy of verification of submitted data and submitted documents, and is conducive to effectively improving the submission quality.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method for verifying submitted data and submitted documents based on regulatory data standards. Background Art

[0002] In recent years, with the issuance of work notices on regulatory data standards, relevant departments have reported typical problems in the data and documents submitted by insurance companies. It is crucial for insurance companies to ensure the accuracy of the data and documents submitted. At present, insurance companies usually use manual sampling to verify the data and documents submitted.

[0003] The manual verification method in the prior art has the following disadvantages:

[0004] 1. Manual sampling verification is difficult to cover all submitted data and submitted documents, which consumes a lot of manpower and is inefficient;

[0005] 2. Manual sampling and verification is difficult to timely discover reported data and submitted documents that do not meet regulatory standards, and the accuracy rate is low, which is not conducive to effectively improving the quality of reporting; Summary of the invention

[0006] The purpose of the present invention is to solve the shortcomings of the prior art and to propose a method for verifying submitted data and submitted documents based on regulatory data standards.

[0007] To achieve the above object, the present invention adopts the following technical solutions:

[0008] A method for verifying submitted data and submitted documents based on regulatory data standards, comprising the following steps:

[0009] S1: Obtain the submitted data and save it in the database;

[0010] Obtain all submitted data to be accepted in the enterprise;

[0011] The reported data includes public information data, customer information data, product information data, underwriting information data, payment information data, claims information data, related transaction information data, etc.;

[0012] The acquired reporting data is saved in the corresponding reporting data table of the database;

[0013] The reported data table includes a reported data table name and reported data. Each reported data in the reported data table corresponds to a serial number, and the serial number is unique and continuous.

[0014] S2: Verify submitted data;

[0015] Verify the collected reported data;

[0016] The verification includes data format verification and data consistency verification;

[0017] The following sub-steps are included:

[0018] S21: Verify the data format of the submitted data;

[0019] The following sub-steps are included:

[0020] S211: Verify that the submitted data is not empty;

[0021] Use the isnull function to verify that the submitted data is not empty, and determine whether there is any submitted data in the submitted data table that is not allowed to be empty as specified in the regulatory data standards;

[0022] If there is no empty data in the submitted data, the format of the submitted data will be verified;

[0023] If there is empty data in the submitted data, the R&D personnel will check the reason and modify it in the submitted data table, and verify the modified data again until there is no empty data, and then perform format verification on the submitted data;

[0024] S212: Format verification of submitted data;

[0025] Import the reporting data format verification table that complies with regulatory data standardization into the database in advance;

[0026] The reported data format verification table contains the range and data format corresponding to each data;

[0027] Use the if-else function to determine whether each submitted data in the submitted data table is within the range specified in the submitted data format verification table;

[0028] If all submitted data are within the range specified in the submitted data format verification table, the submitted data will be desensitized and verified;

[0029] If there is reported data in the reported data table that is not within the range specified in the reported data format verification table, the R&D personnel shall check the reason and modify it in the reported data table, and verify the modified reported data again until all reported data are within the range specified in the reported data format verification table, and then perform desensitization verification on the reported data;

[0030] S213: Desensitize and verify the submitted data;

[0031] Determine whether there is sensitive data in the submitted data; if so, create a copy of the submitted data table; the copy of the submitted data table is a copy of the submitted data table;

[0032] The sensitive data in the copy of the submitted data form is desensitized. After the processing is completed, the copy of the submitted data form is recorded as the desensitized submitted data form; the desensitized submitted data form includes the name of the desensitized submitted data form and the desensitized submitted data;

[0033] Use the if-else function to determine whether the submitted data in the desensitized submitted data table conforms to the data format specified in the data format verification table; if all submitted data conform to the data format specified in the data format verification table, perform data consistency verification on the submitted data;

[0034] If there is reported data that does not conform to the data format specified in the data format verification table, the R&D personnel will check the reasons and make modifications in the desensitized reported data table, and verify the modified data again until all reported data conform to the data format specified in the data format verification table, and then perform data consistency verification on the reported data;

[0035] S22: Verify the consistency of the submitted data;

[0036] The following sub-steps are included:

[0037] S221: Obtain source data;

[0038] Obtain source data corresponding to the reported data from the enterprise source system;

[0039] The source data refers to data stored in the source system that complies with regulatory data standardization;

[0040] S222: Compare the consistency of submitted data;

[0041] Compare the reported data in the reported data table with the source data;

[0042] Use the equal function to determine whether the reported data in the reported data table is consistent with the source data obtained; if they are consistent, use the data processing tool to generate a reporting file based on the file format specified by the regulatory data standard for the reported data in the desensitized reported data table;

[0043] If there is any inconsistency, the R&D personnel will check the reasons and make changes in the submitted data sheet, and verify the modified data again until the submitted data in the submitted data sheet is consistent with the source data obtained;

[0044] S3: Verify submitted documents;

[0045] Use data processing tools to generate reporting files and log files corresponding to the reporting files from the desensitized reporting data table in accordance with the file format specified by the regulatory data standards;

[0046] The submitted file includes information such as file name, file size, file serial number, etc.;

[0047] The naming rule of the file name is: agency code-table name;

[0048] The affiliation institution code is the affiliation institution code corresponding to the submitted data table;

[0049] The table name corresponds to the name of the desensitized reporting data table;

[0050] The log file corresponding to the submitted file contains the file name, file size, etc.;

[0051] Verification of the generated submission documents includes the following sub-steps:

[0052] S31: Compare the submitted document with the submitted data table in the database;

[0053] Use the max function to obtain the maximum serial number in the submitted data table, and use the min function to obtain the minimum serial number in the submitted data table;

[0054] Use the grep command to determine whether the maximum and minimum serial numbers in the submitted data table exist in the submitted file;

[0055] Use the count function to calculate the number of data rows in the submitted data table according to the serial number, and use the wc command to obtain the number of data rows in the submitted file; use the equal function to compare whether the number of data rows in the submitted file is consistent with the number of data rows in the submitted data table;

[0056] If the maximum serial number and the minimum serial number in the submitted data table exist in the submitted data file, and the number of data rows in the submitted data table and the submitted file are the same, file log verification is performed;

[0057] Otherwise, the R&D personnel shall check and modify the submitted file and regenerate the submitted file until the maximum serial number and the minimum serial number in the submitted data table exist in the submitted file and the number of data rows in the submitted data table is consistent with that in the submitted file, and then perform file log verification;

[0058] By comparing the maximum serial number, the minimum serial number, and the number of data lines, the generated reporting file is prevented from being incomplete. At the same time, only the maximum serial number, the minimum serial number, and the number of data lines are compared, which avoids the problem that the number of lines in the reporting file is too large, and the comparison line by line consumes a lot of time, affecting the reporting timeliness;

[0059] S32: Log file verification;

[0060] Compare the file name, file size and other information of the submitted file with the corresponding information in the log file. If they are completely consistent, verify the content of the submitted file. If they are inconsistent, the R&D personnel will check and modify the submitted file and regenerate the submitted file until they are consistent, then verify the content of the submitted file;

[0061] S33: Verify the content of the submitted documents;

[0062] The following sub-steps are included:

[0063] S331: non-empty verification;

[0064] Verify the submitted documents again to see if there are any submitted data in the submitted data table that are not allowed to be empty as specified in the regulatory data standards;

[0065] If there is no empty data, the affiliated institution verification is performed;

[0066] If there is empty data, the R&D personnel will check and modify the submitted documents and regenerate the submitted documents until they are consistent, and then verify the affiliated institution;

[0067] By re-verifying the submitted documents as non-empty, data omission in the generated submitted documents can be prevented;

[0068] S332: Verification of affiliated institution;

[0069] Verify whether the submitted document is in the affiliated institution specified in the regulatory data standard according to the affiliated institution code in the corresponding file name of the submitted document. If yes, proceed to step S4;

[0070] If not, the R&D personnel will check and modify the submitted documents, regenerate the submitted documents until they are consistent, and proceed to step S4.

[0071] S4: Submit the submission documents;

[0072] Submit the reporting documents according to the regulatory data standards.

[0073] Compared with the prior art, the present invention has the following beneficial effects:

[0074] The method for verifying submitted data and submitted documents based on regulatory data standards proposed in the present invention can cover all submitted data and submitted documents through a combination of computer verification and manual verification, thus saving manpower and improving efficiency.

[0075] It can timely discover reported data and reported documents that do not comply with regulatory standards, and can make real-time adjustments to problematic reported data and documents, thereby improving the accuracy of verification of reported data and reported documents, which is conducive to effectively improving the quality of reporting. DETAILED DESCRIPTION

[0076] In order to provide a further understanding of the purpose, structure, features, and functions of the present invention, the following detailed description is given in conjunction with the embodiments.

[0077] A method for verifying submitted data and submitted documents based on regulatory data standards, comprising the following steps:

[0078] S1: Obtain the submitted data and save it in the database;

[0079] Obtain all submitted data to be accepted in the enterprise;

[0080] The reported data includes public information data, customer information data, product information data, underwriting information data, payment information data, claims information data, related transaction information data, etc.;

[0081] The acquired reporting data is saved in the corresponding reporting data table of the database;

[0082] The reported data table includes a reported data table name and reported data. Each reported data in the reported data table corresponds to a serial number, and the serial number is unique and continuous.

[0083] S2: Verify submitted data;

[0084] Verify the collected reported data;

[0085] The verification includes data format verification and data consistency verification;

[0086] The following sub-steps are included:

[0087] S21: Verify the data format of the submitted data;

[0088] The following sub-steps are included:

[0089] S211: Verify that the submitted data is not empty;

[0090] Use the isnull function to verify that the submitted data is not empty, and determine whether there is any submitted data in the submitted data table that is not allowed to be empty as specified in the regulatory data standards;

[0091] If there is no empty data in the submitted data, the format of the submitted data will be verified;

[0092] If there is empty data in the submitted data, the R&D personnel will check the reason and modify it in the submitted data table, and verify the modified data again until there is no empty data, and then perform format verification on the submitted data;

[0093] S212: Format verification of submitted data;

[0094] Import the reporting data format verification table that complies with regulatory data standardization into the database in advance;

[0095] The reported data format verification table contains the range and data format corresponding to each data;

[0096] Use the if-else function to determine whether each submitted data in the submitted data table is within the range specified in the submitted data format verification table;

[0097] If all submitted data are within the range specified in the submitted data format verification table, the submitted data will be desensitized and verified;

[0098] If there is reported data in the reported data table that is not within the range specified in the reported data format verification table, the R&D personnel shall check the reason and modify it in the reported data table, and verify the modified reported data again until all reported data are within the range specified in the reported data format verification table, and then perform desensitization verification on the reported data;

[0099] S213: Desensitize and verify the submitted data;

[0100] Determine whether there is sensitive data in the submitted data; if so, create a copy of the submitted data table; the copy of the submitted data table is a copy of the submitted data table;

[0101] The sensitive data in the copy of the submitted data form is desensitized. After the processing is completed, the copy of the submitted data form is recorded as the desensitized submitted data form; the desensitized submitted data form includes the name of the desensitized submitted data form and the desensitized submitted data;

[0102] Use the if-else function to determine whether the submitted data in the desensitized submitted data table conforms to the data format specified in the data format verification table; if all submitted data conform to the data format specified in the data format verification table, perform data consistency verification on the submitted data;

[0103] If there is reported data that does not conform to the data format specified in the data format verification table, the R&D personnel will check the reasons and make modifications in the desensitized reported data table, and verify the modified data again until all reported data conform to the data format specified in the data format verification table, and then perform data consistency verification on the reported data;

[0104] S22: Verify the consistency of the submitted data;

[0105] The following sub-steps are included:

[0106] S221: Obtain source data;

[0107] Obtain source data corresponding to the reported data from the enterprise source system;

[0108] The source data refers to data stored in the source system that complies with regulatory data standardization;

[0109] S222: Compare the consistency of submitted data;

[0110] Compare the reported data in the reported data table with the source data;

[0111] Use the equal function to determine whether the reported data in the reported data table is consistent with the source data obtained; if they are consistent, use the data processing tool to generate a reporting file based on the file format specified by the regulatory data standard for the reported data in the desensitized reported data table;

[0112] If there is any inconsistency, the R&D personnel will check the reasons and make changes in the submitted data sheet, and verify the modified data again until the submitted data in the submitted data sheet is consistent with the source data obtained;

[0113] S3: Verify submitted documents;

[0114] Use data processing tools to generate reporting files and log files corresponding to the reporting files from the desensitized reporting data table in accordance with the file format specified by the regulatory data standards;

[0115] The submitted file contains information such as the file name and file size, and the maximum and minimum serial numbers and the number of data rows are marked in the submitted file;

[0116] The naming rule of the file name is: region code-affiliation organization code;

[0117] The log file corresponding to the submitted file contains the file name, file size, etc.;

[0118] Verification of the generated submission documents includes the following sub-steps:

[0119] S31: Compare the submitted document with the submitted data table in the database;

[0120] Use the max function to obtain the maximum serial number in the submitted data table, and use the min function to obtain the minimum serial number in the submitted data table;

[0121] Use the grep command to determine whether the maximum and minimum serial numbers in the submitted data table exist in the submitted file;

[0122] Use the count function to calculate the number of data rows in the submitted data table according to the serial number, and use the wc command to obtain the number of data rows in the submitted file; use the equal function to compare whether the number of data rows in the submitted file is consistent with the number of data rows in the submitted data table;

[0123] If the maximum serial number and the minimum serial number in the submitted data table exist in the submitted data file, and the number of data rows in the submitted data table and the submitted file are the same, file log verification is performed;

[0124] Otherwise, the R&D personnel shall check and modify the submitted file and regenerate the submitted file until the maximum serial number and the minimum serial number in the submitted data table exist in the submitted file and the number of data rows in the submitted data table is consistent with that in the submitted file, and then perform file log verification;

[0125] By comparing the maximum serial number, the minimum serial number, and the number of data lines, the generated reporting file is prevented from being incomplete. At the same time, only the maximum serial number, the minimum serial number, and the number of data lines are compared, which avoids the problem that the number of lines in the reporting file is too large, and the comparison line by line consumes a lot of time, affecting the reporting timeliness;

[0126] S32: Log file verification;

[0127] Compare the file name, file size and other information of the submitted file with the corresponding information in the log file. If they are completely consistent, verify the content of the submitted file. If they are inconsistent, the R&D personnel will check and modify the submitted file and regenerate the submitted file until they are consistent, then verify the content of the submitted file;

[0128] S33: Verify the content of the submitted documents;

[0129] The following sub-steps are included:

[0130] S331: non-empty verification;

[0131] Verify the submitted file again to see if there is any submitted data in the submitted data table that is not allowed to be empty as specified in the regulatory data standards;

[0132] If there is no empty data, the affiliated institution verification is performed;

[0133] If there is empty data, the R&D personnel will check and modify the submitted documents and regenerate the submitted documents until they are consistent, and then verify the affiliated institution;

[0134] By re-verifying the submitted documents as non-empty, data omission in the generated submitted documents can be prevented;

[0135] S332: Verification of affiliated institution;

[0136] Verify whether the submitted document is in the affiliated institution specified in the regulatory data standard according to the affiliated institution code in the corresponding file name of the submitted document. If yes, proceed to step S4;

[0137] If not, the R&D personnel will check and modify the submitted documents, regenerate the submitted documents until they are consistent, and proceed to step S4.

[0138] S4: Submit the submission documents;

[0139] Submit the reporting documents according to the regulatory data standards.

[0140] The present invention has been described by the above-mentioned relevant embodiments, however, the above-mentioned embodiments are only examples for implementing the present invention. It must be pointed out that the disclosed embodiments do not limit the scope of the present invention. On the contrary, changes and modifications made without departing from the spirit and scope of the present invention are all within the scope of patent protection of the present invention.

Claims

1. A method for verifying submitted data and submitted documents based on regulatory data standards, characterized in that: The following steps are involved: S1: Obtain the submitted data and save it in the database; Obtain all submitted data to be accepted in the enterprise; The acquired reporting data is saved in the corresponding reporting data table of the database; The reported data table includes a reported data table name and reported data. Each reported data in the reported data table corresponds to a serial number, and the serial number is unique and continuous; S2: Verify submitted data; Verify the collected reported data; The verification includes data format verification and data consistency verification; The following sub-steps are included: S21: Verify the data format of the submitted data; The following sub-steps are included: S211: Verify that the submitted data is not empty; Verify that the submitted data is not empty, and determine whether there is any submitted data in the submitted data table that is not allowed to be empty as specified in the regulatory data standards; If there is no empty data in the submitted data, the format of the submitted data will be verified; If there is empty data in the submitted data, the R&D personnel will check the reason and modify it in the submitted data table, and verify the modified data again until there is no empty data, and then perform format verification on the submitted data; S212: Format verification of submitted data; Import the reporting data format verification table that complies with regulatory data standardization into the database in advance; The reported data format verification table contains the range and data format corresponding to each data; Determine whether each submitted data in the submitted data table is within the range specified in the submitted data format verification table; If all submitted data are within the range specified in the submitted data format verification table, the submitted data will be desensitized and verified; If there is reported data in the reported data table that is not within the range specified in the reported data format verification table, the R&D personnel shall check the reason and modify it in the reported data table, and verify the modified reported data again until all reported data are within the range specified in the reported data format verification table, and then perform desensitization verification on the reported data; S213: Desensitize and verify the submitted data; Determine whether there is sensitive data in the submitted data; If it exists, create a copy of the submission data table; The duplicate of the submitted data form is a copy of the submitted data form; The sensitive data in the copy of the submitted data sheet shall be desensitized. After the processing is completed, the copy of the submitted data sheet shall be recorded as the desensitized submitted data sheet; The desensitized reporting data table includes the name of the desensitized reporting data table and the desensitized reporting data; Determine whether the submitted data in the desensitized submitted data table conforms to the data format specified in the data format verification table; If all submitted data conform to the data format specified in the data format verification table, the submitted data will be verified for data consistency; If there is reported data that does not conform to the data format specified in the data format verification table, the R&D personnel will check the reasons and make modifications in the desensitized reported data table, and verify the modified data again until all reported data conform to the data format specified in the data format verification table, and then perform data consistency verification on the reported data; S22: Verify the consistency of the submitted data; S3: Verify submitted documents; Use data processing tools to generate reporting files and log files corresponding to the reporting files from the desensitized reporting data table in accordance with the file format specified by the regulatory data standards; The submitted file includes the file name, file size, and file serial number; The naming rule of the file name is: agency code-table name; The affiliation institution code is the affiliation institution code corresponding to the submitted data table; The table name corresponds to the name of the desensitized reporting data table; The log file corresponding to the submitted file contains the file name, file size, number of file lines, and last modification date; Verification of the generated submission documents includes the following sub-steps: S31: Compare the submitted document with the submitted data table in the database; Compare the submission documents with the submission data table in the database; Obtain the maximum and minimum serial numbers in the submitted data table; Determine whether the maximum serial number and the minimum serial number in the submitted data table exist in the submitted file; Calculate the number of data rows in the submitted data table and submitted documents, and compare the number of data rows in the submitted documents with the number of data rows in the submitted data table to see if they are consistent; If the maximum serial number and the minimum serial number in the submitted data table exist in the submitted data file, and the number of data rows in the submitted data table and the submitted file are the same, file log verification is performed; Otherwise, the R&D personnel shall check and modify the submitted file and regenerate the submitted file until the maximum serial number and the minimum serial number in the submitted data table exist in the submitted file and the number of data rows in the submitted data table is consistent with that in the submitted file, and then perform file log verification; S32: Log file verification; S33: Verify the content of the submitted documents; S4: Submit the submission documents; Submit the reporting documents according to the regulatory data standards.

2. The method for verifying submitted data and submitted documents based on regulatory data standards according to claim 1, characterized in that: Step S22 includes the following sub-steps: S221: Obtain source data; Obtain source data corresponding to the reported data from the enterprise source system; The source data refers to data stored in the source system that complies with regulatory data standardization; S222: Compare the consistency of submitted data; Compare the reported data in the reported data table with the source data; Compare the reported data in the reported data table with the acquired source data to see if they are consistent; If they are consistent, the data processing tool will be used to generate a reporting file based on the file format specified by the regulatory data standards from the reporting data in the desensitized reporting data table; If there is any inconsistency, the R&D personnel will check the cause and make changes in the submitted data table, and verify the modified data again until the submitted data in the submitted data table is consistent with the source data obtained.

3. The method for verifying submitted data and submitted documents based on regulatory data standards according to claim 1, characterized in that: In step S32, the file name and file size of the submitted file are compared with the corresponding information in the log file. If they are completely consistent, the submitted file content verification is performed; if they are inconsistent, the R&D personnel check the submitted file and modify it, and regenerate the submitted file until they are consistent, and then the submitted file content verification is performed.

4. The method for verifying submitted data and submitted documents based on regulatory data standards according to claim 1, characterized in that: Step S33 includes the following sub-steps: S331: non-empty verification; Verify the submitted documents again to see if there are any submitted data in the submitted data table that are not allowed to be empty as specified in the regulatory data standards; If there is no empty data, the affiliated institution verification is performed; If there is empty data, the R&D personnel will check and modify the submitted documents and regenerate the submitted documents until they are consistent, and then verify the affiliated institution; By re-verifying the submitted documents as non-empty, data omission in the generated submitted documents can be prevented; S332: Verification of affiliated institution; Verify whether the submitted document is in the affiliated institution specified in the regulatory data standard according to the affiliated institution code in the corresponding file name of the submitted document. If yes, proceed to step S4; If not, the R&D personnel will check and modify the submitted documents, regenerate the submitted documents until they are consistent, and proceed to step S4.