CN109829814B - Method, device, equipment and storage medium for generating historical repayment information - Google Patents
Method, device, equipment and storage medium for generating historical repayment information Download PDFInfo
- Publication number
- CN109829814B CN109829814B CN201811654373.5A CN201811654373A CN109829814B CN 109829814 B CN109829814 B CN 109829814B CN 201811654373 A CN201811654373 A CN 201811654373A CN 109829814 B CN109829814 B CN 109829814B
- Authority
- CN
- China
- Prior art keywords
- processed
- information
- loan
- attribute
- target sample
- 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
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000000605 extraction Methods 0.000 claims description 6
- 230000000875 corresponding effect Effects 0.000 claims 13
- 230000002596 correlated effect Effects 0.000 claims 2
- 239000000284 extract Substances 0.000 abstract description 2
- 238000011144 upstream manufacturing Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention relates to the technical field of big data, further relates to the technical field of data standardization, and discloses a method, a device, equipment and a storage medium for generating historical repayment information. The invention acquires the to-be-processed loan service table, then determines to-be-processed framework information of the to-be-processed loan service table, searches the corresponding to-be-processed form template according to the to-be-processed framework information, extracts user information and the corresponding historical repayment record from the to-be-processed loan service table according to the to-be-processed form template, finally generates the historical repayment information according to the historical repayment record, and associates the historical repayment information with the user information.
Description
Technical Field
The present invention relates to the field of data standardization technologies, and in particular, to a method, an apparatus, a device, and a storage medium for generating historical payment information.
Background
The upstream business system (i.e., loan system) typically only records the latest user repayment status, assuming that the current time is 8 months and 14 days, and that the user repayment is performed on 8 months and 10 days, at this time, the upstream business system only records the status that characterizes whether the user repayment on 8 months and 10 days, and does not record the status that characterizes whether the user repayment on time before 8 months and 10 days.
When the upstream service system reports the credit to the bank, the historical data is needed to calculate the historical repayment information, and the upstream service system usually adopts a mode of self-calculating the historical repayment information at the moment, but the calculation of the historical repayment information involves logic calculation, so that the acquisition process of the historical repayment information is directly caused to be too slow, the processing resources of the upstream service system are occupied, and the efficiency of reporting the credit is influenced.
The foregoing is provided merely for the purpose of facilitating understanding of the technical solutions of the present invention and is not intended to represent an admission that the foregoing is prior art.
Disclosure of Invention
The invention mainly aims to provide a method, a device, equipment and a storage medium for generating historical repayment information, and aims to solve the technical problems that a loan system in the prior art is slower in obtaining the historical repayment information, occupies processing resources and affects credit reporting efficiency.
In order to achieve the above object, the present invention provides a method for generating historical payment information, the method for generating historical payment information comprising the steps of:
acquiring a loan service table to be processed;
determining the to-be-processed framework information of the to-be-processed loan business table;
searching a corresponding to-be-processed form template according to the to-be-processed framework information;
extracting user information and corresponding historical repayment records from the loan service table to be processed according to the table template to be processed;
and generating historical repayment information according to the historical repayment record, and associating the historical repayment information with the user information.
Preferably, the extracting, according to the form template to be processed, user information and a corresponding historical repayment record from the loan service table to be processed includes:
dividing the to-be-processed loan business table into a plurality of to-be-processed areas according to the to-be-processed table template;
determining the attribute of each to-be-processed area in the to-be-processed loan business table according to the to-be-processed table template;
and extracting information from the loan service table to be processed based on the attribute of each area to be processed, and obtaining user information and a corresponding historical repayment record.
Preferably, the searching for the corresponding to-be-processed form template according to the to-be-processed framework information includes:
and searching a corresponding to-be-processed form template in a preset template library according to the to-be-processed framework information.
Preferably, before the obtaining the pending loan service table, the method for generating the historical repayment information further includes:
acquiring sample loan business tables of different loan types;
traversing the sample loan business table, taking the traversed sample loan business table as a target sample loan business table, and determining target sample framework information corresponding to the target sample loan business table;
displaying the target sample loan business table;
receiving an area frame selection instruction and an attribute setting instruction input by a user based on a displayed target sample loan business table, and generating a target table template corresponding to the target sample loan business table according to the area frame selection instruction and the attribute setting instruction;
and associating the target sample framework information with a target table template, and storing the associated target sample framework information and target table template into a preset template library.
Preferably, the receiving the region frame selection instruction and the attribute setting instruction input by the user based on the displayed target sample loan service table, and generating the target table template corresponding to the target sample loan service table according to the region frame selection instruction and the attribute setting instruction, includes:
receiving an area frame selection instruction and an attribute setting instruction which are input by a user based on a displayed target sample loan business table;
determining the region position of a frame selection region corresponding to the region frame selection instruction in the target sample loan service table;
setting attributes for the frame selection area according to the attribute setting instruction;
and returning to the step of receiving the region frame selection instruction and the attribute setting instruction input by the user based on the displayed target sample loan service table, and taking the region position of each frame selection region and the set attribute in the target sample loan service table as the target table template until receiving the stop setting instruction input by the user.
Preferably, the setting the attribute for the box selection area according to the attribute setting instruction includes:
acquiring an attribute to be set corresponding to the attribute setting instruction, and acquiring an explanation element from preset cells of the target sample loan service table, wherein the preset cells are cells adjacent to the frame selection area;
performing fuzzy matching on the attribute to be set and the description element;
when the attribute to be set and the description element are successfully subjected to fuzzy matching, setting the attribute of the frame selection area as the attribute to be set;
and when the fuzzy matching of the attribute to be set and the description element is unsuccessful, displaying reminding information of setting failure, prompting to reenter the attribute setting instruction, and setting the attribute for the frame selection area according to the reentered attribute setting instruction.
Preferably, the obtaining the pending loan service table includes:
and collecting each loan business table in the loan system, traversing the collected loan business tables, and taking the traversed loan business tables as the loan business tables to be processed.
In addition, in order to achieve the above object, the present invention further provides a device for generating historical payment information, the device comprising:
the service table acquisition module is used for acquiring a loan service table to be processed;
the framework determining module is used for determining the to-be-processed framework information of the to-be-processed loan business table;
the template searching module is used for searching a corresponding to-be-processed form template according to the to-be-processed framework information;
the information extraction module is used for extracting user information and a corresponding historical repayment record from the loan business table to be processed according to the form template to be processed;
and the information generation module is used for generating historical repayment information according to the historical repayment record and associating the historical repayment information with the user information.
In addition, in order to achieve the above object, the present invention also provides a device for generating historical payment information, the device comprising: the system comprises a memory, a processor and a historical repayment information generation program which is stored in the memory and can run on the processor, wherein the historical repayment information generation program is configured to realize the steps of the historical repayment information generation method.
In addition, in order to achieve the above object, the present invention also provides a storage medium having stored thereon a generation program of history payment information, which when executed by a processor, implements the steps of the generation method of history payment information as described above.
The invention acquires the to-be-processed loan service table, then determines to-be-processed framework information of the to-be-processed loan service table, searches the corresponding to-be-processed form template according to the to-be-processed framework information, extracts user information and the corresponding historical repayment record from the to-be-processed loan service table according to the to-be-processed form template, finally generates the historical repayment information according to the historical repayment record, and associates the historical repayment information with the user information.
Drawings
FIG. 1 is a schematic diagram of a device for generating historical payment information for a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a flowchart of a first embodiment of a method for generating historical payment information according to the present invention;
FIG. 3 is a schematic diagram of a form style of a loan service table, according to an embodiment of the invention;
FIG. 4 is a schematic diagram of a form style of another loan service table, in accordance with an embodiment of the invention;
FIG. 5 is a flowchart of a second embodiment of a method for generating historical payment information according to the present invention;
fig. 6 is a block diagram showing a first embodiment of a device for generating historical payment information according to the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a generating device of historical repayment information of a hardware running environment according to an embodiment of the present invention.
As shown in fig. 1, the generating device of the historical payment information may include: a processor 1001, such as a central processing unit (Central Processing Unit, CPU), a communication bus 1002, a user interface 1003, a network interface 1004, a memory 1005. Wherein the communication bus 1002 is used to enable connected communication between these components. The user interface 1003 may include a Display, an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may further include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a WIreless interface (e.g., a WIreless-FIdelity (WI-FI) interface). The Memory 1005 may be a high-speed random access Memory (Random Access Memory, RAM) Memory or a stable nonvolatile Memory (NVM), such as a disk Memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.
It will be appreciated by those skilled in the art that the structure shown in fig. 1 does not constitute a limitation of the apparatus for generating historical payment information, and may include more or fewer components than shown, or may combine certain components, or may have a different arrangement of components.
As shown in fig. 1, the memory 1005, which is a storage medium, may include an operating system, a network communication module, a user interface module, and a generation program of history payment information.
In the generation device of the historical payment information shown in fig. 1, the network interface 1004 is mainly used for data communication with other devices; the user interface 1003 is mainly used for data interaction with a user; the processor 1001 and the memory 1005 in the historical payment information generating device of the present invention may be provided in the historical payment information generating device, where the historical payment information generating device calls a historical payment information generating program stored in the memory 1005 through the processor 1001, and executes the historical payment information generating method provided by the embodiment of the present invention.
An embodiment of the present invention provides a method for generating historical payment information, and referring to fig. 2, fig. 2 is a schematic flow chart of a first embodiment of a method for generating historical payment information according to the present invention.
In this embodiment, the method for generating the historical payment information includes the following steps:
s10: and obtaining a loan business table to be processed.
The execution subject of the method of the present embodiment is specifically a server capable of performing data processing.
It can be understood that the to-be-processed loan business table is a loan business table to be processed at the current moment, and of course, in a specific implementation, the to-be-processed loan business table is usually a loan business table in a loan system, which is usually more in number, so as to process each loan business table conveniently to prevent omission.
Generally, the loan system is a system for processing a loan application, which may be referred to as an upstream business system, and correspondingly, the server is referred to as a downstream business system.
S20: and determining the to-be-processed framework information of the to-be-processed loan business table.
Since there are a plurality of business tables of different loan types in the upstream business system, for example: the loan can be divided into mortgage-free loan and mortgage-free loan, and the mortgage-free loan have different frame information due to different related information conditions, so that the frame information to be processed of the frame information to be processed can be determined.
It should be noted that the to-be-processed architecture information is information for reflecting the table style of the to-be-processed loan service table, and it is assumed that one loan service table is the table style of fig. 3, and the other loan service table is the table style of fig. 4, and the table styles of the two loan service tables are completely different, i.e. the architecture information of the two loan service tables is completely different.
In a specific implementation, in order to determine the to-be-processed architecture information of the to-be-processed loan service table, the to-be-processed loan service table may be duplicated, data of the duplicated to-be-processed loan service table may be deleted, and the to-be-processed loan service table after deleting the data may be used as the to-be-processed architecture information.
S30: and searching a corresponding to-be-processed form template according to the to-be-processed framework information.
It can be understood that, for the loan service table of different architecture information, the corresponding table templates will also be different, so that the corresponding table templates to be processed can be searched according to the architecture information to be processed.
S40: and extracting user information and corresponding historical repayment records from the to-be-processed loan business table according to the to-be-processed table template.
It should be noted that, the area location and the attribute of the area to be processed will be carried in one form template, so the loan service table to be processed may be divided into a plurality of areas to be processed according to the form template to be processed, then the attribute of each area to be processed in the loan service table to be processed is determined according to the form template to be processed, and finally information extraction is performed on the loan service table to be processed based on the attribute of each area to be processed, so as to obtain user information and corresponding historical repayment record.
It will be appreciated that the attributes are used to indicate the type of data in the region, for example: when the attribute is 'name', the data in the region can be extracted as 'name'; when the attribute is 'repayment date', the data in the area can be extracted as 'repayment date'.
In a specific implementation, the attribute of each to-be-processed area in the to-be-processed loan business table can be determined through the to-be-processed table template, so that the information extraction of the to-be-processed loan business table can be successfully completed, and the user information and the corresponding historical repayment record can be obtained.
S50: and generating historical repayment information according to the historical repayment record, and associating the historical repayment information with the user information.
It should be noted that, the historical payment record generally includes records of a statistical date, a payment number, a payment plan number, a expiration date overdue day, an expiration date overdue amount, and the like, and the historical payment information is information for reflecting a user's payment condition in a certain period of time, specifically, the historical payment information may be generated according to a preset rule according to the historical payment record, where the preset rule is determined by the historical payment information required by the loan system.
Assuming that the historical repayment information is the repayment overdue condition in the last half year, at this time, the repayment overdue condition in the last half year can be determined according to the historical repayment record in the last half year; and assuming that the historical repayment information is the repayment overdue condition in the last year, at this time, the repayment overdue condition in the last year can be determined according to the historical repayment record in the last year.
In order to facilitate the subsequent loan system to invoke the historical repayment information for each user, in this embodiment, the historical repayment information may be associated with the user information.
According to the method, the system and the device, the to-be-processed loan service table is obtained, to-be-processed framework information of the to-be-processed loan service table is determined, then the corresponding to-be-processed form template is searched according to the to-be-processed framework information, user information and the corresponding historical repayment record are extracted from the to-be-processed loan service table according to the to-be-processed form template, finally the historical repayment information is generated according to the historical repayment record, and the historical repayment information is associated with the user information.
Referring to fig. 5, fig. 5 is a flowchart illustrating a second embodiment of a method for generating historical payment information according to the present invention.
Based on the first embodiment, in this embodiment, step S30 includes:
s31: and searching a corresponding to-be-processed form template in a preset template library according to the to-be-processed framework information.
In order to facilitate searching the to-be-processed form template, in this embodiment, a preset template library may be pre-established, and the corresponding relation between various framework information and the corresponding form template may be stored in the preset template library.
In order to facilitate the establishment of the preset template library, in this embodiment, before step 10, the method for generating historical repayment information further includes:
s01: and obtaining sample loan business tables of different loan types.
It should be noted that, in order to ensure that the sample loan business tables of multiple loan types generate corresponding table templates, in this embodiment, sample loan business tables of different loan types may be obtained.
S02: traversing the sample loan business table, taking the traversed sample loan business table as a target sample loan business table, and determining target sample framework information corresponding to the target sample loan business table.
It can be understood that, in order to determine the target sample architecture information corresponding to the target sample loan service table, the target sample loan service table may be duplicated, the duplicated target sample loan service table may be deleted, and the target sample loan service table after deleting the data may be used as the target sample architecture information.
S03: and displaying the target sample loan business table.
In a specific implementation, in order to facilitate the user to input a corresponding instruction, in this embodiment, the target sample loan service table may be displayed.
S04: and receiving an area frame selection instruction and an attribute setting instruction which are input by a user based on the displayed target sample loan business table, and generating a target table template corresponding to the target sample loan business table according to the area frame selection instruction and the attribute setting instruction.
It can be understood that the region frame selection instruction is an instruction generated when a user selects a region in the target sample loan service table, and the attribute setting instruction is an instruction for setting an attribute of the frame selection region, but in the process of generating the target table template, the region frame selection and the attribute setting are generally required to be performed on the target sample loan service table for multiple times, so as to generate the target table template.
It can be understood that, in general, the data portion of the table corresponds to the frame selection area, in the target sample loan service table, there is typically an explanation element representing the attribute thereof near the frame selection area, and when the user performs attribute setting, there may be a setting error, so as to be convenient for verifying the attribute of the attribute setting instruction, when the attribute is set for the frame selection area according to the attribute setting instruction, the attribute to be set corresponding to the attribute setting instruction may be acquired first, and the explanation element is acquired from a preset cell of the target sample loan service table, where the preset cell is a cell adjacent to the frame selection area; then carrying out fuzzy matching on the attribute to be set and the description element; when the attribute to be set and the description element are successfully subjected to fuzzy matching, setting the attribute of the frame selection area as the attribute to be set; and when the fuzzy matching of the attribute to be set and the description element is unsuccessful, displaying reminding information of setting failure, prompting to reenter the attribute setting instruction, and setting the attribute for the frame selection area according to the reentered attribute setting instruction.
It should be noted that fuzzy matching is synonymous matching, and it is assumed that the attribute to be set is "name", and in general, if the description element obtained in the preset cell is "name", at this time, the content of the attribute to be set and the content of the description element are the same, and it can be understood that the fuzzy matching of the attribute to be set and the description element is successful;
if the description element obtained from the preset cell is a name or a name, the attribute to be set and the description element are different in content, but belong to synonyms, and the fact that the attribute to be set and the description element are matched successfully in a fuzzy manner can be understood;
however, it is assumed that the description element acquired in the preset cell is "age" or "age", and at this time, the attribute to be set and the content of the description element are different, and the attribute to be set and the description element do not belong to synonyms, which can be understood that fuzzy matching of the attribute to be set and the description element is unsuccessful.
In a specific implementation, in order to facilitate fuzzy matching, a synonym library may be pre-established, when the attribute to be set is matched with the description element in a fuzzy manner, if the attribute to be set is different from the description element, the synonym library is searched according to the attribute to be set and the description element, and whether the attribute to be set and the description element belong to synonyms is determined according to the search result.
S05: and associating the target sample framework information with a target table template, and storing the associated target sample framework information and target table template into a preset template library.
In addition, the embodiment of the invention also provides a storage medium, wherein the storage medium stores a generation program of the historical payment information, and the generation program of the historical payment information realizes the steps of the generation method of the historical payment information when being executed by a processor.
Referring to fig. 6, fig. 6 is a block diagram showing a first embodiment of a device for generating historical payment information according to the present invention.
As shown in fig. 6, the apparatus for generating historical payment information according to the embodiment of the present invention includes:
a service table acquisition module 6001 for acquiring a loan service table to be processed;
a frame determining module 6002, configured to determine frame information to be processed of the loan service table to be processed;
the template searching module 6003 is configured to search a corresponding to-be-processed form template according to the to-be-processed framework information;
the information extraction module 6004 is configured to extract user information and a corresponding historical repayment record from the loan service table to be processed according to the table template to be processed;
the information generating module 6005 is configured to generate historical payment information according to the historical payment record, and associate the historical payment information with the user information.
It should be noted that, the region location and the attribute of the region to be processed will be carried in one form template, so the information extraction module 6004 is further configured to divide the loan service table to be processed into a plurality of regions to be processed according to the form template to be processed; determining the attribute of each to-be-processed area in the to-be-processed loan business table according to the to-be-processed table template; and extracting information from the loan service table to be processed based on the attribute of each area to be processed, and obtaining user information and a corresponding historical repayment record.
It may be understood that, in this embodiment, a preset template library may be pre-established to facilitate searching the to-be-processed table template, and the corresponding relationship between the various framework information and the corresponding table template is stored in the preset template library, and in this embodiment, the template searching module 6003 is further configured to search the corresponding to-be-processed table template in the preset template library according to the to-be-processed framework information.
In order to facilitate the establishment of the preset template library, in this embodiment, the generating device of the historical payment information further includes:
the template library building module is used for obtaining sample loan business tables of different loan types; traversing the sample loan business table, taking the traversed sample loan business table as a target sample loan business table, and determining target sample framework information corresponding to the target sample loan business table; displaying the target sample loan business table; receiving an area frame selection instruction and an attribute setting instruction input by a user based on a displayed target sample loan business table, and generating a target table template corresponding to the target sample loan business table according to the area frame selection instruction and the attribute setting instruction; and associating the target sample framework information with a target table template, and storing the associated target sample framework information and target table template into a preset template library.
It can be understood that the region frame selection instruction is an instruction generated when a user selects a region in the target sample loan service table, and the attribute setting instruction is an instruction for setting an attribute in the frame selection region, but in the process of generating the target table template, the target sample loan service table is generally required to be subjected to region frame selection and attribute setting for multiple times, so as to generate the target table template, in this embodiment, the template library building module is further configured to receive the region frame selection instruction and the attribute setting instruction input by the user based on the displayed target sample loan service table; determining the region position of a frame selection region corresponding to the region frame selection instruction in the target sample loan service table; setting attributes for the frame selection area according to the attribute setting instruction; and returning to the step of receiving the region frame selection instruction and the attribute setting instruction input by the user based on the displayed target sample loan service table, and taking the region position of each frame selection region and the set attribute in the target sample loan service table as the target table template until receiving the stop setting instruction input by the user.
It can be understood that, in general, the data portion of the table corresponds to the frame selection area, in the target sample loan service table, there is typically an explanation element representing the attribute thereof near the frame selection area, and when the user performs attribute setting, there may be a setting error, so as to facilitate verifying the attribute of the attribute setting instruction, the template library building module is further configured to obtain the attribute to be set corresponding to the attribute setting instruction, and obtain the explanation element from a preset cell of the target sample loan service table, where the preset cell is a cell adjacent to the frame selection area; performing fuzzy matching on the attribute to be set and the description element; when the attribute to be set and the description element are successfully subjected to fuzzy matching, setting the attribute of the frame selection area as the attribute to be set; and when the fuzzy matching of the attribute to be set and the description element is unsuccessful, displaying reminding information of setting failure, prompting to reenter the attribute setting instruction, and setting the attribute for the frame selection area according to the reentered attribute setting instruction.
It can be understood that the to-be-processed loan business table is a loan business table to be processed at the current moment, and of course, in a specific implementation, the to-be-processed loan business table is generally a loan business table in a loan system, which generally has a larger number, so as to process each loan business table to prevent omission.
In addition, technical details not described in detail in the present embodiment may refer to the method for generating historical payment information provided in any embodiment of the present invention, which is not described herein.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (8)
1. The method for generating the historical repayment information is characterized by comprising the following steps of:
acquiring sample loan business tables of different loan types;
traversing the sample loan business table, taking the traversed sample loan business table as a target sample loan business table, and determining target sample framework information corresponding to the target sample loan business table;
displaying the target sample loan business table;
receiving an area frame selection instruction and an attribute setting instruction which are input by a user based on a displayed target sample loan business table;
determining the region position of a frame selection region corresponding to the region frame selection instruction in the target sample loan service table;
setting attributes for the frame selection area according to the attribute setting instruction;
returning to the step of receiving the region frame selection instruction and the attribute setting instruction input by the user based on the displayed target sample loan service table, and taking the region position of each frame selection region and the set attribute in the target sample loan service table as a target table template until receiving the stop setting instruction input by the user;
correlating the target sample framework information with a target form template, and storing the correlated target sample framework information and the correlated target form template into a preset template library;
acquiring a loan service table to be processed;
determining the to-be-processed framework information of the to-be-processed loan business table;
searching a corresponding to-be-processed form template according to the to-be-processed framework information;
extracting user information and corresponding historical repayment records from the loan service table to be processed according to the table template to be processed;
and generating historical repayment information according to the historical repayment record, and associating the historical repayment information with the user information.
2. The method for generating historical payment information according to claim 1, wherein the step of extracting user information and a corresponding historical payment record from the pending loan service table according to the pending form template comprises:
dividing the to-be-processed loan business table into a plurality of to-be-processed areas according to the to-be-processed table template;
determining the attribute of each to-be-processed area in the to-be-processed loan business table according to the to-be-processed table template;
and extracting information from the loan service table to be processed based on the attribute of each area to be processed, and obtaining user information and a corresponding historical repayment record.
3. The method for generating historical payment information according to claim 1, wherein searching for a corresponding form template to be processed according to the frame information to be processed comprises:
and searching a corresponding to-be-processed form template in a preset template library according to the to-be-processed framework information.
4. The method for generating historical payment information as recited in claim 1, wherein said setting an attribute for said selected area according to said attribute setting instruction comprises:
acquiring an attribute to be set corresponding to the attribute setting instruction, and acquiring an explanation element from preset cells of the target sample loan service table, wherein the preset cells are cells adjacent to the frame selection area;
performing fuzzy matching on the attribute to be set and the description element;
when the attribute to be set and the description element are successfully subjected to fuzzy matching, setting the attribute of the frame selection area as the attribute to be set;
and when the fuzzy matching of the attribute to be set and the description element is unsuccessful, displaying reminding information of setting failure, prompting to reenter the attribute setting instruction, and setting the attribute for the frame selection area according to the reentered attribute setting instruction.
5. The method for generating historical payment information according to any one of claims 1 to 4, wherein the obtaining a pending loan service table includes:
and collecting each loan business table in the loan system, traversing the collected loan business tables, and taking the traversed loan business tables as the loan business tables to be processed.
6. A device for generating historical payment information, the device comprising:
the service table acquisition module is used for acquiring a loan service table to be processed;
the framework determining module is used for determining the to-be-processed framework information of the to-be-processed loan business table;
the template searching module is used for searching a corresponding to-be-processed form template according to the to-be-processed framework information;
the information extraction module is used for extracting user information and a corresponding historical repayment record from the loan business table to be processed according to the form template to be processed;
the information generation module is used for generating historical repayment information according to the historical repayment record and associating the historical repayment information with the user information;
wherein, the service table acquisition module is further configured to:
acquiring sample loan business tables of different loan types;
traversing the sample loan business table, taking the traversed sample loan business table as a target sample loan business table, and determining target sample framework information corresponding to the target sample loan business table;
displaying the target sample loan business table;
receiving an area frame selection instruction and an attribute setting instruction which are input by a user based on a displayed target sample loan business table;
determining the region position of a frame selection region corresponding to the region frame selection instruction in the target sample loan service table;
setting attributes for the frame selection area according to the attribute setting instruction;
returning to the step of receiving the region frame selection instruction and the attribute setting instruction input by the user based on the displayed target sample loan service table, and taking the region position of each frame selection region and the set attribute in the target sample loan service table as a target table template until receiving the stop setting instruction input by the user;
and associating the target sample framework information with a target table template, and storing the associated target sample framework information and target table template into a preset template library.
7. A generation apparatus of historical payment information, the apparatus comprising: a memory, a processor, and a generation program of historical payment information stored on the memory and executable on the processor, the generation program of historical payment information configured to implement the steps of the method of generating historical payment information as claimed in any one of claims 1 to 5.
8. A storage medium having stored thereon a history payment information generation program which, when executed by a processor, implements the steps of the history payment information generation method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811654373.5A CN109829814B (en) | 2018-12-29 | 2018-12-29 | Method, device, equipment and storage medium for generating historical repayment information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811654373.5A CN109829814B (en) | 2018-12-29 | 2018-12-29 | Method, device, equipment and storage medium for generating historical repayment information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109829814A CN109829814A (en) | 2019-05-31 |
| CN109829814B true CN109829814B (en) | 2024-04-02 |
Family
ID=66861453
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811654373.5A Active CN109829814B (en) | 2018-12-29 | 2018-12-29 | Method, device, equipment and storage medium for generating historical repayment information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109829814B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107146082A (en) * | 2017-05-27 | 2017-09-08 | 北京小米移动软件有限公司 | Transaction record information acquisition methods, device and computer-readable recording medium |
| CN107545404A (en) * | 2016-06-29 | 2018-01-05 | 腾讯科技（深圳）有限公司 | Bill based reminding method and device |
| CN108846520A (en) * | 2018-06-22 | 2018-11-20 | 北京京东金融科技控股有限公司 | Overdue loan prediction technique, device and computer readable storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7444302B2 (en) * | 2002-06-14 | 2008-10-28 | Ellie Mae, Inc. | Online system for fulfilling loan applications from loan originators |
| JP5465015B2 (en) * | 2010-01-06 | 2014-04-09 | キヤノン株式会社 | Apparatus and method for digitizing documents |
| US20120191594A1 (en) * | 2011-01-20 | 2012-07-26 | Social Avail LLC. | Online business method for providing a financial service or product |
| US9082151B2 (en) * | 2012-05-30 | 2015-07-14 | Ncino, Inc. | Financial-service structured content manager |
-
2018
- 2018-12-29 CN CN201811654373.5A patent/CN109829814B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107545404A (en) * | 2016-06-29 | 2018-01-05 | 腾讯科技（深圳）有限公司 | Bill based reminding method and device |
| CN107146082A (en) * | 2017-05-27 | 2017-09-08 | 北京小米移动软件有限公司 | Transaction record information acquisition methods, device and computer-readable recording medium |
| CN108846520A (en) * | 2018-06-22 | 2018-11-20 | 北京京东金融科技控股有限公司 | Overdue loan prediction technique, device and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109829814A (en) | 2019-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109726105B (en) | Test data construction method, device, equipment and storage medium | |
| WO2019056710A1 (en) | Supplier recommendation method and apparatus, and computer readable storage medium | |
| US9787838B1 (en) | System and method for analysis of interactions with a customer service center | |
| CN113448862B (en) | Software version testing method and device and computer equipment | |
| WO2020259325A1 (en) | Feature processing method applicable to machine learning, and device | |
| US20180300413A1 (en) | Method, device, server and storage medium of searching a group based on social network | |
| CN112667802A (en) | Service information input method, device, server and storage medium | |
| CN111858608A (en) | Data management method, device, server and storage medium | |
| CN111369294B (en) | Software cost estimation method and device | |
| CN111737443B (en) | Answer text processing method and device and key text determining method | |
| CN110750619B (en) | Chat record keyword extraction method and device, computer equipment and storage medium | |
| CN116881051B (en) | Data backup and recovery method and device, electronic equipment and storage medium | |
| CN109829814B (en) | Method, device, equipment and storage medium for generating historical repayment information | |
| CN116074183B (en) | C3 timeout analysis method, device and equipment based on rule engine | |
| CN108880835B (en) | Data analysis method and device and computer storage medium | |
| CN115660695A (en) | Customer service personnel label portrait construction method and device, electronic equipment and storage medium | |
| CN114443493A (en) | Test case generation method and device, electronic equipment and storage medium | |
| JP2001044412A (en) | Semiconductor simulation apparatus | |
| CN111752927A (en) | Clone-based data form generation method, device, terminal equipment and medium | |
| CN113342931B (en) | Big data based user demand analysis method, device, equipment and storage medium | |
| CN109670154B (en) | Base table configuration method, equipment, storage medium and device | |
| CN117763140B (en) | Accurate medical information conclusion generation method based on computing feature network | |
| CN112925856B (en) | Entity relationship analysis method, entity relationship analysis device, entity relationship analysis equipment and computer storage medium | |
| CN115456586A (en) | Intelligent interviewing method and device, computer equipment and storage medium | |
| CN117149753A (en) | Data checking method and system |
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 |