CN111639910A - Standing book generation method, device, equipment and storage medium - Google Patents
Standing book generation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN111639910A CN111639910A CN202010463666.6A CN202010463666A CN111639910A CN 111639910 A CN111639910 A CN 111639910A CN 202010463666 A CN202010463666 A CN 202010463666A CN 111639910 A CN111639910 A CN 111639910A
- Authority
- CN
- China
- Prior art keywords
- business
- information
- standing book
- tables
- ledger
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000003860 storage Methods 0.000 title claims abstract description 19
- 238000004590 computer program Methods 0.000 claims description 9
- 230000006870 function Effects 0.000 description 13
- 238000007726 management method Methods 0.000 description 11
- 238000011161 development Methods 0.000 description 10
- 238000012545 processing Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 6
- 230000003287 optical effect Effects 0.000 description 6
- 238000011084 recovery Methods 0.000 description 4
- 238000012546 transfer Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000012795 verification Methods 0.000 description 3
- 230000002776 aggregation Effects 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 2
- 238000012550 audit Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000013508 migration Methods 0.000 description 2
- 230000005012 migration Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000005215 recombination Methods 0.000 description 2
- 230000006798 recombination Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 125000004122 cyclic group Chemical group 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 201000010099 disease Diseases 0.000 description 1
- 208000037265 diseases, disorders, signs and symptoms Diseases 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 238000012946 outsourcing Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 238000012954 risk control Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000013515 script Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/03—Credit; Loans; Processing thereof
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Finance (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Technology Law (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a standing book generating method, a device, equipment and a storage medium. The method comprises the following steps: acquiring a core field; determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables; acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage; selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information; acquiring the associated information of the at least two business tables; and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
Description
Technical Field
The embodiment of the invention relates to computer technology, in particular to a standing book generating method, a standing book generating device, equipment and a storage medium.
Background
With the rapid development of national economy in China, bank borrowers cannot pay timely, so that banks can continuously expose bad assets, and the forming reasons are as follows: the financial situation is constantly changed, the economic development presents the cyclic fluctuation between prosperity and the scholar, and the scholar period influences the profit capacity and the fund mobility of the participants; market capital moves among hot spot industries, the industry technology is continuously promoted to be new, part of enterprises encounter resistance in commercial development and the consumption market is atrophied; enterprise managers lack of management quality and poor risk control capability, and the borrowing is blindly expanded and illegally used in enterprise operation; when an individual suffers from household accidents or sudden diseases, the ability of repayment is lost; personal credit insights of thin or deliberate evasion of liabilities, etc.
Aiming at the bad loans, banks need to practically implement a bad asset management and management method according to related national laws and regulations and financial institution self regulations, clear the requirements of the bad financial asset disposition work due to the best effort, prevent moral risks, promote loan recovery in various asset disposition modes and reduce bank losses.
In the operation management work of the poor assets, the following types of standing accounts are often needed to be involved:
1. the client class of the bad assets comprises the client details of the bad assets, basic information of related persons (debtors and guarantors, spouses, common borrowers and the like), other debts and guarantor details of the related persons, additional compensation details of the related persons by other organizations, financial production line claim details of the related persons, share rights of the related persons and control right details;
2. the system comprises a contract class of the poor assets, a contract rule, a contract receiving rule, a contract quitting (inventory, migration, recombination, transfer and securitization) rule, a litigation timeliness information rule and an application execution deadline rule, wherein the contract class of the poor assets comprises a contract rule detail of the poor assets, a classification change detail of contract risk, a contract receiving detail, a contract quitting (inventory, migration, recombination, transfer and securitization) detail, a litigation timeliness;
3. the bad asset accounts comprise account principal interest, penalty interest and profit recovery balance details and principal recovery details;
4. bad asset property right class, contract related to the state of the mortgage, value change detail and right certificate detail;
5. bad asset management, detail collection (home collection, call collection, short message letter collection, outsourcing collection), detail evaluation;
6. bad asset disposition, collection, storage, calculation, disposition details of the debt assets, batch transfer details, verification and preparation details, and details of the litigation fees to be settled;
7. and (4) taking requirements of each stage of central lines, bank audits, temporary audits of the resource management company, statistics, asset transfer price inquiry and the like.
Therefore, the ledgers form the fact description of the undesirable assets from all dimensions, help the undesirable asset management departments to make asset management plans, strengthen plan management on asset recovery, disposal cost and disposal profit and loss, and continuously track and monitor project progress; relevant regulations of the country are implemented, and a complete and real archive is formed for the asset management disposal process and the result.
But we also see that the types of bad asset accounts are more, the emphasis of each account under a specific type is different, and how to quickly and effectively establish the accounts according to user configuration is a technical problem which is urgently needed to be solved at present.
Disclosure of Invention
The embodiment of the invention provides a standing book generating method, a device, equipment and a storage medium, which are used for realizing the purpose of quickly and effectively establishing a standing book according to user configuration.
In a first aspect, an embodiment of the present invention provides a standing book generation method, including:
acquiring a core field;
determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage;
selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information;
acquiring the associated information of the at least two business tables;
and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
Further, the core field includes: at least one of a loan institution, a customer manager name, a customer number, a customer name, a contract number, an account number, an intrinsic balance, an expiration time, a loan classification, and a loan period.
Further, the service table candidate pool includes: at least one of a customer information form, a contract form, an account balance form, a payment schedule form, and a plan form.
Further, merging the at least two service forms according to the at least two service forms and the association information of the at least two service forms to obtain an account book includes:
if the association information of the at least two business forms is internal association, acquiring the same core fields in the at least two business forms, and combining the same core fields in the at least two business forms to obtain a machine account;
and if the association information of the at least two business tables is left association, combining the at least two business tables to obtain the machine account.
Further, acquiring the standing book information includes:
when the click operation of a user on a drop-down box in an area corresponding to a query condition in a standing book generation interface is detected, displaying field information corresponding to the drop-down box;
and when the touch operation of the user on the field information corresponding to the drop-down box is detected, acquiring the field information as the standing book information.
Further, determining the service table candidate pool according to the core field includes:
pre-establishing a database for storing at least one business table aiming at poor assets users;
and selecting at least one service form from the database according to the core field, and determining the at least one service form as a service form candidate pool.
In a second aspect, an embodiment of the present invention further provides an apparatus for generating a standing book, where the apparatus for generating a standing book includes:
the first acquisition module is used for acquiring the core field;
the determining module is used for determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
a second obtaining module, configured to obtain standing book information, where the standing book information includes: at least one of ledger name, ledger classification, and ledger usage;
the selecting module is used for selecting at least two business tables from the business table candidate pool as target business tables according to the standing book information;
a third obtaining module, configured to obtain association information of the at least two service tables;
and the merging module is used for merging the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
In a third aspect, an embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement the ledger generation method according to any one of the embodiments of the present invention.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the ledger generation method according to any one of the embodiments of the present invention.
The embodiment of the invention obtains the core field; determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables; acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage; selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information; acquiring the associated information of the at least two business tables; and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book, so that the standing book can be quickly and effectively established according to user configuration.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 is a flowchart of a standing book generation method in a first embodiment of the present invention;
fig. 2A is a flowchart of a ledger generation method in the second embodiment of the present invention;
fig. 2B is a diagram of an account generation interface in the second embodiment of the present invention;
fig. 3 is a schematic structural diagram of an account book generation apparatus in a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device in the fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present invention, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance.
Example one
Fig. 1 is a flowchart of a standing book generation method according to an embodiment of the present invention, where this embodiment is applicable to a situation of standing book generation, and the method may be executed by a standing book generation apparatus according to an embodiment of the present invention, and the apparatus may be implemented in a software and/or hardware manner, as shown in fig. 1, the method specifically includes the following steps:
s110, acquiring a core field;
specifically, the core field is field information related to the bad asset account, including but not limited to at least one of a loan institution, a customer manager name, a customer number, a customer name, a contract number, an account number, a local balance, an expiration time, a loan classification, and a loan period.
Optionally, the core field includes: at least one of a loan institution, a customer manager name, a customer number, a customer name, a contract number, an account number, an intrinsic balance, an expiration time, a loan classification, and a loan period.
S120, determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
wherein the service table candidate pool comprises: at least one of a customer information table, a contract table, an account balance table, a repayment flow table and a plan scheme table, wherein each business table is at least two.
The determination mode of the service form candidate pool may be determined by at least one service form selected from the database according to the core field, or may be determined by at least one service form obtained by directly querying a form related to a bad asset account according to a keyword, which is not limited in the embodiment of the present invention.
Specifically, a service form candidate pool is determined according to the core field, and the service form candidate pool includes: at least one of a customer information table, a contract table, an account balance table, a repayment flow table and a plan scheme table, wherein each business table is at least two.
S130, obtaining standing book information, wherein the standing book information comprises: a ledger name, a ledger classification, and ledger usage.
The method for acquiring the standing book information can be user-defined standing book generating conditions, for example, the name of a user, a loan account number, loan types, balance and the like, condition contents which are newly added to be input by a standing book user on an interface are added in a standing book generating interface one by one, and the condition name and the type (numerical value, text, date and drop-down box) of the numerical value input by the user are defined; the ledger generation conditions that may also be defined for the system may be, for example, primary, secondary, or office lines. The embodiments of the present invention are not limited in this regard.
Specifically, the standing book information input by the user is obtained, the mode of inputting the standing book information by the user may be through voice input or through keyboard input, which is not limited in this embodiment of the present invention, and the standing book information is field information related to an account of the undesirable asset, where the standing book information includes: a ledger name, a ledger classification, and ledger usage.
S140, at least two business forms are selected from the business form candidate pool as target business forms according to the standing book information.
The at least two service tables may include a master table and a slave table, for example, the at least two service tables may include a master table and a slave table, or may include a master table and at least two slave tables.
Specifically, one master table with a higher matching degree and one slave table with a lower matching degree may be selected from the business table candidate pool according to the matching degree with the ledger information, or at least two business tables may be selected from the business table candidate pool according to the priority of the business tables in the business table candidate pool, which is not limited in this embodiment of the present invention.
S150, acquiring the associated information of the at least two business forms.
Wherein the associated information at least comprises: inner association and left association.
Specifically, the association information may be an association type, and the association types of the at least two service forms are obtained, for example, the association types of the at least two service forms may be intra-association.
And S160, merging the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
Specifically, the ledger is generated according to the target business table, for example, if the target business table is a single business table, the single business table is taken as the ledger; and if the target business form is at least two business forms, generating a standing book according to the at least two business forms and the association information between the at least two business forms.
The embodiment of the invention can adapt to the account requirements in the work of the security department under the current financial situation, greatly reduces the repeated development pressure of the software department while ensuring the normalization and the effectiveness of the account, and improves the realization efficiency of the account requirements. Its advantages are as follows: the configuration and generation method fully explores the self-use number capability of business departments, and solves the pain point that account accounts are complex in demand and repeated development is carried out by a software development department with large input of manpower; the configuration and generation method solves the problem that the standing book development period is long, the front-end and back-end codes can be put into production only through version change, and the pain points are in contradiction with short and quick working and multi-phase supervision requirements of a security department, realizes the WYSIWYG type standing book generation through simple configuration and Excel import, and can use data and access data in real time and flexibly according to business requirements.
According to the technical scheme of the embodiment, the core field is obtained; determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables; acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage; selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information; acquiring the associated information of the at least two business tables; and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book, so that the standing book can be quickly and effectively established according to user configuration.
Example two
Fig. 2A is a flowchart of a ledger generation method in a second embodiment of the present invention, which is optimized based on the above embodiment, and in this embodiment, the method further includes: combining the at least two business forms according to the at least two business forms and the associated information of the at least two business forms to obtain the standing book comprises: if the association information of the at least two business forms is internal association, acquiring the same core fields in the at least two business forms, and combining the same core fields in the at least two business forms to obtain a machine account; and if the association information of the at least two business tables is left association, combining the at least two business tables to obtain the machine account.
As shown in fig. 2A, the method of this embodiment specifically includes the following steps:
s210, acquiring a core field.
S220, determining a service table candidate pool according to the core field, wherein the service table candidate pool comprises at least two service tables.
S230, obtaining standing book information, wherein the standing book information comprises: a ledger name, a ledger classification, and ledger usage.
S240, selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information;
s250, acquiring the associated information of the at least two business forms.
S260, combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain a machine account.
S250, acquiring the associated information of the at least two business forms.
The association information may be internal association or left association.
And S260, if the correlation information of the at least two business forms is internal correlation, acquiring the same core fields in the at least two business forms, and combining the same core fields in the at least two business forms to obtain the ledger.
Specifically, if the association information is an internal association, the same core fields in the at least two business forms are obtained, and the contents corresponding to the same core fields in the at least two business forms are combined to obtain the ledger, that is, the intersection of the at least two business forms is taken.
And S270, if the association information of the at least two business forms is left association, combining the at least two business forms to obtain the machine account.
Specifically, if the association information is left association, the at least two business forms are directly merged to obtain the ledger, that is, a union set of the at least two business forms is obtained.
Optionally, the obtaining the ledger information includes:
when the click operation of a user on a drop-down box in an area corresponding to a query condition in a standing book generation interface is detected, displaying field information corresponding to the drop-down box;
and when the touch operation of the user on the field information corresponding to the drop-down box is detected, acquiring the field information as the standing book information.
Optionally, determining the service form candidate pool according to the core field includes:
pre-establishing a database for storing at least one business table aiming at poor assets users;
and selecting at least one service form from the database according to the core field, and determining the at least one service form as a service form candidate pool.
In a specific example, as shown in fig. 2B, in the operation practice of the banking security business, the required ledger mainly includes three parts: query conditions, query results and statistical results. The embodiment of the invention describes a bad asset standing book generating method configured by a user, and the realization method mainly comprises the following steps: configuring basic information of the machine account; configuring the display content of the standing book; configuring a standing book association condition; configuring a standing book filtering condition; configuring standing book statistical information; and previewing the generated content of the standing book.
And (3) metadata configuration: because the applied physical model of the bad asset usually contains a technical data table (such as a source system original table and an intermediate data accumulation table) and a technical physical field (such as a data loading operation time batch), and is not suitable for the stage of the bad asset account book, a system administrator screens out a service interface table (such as a customer information table, a contract table, an account balance table, a repayment flow water meter, a plan scheme table and the like) and a core field (such as a paying institution, a customer manager name, a customer number, a customer name, a contract number, an account number, a local balance, overdue time, loan classification, a loan period and the like) suitable for the configuration of the bad asset account book for business personnel through a metadata configuration function.
The embodiment of the invention supports the currently-passing Oracle and MySQL databases of banking institutions, and acquires all user tables and field information including field types and Chinese names of bad asset application users or corresponding modes from the databases. Two table trees are displayed on the interface, and the left side is the information of the enabled tables and fields in the system and is initialized to be empty; and the right side is the table and field information which is not added into the candidate pool, and the table and field information is initialized to be the full table and field information of the application user. The system administrator removes or adds fields and corresponding tables to the candidate pool by dragging nodes between the two table trees.
Generating a data table filter: based on the metadata configuration, the data table added to the left tree in the metadata configuration is shown to the user in the form of a drop-down box.
Basic information configuration of the machine account: the service personnel names the standing book through a standing book basic information configuration interface, sets the classified name of the menu (such as personal, company and checked asset), controls whether the standing book is started or not and describes the service use of the standing book. In addition, the service personnel also need to select a core service table for the standing book through a data table filter, and the core service table is used as a data query dimension of the standing book, namely a data query statement main table of the standing book; for part of simpler standing book data requirements, the data in the main table can be satisfied. For example, for an undesirable asset client class ledger, the undesirable asset client table is typically selected as the master table, i.e., the data in the ledger is in the customer dimension, with each record representing a customer. The system automatically generates a unique identifier for each ledger.
And (3) configuration of the standing book associated information: for more complex bad asset account requirements, such as bad asset account balance account, the header of the account table needs to display the information of bad customer name, customer number, contract type, contract risk classification, account deposit date, account overdue start date, account interest and penalty profit balance, etc. which are respectively from the bad asset customer information table, the bad asset contract risk rating table, the bad asset contract account table and the bad asset repayment flow meter, at this time, the bad asset contract account is used as a main table, and other dimensions associated with the account are acquired: customer information, contracts, contract classifications, etc. Therefore, after the master table is selected in the standing book basic information configuration, the slave table and the association type (internal association or left association) to be associated need to be selected in the standing book association information configuration, and the slave table is also from the data table filter. And repeating the steps, wherein the standing book association information can be recorded into a plurality of slave tables.
Generating a data field filter: based on the metadata configuration, a union of the data fields added into the left-side tree in the metadata configuration and the full-scale fields of the master table and the slave table added into the association between the data fields and the tables is displayed for the user in a drop-down box form.
A generate data field processor: performing function processing on the selected data field, wherein the function type is divided into a character string function, a numerical function, a date function and an aggregation function, for example, the 7 th to 14 th bits in the character string are taken from the identity card number of the client of the natural person with the poor asset to obtain the birth date of the client; the aggregation function supports solving of a maximum value, a minimum value, a median, a summation, an average value, a variance, a count and the like, and is suitable for a configuration scene of the standing book statistical result.
Configuring association conditions among tables: if one to more than one table association relation is defined in association information configuration, the association condition between tables needs to be configured. The correlation condition consists of a left field, a right field and an operation symbol: selecting left and right fields from a data field filter; through the data field processor, the left field and the right field both support the comparison after the function calculation processing is carried out on the original field. The left and right fields also support constant entry, e.g., the right field is compared to the left field using the string "19870101" to screen out bad customers with a birth date earlier than 87 years. The operation symbol supports the combination of the size being not equal to the equal size, and also supports the combination of 'in.. and' out.. to support the comparison of dictionary types, such as the verification and sale standing book of the small and tiny fast loan, whether the loan contract type is in the following dictionary values, namely 'personal credit fast loan', 'small and tiny enterprise loan', 'personal APP on-line loan', and the like, needs to be judged, so that the bad asset contract with the contract type being the small and tiny fast loan is screened out. In an inter-table association relationship, a plurality of inter-table association conditions may exist. And supports adjusting and combining the association conditions by brackets and/or operators.
And (3) configuring standing book query conditions: in actual business, business personnel need to screen and sort the ledger data according to specific conditions. The system defaults to support screening based on the main form data mechanism, namely, a primary row, a secondary row or a business mechanism to be inquired is selected on the standing book interface. The system also supports business personnel to customize query conditions of the standing book, such as customer names, loan account numbers, loan types, balance and the like, in a standing book query condition configuration interface, condition contents input by a standing book user on the interface are added one by one, the condition name and the type (value, text, date and drop-down frame) of a numerical value input by the user are defined, a source table field which is compared with the user input field is selected through a data field filter, and a table field comparison mode with the query condition input by the user is set on the basis, such as balance is less than the maximum value input by the user, and balance is greater than the minimum value input by the user; and the loan currency is the currency input by the user.
And (3) configuration of a standing book query result: the system supports business personnel to directly import the drawn header in an Excel table mode, supports a user to draw the multi-level header in a merging cell mode, and finally resolves the header configuration through a third-party function library such as POI. The header configuration should include: each initial column cell (X row, Y column) occupies a plurality of cells (X in transverse direction and Y in longitudinal direction), column name and header should meet the requirement that all rows do not have empty cells and duplicate cells. And all columns in the last row of the header are used as ledger display columns for establishing mapping with the source data in the next step. If the header imported by the user is valid, the user configures a data source for each standing book display field in the next step, namely, the source field is selected through the data field filter, and the source field is processed through the data field processor. For example, for the "customer manager" field in the last column of the header, the manager field of the bad asset contract receipt form is selected as the data source. Thus, the accountant field for each ledger record will be displayed under the "customer manager" field of the header. The data source also supports the display of derived fields among a plurality of fields through brackets and four operations of addition, subtraction, multiplication and division, for example, the sum of principal balance, interest balance, profit balance and penalty balance of the bad asset contract account table is displayed for the 'balance sum' field of the header.
And (3) account accounting statistical result configuration: the invention supports the configuration of statistical types by business personnel besides the detailed inquiry of conventional customer-by-customer, contract and account by a machine account user, such as displaying the total data of bad principal balance sum, stroke sum, handling amount sum, verification and sale sum and the like of bank credit users, average data of average handling period, average home-entry collection number and the like of bad customers, and entering the extreme data of earliest bad time, maximum handling amount, maximum balance and the like. Specifically, service personnel firstly need to configure grouping fields through a field filter, then newly add target statistical fields one by one to name the fields, and customize source field processing rules through a data field filter and a data field processor.
And (3) standing book display: the account user finds the account link to be accessed through the navigation page and the menu to which the account belongs, and the link contains the unique mark of the account. The system sequentially obtains the query condition configuration, the query result configuration and the statistical result configuration of the standing book according to the unique standing book mark, and dynamically renders and generates a query condition area, a query result header and a statistical result area field name in the page by adopting a JavaScript technology.
And (3) submitting standing book query: after the user inputs the query conditions, the system dynamically assembles the detailed data paging query statement and the standing account statistical result information query statement of the standing account by adopting Java according to the query condition configuration, the basic information configuration (main table) of the standing account, the associated information configuration of the standing account, the query condition configuration of the standing account and the statistical result configuration information of the standing account, respectively queries to obtain results, and fills the data records in the standing account query result area and the field value in the statistical result area. The user can click to turn pages or jump to a specified number of pages.
And (3) result data derivation: and when the query result is not empty, the user can click the export button, the system executes the query statement again, fills the data into the Excel form header template imported by the user, and pops up a download box to prompt the user to save. For queries with a result set exceeding ten thousand, the system takes ten thousand as query units, merges the query results of multiple times into a zip file and prompts a user.
The preservation department is used as an operation management department of the bad assets, urgent and strict requirements are placed on bad asset ledgers, and the contents of the ledgers are aimed to be visual, easy to use and real. Based on the above, the following bad asset ledger generation method based on user configuration is established, so that the security department can independently and quickly establish various bad asset ledgers, and pain points that the ledgers are various in types, consume a large amount of manpower and material resources due to low-level repeated development and require quick access of supervision are solved. In the traditional bad asset standing account method, a business lead person of a security department puts forward a requirement, and a software development department analyzes the requirement and draws an interface prototype to reach requirement understanding consistency with business personnel. On the basis, a background developer develops corresponding data storage layer scripts, a foreground developer develops application end service and interfaces, and finally performs application assembly test and user test. The development method obviously needs more cooperation of participants and cannot meet the requirements of mass, agility and rapid production of bad asset accounts. In order to meet the requirement for agile development of the bad asset ledger, the embodiment of the invention realizes the bad asset ledger generation method based on user configuration by using JavaScript and Java language around the characteristics of the bad asset ledger. The method takes the user configuration as the core, extracts the core common points of various ledgers of the bad assets, gives full play to the creativity of business personnel of a demand side, supports the security department to independently use data, and reduces the repeated development work of a software development department.
According to the technical scheme of the embodiment, the core field is obtained; determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables; acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage; selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information; acquiring the associated information of the at least two business tables; if the association information of the at least two business forms is internal association, acquiring the same core fields in the at least two business forms, and combining the same core fields in the at least two business forms to obtain a machine account; and if the association information of the at least two business forms is left association, combining the at least two business forms to obtain the standing book, and quickly and effectively establishing the standing book according to user configuration.
EXAMPLE III
Fig. 3 is a schematic structural diagram of an account book generating apparatus according to a third embodiment of the present invention. The embodiment is applicable to the case of generating the standing book, the apparatus may be implemented in a software and/or hardware manner, and the apparatus may be integrated in any device providing a function of generating the standing book, as shown in fig. 3, where the standing book generating apparatus specifically includes: a first obtaining module 310, a determining module 320, a second obtaining module 330, a selecting module 340, a third obtaining module 350, and a combining module 360.
The first obtaining module is used for obtaining the core field;
the determining module is used for determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
a second obtaining module, configured to obtain standing book information, where the standing book information includes: at least one of ledger name, ledger classification, and ledger usage;
the selecting module is used for selecting at least two business tables from the business table candidate pool as target business tables according to the standing book information;
a third obtaining module, configured to obtain association information of the at least two service tables;
and the merging module is used for merging the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
Optionally, the merging module is specifically configured to:
if the association information of the at least two business forms is internal association, acquiring the same core fields in the at least two business forms, and combining the same core fields in the at least two business forms to obtain a machine account;
and if the association information of the at least two business tables is left association, combining the at least two business tables to obtain the machine account.
The product can execute the method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
According to the technical scheme of the embodiment, the core field is obtained; determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables; acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage; selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information; acquiring the associated information of the at least two business tables; and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book, so that the standing book can be quickly and effectively established according to user configuration.
Example four
Fig. 4 is a schematic structural diagram of a computer device in the fourth embodiment of the present invention. FIG. 4 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 4 is only one example and should not bring any limitations to the functionality or scope of use of embodiments of the present invention.
As shown in FIG. 4, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.
The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)30 and/or cache memory 32. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, and commonly referred to as a "hard drive"). Although not shown in FIG. 4, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.
The processing unit 16 executes various functional applications and data processing by running a program stored in the system memory 28, for example, to implement the ledger generation method provided by the embodiment of the present invention: acquiring a core field;
determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage;
selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information;
acquiring the associated information of the at least two business tables;
and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
EXAMPLE five
An embodiment five of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a ledger generation method according to any embodiment of the present invention: acquiring a core field;
determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage;
selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information;
acquiring the associated information of the at least two business tables;
and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A standing book generating method is characterized by comprising the following steps:
acquiring a core field;
determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
acquiring the standing book information, wherein the standing book information comprises: at least one of ledger name, ledger classification, and ledger usage;
selecting at least two business forms from the business form candidate pool as target business forms according to the standing book information;
acquiring the associated information of the at least two business tables;
and combining the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
2. The method of claim 1, wherein the core field comprises: at least one of a loan institution, a customer manager name, a customer number, a customer name, a contract number, an account number, an intrinsic balance, an expiration time, a loan classification, and a loan period.
3. The method of claim 1, wherein the traffic table candidate pool comprises: at least one of a customer information table, a contract table, an account balance table, a repayment flow table and a plan scheme table, wherein each business table is at least two.
4. The method of claim 1, wherein merging the at least two business forms to obtain a ledger according to the at least two business forms and the association information of the at least two business forms comprises:
if the association information of the at least two business forms is internal association, acquiring the same core fields in the at least two business forms, and combining the same core fields in the at least two business forms to obtain a machine account;
and if the association information of the at least two business tables is left association, combining the at least two business tables to obtain the machine account.
5. The method of claim 1, wherein obtaining ledger information comprises:
when the click operation of a user on a drop-down box in an area corresponding to a query condition in a standing book generation interface is detected, displaying field information corresponding to the drop-down box;
and when the touch operation of the user on the field information corresponding to the drop-down box is detected, acquiring the field information as the standing book information.
6. The method of claim 1, wherein determining a candidate pool of business forms based on the core field comprises:
pre-establishing a database for storing at least one business table aiming at poor assets users;
and selecting at least one service form from the database according to the core field, and determining the at least one service form as a service form candidate pool.
7. An ledger generation apparatus characterized by comprising:
the first acquisition module is used for acquiring the core field;
the determining module is used for determining a business table candidate pool according to the core field, wherein the business table candidate pool comprises at least two business tables;
a second obtaining module, configured to obtain standing book information, where the standing book information includes: at least one of ledger name, ledger classification, and ledger usage;
the selecting module is used for selecting at least two business tables from the business table candidate pool as target business tables according to the standing book information;
a third obtaining module, configured to obtain association information of the at least two service tables;
and the merging module is used for merging the at least two business tables according to the at least two business tables and the associated information of the at least two business tables to obtain the standing book.
8. The apparatus of claim 7, wherein the merging module is specifically configured to:
if the association information of the at least two business forms is internal association, acquiring the same core fields in the at least two business forms, and combining the same core fields in the at least two business forms to obtain a machine account;
and if the association information of the at least two business tables is left association, combining the at least two business tables to obtain the machine account.
9. A computer device 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 method according to any of claims 1-6 when executing the program.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010463666.6A CN111639910A (en) | 2020-05-27 | 2020-05-27 | Standing book generation method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010463666.6A CN111639910A (en) | 2020-05-27 | 2020-05-27 | Standing book generation method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111639910A true CN111639910A (en) | 2020-09-08 |
Family
ID=72331095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010463666.6A Pending CN111639910A (en) | 2020-05-27 | 2020-05-27 | Standing book generation method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111639910A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112364609A (en) * | 2020-10-27 | 2021-02-12 | 远光软件股份有限公司 | Business standing book generation method and device, storage medium and electronic equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140143126A1 (en) * | 2012-11-21 | 2014-05-22 | Shaheen Malik | Loan Analysis And Management System |
| CN107193842A (en) * | 2016-03-15 | 2017-09-22 | 阿里巴巴集团控股有限公司 | A kind of hardware and software platform system business localization method and device |
| CN107506442A (en) * | 2017-08-24 | 2017-12-22 | 中国银行股份有限公司 | The modeling method and device of a kind of model |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer equipment and storage medium |
| CN110046153A (en) * | 2018-11-19 | 2019-07-23 | 阿里巴巴集团控股有限公司 | A kind of method, device and equipment of account fund verification |
| CN110674163A (en) * | 2019-08-26 | 2020-01-10 | 天津浪淘科技股份有限公司 | Heterogeneous data query system and method based on BS framework |
-
2020
- 2020-05-27 CN CN202010463666.6A patent/CN111639910A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140143126A1 (en) * | 2012-11-21 | 2014-05-22 | Shaheen Malik | Loan Analysis And Management System |
| CN107193842A (en) * | 2016-03-15 | 2017-09-22 | 阿里巴巴集团控股有限公司 | A kind of hardware and software platform system business localization method and device |
| CN107506442A (en) * | 2017-08-24 | 2017-12-22 | 中国银行股份有限公司 | The modeling method and device of a kind of model |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer equipment and storage medium |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN110046153A (en) * | 2018-11-19 | 2019-07-23 | 阿里巴巴集团控股有限公司 | A kind of method, device and equipment of account fund verification |
| CN110674163A (en) * | 2019-08-26 | 2020-01-10 | 天津浪淘科技股份有限公司 | Heterogeneous data query system and method based on BS framework |
Non-Patent Citations (2)
| Title |
|---|
| 叶文辉: "互联网平台背景下不良资产处置模式创新研究", 《农村金融研究》, no. 11 * |
| 戚敏: "数字信息资源检索方法与实践 理工版", 华中科技大学出版社, pages: 284 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112364609A (en) * | 2020-10-27 | 2021-02-12 | 远光软件股份有限公司 | Business standing book generation method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11681694B2 (en) | Systems and methods for grouping and enriching data items accessed from one or more databases for presentation in a user interface | |
| CA3040101C (en) | Method and system for searching for and navigating to user content and other user experience pages in a financial management system with a customer self-service system for the financial management system | |
| CN111402061A (en) | Asset management method and system | |
| CN112508694B (en) | Method and device for processing resource limit application by server and electronic equipment | |
| US20210182906A1 (en) | Method and system for predicting relevant offerings for users of data management systems using machine learning processes | |
| US20150379591A1 (en) | Method, System, And Software For Generating Performance Metrics Of Charity Effectiveness | |
| CN111062799A (en) | Method and device for managing family client, electronic equipment and storage medium | |
| Navdeep et al. | Role of big data analytics in analyzing e-Governance projects | |
| CN113034046A (en) | Data risk metering method and device, electronic equipment and storage medium | |
| CN111708897A (en) | Target information determination method, device and equipment | |
| CN112102006A (en) | Target customer acquisition method, target customer search method and target customer search device based on big data analysis | |
| KR101927578B1 (en) | System for providing enterprise information and method | |
| US11620665B2 (en) | Methods and systems using and constructing merchant communities based on financial transaction data | |
| CN111639910A (en) | Standing book generation method, device, equipment and storage medium | |
| CN117033431A (en) | Work order processing method, device, electronic equipment and medium | |
| CN112348658A (en) | Resource allocation method and device and electronic equipment | |
| US20230088044A1 (en) | End-to-end prospecting platform utilizing natural language processing to reverse engineer client lists | |
| KR20200054533A (en) | system for providing financial product recommendation service including diagnosing financial tendency | |
| US20170148098A1 (en) | Data creating, sourcing, and agregating real estate tool | |
| CN114707091A (en) | Page display method and device, electronic equipment and storage medium | |
| Pattnaik et al. | Microfinance: A bibliometric exploration of the knowledge landscape | |
| CN111415138A (en) | Creative processing method and system, client and server | |
| CN117609263A (en) | Data processing method and device | |
| Obasa | Effect of Information and Communication Technology on the Financial Performance of Money Deposit Banks in Nigeria | |
| CN117056341A (en) | Construction method and system of financial asset database |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220920 Address after: 25 Financial Street, Xicheng District, Beijing 100033 Applicant after: CHINA CONSTRUCTION BANK Corp. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |