JPH10214301A - Initial register method for medium delivery management system for automatic transfer device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the processing efficiency by reduction of receipt and delivery management online processing and to effectively use disk resources by uniform arrangement of data in a disk. SOLUTION: Contract contents information for each clients is stored in a client management data base based on contract documents accompanied with account automatic transfer contracts made with clients. In a schedule management data base, delivery management information of an automatic transfer request medium consists of a common part of the client management data base and a detailed part of contents of a medium with respect to each of codes specifying a clients and automatic transfer designated days. As a preparatory processing, a client for whom the transfer day is cyclic is initially registered after the end of a batch of several months before the transfer day.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic transfer process of an accounting system of a financial institution, and more particularly to a process registration method of a medium transfer management system of an automatic transfer device for a medium received from a client.

[0002]

2. Description of the Related Art As a conventional initial registration method of a medium transfer management system of an automatic transfer apparatus, a method of realizing schedule management by a transmission network and information input from an information terminal is proposed in Japanese Patent Laid-Open No. 57-11657. Have been.

That is, this type of schedule management system is limited to registration and search from an online terminal.

[0004]

The above-mentioned prior art has the following problems. The first problem is that data is stored in the spare area or the extended area even though there is sufficient free space in the main area of the database, and the data cannot be stored due to insufficient database area. The disadvantage is that resources could not be used effectively. This is because the registration process is performed sequentially by online processing. Therefore, when a database is constructed using an indexed file, data is stored in a free space between the previous key and the file when the file is stored. Therefore, the data arrangement in the disk is biased.

Therefore, since the free size of data at the time of registration is constant, when a key having a high key value is registered first, the area size between keys becomes small, and overflowing records are stored in the extended area. As a result, the data arrangement in the disk is biased as described above. For this reason, work that should be unnecessary, such as expansion of the disk area when the database area overflows, or reorganization by constantly monitoring the data arrangement of the database, has occurred.

As a second problem in the above-mentioned prior art, all the registration processing of the schedule management database is limited to a method of online processing from the information terminal, and an excerpt part from the client management database is stored. Since it is necessary to create both a common part and a detailed part for storing the medium transfer information, the load is concentrated on online processing in the registration processing of the schedule management database, and the turnaround time becomes long.

A third problem with the above-mentioned prior art is that it is possible to search for information about already registered medium exchange information, but it is not possible to output a future schedule in advance. .

An object of the present invention is to improve the turnaround time by reducing the processing load of online processing.

Another object of the present invention is to effectively use resources by evenly allocating data in a database area.

[0010] Still another object of the present invention is to collect schedule data, output a book table, and use it for management of exchange of media.

[0011]

In order to solve the above-mentioned problem, in the present invention, the contents of a contract with a customer who makes a transfer request to a financial institution are managed separately from schedule registration information. Based on the automatic account transfer contract information of the client management database, the registration is performed in advance in the common part of the schedule management database of the client with the cycle property on the transfer date by batch processing. When performing pre-registration, records are registered in ascending order of the key value in order to arrange data evenly in the database area. Also, a schedule book is output based on the registration information, and is used as a check sheet for medium transfer.

[0012]

[Function] Since it is possible to output a check sheet on the scheduled date of receiving the automatic transfer data medium, it is possible to prevent the forgetting of the online processing, and as inquiry information to the data creator when the scheduled medium does not arrive. Available.

[0013] In addition, since registration processing of an indexed file having a large processing load is collectively performed for one month in advance in a time period when the number of processed files is small and there is room for processing, the load of online processing in the window time window is reduced. Can be reduced.

Further, since the records are registered in ascending order of the key value, the data are evenly arranged in the database area.
Effective use of disk resources.

[0015]

Embodiments of the present invention will be described below in detail with reference to the drawings. Referring to FIG.
The initial registration method in the embodiment of the present invention is performed by a central processing unit (host computer) 1 and an input / output information terminal 2 composed of a keyboard, a display device, and the like.
And a storage device 3 such as a magnetic disk for storing information, and an output device 4 such as a printer.

The storage device 3 can internally constitute a database, and stores a client management database (see FIG. 3) and a schedule management database (see FIG. 4) in the storage device. The storage device 3 is effective only during execution of a process, and can create a temporary work area to be deleted at the end of the process.

The input / output information terminal 2 includes a central processing unit 1
To the central processing unit 1 to request processing and output the processing result. The output device 4 is connected to the central processing unit 1, and outputs various books in response to a request from the central processing unit 1.

The registration data of the schedule management database is created from the automatic transfer contract information of the trustee management database. As shown in FIG. 3, the trustee management database includes basic information (information such as the name of the subcontractor, kana name, telephone number, etc.) 21 and due date information (transfer date cycle information (to what day each month is automatically transferred) Information), holiday adjustment information (information on whether the transfer will be made on the previous day or the next day if the transfer date is a holiday), scheduled media receiving date information (how many days before the transfer date is the contract for the media to arrive Information) 22, the receiving medium information (the form of the receiving medium (MT, F
D, communication, leased line, etc.), record length, block size, code form (JIS, EBCDIC, etc.)
27, contract information of an automatic transfer contract with a consignee, such as settlement information (information on which account the funds collected by automatic transfer are to be stored) 26, common information (information on the classification of debit / transfer) 23, etc. I have.

FIG. 2 is a schematic diagram showing the flow of the process of the present invention. In step A of FIG. 2, a full search of the client management database 11 is performed, and a transfer date at which an automatic transfer is scheduled to occur for each client is calculated. If an automatic transfer occurs in the relevant month, extract an extract (basic information, due date information, common information, etc.) of the automatic transfer contract information, create a registration record for each transfer date and client code, and The information is stored as a schedule management database registration information 12 in a temporary storage area in the apparatus.

Next, in step B of FIG. 2, the sorting process (permutation) is performed using the transfer date / client code as key information.
Is performed, and the records for registration are sorted in ascending order of the transfer date and the client code.

In step C of FIG. 2, the registration records 12 'rearranged in step B are input and the medium management information of the automatic transfer processing is registered in the schedule management database 13. Outsourcing companies that do not have regularity on the transfer date,
Alternatively, a case for an automatic transfer processing request due to a special situation such as an emergency or a consignee for which an automatic transfer contract has been concluded after the completion of the pre-registration processing cannot be registered in the pre-registration processing. Therefore, in the above case, the media management information is registered from the online terminal as before.

[0022]

Embodiments of the present invention will be described below. The consignor management database is a database that stores the contents of contracts with the consignee, and becomes invariable once registered unless the contract with the consignee is changed or updated. The system is unique and is set uniquely using the client code that specifies the contractor as a key.

The information stored in the client management database mainly comprises the following seven pieces of information. There is basic information as first information, and this information includes a client code (a system is unique and specifies a subcontractor), a client name, a contact, and an input-permitted store (a contracted financial institution (store) of the subcontractor). And the like, and classification of whether this record is currently valid (live data).

The second information includes due date information. This information includes whether or not a transfer date has a cycle, and a transfer date for each month (2 days each month).
Etc to be transferred on the 5th), the scheduled media acceptance date (how many days before the media arrives on the transfer date), holiday adjustment classification (if the transfer date is a holiday, which date before or after the transfer date should be changed),
The transfer date, such as the scheduled media return date (how many days after the transfer date the media will be returned), the media acceptability date (how long before the transfer date can media be accepted), and reference data for calculating the media return date Is stored.

There is common information as the third information, which is common in the automatic transfer system such as a loan / borrow category (a category indicating transfer data or debit data) and a fund settlement category (whether or not to perform automatic fund settlement). Stores items used for.

As the fourth information, there is registration information. This information includes a form in which the received medium data is registered as automatic transfer data in the automatic transfer system, a book table to be output when the data is registered in the automatic transfer system, and its output. Information such as the form is stored. It is unused information in the medium management system of the present invention.

Fifth information is return information, which stores reference information for returning the medium, such as a book attached to the medium received from the consignee and a storage method for the returned medium. ing.

The sixth information is settlement information, which includes a transfer fee unit price, a method of processing a transfer fee consumption tax,
The method of fund settlement processing (delivery of funds between financial institutions when performing transfer processing (withdrawal / transfer) through another financial institution), and ultimately storing funds when withdrawing or transferring Stores information related to fund settlement, such as an account number. In the present invention, the information is unused information.

The seventh information is medium information. The information includes the form of the receiving medium (MT, FD, telephone communication, dedicated line,...), Record length, block size, and code form of the medium (JIS code, new JIS). Code, EBICDIC
..) Are stored.

As shown in FIG. 4, the schedule management database registers items extracted from the client management database, a common part 31 composed of data calculated from information in the client management database, and registers data. And a specification part 32 that is sometimes input.

The common part 31 includes a name of a trustee, a name of a trustee,
It consists of items extracted from the client management database, such as the client code, transfer date, and telephone number, and data calculated from information in the client management database, and depends only on the contents of the client management database.

The specification unit 32 includes a registered store (obtained from the terminal number of the registered terminal), an order number (a number for specifying the receiving medium, which is uniquely assigned to the system by schedule registration),
Consists of the receiving medium, return medium, registration date, return date, processing status code, etc., and the contents are finalized when the store (automatic transfer contract concluded financial institution) that received the data from the contractor has registered the medium. . The processing status code is a code indicating the current media receiving status and return status, and is represented by a numerical value (media registration request, media arrived, media registered,
During the automatic transfer process, the automatic transfer process ends,...). The two databases are constructed and stored in a magnetic disk device attached to the host computer.

One or more information terminals 2 are installed at the system administrator and at each financial institution / branch, and the schedule registration and schedule confirmation of the receiving medium can be performed by online processing. However, only the system administrator can register and change the client management database.
When the contents of the contract with the contractor are changed, each financial institution requests the system administrator to register or change.

The printer device 4 is a printer device connected to a host computer and mainly performs output processing on a large amount of books. Therefore, the printer device is a printer capable of high-speed output. A page printer is preferred.

The operation of the medium transfer management system can be broadly divided into three operations: pre-registration by batch processing, online registration processing, and state display change processing by the status of the automatic transfer processing.

The operation of pre-registration by batch processing will be described below. The pre-registration by the batch process is a process of collectively registering scheduled schedules of the receiving media of all the subcontractors having a cycle property several months before the transfer process is performed. 9 for the moon
The processing is performed after the end of the daily batch on the second Friday of Monday. The reason why the processing is performed on the second Friday is that it has been confirmed from the business requirements that this is the day with the least processing in the entire system.

The processing flow of the output processing of the registration data from the full search of the client management database in step A of FIG. 2 will be described with reference to FIG. First, a record for one consignee is read (step S1), and it is determined whether the record is valid or invalid based on the life and death flag of the basic record (step S2). When invalid, the record of the next trustee is searched. When the transfer date is valid, the transfer date cycle division of the due date information is read, and it is determined whether or not the transfer date has a cycle property (step S3). If there is no cycle on the transfer date, it will not be subject to pre-registration in batch processing,
Search for the record of the next trustee. In the case of a record having a cycle property, the designated transfer date information of the due date information (5th of every month,
The transfer date is calculated from the last day of the month, 5/10,...) (Step S4), and it is checked whether the day is a holiday (step S5). The transfer date is changed on the day (the business day means the window handling day) or the next business day (step S6).

However, if the calculated transfer date is outside the month to be processed (for example, data for September is being processed,
September 1 is adjusted by setting Sunday as a holiday on September 30.
If it is a day), it is excluded from the schedule management database registration data output target (step S7).

Further, the number of days before the transfer date before the transfer date has been reached is read from the date management information, and the expected arrival date is calculated in the same manner (step S8). In step S9, the schedule management database registration data is output to the temporary save area. The output information is information specifying a client such as a client code, a client name, a telephone number, an input-permitted store, and due date information such as a transfer date calculated in steps S6 and S8 and a scheduled media arrival date. Information necessary for book output by online search or batch processing is stored so that unnecessary disk IO is not generated in the client management database when the book is output. These processes are performed for each outsourcing party, and the processing is performed until the processing for all outsourcing parties is completed (step S10).

In step B of FIG. 2, the data for registering in the schedule management database is sorted in ascending order of transfer date / client code. As a result, uniform arrangement in the database area becomes possible. In step C of FIG. 2, the schedule management database registration data is registered in the schedule management database, and the pre-registration work is completed.

Next, the daily processing will be described. First,
Performs a full search of the schedule management database, extracts data for which the transfer date and the scheduled media acceptance date are close to today's date, and outputs a book. The data to be output include information such as a transfer date, a client code, a consignor name, and a telephone number, and the current status of whether the medium has arrived and whether the system has been registered. The operation manager checks the data and the like that has not been registered but has not been registered based on the book table, and confirms it by contacting the trustee.

Next, with reference to FIG. 6, a description will be given of online registration processing of a receiving medium. Using the information terminal, enter the transfer date, client code, number, and amount. The input of the number of cases is for checking whether the registered medium is the same as the medium sent by the consignee. Based on the transfer date / client code, the basic part of the schedule management database is searched, and the record is read (step 2).
1) Check whether the record has already been registered (step 22). If the record has already been registered, the input data is combined with the contents of the common part of the schedule management database (step 2).
6) If the data is valid, an order number is assigned (step 27), and the specification part is registered (step 29).

If there is no record in the search in step 21, the entrustor management database is read (step 23), the common part is edited (step 25), and the contents of the input data and the edited common part data are read. The validity is checked, and if the data is valid, an order number is assigned (step 27), and the common part and the detailed part are registered (steps 28 and 29). The registered schedule management database holds the status at that time as a processing state.

Therefore, every time an event (transfer data registration / registration failure / transfer processing execution / failure / return data creation, etc.) occurs due to the daily processing, processing state change data is generated. The state shall be changed.

The data to be registered only by the online processing are data that does not have a cycle on the transfer date, data of an urgent request, and data of a consignee to whom an automatic transfer contract has been concluded after the completion of the pre-registration processing. These contractors can be regarded as 10% or less of all the contractors, and most of the contractors are subject to pre-registration.

[0046]

According to the present invention, the registration processing of the pre-registered data is completed only by registering the detailed section, but the data not pre-registered is registered in both the common section and the detailed section. Is required, the turnaround time can be reduced, and the waiting time of the terminal can be reduced.

According to the present invention, in the database,
Data can be evenly distributed, and effective use of resources can be expected.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of the entire system.

FIG. 2 is a schematic diagram of the entire system.

FIG. 3 is a schematic diagram of information constituting a client management database.

FIG. 4 is a schematic diagram of information constituting a schedule management database.

FIG. 5 is a process flow of a schedule management database registration data output process.

FIG. 6 is a processing flow of a registration process of a schedule management database when using online.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Central processing unit 2 I / O information terminal 3 Storage device 4 Output device

Claims (2)

[Claims] Claims 1. An automatic transfer request to a financial institution, a contractor management database for storing the contents of an automatic account transfer contract with a customer (hereinafter referred to as a subcontractor) for each subcontractor, A schedule management system comprising a medium for storing medium exchange information, a common part for storing a code for specifying a consignee, and excerpt information of the entrustor management database for each designated day of the automatic transfer process, and a detailed part for storing information on the medium for exchange. A storage device that stores a database, a plurality of input / output terminals, an output device, and a central processing unit that controls them are provided.The central processing unit performs a full search of the client management database, Calculate the transfer date at which automatic transfer is scheduled to occur for each subcontractor. If automatic transfer occurs in the relevant month, extract an excerpt from the automatic transfer contract information, and A registration record is created for each client code, the registration record is stored in the temporary storage area of the storage device as registration information of the schedule management database, and the transfer date and the client code are used as key information. Performing sort processing, and rearranging the registration records in ascending order of the transfer date and the client code,
An initial registration method for a medium transfer management system for an automatic transfer apparatus, wherein the rearranged registration records are input and medium management information for automatic transfer processing is registered in the schedule management database. 2. The contract contents stored in the client management database include a transfer date, a transfer cycle, a classification of debit / transfer, a type and method of settlement between financial institutions, and a case where transfer processing becomes impossible. Processing method, output book type,
2. An initial registration method for a medium transfer management system for an automatic transfer apparatus according to claim 1, wherein the method includes a type of a carry-in medium and a method of writing a return medium.