Engineering settlement cost audit system based on heterogeneous data

Abstract

The present invention discloses a system for auditing the cost of engineering settlement based on heterogeneous data, and relates to the technical field of auditing the cost of engineering settlement, in order to solve the problems of inaccurate auditing of the cost of engineering settlement data and overly cumbersome auditing process. The present invention avoids the gray area in the auditing process by detecting abnormal data found in manual verification and automatic verification, and the abnormal reason description attached when returning enables the submitting personnel to clearly understand the problem, marks the problem of the cost data to be approved and returns it to the auditor, and provides approval opinions and modification methods at the same time, which is helpful to optimize the cost management process, ensure the accuracy and compliance of the data, and perform the approval operation of the cost data through the approval management system, which can ensure that each approval complies with the established rules and regulations and legal and regulatory requirements of the enterprise, and the entire stamping process is carried out in the OA system, and each step of the operation is recorded and can be checked, so as to realize the transparency and traceability of the auditing process.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering settlement cost auditing, and in particular to an engineering settlement cost auditing system based on heterogeneous data. Background Art

[0002] Project settlement cost audit refers to the review and verification of the final settlement cost of the project to ensure the accuracy, rationality and compliance of the settlement cost.

[0003] The Chinese patent with publication number CN113962669A discloses a construction project cost audit method and system. The method mainly obtains the cost list when auditing the cost list. For engineering projects that are open to the public and belong to the ordinary level, the audit level of the cost list needs to be obtained. For some ordinary level cost lists, in order to improve the audit efficiency, only one audit is required, while for some important level cost lists, repeated audits are required to ensure the accuracy. By automatically determining the type and importance level of the cost list and then automatically auditing the cost list, a lot of manpower can be saved. Although the above patent solves the problem of cost audit, the following problems still exist in actual operation:

[0004] 1. After acquiring different project settlement cost data, no further heterogeneous data preprocessing is performed, resulting in the inability to accurately verify the data during audit.

[0005] 2. When reviewing and approving data, the abnormal problems of abnormal data are not effectively identified and judged, resulting in low data accuracy.

[0006] 3. Failure to perform effective data judgment on the data to be stamped, and failure to securely store and encrypt the stamped data, resulting in reduced data security. Summary of the invention

[0007] The purpose of the present invention is to provide an engineering settlement cost audit system based on heterogeneous data. Abnormal data found in manual verification and automatic verification can avoid gray areas in the audit process. The abnormal reason explanation attached when returning can enable the submitting personnel to clearly understand the problem, mark the cost data to be approved with problems and return it to the auditor, and provide approval opinions and modification methods at the same time, which is helpful to optimize the cost management process and ensure the accuracy and compliance of the data. The approval operation of cost data is carried out through the approval management system, which can ensure that each approval complies with the company's established rules and regulations and legal and regulatory requirements. The entire stamping process is carried out in the OA system, and each step of the operation is recorded and traceable, which realizes the transparency and traceability of the audit process and can solve the problems in the prior art.

[0008] To achieve the above object, the present invention provides the following technical solutions:

[0009] The engineering settlement cost audit system based on heterogeneous data includes:

[0010] Engineering cost data entry and processing unit, used for:

[0011] The submitter logs into the OA system and enters the engineering cost data into the OA system. The entered engineering cost data is preprocessed to obtain the cost data to be processed;

[0012] The engineering cost data review unit is used to:

[0013] The auditor logs into the OA system and audits the pending cost data. The pending cost data that fails the audit is returned with an audit form, and the pending cost data that passes the audit is marked as pending cost data for approval.

[0014] Audit data approval processing unit, used to:

[0015] The approval personnel log in to the OA system and approve the cost data to be approved. The approval form will be returned for the cost data that have not been approved, and the approved cost data will be marked as the cost data to be stamped.

[0016] Approval data stamping processing unit, used for:

[0017] The stamping personnel log in to the OA system, stamp the cost data to be stamped, and return the stamped cost data that fails the stamping. After the stamping of the cost data passes the audit process, the project settlement cost data will be obtained.

[0018] Preferably, the engineering cost data entry and processing unit includes:

[0019] Information entry module, used for:

[0020] Before entering the project settlement cost data, the person submitting the project settlement cost data should first log in to the OA system, which is the review system for the project settlement cost;

[0021] The submitter logs into the OA system and enters the task order creation interface. After entering the task order creation interface, confirm the created task order items;

[0022] The task list items include project name, business category, task name, executor and task description, among which the executor includes at least one preparer and one reviewer;

[0023] The creation of the task order is completed after the task order item is confirmed.

[0024] Preferably, the engineering cost data entry and processing unit further includes:

[0025] Input information processing module, used for:

[0026] Pre-process the project data for the created task orders;

[0027] Project data preprocessing is to unify the data format of project data in the task order;

[0028] After the data format is unified, data cleaning is performed;

[0029] After data cleaning is completed, data standardization is performed;

[0030] Data validation is performed after data standardization;

[0031] Integrate the data that have passed the data verification, and obtain the cost data to be processed after data integration;

[0032] Save the cost data to be processed into the audit file.

[0033] Preferably, the engineering cost data review unit is also used for:

[0034] After the auditor logs into the OA system, he / she shall audit the cost data to be processed in the audit document;

[0035] Audit operations include manual verification and automatic verification;

[0036] Manual verification includes verification of the completeness, accuracy, rationality and compliance of the cost data to be processed;

[0037] Automatic verification is performed after manual verification is completed;

[0038] Automatic verification is to verify and compare the cost data to be processed with the standard engineering cost audit data.

[0039] Preferably, the engineering cost data review unit is also used for:

[0040] Confirm the manual verification results and automatic verification results of the cost data to be processed;

[0041] If there is no abnormal data in the manual verification results and the automatic verification results, the cost data to be processed without abnormal data will be marked as cost data to be approved, and the cost data to be approved will be saved in the approval folder;

[0042] If there are abnormal data in the manual verification results and automatic verification results, the abnormal data will be marked as a problem, and the unprocessed cost data with abnormal data will be returned to the return folder of the submitter;

[0043] At the same time, when the cost data to be processed is returned, the reason for the return will be explained based on the abnormal reason of the abnormal data.

[0044] Preferably, the audit data approval processing unit is further used to:

[0045] After the approval personnel log in to the OA system, they shall perform data approval operations on the cost data to be approved in the approval folder;

[0046] The data approval operation is to analyze the cost data to be approved, including trend analysis, comparative analysis and risk assessment;

[0047] According to the data analysis results, the approving personnel will make an approval judgment on the cost data to be approved;

[0048] When the approval judgment result is qualified, the cost data to be approved is marked as cost data to be stamped, and the cost data to be stamped is saved in the stamping folder;

[0049] When the approval judgment result is unqualified, the cost data to be approved will be marked as problematic and returned to the reviewer's return folder;

[0050] At the same time, when the cost data to be approved is marked with problems, the approving personnel will explain the approval opinions and modification methods.

[0051] Preferably, the approval data stamping processing unit is also used for:

[0052] After the stamping personnel log in to the OA system, they will make stamp judgment on the cost data to be stamped in the stamping folder;

[0053] Stamping judgment is to conduct data verification, document inspection, compliance inspection and policy inspection on the stamped cost data;

[0054] If the cost data to be stamped fails the stamping judgment, the cost data to be stamped will be marked as problematic, and the marked problematic cost data will be returned to the return folder of the approver;

[0055] After the cost data to be stamped is judged and passed, the cost data to be stamped will be stamped. The submitter can choose the stamping method by himself. The stamping methods include physical stamp or electronic stamp.

[0056] Among them, when the submitter selects the physical seal, the stamping personnel will obtain the project settlement cost data after the audit process is completed;

[0057] When the submitter chooses the electronic seal, after the stamping personnel have passed the seal, the submitter will stamp it by himself in the OA system and finally obtain the project settlement cost data after the review process is completed.

[0058] Preferably, the approval data stamping processing unit is also used for:

[0059] The engineering settlement cost data obtained after the audit process is completed is encrypted using a symmetric encryption algorithm;

[0060] The data encryption process is to first generate an encryption key using a symmetric encryption algorithm, and then store the generated encryption key in the key management library of the OA system;

[0061] Use symmetric encryption algorithm and generated encryption key to encrypt the project settlement cost data after the audit process is completed;

[0062] After data encryption is completed, the encrypted project settlement cost data is obtained, and the encrypted project settlement cost data is encoded and marked according to the time series, name and random number, and stored in the memory of the OA system after encoding and marking.

[0063] Preferably, the engineering cost data entry and processing unit unifies the data format of the project data in the task list, including:

[0064] Mapping rules build subunits for:

[0065] Read all data formats of heterogeneous data in the OA system, and collect the data content corresponding to the same target information in different data formats;

[0066] Define the base data format of the OA system among all data formats;

[0067] Acquire the first key field of the data content corresponding to the reference data format, and at the same time, acquire the second key field of the data content corresponding to the remaining data formats;

[0068] Acquire an association relationship between the first key field and the second key field, and determine a mapping rule set for format conversion of the remaining data format to the reference data format according to the association relationship, wherein the data formats in the remaining data format correspond to the mapping rules one by one;

[0069] The project data reading subunit is used to read the project data in the task list, determine multiple target data formats of the project data in the task list, and divide the project data according to the data formats of the project data in the task list to obtain multiple project data sets;

[0070] Data format unified subunit for:

[0071] Read the target data format of the project data in the task order and match the target mapping rules that are consistent with the target data format;

[0072] Convert the corresponding project data sets into different formats according to the target mapping rules to obtain the standard format project data corresponding to each project data set;

[0073] Integrate the standard format project data of each project data set to complete the data format unification of the project data in the task order.

[0074] Preferably, in the mapping rule construction subunit, after determining the mapping rule set for converting the remaining data format into the reference data format, the following steps are included:

[0075] The verification subunit is used to:

[0076] After determining a mapping rule set for converting the remaining data formats to the reference data format, obtaining a verification sample data set corresponding to each data format in the remaining data formats except the reference data format;

[0077] Input the verification sample data set into the corresponding mapping rule for format conversion, obtain the target result of format conversion for each verification data in the verification sample data set, and at the same time, obtain the benchmark result corresponding to each verification data in the verification data set;

[0078] Calculate the accuracy of the corresponding mapping rule based on the target result and the benchmark result;

[0079] ;

[0080] in, Indicates The accuracy of the mapping rules; Indicates the sequence number value of the mapping rule; Represents the total amount of data in the validation sample data set; It indicates the total amount of data in the validation sample data set whose output target result is inconsistent with the benchmark result when the validation sample data set is input into the corresponding mapping rule for format conversion; It indicates the total amount of data in the validation sample data set whose output target result is consistent with the benchmark result when the validation sample data set is input into the corresponding mapping rule for format conversion, and ; Indicates the serial number value of the validation sample data set; Indicates that based on In the mapping rule Benchmark results corresponding to validation sample data; Indicates that based on In the mapping rule The target result after format conversion of the verification sample data;

[0081] Obtain a preset accuracy threshold, and compare the accuracy of the current mapping rule with the preset accuracy threshold to determine whether the current mapping rule is qualified;

[0082] If the accuracy of the current mapping rule is equal to or greater than the preset accuracy threshold, the current mapping rule is determined to be qualified;

[0083] Otherwise, the current mapping rule is judged to be unqualified;

[0084] The report reminder subunit is used to mark the unqualified mapping rules in the mapping rule set according to the comparison result, generate a warning report according to the marking result, and transmit the warning report to the user terminal for report reminder.

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

[0086] 1. The engineering settlement cost audit system based on heterogeneous data provided by the present invention can greatly reduce manual intervention and error rate, improve the efficiency and accuracy of data processing through automated data processing procedures, and can process heterogeneous data from different data sources and in different formats, so that enterprises can make full use of various data resources for analysis and decision-making, and can verify and compare data to ensure the accuracy and consistency of data. Through systematic management and audit procedures, the compliance of engineering settlement cost data can be ensured.

[0087] 2. The engineering settlement cost audit system based on heterogeneous data provided by the present invention clearly stipulates how to deal with abnormal data found in manual verification and automatic verification, avoiding gray areas in the audit process. The abnormal reason explanation attached when returning enables the submitting personnel to clearly understand the problem, mark the problem of the cost data to be approved and return it to the auditor, and provide approval opinions and modification methods at the same time, which helps to optimize the cost management process and ensure the accuracy and compliance of the data. The approval operation of cost data is carried out through the approval management system, which can ensure that each approval complies with the company's established rules and regulations and laws and regulations.

[0088] 3. The engineering settlement cost audit system based on heterogeneous data provided by the present invention has the entire stamping process carried out in the OA system, and each step of the operation is recorded and traceable, thus realizing the transparency and traceability of the audit process, which helps to ensure the fairness and accuracy of the audit, and is convenient for subsequent problem tracking and responsibility identification, which can significantly improve the audit efficiency, shorten the audit cycle, and reduce the management cost through the automated encryption process, thereby reducing the economic losses caused by data leakage or tampering.

[0089] 4. By acquiring all data formats of heterogeneous data in the OA system and collecting the data content corresponding to the same target information in different data formats, the first key field of the data content corresponding to the baseline data format and the second key field of the data content corresponding to the remaining data formats can be effectively obtained, so as to effectively construct a mapping rule set by determining the association between the first key field and the second key field, laying an effective foundation for format unification of heterogeneous data, and by determining the target data format of the project data in the task order, the target mapping rule consistent with the target data format in the mapping rule set is retrieved for format conversion, and the standard format project data is effectively obtained, so as to effectively complete the effectiveness and accuracy of data format unification of the project data in the task order by integrating the standard format project data, thereby providing effective data processing for the project settlement cost audit and improving the efficiency of the project settlement cost audit.

[0090] 5. After determining the mapping rule set for format conversion of the remaining data formats to the benchmark data format, the format conversion is verified by obtaining the verification sample data set corresponding to each data format in the remaining data formats except the benchmark data format and the corresponding mapping rules, so as to effectively calculate the accuracy of each mapping rule according to the obtained target result, and then effectively mark the unqualified mapping rules in the mapping rule set, effectively generate report reminders and transmit them to the user terminal, which is conducive to timely grasping the qualified status of each mapping rule in the mapping rule set, and effectively ensuring the effectiveness and accuracy of format unification of heterogeneous data. BRIEF DESCRIPTION OF THE DRAWINGS

[0091] Figure 1 It is a schematic diagram of the engineering settlement cost review unit of the present invention;

[0092] Figure 2 It is a schematic diagram of the engineering settlement cost review process of the present invention. DETAILED DESCRIPTION

[0093] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0094] In order to solve the problem in the prior art that different engineering settlement cost data are obtained without further heterogeneous data preprocessing, which leads to the problem that the data cannot be accurately verified during audit, please refer to Figure 1 and Figure 2 , this embodiment provides the following technical solutions:

[0095] The engineering settlement cost audit system based on heterogeneous data includes:

[0096] Engineering cost data entry and processing unit, used for:

[0097] The submitter logs into the OA system and enters the engineering cost data into the OA system. The entered engineering cost data is preprocessed to obtain the cost data to be processed;

[0098] The engineering cost data review unit is used to:

[0099] The auditor logs into the OA system and audits the pending cost data. The pending cost data that fails the audit is returned with an audit form, and the pending cost data that passes the audit is marked as pending cost data for approval.

[0100] Audit data approval processing unit, used to:

[0101] The approval personnel log in to the OA system and approve the cost data to be approved. The approval form will be returned for the cost data that have not been approved, and the approved cost data will be marked as the cost data to be stamped.

[0102] Approval data stamping processing unit, used for:

[0103] The stamping personnel log in to the OA system, stamp the cost data to be stamped, and return the stamped cost data that fails the stamping. After the stamping of the cost data passes the audit process, the project settlement cost data will be obtained.

[0104] Specifically, the possibility of human error is reduced through system automation through the engineering cost data entry and processing unit. The automated data processing process can greatly reduce human intervention and error rate. The abnormal reason explanation attached when the engineering cost data review unit is returned can enable the submitting personnel to clearly understand the problem. The cost data approval operation is carried out through the review data approval processing unit, which can ensure that each approval complies with the company's established rules and regulations and legal requirements. The approval data stamping processing unit carries out strict data verification, document inspection, compliance inspection and policy verification steps to ensure the quality of the audit and reduce the audit risk.

[0105] Engineering cost data entry and processing unit, including:

[0106] Information entry module, used for:

[0107] Before entering the project settlement cost data, the person submitting the project settlement cost data should first log in to the OA system, which is the review system for the project settlement cost;

[0108] The submitter logs into the OA system and enters the task order creation interface. After entering the task order creation interface, confirm the created task order items;

[0109] The task list items include project name, business category, task name, executor and task description, among which the executor includes at least one preparer and one reviewer;

[0110] The creation of the task order is completed after the task order item is confirmed.

[0111] Specifically, through the OA system, the submitter needs to create a task order according to the established steps, including confirming key information such as project name, business category, task name, executor and task description. This standardized process ensures the accuracy and consistency of data submission. The executors in the task order include at least the preparer and the reviewer. This clear division of roles helps to clearly define responsibilities and improve the quality and efficiency of the review work. Through system automation processing, the possibility of human errors is reduced. At the same time, the system can also verify and compare the data to ensure the accuracy and consistency of the data. Through systematic management and review processes, the compliance of engineering settlement cost data can be ensured, which helps companies comply with relevant laws, regulations and industry standards and reduce legal risks.

[0112] Input information processing module, used for:

[0113] Pre-process the project data for the created task orders;

[0114] Project data preprocessing is to unify the data format of project data in the task order;

[0115] After the data format is unified, data cleaning is performed;

[0116] After data cleaning is completed, data standardization is performed;

[0117] Data validation is performed after data standardization;

[0118] Integrate the data that have passed the data verification, and obtain the cost data to be processed after data integration;

[0119] Save the cost data to be processed into the audit file.

[0120] Specifically, by unifying the format of the project data in the task order, the format differences between different data sources can be eliminated, making the subsequent data processing steps smoother. The cleaning process includes checking the integrity, accuracy, consistency and removal of duplicate data, which is an indispensable step in data preprocessing. Through standardization, data from different sources can be compared and analyzed under the same standards, which improves the comparability of data. Data verification is an important step to ensure data accuracy and integrity. By verifying the data, errors and omissions in the data can be discovered and corrected in a timely manner. The verification process includes checking whether the scope, type, relationship, etc. of the data meet expectations, ensuring the reliability of the data in subsequent analysis. Through automated data processing processes, manual intervention and error rates can be greatly reduced, and the efficiency and accuracy of data processing can be improved. It can process heterogeneous data from different data sources and different formats, so that enterprises can make full use of various data resources for analysis and decision-making. Saving the cost data to be processed in the audit file can facilitate the review and audit of auditors, thereby improving the audit efficiency.

[0121] In order to solve the problem in the prior art that when reviewing and approving data, the abnormal problems of abnormal data are not effectively identified and judged, resulting in low data accuracy, please refer to Figure 1 and Figure 2 , this embodiment provides the following technical solutions:

[0122] The engineering cost data review unit is also used for:

[0123] After the auditor logs into the OA system, he / she shall audit the cost data to be processed in the audit document;

[0124] Audit operations include manual verification and automatic verification;

[0125] Manual verification includes verification of the completeness, accuracy, rationality and compliance of the cost data to be processed;

[0126] Automatic verification is performed after manual verification is completed;

[0127] Automatic verification is to verify and compare the cost data to be processed with the standard engineering cost audit data.

[0128] Confirm the manual verification results and automatic verification results of the cost data to be processed;

[0129] If there is no abnormal data in the manual verification results and the automatic verification results, the cost data to be processed without abnormal data will be marked as cost data to be approved, and the cost data to be approved will be saved in the approval folder;

[0130] If there are abnormal data in the manual verification results and automatic verification results, the abnormal data will be marked as a problem, and the unprocessed cost data with abnormal data will be returned to the return folder of the submitter;

[0131] At the same time, when the cost data to be processed is returned, the reason for the return will be explained based on the abnormal reason of the abnormal data.

[0132] Specifically, the audit process is clearly divided into two stages: manual verification and automatic verification, making the audit process more standardized. The introduction of automatic verification reduces manual operations, improves audit efficiency, and ensures the consistency of data verification. Automatic verification further strengthens the verification of data quality by comparing with standard engineering cost audit data. It clearly stipulates how to deal with abnormal data found in manual verification and automatic verification, avoiding gray areas in the audit process. The explanation of the reason for the abnormality attached at the time of return enables the submitter to clearly understand the problem and make targeted modifications. The clear feedback mechanism helps to promote effective communication between auditors and submitters and improve audit efficiency.

[0133] The audit data approval processing unit is also used to:

[0134] After the approval personnel log in to the OA system, they shall perform data approval operations on the cost data to be approved in the approval folder;

[0135] The data approval operation is to analyze the cost data to be approved, including trend analysis, comparative analysis and risk assessment;

[0136] According to the data analysis results, the approving personnel will make an approval judgment on the cost data to be approved;

[0137] When the approval judgment result is qualified, the cost data to be approved is marked as cost data to be stamped, and the cost data to be stamped is saved in the stamping folder;

[0138] When the approval judgment result is unqualified, the cost data to be approved will be marked as problematic and returned to the reviewer's return folder;

[0139] At the same time, when the cost data to be approved is marked with problems, the approving personnel will explain the approval opinions and modification methods.

[0140] Specifically, the approval personnel perform data approval operations through the OA system, which realizes the automation and standardization of the approval process, greatly shortens the approval cycle, and provides comprehensive and accurate data support for the approval personnel through data analysis functions such as trend analysis, comparative analysis and risk assessment, which helps the approval personnel make more scientific approval judgments, and can be seamlessly connected with other systems (such as ERP, CRM, etc.) to achieve information sharing and circulation, improve the transparency of internal enterprise information, and promote the efficiency of collaboration between different departments. When the approval judgment result is unqualified, the system supports marking the cost data to be approved as a problem and returning it to the reviewer, while providing approval opinions and modification methods, which helps to optimize the cost management process and ensure the accuracy and compliance of the data. Approval operations on cost data are performed through the approval management system, which can ensure that each approval complies with the company's established rules and regulations and laws and regulations, and improve the company's compliance management level.

[0141] In order to solve the problem in the prior art that the data to be stamped is not effectively judged, and the stamped data is not securely stored and encrypted, thereby reducing data security, please refer to Figure 1 and Figure 2 , this embodiment provides the following technical solutions:

[0142] The approval data stamping processing unit is also used for:

[0143] After the stamping personnel log in to the OA system, they will make stamp judgment on the cost data to be stamped in the stamping folder;

[0144] Stamping judgment is to conduct data verification, document inspection, compliance inspection and policy inspection on the stamped cost data;

[0145] If the cost data to be stamped fails the stamping judgment, the cost data to be stamped will be marked as problematic, and the marked problematic cost data will be returned to the return folder of the approver;

[0146] After the cost data to be stamped is judged and passed, the cost data to be stamped will be stamped. The submitter can choose the stamping method by himself. The stamping methods include physical stamp or electronic stamp.

[0147] Among them, when the submitter selects the physical seal, the stamping personnel will obtain the project settlement cost data after the audit process is completed;

[0148] When the submitter chooses the electronic seal, after the stamping personnel have passed the seal, the submitter will stamp it by himself in the OA system and finally obtain the project settlement cost data after the review process is completed.

[0149] Specifically, the OA system is used to standardize the stamping process, so that each cost data to be stamped goes through the same data verification, document inspection, compliance inspection, policy inspection and other steps, ensuring the consistency and fairness of the audit. When the cost data to be stamped fails to pass the stamping judgment, the system will automatically mark the problem and return the data to the return folder of the approver. This mechanism helps to quickly identify and solve problems and avoid omissions and delays in the audit process. The returned data is marked with clear problem marks, which makes it easier for the approver to understand the problem and make corresponding modifications and improvements. It supports both physical and electronic stamping processing methods to meet the needs of different scenarios. The submitter can choose the stamping method according to the actual situation, which improves the flexibility and applicability of the system. The introduction of stamps not only improves the efficiency of stamping, but also reduces the use of paper documents. It is in line with the current trend of digital office and can handle heterogeneous data, that is, it can receive and process engineering settlement cost data from different sources, different formats, and different standards. This capability enables the system to be more widely used in various engineering projects, improving the versatility and practicality of the system. The entire stamping process is carried out in the OA system, and each step of the operation is recorded, which realizes the transparency and traceability of the audit process, which helps to ensure the fairness and accuracy of the audit, and facilitates subsequent problem tracking and responsibility identification, which can significantly improve the audit efficiency and shorten the audit cycle. At the same time, through strict data verification, document inspection, compliance inspection and policy verification steps, it can ensure the quality of the audit and reduce the risk of the audit.

[0150] The engineering settlement cost data obtained after the audit process is completed is encrypted using a symmetric encryption algorithm;

[0151] The data encryption process is to first generate an encryption key using a symmetric encryption algorithm, and then store the generated encryption key in the key management library of the OA system;

[0152] Use symmetric encryption algorithm and generated encryption key to encrypt the project settlement cost data after the audit process is completed;

[0153] After data encryption is completed, the encrypted project settlement cost data is obtained, and the encrypted project settlement cost data is encoded and marked according to the time series, name and random number, and stored in the memory of the OA system after encoding and marking.

[0154] Specifically, the symmetric encryption algorithm is known for its high-intensity encryption effect, which can ensure the security of engineering settlement cost data during transmission and storage. Through complex mathematical operations, including bit operations, permutations, iterations, etc., the generated ciphertext has sufficient randomness and security. Even if the key and ciphertext are short, it can effectively prevent the data from being illegally stolen or tampered with. The generated encryption key is stored in the key management library of the OA system, realizing the secure storage and unified management of the key, which helps to ensure the confidentiality of the key and prevent security risks caused by key leakage. After the data encryption is completed, the encrypted engineering settlement cost data is encoded and marked according to the time series, name and random number. This encoding method facilitates the classified storage and rapid retrieval of data, and improves the efficiency of data management. The encoded and marked data is stored in the memory of the OA system, realizing the centralized storage and unified management of the data, which helps to ensure the integrity and consistency of the data, and facilitates subsequent data analysis and utilization. The automated encryption process reduces management costs and reduces economic losses caused by data leakage or tampering. Through the automated encryption process, the time and error rate of manual operations are reduced, thereby improving the efficiency and accuracy of engineering cost management.

[0155] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0156] In one embodiment, the engineering cost data entry and processing unit unifies the data format of the project data in the task list, including:

[0157] Mapping rules build subunits for:

[0158] Read all data formats of heterogeneous data in the OA system, and collect the data content corresponding to the same target information in different data formats;

[0159] Define the base data format of the OA system among all data formats;

[0160] Acquire the first key field of the data content corresponding to the reference data format, and at the same time, acquire the second key field of the data content corresponding to the remaining data formats;

[0161] Acquire an association relationship between the first key field and the second key field, and determine a mapping rule set for format conversion of the remaining data format to the reference data format according to the association relationship, wherein the data formats in the remaining data format correspond to the mapping rules one by one;

[0162] The project data reading subunit is used to read the project data in the task list, determine multiple target data formats of the project data in the task list, and divide the project data according to the data formats of the project data in the task list to obtain multiple project data sets;

[0163] Data format unified subunit for:

[0164] Read the target data format of the project data in the task order and match the target mapping rules that are consistent with the target data format;

[0165] Convert the corresponding project data sets into different formats according to the target mapping rules to obtain the standard format project data corresponding to each project data set;

[0166] Integrate the standard format project data of each project data set to complete the data format unification of the project data in the task order.

[0167] In this embodiment, all data formats may be data formats of all heterogeneous data read in the OA system.

[0168] In this embodiment, the data contents corresponding to the same target information in different data formats are collected, that is, the data contents corresponding to the different data formats are regarded as the same information.

[0169] In this embodiment, defining the base data format of the OA system in all data formats may be a result of customization according to actual needs.

[0170] In this embodiment, the first key field may be core data used to characterize the data content in the reference data format, wherein the number of the first key field is 1.

[0171] In this embodiment, the second key field may be core data used to characterize the data content in the remaining data formats except the reference data format, wherein the second key field includes a plurality of fields corresponding one-to-one to each data format in the remaining data formats.

[0172] In this embodiment, the association relationship may be achieved by extracting the relevant information corresponding to the first key field and each second key field respectively in a computer learning manner, thereby realizing the association between the first key field and the second key field.

[0173] In this embodiment, the mapping rule is a conversion method between data in a non-reference format and data in a reference data format.

[0174] In this embodiment, the target data format may be a data format existing in the project data in the task list.

[0175] The working principle and beneficial effects of the above technical solution are as follows: by acquiring all data formats of heterogeneous data in the OA system and collecting the data content corresponding to the same target information in different data formats, the first key field of the data content corresponding to the baseline data format and the second key field of the data content corresponding to the remaining data formats can be effectively obtained, thereby effectively constructing a mapping rule set by determining the association between the first key field and the second key field, laying an effective foundation for format unification of heterogeneous data, and by determining the target data format of the project data in the task order, the target mapping rule consistent with the target data format in the mapping rule set is retrieved for format conversion, and the standard format project data is effectively obtained, thereby effectively completing the effectiveness and accuracy of data format unification of the project data in the task order by integrating the standard format project data, thereby providing effective data processing for the project settlement cost audit and improving the efficiency of the project settlement cost audit.

[0176] In one embodiment, in the mapping rule construction subunit, after determining the mapping rule set for converting the remaining data format into the reference data format, the following steps are included:

[0177] The verification subunit is used to:

[0178] After determining a mapping rule set for converting the remaining data formats to the reference data format, obtaining a verification sample data set corresponding to each data format in the remaining data formats except the reference data format;

[0179] Input the verification sample data set into the corresponding mapping rule for format conversion, obtain the target result of format conversion for each verification data in the verification sample data set, and at the same time, obtain the benchmark result corresponding to each verification data in the verification data set;

[0180] Calculate the accuracy of the corresponding mapping rule based on the target result and the benchmark result;

[0181] ;

[0182] in, Indicates The accuracy of the mapping rules; Indicates the sequence number value of the mapping rule; Represents the total amount of data in the validation sample data set; It indicates the total amount of data in the validation sample data set whose output target result is inconsistent with the benchmark result when the validation sample data set is input into the corresponding mapping rule for format conversion; It indicates the total amount of data in the validation sample data set whose output target result is consistent with the benchmark result when the validation sample data set is input into the corresponding mapping rule for format conversion, and ; Indicates the serial number value of the validation sample data set; Indicates that based on In the mapping rule Benchmark results corresponding to validation sample data; Indicates that based on In the mapping rule The target result after format conversion of the verification sample data;

[0183] Obtain a preset accuracy threshold, and compare the accuracy of the current mapping rule with the preset accuracy threshold to determine whether the current mapping rule is qualified;

[0184] If the accuracy of the current mapping rule is equal to or greater than the preset accuracy threshold, the current mapping rule is determined to be qualified;

[0185] Otherwise, the current mapping rule is judged to be unqualified;

[0186] The report reminder subunit is used to mark the unqualified mapping rules in the mapping rule set according to the comparison result, generate a warning report according to the marking result, and transmit the warning report to the user terminal for report reminder.

[0187] In this embodiment, the preset accuracy threshold may be set in advance and used as a standard for measuring whether the current mapping rule is qualified.

[0188] In this embodiment, the user terminal may be a mobile phone, a computer, etc.

[0189] In this embodiment, the early warning report is transmitted to the user terminal, and the user can perform operations such as parameter adjustment on the mapping rule based on experience, etc., so as to make the mapping rule accurate and qualified.

[0190] The working principle and beneficial effects of the above technical solution are: after determining the mapping rule set for format conversion of the remaining data formats to the benchmark data format, the format conversion verification is performed by obtaining the verification sample data set corresponding to each data format in the remaining data formats except the benchmark data format and the corresponding mapping rules, so as to effectively calculate the accuracy of each mapping rule according to the obtained target result, and then effectively mark the unqualified mapping rules in the mapping rule set, effectively generate report reminders and transmit them to the user terminal, which is conducive to timely grasping the qualified status of each mapping rule in the mapping rule set, and effectively ensuring the effectiveness and accuracy of format unification of heterogeneous data.

[0191] While the embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that many changes, modifications, substitutions and variations can be made to the embodiments without departing from the principles and spirit of the invention.

Claims

1. The engineering settlement cost audit system based on heterogeneous data is characterized by: include: Engineering cost data entry and processing unit, used for: The submitter logs into the OA system and enters the engineering cost data into the OA system. The entered engineering cost data is preprocessed to obtain the cost data to be processed; The engineering cost data review unit is used to: The auditor logs into the OA system and audits the pending cost data. The pending cost data that fails the audit is returned with an audit form, and the pending cost data that passes the audit is marked as pending approval cost data. Audit data approval processing unit, used to: The approval personnel log in to the OA system and approve the cost data to be approved. The approval form will be returned for the cost data that have not been approved, and the approved cost data will be marked as the cost data to be stamped. Approval data stamping processing unit, used for: The stamping personnel log in to the OA system, stamp the cost data to be stamped, and return the cost data that have not passed the stamping. After the cost data to be stamped passes the stamping, the project settlement cost data with the audit process completed will be obtained; Data preprocessing is to unify the data format of the project data in the task order, including: Mapping rules build subunits for: Read all data formats of heterogeneous data in the OA system, and collect the data content corresponding to the same target information in different data formats; Define the base data format of the OA system among all data formats; Acquire the first key field of the data content corresponding to the reference data format, and at the same time, acquire the second key field of the data content corresponding to the remaining data formats; Acquire an association relationship between the first key field and the second key field, and determine a mapping rule set for format conversion of the remaining data format to the reference data format according to the association relationship, wherein the data formats in the remaining data format correspond to the mapping rules one by one; The project data reading subunit is used to read the project data in the task list, determine multiple target data formats of the project data in the task list, and divide the project data according to the data formats of the project data in the task list to obtain multiple project data sets; Data format unified subunit for: Read the target data format of the project data in the task order and match the target mapping rules that are consistent with the target data format; Convert the corresponding project data sets into different formats according to the target mapping rules to obtain the standard format project data corresponding to each project data set; Integrate the standard format project data of each project data set to complete the data format unification of the project data in the task order; In the mapping rule construction subunit, after determining the mapping rule set for converting the remaining data format into the reference data format, the following steps are included: The verification subunit is used to: After determining a mapping rule set for converting the remaining data formats to the reference data format, obtaining a verification sample data set corresponding to each data format in the remaining data formats except the reference data format; Input the verification sample data set into the corresponding mapping rule for format conversion, obtain the target result of format conversion for each verification data in the verification sample data set, and at the same time, obtain the benchmark result corresponding to each verification data in the verification data set; Calculate the accuracy of the corresponding mapping rule based on the target result and the benchmark result; ； in, Indicates The accuracy of the mapping rules; Indicates the sequence number value of the mapping rule; Represents the total amount of data in the validation sample data set; It indicates the total amount of data in the validation sample data set whose output target result is inconsistent with the benchmark result when the validation sample data set is input into the corresponding mapping rule for format conversion; It indicates the total amount of data in the validation sample data set whose output target result is consistent with the benchmark result when the validation sample data set is input into the corresponding mapping rule for format conversion, and ; Indicates the serial number value of the validation sample data set; Indicates that based on The mapping rule Benchmark results corresponding to validation sample data; Indicates that based on In the mapping rule The target result after format conversion of the verification sample data; Obtain a preset accuracy threshold, and compare the accuracy of the current mapping rule with the preset accuracy threshold to determine whether the current mapping rule is qualified; If the accuracy of the current mapping rule is equal to or greater than the preset accuracy threshold, the current mapping rule is determined to be qualified; Otherwise, the current mapping rule is judged to be unqualified; The report reminder subunit is used to mark the unqualified mapping rules in the mapping rule set according to the comparison result, generate a warning report according to the marking result, and transmit the warning report to the user terminal for report reminder.

2. The engineering settlement cost audit system based on heterogeneous data according to claim 1 is characterized in that: The engineering cost data entry and processing unit comprises: Information entry module, used for: Before entering the project settlement cost data, the person submitting the project settlement cost data should first log in to the OA system, which is the review system for the project settlement cost; The submitter logs into the OA system and enters the task order creation interface. After entering the task order creation interface, confirm the created task order items; The task list items include project name, business category, task name, executor and task description, among which the executor includes at least one preparer and one reviewer; The creation of the task order is completed after the task order item is confirmed.

3. The engineering settlement cost audit system based on heterogeneous data according to claim 2 is characterized in that: The engineering cost data entry and processing unit further includes: Input information processing module, used for: Pre-process the project data for the created task orders; Project data preprocessing is to unify the data format of project data in the task order; After the data format is unified, data cleaning is performed; After data cleaning is completed, data standardization is performed; Data validation is performed after data standardization; Integrate the data that have passed the data verification, and obtain the cost data to be processed after data integration; Save the cost data to be processed into the audit file.

4. The engineering settlement cost audit system based on heterogeneous data according to claim 3 is characterized in that: The engineering cost data review unit is also used for: After the auditor logs into the OA system, he / she shall audit the cost data to be processed in the audit document; Audit operations include manual verification and automatic verification; Manual verification includes verification of the completeness, accuracy, rationality and compliance of the cost data to be processed; Automatic verification is performed after manual verification is completed; Automatic verification is to verify and compare the cost data to be processed with the standard engineering cost audit data.

5. The engineering settlement cost audit system based on heterogeneous data according to claim 4 is characterized in that: The engineering cost data review unit is also used for: Confirm the manual verification results and automatic verification results of the cost data to be processed; If there is no abnormal data in the manual verification results and the automatic verification results, the cost data to be processed without abnormal data will be marked as cost data to be approved, and the cost data to be approved will be saved in the approval folder; If there are abnormal data in the manual verification results and automatic verification results, the abnormal data will be marked as a problem, and the unprocessed cost data with abnormal data will be returned to the return folder of the submitter; At the same time, when the cost data to be processed is returned, the reason for the return will be explained based on the abnormal reason of the abnormal data.

6. The engineering settlement cost audit system based on heterogeneous data according to claim 5 is characterized in that: The audit data approval processing unit is also used to: After the approval personnel log in to the OA system, they shall perform data approval operations on the cost data to be approved in the approval folder; The data approval operation is to analyze the cost data to be approved, including trend analysis, comparative analysis and risk assessment; According to the data analysis results, the approving personnel will make an approval judgment on the cost data to be approved; When the approval judgment result is qualified, the cost data to be approved is marked as cost data to be stamped, and the cost data to be stamped is saved in the stamping folder; When the approval judgment result is unqualified, the cost data to be approved will be marked as problematic and returned to the reviewer's return folder; At the same time, when the cost data to be approved is marked with problems, the approving personnel will explain the approval opinions and modification methods.

7. The engineering settlement cost audit system based on heterogeneous data according to claim 6 is characterized in that: The approval data stamping processing unit is also used for: After the stamping personnel log in to the OA system, they will make stamp judgment on the cost data to be stamped in the stamping folder; Stamping judgment is to conduct data verification, document inspection, compliance inspection and policy inspection on the stamped cost data; If the cost data to be stamped fails the stamping judgment, the cost data to be stamped will be marked as problematic, and the marked problematic cost data will be returned to the return folder of the approver; After the cost data to be stamped is judged and passed, the cost data to be stamped will be stamped. The submitter can choose the stamping method by himself. The stamping methods include physical stamp or electronic stamp. Among them, when the submitter selects the physical seal, the stamping personnel will obtain the project settlement cost data after the audit process is completed; When the submitter chooses the electronic seal, after the stamping personnel have passed the seal, the submitter will stamp it by himself in the OA system and finally obtain the project settlement cost data after the review process is completed.

8. The engineering settlement cost review system based on heterogeneous data according to claim 7 is characterized in that: The approval data stamping processing unit is also used for: The engineering settlement cost data obtained after the audit process is completed is encrypted using a symmetric encryption algorithm; The data encryption process is to first generate an encryption key using a symmetric encryption algorithm, and then store the generated encryption key in the key management library of the OA system; Use symmetric encryption algorithm and generated encryption key to encrypt the project settlement cost data after the audit process is completed; After data encryption is completed, the encrypted project settlement cost data is obtained, and the encrypted project settlement cost data is encoded and marked according to the time series, name and random number, and stored in the memory of the OA system after encoding and marking.

Images