CN101916422A - Multi-dimensional performance evaluation system and method for banks - Google Patents
Multi-dimensional performance evaluation system and method for banks Download PDFInfo
- Publication number
- CN101916422A CN101916422A CN2010102722822A CN201010272282A CN101916422A CN 101916422 A CN101916422 A CN 101916422A CN 2010102722822 A CN2010102722822 A CN 2010102722822A CN 201010272282 A CN201010272282 A CN 201010272282A CN 101916422 A CN101916422 A CN 101916422A
- Authority
- CN
- China
- Prior art keywords
- data
- branch
- bank
- module
- rule
- 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
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a multi-dimensional performance evaluation system and a multi-dimensional performance evaluation method for banks. The system comprises a head office multi-dimensional performance evaluation system, a branch bank multi-dimensional performance evaluation system and a system for multi-dimensionally evaluating the performance of a head office and a branch bank at the same time, wherein the head office multi-dimensional performance evaluation system comprises a data preprocessing module, a performance evaluation module, a report data generation module and a front-end display module; the data preprocessing module is used for mapping and transforming external data from an origin system; the performance evaluation module is used for evaluating the performance according to general ledger data and client account information-containing account grade data in the mapped and transformed external data; the report data generation module is used for processing the data acquired after the performance evaluation and generating report data; and the front-end display module is used for displaying the report data. By preprocessing the client account information-containing data, evaluating the performance, generating the report data and displaying the report data, the multi-dimensional performance evaluation system realizes the multi-dimensional performance evaluation of clients, products, mechanisms and the like at the same time, and can meet flexible financial management requirements.
Description
Technical field
The present invention relates to the bank finance management domain, more specifically, relate to head office of a kind of bank, branch's various dimensions performance appraisal system and method and a kind of system that head office of bank and branch are carried out the various dimensions performance appraisal of being used for simultaneously.
Background technology
Propelling along with the operation of bank transition and strategic transformation customer-centric, the various operational and managerial activities of bank have all proposed new requirement to financial management work, for example, need analyze etc. the business circumstance of all kinds of operation main bodys and great client's contribution degree.Therefore, in the keen competition environment, no matter be nationwide large bank or regional middle pet bank, all than more needed bank's various dimensions Performance Evaluation System effectively and reasonably to formulate the profitability of bank's target, assessing mechanism product and customer relationship in the past, thereby monitor that whether strategic decision is by the realization of success, further establishment and control budget, reduction risk make the enterprise value maximization.
Existing bank Performance Evaluation System is a basic calculation with the financial accounting general ledger, but, because the data granularity of financial accounting general ledger is thicker, and do not comprise any customer account information, therefore, existing Performance Evaluation System can only be calculated on mechanism's dimension or product dimension, can't carry out performance appraisal from client's dimension.In order to realize the degree of depth support of financial management, need a kind of system that can on a plurality of dimensions such as client, product, mechanism, carry out bank's performance appraisal simultaneously to banking activity.
Summary of the invention
The objective of the invention is to: a kind of various dimensions performance appraisal system and method that is used for bank is provided, realizes on a plurality of dimensions such as client, product, mechanism, estimating simultaneously bank's performance, for the business decision of bank provides important evidence.
On the one hand, the invention provides various dimensions performance appraisal system of head office of a kind of bank, this system comprises:
Data preprocessing module, be used for according to mapping ruler the external data from origin system being shone upon conversion, wherein, described external data comprises that general ledger data, account levels data, dimension data, first decompose the reason data, wherein, described account levels data comprise customer account information;
The performance appraisal module is used for carrying out performance analysis according to general ledger data and account levels data after the described mapping conversion;
The report data generation module is used for processing according to the data that demand obtains after to described performance analysis that gather of report form index, generates report data;
The front end display module is used for showing described report data according to the form standard.
On the other hand, the invention provides various dimensions performance appraisal system of a kind of branch bank, this system comprises:
Branch's data preprocessing module, be used for profitability data, traffic data and time point balance data from various dimensions performance appraisal system of head office of bank and origin system being shone upon conversion respectively, generate profitability data of the customer manager of branch account levels and the customer manager of branch account levels traffic data according to mapping ruler;
The professional figureofmerit computing module of branch is used for according to the portfolio report form index the described customer manager of branch account levels traffic data being processed, and generates portfolio report form index data;
Branch's profitability index computing module is used for according to profitability report form index the profitability data of the described customer manager of branch account levels being processed, and generates profitability report form index data;
Branch's report form showing module is used for showing described portfolio report form index data and profitability report form index data according to branch's form demand and form standard.
Another aspect the invention provides a kind of system that head office of bank and branch are carried out the various dimensions performance appraisal of being used for simultaneously, and this system comprises various dimensions performance appraisal system of head office of described bank and various dimensions performance appraisal system of described branch bank.
On the one hand, the invention provides head office of a kind of bank various dimensions performance appraisal method again, this method comprises:
According to mapping ruler the external data from origin system is shone upon conversion, wherein, described external data comprises that general ledger data, account levels data, the dimension data, first of head office decompose the reason data, and wherein, described account levels data comprise customer account information;
Carry out performance analysis according to general ledger data and account levels data after the described mapping conversion;
The data that demand obtains after to described performance analysis that gather according to report form index are processed, and generate report data;
Show described report data according to the form standard.
Another aspect the invention provides a kind of branch bank various dimensions performance appraisal method, and this method comprises:
According to mapping ruler profitability data, traffic data and time point balance data from various dimensions performance appraisal system of head office of bank and origin system are shone upon conversion respectively, generate profitability data of the customer manager of branch account levels and the customer manager of branch account levels traffic data;
According to the portfolio report form index the described customer manager of branch account levels traffic data is processed, generated portfolio report form index data;
According to profitability report form index the profitability data of the described customer manager of branch account levels are processed, generate profitability report form index data;
Show described portfolio report form index data and profitability report form index data according to branch's form demand and form standard.
Implement a kind of various dimensions performance appraisal system and method that is used for bank of the present invention and have following beneficial effect: by to the general ledger data of the information that comprises dimensions such as product and mechanism with comprise the mapping conversion of the account levels data of customer account information, carry out performance analysis according to the data after the mapping conversion, the data that obtain after the performance analysis are processed, generated report data and show described report data, make described system and method on a plurality of dimensions such as client, product, mechanism, to carry out bank's performance appraisal simultaneously.
Description of drawings
Fig. 1 is the embodiment 1 of various dimensions performance appraisal system of head office of bank of the present invention 1.
Fig. 2 is the embodiment of the performance appraisal module 12 in the embodiments of the invention 1.
Fig. 3 is the embodiment 2 of various dimensions performance appraisal system of head office of bank of the present invention 1.
Fig. 4 is the embodiment 1 of various dimensions performance appraisal system of branch bank of the present invention 2.
Fig. 5 is the embodiment 2 of various dimensions performance appraisal system of branch bank of the present invention 2.
Fig. 6 is the embodiment that is used for simultaneously head office of bank and branch being carried out the system of various dimensions performance appraisal of the present invention.
Fig. 7 is the process flow diagram of head office of bank of the present invention various dimensions performance appraisal method.
Fig. 8 is the process flow diagram of step S11 in head office of the bank of the present invention various dimensions performance appraisal method.
Fig. 9 is the process flow diagram of branch bank of the present invention various dimensions performance appraisal method.
Embodiment
For the purpose, technical scheme and the advantage that make embodiments of the invention is clearer, further combined with drawings and Examples the present invention is described in detail below.
Fig. 1 is the embodiment 1 of various dimensions performance appraisal system of head office of bank of the present invention 1.As shown in Figure 1, head office of bank various dimensions performance appraisal system 1 comprises data preprocessing module 10, performance appraisal module 12, report data generation module 14 and front end display module 16.To being described in detail as follows of these modules:
Report data generation module 14 is used for processing according to the data that demand obtains after to described performance analysis that gather of report form index, generates report data.
Wherein, the form of described report form index comprises basic index and the index of deriving, this index of deriving is to calculate on the basis of described basic index, the content of described report form index comprises portfolio index and profitability index, for example, the portfolio index comprises: indexs such as deposit time point remaining sum, the average daily remaining sum of providing a loan, debt time point remaining sum and the average daily remaining sum of assets, profitability index comprises: interest revenue and expenditure, the inner indexs such as revenue and expenditure, the loss of non-credit Write-downs and gross income rate that shift.Described to data process the cleaning that comprises data, gather, renewal etc.The report data of described generation can comprise: portfolio form, bar line service scale, great client table, profitability monthly magazine on the five, share form and some other form.The definition of described report form index can be finished according to actual conditions by the user, it gathers demand and can be provided with according to the demand of different dimensions by the user, for example, great client's table gathers according to dimensions such as client, mechanism and products, and bar line service scale gathers according to mechanism and bar line dimension.In the present embodiment, be example with the portfolio daily paper, the described treatment scheme that report data was processed, generated to the data that obtain after the performance analysis comprises: the pre-service of portfolio daily paper report data; Refresh dimension data; Generate operation mainstream amount report data; Generate the detailed rank report data of client traffic; Generate bar line, the detailed rank report data of product portfolio.Report data generation module 14 generates report data according to user's demand, for the user provides support to the flexible adjustment of evaluative dimension.
Front end display module 16 is used for showing described report data according to the form standard.Wherein, described form standard is provided with in advance according to the actual requirements by the user, and this form standard can comprise: interface norm, for example font, color, alignment, digital format etc.; Naming conventions, for example data source, FM Project file (file of being created by the metadata modeling instrument Framework Manager assembly among report making and the demonstration tool COGNOS), MDL/MDC file (two kinds of files that generate by modeling tool) and Report (form) etc.Show report data by front end display module 16, the user can be checked these report datas and analyze intuitively, and then the performance of head office of bank is estimated.
Need to prove, in another embodiment of the invention, data preprocessing module 10 also be used for described according to mapping ruler to before shining upon conversion from the external data of origin system, reception is carried out integrity checking according to this control documents and the metadata that sets in advance in various dimensions performance appraisal system of head office of bank 1 to the external data from origin system from the control documents of described origin system.Particularly, data preprocessing module 10 checks according to described control documents and metadata whether the record number of described external data and file layout be qualified, when checking when qualified, data preprocessing module 10 is proceeded the mapping conversion, in the present embodiment, described " checking to qualified " comprises following two kinds of situations: the record number of external data and file layout are in full accord with control documents and metadata respectively, and rank not quite identical but that make mistakes only is warning level (the concrete standard of this warning level can be provided with according to actual conditions by the user); When checking when defective, various dimensions performance appraisal system of head office of bank 1 temporarily interrupts, and after the user makes amendment to corresponding underproof data according to actual conditions, the processing that this system 1 continues operation and shone upon conversion by data preprocessing module 10, in the present embodiment, described " checking to defective " comprises following two kinds of situations: the record number of external data and file layout are inconsistent fully with control documents and metadata respectively, and rank not quite identical but that make mistakes is absolute rank (other concrete standard of this absolute level can be provided with according to actual conditions by the user).In a kind of example, described user makes amendment and can comprise corresponding underproof data according to actual conditions: makeing mistakes when data is to be caused by the corresponding information disappearance of certain product in product dimension table, then increases corresponding information in this product dimension table; Makeing mistakes when data is to be caused by the mapping relations disappearance of certain product in product and bar line mapping table, then increases corresponding mapping relations in this product and bar line mapping table.Wherein, described control documents is used for describing the quantity of described external data, and described metadata is used for describing the form of described external data.For example, the record number that this control documents can write down relevant loan in the described external data has 150000, this metadata can be described described external data and comprise how many fields, and the type of each field is character, numeral or date, the implication of each field and codomain scope etc.Described metadata can be set in advance in various dimensions performance appraisal system of head office of bank 1 according to actual conditions by the user.By integrity checking can the assurance system in the correctness of data.
In addition, in another embodiment, described data preprocessing module 10 after mapping conversion with data load in the database of described system 1, performance appraisal module 12 is to extract data to handle and will handle data load afterwards in this database from described database when analyzing, the data that obtain after the performance analysis in 14 pairs of described databases of report data generation module are handled and the report data that generates are loaded in the report database of system 1, and front end display module 16 extracts report data from this report database shows.
In another embodiment of the invention, various dimensions performance appraisal system of head office of bank 1 also can comprise master data maintenance module (not shown), this master data maintenance module is used to the user that the function that is provided with that gathers demand to described mapping ruler, report form index and report form index is provided, and when dimension changes, for the user provides the maintenance function that gathers corresponding master data in demand and the system 1 to described mapping ruler, report form index, report form index.Wherein, described maintenance function comprises increase, deletion or the modification to data in the described database.By the master data maintenance module, the user can correspondingly be safeguarded the data in the various dimensions performance appraisal system of head office of bank 1 according to the demand of the evaluative dimension of reality, guarantee the accuracy of various dimensions performance appraisal, also adapted to flexible and changeable bank finance management expectancy simultaneously.
Below in conjunction with Fig. 2 the performance appraisal module 12 in the embodiments of the invention 1 is elaborated.As shown in Figure 2, performance appraisal module 12 comprises revenue sharing submodule 120, cost apportionments submodule 121, profitability calculating sub module 122 and manages main body income fractionation submodule 123.To being described in detail as follows of these submodules:
Particularly, revenue sharing submodule 120 is done revenue sharing according to the revenue sharing rule that sets in advance to interest income, intermediary service income and some other income of each customer account and is handled between different payoff profile object (for example mechanism), wherein, described revenue sharing rule can be provided with according to the actual demand of different dimensions by the user.For example, the revenue sharing of bar line dimension is meant managing between the bar line income is split, wherein, described income of managing between the bar line can occur between this product of managing bar line common service or operation, also can occur between corporate business and the institution business bar line, between corporate business and the international business bar line, between institution business and the international business bar line etc.In the present embodiment, for example, product " individual short message service business " ratio with 5% and 95% between bar line " house finance and personal credit " and bar line " personal finance (Wealth management and private bank) " is divided into.
Particularly, cost apportionments submodule 121 is made in dimensions such as client, bar line, products according to the first decomposition reason data and is originally shared processing.For example,, share operation control type responsibility center to detail according to responsibility center to the workload of bar line and manage the bar line, obtain general ledger sheet operation control type responsibility center detail and manage bar line expense for general ledger sheet operation control type responsibility center expense; For the noncommercial centre type assets of non-site class expense, share all assets expenses of the noncommercial centre type of non-site class to all bar lines according to responsibility center to the workload of bar line, obtain each bar line assets expense of the noncommercial centre type of the non-site of general ledger sheet class.Wherein, described first decomposes the reason data comprises the statistics of the class of concluding the business or the statistics that resource consumes class, and for example the account trading stroke count closes table, account screening transaction stroke count closes table, giving credit stroke count statistical form, international card account number and hair fastener and counts statistical form etc.
Profitability calculating sub module 122 is used for according to the data computation report form index after 121 processing of cost apportionments submodule.Wherein, described report form index is identical with the description to report form index in report data generation module 14.Described accounting report index had both comprised adding, take advantage of, subtract, removing and bracket operation etc. between the data tabular in the data after cost apportionments submodule 121 handled, also comprised adding, take advantage of, subtract, removing and bracket operation etc. between the tables of data row.Below profitability calculation process is lifted two examples: (1) be new visitor table _ discount, interbank discount (time point) for report form index, is that 30104 product gathers according to dimensions such as client, operation main body, mechanism, bar lines with product coding according to the definition of this report form index then; (2) for report form index new visitor table _ generality deposit (time point), then the balance of debt field with all products gathers according to dimensions such as client, operation main body, mechanism, bar lines, also will deduct structural deposit, long-term dormant deposit and sub loan fund class deposit etc.
Manage the main body income and split submodule 123, be used between accounting type site and operation center, carrying out data and split and trim according to the data that income fractionation rule calculates profitability calculating sub module 122.Wherein, manage main body and comprise two parts in accounting type site and operation center, accounting type site mainly comprises head office, one-level branch, secondary branch, adjusts main body row etc., and the operation center is meant that all kinds of specializations concentrate the operation center, is defined as responsibility center in ERPF.Described income splits the rule expression and carries out the ratio that data split, and this ratio is to be decided by actual conditions, and how following mask body determines the fractionation ratio for two example explanations:
(1) income to non-group customer splits between bank's accounting type site and the operation center
Head office of bank determines the ratio that the accounting type site of account levels splits to the operation center, and branches at different levels regularly split to the operation center according to the ratio that splits all account achievement datas with accounting type site.
(2) income to group customer between accounting type site and the operation center splits
If split to as if the group customer portion account of being managed, then needed for two steps determined concrete fractionation ratio.The first step is determined the fractionation ratio of account between group customer portion and each one-level branch to the group customer of being managed by group customer portion.For the fractionation ratio that group customer portion safeguards, each one-level branch can inquire about but can not revise.Second step, the one-level branch of site, above-mentioned account place ownership can be according to service needed, according to group customer portion (first step) first split result to group customer, by one-level unified in lines safeguard the account in one-level branch accounting type site and the fractionation ratio between the operation center.
For clarity sake, the main body income splits and two examples of process act of trim are illustrated to managing below:
(1) there are two secondarys to manage main body b and c in lines under the operation main body A of certain one-level bank, if assert that a certain professional income is is 6: 4 by the ratio that b and c contribute simultaneously and contribute, but owing to should the business income all remember at present under the operation main body A, can the ratio that this business is taken in according to 60% and 40% be broken to b and c so, simultaneously to 100% negative business income of one of A record, so should business gross income in the scope of managing main body A with split before keep balance;
(2) certain one-level bank manages under the main body A has two secondarys to manage main body b and c in lines, if assert that a certain professional income is is 6: 4 by the ratio that b and c contribute simultaneously and contribute, but owing to should the business income all remember at present under the operation main body b, will give c 40% partition of this business income so, the process of trim is 40% business income to be charged to manage under the main body c, give to manage 40% negative business income of one of main body b record, so should business gross income in A manages the main body scope with split before keep balance.
In addition, in another embodiment, it all is to extract corresponding data to handle from database that described revenue sharing submodule 120, cost apportionments submodule 121, profitability calculating sub module 122 and operation main body income split submodule 123, and the data load after will handling supplies other module or submodule to handle in this database.
More than be detailed description, elaborate the embodiment 2 of various dimensions performance appraisal system of head office of bank 1 below in conjunction with Fig. 3 the embodiment 1 of various dimensions performance appraisal system of head office of bank of the present invention 1.
Fig. 3 is the embodiment 2 of various dimensions performance appraisal system of head office of bank of the present invention 1.As shown in Figure 3, in the present embodiment, various dimensions performance appraisal system 1 of head office of bank comprises that also decomposing parameter work station module 11, data adjusting module 13, total points checks module 15 and master data maintenance module 17 except comprising module mentioned above.To being described in detail as follows of these modules:
The embodiment that data preprocessing module 10 in the present embodiment, the revenue sharing submodule 120 in the performance appraisal module 12, profitability calculating sub module 122, operation main body income split submodule 123 and report data generation module 14, front end display module 16 is identical with the description in the embodiment 1 of various dimensions performance appraisal system of head office of bank 1, therefore repeats no more.
Decompose parameter work station module 11, be used for data preprocessing module 10 shine upon the conversion after and the cost apportionments submodule 121 of performance appraisal module 12 make originally share processing before, decompose the reason data to first and gather and/or weighted calculation, obtain second and decompose the reason data.For example,, can be weighted calculating according to 7: 3 ratio, draw the second decomposition reason data according to giving credit stroke count and newly-increased credit assets remaining sum for the cost apportionments of management bar line from the responsibility center to the credit; Cost apportionments for from credit management bar line to product bar line can be weighted calculating according to assets average and 7: 3 ratio of newly-increased credit assets remaining sum, draws second and decomposes the reason data.
Cost apportionments submodule 121 in the performance appraisal module 12 is used for second decomposing data after the reason data are handled revenue sharing submodule 120 and making and originally share processing according to what decompose that parameter work station module 11 provides in present embodiment 2.Particularly, cost apportionments submodule 121 is made in client, bar line, product dimension according to the described second decomposition reason data and is originally shared processing.Wherein, described second decomposes the reason data comprises the statistics of the class of concluding the business or the statistics that resource consumes class, for example, the account trading stroke count closes table, account screening transaction stroke count closes table, giving credit stroke count statistical form, international card account number and hair fastener and counts statistical form etc.
In addition, decomposing parameter work station module 11 also is used for providing the function of decomposing examination, modification and the amended record of reason data to second to the user.Decompose parameter work station module 11 and decompose the reason data more accurately, improved the accuracy of performance analysis for cost apportionments submodule 121 provides.
After data preprocessing module 10 is shone upon conversion and cost apportionments submodule 121 make originally share processing before for the user provides the function of first data adjustment, and/or
Cost apportionments submodule 121 make originally share handle after and the function of second data adjustment was provided for the user before profitability calculating sub module 122 accounting report indexs, and/or
After profitability calculating sub module 122 accounting report indexs and managing the main body income, split the function that submodule 123 provides the 3rd data to adjust for the user before taking in fractionation.
Wherein, the first data adjustment comprises site type cost, non-site type cost is assigned to specific cost objective, for example, some costs be at some clients, then before cost apportionments, this cost is assigned to this client.Similarly, if a certain cost is at a certain line, then before cost apportionments, this cost is assigned to this line; The second data adjustment comprise after described cost apportionments handled share that variance data is examined, amended record, modification, particularly, if after cost apportionments, it is unreasonable to examine some absorption of costs, then can more reasonably this cost be assigned on its apportioned object, thus amended record, the modification of realization to sharing variance data; The 3rd data adjustment comprise to the variance data after the described accounting report index examine, amended record, modification.
By data adjusting module 13, not only can carry out amended record to bank's intermediary service data, can also improve the accuracy of data in the various dimensions performance appraisal system 1 of bank.
Total points is checked module 15, be used for checking rule respectively to data pretreatment module 10 according to the total points that sets in advance, revenue sharing submodule 120 in data adjusting module 13 and the performance appraisal module 12, cost apportionments submodule 121, profitability calculating sub module 122, data after operation main body income fractionation submodule 123 is handled are carried out total points and are checked, when the described total points of the data fit of being checked is checked rule, do not process, when the data of being checked do not meet described total points and check rule, this is not met total points check the data of rule and carry out trim, and generate virtual account.Wherein, described total points is checked rule and can be comprised that the account levels data should equate with the general ledger data by the data that index, subject and mechanism gather.For clarity sake, below to described do not meet total points check the rule situation specifically be illustrated for two examples:
(1) supposes in the general ledger data, managing main body is 0100000000, and index is 401602, and subject is 11000000, the client is A, the amount of money is 100 yuan, and in the account levels data, managing main body is 0100000000, index is 401602, subject is 11000000, and the client is A, and the amount of money is 90 yuan, because 100 yuan of the general ledger data with the account levels data 90 yuan are unequal, the account levels data have been lacked 10 yuan, then need to generate a virtual account, that is: managing main body is 0100000000, index is 401602, subject is 11000000, and the record amount of money be 10 yuan, guarantee the consistance of account levels data and general ledger data with this;
(2) suppose in the general ledger data, managing main body is 0100000000, and index is 401602, and subject is 11000000, the client is A, the amount of money is 90 yuan, and in the account levels data, managing main body is 0100000000, index is 401602, subject is 11000000, and the client is A, and the amount of money is 100 yuan, because 90 yuan of the general ledger data with the account levels data 100 yuan are unequal, the account levels data have more 10 yuan, then need to generate a virtual account, that is: managing main body is 0100000000, index is 401602, subject is 11000000, and the record amount of money is negative 10 yuan, thereby has guaranteed the consistance of account levels data and general ledger data.
Need to prove which link the user can also be provided with according to actual conditions is carried out total points and check, perhaps which link is not carried out total points and is checked.For example, in another embodiment, if not needing to carry out total points after the data adjustment checks, then the user can not set in advance to do not carry out total points after the data adjusting module is handled and check, and then system only carries out total points to data and checks after the needs that the user is provided with carry out module that total points checks or submodule processing.
Check module 15 by total points, guaranteed the consistance of account levels data and general ledger data, also improved the correctness of each module and submodule deal with data in the various dimensions performance appraisal system of bank 1.
In the present embodiment, master data maintenance module 17 in the various dimensions performance appraisal system of head office of bank 1 is used to the user that the function that is provided with that demand and total points are checked rule that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index is provided, and when dimension changes, provide the maintenance function that demand and total points are checked corresponding master data in rule and the system 1 that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index for the user.In one embodiment, the various rules that are provided with by master data maintenance module 17 are loaded in the database of system 1, need use these regular corresponding modules or submodule and obtain in this database in operational process.Similar ground, the various rules of safeguarding by master data maintenance module 17 also are loaded in the described database, take for corresponding module or submodule.
Particularly, the described dimension increase, deletion or the modification that change and comprise data in certain dimension.For example, in a kind of example, increased certain product newly, then need in the product dimension table, the related data of this product have been safeguarded into, needed simultaneously the hierarchical relationship of the related the superior and the subordinate's product of this product is safeguarded.Be appreciated that because variation has taken place the product dimension gather demand and the total points that the related mapping ruler of this dimension variation, revenue sharing rule, report form index, income are split rule, report form index checked the variation of rule and also needed to be serviced so.Wherein, described maintenance function comprises when dimension changes the data in the database is made corresponding increase, deletion or modification.
In addition, in another embodiment, data adjusting module 13, total points check module 15 and master data maintenance module 17 also can be handled the data load after handling in database for other module or submodule.
In other embodiments of the present invention, various dimensions performance appraisal system of head office of bank 1 also can comprise task scheduling modules, system management module and data purge module (not shown in the accompanying drawing).To being described in detail as follows of these modules:
Task scheduling modules is used to each module and submodule in the various dimensions performance management system of head office of bank 1 that execution order is set.Particularly, this task scheduling modules can realize by the CONTRAL-M dispatching platform.In this embodiment, task scheduling modules can be dispatched at following job stream: daily paper batch processing time window and batch processing job stream, monthly magazine batch processing time window and batch processing job stream, batch processing abnormality processing job stream, how daily paper batch processing and monthly magazine batch processing avoid interference job stream and other job streams.This task scheduling modules provides guarantee for the true(-)running of total system 1.
System management module is used to the user that monitoring to the setting of the rights of using of various dimensions performance management system of head office of bank 1, the inquiry of running log (comprising that backstage batch processing job, user operate audits and compliance daily record, system exception or fault log etc.) and running status is provided.Wherein, described monitoring to running status can be should be unusually when unusual or fault occurring by note or mail in system or signalling trouble to the user.By system management module, the user can check the operation conditions of each module in the total system 1 or submodule, and then provides in time when makeing mistakes in system 1 and handle, and also for the user provides foundation to the maintenance of system 1, has guaranteed the normal operation of system 1.
The data purge module is used for according to the data scrubbing rule that sets in advance the historical data that various dimensions performance management system of head office of bank 1 generates being cleared up.Wherein, described historical data comprises temporary file, pilot process file, history lists and other stale datas etc. that produce in various dimensions performance appraisal system of head office of bank 1 operational process in database and the report database.Described data scrubbing rule can be by the user according to the actual conditions setting, can comprise the information such as type, cycle, object of data scrubbing, for example: monthly the financial instrument table of last month is filed in the corresponding history lists; It is medium by the cycle of operation interface document to be loaded into the corresponding interface table.The user clears up the historical data in the system 1 in time by the data purge module, makes described database that sufficient free space be arranged, thus the speed and the correctness of 1 operation of assurance system.
In another embodiment of the present invention, various dimensions performance appraisal system of head office of bank 1 also can comprise initial data conversion module, be used for the data that various dimensions performance appraisal system of head office of bank 1 comes into operation the previous year are carried out conversion, and generate corresponding form, thereby solve some problems that run into when initial data after various dimensions performance appraisal system of head office of bank 1 comes into operation generate, comprise problem and some other problem of data difference problem, normal load.Wherein, the problem of described normal load for example: when initial data generated, some table as mechanism's table needed full dose to load, and mechanism's table of the routine after coming into operation for system only needs every day that the mechanism that changes is increased into.
Below in conjunction with Fig. 4 and Fig. 5 various dimensions performance appraisal system of branch bank of the present invention 2 is described in detail.
Fig. 4 is the embodiment 1 of various dimensions performance appraisal system of branch bank of the present invention 2.As shown in Figure 4, branch bank's various dimensions performance appraisal system 2 comprises branch's data preprocessing module 20, the professional figureofmerit computing module 22 of branch, branch's profitability index computing module 24 and branch's report form showing module 26.To being described in detail as follows of these modules:
Branch's data preprocessing module 20, be used for profitability data, traffic data and time point balance data from various dimensions performance appraisal system of head office of bank and origin system being shone upon conversion respectively, generate profitability data of the customer manager of branch account levels and the customer manager of branch account levels traffic data according to mapping ruler.Wherein, described origin system comprises DW and ERPF, described profitability data comprise from various dimensions performance appraisal system of head office of bank to the profitability data of public account and from DW to the profitability data of private account, described traffic data comprise from the service for corporate customers amount data of DW and to private traffic data and from ERPF to public account time point balance data with to private account time point balance data.Described mapping conversion comprises extraction, conversion and loads.In the present embodiment, can adopt DataStage to realize the mapping conversion of data.Described profitability data of the generation customer manager of branch account levels and the customer manager of branch account levels traffic data are particularly, be associated with the account mapping relations with the customer manager of branch to the profitability data of public affairs with to the profitability data of private described, gather the back and generate the profitability data of the customer manager of branch account levels, similarly, with described service for corporate customers amount data, to private traffic data, be associated with the account relation mapping table with the customer manager of branch to public account time point balance data with to private account time point balance data, gather the back and generate the customer manager of branch account levels traffic data.
The professional figureofmerit computing module 22 of branch is used for according to the portfolio report form index the described customer manager of branch account levels traffic data being processed, and generates portfolio report form index data.Wherein, the form of described portfolio report form index comprises portfolio basic index and the portfolio index of deriving, and this portfolio index of deriving is to calculate on the basis of described portfolio basic index.For example calculate time deposit index of the same trade or business, then according to this portfolio basic index definition, the data that will have product mark and be 20302 time deposits of the same trade or business and 20303 deposits at notice of the same trade or business gather according to mechanism, Currency Type, customer manager, generate time deposit achievement data of the same trade or business.For example calculate the banker's deposit index again, after then finishing according to portfolio basic index definition calculating, according to the portfolio index definition of deriving, demand deposit index of the same trade or business and time deposit index of the same trade or business are gathered according to mechanism, Currency Type, customer manager, generate the banker's deposit achievement data.Definition to the portfolio report form index can be finished according to actual conditions by the user.
Branch's profitability index computing module 24 is used for according to profitability report form index the profitability data of the described customer manager of branch account levels being processed, and generates profitability report form index data.Wherein, the form of described profitability report form index comprises profitability basic index and the profitability index of deriving, and this profitability index of deriving is to calculate on the basis of described profitability basic index.For example, can directly obtain profitability report form index data according to profitability basic index and " customer manager get a profit summary sheet " field mappings table, shift income as branch's basic index 42002004 internal finances and can shift the income mapping and obtain from " customer manager get a profit summary sheet " field FTP_INTEREST_YR internal finance.For example calculate the index 42002006 inner net interest income/expenditures of deriving again,, internal finance is shifted the income index deduct internal finance transfer expenditure target, obtain inner net interest income/expenditure target data then according to the index definition of deriving.Definition to profitability report form index can be finished according to actual conditions by the user.
Branch's report form showing module 26 is used for showing described portfolio report form index data and profitability report form index data according to branch's form demand and form standard.Wherein, described form standard is provided with in advance according to the actual requirements by the user, and for example, this form standard can comprise: interface norm, for example font, color, alignment, digital format etc.; Naming conventions, for example data source, FM Project file, MDL/MDC file and Report etc.Described branch form demand can be provided with according to actual needs by the user.Show the report form index data by branch's report form showing module 26, the user can be checked these report form index data and analyze intuitively, and then the performance of branch bank is estimated.
In addition, in another embodiment, described branch data preprocessing module 20 after mapping conversion with data load in branch's Data Mart of described system 2, the professional figureofmerit computing module 22 of branch and branch's profitability index computing module 24 extract data respectively and process from this branch's Data Mart, and respectively with the portfolio report form index data that generate and profitability report form index data load in branch's Data Mart, branch's report form showing module 26 extracts described portfolio report form index data from branch's Data Mart and profitability report form index data are showed.
The embodiment 2 of various dimensions performance appraisal system of branch bank of the present invention 2 as shown in Figure 5, as can be seen from Figure 5, various dimensions performance appraisal system of branch bank 2 comprises that also total points is checked module 21 and branch's master data maintenance module 23 in lines except comprising branch's data preprocessing module 20, the professional figureofmerit computing module 22 of branch, branch's profitability index computing module 24 and branch's report form showing module 26.To being described in detail as follows of these modules:
The embodiment of branch's data preprocessing module 20, the professional figureofmerit computing module 22 of branch, branch's profitability index computing module 24 and branch report form showing module 26 is with identical to the description of the embodiment 1 of various dimensions performance appraisal system of branch bank 2 in conjunction with Fig. 4, so repeats no more.
Branch's total points is checked module 21, being used for checking the data of rule after respectively branch's data preprocessing module 20, the professional figureofmerit computing module 22 of branch and branch's profitability index computing module 24 being handled according to branch's total points of setting in advance carries out total points and checks, when the described branch of the data fit of being checked total points is checked rule, do not process, when the data of being checked do not meet described branch total points and check rule, this is not met branch's total points check the data of rule and carry out trim, and generate branch's virtual account.Wherein, described branch total points is checked rule can comprise that the account levels data should equate with the general ledger data (these general ledger data are loaded in the described branch Data Mart) among the ERPF by the data that index, subject and mechanism gather after the 20 mapping conversion of branch's data preprocessing module.Do not meet the situation that branch's total points is checked rule for described, its concrete embodiment is identical with the corresponding description of total points being checked module 15 in conjunction with Fig. 3, so repeats no more.
Check availability and the reliability that module 21 can improve data in the various dimensions performance appraisal system 2 of branch bank by branch's total points.
In the present embodiment, branch's master data maintenance module 23 in the various dimensions performance appraisal system of branch bank 2, be used to the user that the function that is provided with of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule is provided, and when dimension changes, provide the maintenance function of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule for the user.Particularly, the described dimension increase, deletion or the modification that change and comprise data in certain dimension.Wherein, described maintenance function promptly comprises increase, deletion or the modification to data in the described branch Data Mart.
By branch's master data maintenance module 23,, guaranteed the accuracy of various dimensions performance appraisal even making that dimension changes in various dimensions performance appraisal system 2 of branch bank also can carry out data maintenance in time.
In addition, in another embodiment, described branch total points is checked module 21 and branch's master data maintenance module 23 can be with the resume module for other in the described branch Data Mart of the data load after handling.
In another embodiment of the present invention, various dimensions performance appraisal system of branch bank 2 also can comprise branch's system management module and branch's data purge module (not shown).Wherein,
Branch's system management module is used to the user that the setting to the rights of using of various dimensions performance appraisal system of branch bank 2, the inquiry of running log and the monitoring of running status are provided.Wherein, described monitoring to running status can be should be unusually when unusual or fault occurring by note or mail in system or signalling trouble to the user.By system management module, the user can check the operation conditions of each module in the total system 1, and then provides in time when makeing mistakes in system 2 and handle, and also for the user provides foundation to the maintenance of system 2, has guaranteed the normal operation of system 2.
Branch's data purge module is used for according to the branch's data scrubbing rule that sets in advance the historical data that various dimensions performance management system of branch bank 2 generates being cleared up.Wherein, described data scrubbing rule can be by the user according to the actual conditions setting.Described historical data comprises temporary file, pilot process file, history lists and other stale datas etc. that produce in various dimensions performance appraisal system of branch bank 2 operational processs in the described branch Data Mart.The user clears up the historical data in the system 2 in time by the data purge module, has guaranteed the speed and the correctness of system's 2 operations.
Fig. 6 is the embodiment that is used for simultaneously head office of bank and branch being carried out the system of various dimensions performance appraisal of the present invention.As shown in Figure 6, described system comprises various dimensions performance appraisal system of head office of bank 1 and various dimensions performance appraisal system of branch bank 2.Wherein, the embodiment of various dimensions performance appraisal system of head office of bank 1 and various dimensions performance appraisal system of branch bank 2 is described identical with preamble, therefore repeats no more.
By the described system that head office of bank and branch are carried out the various dimensions performance appraisal of being used for simultaneously, can carry out performance appraisal to head office of bank and branch from a plurality of dimensions simultaneously, for the business decision of bank provides important evidence.
Above be detailed description, elaborate the embodiment of method of the present invention below in conjunction with Fig. 7, Fig. 8 and Fig. 9 system of the present invention.
Fig. 7 is the process flow diagram of head office of bank of the present invention various dimensions performance appraisal method.As shown in Figure 7, head office of bank various dimensions performance appraisal method comprises the steps:
S10 shines upon conversion according to mapping ruler to the external data from origin system, and described external data comprises the general ledger data, comprises the account levels data of customer account information, first decompose the reason data.About the detailed content of these data and origin system and mapping conversion with above identical to the description of data pretreatment module 10 in conjunction with Fig. 1, so repeat no more.
S11 carries out performance analysis according to general ledger data and account levels data after the described mapping conversion.The back can be described in detail S11 in conjunction with Fig. 8.
S12 processes according to the data that demand obtains after to described performance analysis that gather of report form index, generates report data.Wherein, about the detailed content that gathers demand of report form index and report form index with identical to the description of report data generation module 14 in conjunction with Fig. 1, therefore repeat no more.
S13 shows report data in the described database according to the form standard.Wherein, about the detailed content of form standard with identical to the description of front end display module 16 in conjunction with Fig. 1, therefore repeat no more.
Need to prove, in another embodiment of the invention, before S10, head office of described bank various dimensions performance appraisal method also comprises the control documents of reception from described origin system, according to this control documents and the metadata that sets in advance the external data from origin system is carried out integrity checking, when passed examination, proceed the mapping conversion, when inspection is defective, after making amendment to underproof data according to actual conditions, the user proceeds to shine upon the processing of conversion.Therefore the embodiment of this step repeats no more with identical to the description of data pretreatment module 10 in conjunction with Fig. 1.
Elaborate the S11 in head office of the described bank various dimensions performance appraisal method below.As shown in Figure 8, S11 comprises the steps:
S110 does the revenue sharing processing according to the revenue sharing rule that sets in advance to the general ledger data and the account levels data of shining upon after changing between different payoff profile objects.Therefore the detailed content of the embodiment of this step and revenue sharing rule repeats no more with identical to the description of revenue sharing submodule 120 in conjunction with Fig. 2.
S111 decomposes data after the reason data are handled revenue sharing according to described first and makes and originally share processing.Therefore the embodiment of this step and first detailed content of decomposing the reason data repeat no more with identical to the description of cost apportionments submodule 121 in conjunction with Fig. 2.
S112 is according to the described report form index of data computation after the cost apportionments processing.Therefore the embodiment of this step and the detailed content of report form index repeat no more with identical to the description of profitability calculating sub module 122 in conjunction with Fig. 2.
S113 splits the regular data that profitability is calculated according to income and carry out data fractionation and trim between accounting type site and operation center.The embodiment of this step and income split the detailed content of rule with identical to the description that operation main body income splits submodule 123 in conjunction with Fig. 2, therefore repeat no more.
In another embodiment of the invention, the data after S111 can also handle revenue sharing according to the second decomposition reason data are made and are originally shared processing.In this embodiment, head office of described bank various dimensions performance appraisal method also comprises: according to mapping ruler to after shining upon conversion from the external data of origin system, and before the data after according to the second decomposition reason data revenue sharing being handled are made and are originally shared processing, decomposing the reason data to first gathers and/or weighted calculation, obtain second and decompose the reason data, therefore its concrete embodiment repeats no more with identical to the description of decomposing parameter work station module 11 in conjunction with Fig. 3.
In another embodiment of the present invention, head office of described bank various dimensions performance appraisal method also is included in after the described mapping conversion and before described cost apportionments is handled, the function of first data adjustment is provided for the user, and/or after described cost apportionments is handled and before described accounting report index, the function of second data adjustment is provided for the user, and/or after described accounting report index and before described data split, provide the function of the 3rd data adjustment for the user.
Particularly, the first data adjustment comprises site type cost, non-site type cost is assigned to specific cost objective, for example, some costs be at some clients, then before cost apportionments, this cost is assigned to this client.Similarly, if a certain cost is at a certain line, then before cost apportionments, this cost is assigned to this line; The second data adjustment comprise after described cost apportionments handled share that variance data is examined, amended record, modification, particularly, if after cost apportionments, it is unreasonable to examine some absorption of costs, then can more reasonably this cost be assigned on its apportioned object, thereby realize described amended record, modification of sharing variance data; The 3rd data adjustment comprise to the variance data after the described accounting report index examine, amended record, modification.
In another embodiment of the present invention, head office of described bank various dimensions performance appraisal method also comprise according to the total points that sets in advance check rule respectively to after the described mapping conversion, after the data adjustment, after the revenue sharing, after the cost apportionments, after the accounting report index and the data of data after splitting carry out total points and check, when the described total points of the data fit of being checked is checked rule, do not process, when the data of being checked do not meet described total points and check rule, this is not met total points check the data of rule and carry out trim, and generate virtual account.The detailed content that the embodiment of this step and total points are checked rule is identical with the description of total points being checked module 15 in conjunction with Fig. 3, so repeats no more.
In addition, in another embodiment of the invention, head office of described bank various dimensions performance appraisal method also can comprise:
The function that is provided with that demand and total points are checked rule that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index is provided for the user, and when dimension changes, provide the maintenance function that demand and total points are checked rule and corresponding master data that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index for the user.
In another embodiment, head office of described bank various dimensions performance appraisal method also can comprise:
For the user provides the setting to the rights of using of described method, the inquiry of running log and the monitoring of running status.With
Clear up according to the historical data that generates in the operational process of data scrubbing rule that sets in advance described method.
More than the embodiment of two steps with identical to the description of master data maintenance module 17, system management module and data purge module in conjunction with Fig. 3, therefore repeat no more.
The process flow diagram of branch bank of the present invention various dimensions performance appraisal method as shown in Figure 9, as can be seen from Figure 9, branch bank's various dimensions performance appraisal method comprises the steps:
S20, according to mapping ruler profitability data, traffic data and time point balance data from various dimensions performance appraisal system of head office of bank and origin system are shone upon conversion respectively, generate profitability data of the customer manager of branch account levels and the customer manager of branch account levels traffic data.Therefore the embodiment of this step repeats no more with identical to the description of branch's data preprocessing module 20 in conjunction with Fig. 4.
S21 processes the described customer manager of branch account levels traffic data according to the portfolio report form index, generates portfolio report form index data.
S22 processes the profitability data of the described customer manager of branch account levels according to profitability report form index, generates profitability report form index data.
S23 shows described portfolio report form index data and profitability report form index data according to branch's form demand and form standard.Therefore the detailed content of described form standard repeats no more with identical to the description of branch's report form showing module 26 in conjunction with Fig. 4.
In process flow diagram shown in Figure 9, the embodiment of S21 and S22 with identical to the description of the professional figureofmerit computing module 22 of branch and branch's profitability index computing module 24 in conjunction with Fig. 4, therefore repeats no more respectively.Here need to prove, for branch bank's various dimensions performance appraisal method, the customer manager of branch account levels traffic data processed generate portfolio report form index data and do not have absolute ordinal relation with the profitability data of the customer manager of branch account levels are processed between the profitability report form index data of generation.In embodiment shown in Figure 9, be to carry out S21 earlier to generate portfolio report form index data, carry out S22 again and generate profitability report form index data, and in other embodiment, also can generate profitability report form index data earlier, regeneration portfolio report form index data just have not been elaborated here in conjunction with the accompanying drawings.
In another embodiment of the invention, described branch bank various dimensions performance appraisal method also comprises:
Checking rule according to the branch's total points that sets in advance carries out total points to the data after processing after processing after the described mapping conversion, to the customer manager of branch account levels traffic data, to the profitability data of the customer manager of branch account levels and checks, when the described branch of the data fit of being checked total points is checked rule, do not process, when the data of being checked do not meet described branch total points and check rule, this is not met branch's total points check the data of rule and carry out trim, and generate branch's virtual account.The detailed content that the embodiment of this step and described branch total points are checked rule is identical with the description of branch's total points being checked module 21 in conjunction with Fig. 5, so repeats no more.
In another embodiment of the present invention, described branch bank various dimensions performance appraisal method also comprises:
The function that is provided with of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule is provided for the user, and when dimension changes, provide the maintenance function of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule and corresponding master data for the user.Therefore concrete embodiment repeats no more with identical to the description of branch's master data maintenance module 23 in conjunction with Fig. 5.
In addition, in another embodiment, described branch bank various dimensions performance appraisal method also can comprise:
For the user provides the setting to the rights of using of described method, the inquiry of running log and the monitoring of running status.With
Clear up according to the historical data that generates in the operational process of branch's data scrubbing rule that sets in advance described method.
In sum, implement a kind of various dimensions performance appraisal system and method that is used for bank of the present invention, by to comprising product, the information of dimensions such as mechanism and the external data of customer account information are shone upon conversion, carry out performance analysis according to the data after the mapping conversion, the data that obtain after the performance analysis are processed, generate report data and show described report data, with general ledger data and the data basis that comprises the account levels data construct various dimensions performance appraisal system of customer account information, realize simultaneously the client, product, carry out performance appraisal on a plurality of dimensions such as mechanism, can help to formulate bank's target, assessing mechanism, the profitability of product and customer relationship, thus monitor whether strategic decision successfully realizes.By implementing the present invention, bank can obtain the performance appraisal result fast as required, for bank's business decision provides important evidence, in addition, can also solve the big counting yield problem of personal account data volume, bank's loans and deposits real account can't objectively respond the problem of intermediary service income, and change and problem that the bank performance appraisal computation rule that causes changes when evaluative dimension, make the efficient of performance appraisal improve greatly, and can adapt to flexible and changeable financial management requirement, make the enterprise value maximization.
Through the above description of the embodiments, those skilled in the art can be well understood to the present invention and can realize by the mode of software combined with hardware platform, can certainly all implement by hardware.Based on such understanding, all or part of can the embodying that technical scheme of the present invention contributes to background technology with the form of software product, this computer software product can be stored in the storage medium, as ROM/RAM, magnetic disc, CD etc., comprise that some instructions are with so that a computer equipment (can be a personal computer, server, the perhaps network equipment etc.) carry out the described method of some part of each embodiment of the present invention or embodiment.
More than disclosed only be the specific embodiment of the present invention; only be used for the present invention is illustrated; can not limit the present invention's protection domain with this; those skilled in the art can carry out various modifications, variation or replacement under the prerequisite that does not break away from essence of the present invention; therefore; according to the various equivalent variations that the present invention did, still belong to the scope that the present invention is contained.
Claims (29)
1. a various dimensions performance appraisal system of head office of bank is characterized in that, various dimensions performance appraisal system of head office of described bank comprises:
Data preprocessing module is used for according to mapping ruler the external data from origin system being shone upon conversion, and described external data comprises general ledger data, account levels data, the first decomposition reason data, and wherein, described account levels data comprise customer account information;
The performance appraisal module is used for carrying out performance analysis according to general ledger data and account levels data after the described mapping conversion;
The report data generation module is used for processing according to the data that demand obtains after to described performance analysis that gather of report form index, generates report data;
The front end display module is used for showing described report data according to the form standard.
2. various dimensions performance appraisal system of head office of bank according to claim 1 is characterized in that described data preprocessing module also is used for:
Described according to mapping ruler to before carrying out Mapping and Converting from the external data of origin system; Reception is from the control documents of described origin system; According to described control documents and the metadata that sets in advance in head office of described bank various dimensions Performance Evaluation System described external data from origin system is carried out integrity checking; When passed examination; Proceed Mapping and Converting; When inspection is defective; After making amendment to underproof data according to actual conditions, the user proceeded the processing of Mapping and Converting by described data preprocessing module
Wherein, described control documents is used for describing the quantity of described external data, and described metadata is used for describing the form of described external data.
3. various dimensions performance appraisal system of head office of bank according to claim 1 is characterized in that, described performance appraisal module comprises:
The revenue sharing submodule is used for doing revenue sharing handle between different payoff profile objects according to the revenue sharing rule that sets in advance general ledger data and the account levels data after to described mapping conversion;
The cost apportionments submodule is used for decomposing data after the reason data are handled described revenue sharing submodule according to described first and makes and originally share processing;
Profitability calculating sub module is used for according to the described report form index of data computation after the described cost apportionments submodule processing;
Manage the main body income and split submodule, be used between accounting type site and operation center, carrying out data and split and trim according to the data that income fractionation rule calculates described profitability calculating sub module.
4. various dimensions performance appraisal system of head office of bank according to claim 3 is characterized in that, various dimensions performance appraisal system of head office of described bank also comprises:
Decompose the parameter work station module, be used for described data preprocessing module shine upon the conversion after and described cost apportionments submodule make originally share processing before, decompose the reason data to described first and gather and/or weighted calculation, obtain second and decompose the reason data.
5. various dimensions performance appraisal system of head office of bank according to claim 4 is characterized in that,
Described cost apportionments submodule also is used for decomposing data after the reason data are handled described revenue sharing submodule according to described second and makes and originally share processing.
6. according to claim 3 or various dimensions performance appraisal system of 5 head offices of described bank, it is characterized in that various dimensions performance appraisal system of head office of described bank also comprises:
The data adjusting module is used to be achieved as follows function:
After described data preprocessing module is shone upon conversion and described cost apportionments submodule make originally share processing before for the user provides the function of first data adjustment, and/or
Described cost apportionments submodule make originally share handle after and the function of second data adjustment was provided for the user before described profitability calculating sub module accounting report index, and/or
After described profitability calculating sub module accounting report index and in described operation main body income, split the function that submodule provides the 3rd data to adjust for the user before taking in fractionation.
7. various dimensions performance appraisal system of head office of bank according to claim 6 is characterized in that,
The described first data adjustment comprises site type cost, non-site type cost is assigned to specific cost objective,
The described second data adjustment comprise after described cost apportionments handled share that variance data is examined, amended record, modification,
Described the 3rd data adjustment comprise to the variance data after the described accounting report index examine, amended record, modification.
8. system according to claim 6 is characterized in that, various dimensions performance management system of head office of described bank also comprises:
Total points is checked module, be used for according to the total points that sets in advance check rule respectively to revenue sharing submodule, cost apportionments submodule, the profitability calculating sub module of described data preprocessing module, data adjusting module and performance appraisal module, manage the main body income and split the data of submodule after handling and carry out total points and check
When the described total points of the data fit of being checked is checked rule, do not process,
When the data of being checked do not meet described total points and check rule, this is not met total points check the data of rule and carry out trim, and generate virtual account.
9. system according to claim 8 is characterized in that, various dimensions performance management system of head office of described bank also comprises:
The master data maintenance module, be used to the user that the function that is provided with that demand and total points are checked rule that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index is provided, and when dimension changes, provide the maintenance function that demand and total points are checked rule that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index for the user.
10. system according to claim 1 is characterized in that, various dimensions performance management system of head office of described bank also comprises:
Task scheduling modules is used to each module and submodule in the various dimensions performance management system of head office of described bank that execution order is set;
System management module is used to the user to provide the setting of the rights of using of various dimensions performance management system of head office of described bank, the inquiry of running log and the monitoring of running status;
The data purge module is used for according to the data scrubbing rule that sets in advance the historical data that various dimensions performance management system of head office of described bank generates being cleared up.
11. a various dimensions performance appraisal system of branch bank is characterized in that, various dimensions performance appraisal system of described branch bank comprises:
Branch's data preprocessing module, be used for profitability data, traffic data and time point balance data from various dimensions performance appraisal system of head office of bank and origin system being shone upon conversion respectively, generate profitability data of the customer manager of branch account levels and the customer manager of branch account levels traffic data according to mapping ruler;
The professional figureofmerit computing module of branch is used for according to the portfolio report form index the described customer manager of branch account levels traffic data being processed, and generates portfolio report form index data;
Branch's profitability index computing module is used for according to profitability report form index the profitability data of the described customer manager of branch account levels being processed, and generates profitability report form index data;
Branch's report form showing module is used for showing described portfolio report form index data and profitability report form index data according to branch's form demand and form standard.
12. various dimensions performance appraisal system of branch bank according to claim 11 is characterized in that, various dimensions performance appraisal system of described branch bank also comprises:
Branch's total points is checked module, and be used for checking the data of rule after respectively described branch data preprocessing module, the professional figureofmerit computing module of branch and branch's profitability index computing module being handled and carry out total points and check according to branch's total points of setting in advance,
When the described branch of the data fit of being checked total points is checked rule, do not process,
When the data of being checked do not meet described branch total points and check rule, this is not met branch's total points check the data of rule and carry out trim, and generate branch's virtual account.
13. various dimensions performance appraisal system of branch bank according to claim 12 is characterized in that, various dimensions performance appraisal system of described branch bank also comprises:
Branch's master data maintenance module, be used to the user that the function that is provided with of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule is provided, and when dimension changes, provide the maintenance function of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule for the user.
14. various dimensions performance appraisal system of branch bank according to claim 11 is characterized in that, various dimensions performance appraisal system of described branch bank also comprises:
Branch's system management module is used to the user to provide the setting of the rights of using of various dimensions performance appraisal system of described branch, the inquiry of running log and the monitoring of running status;
Branch's data purge module is used for according to the branch's data scrubbing rule that sets in advance the historical data that various dimensions performance management system of described branch generates being cleared up.
15. one kind is used for simultaneously to head office of bank and the system that carries out the various dimensions performance appraisal in lines, it is characterized in that, described system comprises as any various dimensions performance appraisal system of head office of described bank in the claim 1 to 10 with as any various dimensions performance appraisal system of described branch bank in the claim 11 to 14
Wherein, various dimensions performance appraisal system of head office of described bank is used for head office of bank is carried out the various dimensions performance appraisal, and various dimensions performance appraisal system of described branch bank is used for branch bank is carried out the various dimensions performance appraisal.
16. head office of a bank various dimensions performance appraisal method is characterized in that described method comprises:
According to mapping ruler the external data from origin system is shone upon conversion, wherein, described external data comprises that general ledger data, account levels data, dimension data, first decompose the reason data, and wherein, described account levels data comprise customer account information;
Carry out performance analysis according to general ledger data and account levels data after the described mapping conversion;
The data that demand obtains after to described performance analysis that gather according to report form index are processed, and generate report data;
Show described report data according to the form standard.
17. method according to claim 16 is characterized in that, described according to mapping ruler to before shining upon conversion from the external data of origin system, described method also comprises:
Reception is from the control documents of described origin system, according to described control documents and the metadata that sets in advance described external data from origin system is carried out integrity checking, when passed examination, proceed the mapping conversion, when inspection is defective, after making amendment to underproof data according to actual conditions, the user proceeds to shine upon the processing of conversion
Wherein, described control documents is used for describing the quantity of described external data, and described metadata is used for describing the form of described external data.
18. method according to claim 16 is characterized in that, describedly carries out performance analysis according to the general ledger data after the mapping conversion and account levels data and comprises:
Between different payoff profile objects, do revenue sharing and handle according to the general ledger data and the account levels data of the revenue sharing rule that sets in advance after described mapping conversion;
Decomposing data after the reason data are handled described revenue sharing according to described first makes and originally shares processing;
According to the described report form index of data computation after the described cost apportionments processing;
Split the regular data that described profitability is calculated according to income and between accounting type site and operation center, carry out data fractionation and trim.
19. method according to claim 16 is characterized in that, describedly carries out performance analysis according to the general ledger data after the mapping conversion and account levels data and comprises:
Between different payoff profile objects, do revenue sharing and handle according to the general ledger data and the account levels data of the revenue sharing rule that sets in advance after described mapping conversion;
Decomposing data after the reason data are handled described revenue sharing according to second makes and originally shares processing;
According to the described report form index of data computation after the described cost apportionments processing;
Split the regular data that described profitability is calculated according to income and between accounting type site and operation center, carry out data fractionation and trim.
20. method according to claim 19 is characterized in that,
Described second to decompose the reason data be to decompose to described first that the reason data gather and/or weighted calculation obtains.
21., it is characterized in that described method also comprises according to claim 18 or 19 described methods:
After described mapping conversion and before described cost apportionments is handled, for the user provides the function of first data adjustment, and/or
After described cost apportionments is handled and before described accounting report index, for the user provides the function of second data adjustment, and/or
After described accounting report index and before described data split, provide the function of the 3rd data adjustment for the user.
22. method according to claim 21 is characterized in that,
The described first data adjustment comprises site type cost, non-site type cost is assigned to specific cost objective,
The described second data adjustment comprise after described cost apportionments handled share that variance data is examined, amended record, modification,
Described the 3rd data adjustment comprise to the variance data after the described accounting report index examine, amended record, modification.
23. method according to claim 21 is characterized in that, described method also comprises:
According to the total points that sets in advance check rule respectively to after the described mapping conversion, after the data adjustment, after the revenue sharing, after the cost apportionments, after the accounting report index and the data of data after splitting carry out total points and check,
When the described total points of the data fit of being checked is checked rule, do not process,
When the data of being checked do not meet described total points and check rule, this is not met total points check the data of rule and carry out trim, and generate virtual account.
24. method according to claim 23 is characterized in that, described method also comprises:
The function that is provided with that demand and total points are checked rule that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index is provided for the user, and when dimension changes, provide the maintenance function that demand and total points are checked rule that gathers that described mapping ruler, revenue sharing rule, report form index, income is split rule, report form index for the user.
25. method according to claim 15 is characterized in that, described method also comprises:
For the user provides the setting to the rights of using of described method, the inquiry of running log and the monitoring of running status;
Clear up according to the historical data that generates in the operational process of data scrubbing rule that sets in advance described method.
26. branch bank's various dimensions performance appraisal method is characterized in that described method comprises:
According to mapping ruler profitability data, traffic data and time point balance data from various dimensions performance appraisal system of head office of bank and origin system are shone upon conversion respectively, generate profitability data of the customer manager of branch account levels and the customer manager of branch account levels traffic data;
According to the portfolio report form index the described customer manager of branch account levels traffic data is processed, generated portfolio report form index data;
According to profitability report form index the profitability data of the described customer manager of branch account levels are processed, generate profitability report form index data;
Show described portfolio report form index data and profitability report form index data according to branch's form demand and form standard.
27. method according to claim 26 is characterized in that, described method also comprises:
Check rule according to the branch's total points that sets in advance and the data after processing after processing after the described mapping conversion, to the customer manager of branch account levels traffic data, to the profitability data of the customer manager of branch account levels are carried out total points check,
When the described branch of the data fit of being checked total points is checked rule, do not process,
When the data of being checked do not meet described branch total points and check rule, this is not met branch's total points check the data of rule and carry out trim, and generate branch's virtual account.
28. method according to claim 27 is characterized in that, described method also comprises:
The function that is provided with of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule is provided for the user, and when dimension changes, provide the maintenance function of described mapping ruler, portfolio report form index, profitability report form index, branch's form demand and branch's total points being checked rule for the user.
29. method according to claim 28 is characterized in that, described method also comprises:
For the user provides the setting to the rights of using of described method, the inquiry of running log and the monitoring of running status;
Clear up according to the historical data that generates in the operational process of branch's data scrubbing rule that sets in advance described method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102722822A CN101916422A (en) | 2010-09-01 | 2010-09-01 | Multi-dimensional performance evaluation system and method for banks |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102722822A CN101916422A (en) | 2010-09-01 | 2010-09-01 | Multi-dimensional performance evaluation system and method for banks |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101916422A true CN101916422A (en) | 2010-12-15 |
Family
ID=43323927
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102722822A Pending CN101916422A (en) | 2010-09-01 | 2010-09-01 | Multi-dimensional performance evaluation system and method for banks |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101916422A (en) |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761611A (en) * | 2014-01-08 | 2014-04-30 | 国家电网公司 | Safety performance evaluation system of production enterprise |
| CN104182900A (en) * | 2014-08-07 | 2014-12-03 | 深圳市雁联计算系统有限公司 | Business data processing method, device and system |
| CN105786902A (en) * | 2014-12-24 | 2016-07-20 | 北京奇虎科技有限公司 | Message content based data processing method and system as well as electronic device |
| CN106067091A (en) * | 2016-06-02 | 2016-11-02 | 中国农业银行股份有限公司 | Enterprise Institutions checking system and method |
| CN107239870A (en) * | 2017-04-11 | 2017-10-10 | 太仓鸿策创达广告策划有限公司 | Business finance aggregation process system |
| CN107392748A (en) * | 2016-08-02 | 2017-11-24 | 南京坦道信息科技有限公司 | A kind of income index based on dimension map matching is efficiently entered an item of expenditure in the accounts system and method |
| CN107437220A (en) * | 2017-07-13 | 2017-12-05 | 广东网金控股股份有限公司 | A kind of method and device for generating differential interest rate |
| CN107491504A (en) * | 2017-07-31 | 2017-12-19 | 蒋强 | Expressway tol lcollection person rewards computational methods and system |
| CN107704459A (en) * | 2016-06-21 | 2018-02-16 | 平安科技（深圳）有限公司 | The treating method and apparatus of business activity data |
| CN108596426A (en) * | 2018-03-09 | 2018-09-28 | 广州天维信息技术股份有限公司 | A kind of recalculation method and system of performance appraisal |
| CN108876582A (en) * | 2018-07-26 | 2018-11-23 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus exporting real-time accounting statement and server |
| CN108875048A (en) * | 2018-06-27 | 2018-11-23 | 中国建设银行股份有限公司 | Report form generation method, device, electronic equipment and readable storage medium storing program for executing |
| CN109657896A (en) * | 2018-09-28 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Mobility notch detection method, device, equipment and storage medium |
| CN110766546A (en) * | 2019-10-25 | 2020-02-07 | 神州数码融信软件有限公司 | Bank account management method |
| CN111737490A (en) * | 2020-06-19 | 2020-10-02 | 中国建设银行股份有限公司 | Knowledge graph body model generation method and device based on bank channel |
| CN112541693A (en) * | 2020-12-21 | 2021-03-23 | 携程计算机技术（上海）有限公司 | Performance data generation method, system, electronic device and storage medium |
| CN112686484A (en) * | 2019-10-18 | 2021-04-20 | 广州天维信息技术股份有限公司 | Method for automatically detecting performance wages |
| TWI794720B (en) * | 2021-01-07 | 2023-03-01 | 台北富邦商業銀行股份有限公司 | Performance management analyzing system and method thereof |
-
2010
- 2010-09-01 CN CN2010102722822A patent/CN101916422A/en active Pending
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761611A (en) * | 2014-01-08 | 2014-04-30 | 国家电网公司 | Safety performance evaluation system of production enterprise |
| CN104182900A (en) * | 2014-08-07 | 2014-12-03 | 深圳市雁联计算系统有限公司 | Business data processing method, device and system |
| CN105786902A (en) * | 2014-12-24 | 2016-07-20 | 北京奇虎科技有限公司 | Message content based data processing method and system as well as electronic device |
| CN105786902B (en) * | 2014-12-24 | 2019-06-04 | 北京奇虎科技有限公司 | Data processing method and system and electronic equipment based on message content |
| CN106067091A (en) * | 2016-06-02 | 2016-11-02 | 中国农业银行股份有限公司 | Enterprise Institutions checking system and method |
| CN107704459A (en) * | 2016-06-21 | 2018-02-16 | 平安科技（深圳）有限公司 | The treating method and apparatus of business activity data |
| CN107392748A (en) * | 2016-08-02 | 2017-11-24 | 南京坦道信息科技有限公司 | A kind of income index based on dimension map matching is efficiently entered an item of expenditure in the accounts system and method |
| CN107239870A (en) * | 2017-04-11 | 2017-10-10 | 太仓鸿策创达广告策划有限公司 | Business finance aggregation process system |
| CN107437220A (en) * | 2017-07-13 | 2017-12-05 | 广东网金控股股份有限公司 | A kind of method and device for generating differential interest rate |
| CN107491504A (en) * | 2017-07-31 | 2017-12-19 | 蒋强 | Expressway tol lcollection person rewards computational methods and system |
| CN108596426A (en) * | 2018-03-09 | 2018-09-28 | 广州天维信息技术股份有限公司 | A kind of recalculation method and system of performance appraisal |
| CN108875048A (en) * | 2018-06-27 | 2018-11-23 | 中国建设银行股份有限公司 | Report form generation method, device, electronic equipment and readable storage medium storing program for executing |
| CN108875048B (en) * | 2018-06-27 | 2020-12-25 | 中国建设银行股份有限公司 | Report generation method and device, electronic equipment and readable storage medium |
| CN108876582A (en) * | 2018-07-26 | 2018-11-23 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus exporting real-time accounting statement and server |
| CN109657896A (en) * | 2018-09-28 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Mobility notch detection method, device, equipment and storage medium |
| CN112686484A (en) * | 2019-10-18 | 2021-04-20 | 广州天维信息技术股份有限公司 | Method for automatically detecting performance wages |
| CN110766546A (en) * | 2019-10-25 | 2020-02-07 | 神州数码融信软件有限公司 | Bank account management method |
| CN111737490A (en) * | 2020-06-19 | 2020-10-02 | 中国建设银行股份有限公司 | Knowledge graph body model generation method and device based on bank channel |
| CN111737490B (en) * | 2020-06-19 | 2023-07-25 | 中国建设银行股份有限公司 | Knowledge graph ontology model generation method and device based on banking channel |
| CN112541693A (en) * | 2020-12-21 | 2021-03-23 | 携程计算机技术（上海）有限公司 | Performance data generation method, system, electronic device and storage medium |
| TWI794720B (en) * | 2021-01-07 | 2023-03-01 | 台北富邦商業銀行股份有限公司 | Performance management analyzing system and method thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101916422A (en) | Multi-dimensional performance evaluation system and method for banks | |
| Lee et al. | Financial analysis, planning and forecasting: Theory and application | |
| Ahmad | A proposed framework for business demography statistics | |
| Rickne | Labor market conditions and social insurance in China | |
| Flores et al. | Earnings management and macroeconomic crises: Evidences from Brazil and USA capital markets | |
| Wignaraja | Can SMEs participate in global production networks? | |
| CN104599006A (en) | Collaborative management information system of enterprise business on the basis of workflow engine | |
| Okoye et al. | Effect of intangible assets on performance of quoted companies in Nigeria | |
| Günnel et al. | Does Benford’s Law hold in economic research and forecasting? | |
| Hamawandy et al. | The role of segment financial reports in rationalising investment decisions in Iraq | |
| Guo | Data source analysis of computerized management accounting based on data warehouse and mobile edge computing | |
| Zhao | Comprehensive Budget Execution Performance Evaluation of Companies Incorporating EVA Unsupervised Learning Model | |
| Lazonick et al. | How the disappearance of unionized jobs obliterated an emergent Black middle class | |
| Hundsdoerfer et al. | How accurately does the CCCTB apportionment formula allocate profits? An evaluation of the European Commission proposal | |
| Mallick et al. | Association between management capacity and profitability of scheduled urban co-operative banks in India | |
| Labunska et al. | Cognitive analytical tools for cost management of innovation activity | |
| Chen et al. | Optimal staffing policy in commercial banks under seasonal demand variation | |
| KR20210053563A (en) | Construction information management system with using big data processing | |
| Rickne | Firm size and work compensation in China | |
| Karmańska | Business Intelligence in consolidation of financial statements | |
| Albadainah | The Applicability of AIS Practices within Modern Business Environment–Case Study of Amman Stock Exchange | |
| Hidayat et al. | A Cross-Tabulation to Know the Relationship between Financial Performance and Leverage on a Company’s Tax Reporting and Tax Compliance | |
| Petroska Angelovska et al. | Possibilities for improvement of profitability of enterprises in tourism industry in the Republic of Macedonia | |
| Silva et al. | COVID-19 and Local Market Power in Credit Markets | |
| US20050021496A1 (en) | System for handling data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20101215 |