CN114666321A - Supervision submission data processing method, device, equipment, medium and product - Google Patents
Supervision submission data processing method, device, equipment, medium and product Download PDFInfo
- Publication number
- CN114666321A CN114666321A CN202210280030.7A CN202210280030A CN114666321A CN 114666321 A CN114666321 A CN 114666321A CN 202210280030 A CN202210280030 A CN 202210280030A CN 114666321 A CN114666321 A CN 114666321A
- Authority
- CN
- China
- Prior art keywords
- data
- message
- transaction
- information
- transaction data
- 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.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title description 9
- 238000012545 processing Methods 0.000 claims abstract description 87
- 238000000034 method Methods 0.000 claims abstract description 52
- 238000012544 monitoring process Methods 0.000 claims abstract description 27
- 238000004590 computer program Methods 0.000 claims description 29
- 230000007246 mechanism Effects 0.000 claims description 29
- 238000012937 correction Methods 0.000 claims description 16
- 230000000875 corresponding effect Effects 0.000 claims description 15
- 230000005540 biological transmission Effects 0.000 claims description 11
- 238000012216 screening Methods 0.000 claims description 8
- 230000001105 regulatory effect Effects 0.000 claims description 5
- 230000002596 correlated effect Effects 0.000 claims description 3
- 230000008520 organization Effects 0.000 claims description 3
- 239000000126 substance Substances 0.000 claims description 2
- 238000012546 transfer Methods 0.000 claims description 2
- 230000004044 response Effects 0.000 claims 1
- 238000007726 management method Methods 0.000 description 30
- 238000012795 verification Methods 0.000 description 10
- 238000004364 calculation method Methods 0.000 description 8
- 238000004891 communication Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 230000010354 integration Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000026676 system process Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/03—Protocol 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 method, a device, equipment, a medium and a product for processing supervision submission data. 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; sending the data in the message increment table to an information reporting system, processing the data in the message increment table through the information reporting system according to interface specifications to generate a reporting message, and sending the reporting message to a monitoring pipe end; responding to an access request of a service personnel terminal through an information submission management system, generating a submission data statistical table based on data in the message increment table, and sending the submission data statistical table to the service personnel terminal for displaying. The embodiment of the invention solves the problem of inaccurate reported data caused by the fact that a single message contains multiple branch data in each line of message split, and also solves the problem of front-end display.
Description
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 submission data.
Background
In recent years, under the situation of 'strict supervision and strong compliance', the supervision department has increased the inspection punishment for the provision of the account data of the RMB personal bank settlement. Therefore, each row highly pays attention to the data submission work of the personal settlement account, and the data submission of the personal settlement account is ensured to be complete according to the requirements of the implementation supervision regulations.
In a traditional data reporting mode, a batch job scheduling platform is used for loading and processing batch data files, specifically, data is copied from a database, then the data is loaded and downstream data processing script operation is triggered, and finally data unloading is triggered to data transmission to complete a reporting task of a monitoring end. However, in the current reporting mode, the situation that each line of message is split and a single message contains multiple branch line data affects the accuracy of the reported message and also has the problem of front-end display.
Disclosure of Invention
The invention provides a method, a device, equipment, a medium and a product for processing supervision submission data, which can solve the problems of accuracy of submission messages and front-end display.
According to an aspect of the present invention, there is provided a method for processing supervision submission 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;
sending the data in the message increment table to an information reporting system, processing the data in the message increment table through the information reporting system according to interface specifications to generate a reporting message, and sending the reporting message to a monitoring pipe end;
responding to an access request of a service personnel terminal through an information submission management system, generating a submission data statistical table based on data in the message increment table, and sending the submission data statistical table to the service personnel terminal for displaying.
According to another aspect of the present invention, there is provided a supervisory submission 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 supervision requirements, and generating a message increment table based on the processed transaction data;
the data reporting module is used for sending the data in the message increment table to an information reporting system, processing the data in the message increment table through the information reporting system according to interface specifications to generate a reporting message, and sending the reporting message to a monitoring pipe end;
and the data statistics module is used for executing an access request of a service personnel end responded by an information reporting management system, generating a reporting data statistics table based on the data in the message increment table, and sending the reporting data statistics table to the service personnel end for displaying.
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 content of the first and second substances,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the method of supervisory advisory data processing in accordance with any one 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 implement a method for supervisory advisory data processing according to any one of the embodiments of the present invention when executed.
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 supervisory submission data processing of any of the embodiments of the present invention.
According to the technical scheme of the embodiment of the invention, the transaction data is obtained and processed to generate the message increment table, the data in the message increment table is sent to the information reporting system, the data in the message increment table is processed by the information reporting system according to the interface specification to generate the reporting message, and then the reporting message is sent to the monitoring end by the head office, so that the condition that a single message contains data of a plurality of branches in each line of message splitting is avoided.
It should be understood that the statements in this section do not necessarily identify key or critical features of the embodiments of the present invention, nor do they necessarily limit the scope of the invention. Other features of the present invention will become apparent from the following description.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1a is a flowchart of a method for processing supervision advisory data according to an embodiment of the present invention;
FIG. 1b is a logic diagram of a supervisory submission data processing flow according to an embodiment of the present invention;
fig. 1c is a schematic view of a reporting process of monitoring reporting data according to an embodiment of the present invention;
FIG. 2 is a flowchart of another method for handling supervisory advisory data in accordance with an embodiment of the present invention;
FIG. 3 is a flowchart of another method for processing supervisory submission data according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a supervision submission data processing apparatus 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 to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or 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. In the technical scheme of the invention, the data acquisition, storage, use, processing and the like all conform to relevant regulations of national laws and regulations.
Fig. 1a is a flowchart of a supervisory submission data processing method according to an embodiment of the present invention, where the method is applicable to a financial field supervisory submission scenario, and the method may be executed by a supervisory submission data processing apparatus, where the supervisory submission data processing apparatus may be implemented in hardware and/or software, and the supervisory submission data processing apparatus may be configured in an electronic device. As shown in fig. 1a, the method comprises:
s110, transaction data of the transaction assembly are obtained, the transaction data are processed according to supervision requirements, and a message increment table is generated based on the processed transaction data.
The transaction component is a computer program packaged with transaction data and a method, transaction service is realized through the transaction component, and the transaction component generates transaction data in the service providing process. In particular, the transaction component may include components that implement various financial services. For example, the transaction components include a loan component, a deposit component, a bond component, and a credit card component, among others.
In one case, the transaction data comprises personal business card account information and identity document 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 document information is special type document information, format adjustment is carried out on the special type document information according to the reporting requirement, and convenience is brought to personalized processing while commonalization is met by adjusting the format of the special type document.
The processing of the transaction data is an operation that the data integration layer carries out format adjustment on the transaction data according to the supervision requirement, and the transaction data of corresponding types can be respectively sent to a data lake and a posting source layer of the data integration layer according to the posting type. The type of the submission includes the flow of funds, account information and the like. Fig. 1b is a logic block diagram of a supervision submission data processing procedure according to an embodiment of the present invention. As shown in fig. 1b, the data integration layer includes a data lake, a clouded data warehouse, a source pasting layer, a public computing module, and a supervisory computing area module. The data lake comprises a file cache region, a batch data region and a real-time data region so as to meet the requirements of real-time delivery and batch synchronization. And reading batch transaction data from the batch data area through the cloud data warehouse, and carrying out processing on the batch transaction data, such as data integration, processing according to indexes or tags and the like. And reading real-time transaction data from the real-time data area through the cloud data warehouse, and carrying out processing on the real-time transaction data, such as data integration, processing according to indexes or tags and the like. And the data after the cloud storage processing is sent to a supervision and calculation area module, and the data after the cloud storage processing is processed according to the supervision and calculation rules in the supervision and calculation area module. The source pasting layer is used for backing up the transaction data in the service source database, and the backed-up transaction data is subjected to data cleaning and other processing through the source pasting layer. And processing the transaction data output by the source layer through a common calculation rule in the common calculation module. And processing the transaction data output by the public calculation module through a supervision calculation rule in the supervision calculation 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 in a data service or copying mode. The message increment table is a data table for storing transaction original data to be reported. The management analysis layer comprises an information submission system, an information submission management system and the like.
Illustratively, transaction data of the transaction component is acquired through the file transmission component NFT, and the transaction data is transmitted to a data lake or a posting layer; classifying and processing the transaction data through a data lake or a posting layer according to the supervision requirement based on the characteristic attributes of the transaction data, and generating a message increment table according to the processed transaction data, wherein the message increment table comprises processed customer information and processed specific account information, and the specific account information comprises debit card, a current deposit book, quasi-credit card account information, credit card account detail 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 the transaction data through a data lake or a posting layer according to a supervision requirement based on the characteristic attributes of the transaction data, and generating a message increment table according to various processed transaction data, which specifically includes:
screening transaction data based on user attributes and bank card attributes through a data lake or a posting layer to generate a customer information table and a specific account information table; associating the customer information table with the specific account information table according to the data association relation of the transaction data; and processing the correlated data in the customer 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 customer information table and the data in the specific account information table.
And S120, sending the data in the message increment table to an information reporting system, processing the data in the message increment table through the information reporting system according to interface specifications to generate a reporting message, and sending the reporting message to a monitoring pipe end.
Wherein, the information submission system points to the supervision submission system of the submission data of the supervision institution. The staff of the headquarter and the branch can report data to the supervision organization through the information reporting system. In the embodiment of the invention, the bank head office reports data to the supervision institution through the information reporting system.
The interface specification is a relevant provision in the transport protocol agreed upon by the regulatory body. And determining the format of the report message through the interface specification.
Illustratively, the message increment table is converted into a file with a specific format, and the data in the message increment table is sent to the information reporting system through the file transmission component NFT. And the information reporting system processes the data in the message increment table according to the interface specification to generate a reporting message, and transmits the reporting message to the monitoring end through the message queue MQ interface. The reporting message is sent to the monitoring end in an MQ direct connection mode, and reporting instantaneity can be provided.
In a specific embodiment, the process of reporting the supervision reporting data includes data access, data processing, data unloading, and data reporting. Fig. 1c is a schematic view of a reporting process for supervising 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 of private customers, debit card (private), private deposit, card issuance, business approval (credit card), electronic banking, product research and development, organization management, format check error, logic check error, and the like. And the data is accessed to the data integration layer for data processing. The data processing specifically comprises customer information processing, debit card processing, shelf bankbook processing, quasi credit card account processing, payment wallet account processing and the like, and a message increment table is generated based on processed data. And pre-checking the data in the message increment table, generating a daily increment message interface table based on the qualified data of the pre-checking, and generating a pre-checking error detail table based on the unqualified data of the pre-checking. And generating a message section full-scale table based on the data in the daily increment message interface table. Data in the daily increment message interface table is unloaded to obtain data in a set format, the data is sent to an information delivery system through a file transfer component NFT, a message is split, compressed and encrypted through the information delivery system to obtain a delivery message, and the delivery message is transmitted to a monitoring end through a message queue MQ interface. And sending the reporting message to a monitoring end in an MQ direct connection mode.
Optionally, after sending the report message to the monitoring terminal, the method further includes obtaining a message receipt sent by the monitoring terminal, and determining whether the report is successful according to a code value in the message receipt. Specifically, after sending the report message, if the code value in the received message return is a preset numerical value representing successful report, the report is determined to be successful, and the report state of the message is recorded as successful report, otherwise, the report is failed. When the service personnel inquires the message receiving and sending condition, the message receiving and sending condition can be obtained by inquiring the message sending state.
Optionally, before sending the data in the message increment table to the information delivery system, the method further includes: carrying out format check on data in the message incremental table; and 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-scale table. And converting the daily increment message interface table into a file with a specific format, and sending the data in the daily increment message interface table to an information reporting system through a file transmission component NFT. The database is set to be a pre-configured database used for storing data in the daily increment message interface table.
S130, responding to an access request of a service personnel terminal through an information delivery management system, generating a delivery data statistical table based on data in the message increment table, and sending the delivery data statistical table to the service personnel terminal for displaying.
The data statistical table is a data table generated based on the viewing requirements or supervision and assessment requirements of front-end business personnel. Specifically, the data statistical table contains data of multiple dimensions meeting viewing requirements or supervision and assessment requirements. For example, the data statistics table includes a report data statistics table, an error rectification statistics table, and a key data item specific statistics table. And the statistics, display and distribution of the reported data are realized through the data statistics table. And the statistics, the display and the distribution of the pre-correction error or the check error fed back by the monitoring end are realized through the error statistics table. And displaying and distributing the checking error correction condition through the error correction statistical table. And realizing the data counting and displaying of the important data through the special statistical table of the important data. The key data comprises the condition of missing financial institution codes, the condition that the entity institution does not maintain the financial institution codes in the institution components, the condition that the verification result is not real and the like.
Illustratively, responding to an access request of a service personnel end through an information reporting management system to obtain data in a message section full-scale table; and screening the data in the message section full-scale according to the set dimension, generating a report data statistical table, and sending the report data statistical table to a service personnel end for displaying. Specifically, data in the full-scale of the message section are counted according to dimensions such as time, mechanisms and reporting elements, a reporting data statistical table is generated, and the reporting data statistical table is sent to a service personnel end for displaying, so that the service personnel can conveniently master data reporting conditions.
According to the technical scheme of the embodiment of the invention, transaction data are obtained and processed to generate the message increment table, data in the message increment table are sent to the information reporting system, the data in the message increment table are processed according to the interface specification through the information reporting system to generate the reporting message, then the reporting message is sent to the monitoring end by the head office, the condition that each line of message is split and a single message contains data of multiple branches is avoided, in addition, the message data statistical table is generated through the information reporting management system based on the data in the message increment table, and the message data statistical table is sent to the service personnel end for displaying, so that the problem in the aspect of front-end displaying is solved.
Fig. 2 is a flowchart of another method for processing supervision and delivery data according to an embodiment of the present invention, where on the basis of the foregoing embodiment, after format verification is performed on data in the message increment table, the embodiment further includes performing pre-verification processing on the data in the message increment table. As shown in fig. 2, the method includes:
s210, transaction data of the transaction assembly are obtained, the transaction data are processed according to supervision requirements, and a message increment table is generated based on the processed transaction data.
And S220, carrying out format check on the data in the message increment table, and judging whether the data in the message increment table meets the format requirement, if so, executing S230, otherwise, executing S250.
Illustratively, through analyzing the check error of the historical report data, the check rule related to the format error is abstracted, the format check is carried out on the data in the message increment table through the check rule, and whether the data in the message increment table meets the format requirement is judged based on the format check result.
And 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 through the information reporting system to generate a reporting message, and sending the reporting message to a monitoring end.
And S240, copying the data in the daily increment message interface table to a set database to generate a message section full-scale table.
And S250, 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 dimensions through the information reporting management system, and sending the pre-check error statistical table to a corresponding mechanism subsystem.
Illustratively, a pre-check error detail table is generated based on data which does not meet format requirements in the message increment table, and the pre-check error detail table is sent to a corresponding mechanism subsystem and displayed to prompt service personnel of a corresponding mechanism to correct transaction data. The modified transaction data may be sent to the supervising end as a transaction data along with transaction data collected at the next submission. Optionally, for the case that the last report is unsuccessful, if the report is repeated, the modified transaction data and the data meeting the format requirement in the message increment table are used as the transaction data, and the report is repeated.
S260, responding to an access request of a service personnel terminal through the information reporting management system, acquiring data in the message section full-scale table, screening the data in the message section full-scale table according to a set dimension, generating a reporting data statistical table, and sending the reporting data statistical table to the service personnel terminal for displaying.
According to the technical scheme of the embodiment of the invention, format pre-check 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 the accuracy of the reported data is improved; and generating a pre-check error list for 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 list according to time and mechanism dimensions, and giving the pre-check error statistical table to a corresponding mechanism subsystem, so that the check error information is displayed at the front end, and the timeliness of the report of the pre-check error data is improved.
Fig. 3 is a flowchart of another supervision submission data processing method according to an embodiment of the present invention, where this embodiment further includes a step of displaying a check error and an error correction condition after sending the submission message to the supervision end based on the foregoing embodiment. The check errors comprise pre-check errors and check errors fed back by the supervision terminal. The error rectification condition comprises a pre-correction error rectification condition and a check error rectification condition fed back by the 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 corrected transaction data, the incremental transaction data is transaction data added in the transaction component compared with the transaction data sent last time, and the corrected transaction data is the transaction data sent last time and corrected based on the feedback message.
Illustratively, increment transaction data and correction transaction data of the transaction component are obtained through the file transmission component NFT, the increment transaction data and the correction transaction data are processed according to supervision requirements, and a message increment table is generated based on the processed increment transaction data and the correction transaction data.
And S320, carrying out format check on the data in the message increment table, and judging whether the data in the message increment table meets the format requirement, if so, executing S330, and 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 through the information reporting system to generate a reporting message, and sending the reporting message to a monitoring end.
And S340, copying the data in the daily increment message interface table to a set database to generate a message section full-scale table.
S350, generating a pre-check error detail table based on data which do not meet format requirements in the message incremental table, generating a pre-check error statistical table based on the pre-check error detail table according to time and mechanism dimensions through the information reporting management system, and sending the pre-check error statistical table to a corresponding mechanism subsystem.
S360, obtaining a feedback message of the monitoring 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 check error statistical table based on the feedback message according to time and mechanism dimension through the information reporting management system, and sending the check error statistical table to a corresponding mechanism subsystem.
Illustratively, a verification error statistical table is generated by the information reporting management system according to two dimensions of time and mechanism based on format verification error information and/or logic verification error information in the feedback message, and the verification error statistical table is sent to the corresponding mechanism subsystem, so that branch service personnel are prompted by the corresponding mechanism subsystem to correct the to-be-reported verification data with errors, and corrected transaction data are obtained.
And S380, generating an error correction statistical table based on the corrected transaction data according to time and mechanism dimensions through the information submission management system.
The corrected transaction data comprises transaction data corrected based on the verification error statistical table and transaction data corrected based on the pre-verification error detail table.
Illustratively, a first error correction statistics is generated by the messaging management system based on the revised transaction data of the check error statistics in both the time and institution dimensions. And generating a second error correction statistical table based on the transaction data corrected by the pre-correction error detail table according to two dimensions of time and mechanisms through the information reporting management system.
Optionally, according to the supervision and assessment requirements, an error third error correction statistical table can be generated through the information reporting management system according to two dimensions of time and mechanisms based on the transaction data corrected by the check error statistical table and the transaction data corrected by the pre-check error detail table.
And S390, responding to an access request of a service personnel terminal through the information submission management system, acquiring data in the message section full-scale table, screening the data in the message section full-scale table according to a set dimension, generating a submission data statistical table, and sending the submission data statistical table to the service personnel terminal for displaying.
According to the technical scheme of the embodiment of the invention, the information reporting management system generates the check error statistical table based on the feedback message according to time and mechanism dimension, and sends the check error statistical table to the corresponding mechanism subsystem, so that the check error fed back by the monitoring end is displayed through the front end system, and the check error is convenient for service personnel to check; and an error correction statistical table is generated based on the corrected transaction data according to time and mechanism dimensions through the information submission management system, so that the correction condition of the error data of the branch is synchronized in real time.
Fig. 4 is a schematic structural diagram of a supervision submission data processing apparatus according to an embodiment of the present invention. The administration submission processing arrangement may be implemented in hardware and/or software, and the administration submission data processing arrangement may be configured in an electronic device. 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 used for executing the 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 420 is configured to execute 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 reporting message, and send the reporting message to a monitoring pipe end;
and the data statistics module 430 is configured to execute an access request of a service staff end responded by an information delivery management system, generate a delivery data statistics table based on data in the message increment table, and send the delivery data statistics table to the service staff end for display.
Optionally, the data processing module 410 includes:
the data transmission sub-module is used for acquiring transaction data of the transaction component through the file transmission component NFT and transmitting the transaction data to a data lake or a posting layer;
and the data processing submodule is used for classifying and processing the transaction data through the data lake or the posting layer according to the supervision requirement based on the characteristic attribute of the transaction data, and generating a message increment table according to the processed transaction data, wherein the message increment table contains processed customer information and processed specific account information.
Optionally, the data processing submodule is specifically configured to perform:
screening the transaction data through the data lake or the posting layer based on user attributes and bank card attributes to generate a customer information table and a specific account information table;
associating the customer information table with a specific account information table according to the data association relation of the transaction data;
and processing the correlated data in the customer 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 customer 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 checking on the data in the message increment table before the data in the message increment table is sent to an information reporting system;
the generating module is used for 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-scale table;
and the data reporting module 420 is specifically configured to perform:
and sending the data in the daily increment message interface table to an information reporting system.
Optionally, the apparatus further comprises:
and the pre-check error statistical module is used for generating a pre-check error detail table based on the data which does not meet the format requirement in the message increment table after performing format check on the data 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 dimensions through the information reporting management system, and sending the pre-check error statistical table to a 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 submission management system, and acquiring data in the full-scale table of the message section;
and screening the data in the message section full-scale according to a set dimension to generate a report data statistical table.
Optionally, the apparatus further comprises:
a feedback message obtaining module, configured to obtain a feedback message of the monitoring end after the sending of the report message to the monitoring end is performed, and send the feedback message to an information report management system, where the feedback message includes format check error information and/or logic check error information;
and generating a check error statistical table based on the feedback message according to time and mechanism dimension through the information reporting management system, and sending the check 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 corrected transaction data of a transaction component through a file transmission component NFT, wherein the incremental transaction data is transaction data which is added in the transaction component compared with the transaction data which is sent last time, and the corrected transaction data is the transaction data which is sent last time and is corrected based on the feedback message.
Optionally, the apparatus further comprises:
and the rectification table generating module is used for generating an error rectification statistical table based on the corrected transaction data according to time and mechanism dimensions through the information reporting management system after the incremental transaction data and the corrected transaction data of the transaction component are acquired through the file transmission component NFT.
Optionally, the apparatus further comprises:
and the receipt acquiring module is used for acquiring the message receipt sent by the monitoring end after the report message is sent to the monitoring end, and determining whether the report is successful according to the code value in the message receipt.
Optionally, the transaction data includes account information of the personal commerce card 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 a reporting requirement.
The supervision submission data processing device provided by the embodiment of the invention can execute the supervision submission data processing method provided by any embodiment of the invention, and has 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 communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM)12, a Random Access Memory (RAM)13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 can perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM)12 or the computer program loaded from a storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 can 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.
A number of 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, or the like; 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, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, or the like. The processor 11 performs the various methods and processes described above, such as the supervisory advisory data processing method.
In some embodiments, the supervisory submission data processing method may be implemented as a computer program tangibly embodied in 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. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the supervisory advisory data processing method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the supervisory advisory data processing method in any other suitable manner (e.g., by means of firmware).
A computer program for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, 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 performed. A computer program can execute entirely on a machine, partly on a machine, as a stand-alone software package partly on a machine and partly on a remote machine or entirely on a 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. A 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) by 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 can 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, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end 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 back-end, 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. A client and server are generally 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 host and VPS service are overcome.
An embodiment of the present invention further provides a computer program product, including a computer program, where the computer program, when executed by a processor, implements the method for processing supervisory submission data provided in any embodiment of the present application.
Computer program product in implementing the computer program code for carrying out operations of the present invention may be written in any combination of 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 type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired results of the technical solution of the present invention can be achieved.
The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (15)
1. A method for supervisory submission data processing, comprising:
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;
sending the data in the message increment table to an information reporting system, processing the data in the message increment table through the information reporting system according to interface specifications to generate a reporting message, and sending the reporting message to a monitoring pipe end;
responding to an access request of a service personnel terminal through an information submission management system, generating a submission data statistical table based on data in the message increment table, and sending the submission data statistical table to the service personnel terminal for displaying.
2. The method of claim 1, wherein the obtaining transaction data for a transaction component, processing the transaction data according to regulatory requirements, and generating a message delta table based on the processed transaction data comprises:
acquiring transaction data of a transaction component through a file transmission component NFT, and transmitting the transaction data to a data lake or a posting layer;
classifying and processing the transaction data through the data lake or the posting layer according to the supervision requirement based on the characteristic attributes of the transaction data, and generating a message increment table according to the processed transaction data, wherein the message increment table comprises processed customer information and processed specific account information.
3. The method according to claim 2, wherein classifying and processing based on the characteristic attributes of the transaction data through the data lake or the posting layer according to the regulatory requirements and generating a message increment table according to the processed transaction data of each type comprises:
screening the transaction data through the data lake or the posting layer based on user attributes and bank card attributes to generate a customer information table and a specific account information table;
associating the customer information table with a specific account information table according to the data association relation of the transaction data;
and processing the correlated data in the customer 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 customer information table and the data in the specific account information table.
4. The method of claim 1, wherein before sending the data in the message delta table to the messaging system, further comprising:
carrying out format check 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-scale table;
and, the sending of the data in the message increment table to an information reporting system comprises:
and sending the data in the daily increment message interface table to an information reporting system.
5. The method according to claim 4, further comprising, after the format checking the data in the packet increment table, the step of:
and generating a pre-check error list 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 list through the information reporting management system according to time and mechanism dimensions, and sending the pre-check error statistical table to a corresponding mechanism subsystem.
6. The method of claim 5, wherein the generating a report data statistical table based on the data in the message increment table in response to an access request of a service personnel end through an information report management system comprises:
responding an access request of a service personnel end through the information reporting management system to obtain data in the full-scale table of the message section;
and screening the data in the message section full-scale according to the set dimension to generate a report data statistical table.
7. The method of claim 5, after said sending said report message to a policing terminal, further comprising:
acquiring a feedback message of the monitoring 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 check error statistical table based on the feedback message according to time and mechanism dimension through the information reporting management system, and sending the check error statistical table to a corresponding mechanism subsystem.
8. The method of claim 7, wherein the obtaining transaction data for a transaction component comprises:
and acquiring incremental transaction data and corrected transaction data of a transaction component through a file transmission component NFT, wherein the incremental transaction data is transaction data which is added in the transaction component compared with the transaction data which is sent last time, and the corrected transaction data is the transaction data which is sent last time and is corrected based on the feedback message.
9. The method according to claim 8, wherein after said obtaining incremental transaction data and revised transaction data of a transaction component by a file transfer component NFT, further comprising:
and generating an error correction statistical table based on the corrected transaction data according to time and organization dimensions through the information submission management system.
10. The method according to claim 1, wherein after said sending the report message to a policing terminal, further comprising:
and acquiring a message receipt sent by the supervision terminal, and determining whether the message is successfully reported according to a code value in the message receipt.
11. The method as claimed in claim 1, wherein the transaction data includes personal commerce card account information and identity document information, and when the identity document information is a special type document information, the special type document information is formatted according to a submission requirement.
12. A supervisory submission data processing apparatus, comprising:
the data processing module is used for acquiring transaction data of the transaction component, processing the transaction data according to a supervision requirement and generating a message increment table based on the processed transaction data;
the data reporting module is used for sending the data in the message increment table to an information reporting system, processing the data in the message increment table through the information reporting system according to interface specifications to generate a reporting message, and sending the reporting message to a monitoring pipe end;
and the data statistics module is used for executing an access request of a service personnel end responded by an information reporting management system, generating a reporting data statistics table based on the data in the message increment table, and sending the reporting data statistics table to the service personnel end for displaying.
13. An electronic device, characterized in that the electronic device comprises:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the method of supervisory newspaper data processing as recited in any of claims 1-11.
14. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for causing a processor, when executed, to implement the method of supervisory submission data processing of any of claims 1-11.
15. A computer program product, characterized in that the computer program product comprises a computer program which, when executed by a processor, implements a method of supervisory submission data processing according to any of claims 1-11.
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 true CN114666321A (en) | 2022-06-24 |
| CN114666321B 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)
| 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 |
-
2022
- 2022-03-21 CN CN202210280030.7A patent/CN114666321B/en active Active
Patent Citations (6)
| 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)
| Title |
|---|
| 曾庆妍等: "监管报送数据质量平台的设计与实现", 《信息技术与信息化（总第238期）》, 10 February 2020 (2020-02-10) * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114666321B (en) | 2024-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20140156785A1 (en) | Method and Apparatus for Generating User Notifications | |
| CN107025604B (en) | Method and device for generating business order data | |
| CN111277625A (en) | E-commerce platform order pushing method and system | |
| CN115391758A (en) | Self-service business platform system | |
| CN114168682A (en) | Data auditing method, device, equipment and storage medium | |
| CN111711512B (en) | Message sending method and device | |
| CN112990871A (en) | Document processing method and related equipment | |
| CN114666321B (en) | Supervision report data processing method, device, equipment, medium and product | |
| CN111738728A (en) | Transaction compensation method and device | |
| US20160267230A1 (en) | Touchless processing | |
| CN115619552A (en) | Asynchronous processing method and device of transaction bill, electronic equipment and medium | |
| CN113792533A (en) | Data processing method, data processing device, storage medium and electronic equipment | |
| CN111353714A (en) | Data monitoring method, server, client and system | |
| US20240070661A1 (en) | Transaction system transfer techniques | |
| CN115496583A (en) | Asynchronous accounting data processing method, device, equipment and storage medium | |
| CN111967960B (en) | Batch adjustment method and device for account data | |
| CN111105315B (en) | Policy request processing method, policy request processing device, policy request processing medium and electronic equipment | |
| CN113487413A (en) | Accounting processing method and device, electronic equipment and computer readable medium | |
| CN116757638A (en) | Transaction data verification method and device | |
| CN114168660A (en) | Method, device and equipment for processing accumulation fund data and storage medium | |
| CN114119261A (en) | Processing method and device for anti-money laundering data, storage medium and electronic equipment | |
| CN115544052A (en) | Data processing method and device | |
| CN114331597A (en) | Order parallel generation method and system, electronic equipment and storage medium | |
| CN117592063A (en) | Data risk early warning method, device, equipment and storage medium | |
| CN115829771A (en) | Financial accounting method and device, electronic equipment and storage 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 |