CN114666321B - Supervision report data processing method, device, equipment, medium and product - Google Patents

Supervision report data processing method, device, equipment, medium and product Download PDF

Info

Publication number
CN114666321B
CN114666321B CN202210280030.7A CN202210280030A CN114666321B CN 114666321 B CN114666321 B CN 114666321B CN 202210280030 A CN202210280030 A CN 202210280030A CN 114666321 B CN114666321 B CN 114666321B
Authority
CN
China
Prior art keywords
data
message
report
information
generating
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202210280030.7A
Other languages
Chinese (zh)
Other versions
CN114666321A (en
Inventor
郭秀连
李鹏
邓杨
周琳琳
曾垂鑫
蔡朴锐
廖清碧
陈俊
林晓苑
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN202210280030.7A priority Critical patent/CN114666321B/en
Publication of CN114666321A publication Critical patent/CN114666321A/en
Application granted granted Critical
Publication of CN114666321B publication Critical patent/CN114666321B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/06Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/04Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L69/00Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
    • H04L69/03Protocol definition or specification 

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Signal Processing (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Technology Law (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Computer Security & Cryptography (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention discloses a supervision report data processing method, a supervision report data processing device, supervision report data processing equipment, supervision report data processing media and supervision report data processing products. The invention relates to the technical field of big data. The method comprises the following steps: acquiring transaction data of a transaction component, processing the transaction data according to supervision requirements, and generating a message increment table based on the processed transaction data; the method comprises the steps of sending data in a message increment table to an information reporting system, processing the data in the message increment table according to interface specifications through the information reporting system to generate a message, and sending the message to a monitoring end; responding to an access request of a business personnel terminal through an information report management system, generating a report data statistical table based on data in the message increment table, and sending the report data statistical table to the business personnel terminal for display. The embodiment of the invention solves the problem of inaccurate data reporting caused by the fact that each line of message is split and a single message contains multiple pieces of branch line data, and also solves the problem of front-end display.

Description

Supervision report data processing method, device, equipment, medium and product
Technical Field
The embodiment of the invention relates to the technical field of big data, in particular to a method, a device, equipment, a medium and a product for processing supervision report data.
Background
In recent years, under the situation of strict supervision and strong compliance, the supervision department increases the checking punishment force for account data report of the personal bank of the RMB. Therefore, each row starts to pay high attention to the personal settlement account data reporting work, and the personal settlement account data reporting is ensured to be complete strictly according to the requirements of the implementation supervision regulations.
The traditional data reporting mode realizes the loading and processing of batch data files through a batch job scheduling platform, specifically copies data from a database, loads the data and triggers downstream data processing script operation, and finally triggers the unloading to data transmission to complete reporting tasks of a monitoring end. However, the current report mode has the problems that the accuracy of the report message is affected and the front end display is also carried out because each line of message is split and a single message contains multiple lines of branch data.
Disclosure of Invention
The invention provides a method, a device, equipment, a medium and a product for processing supervision report data, which can solve the problems of report message accuracy and front end display.
According to an aspect of the present invention, there is provided a method for processing supervision report data, including:
Acquiring transaction data of a transaction component, processing the transaction data according to supervision requirements, and generating a message increment table based on the processed transaction data;
the method comprises the steps of sending data in a message increment table to an information reporting system, processing the data in the message increment table according to interface specifications through the information reporting system to generate a message, and sending the message to a monitoring end;
Responding to an access request of a business personnel terminal through an information report management system, generating a report data statistical table based on data in the message increment table, and sending the report data statistical table to the business personnel terminal for display.
According to another aspect of the present invention, there is provided a supervision report data processing apparatus including:
The data processing module is used for executing and acquiring transaction data of the transaction component, processing the transaction data according to the supervision requirement and generating a message increment table based on the processed transaction data;
the data reporting module is used for executing the data in the message increment table to be sent to the information reporting system, processing the data in the message increment table according to the interface specification by the information reporting system to generate a report message, and sending the report message to the monitoring end;
And the data statistics module is used for responding to the access request of the business personnel terminal through the information report management system, generating a report data statistics table based on the data in the message increment table, and sending the report data statistics table to the business personnel terminal for display.
According to another aspect of the present invention, there is provided an electronic apparatus including:
At least one processor; and
A memory communicatively coupled to the at least one processor; wherein,
The memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the supervisory report data processing method according to any of the embodiments of the present invention.
According to another aspect of the present invention, there is provided a computer readable storage medium storing a computer program for causing a processor to execute the method for processing supervision report data according to any one of the embodiments of the present invention.
According to another aspect of the present invention there is provided a computer program product comprising a computer program which when executed by a processor implements the method of supervision report data processing according to any one of the embodiments of the present invention.
According to the technical scheme, the message increment table is generated by acquiring and processing transaction data, the data in the message increment table is sent to the information reporting system, the message is generated by processing the data in the message increment table according to the interface specification through the information reporting system, then the message is sent to the monitoring end by the head office, the situation that each row of messages are split and contain multiple pieces of branch data is avoided, in addition, the message data statistics table is generated by the information reporting management system based on the data in the message increment table, and the message data statistics table is sent to the business personnel end for display, so that the problem of front-end display is solved.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1a is a flowchart of a method for processing supervision report data according to an embodiment of the present invention;
FIG. 1b is a logic block diagram of a process flow for supervising reporting data according to an embodiment of the present invention;
fig. 1c is a schematic diagram of a reporting flow for supervising reporting data according to an embodiment of the present invention;
FIG. 2 is a flowchart of another method for processing supervision report data according to an embodiment of the present invention;
FIG. 3 is a flowchart of another method for processing supervision report data according to an embodiment of the present invention;
Fig. 4 is a schematic structural diagram of a supervision report data processing device according to an embodiment of the present invention;
Fig. 5 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus. The technical scheme of the invention obtains, stores, uses, processes and the like the data, which all meet the relevant regulations of national laws and regulations.
Fig. 1a is a flowchart of a method for processing supervision and report data according to an embodiment of the present invention, where the method may be performed by a supervision and report data processing device, and the supervision and report data processing device may be implemented in hardware and/or software, and the supervision and report data processing device may be configured in an electronic device. As shown in fig. 1a, the method comprises:
S110, acquiring transaction data of the transaction component, processing the transaction data according to supervision requirements, and generating a message increment table based on the processed transaction data.
The transaction component is a computer program packaged with transaction data and methods, transaction service is realized through the transaction component, and the transaction component generates the transaction data in the process of providing service. In particular, the transaction component may include components that implement various financial services. For example, transaction components include loan components, deposit components, bond components, credit card components, and the like.
Under the condition that the transaction data comprises personal business card account information and identity card information, the credit card account reporting function is optimized by adding the personal business card account information, the data reporting is facilitated, when the identity card information is special type identity card information, format adjustment is carried out on the special type identity card information according to reporting requirements, and convenience is provided for personalized treatment while the commonality is met through the format adjustment of the special type identity card.
The transaction data is processed into the data integration layer, the format of the transaction data is adjusted according to the supervision requirement, and the transaction data of the corresponding type can be respectively sent to the data lake and the source pasting layer of the data integration layer according to the reporting type. Types of reimbursement include funds flow and account information, etc. Fig. 1b is a logic block diagram of a process flow for supervising report data according to an embodiment of the present invention. As shown in fig. 1b, the data integration layer comprises a data lake, a clouding number bin, a source layer, a public computing module and a supervision computing area module. The data lake comprises a file cache area, a batch data area and a real-time data area so as to meet the requirements of real-time reporting and batch synchronization. And reading batch transaction data from the batch data area through the cloud storage digital bin, and processing the batch transaction data, including data integration, processing according to indexes or labels and the like. And reading real-time transaction data from the real-time data area through the cloud storage digital bin, and processing the real-time transaction data, including data integration, processing according to indexes or labels and the like. And sending the data processed by the clouding number bin to a supervision and calculation area module, and processing the data processed by the clouding number bin through supervision and calculation rules in the supervision and calculation area module. The source layer is used for backing up transaction data in the service source database, and the backed up transaction data is subjected to data cleaning and other processing through the source layer. And processing the transaction data output by the source layer through a public calculation rule in the public calculation module. And processing the transaction data output by the public computing module through the supervision computing rule in the supervision computing area module. And generating a message increment table based on the processed transaction data output by the data integration layer, and outputting the message increment table to the management analysis layer through data service or copying and other modes. The message increment table is a data table for storing the original data of the transaction to be reported. The management analysis layer comprises an information reporting system, an information reporting management system and the like.
Illustratively, transaction data of the transaction component is acquired through the file transfer component NFT, and the transaction data is transferred to a data lake or a paste source layer; classifying and processing the transaction data based on characteristic attributes of the transaction data through a data lake or a source pasting layer according to supervision requirements, and generating a message increment table according to various processed transaction data, wherein the message increment table comprises processed client information and processed specific account information, and the specific account information comprises debit card, living passbook, quasi credit card account information, credit card account fine information and dragon payment wallet account processing information. It should be noted that, the specific account information is determined based on the regulatory requirement, and if the regulatory requirement changes, the specific account is correspondingly increased or decreased.
Optionally, classifying and processing are performed by the data lake or the source layer according to the supervision requirement based on the characteristic attribute of the transaction data, and a message increment table is generated according to various processed transaction data, which specifically comprises the following steps:
Screening transaction data based on user attributes and bank card attributes through a data lake or a source layer to generate a client information table and a specific account information table; associating the client information table with the specific account information table according to the data association relation of the transaction data; processing the data in the correlated client information table and the data in the specific account information table according to the supervision requirement, and generating a message increment table according to the processed data in the client information table and the data in the specific account information table.
S120, sending the data in the message increment table to an information reporting system, processing the data in the message increment table according to an interface specification by the information reporting system to generate a message, and sending the message to a monitoring end.
The information reporting system points to a supervision reporting system of the supervision organization for reporting data. The bank headquarter and the branch staff can report data to the supervision mechanism through the information reporting system. In the embodiment of the invention, the data is reported to the supervision mechanism by the information reporting system for the bank headquarters.
The interface specification is a relevant specification in the transport protocol agreed with the regulatory body. And determining the format of the message through interface specifications.
Illustratively, the message increment table is converted into a file with a specific format, and data in the message increment table is sent to the information reporting system through the file transmission component NFT. The information reporting system processes data in the message increment table according to the interface specification to generate a report message, and the report message is transmitted to the monitoring end through the message queue MQ interface. The report message is sent to the supervision terminal in a MQ direct connection mode, so that report instantaneity can be provided.
In a specific embodiment, the reporting process of the supervision reporting data comprises links such as data access, data processing, data unloading, data reporting and the like. Fig. 1c is a schematic diagram of a reporting flow for monitoring reporting data according to an embodiment of the present invention. As shown in fig. 1c, the data sources of the data access link include information management for private customers, debit cards (for private), deposit for private, issue cards, business approval (credit cards), electronic banking, product development, institution management, format verification errors, logic verification errors, and the like. And the data access data integration layer performs data processing. The data processing specifically comprises processing of customer information, processing of debit cards, goods period passbooks, processing of quasi-credit card accounts, processing of dragon payment wallet accounts and the like, and a message increment table is generated based on processed data. Pre-checking the data in the message increment table, generating a daily increment message interface table based on the pre-checked qualified data, and generating a pre-check error detail table based on the pre-checked unqualified data. And generating a message section total table based on the data in the daily increment message interface table. Data in the daily increment message interface table is subjected to unloading processing to obtain data in a set format, the data is sent to an information reporting system through a file transmission assembly NFT, the information reporting system is used for carrying out message splitting, message compression and message encryption to obtain a message, and the message is transmitted to a monitoring end through a message queue MQ interface. And sending the message to the monitoring end in a MQ direct connection mode.
Optionally, after sending the report message to the supervision end, the method further includes obtaining a report Wen Huizhi sent by the supervision end, and determining whether the report is successful according to a code value in the message return license. Specifically, after sending the report message, if the code value in the received message return license is a preset value indicating that the report is successful, the report success is determined, the report state of the message is recorded as the report success, and otherwise, the report failure is recorded. When the business personnel inquires the message receiving and transmitting condition, the message receiving and transmitting condition can be obtained by inquiring the message sending state.
Optionally, before sending the data in the message increment table to the information reporting system, the method further comprises: performing format verification on the data in the message increment table; generating a daily increment message interface table based on the data meeting the format requirement in the message increment table, copying the data in the daily increment message interface table to a set database, and generating a message section full table. And converting the daily increment message interface table into a file in a specific format, and transmitting data in the daily increment message interface table to the information reporting system through the file transmission component NFT. The database is set as a pre-configured database for storing data in a daily increment message interface table.
S130, responding to an access request of a business personnel terminal through an information report management system, generating a report data statistical table based on data in the message increment table, and sending the report data statistical table to the business personnel terminal for display.
The data statistics table is generated based on the checking requirement or the supervision and assessment requirement of front-end service personnel. Specifically, the data statistics table contains data of various dimensions meeting the requirement of checking or supervision and assessment. For example, the data statistics include report data statistics, error correction statistics, and key data item specific statistics. And counting, displaying and distributing the reported data through the data statistics table. And counting, displaying and distributing the pre-checking errors or the checking errors fed back by the supervision end through the error counting table. And displaying and distributing the verification error correction condition through the error correction statistics table. And realizing the statistics and display of the key data through the key data special statistics table. The key data comprises a financial institution code missing condition, a financial institution code not maintained by an entity institution in an institution component, a verification result unreal condition and the like.
Illustratively, responding to an access request of a service personnel end through an information reporting management system, and acquiring data in a message section full-scale table; and screening data in the report Wen Jiemian full scale according to the set dimension, generating a report data statistical table, and sending the report data statistical table to a business personnel end for display. Specifically, statistics is carried out on data in the message section full-scale according to the dimensions of time, a mechanism, a reporting element and the like, a reporting data statistical table is generated, and the reporting data statistical table is sent to a business personnel end for display, so that the business personnel can conveniently master the data reporting condition.
According to the technical scheme, the message increment table is generated by acquiring and processing transaction data, the data in the message increment table is sent to the information reporting system, the message is generated by processing the data in the message increment table according to the interface specification through the information reporting system, then the message is sent to the monitoring end by the head office, the situation that each row of messages are split and contain multiple pieces of branch data is avoided, in addition, the message data statistics table is generated by the information reporting management system based on the data in the message increment table, and the message data statistics table is sent to the business personnel end for display, so that the problem of front-end display is solved.
Fig. 2 is a flowchart of another method for processing supervision report data according to an embodiment of the present invention, where the method further includes performing a pre-verification process on the data in the message increment table after performing a format verification on the data in the message increment table on the basis of the foregoing embodiment. As shown in fig. 2, the method includes:
S210, acquiring transaction data of a transaction component, processing the transaction data according to supervision requirements, and generating a message increment table based on the processed transaction data.
S220, carrying out format verification on the data in the message increment table, judging whether the data in the message increment table meets the format requirement, if so, executing S230, otherwise, executing S250.
By analyzing the check errors of the historical report data, abstracting the check rules related to the format errors, performing format check on the data in the message increment table by the check rules, and judging whether the data in the message increment table meets the format requirement or not based on the format check result.
S230, generating a daily increment message interface table based on the data meeting the format requirement in the message increment table, sending the data in the daily increment message interface table to an information reporting system, processing the data in the message increment table according to interface specifications by the information reporting system to generate a message, and sending the message to a monitoring end.
S240, copying the data in the daily increment message interface table to a set database to generate a message section total table.
S250, generating a pre-verification error detail table based on the data which does not meet the format requirement in the message increment table, generating a pre-verification error statistical table based on the pre-verification error detail table according to time and mechanism dimension by the information reporting management system, and transmitting the pre-verification error statistical table to a corresponding mechanism subsystem.
The method includes the steps of generating a pre-verification error detail table based on data which does not meet format requirements in a message increment table, sending the pre-verification error detail table to a subsystem of a corresponding mechanism and displaying the pre-verification error detail table so as to prompt business personnel of the corresponding mechanism to correct transaction data. The corrected transaction data may be reported to the monitoring end together with the transaction data collected at the next report. Optionally, if the reporting is unsuccessful, reporting again is performed, where the corrected transaction data and the data meeting the format requirement in the message increment table are taken as the transaction data together.
And S260, responding to an access request of a business personnel terminal through the information report management system, acquiring the data in the report Wen Jiemian full scale, screening the data in the report Wen Jiemian full scale according to a set dimension, generating a report data statistical table, and sending the report data statistical table to the business personnel terminal for display.
According to the technical scheme, format pre-verification is carried out on the data in the message increment table, whether the data in the message increment table meets the format requirement is judged, the data in the message increment table meeting the format requirement is reported, and accuracy of reporting the data is improved; generating a pre-check error detail table for the data in the message increment table which does not meet the format requirement, generating a pre-check error statistical table based on the pre-check error detail table according to time and the mechanism dimension, and giving the pre-check error statistical table to a corresponding mechanism subsystem, so that the verification error information is displayed at the front end, and the timeliness of pre-check error data reporting is improved.
Fig. 3 is a flowchart of another method for processing supervision report data according to an embodiment of the present invention, where the method further includes a step of displaying a verification error and an error correction condition after sending the report message to a supervision end based on the above embodiment. The check errors comprise pre-check errors and check errors fed back by the supervision end. The error correction conditions comprise a pre-check error correction condition and a check error correction condition fed back by a supervision end. As shown in fig. 3, the method includes:
S310, acquiring transaction data of the transaction component, processing the transaction data according to supervision requirements, and generating a message increment table based on the processed transaction data.
The transaction data comprises incremental transaction data and correction transaction data, wherein the incremental transaction data is transaction data which is increased compared with the last report in the transaction component, and the correction transaction data is transaction data which is corrected based on a feedback message and is reported last.
The incremental transaction data and the correction transaction data of the transaction component are obtained through the file transmission component NFT, the incremental transaction data and the correction transaction data are processed according to the supervision requirements, and the message increment table is generated based on the processed incremental transaction data and the correction transaction data.
S320, performing format verification on the data in the message increment table, judging whether the data in the message increment table meets the format requirement, if so, executing S330, otherwise, executing S350.
S330, generating a daily increment message interface table based on the data meeting the format requirement in the message increment table, sending the data in the daily increment message interface table to an information reporting system, processing the data in the message increment table according to interface specifications by the information reporting system to generate a message, and sending the message to a monitoring end.
S340, copying the data in the daily increment message interface table to a set database to generate a message section total table.
S350, generating a pre-verification error detail table based on the data which does not meet the format requirement in the message increment table, generating a pre-verification error statistical table based on the pre-verification error detail table according to time and mechanism dimension by the information reporting management system, and transmitting the pre-verification error statistical table to a corresponding mechanism subsystem.
S360, acquiring a feedback message of the supervision end, and sending the feedback message to an information reporting management system, wherein the feedback message comprises format check error information and/or logic check error information.
And S370, generating a checking error statistical table based on the feedback message through the information reporting management system according to time and mechanism dimension, and sending the checking error statistical table to a corresponding mechanism subsystem.
The information reporting management system generates a check error statistical table based on the format check error information and/or the logic check error information in the feedback message according to two dimensions of time and the mechanism, and sends the check error statistical table to the corresponding mechanism subsystem so as to prompt a branch business personnel to correct the check data with errors to be reported through the corresponding mechanism subsystem, thereby obtaining corrected transaction data.
S380, generating an error correction statistic table based on the correction transaction data according to time and mechanism dimension by the information reporting management system.
Wherein the corrected transaction data includes transaction data corrected based on the verification error statistics and transaction data corrected based on the pre-verification error details.
Illustratively, the first error correction statistic table is generated by the messaging management system in terms of time and organization two dimensions based on the transaction data corrected by the verification error statistic table. And generating a second error correction statistical table based on transaction data corrected by the pre-verification error detail table according to two dimensions of time and an organization by the information reporting management system.
Optionally, according to the supervision and assessment requirements, an error third error correction statistical table can be generated by the information reporting management system according to two dimensions of time and an organization based on the transaction data corrected by the verification error statistical table and the transaction data corrected by the pre-verification error detail table.
S390, responding to the access request of the business personnel end by the information report management system, acquiring the data in the report Wen Jiemian full scale, screening the data in the report Wen Jiemian full scale according to the set dimension, generating a report data statistical table, and sending the report data statistical table to the business personnel end for display.
According to the technical scheme, the information report management system generates the check error statistical table based on the feedback message according to the time and the mechanism dimension, and the check error statistical table is sent to the corresponding mechanism subsystem, so that check errors fed back by the supervision end are displayed through the front-end system, and service personnel can check the check errors conveniently; and an error correction statistical table is generated based on correction transaction data according to time and mechanism dimension by the information reporting management system, so that real-time synchronization of correction conditions of the branch error data is facilitated.
Fig. 4 is a schematic structural diagram of a supervision report data processing device according to an embodiment of the present invention. The supervision report processing device can be realized in a form of hardware and/or software, and the supervision report data processing device can be configured in the electronic equipment. As shown in fig. 4, the apparatus includes: a data processing module 410, a data reporting module 420 and a data statistics module 430.
The data processing module 410 is configured to perform obtaining transaction data of the transaction component, process the transaction data according to the supervision requirement, and generate a message increment table based on the processed transaction data;
The data reporting module 420 is configured to perform sending of data in the message increment table to an information reporting system, process the data in the message increment table according to an interface specification by the information reporting system to generate a report message, and send the report message to a monitoring end;
The data statistics module 430 is configured to respond to an access request of a service personnel terminal through the information reporting management system, generate a reporting data statistics table based on data in the message increment table, and send the reporting data statistics table to the service personnel terminal for display.
Optionally, the data processing module 410 includes:
The data transmission sub-module is used for executing the transaction data of the transaction component obtained through the file transmission component NFT and transmitting the transaction data to the data lake or the source layer;
and the data processing sub-module is used for performing classification and processing based on the characteristic attribute of the transaction data through the data lake or the source pasting layer according to the supervision requirement, and generating a message increment table according to various processed transaction data, wherein the message increment table comprises processed client information and processed specific account information.
Optionally, the data processing submodule is specifically configured to perform:
Screening the transaction data based on user attributes and bank card attributes through the data lake or the source layer to generate a client information table and a specific account information table;
The client information table and the specific account information table are associated according to the data association relation of the transaction data;
And processing the data in the associated client information table and the data in the specific account information table according to the supervision requirement, and generating a message increment table according to the processed data in the client information table and the data in the specific account information table.
Optionally, the apparatus further comprises:
The pre-checking module is used for performing format check on the data in the message increment table before the data in the message increment table is sent to the information reporting system;
the generation module is used for executing the generation of a daily increment message interface table based on the data meeting the format requirement in the message increment table, copying the data in the daily increment message interface table to a set database and generating a message section total table;
And, the datagram module 420 is specifically configured to perform:
And sending the data in the daily increment message interface list to the information reporting system.
Optionally, the apparatus further comprises:
And the pre-verification error statistics module is used for generating a pre-verification error detail table based on the data which does not meet the format requirement in the message increment table after the format verification is carried out on the data in the message increment table, generating a pre-verification error statistics table based on the pre-verification error detail table according to time and the mechanism dimension by the information report management system, and sending the pre-verification error statistics table to the corresponding mechanism subsystem.
Optionally, the data statistics module 430 is specifically configured to perform:
responding to an access request of a service personnel end through the information report management system to acquire data in the report Wen Jiemian full scale;
And screening the data in the report Wen Jiemian full scale according to the set dimension to generate a report data statistical table.
Optionally, the apparatus further comprises:
The feedback message acquisition module is used for acquiring a feedback message of the supervision terminal after the report message is sent to the supervision terminal, and sending the feedback message to the information report management system, wherein the feedback message comprises format check error information and/or logic check error information;
And generating a checking error statistical table based on the feedback message by the information reporting management system according to time and mechanism dimension, and sending the checking error statistical table to a corresponding mechanism subsystem.
Optionally, the data processing module 410 is specifically configured to perform:
And acquiring incremental transaction data and correction transaction data of a transaction component through a file transmission component NFT, wherein the incremental transaction data are transaction data which are increased compared with the last report in the transaction component, and the correction transaction data are transaction data which are corrected based on the feedback message and are reported last.
Optionally, the apparatus further comprises:
And the correction table generation module is used for executing the generation of an error correction statistical table based on the correction transaction data according to time and mechanism dimension by the information report management system after the incremental transaction data and the correction transaction data of the transaction component are acquired through the file transmission component NFT.
Optionally, the apparatus further comprises:
And the receipt acquisition module is used for acquiring the report Wen Huizhi sent by the supervision terminal after the report message is sent to the supervision terminal, and determining whether the report is successful according to the code value in the report.
Optionally, the transaction data includes personal business card account information and identity document information, and when the identity document information is special type document information, format adjustment is performed on the special type document information according to the reporting requirement.
The supervision report data processing device provided by the embodiment of the invention can execute the supervision report data processing method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
Fig. 5 is a block diagram of an electronic device according to an embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 5, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as the administrative report data processing method.
In some embodiments, the administrative report data processing method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. One or more of the steps of the supervisory report data processing method described above may be performed when the computer program is loaded into RAM 13 and executed by processor 11. Alternatively, in other embodiments, processor 11 may be configured to perform the administration report data processing method in any other suitable manner (e.g., by means of firmware).
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
The embodiments of the present application also provide a computer program product comprising a computer program which, when executed by a processor, implements a method of supervision report data processing as provided by any of the embodiments of the present application.
Computer program product in the implementation, the computer program code for carrying out operations of the present invention may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims (12)

1. A method for processing supervision report data, comprising:
the method comprises the steps that transaction data of a transaction component are obtained through a file transmission component NFT, the transaction data are transmitted to a data lake or a source pasting layer, the data lake comprises a file cache area, a batch data area and a real-time data area so as to meet real-time reporting and batch synchronization requirements, and the source pasting layer is used for backing up the transaction data in a service source database;
Screening the transaction data based on user attributes and bank card attributes through the data lake or the source layer to generate a client information table and a specific account information table;
The client information table and the specific account information table are associated according to the data association relation of the transaction data;
Processing the associated client information in-table data and the specific account information in-table data according to the supervision requirement, and generating a message increment table according to the processed client information in-table data and the specific account information in-table data, wherein the message increment table comprises processed client information and processed specific account information;
Pre-checking the data in the message increment table, generating a daily increment message interface table based on the pre-checked qualified data, generating a message section full table based on the data in the daily increment message interface table, transmitting the data in the message increment table to an information reporting system, processing the data in the message increment table according to interface specifications by the information reporting system to generate a report message, and transmitting the report message to a monitoring end;
Responding to an access request of a business personnel terminal through an information report management system, generating a report data statistical table based on data in the message increment table, and sending the report data statistical table to the business personnel terminal for display, wherein the method comprises the following steps: responding to an access request of a business personnel end by the information report management system, acquiring data in the report Wen Jiemian full scale, screening the data in the report Wen Jiemian full scale according to a set dimension, generating a report data statistical table, and sending the report data statistical table to the business personnel end for display;
generating a pre-verification error detail table based on the data with unqualified pre-verification, generating a pre-verification error statistical table based on the pre-verification error detail table according to time and mechanism dimension by the information reporting management system, and sending the pre-verification error statistical table to a corresponding mechanism subsystem.
2. The method of claim 1, wherein pre-checking the data in the message increment table, generating a daily increment message interface table based on pre-checked qualified data, and generating a message section full table based on data in the daily increment message interface table, comprises:
performing format verification on the data in the message increment table;
Generating a daily increment message interface table based on the data meeting the format requirement in the message increment table, copying the data in the daily increment message interface table to a set database, and generating a message section total table;
And the system for sending the data in the message increment table to the information reporting system comprises:
And sending the data in the daily increment message interface list to the information reporting system.
3. The method of claim 2, wherein generating a pre-verification error schedule based on pre-verification failed data, generating a pre-verification error statistics based on the pre-verification error schedule by the information delivery management system according to time and facility dimensions, and transmitting the pre-verification error statistics to a corresponding facility subsystem, comprises:
Generating a pre-check error detail table based on the data which does not meet the format requirement in the message increment table, generating a pre-check error statistical table based on the pre-check error detail table according to time and mechanism dimension by the information reporting management system, and transmitting the pre-check error statistical table to a corresponding mechanism subsystem.
4. The method of claim 1, further comprising, after said sending said report message to a policing end:
The method comprises the steps of obtaining a feedback message of the supervision end, and sending the feedback message to an information reporting management system, wherein the feedback message comprises format check error information and/or logic check error information;
And generating a checking error statistical table based on the feedback message by the information reporting management system according to time and mechanism dimension, and sending the checking error statistical table to a corresponding mechanism subsystem.
5. The method of claim 4, wherein the obtaining, by the file transfer component NFT, transaction data of the transaction component comprises:
And acquiring incremental transaction data and correction transaction data of a transaction component through a file transmission component NFT, wherein the incremental transaction data are transaction data which are increased compared with the last report in the transaction component, and the correction transaction data are transaction data which are corrected based on the feedback message and are reported last.
6. The method of claim 5, further comprising, after the obtaining, by the file transfer component NFT, the incremental transaction data and the revised transaction data for the transaction component:
and generating an error correction statistic table based on the correction transaction data according to time and mechanism dimension by the information reporting management system.
7. The method of claim 1, further comprising, after said sending said report message to a policing end:
and acquiring the report Wen Huizhi sent by the supervision terminal, and determining whether the report is successful or not according to the code value in the message return license.
8. The method of claim 1, wherein the transaction data includes personal commerce card account information and identity document information, and wherein when the identity document information is a special type of document information, the special type of document information is formatted according to a reporting requirement.
9. A supervisory report data processing apparatus comprising:
the data processing module is used for executing the transaction data of the transaction component obtained through the file transmission component NFT, and transmitting the transaction data to a data lake or a source pasting layer, wherein the data lake comprises a file cache area, a batch data area and a real-time data area so as to meet the requirements of real-time reporting and batch synchronization, and the source pasting layer is a backup of the transaction data in a service source database;
Screening the transaction data based on user attributes and bank card attributes through the data lake or the source layer to generate a client information table and a specific account information table;
The client information table and the specific account information table are associated according to the data association relation of the transaction data;
Processing the associated client information in-table data and the specific account information in-table data according to the supervision requirement, and generating a message increment table according to the processed client information in-table data and the specific account information in-table data, wherein the message increment table comprises processed client information and processed specific account information;
The data reporting module is used for executing pre-verification on the data in the message increment table, generating a daily increment message interface table based on the pre-verified data, generating a message section full table based on the data in the daily increment message interface table, transmitting the data in the message increment table to the information reporting system, processing the data in the message increment table according to interface specifications by the information reporting system to generate a message, and transmitting the message to a monitoring end;
The data statistics module is used for executing the response to the access request of the business personnel terminal through the information report management system, generating a report data statistics table based on the data in the message increment table, and sending the report data statistics table to the business personnel terminal for display, and comprises the following steps: responding to an access request of a business personnel end by the information report management system, acquiring data in the report Wen Jiemian full scale, screening the data in the report Wen Jiemian full scale according to a set dimension, generating a report data statistical table, and sending the report data statistical table to the business personnel end for display;
The data reporting module is further used for executing generation of a pre-verification error detail table based on the pre-verification unqualified data, generating a pre-verification error statistical table based on the pre-verification error detail table according to time and mechanism dimension through the information reporting management system, and sending the pre-verification error statistical table to a corresponding mechanism subsystem.
10. An electronic device, the electronic device comprising:
At least one processor; and
A memory communicatively coupled to the at least one processor; wherein,
The memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the supervisory report data processing method of any of claims 1-8.
11. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program for causing a processor to implement the supervision report data processing method of any one of claims 1 to 8 when executed.
12. A computer program product, characterized in that it comprises a computer program which, when executed by a processor, implements the supervision report data processing method according to any one of claims 1-8.
CN202210280030.7A 2022-03-21 2022-03-21 Supervision report data processing method, device, equipment, medium and product Active CN114666321B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210280030.7A CN114666321B (en) 2022-03-21 2022-03-21 Supervision report data processing method, device, equipment, medium and product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210280030.7A CN114666321B (en) 2022-03-21 2022-03-21 Supervision report data processing method, device, equipment, medium and product

Publications (2)

Publication Number Publication Date
CN114666321A CN114666321A (en) 2022-06-24
CN114666321B true CN114666321B (en) 2024-04-26

Family

ID=82032011

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210280030.7A Active CN114666321B (en) 2022-03-21 2022-03-21 Supervision report data processing method, device, equipment, medium and product

Country Status (1)

Country Link
CN (1) CN114666321B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2011062817A1 (en) * 2009-11-18 2011-05-26 American Express Travel Related Services Company, Inc. Data processing framework
WO2021036321A1 (en) * 2019-08-30 2021-03-04 深圳壹账通智能科技有限公司 Supervision data reporting, electronic apparatus, device and computer-readable storage medium
CN112468532A (en) * 2020-10-12 2021-03-09 苏宁金融科技(南京)有限公司 Credit investigation data sending method, device, system, equipment and computer storage medium
CN113011784A (en) * 2021-04-20 2021-06-22 中国建设银行股份有限公司 Processing model and method for supervising submission data
CN113297179A (en) * 2021-05-31 2021-08-24 中国建设银行股份有限公司 Method and device for processing supervision submission data
CN114022031A (en) * 2021-11-23 2022-02-08 中国工商银行股份有限公司 Data processing method, data processing apparatus, electronic device, medium, and computer program product

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2011062817A1 (en) * 2009-11-18 2011-05-26 American Express Travel Related Services Company, Inc. Data processing framework
WO2021036321A1 (en) * 2019-08-30 2021-03-04 深圳壹账通智能科技有限公司 Supervision data reporting, electronic apparatus, device and computer-readable storage medium
CN112468532A (en) * 2020-10-12 2021-03-09 苏宁金融科技(南京)有限公司 Credit investigation data sending method, device, system, equipment and computer storage medium
CN113011784A (en) * 2021-04-20 2021-06-22 中国建设银行股份有限公司 Processing model and method for supervising submission data
CN113297179A (en) * 2021-05-31 2021-08-24 中国建设银行股份有限公司 Method and device for processing supervision submission data
CN114022031A (en) * 2021-11-23 2022-02-08 中国工商银行股份有限公司 Data processing method, data processing apparatus, electronic device, medium, and computer program product

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
监管报送数据质量平台的设计与实现;曾庆妍等;《信息技术与信息化(总第238期)》;20200210;全文 *

Also Published As

Publication number Publication date
CN114666321A (en) 2022-06-24

Similar Documents

Publication Publication Date Title
CN110263024B (en) Data processing method, terminal device and computer storage medium
US20140156785A1 (en) Method and Apparatus for Generating User Notifications
CN107025604B (en) Method and device for generating business order data
US20150213444A1 (en) Systems and methods for improving data processing and management
CN112381645A (en) Information processing method and device for bill transaction
CN112150295A (en) Block chain-based investment risk early warning method, device, system and equipment
CN115391758A (en) Self-service business platform system
CN113362025A (en) Data accounting system, method, computer readable storage medium, electronic device
CN114666321B (en) Supervision report data processing method, device, equipment, medium and product
CN111711512A (en) Message sending method and device
US20160267230A1 (en) Touchless processing
CN115147049A (en) Order batch loading method and device, storage medium and computer equipment
CN113077315A (en) Data processing method and device, computer readable storage medium and electronic equipment
CN113034258A (en) Tax data processing method and device, electronic equipment and storage medium
CN113792533A (en) Data processing method, data processing device, storage medium and electronic equipment
US20240070661A1 (en) Transaction system transfer techniques
CN117437076B (en) Account checking method, device, equipment and medium based on account checking code
CN104318451A (en) Online transaction tracking method
US20230186387A1 (en) Information processing device, information processing method, and recording medium
CN115496583A (en) Asynchronous accounting data processing method, device, equipment and storage medium
CN110517157B (en) Method, device, medium and electronic equipment for managing mutual insurance of property
CN111292051B (en) Foreign exchange business processing method, device, equipment and medium
CN116823509A (en) Contactless expense reimbursement method, contactless expense reimbursement device, electronic equipment and storage medium
CN117350829A (en) Bank collecting business processing method and device, electronic equipment and storage medium
CN113487413A (en) Accounting processing method and device, electronic equipment and computer readable medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant