CN112632169B - Automatic financial data reporting method and device and computer equipment - Google Patents
Automatic financial data reporting method and device and computer equipment Download PDFInfo
- Publication number
- CN112632169B CN112632169B CN202011605668.0A CN202011605668A CN112632169B CN 112632169 B CN112632169 B CN 112632169B CN 202011605668 A CN202011605668 A CN 202011605668A CN 112632169 B CN112632169 B CN 112632169B
- Authority
- CN
- China
- Prior art keywords
- data
- credit
- information
- client
- checked
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2443—Stored procedures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2445—Data retrieval commands; View definitions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Abstract
The invention provides a financial data automatic reporting method, a device and computer equipment, wherein the method comprises the following steps: reading the basic information of the current day at regular time, inquiring and extracting initial data from the basic information, and inserting the extracted initial data into an intermediate data warehouse, wherein the initial data at least comprises a name field; classifying and processing initial data in the intermediate data warehouse to obtain data to be inspected after processing of each class; checking the data to be checked, checking whether a null field exists, and taking the data to be checked without the null field as the data to be reported; and correspondingly reporting the data to be reported according to the reporting requirement, and finishing the reporting of the data of the day. The scheme realizes daily automatic data query, extraction, processing, inspection and reporting, reduces manpower to the greatest extent and improves the reporting efficiency.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a financial data automatic reporting method and device and computer equipment.
Background
The existing banks and financial companies are related to summarizing a plurality of source data, and the reporting requirements can be met only by manual processing for a plurality of times. When a data source is added, data source summarization needs to be carried out from a source service system, an original summarization mode is changed in a large area, and a large amount of manpower is needed to finish data reporting.
Disclosure of Invention
Therefore, it is necessary to provide a method, an apparatus and a computer device for automatically reporting financial data in order to solve the above technical problems.
A financial data automatic reporting method comprises the following steps: reading the basic information of the current day at regular time, inquiring and extracting initial data from the basic information, and inserting the extracted initial data into an intermediate data warehouse, wherein the initial data at least comprises a name field; classifying and processing initial data in the intermediate data warehouse to obtain data to be inspected after processing of each class; checking the data to be checked, checking whether a null field exists, and taking the data to be checked without the null field as the data to be reported; and correspondingly reporting the data to be reported according to the reporting requirement, and finishing the reporting of the data of the current day.
In one embodiment, the step of reading the basic information of the current day periodically, querying and extracting initial data from the basic information, and inserting the extracted initial data into the intermediate data warehouse, further includes, before the step of including at least a name field in the initial data: and receiving a data reporting instruction and receiving the basic information of the current day.
In one embodiment, the basic information at least comprises a client basic information table, a client borrowing information table, a client credit information table, a client installment record table and a client deduction record table.
In one embodiment, before the step of classifying and processing the initial data in the intermediate data warehouse to obtain the processed data to be inspected in each category, the method further includes: according to an extraction source of initial data, the initial data is divided into three types of data, namely basic information type, credit granting type and credit type.
In one embodiment, the classifying and processing the initial data in the intermediate data warehouse to obtain the processed data to be inspected in each category specifically includes: associating the initial data based on a name field; adding personal information to initial data of the basic information in the intermediate data warehouse to obtain to-be-inspected data of the basic information, and storing the to-be-inspected data into a first processing table; adding credit information, updating credit status and updating amount of the initial data of the credit in the intermediate data warehouse to obtain to-be-checked data of the credit, and storing the to-be-checked data into a second processing table; and carrying out loan information addition, loan state updating and account state updating on the initial data of the loans in the intermediate data warehouse to obtain the data to be checked of the loans, and storing the data to be checked in the third processing table.
In one embodiment, the checking the data to be checked, checking whether there is a null field, and using the data to be checked without a null field as the data to be reported specifically includes: and respectively checking the data to be checked in the first processing table, the second processing table and the third processing table, checking whether a null field exists, and taking the data to be checked without the null field as the data to be reported.
In one embodiment, after the step of classifying and processing the initial data in the intermediate data warehouse to obtain the processed data to be inspected in each category, the method further includes: and judging whether the current date is a holiday, if so, not checking, reserving the current date as data to be checked, and ending execution.
In one embodiment, after the step of checking the data to be checked, checking whether there is a null field, and taking the data to be checked without a null field as the data to be reported, the method further includes: and screening out the data to be reported of which the name fields conform to a preset white client list in the data to be reported according to the preset white client list.
The utility model provides an automatic reporting device of financial data, includes data extraction module, data processing module, data inspection module and data reporting module, wherein: the data extraction module is used for reading the basic information of the current day, inquiring and extracting initial data from the basic information, and inserting the extracted initial data into the intermediate data warehouse, wherein the initial data at least comprises a name field; the data processing module is used for classifying and processing the initial data in the intermediate data warehouse to obtain the data to be checked after processing of each class; the data checking module is used for checking the data to be checked, checking whether a null field exists or not, and taking the data to be checked without the null field as the data to be reported; and the data reporting module is used for correspondingly reporting the data to be reported according to the reporting requirement so as to finish the reporting of the data on the day.
A computer device, comprising a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor implements the steps of the automatic financial data reporting method in the above embodiments when executing the program.
According to the financial data automatic reporting method, device and computer equipment, the basic information of the day is read regularly, the initial data is inquired and extracted from the basic information and is inserted into the intermediate data warehouse, the initial data in the intermediate data warehouse is processed in a classified mode to obtain the data to be checked, whether the data to be checked has the empty field or not is checked, the data which does not have the empty field is used as the data to be reported, and the data to be reported is reported according to the corresponding reporting requirement. Therefore, data query, extraction, processing, inspection and reporting are automatically completed every day, manpower is reduced to the greatest extent, and reporting efficiency is improved.
Drawings
Fig. 1 is an application scenario diagram of an automatic financial data reporting method in an embodiment;
FIG. 2 is a flow chart illustrating an exemplary method for automatically reporting financial data;
FIG. 3 is a block diagram illustrating an exemplary embodiment of an apparatus for automatically reporting financial data;
FIG. 4 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings by way of specific embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The method for automatically reporting financial data can be applied to the application environment shown in fig. 1. Wherein the terminal 1 communicates with the server 2 via a network. The inquiry, extraction, classification processing and inspection of daily financial data are all carried out in the terminal 1, the inspected data to be reported are uploaded to the server 2 from the terminal 1 through a network, and the server 2 can be realized by an independent server or a server cluster consisting of a plurality of servers, so that the data can be reported to one or more interfaces in need. Similarly, in any data query, extraction, classification processing and inspection stage, whether a task in the timing query stage is completed or not is performed, and once a task abnormality exists, such as extraction failure or processing failure, the corresponding task is stopped, and other normal tasks are continuously executed; when a task that is stopped at the same time occurs, the terminal 1 sends a notification that the corresponding task is stopped due to an exception to the server 2. Among them, the terminal 1 may be, but is not limited to, various personal computers, notebook computers, tablet computers, and portable wearable devices.
In one embodiment, as shown in fig. 2, an automatic reporting method for financial data is provided, which includes the following steps:
s110, reading the basic information of the current day, inquiring and extracting initial data from the basic information, and inserting the extracted initial data into an intermediate data warehouse, wherein the initial data at least comprises a name field.
Specifically, the basic information of the current day is read, initial data is completely inquired in a mode of an sql statement select from table, and then the initial data is inserted into an intermediate data warehouse in a mode of an sql statement insert src _ c _ table values (value 1, value 2.. Department) for data processing.
In one embodiment, before step S110, the method further includes: and receiving a data reporting instruction and receiving the basic information of the current day. Specifically, the method is based on an XXL-JOB scheduling framework, the XXL-JOB is a lightweight distributed task scheduling framework, and the scheme is based on task scheduling of regularly pulling up data extraction, data processing, data inspection and data reporting every day after XXL-JOB configuration. The XXL-JOB task triggering mode is divided into two types, and scheduling triggering is carried out: the scheduling period triggers execution automatically. Manual triggering: and the console manually and forcibly triggers execution. In any mode, the execution is triggered by the JobTriggerPoolHelper triggering thread pool of the dispatching center. According to actual needs, the set period of execution of the automatic trigger is a determined time point every day.
In one embodiment, the basic information in step S110 at least includes a customer basic information table, a customer borrowing information table, a customer credit information table, a customer offer record table and a customer deduction record table. Specifically, the basic information mainly includes a customer basic information table, a customer borrowing information table, a customer credit information table, a customer service record table and a customer deduction record table in the service system.
And S120, classifying and processing the initial data in the intermediate data warehouse to obtain the data to be inspected after processing of each class.
Specifically, the initial data inserted into the intermediate data warehouse is classified and processed to obtain the data to be inspected after each class of processing, the classification is carried out according to the classification of the initial data, and the classification of the initial data is carried out according to the source of the initial data.
In one embodiment, before step S120, the method further includes: according to the extraction source of the initial data, the initial data is divided into three types of data, namely a basic information type, a credit type and a credit type. Specifically, the initial data can be classified into three types of data of a basic information type, a credit type and a credit type according to the tables of the extraction sources of the initial data, namely a customer basic information table, a customer borrowing information table, a customer credit information table, a customer service record table and a customer deduction record table.
In one embodiment, step S120 specifically includes: associating the initial data based on the name field; adding personal information to initial data of the basic information in the intermediate data warehouse to obtain to-be-inspected data of the basic information, and storing the to-be-inspected data into a first processing table; adding credit information, updating credit status and updating limit on the initial data of the credit classes in the intermediate data warehouse to obtain to-be-checked data of the credit classes, and storing the to-be-checked data into a second processing table; and carrying out loan information addition, loan state updating and account state updating on the initial data of the loans in the intermediate data warehouse to obtain the data to be checked of the loans, and storing the data to be checked in the third processing table.
Specifically, the initial data in the intermediate data warehouse needs to be associated based on the field of the customer name according to the table of different sources.
Then, for the initial data of the basic information class, all the client ids paid yesterday are inquired from the client borrowing information source table in the intermediate data warehouse, and after the basic information source table of the client is associated, some basic information of the client, such as personal name, mobile phone number, communication address, professional information, marital status and education information, is taken out and then inserted into a historical processing table of his _ per _ base, a status field in the processing table is used for recording the state of each piece of data, namely a first processing table, and the data is represented by 2 in a stage to be checked.
For initial data of credit service class, three kinds of processing are carried out, firstly, all client ids (namely name fields) paid last year are inquired from a client data borrowing information source table, a credit service information source table and a personal credit service information table are associated, and information of credit service name, credit service identity number, credit service amount, credit service state, credit service expiration date and the like of a client credit service is inserted into a his _ per _ credit history processing table; secondly, inquiring all data with yesterday as due date from a client credit information source table, and inserting the data into a his _ per _ credit history processing table after changing the credit state into the due date; thirdly, inquiring data with inconsistent quota from the client credit information source table and the data upper report per _ credit, and then inserting the data of the new quota into the his _ per _ credit table, namely the second processing table.
For initial data of the loan class, three kinds of processing are also carried out, namely, a borrowing information source table for all yesterday loans is directly inquired from a client borrowing information source table, and some borrowing information of a client is obtained, for example: inserting borrowing information such as borrowing amount, balance in loan, due date of borrowing, due date of repayment, account state, repayment amount in the month, actual repayment amount in the month and the like into a his _ per _ loan historical processing table; secondly, inquiring data with a loan data state of being clear and the clearing time of being yesterday from a customer borrow information source table, and modifying the account state of being closed and then inserting the data into his _ per _ loan; and thirdly, inquiring the loan data state from the customer loan data information source table as overdue, modifying the account state as overdue, and inserting the account into the his _ per _ loan, namely a third processing table.
The processing of these three types of initial data is performed simultaneously.
In one embodiment, after step S120, the method further includes: and judging whether the current date is a holiday, if so, not checking, reserving the current date as data to be checked, and finishing execution. Specifically, after the initial data is processed and before the data to be checked is obtained, date judgment is needed to be carried out first to judge whether the current time is a holiday, if the current time is the holiday, the state in the table cannot be updated, the task is directly finished, and when the date is not the holiday, the data state can be updated to the data to be checked.
S130, the data to be checked is checked, whether a null field exists is checked, and the data to be checked without the null field is used as the data to be reported.
Specifically, whether each field is empty is checked, if data which are empty exist, a notification needs to be sent to a server if the data which are empty exist, and therefore the notification is sent to maintenance personnel for access processing. If no empty field exists, the data to be checked can be updated to be data to be reported.
In one embodiment, step S130 specifically includes: and respectively checking the data to be checked in the first processing table, the second processing table and the third processing table, checking whether a null field exists, and taking the data to be checked without the null field as the data to be reported. Specifically, during the checking, the data to be checked in the first processing table, the second processing table and the third processing table are respectively checked, the data are executed independently, whether an empty field exists is checked, and the data to be checked in the processing table without the empty field is updated to the data to be reported.
In one embodiment, after step S130, the method further includes: and screening out the data to be reported of which the name fields in the data to be reported accord with the preset white client list according to the preset white client list. Specifically, sometimes, after checking whether there is an empty field, all clients in the white list need to be screened out, and no report is performed.
S140, the data to be reported is correspondingly reported according to the reporting requirement, and the data on the day is reported.
Specifically, after all the checks are finished, the state of the data in each processing table is checked, only the state is updated to the data to be reported, and the data is reported, and if the state is not to be reported, the data is continuously reserved. And reporting the data to be reported according to the reporting requirement, thereby completing the reporting of the data of the day.
In the above embodiment, the basic information of the current day is read regularly, the initial data is queried and extracted from the basic information and is inserted into the intermediate data warehouse, the initial data in the intermediate data warehouse is classified and processed to obtain the data to be checked, the data to be checked is checked to see whether there is a null field, the data without the null field is used as the data to be reported, and the data to be reported is reported according to the corresponding reporting requirement. Therefore, data query, extraction, processing, inspection and reporting are automatically completed every day, manpower is reduced to the greatest extent, and reporting efficiency is improved. And intelligent reporting can be performed according to whether the judgment is a holiday or not. And the clients belonging to the white list are automatically removed, so that the method is closer to the actual reporting requirement, and the reporting efficiency is improved.
In one embodiment, as shown in fig. 3, an automatic reporting apparatus 200 for financial data is provided, which includes a data extracting module 210, a data processing module 220, a data checking module 230, and a data reporting module 240, wherein:
the data extraction module 210 is configured to read basic information of the current day, query and extract initial data from the basic information, and insert the extracted initial data into the intermediate data warehouse, where the initial data at least includes a name field;
the data processing module 220 is configured to classify and process the initial data in the intermediate data warehouse to obtain data to be inspected after processing of each class;
the data checking module 230 is configured to check the data to be checked, check whether there is a null field, and use the data to be checked without a null field as the data to be reported;
the data reporting module 240 is configured to correspondingly report the data to be reported according to reporting requirements, and complete the reporting of the data of the current day.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 4. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing the configuration template and also used for storing target webpage data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by the processor to realize an automatic reporting method of financial data.
Those skilled in the art will appreciate that the architecture shown in fig. 4 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above may be implemented by a computer program, which may be stored in a computer readable storage medium and executed by a computer to implement the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
It will be apparent to those skilled in the art that the modules or steps of the invention described above may be implemented in a general purpose computing device, they may be centralized on a single computing device or distributed across a network of computing devices, and optionally they may be implemented in program code executable by a computing device, such that they may be stored on a computer storage medium (ROM/RAM, magnetic disks, optical disks) and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
The foregoing is a more detailed description of the present invention that is presented in conjunction with specific embodiments, and the practice of the invention is not to be considered limited to those descriptions. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.
Claims (8)
1. An automatic reporting method of financial data is characterized by comprising the following steps:
reading the basic information of the current day at regular time, inquiring and extracting initial data from the basic information, and inserting the extracted initial data into an intermediate data warehouse, wherein the initial data at least comprises a name field;
dividing initial data into three types of data, namely a basic information type, a credit type and a credit type, according to an extraction source of the initial data; the extraction source comprises a client basic information table, a client borrowing information table, a client credit information table, a personal borrowing information table, a data reporting table, a client period supply record table and a client deduction record table;
classifying and processing initial data in the intermediate data warehouse to obtain data to be inspected after processing of each class; the method specifically comprises the following steps:
associating the initial data based on a name field; carrying out personal information adding processing on initial data of basic information types in the intermediate data warehouse, inquiring all client ids paid yesterday from a client borrowing information table in the intermediate data warehouse, associating the client basic information table, then inserting the client basic information into a first processing table of his _ per _ base after being taken out, wherein the basic information comprises personal names, mobile phone numbers, communication addresses, professional information, marital conditions and education information; a status field in the first processing table is used for recording the state of each piece of data to obtain the to-be-inspected data of the basic information class;
adding credit information, updating credit status and updating amount of the initial data of the credit in the intermediate data warehouse to obtain to-be-checked data of the credit, and storing the to-be-checked data into a second processing table; specifically, all client ids paid yesterday are inquired from a client borrowing information table, a client credit information table and a personal debit information table are correlated, and the credit name, the identity number, the credit limit and the credit state of a client credit and credit expiration date information of the client credit are inserted into a history processing table of his _ per _ credit; inquiring yesterday data of an expiration date from a client credit information table, changing a credit status into an expiration date, and inserting the yesterday data into a his _ per _ credit historical processing table; inquiring data with inconsistent quota from the client credit information table and the data upper report per _ credit, and then inserting the data of new quota into the his _ per _ credit table to form a second processing table to obtain to-be-inspected data of credit types;
performing loan information addition, loan state update and account state update on the initial data of the loans in the intermediate data warehouse to obtain data to be checked of the loans, and storing the data to be checked in a third processing table; specifically, a data borrowing information source table for all yesterday money paid is inquired from a customer data borrowing information table, the borrowing information of the customer is inserted into a his _ per _ loan history processing table, and the borrowing information comprises borrowing amount, remaining balance, due borrowing date, repayment date, account state, repayment amount in the month and actual repayment amount in the month; inquiring data with a borrow state of being clear and the clearing time of being yesterday from a client borrow information table, and modifying the account state to be closed and then inserting the data into his _ per _ loan; inquiring the loan data state from the customer loan data information table as overdue, modifying the account state as overdue, and inserting the modified account state into his _ per _ loan to form a third processing table to obtain the data to be checked of the loan;
checking the data to be checked, checking whether a null field exists, and taking the data to be checked without the null field as the data to be reported;
and correspondingly reporting the data to be reported according to the reporting requirement, and finishing the reporting of the data of the current day.
2. The method as claimed in claim 1, wherein the step of reading the basic information of the current day regularly, searching and extracting the initial data from the basic information, and inserting the extracted initial data into the intermediate data warehouse, and before the step of including at least the name field in the initial data, further comprises:
and receiving a data reporting instruction and receiving the basic information of the current day.
3. The method of claim 1, wherein the basic information comprises at least a customer basic information table, a customer borrowing information table, a customer credit information table, a customer offer record table, and a customer deduction record table.
4. The method according to claim 1, wherein the checking the data to be checked, checking whether there is a null field, and using the data to be checked without a null field as the data to be reported specifically comprises:
and respectively checking the data to be checked in the first processing table, the second processing table and the third processing table, checking whether a null field exists, and taking the data to be checked without the null field as the data to be reported.
5. The method of claim 1, wherein after the step of classifying the initial data in the intermediate data warehouse to obtain the data to be inspected after each classification processing, the method further comprises: and judging whether the current date is a holiday, if so, not checking, reserving the current date as data to be checked, and finishing execution.
6. The method as claimed in claim 1, wherein said step of checking said data to be checked, checking whether there is a null field, and using the data to be checked without a null field as the data to be reported further comprises:
and screening out the data to be reported of which the name fields conform to a preset white client list in the data to be reported according to the preset white client list.
7. The automatic financial data reporting device is characterized by comprising a data extraction module, a data processing module, a data checking module and a data reporting module, wherein:
the data extraction module is used for reading the basic information of the current day, inquiring and extracting initial data from the basic information, and inserting the extracted initial data into the intermediate data warehouse, wherein the initial data at least comprises a name field;
the data processing module is used for dividing the initial data into three types of data, namely basic information type, credit type and credit type, according to the extraction source of the initial data, wherein the extraction source comprises a customer basic information table, a customer borrowing information table, a customer credit information table, a personal debit information table, a data upper report, a customer period supply record table and a customer deduction record table; classifying and processing the three types of data in the intermediate data warehouse to obtain the data to be inspected after processing of each type; the method specifically comprises the following steps:
associating the initial data based on a name field; carrying out personal information adding processing on initial data of basic information types in the intermediate data warehouse, inquiring all client ids paid yesterday from a client borrowing information table in the intermediate data warehouse, associating the client basic information table, then inserting the client basic information into a first processing table of his _ per _ base after being taken out, wherein the basic information comprises personal names, mobile phone numbers, communication addresses, professional information, marital conditions and education information; a status field in the first processing table is used for recording the state of each piece of data to obtain the to-be-inspected data of the basic information class;
adding credit information, updating credit status and updating amount of the initial data of the credit in the intermediate data warehouse to obtain to-be-checked data of the credit, and storing the to-be-checked data into a second processing table; specifically, all client ids paid yesterday are inquired from a client borrowing information table, a client credit information table and a personal debit information table are correlated, and the credit name, the identity number, the credit limit and the credit state of a client credit and credit expiration date information of the client credit are inserted into a history processing table of his _ per _ credit; inquiring all data with yesterday as due date from a client credit information table, and inserting the data into a his _ per _ credit history processing table after changing the credit status to be due; inquiring data with inconsistent quota from the client credit information table and the data upper report per _ credit, and then inserting the data of new quota into the his _ per _ credit table to form a second processing table to obtain to-be-inspected data of credit types;
performing loan information addition, loan state update and account state update on the initial data of the loans in the intermediate data warehouse to obtain data to be checked of the loans, and storing the data to be checked in a third processing table; specifically, inquiring a data borrowing information source table for all yesterday money released from a client data borrowing information table, and inserting the client data borrowing information into a his _ per _ loan historical processing table, wherein the borrowing information comprises a borrowing amount, a credit balance, a borrowing due date, a repayment date, an account state, a repayment amount in the current month and an actual repayment amount in the current month; inquiring data with a borrow state of being clear and the clearing time of being yesterday from a client borrow information table, and modifying the account state to be closed and then inserting the data into his _ per _ loan; inquiring the loan data state from the customer loan data information table as overdue, modifying the account state as overdue, and inserting the modified account state into his _ per _ loan to form a third processing table to obtain the data to be checked of the loan;
the data checking module is used for checking the data to be checked, checking whether an empty field exists or not, and taking the data to be checked without the empty field as the data to be reported;
and the data reporting module is used for correspondingly reporting the data to be reported according to the reporting requirement so as to finish the reporting of the data of the day.
8. A computer arrangement comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 6 when executing the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011605668.0A CN112632169B (en) | 2020-12-29 | 2020-12-29 | Automatic financial data reporting method and device and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011605668.0A CN112632169B (en) | 2020-12-29 | 2020-12-29 | Automatic financial data reporting method and device and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112632169A CN112632169A (en) | 2021-04-09 |
| CN112632169B true CN112632169B (en) | 2023-03-28 |
Family
ID=75286448
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011605668.0A Active CN112632169B (en) | 2020-12-29 | 2020-12-29 | Automatic financial data reporting method and device and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112632169B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104160394A (en) * | 2011-12-23 | 2014-11-19 | 阿米亚托股份有限公司 | Scalable analysis platform for semi-structured data |
| CN109947746A (en) * | 2017-10-26 | 2019-06-28 | 亿阳信通股份有限公司 | A kind of quality of data management-control method and system based on ETL process |
| CN110019566A (en) * | 2019-03-13 | 2019-07-16 | 平安信托有限责任公司 | Data checking, device, computer equipment and storage medium based on data warehouse |
| CN111159191A (en) * | 2019-12-30 | 2020-05-15 | 深圳博沃智慧科技有限公司 | Data processing method, device and interface |
| CN111324647A (en) * | 2020-01-21 | 2020-06-23 | 北京东方金信科技有限公司 | Method and device for generating ETL code |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7363261B2 (en) * | 2002-05-08 | 2008-04-22 | Regions Asset Company | Method, computer program product and system for verifying financial data |
| US20040243588A1 (en) * | 2003-05-29 | 2004-12-02 | Thomas Tanner | Systems and methods for administering a global information database |
| US9684703B2 (en) * | 2004-04-29 | 2017-06-20 | Precisionpoint Software Limited | Method and apparatus for automatically creating a data warehouse and OLAP cube |
| US10725985B2 (en) * | 2015-02-20 | 2020-07-28 | Metropolitan Life Insurance Co. | System and method for enterprise data quality processing |
| CN107220892B (en) * | 2017-05-27 | 2020-10-16 | 国家计算机网络与信息安全管理中心 | Intelligent preprocessing tool and method applied to massive P2P network loan financial data |
| CN107908672B (en) * | 2017-10-24 | 2022-01-14 | 深圳前海微众银行股份有限公司 | Application report realization method, device and storage medium based on Hadoop platform |
| CN108829781B (en) * | 2018-05-31 | 2023-07-25 | 中国平安人寿保险股份有限公司 | Client information query method, device, computer equipment and storage medium |
| CN109670938B (en) * | 2018-10-10 | 2021-02-12 | 苏宁消费金融有限公司 | Method and system for merging and reporting credit investigation data |
| CN110321393A (en) * | 2019-06-28 | 2019-10-11 | 深圳前海微众银行股份有限公司 | Method for computing data, device, equipment and readable storage medium storing program for executing |
-
2020
- 2020-12-29 CN CN202011605668.0A patent/CN112632169B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104160394A (en) * | 2011-12-23 | 2014-11-19 | 阿米亚托股份有限公司 | Scalable analysis platform for semi-structured data |
| CN109947746A (en) * | 2017-10-26 | 2019-06-28 | 亿阳信通股份有限公司 | A kind of quality of data management-control method and system based on ETL process |
| CN110019566A (en) * | 2019-03-13 | 2019-07-16 | 平安信托有限责任公司 | Data checking, device, computer equipment and storage medium based on data warehouse |
| CN111159191A (en) * | 2019-12-30 | 2020-05-15 | 深圳博沃智慧科技有限公司 | Data processing method, device and interface |
| CN111324647A (en) * | 2020-01-21 | 2020-06-23 | 北京东方金信科技有限公司 | Method and device for generating ETL code |
Non-Patent Citations (3)
| Title |
|---|
| 吴国华 ; .数据库ETL在房产信息数据迁移整合中的应用.福建建设科技.2016,(04),86-88. * |
| 崔晓伟. 企业养老保险网上申报系统的设计与实现.《中国优秀硕士学位论文全文数据库信息科技辑》.2018,(7),I138-276. * |
| 张朋华 ; 李先国 ; 陈晓跃 ; .数据中心系统研究与实现.微处理机.2008,(02),83-84+87. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112632169A (en) | 2021-04-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7962386B2 (en) | Enterprise service architecture platform architecture for multi-application computer system | |
| US9703808B2 (en) | Data masking setup | |
| WO2020233307A1 (en) | Task data processing method and apparatus, computer device and storage medium | |
| US20050080821A1 (en) | System and method for managing collections accounts | |
| US20050165668A1 (en) | Multi-processing financial transaction processing system | |
| JP2020507135A (en) | Exclusive agent pool distribution method, electronic device, and computer-readable storage medium | |
| CN111178952A (en) | System, method and medium for sales lead follow-up and processing for the automotive industry | |
| US7805462B2 (en) | Portfolio management methods, systems, and computer programs | |
| CN112184005A (en) | Operation task classification method, device, equipment and storage medium | |
| JP2016522933A (en) | Calculating the probability of a defaulting company | |
| CN112632169B (en) | Automatic financial data reporting method and device and computer equipment | |
| CN112750027A (en) | Batch business processing method and device, computer equipment and storage medium | |
| CN104317660A (en) | Bank parameter managing system | |
| US10235719B2 (en) | Centralized GAAP approach for multidimensional accounting to reduce data volume and data reconciliation processing costs | |
| US10460116B2 (en) | Access control method, system and storage medium | |
| CN113436018A (en) | Asset hosting business processing method and device, storage medium and electronic equipment | |
| JPWO2018167983A1 (en) | Management information system, method and program | |
| CN110515989B (en) | Data real-time statistical method based on financial data management platform | |
| CN108008966B (en) | Resource updating method and system | |
| CN116382924B (en) | Recommendation method and device for resource allocation, electronic equipment and storage medium | |
| US20230237189A1 (en) | Data categories for purpose-based processing of personal data | |
| KR20080104863A (en) | Apparatus and method for workflow modeling data management | |
| CN116485570A (en) | Account checking method, device, equipment and medium | |
| CN116541351A (en) | Data processing method, device, equipment and storage medium | |
| CN117314166A (en) | Intelligent risk inspection method and device after claim |
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 |