JPH08147381A - Examination job support system - Google Patents

Abstract

PURPOSE: To enable exact examinations and approvals by displaying update information from the preparation of a document to examination and approval and checking the update information by examiners and approvers. CONSTITUTION: As for a financing process of obtaining the sanction to a plan by circulating the draft prepared by a person in charge job, a document preparing person refers to the information required for the preparation of a document from a data base system 101 on a computer 111 at first, prepares the process document and stores it in a document data base 105. An examiner examines the contents of the process document on a computer 121. If the examination result is a 'rejection', the document is returned to its original state. If the result is 'OK', an approver inputs the examined process document on a computer 131 and approves the contents of the process document. The history information on only the information referred to at the time of preparing the process document is stored in an update history data base 104. Thus, because the data quantity of the update history data base 104 is reduced as compared with the case where all the update information is stored in the update history data base, the retrieval time for update information is shortened, response time is shortened and the working efficiency of examination and approval works is improved.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an examination work support system in which a plurality of workers obtain information from a database or the like and support a series of examination work of document preparation, examination, and approval.
In particular, it is applied to a loan examination work support system that creates, examines, and approves a loan examination document by referring to information that changes with time (deposit balance, loan balance data), such as lending operations at financial institutions. It is related to effective technology.

[0002]

2. Description of the Related Art Conventionally, loan examination documents and loan approval documents in the financial industry, etc. are described in "Bank Training Company Edition, How to Make Lend Approval Documents and Views, Bank Training Company", pages 33 to 45. The drafter describes the transaction status and borrowing status as attributes of the lender, and the final settler has been settled, examined, and approved for loan execution.

As a system for supporting the preparation, examination, and approval of documents by a plurality of workers as described above, a workflow system is described on pages 66 to 76 of "Nikkei Information Strategy July 1994". .

The workflow system has realized a routing function for automating the takeover of business, a function for defining the routing, and a function for automatically inputting information from a database that centrally manages information.

[0005]

DISCLOSURE OF THE INVENTION The present inventors have found the following problems as a result of examining the above prior art.

The above-mentioned prior art has the following problems in the examination work of documents referring to a database that changes with time.

[0007] First, it is not considered that the information on the items described in the document changes between the time the document is created and the time it is examined and approved. Inconsistency occurs and accurate examination and approval cannot be performed.

Further, if information is automatically input from a database that centrally manages information, the contents described in the document will automatically change, and the document will differ from the creator's judgment at the time of document preparation, and correct examination and approval cannot be performed.

On the other hand, when all the update information for the database is stored, it is not taken into consideration that the update information becomes huge, and it takes a long time to retrieve history information related to examination and approval documents.

An object of the present invention is to provide a technique capable of performing accurate examination and approval in examination work.

[0011] Another object of the present invention is to provide a screening service.
It is to provide a technology capable of shortening the search time of history information related to examination and approval documents.

The above and other objects and novel features of the present invention will be apparent from the description of this specification and the accompanying drawings.

[0013]

Of the inventions disclosed in the present application, a representative one will be briefly described below.
It is as follows.

An information management apparatus comprising a storage device for storing information required for preparing examination documents and the prepared examination documents, and information management means for managing information such as retrieval, update, reference and deletion of the information. , Access to the information management device, create examination documents based on the obtained information, examine the created examination documents, and perform information display editing with examination work means for performing examination work for approval of the examination documents In an examination work support system composed of a device and a communication line connecting both of these devices, reference content storage means for storing the contents of information referred to by the information display editing device when the examination document is created or updated. The information management apparatus is provided with an update history storage unit for storing the update content according to the update of the information stored in the reference content storage unit, and Description is when it is updated at the time of examination or authorization includes the update information display means for displaying that the information referred to the creation has been updated in the information display editing device.

[0015]

According to the above-mentioned means, the information management means is provided with the storage device for storing the information necessary for preparing the examination document and the prepared examination document, and for managing the information such as retrieval, update, reference and deletion of the information. An information management device equipped with and the access to the information management device, the creation of the examination documents based on the obtained information, the examination of the created examination documents, and the examination work of the examination work for the approval of the examination documents In an examination work support system composed of an information display / editing device equipped with means and a communication line connecting the two devices, the contents of information referred to by the information display / editing device at the time of creating or updating the examination document The information management device is provided with a reference content storage unit for storing the information, and an update history storage unit for storing the updated content when the information stored in the reference content storage unit is updated.
When the content of the information referred to at the time of creating the examination document is updated at the time of examination or approval, the information display editing device is provided with update information display means for displaying that the information referred to at the time of creation is updated. As a result, the information updated during the process from document creation to examination and approval is displayed, so that the examiner and approver can check the updated information for accurate examination and approval.

Further, since the update history is stored only for the content of the information or the data item referred to in the document preparation, the storage capacity of the update history is reduced and the search time for the history information is reduced. It is possible to shorten the time until the history information is displayed.

The structure of the present invention will be described below together with embodiments.

In all the drawings for explaining the embodiments, parts having the same functions are designated by the same reference numerals, and the repeated description thereof will be omitted.

[0019]

[Embodiment] As an examination operation support system of the present invention, a loan examination operation support system for creating, examining, and approving a document for a loan approval process in a financial industry is given as an example, and the embodiment will be described below in detail with reference to the drawings. Explained.

FIG. 1 is a block diagram for explaining the configuration of a loan examination work support system which is an embodiment of the present invention.

In FIG. 1, reference numerals 111, 121 and 131 denote computers (information display / editing device) including an input device such as a keyboard, a central processing unit, a storage device, and an output device such as a display, and update information display means 180. Equipped with.

Here, 111 is a computer for preparing documents,
Although 121 is a computer for document examination and 131 is a computer for document approval, these computers 111, 121, 131 may be shared for creation, examination, and approval.

Reference numeral 101 denotes a database system (information management device) including a central processing unit and a storage device,
An information management unit 150 for performing information management such as database search, update, reference, and deletion, a reference content storage unit 160, and an update history storage unit 170 are provided.

Reference numeral 102 denotes a database including customer information, loan application information, transaction information, etc. necessary for preparation, examination and approval of the approval document, 103 a reference content database for storing the content of the information referred to at the time of document preparation, 104 Is an update history database that stores the history of database updates.

Reference numeral 105 is a document database for storing the created documents, and 141 is a transaction information input device such as an automatic teller machine.

Computers 101, 111, 121 and 131 are connected through a communication line 100. In addition, communication line 1
In some cases, the information of the database system 101 may be updated with information from devices other than the above through 00.

FIG. 2 is a diagram showing a work flow of a loan approval work in the loan examination work support system of this embodiment.

In the loan approval work in the loan examination work support system of the present embodiment, first, the document creator creates a computer 111.
In the above, referring to the information necessary for document preparation from 101, the approval document is prepared (step 201), and the document database 10
Store in 5.

The examiner inputs the created approval request on the computer 121 and examines the content of the approval request (step 20).
2).

If the examination result is "rejection", the process returns to step 201, and if the examination result is "OK", the process proceeds to step 203.

The approver inputs the approved request for approval on the computer 131 and approves the content of the request for approval (step 20).
3).

If the approval result is "rejection", the process returns to step 201. If the approval result is "OK", the loan approval process is terminated.

Next, the electronic form showing the approval document of this embodiment will be described with reference to FIG.

In FIG. 3, 300 is 111, 121, 1
It is an electronic form displayed on 31 computer displays.

Reference numeral 311 is information for identifying the approval document such as document number, 321 is information of applicant for loan, 331 is outline of application, 341 is information showing transaction status of applicant, 351 is credit information of applicant. 361, 362 and 363 are creators,
This is an input display area for the opinions of the examiner and approver.

Next, the processing of the creation, examination, and approval computers 111, 121, and 131 using the electronic form of FIG. 3 will be described with reference to the flow charts of FIGS. 4 to 6.

FIG. 4 shows a document creation computer 11 according to this embodiment.
It is a figure which shows the processing flow of 1.

The document creation computer 111 accesses the database system 101 via the communication line 100 in response to the approval document creation request from the creator, assigns the document number, and sets the approval information 311 of the approval request. It is displayed on the output device (step 401).

Further, in response to the information input request for the approval document from the input device 111, the database system 101 is accessed through the communication line 100 and the applicant information 321.
(Step 402), Application Summary 331 (Step 40
3), transaction status 341 (step 404) and credit inquiry information 351 (step 405) are sequentially input and displayed.

Next, the opinion of the creator for the created document is input and displayed in the creator's opinion entry field 361 (step 406).

When the created approval request is completed, the created approval request is stored in the document database 105 as a "circulation to examiner" document (step 407). If not completed, it is stored in the storage device of the computer 111 (step 408).

FIG. 5 is a computer 12 for document examination according to this embodiment.
It is a figure which shows the processing flow of 1.

The computer 121 for document examination accesses the database system 101 via the communication line 100 in response to a request for displaying the approval document from the examiner, and inputs the information of the prepared document from the document database 105 (step 50).
1), electronic form 3 on the display device of the document examination computer 121
Output as 00 (step 502).

Further, the database system 101 is accessed through the communication line 100, the contents of the update information database 104 are input, and if there is update information regarding the relevant document, it is displayed on the output device 121 (step 50).
3). This step 503 corresponds to the update information display means 180.

Next, the examiner's opinion on the displayed document is input and displayed in the examiner's opinion entry field 362 (step 504).

If the examination result is "OK", it is stored in the document database 105 of the database system 101 as a document for "circulation to the approver" (step 505).
If the examination work result is "rejected", it is stored as a "return to creator" document (step 506).

FIG. 6 is a diagram showing a processing flow of the document approval computer 131.

Processing flow 60 of the document approval computer 131
1 to 604 are the same except that the processing flow of the document examination computer 121 and the opinion entry field for the approver are different.

If the approval result is "approval", it is stored in the document database 105 of the database system 101 as a document "end of approval" (step 605). In addition,
If the approval result is "reject", the document is stored as a "return to creator" document (step 606).

Next, the display of the electronic form having the update information (update information display means 180) on the display devices of the computers 121 and 131 described above will be described with reference to FIGS. 7A and 7B.
Will be explained.

In FIG. 7, 700 is an electronic form 300 having update information, 701 is a command line, 702 is an upper display area of the electronic form 300, 703 is a screen division line, and 704 is a lower display area of the electronic form 300. is there.

A display area 704 at the bottom of the electronic form 300
Has an area 741 for displaying update information, in which there is an update information display area 742 displaying the update information of the transaction information 341, a scroll bar 743 for displaying the update information, and a transition of the update information up to the present. There is a button 744 for displaying a graph.

On the scroll bar 743, creation, examination,
View the approval index.

The examiner or approver is the computer 121,
By inputting the position of the knob of the scroll bar 743 from 131, the update information at that time can be displayed.

Further, the buttons 7 from the computers 121 and 131
By inputting the position of 44, it is possible to display the graph 745 of the transition of the update information up to the present as shown in FIG. 7B.

The update information is displayed on the display devices 121 and 131 as shown in FIG. 7 (A) in the vicinity of the relevant information, and the update data is underlined and emphasized.

Next, the processing of the database system for supplying data to the computers 111, 121 and 131 will be described with reference to FIGS.

FIG. 8 is a diagram showing a processing flow of the database system 101.

The database system 101 inputs an access request for the database 102 (step 801).

If the access request is "reference", the reference content is retrieved (step 802), the reference content is output to the reference request source through the communication line 100 (step 803), and the reference content database 103 is shown in FIG. The contents are stored (step 804). This step 804 corresponds to the reference content storage means 160 of this embodiment.

If the access request is "update", the update contents are first updated in the data of the database 102 (step 805), and then the reference contents database 10 is updated.
3 is input, and it is checked whether or not it is a data update of the referred information (step 806). If it is an update of the referred information, the update data is referred to as the post-reference update content,
The contents shown in FIG. 10 are registered in the update history database (step 807). This step 806 and step 8
07 corresponds to the update history storage unit 170 of this embodiment.

If the access request has been examined, the reference content relating to the relevant document is deleted from the content of the reference content database 103 (step 808) and the non-updatable attribute is stored in the relevant document of the document database 105 (step 809). ).

Next, the above-mentioned reference content database 10
3. The contents of the update history database 104 will be described.

FIG. 9 is a diagram showing the contents of the reference contents database 103 of this embodiment.

In FIG. 9, 910 is a document number and 920 is a document number.
Is a reference time, 930 is a referenced database, 940 is a reference key, and 950 is a reference item.

Here, 901 is the document number "94-123".
Reference time "97071" in creating the document "456"
41300 ”Reference database“ Customer database ”
Indicates that the information of the reference item “name, address, work place, annual income” is referred to by the reference key “customer No. = 123456”.

FIG. 10 is a diagram showing the contents of the update history database 104 of this embodiment.

In FIG. 10, 1010 is the document number, 1
Reference numeral 020 indicates update time, 1030 indicates updater, 1040 indicates update database, 1050 indicates update key, and 1060 indicates update content.

Here, 1001 is the document number "94-12"
"Transaction database" referenced in 3456 "document creation
"Customer No. = 123456" information updated by "14"
1 ”, the liquidity balance at the update time“ 9407151000 ”. It indicates that the latest balance is updated to 300,000 ". The updater" 141 "indicates the transaction information input device. Reference numerals 1001 to 1003 indicate the update information display area 742 of FIG. It is an example of the information displayed on the graph of (B).

The effects of the loan examination business system of this embodiment will be described below.

In the present embodiment, in the loan examination business of the financial industry, the information changed during document preparation, examination, and approval is automatically stored, so that it is changed during document preparation, examination, and approval. Information can be grasped efficiently.

In particular, in the present embodiment, since the history information of only the information referred to at the time of creation is stored in the update history database 104, compared to the case where all the update information is stored in the update history database 104, Since the amount of data is small, the update information search time is short.

As a result, the response time is shortened and the work efficiency of examination and approval work is improved.

In this embodiment, the update history is taken,
Since the information of the document created by the worker is not automatically updated, it is possible to leave the criteria and the situation of the document creator at the time of creation, and improve the accuracy of examination approval.

Further, the scroll bar 743 indicates the judgment criteria and the situation of the document creator at the time of preparation and the examiner at the time of screening.
You can search and display efficiently. In the present embodiment, by referring to the update information displayed in 742 from the opinion 361 “Plan housing and car” input by the creator, it is examined and approved that “liquidity. Latest balance” is decreasing. You can check at the time.

Further, in this embodiment, the information updater 74
Since 1 is also displayed, by checking the updater,
It is also possible to check whether there is any inappropriate information update, and it is possible to ensure consistency in the examination contents.

Next, a modification of this embodiment will be described.

In the above-described embodiment, the database system 101 has a device configuration composed of one computer, but it may be realized by using a plurality of computers.
This will be described with reference to FIGS. 11 and 12.

FIG. 11 is a block diagram for explaining the structure of a loan screening operation support system that forms a database system from two computers.

Computers 111, 121 and 13 shown in FIG.
Processing contents of 1, database 102, 103, 104, 1
The storage contents of 05 are the same as in the previous embodiment.

In FIG. 11, reference numeral 1111 indicates a database system provided with information management means, and reference numeral 1211 indicates a workflow database system provided with a reference content storage means 160 for processing reference update history contents of a document and an update history storage means 170, respectively. .

FIG. 12A shows the database system 11
11, FIG. 12B shows the processing flow of 1121.

An access request to the database 102 is input to both computers of the database system 1111 and the workflow database system 1121 through the communication line 100 (step 1211, step 1221) and processed in parallel.

If the access request is "reference", the database system 1111 retrieves the reference content (step 1212) and outputs the reference content to the reference request source through the communication line 100 (step 1213). The access request is "
If it is "update", the data of the database 102 is updated with the updated content (step 1214).

Workflow database system 11
If the access request is “reference,” 21 stores the content shown in FIG. 9 in the reference content database 103 (step 1222). This step 1222 corresponds to the reference content storage means 160.

If the access request is "update", it is checked whether the data of the referred information is updated (step 1
223), if it is an update of the referred information, the update data is registered in the update history database as an update history (step 1224). The steps 1223 and 1224 correspond to the update history storage means 170.

If the access request has been examined, the reference content relating to the relevant document is deleted from the content of the reference content database 103 (step 1225), and the examination operation is completed and the non-updatable attribute is assigned to the relevant document in the document database 105. It is stored (step 1226).

When the database system is realized by using a plurality of computers in this way, the reference update process of the database system and the process of storing and checking the reference contents and the contents of the update history can be performed in parallel, so that the processing time is shortened. To be done.

Further, since the database system 1111 is composed only of processing such as reference updating, it is not necessary to store or check the reference contents and the contents of the update history when the examination document is created.

Further, the load on the database system 1111 is reduced, and the access processing of frequently accessed transaction information can be speeded up. Moreover, since only the data access processing provided by the existing database system is performed, the existing database system can be used.

Although the loan examination work support system of the present embodiment has been described above, the present invention is not limited to this and is applied and applied as follows.

1. In this embodiment, the device configuration is composed of three computers for document preparation, examination and approval.
It can be realized with one, two, or four or more computers.

2. In this embodiment, there are three steps: creation, examination, and approval.
Although it was a business flow of one process, it was created and examined 2
It also applies to one process, or to the workflow of four or more processes such as creation, review, headquarters review, and approval.

3. In this embodiment, the update information is output in the examination and approval process, but a processing step for outputting the update information is added to the creation process,
Information that is updated during document creation can be displayed, changes in information can be grasped during document creation, and the accuracy of created documents can be improved.

4. In this embodiment, the update history regarding transaction information and customer attributes is displayed, but the update history regarding the contents of the opinion entry fields 361, 362, 363 of the creator, the examiner, and the approver is also displayed. It can store and display the progress of the opinion of the person in charge during the process of preparation, examination and approval.

5. In this embodiment, the data is updated every time the data is updated. However, all the updates are stored, and the update of the information referred to when the access is not frequent is checked and updated. The history can also be registered in the update history database.

6. In the workflow database system 1121 of the present embodiment, the file patrol means (not shown) for referencing the reference contents registered in the database system 1111 at regular time intervals to check whether there is update data or not. ), The workflow database system can reduce the processing load of checking the contents of successive updates, prioritize the display registration process of examination documents, and improve the efficiency of document creation, examination, and approval work. .

In the present embodiment, the one that supports the work of preparing, examining, and approving documents relating to financing and lending in the financial industry has been taken up, but a plurality of documents such as deposits, documents relating to interest rate determination in deposits, etc. It is also applicable to those who support the work of document preparation, examination, and approval by workers.

The inventions made by the present inventor are as follows.
Although the present invention has been specifically described based on the above-mentioned embodiments, the present invention is not limited to the above-mentioned embodiments, and it goes without saying that various modifications can be made without departing from the scope of the invention.

[0100]

The effects obtained by the typical ones of the inventions disclosed in the present application will be briefly described as follows.

Since the operation is performed so as to display the updated information during the preparation of the document, the examination, and the approval, the examiner and the approver can check the updated information for accurate examination and approval.

Also, since the update history is stored only for the content of the information or the data item referred to in the document preparation, the storage capacity of the update history is reduced and the search time for the history information is reduced. It is possible to shorten the time until the history information is displayed.

[Brief description of drawings]

FIG. 1 is a diagram for explaining a configuration of a loan screening operation support system that is an embodiment of the present invention.

FIG. 2 is a diagram showing a work flow of a loan approval work in the loan examination work support system of the present embodiment.

FIG. 3 is a diagram showing an electronic voucher showing the approval request of the present embodiment.

FIG. 4 is a diagram showing a processing flow of a document creation computer 111 of this embodiment.

FIG. 5 is a diagram showing a processing flow of the document examination computer 121 of this embodiment.

FIG. 6 is a diagram showing a processing flow of a document approval computer 131 of this embodiment.

FIG. 7 is a diagram showing a display example of update contents of information registered as reference contents in the present embodiment.

FIG. 8 is a process flow diagram of the database system of the present embodiment.

FIG. 9 is a diagram showing an example of reference contents registered in the database system of this embodiment.

FIG. 10 is a diagram for explaining the configuration of a loan screening operation support system that is an embodiment of the present invention.

FIG. 11 is a diagram for explaining the configuration of a loan screening operation support system which is another embodiment of the present invention.

FIG. 12 is a process flow diagram of the database system and the workflow database system of the present embodiment.

[Explanation of symbols]

100 ... Communication line, 101 ... Workflow database system, 102 ... Customer DB, loan application DB, transaction D
B, external inquiry DB, 103 ... Reference DB, 104 ... Customer D
B, 105 ... Document DB, 111 ... Document creation computer, 1
21 ... Calculator for document examination, 131 ... Calculator for document approval,
150 ... Information management means, 160 ... Reference content storage means, 1
70 ... Update history storage means, 180 ... Update information display means.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Atsushi Tanaka 1099, Ozenji, Aso-ku, Kawasaki-shi, Kanagawa Inside Hitachi Systems Development Laboratory, Ltd. Information Systems Division, Hitachi, Ltd.

Claims (5)

[Claims] 1. An information management system comprising a storage device for storing information required for preparing examination documents and the prepared examination documents, and information management means for performing information management such as search, update, reference, and deletion of the information. Information provided with a device and a means for accessing the information management device to perform an inspection document creation based on the obtained information, an examination of the created examination document, and an examination work of approval of the examination document In an examination work support system composed of a display / editing device and a communication line connecting both of these devices, a reference content storage for storing the contents of information referred to by the information display / editing device when the examination document is created or updated. Means, and with the update of the information stored in the reference content storage means,
The information management device is provided with an update history storage unit for storing the update content, and when the content of the information referred to at the time of creating the examination document is updated at the time of examination or approval, the information referred to at the time of creation is updated. An examination work support system, characterized in that the information display editing device is provided with update information display means for displaying the information. 2. The examination service support system according to claim 1, wherein the update information display means displays the update information by emphasizing it by changing a display color or adding an underline,
Alternatively, the examination work support system is provided with means for displaying the update information near the data item of the update information. 3. The examination work support system according to claim 1, wherein the update information display means has a scroll bar indicating the passage of time using the creation, examination, and approval as indexes, and the update information is displayed by the operation. An examination work support system characterized by having means for displaying. 4. The examination work support system according to claim 1, wherein the reference content storage means, the update history storage means, and the information management means each have their own processors. Examination work support system. 5. The examination work support system according to claim 1, wherein whether or not the information stored in said reference content storage means has been updated is determined at an arbitrary time interval or with a low information reference / update frequency. An examination work support system characterized by being equipped with a file patrol means for checking in time zones.