JP4575949B2 - Verification management system - Google Patents

Description

  The present invention relates to a collation management system that converts various transaction data into a common format and collates the contents of transaction data in financial transactions such as balance collation, settlement collation, settlement completion collation, and contract collation.

  In recent years, there has been a need for more efficient financial processing operations as financial related business reforms have been actively carried out. In order to improve the efficiency of the financial processing business, it is important how efficiently the verification business in the financial transaction is performed. Conventionally, in the collation business in financial transactions, data to be collated is sent in a document format using a fax or the like, and the sent document is collated by visual inspection. Further, in order to manage the collated data, the collated data is input as electronic information to a personal computer or the like after the collation.

  By the way, in recent years, with the efficiency of collation work, digitization processing has been promoted and digitized collation data has been transmitted and received, and a contract management system that collates data using this collation data is used. It is supposed to be. In this contract management system, when collation data is displayed, collation data (matching source data and matching destination data) to be collated are displayed side by side on the display screen (see FIG. 8). ).

  However, in this display method, even when there are mismatched items in the matching data to be matched, it is difficult to find mismatched items, and when there are three or more matching target data, It was difficult to check the data to be collated because it could not be displayed at a time.

  An object of the present invention is to provide a collation management system capable of easily confirming a plurality of collation results at a time by displaying collation target data in a list format arranged in the vertical direction.

The collation management system of the present invention includes a received data storage means for storing received data to be collated having a plurality of collation inspection items, and a format of the received data stored in the received data storage means. A standard format that is a format that can be collated by converting the sequence of items into a sequence of data items of standard data and converting the data code of each data item of the received data into the data code of each data item of the standard data Data conversion means for converting to standard data, standard data storage means for storing standard data converted by the data conversion means, and a plurality of target data to be collated from the standard data stored by the standard data storage means A selection means for selecting standard data, and a plurality of selections selected by the selection means And grouping means for grouping the group including standard data of more than 3 on the basis of a preset grouped items quasi data, the terms 3 or more standard data grouped by the grouping unit, advance The collation means for performing collation for the set collation inspection item for each group, and the collation result by the collation means are used as the collation error group in which there is a mismatch in the content of the collation inspection item and the content of the collation inspection item. It is displayed roughly divided into collated groups in which no mismatch exists, and each of the collation error group and the collated group is divided into groups grouped by the grouping means, and the three collation results are displayed. displayed in list format as more standard data arranged in the vertical direction, the verification error group Display means for displaying the collation inspection items whose contents are inconsistent so that they can be identified, transmission data conversion means for converting standard data of the collated group into transmission data in a transmission format, and transmission data conversion means Transmission data storage means for storing the transmission data converted by the above.

  In the collation management system of the present invention, the display unit displays a collation result by the collation unit on the same screen.

  Further, the collation management system of the present invention is characterized in that the standard data storage means collectively stores the standard data for each date received.

  According to the collation management system of this invention, the collation error group in which there is a mismatch in the contents of the collation inspection items and the collated group in which there is no mismatch in the contents of the collation inspection items are displayed by the display means. In addition, each of the collation error group and the collated group is divided into groups grouped by the grouping means, and the collated standard data is displayed in a list form so that the collated standard data is arranged in the vertical direction. Therefore, the verification results of a plurality of groups can be confirmed at a time. Further, even when there are three or more data items in the group, the collation result can be easily confirmed on the same display. Further, in the collation error group, for example, since the collation inspection items whose contents are inconsistent are displayed so as to be identifiable so that the collation result can be identified for each group, it is possible to easily find the inconsistent data items.

  According to the present invention, the result of collation performed by the collating unit is divided into groups by the display unit, and the collated standard data is displayed in a list form so as to be arranged in the vertical direction. Can be confirmed. Further, even when there are three or more data items in the group, the collation result can be easily confirmed on the same display. Further, for example, data items whose contents do not match are displayed in an identifiable state so that the collation result can be identified for each group, so that the mismatched data items can be easily found.

  A collation management system according to an embodiment of the present invention will be described below with reference to the drawings. In this embodiment, an explanation will be given by taking an example of contract verification management in securities transactions.

  FIG. 1 is a block diagram of a collation management system according to an embodiment of the present invention. As shown in FIG. 1, the verification management system 2 installed in a trust bank or the like includes a verification processing unit 20 and a terminal device 22 connected to the verification processing unit 20. The verification management system 2 is connected to each of an overseas securities company system 6a, an overseas institutional investor system 6b, a domestic securities company system 6c, and a domestic institutional investor system 6d via a communication network 4. Further, the product accounting system 10 is connected via the communication network 8.

  The verification processing unit 20 includes a data processing unit 20a that performs received data format conversion, verification processing, and the like. The data processing unit 20a includes a received data storage unit 20b that stores received data as it is, and data processing. A standard data storage unit 20c that stores standard data converted into a standard format by the unit 20a and a transmission data storage unit that stores transmission data (verified contract data) that has been verified by the data processing unit 20a and converted into a transmission format 20d is connected. The terminal device 22 has a display unit and an input unit (not shown). The display unit displays the collation processing status, and correction, approval, and the like are performed using the input unit.

  FIG. 2 is a flowchart for explaining conversion of received data into standard data performed by the collation management system. In the following description, an example is shown in which the trading report data transmitted from the overseas securities company system 6a and the operation instruction data transmitted from the overseas institutional investor system 6b are converted into standard data in a standard format. Will be described.

  First, when the collation management system 2 receives the trade report data transmitted from the overseas securities company system 6a via the communication network 4 (step S10), the received data is received as it is via the data processing unit 20a. It memorize | stores in the memory | storage part 20b (step S11). FIG. 3 is a diagram showing a data format of received sales report data. This trade report data is composed of data items such as “broker code”, “fund No.”, “brand code”, “contract date” and the like arranged in sequence.

  Similarly, when the collation management system 2 receives the operation instruction data transmitted from the overseas institutional investor system 6b via the communication network 4 (step S10), the received data is transmitted via the data processing unit 20a. Is stored in the received data storage unit 20b as it is (step S11). FIG. 4 is a diagram showing a data format of the received operation instruction data. This operation instruction data is composed of data items such as “Fund No.”, “Broker Code”, “Brand Code”, “Extract Date”, etc. arranged in order.

  Next, the reception data (sales report data and operation instruction data) stored in the reception data storage unit 20b is converted into standard data in a standard format (step S12). That is, the sales report data and the operation instruction data transmitted to the verification management system 2 are configured in a unique format for each institutional investor, securities company, etc. to be transmitted. In order to collate the report data and the operation instruction data, it is necessary to convert the trade report data and the operation instruction data into data in a format that can be collated, that is, standard data. Accordingly, the collation management system 2 converts each of the sales report data and the operation instruction data into standard data.

  Here, the conversion of the received data to the standard data is performed by converting the arrangement of the data items of the received data into the sequence of the data items of the standard data, and the data code of each data item of the received data is changed to the data of each data item of the standard data. Convert to code, that is, convert the stock code etc. from external code to in-house code, and if there is a data item that does not exist in the received data in the standard data, the data item that does not exist is another existing data This is done by generating from items. FIG. 5 is a diagram showing a data format of standard data. This standard data is configured in a state in which data items such as “contract date”, “delivery date”, “broker code”, “fund No.”, “brand code”, etc. are sequentially arranged. Accordingly, all the sales report data and operation instruction data stored in the received data storage unit 20b are converted into the standard data format.

  Next, the standard data converted into the standard format is stored in the standard data storage unit 20c (step S13). In addition, when memorize | storing standard data in the standard data memory | storage part 20c, it collects and memorize | stores for every received date.

  FIG. 6 is a flowchart for explaining the contract matching process in the securities transaction executed by the matching management system. First, a collation data selection screen for selecting data to be collated from standard data stored in the standard data storage unit 20c is displayed on the terminal device 22 (step S20), and selection of data to be collated is selected. Is performed (step S21). That is, by selecting a reception date or the like displayed on the collation data selection screen, standard data to be collated is selected.

  Next, the collation target data selected in step S21 is grouped based on a preset item, that is, a grouping item (step S22). Here, the investment instructions are for institutional investors to instruct securities companies, etc. to buy and sell securities, and the trading reports are the securities actually issued by securities companies, etc. based on the investment instructions. Since it is for reporting on buying and selling, the items with the same contents are included if they relate to the same transaction. Therefore, the operation instruction data and trading report data related to the same transaction can be grouped together by setting the data items that have the same contents as the grouping items in advance in the operation instruction data and trading report data related to the same transaction. Grouped into

  Next, the data grouped in step S22 is collated for each group (step S23). In other words, data is collated for preset collation inspection items, specifically, “dealing date”, “delivery date”, “broker code”, “fund No.”, “brand code”, and the like.

  Next, the collation result is displayed in a list format (step S24). FIG. 7 is a diagram showing a display result of the collation result when the data received on November 24, 2000 is selected as the collation reference data in step S21. As shown in FIG. 7, the collation result includes a group in which data items whose contents do not match in the collation inspection item, that is, a group in which collation error and a data item in which the contents in the collation inspection item do not exist, That is, it is displayed roughly divided into collated groups. Further, in each of the collation error group and the collated group, each group grouped in step S22 is displayed in a list format. Further, in the verification error group, verification inspection items whose contents do not match are identified and displayed.

  Next, the data processing unit 20a converts the matching data (matched group data) to the transmission data in the transmission format (step S25). That is, the data is converted into a data format required by the merchandise account system 10 which is a subsequent processing system. Then, the transmission data converted into the transmission format is stored in the transmission data storage unit 20d (step S26).

  Next, the transmission data stored in the transmission data storage unit 20d is transmitted to the merchandise account system 10 (step S27). The transmission data is transmitted to the merchandise account system 10 at the same time as the transmission data is stored in the transmission data storage unit 20d, but may be performed based on an instruction from the terminal device 22.

  According to the collation management system of this embodiment, even when operation instruction data and trading report data having different formats transmitted by securities companies, institutional investors, etc. are received, they are stored in standard formats. Since it is converted to standard data, the verification work can be performed smoothly.

  The collation result of the data selected as the collation target is divided into groups and displayed in a list format. Therefore, a plurality of collation results can be displayed and confirmed at a time on a group basis. Furthermore, since the collation results are displayed in a list format, the collation inspection items that do not match in the collation processing can be displayed in a clearly identifiable state, and the collation results can be easily confirmed.

  In the above-described embodiment, the case where the contract management is managed in the verification management system has been described as an example. However, the present invention is not limited to this, and in the verification management system of the present invention, balance verification, settlement verification Alternatively, settlement completion verification or the like may be performed.

  Further, in the above-described embodiment, two pieces of data are grouped as data for collation. However, even when three or more pieces of data are grouped, the data is once displayed on the same screen. The verification result can be confirmed.

It is a block block diagram of the collation management system which concerns on embodiment of this invention. It is a flowchart for demonstrating conversion to the standard data of the collation data based on embodiment of this invention. It is a figure which shows the format of the sales report data which concern on embodiment of this invention. It is a figure which shows the format of the operation instruction data which concerns on embodiment of this invention. It is a figure which shows the format of the standard data which concerns on embodiment of this invention. It is a flowchart for demonstrating the collation process of the collation data based on embodiment of this invention. It is a figure which shows the display state of the collation data based on embodiment of this invention. It is a figure which shows the display state of the conventional collation data.

Explanation of symbols

2 ... Verification management system, 4 ... Communication network, 6a ... Overseas securities company system, 6b ... Overseas institutional investor system, 6c ... Domestic securities company system, 6d ... Domestic institutional investor system, 8 ... Communication network, 10 ... Product account System system 20 ... collation processing unit 20a ... data processing unit 20b ... received data storage unit 20c ... standard data storage unit 20d ... transmission data storage unit 22 ... terminal device

Claims (3)

Received data storage means for storing received data to be verified having a plurality of verification inspection items;
The received data format stored in the received data storage means is converted from a sequence of data items of the received data to a sequence of data items of the standard data, and a data code of each data item of the received data is converted to the standard data. A data conversion means for converting to standard data in a standard format, which is a format that can be collated by converting the data code of each data item,
Standard data storage means for storing standard data converted by the data conversion means;
Selecting means for selecting a plurality of standard data to be verified from the standard data stored by the standard data storage means;
Grouping means for grouping a plurality of standard data selected by the selection means into a group including three or more standard data based on a preset grouping item;
And matching means for performing for a group of standard data of the above 3 was the verification of the verification test item set in advance for each group by the grouping means,
The verification result by the verification means is broadly displayed as a verification error group in which there is a mismatch in the content of the verification test item and a verified group in which there is no mismatch in the content of the verification test item, and the verification error group In each of the collated groups, the grouping unit divides the data into groups, and displays the collation result in the form of a list so that the three or more standard data are arranged in the vertical direction. Display means for displaying the collation inspection items whose contents are inconsistent in the error group so that they can be identified;
Transmission data conversion means for converting the standard data of the collated group into transmission data in a transmission format;
A collation management system comprising transmission data storage means for storing transmission data converted by the transmission data conversion means.   The collation management system according to claim 1, wherein the display unit displays a collation result by the collation unit on the same screen.   The collation management system according to claim 1 or 2, wherein the standard data storage means stores the standard data collectively for each date of reception.

Images