JP2008003795A - System, method and program for supporting deadline management - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To avoid redundant investigation requests for the same commodity if necessary and to organize investigation requests from the viewpoint of a reply deadline so as to propose an answering operation that is easy for the investigator. <P>SOLUTION: A system 100 comprises: an investigation request accepting part 110 for storing investigation request data including information on reply deadlines in an investigation request table, together with the acceptance periods for requests: a filter part 111 for specifying the same commodity IDs in the investigation request data as redundant commodity IDs, and storing them in a memory, together with information on the reply deadlines; a first deadline determining part 112 for determining the earliest reply deadline as the first reply deadline between the earliest reply deadline and a reply deadline extracted from a status table; a reply deadline calculating part 113 for calculating a reply limit deadline for which an extra period for replies has elapsed since the first acceptance period for investigation requests; a deadline setting part 114 for comparing the reply limit deadline with the first reply deadline, and setting the reply deadline that corresponds to the redundant commodity IDs as the first reply deadline or the reply limit deadline; and a prompting part 115 for detecting a setting event of the reply deadline in the status table, and sending a reply request to a customer user terminal 300. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a deadline management support system, a deadline management support method, and a deadline management support program, and more particularly to a green procurement information system that collects chemical substance information of purchased parts, and in particular, a part procured by an operator. -It relates to technology for managing environmental impact information in unit parts, assemblies and materials.

A system is disclosed in which a response request for the content of a chemical substance in a purchased part is transmitted to the purchaser of the purchased part constituting the product in accordance with a survey request from the product delivery destination (see Non-Patent Document 1). .
Edited by the Green Procurement Survey Standardization Council “Green Procurement Practices Guidelines for Standardization of Green Procurement Surveys for Components for Electrical and Electronic Equipment” published by the Japan Association for Industrial Environment Management, September 20, 2003, pages 20-101

  Conventionally, it has been premised that information on component specifications and the like has already been investigated at the time the designer needs information such as the design stage. However, due to the strengthening of environment-related laws and regulations such as the RoHS directive (Restriction of Hazardous Substance) in the EU, only specification information is available for products already on the market at this stage or for parts in products subject to new design. In addition, environmental information was newly asked.

  This environmental information is information such as whether or not prohibited / regulated substances are contained in the parts. These laws and regulations have made it necessary to manage chemical substances contained in products, and many follow-up survey requests have been concentrated on parts manufacturers and trading companies.

  The investigation level regarding the contained chemical substances such as parts to be investigated varies depending on the parts user, but the same parts are often asked by different users. In addition, different part numbers may be used for the same product, and when investigating the chemical substances contained in one part, the part may have already been investigated in the chemical substance investigation for the other part. . Under such circumstances, the parts manufacturers, trading companies, and the like frequently encounter survey requests from a plurality of users for the same product.

  Thus, by confirming the survey status of the same product, it becomes possible to prevent the above-described duplicate survey requests. However, even if it is a duplicate request, if the response deadline for a later survey request is earlier than the response deadline for a previously requested survey request, it is necessary to cancel the previous survey request and consider a new response deadline There is.

  On the other hand, if the parts manufacturer or trading company has begun preparing for the survey according to the response deadline for the previously received survey request, it is not always possible to respond immediately in response to the deadline that has been brought forward. This is because the survey is based on factors such as the type of product or part for which the survey was requested, the past performance of similar parts, the characteristics of the part, the depth of the part configuration, the number of child parts, the number of survey items, and the type of survey item. This is because the number of days required for this is different. Therefore, when considering measures for accelerating the reply deadline, it is necessary to optimize the deadline management so that the parts manufacturer and trading companies have a reasonable reply deadline.

  Therefore, the present invention has been made in view of the above-described problems, and appropriately suppresses duplication of survey requests for the same product, organizes the survey requests from the viewpoint of the response deadline, and makes it easy for the survey execution side to do the answering work without difficulty. An object is to provide a deadline management support system, a deadline management support method, and a deadline management support program that can be proposed.

  The deadline management support system of the present invention is a system for managing a survey request including a reply deadline for a product, and manages information on the reply deadline for the survey request for each product ID of the product targeted for each survey request. A user of the product includes a status table, a survey request table that stores data of the survey request, a response margin storage table that stores a response margin period necessary for processing the survey request for each product ID of each product, and Survey request data including response deadline information from the delivery destination user terminal is received via the network, and this is stored in the survey request table together with the request acceptance time, and stored in the survey request table. Each survey request data is read, and the survey request data with a common product ID is identified as a duplicate product ID. A filter unit that stores the duplicate product ID and information on the response deadline associated with each survey request data including the duplicate product ID in the memory, and information on the reply product ID and the reply deadline for each survey request data from the memory And extracting the answer deadline information corresponding to the read duplicate product ID from the status table, and the earliest answer deadline from the answer deadline information for each survey request data read from the memory The earliest answer deadline between the earliest answer deadline and the answer deadline extracted from the status table as the earliest answer deadline, and the duplicate product ID From the survey request table, the reception time of the first request received from the survey request table is extracted as the initial reception time, and this initial request is received. From the time, the response limit deadline that the response margin period of the corresponding duplicate product ID read from the response margin storage table has passed is compared, the response time limit calculation unit, the response limit time limit and the earliest response time limit, If the earliest answer deadline is after the answer limit deadline, the answer deadline corresponding to the duplicate product ID in the status table is set as the earliest answer deadline, and if the earliest answer deadline is before the answer limit deadline, A response time limit setting unit for setting a response time limit corresponding to the duplicate product ID in the status table as the response time limit time limit, and detecting a response time limit setting event in the status table, and corresponding information on the set response time limit And a prompting unit that transmits a response request including the product ID to a supplier user terminal included in the provider of the corresponding product via the network.

  Further, in the time limit management support system, the advance limit storage table storing the limit period of the search request advance processing for each product ID of each product, and information on the response time limit for each duplicate product ID and each survey request data from the memory And extracting the answer deadline information corresponding to the read duplicate product ID from the status table, and the earliest answer deadline from the answer deadline information for each survey request data read from the memory And calculating the time difference between the earliest answer deadline and the answer deadline extracted from the status table, the calculated period difference, and the corresponding in the forward limit storage table The product ID is compared with the advance limit period, and in the status table according to the comparison result between the difference and the predetermined value. A deadline setting unit that stores in a memory the latest due date of the corresponding product ID as a latest deadline for the corresponding product ID, the deadline setting unit, The response limit time limit is compared with the latest response time limit of the memory, and if the latest response time limit is after the response limit time limit, the response time limit corresponding to the duplicate product ID in the status table is set as the latest response time limit. If the earliest answer deadline is before the answer limit deadline, the answer deadline corresponding to the duplicate product ID in the status table may be set as the answer limit deadline.

  In the time limit management support system, from the supplier user terminal that has received the answer request, the response information for the survey request obtained at the supplier user terminal is received, and this is registered in the answer information table, It is good also as providing an answer acquisition part which updates and registers an answer situation to a record of applicable merchandise ID in the status table.

  Further, in the time limit management support system, in response to a browsing request from the delivery destination user terminal or the supplier user terminal, the storage information in the status table is output to the delivery destination user terminal or the supplier user terminal. A part may be provided.

  In the time limit management support system, the survey request may be a request for a survey of chemical substance information contained in a target product with a response time limit.

  In the time limit management support system, any variable information that is at least one of the number of component parts of the product, the characteristics of the contained chemical substance, and the number of contained chemical substances and the attribute of the variable information are below a certain level. The answer margin period is the same for the first attribute level and the first attribute margin period at the first attribute level, and the variable information attribute is at or above a certain level. From the variable information table, a level acquisition unit that receives the second response margin period at the second attribute level and the second attribute level at which the period does not change from the supplier user terminal or the input interface and stores it in the variable information table, The information on the first attribute level and the first answer margin period and the second attribute level and the second answer margin period is read, and the first answer margin period and the first answer margin period The change in the response margin period according to the attribute level between the response margin period and the response level is estimated as a function including the attribute level as an argument and the first and second response margin periods in the response value, and the function is stored in the memory. From the function estimation unit and the survey request data of the survey request table, extract information on the target product as attribute level information of the variable information, and apply the information on the target product to the function of the memory, An answer margin period may be provided, and an answer margin period setting unit that stores the answer margin period calculated here for each product ID of the corresponding product in the answer margin storage table may be provided.

  In the time limit management support method of the present invention, a computer that manages a survey request including a response time limit for a product manages information on the response time limit for the survey request for each product ID of the product that is the target of each survey request. Use of the product, comprising a status table, a survey request table for storing the data of the survey request, and a response margin storage table for storing a response margin period required for processing the survey request for each product ID of each product Processing to receive survey request data including answer deadline information from the delivery destination user terminal provided by the person via the network, and store it in the survey request table together with the request acceptance time, and stored in the survey request table Each survey request data is read, and from this survey request data, those with a common product ID are identified as duplicate product IDs. The process of storing in the memory the duplicate product ID and the response deadline information associated with each survey request data including the duplicate product ID, and reading the duplicate product ID and the answer deadline information for each survey request data from the memory The response deadline information corresponding to the read duplicate product ID is extracted from the status table, and the response deadline information for each survey request data read from the memory is the one with the earliest answer deadline. Identifying and processing the earliest answer deadline as the earliest request deadline between the earliest answer deadline and the answer deadline extracted from the status table, and the first of the survey requests corresponding to the duplicate product ID From the survey request table as the initial reception time, and from the initial reception time, The process of calculating the response limit time limit when the response margin period of the corresponding duplicate product ID read from the table has passed is compared with the response limit time limit and the earliest request time limit, and the earliest request time limit is after the response limit time limit For example, if the reply deadline corresponding to the duplicate product ID in the status table is set as the earliest request deadline, and the earliest request deadline is before the reply limit deadline, the reply corresponding to the duplicate product ID in the status table A process for setting a deadline as the response limit deadline and a response deadline setting event in the status table, and sending a reply request including the set reply deadline information and the corresponding product ID to the provider of the corresponding product And a process of transmitting via a network to a supplier user terminal included in the system.

  In addition, the deadline management support program of the present invention manages a survey request including a reply deadline for a product, and manages information on a reply deadline for the survey request for each product ID of a product targeted for each survey request. A user of the product in a computer comprising: a survey request table for storing data of the survey request; and a response margin storage table for storing a response margin period required for processing the survey request for each product ID of each product Receiving survey request data including response deadline information from the delivery destination user terminal included in the network and storing it in the survey request table together with the request acceptance time; and storing in the survey request table Each survey request data is read, and among these survey request data, those with a common product ID are identified as duplicate product IDs. Storing the duplicate product ID and information on the response deadline associated with each survey request data including the duplicate product ID in the memory, and information on the duplicate product ID and the response deadline for each survey request data from the memory. And extracting the answer deadline information corresponding to the read duplicate product ID from the status table, and the earliest answer deadline from the answer deadline information for each survey request data read from the memory And identifying the earliest reply deadline as the earliest request deadline between the earliest reply deadline and the reply deadline extracted from the status table, and a survey request corresponding to the duplicate product ID The first received date is extracted from the survey request table as the first received time, and from the first received time A step of calculating an answer limit deadline in which the answer margin period of the corresponding duplicate product ID read from the answer margin storage table has passed is compared with the answer limit deadline and the earliest request deadline, and the earliest request deadline is the answer limit. If it is after the deadline, the reply deadline corresponding to the duplicate product ID in the status table is set as the earliest request deadline, and if the earliest request deadline is before the reply limit deadline, the duplicate product ID in the status table The response deadline corresponding to the step is set as the response limit deadline, the response deadline setting event in the status table is detected, and the reply request including the set reply deadline information and the corresponding product ID Transmitting to a business partner user terminal provided in the product provider via a network.

  In addition, the problems disclosed by the present application and the solutions thereof will be clarified by the embodiments of the present invention and the drawings.

  According to the present invention, it is possible to appropriately suppress duplication of survey requests for the same product, organize the survey requests from the viewpoint of the response deadline, and propose an unreasonable response work to the survey execution side.

--- System configuration ---
Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a network configuration diagram including a time limit management support system according to the present embodiment. The deadline management support system 100 (hereinafter, system 100) in the present embodiment is a product (various industrial products, etc.) that needs to collect information on contained chemical substances based on, for example, the EU's RoHS (Restriction of Hazardous Substance) commander Assuming a system that manages survey requests for information on chemical substances contained, including the response deadline. Further, this system 100 is located between a delivery destination user terminal 200 that sends out the survey request and a supplier user terminal 300 that is provided by a sales source of the target product of the survey request, for example, an undetermined survey for the same product. In addition to suppressing requests, the survey requests can be organized from the viewpoint of response deadlines, and a reasonable response work can be proposed to the customer user on the survey execution side.

  Of course, this embodiment is an example, and for the inquiry about the same product transmitted from a plurality of requesters, the inquiry is answered by filtering the inquiry based on the answer deadline specified there. The present invention can be applied to any situation as long as the deadline management is performed.

  The system 100 reads the program 102 stored in the program database 101 such as a rewritable memory into the memory 103 and executes it by the CPU 104 as an arithmetic unit in order to realize the function of executing the term management support method of the present invention.

  In addition, the system 100 includes data between the input interface 105 such as various keyboards and buttons generally provided in the computer device, the output interface 106 such as a display, and the delivery destination user terminal 200 or the customer user terminal 300. A communication unit 107 that performs transmission and reception is provided.

  The system 100 uses the communication means 107 to connect to the customer user terminal 200 or the customer user terminal 300 via a network 140 such as the Internet, a LAN, or a serial interface communication line, and execute data exchange.

  Next, functional units that are configured and held by the system 100 based on the program 102 will be described. It is assumed that the system 100 can use a status table 125, a survey request table 126, a response margin storage table 127, a forward limit storage table 128, a response information table 129, and a variable information table 130.

  The system 100 receives the survey request data including the response deadline information from the delivery destination user terminal 200 provided by the user of the product via the network 140, and receives the survey request data together with the request reception timing with the survey request table 126. The survey request accepting unit 110 is stored. The survey request may be a request for a survey of chemical substance information contained in the target product with a reply time limit.

  In addition, the system 100 reads each survey request data stored in the survey request table 126, identifies a common product ID among the survey request data as a duplicate product ID, A filter unit 111 is provided that stores, in the memory 103, response time limit information associated with each survey request data including the duplicate product ID.

  Further, the system 100 reads the duplicate product ID and the answer deadline information for each survey request data from the memory 103 and extracts the answer deadline information corresponding to the read duplicate product ID from the status table 125. And specifying the earliest answer deadline from the answer deadline information for each survey request data read from the memory 103, and the earliest answer deadline and the answer deadline extracted from the status table 125, The earliest answer deadline determination unit 112 is provided for judging the earliest answer deadline as the earliest answer deadline. Further, the system 100 extracts from the survey request table 126 the reception time of the first search request corresponding to the duplicate product ID as the initial reception time, and from the initial reception time, the response margin storage table The response time limit calculation unit 113 for calculating the response time limit for which the response margin period of the corresponding duplicate product ID read from 127 has passed is provided.

  Further, the system 100 compares the response limit time limit with the earliest response time limit, and if the earliest response time limit is after the response limit time limit, the system 100 sets the response time limit corresponding to the duplicate product ID in the status table 125. A time limit setting unit 114 that sets the first response time limit and sets the response time limit corresponding to the duplicate product ID in the status table 125 as the response time limit if the first response time limit is before the response time limit. Prepare.

  Further, the system 100 detects a response deadline setting event in the status table 125, and the supplier of the corresponding product has a response request including the set response time limit information and the corresponding product ID. A prompting unit 115 that transmits to the user terminal 300 via the network 140 is provided.

  Further, the system 100 reads the duplicate product ID and the answer deadline information for each survey request data from the memory 103 and extracts the answer deadline information corresponding to the read duplicate product ID from the status table 125. And specifying the earliest answer deadline from the answer deadline information for each survey request data read from the memory 103, and the earliest answer deadline and the answer deadline extracted from the status table 125, It is good also as providing the period calculation part 116 which calculates the period difference between.

  Further, the system 100 compares the calculated period difference with the advance limit period of the corresponding product ID in the advance limit storage table 128, and according to the comparison result between the difference and a predetermined value, the status table 125 It is good also as providing the time limit determination part 117 which memorize | stores the date which subtracted the said period difference or the said advance limit period from the reply deadline of applicable product ID in memory 103 as the latest reply deadline of applicable product ID.

  In this case, the time limit setting unit 114 of the system 100 compares the response limit time limit with the latest response time limit of the memory 103, and if the latest response time limit is after the response limit time limit, The reply deadline corresponding to the duplicate product ID is set as the latest reply deadline, and if the earliest reply deadline is before the reply limit deadline, the reply deadline corresponding to the duplicate product ID in the status table 125 is set as the reply limit. The deadline will be set.

  Further, the system 100 receives response information for the survey request obtained at the supplier user terminal 300 from the supplier user terminal 300 that has received the answer request, and registers this in the answer information table 129. The response acquisition unit 118 that updates and registers the response status in the record of the corresponding product ID in the status table 125 may be provided.

  Further, the system 100 outputs the stored information in the status table 125 to the delivery destination user terminal 200 or the supplier user terminal 300 in response to a browsing request from the delivery destination user terminal 200 or the supplier user terminal 300. The status output unit 119 may be provided.

  In addition, the system 100 includes variable information that is information on at least one of the number of component parts of a product, characteristics of contained chemical substances, and the number of contained chemical substances, and any level if the attribute of the variable information is below a certain level. Even if the response margin period does not change, the first response level at the first attribute level and the first attribute level, and the answer margin period at any level as long as the attribute of the variable information is higher than a certain level. The second attribute level and the second response margin period at the second attribute level that are not changed may be received from the supplier user terminal 300 or the input interface 105 and stored in the variable information table 130.

  In addition, the system 100 reads information on the first attribute level, the first response margin period, the second attribute level, and the second response margin period from the variable information table 130, and the first response margin period and the second response margin period. A change in the answer margin period according to the attribute level between the answer margin period and the answer level is estimated as a function including the attribute level as an argument and the first and second answer margin periods in the answer value, and the function is stored in the memory 103. The function estimation unit 121 may be provided.

  Further, the system 100 extracts information on the target product as the attribute level information of the variable information from the survey request data in the survey request table 126, and applies the information on the target product to the function of the memory 103. The answer margin period setting unit 122 may be provided that calculates the answer margin period and stores the answer margin period calculated here for each product ID of the corresponding product in the answer margin storage table 127.

  Further, the delivery destination user terminal 200 and the supplier user terminal 300 are computers having the same general configuration as the system 100 described above. Accordingly, it is assumed that the same hardware configuration as that of the system 100 and the like is provided.

  Note that each of the functional units 110 to 122 in the system 100 shown so far may be realized as hardware, or may be realized as a program stored in an appropriate storage device such as a memory or an HDD (Hard Disk Drive). Good. In this case, the CPU 104 reads the corresponding program from the storage device into the memory 103 and executes it in accordance with the execution of the program.

  The network 140 is not limited to the Internet, LAN, ATM line, dedicated line, WAN (Wide Area Network), power line network, wireless network, public line network, mobile phone network, serial interface communication line, etc. A network can also be adopted. If a virtual private network technology such as VPN (Virtual Private Network) is used, communication with improved security is established when the Internet is adopted. The serial interface is a serial transmission that sends data one bit at a time using a single signal line, and refers to an interface for connecting to external devices. Communication methods include RS-232C, RS-422, IrDA, USB, IEEE1394, fiber channel, etc. can be assumed.

--- Example of table structure ---
Next, the structure of the table used by the system 100 in this embodiment will be described. FIG. 2 is a diagram showing examples of data structures of (a) status table 125, (b) survey request table 126, and (c) answer margin storage table 127 in the present embodiment.

  The status table 125 is a table that manages information on the response deadline for a survey request for each product ID of a product that is the subject of each survey request, and makes it possible to grasp the status of responses to the survey request. This status table 125 is, for example, a collection of records associated with data such as a decision response deadline 2002 and a reply status (during reply, reply completed, expired) 2003 using a part number (partner product number) 2001 as a key. Yes.

  Further, the survey request table 126 is a table that stores the data of the survey request in association with the information of the request reception timing, for example, in the order requested. This survey request table 126 uses the survey ID 10001 as a unique number of the survey request as a key, a trading company code 1002, a part number (partner product number) 1003 that is a product ID for specifying the survey target product, a survey request date ( Survey request time) 1004, and a collection of records associated with data such as a response deadline 1005 to a business partner (a manufacturer or a trading company that delivers the product to a delivery destination user).

  The response margin storage table 127 is a table for storing a response margin period necessary for the processing of the survey request for each product ID of each product. This answer margin storage table 127 is a collection of records in which data such as a trading company code 1502 and answer margin days 1503 (periods) are associated using a part number 1501 as a product ID as a key. Regarding the answer margin period 1503 stored in the answer margin storage table 127, it can be assumed that information is acquired from the supplier user terminal 300 or the input interface 105 in advance. Alternatively, it can be assumed that the answer margin period calculated by the processing executed by the level acquisition unit 120, the function estimation unit 121, and the answer margin period setting unit 122 is stored in the answer margin storage table 127.

  FIG. 3 is a diagram showing examples of data structures of (a) the forward limit storage table 128, (b) the answer information table 129, and (c) the variable information table 130 in the present embodiment.

  The advance limit storage table 128 is a table that stores the limit period of the advance processing of the survey request for each product ID of each product. The advance limit storage table 128 is, for example, a collection of records in which data such as a trading company code 3002, a first response deadline 3003, and a limit limit days 3004 are associated with a part number (partner product number) 3001 as a key. . As for the advance deadline days 3004, the feasible advance days are calculated in advance by using a statistical method for the reply history information 4007 of the parts whose past results are stored in the answer information table 129 or similar parts. , Registered.

  The answer information table 129 is a table for storing answer information received from the supplier user terminal 300 in response to the survey request. The answer information table 129 is, for example, using a part number 4001 as a key, a trading company code 4002, part information 4003, configuration information 4004 such as the number of subparts, contained substance information 4005, answer status 4006, answer history information 4007, answer margin. It is an aggregate of records associated with data such as a period 4008.

  In addition, the variable information table 130 is variable information that is acquired from the supplier user terminal 300 or the input interface 105 and is information on at least one of the number of component parts of the product, the characteristics of the contained chemical substances, and the number of contained chemical substances. If the attribute of the variable information is below a certain level, the answer margin period does not change at any level, the first answer margin period at the first attribute level, and the variable information attribute This is a table for storing information on the second response level and the second response margin period at the second attribute level, which does not change the response margin period at any level. This variable information table 130 includes a collection of records associated with data such as a first attribute level 3502, a first response margin period 3503, a second attribute level 3504, and a second response margin period 3505 using the trading company code 3501 as a key. It has become.

--- Processing flow example 1 ---
Hereinafter, the actual procedure of the term management support method in the present embodiment will be described with reference to the drawings. Of the various operations corresponding to the term management support method described below, those related to the system 100 are realized by a program 102 that the system 100 reads into the memory 103 and executes. And this program 102 is comprised from the code | cord | chord for performing the various operation | movement demonstrated below. FIG. 4 is a diagram showing an example of a processing concept in the present embodiment, and FIG. 5 is a diagram showing a processing procedure example 1 of the term management support method of the present embodiment.

  In the following, the product subject to the survey request for contained chemical substance information is, for example, any one of a child part, a parent part composed of the child part, and a product composed of the parent part. Simply “parts”.

  The survey request accepting unit 110 included in the system 100 includes a survey request including a part number (product ID) of a part to be surveyed and information on a response deadline from the plurality of delivery destination user terminals 200 (200a to 200c). Data is received via the network 140 (s100). These are stored in the survey request table 126 together with the request acceptance time (s101). The survey request data stored in the survey request table 126 is collected for a certain period (for example, one day) and output to the filter unit 111 (s102). Alternatively, the filter unit 111 may access the survey request table 126 and extract the survey request data for one day.

  It is assumed that the delivery destination user terminals 200a and 200b and the like shown in FIG. 4 make a survey request with different request deadlines for the same parts at the same time. The survey requests from the delivery destination user terminals 200a and 200b are referred to as “initial survey request” in the sense of an earlier request than the delivery destination user terminal 200c. Further, it is assumed that the delivery destination user terminal 200c issues an investigation request to the same part later with a request deadline that is earlier than the two parties. The investigation request of the delivery destination user terminal 200c is assumed to be a later occurrence than the investigation request of the delivery destination user terminals 200a and 200b, and is referred to as a “subsequent investigation request”.

  In this case, for example, as shown in the situation example of FIG. 9, the survey request data of the delivery destination user terminal 200a is dated November 1, and the response deadline (December 5 for the part of part number: A-001) (It can be said that it is a mere request deadline because it is not determined by the system 100 side) (initial survey request), and the survey request data of the delivery destination user terminal 200b is dated November 1, part number: A- The survey request for the 001 part has a response deadline of December 7 (initial survey request), and the survey request data of the delivery destination user terminal 200c is the part number: A-001 dated November 15. Is a survey request with a response deadline of November 20 (subsequent survey request).

  At this time, the filter unit 111 of the system 100 specifies a search request related to the same part from among the search request data obtained from the search request table 126, that is, a search request related to the same part. Is a duplicate product ID (s103). In the above example, since the survey requests from the delivery destination user terminals 200a to 200c are all related to the part number: A-001, this is used as the duplicate product ID.

  The filter unit 111 uses the duplicate product ID “A-001” and the reply time limit information (12/5, 12/7, 11/20) associated with each survey request data including the duplicate product ID. It is stored in the memory 103 or sent to the earliest deadline determination unit 112 (s104).

  The earliest deadline determination unit 112 stores the duplicate product ID “A-001” and the response deadline information “12/5, 12/7, 11/20” for each survey request data in the memory 103 or the filter unit. 111 (s105). Further, the earliest deadline determination unit 112 has the earliest answer deadline out of the answer deadline information “12/5, 12/7, 11/20” for each survey request data, that is, the answer deadline “11 / 20 "is specified as the earliest response deadline (s106).

  In addition, the response time limit calculation unit 113 of the system 100 extracts the reception timing “11/01” of the first survey request corresponding to the duplicate product ID from the survey request table 126 as the first reception timing, From the first acceptance time “11/01”, the response limit time limit “11/30” when the response margin period “29 days” of the corresponding duplicate product ID “A-001” read from the response margin storage table 127 has elapsed is calculated. (S107).

  Subsequently, the deadline setting unit 114 of the system 100 obtains information on the earliest response deadline (obtained from the earliest deadline determination unit 112) and the answer limit deadline (obtained from the answer deadline calculation unit 113), The limit time limit “11/30” is compared with the earliest response time limit “11/20” (s108). By this comparison, the time limit setting unit 114 can determine that the earliest response time limit “11/20” is before the response limit time limit “11/30” (s108: before), so the duplicate product ID “A−” in the status table 125 is determined. The response time limit “12/5” stored corresponding to “001” is set as the response limit time limit “11/30” (s109). On the other hand, if the earliest answer deadline is after the answer limit deadline (s108: and after), the answer deadline corresponding to the duplicate product ID “A-001” in the status table 125 is set as the earliest answer deadline. (S110).

  Further, the prompting unit 115 of the system 100 detects the setting event (the step s109) of the response time limit “11/30” in the status table 125, and sets the response time limit information and the corresponding product ID “A”. -001 "is transmitted via the network 140 to the supplier user terminal 300 included in the provider of the corresponding product (s111).

  The response acquisition unit 118 of the system 100 receives response information for the survey request obtained at the supplier user terminal 300 from the supplier user terminal 300 that has received the response request, and stores the response information in the response information table 129. The response status is updated and registered in the record of the corresponding product ID “A-001” in the status table 125 (s112). When the response information is received from the supplier user terminal 300, for example, the response acquisition unit 118 updates the information regarding the response status such as “response completed” in the record of the corresponding part number in the status table 125. To do.

  In this way, the system 100 side obtains response information corresponding to the survey request, but receives a response information browsing request from the delivery destination user terminal 200 or the business partner user terminal 300. Accordingly, the status output unit 119 of the system 100 receives the browsing request from the delivery destination user terminal 200 or the customer user terminal 300 (s113), and in response thereto, stores the storage information in the status table 125 in the delivery destination. The data is output to the user terminal 200 or the supplier user terminal 300 (s114), and the process ends.

--- Processing flow example 2 ---
In addition to the above-described processing flow example 1, a processing example in consideration of the limit days in advance can be assumed in the present embodiment. FIG. 6 is a diagram illustrating a processing procedure example 2 of the time limit management support method according to the present embodiment. For the sake of simplicity, the description of the steps s100 to s104, which are the same as those in the above-described processing flow example 1, is omitted.

  The period calculation unit 116 of the system 100 reads the duplicate product ID “A-001” and the information on the response deadline “12/5, 12/7, 11/20” for each survey request data from the memory 103, Information on the response time limit “12/5” corresponding to the read duplicate product ID “A-001” is extracted from the status table 125 (s200). In addition, the period calculation unit 116 has the earliest response time limit “11/11” of the response time limit information “12/5, 12/7, 11/20” for each survey request data read from the memory 103. 20 ”is specified, and the difference between the earliest answer deadline“ 11/20 ”and the answer deadline“ 12/5 ”extracted from the status table 125 is calculated (s201). In this case, the period difference is 15 days.

  Further, the time limit determination unit 117 of the system 100 compares the calculated period difference “15 days” with the advance limit period “7 days” of the part number “A-001” in the advance limit storage table 128. (S202). Here, the time limit judging unit 117 calculates the difference between the period (15 days) and the advance limit period “7 days” of the part number “A-001” in the advance limit storage table 128 as a predetermined value. A comparison is made to recognize a comparison result that “15 days” of the difference exceeds the forward limit period “7 days” (s202: above limit). In this case, from the response deadline “12/5” of the corresponding part number “A-001” in the status table 125, assuming that the requested reply deadline is outside the allowable limit of the advance limit regarding the investigation of the relevant part, The due date “11/28” obtained by subtracting the advance limit number of days “7 days” is updated and registered in the status table 125 as the latest response deadline of the corresponding part number “A-001” (s203).

  On the other hand, it is assumed that the time difference is, for example, “5 days”. In this case, the time limit determination unit 117 determines that the comparison result between “5 days” that is the time difference and the forward limit period “7 days” of the part number “A-001” in the forward limit storage table 128 that is a predetermined value. The difference is less than the advance limit period (s202: below the limit), and a date “subtracting the period difference“ 5 days ”from the response time limit“ 12/5 ”of the corresponding part number in the status table 125 11/30 ”is updated and registered in the status table 125 as the latest reply deadline of the corresponding product ID“ A-001 ”(s204).

  Further, in this case, the time limit setting unit 114 of the system 100 includes the response limit time limit “11/30” of the part number “A-001” previously calculated by the response time limit calculation unit 113 (see step s107), The latest answer deadline “11/28” in the memory 103 is compared (s205).

  By this comparison processing, the time limit setting unit 114 determines that the earliest response time limit “11/28” is before “11/30” of the response limit time limit (s205: before), and the status table 125 is duplicated. The response time limit “11/28” corresponding to the product ID “A-001” is set as the response time limit “11/30” (s206). On the other hand, when the latest reply deadline is after the reply limit deadline (s205: and later), the deadline setting unit 114 sets the reply deadline corresponding to the duplicate product ID “A-001” in the status table 125 to The latest reply deadline “11/28” is set (s207). The subsequent processing is the processing executed by the reminder 115 of the system 100 (step s111), the processing executed by the answer acquisition unit 118 (step s112), and the status output unit shown in the processing flow example 1. It is the same as the processing (s113, s114) executed by 119.

--- Setting process for answer margin period ---
Next, the answer margin period setting process will be described. FIG. 7 is a diagram showing a processing procedure example 3 of the time limit management support method of the present embodiment. Here, the level acquisition unit 120 of the system 100 receives from the supplier user terminal 300 or the input interface 105 the number of component parts of the product, the characteristics of the contained chemical substances (which affects the amount of labor involved in the investigation), and the contained chemistry. The variable attribute that is at least one of the information on the number of substances and the first attribute level at which the response margin period does not change at any level if the variable information attribute is below a certain level and the first attribute level Accepts each information of answer margin period and second answer margin period at the second attribute level and second attribute level where the answer margin period does not change at any level as long as the variable information attribute is above a certain level And stored in the variable information table 130 (s300).

  Here, as in the example shown in FIG. 8, the variable information is the number of component parts, the first attribute level is “10”, the first response margin period is “7”, the second attribute level is “1000”, Assume that the second response margin period is “180”. At this time, the function estimation unit 121 of the system 100 determines from the variable information table 130 that the first attribute level “10” and the first response margin period “7” and the second attribute level “1000” and the second response margin period. The information “180” is read (s301). Then, the change of the response margin period “7 to 180” corresponding to the attribute level “10 <attribute level x <1000” between the first response margin period “7” and the second response margin period “180” is attributed. The number x of component parts, which is a level, is used as an argument, and the first and second answer margin periods are estimated as a function f (x) including answer values (s302).

  In the example of FIG. 8, for example, a common logarithm is assumed as the type of the function. Therefore, it is assumed that the answer margin period increases at an accelerated rate as the number of component parts increases. Of course, other function types may be assumed. For example, the system 100 can use a function table in which a function type is assigned in advance for each type of component or customer user attribute, and processing for setting a response margin period From the function table, the function type may be selected and used according to the setting processing target part or the supplier user.

For example, the function estimation unit 121 having selected the function type as the common logarithm, when the argument is the number of component parts x, x = 10, f (x) = 7, x = 1000, and f (x) = For the condition of 180, for example, it is substituted into the general formula f (x) = a × log ₁₀ (x) + b.

Then, the function estimation unit 121 obtains two formulas: 7 = a × 1 + b and 180 = a × 3 + b. When the function estimating unit 121 processes these two equations as simultaneous equations to obtain the constants a and b, a = 86.5 and b = -97.5 can be calculated. Therefore, the function f (x) can be estimated as 86.5 × log ₁₀ (x) -97.5.

The function estimation unit 121 thus estimating the function f (x) stores the function in the memory 103 (s303). Further, the response margin period setting unit 122 of the system 100 extracts information on the target product as attribute level information of the variable information from the survey request data in the survey request table 126, and uses the target product information as the information on the target product. The answer margin period is calculated by applying to the function of the memory 103 (s304). For example, it is assumed that the information on the target product is information on “number of component parts”, which is “500”. In this case, the function estimation unit 121 substitutes this “500” for the function f (x), and f (x) = 86.5 × log ₁₀ (500) −97.5 = 86.5 × 2.699-97.5 = 136. Calculated as the response margin period.

  The response margin period calculated in step s304 is stored for each product ID of the corresponding product in the response margin storage table 127 by the response margin period setting unit 122 (s305). This makes it possible to set the answer margin period.

  As described above, according to the present embodiment, in order to prevent the adverse effect of simply determining an early response deadline while preferentially considering survey requests with strict response deadlines, the response margin period and the number of days ahead The concept of By executing the deadline management support using this concept, it is possible to suppress duplication of investigation requests regarding the same parts and the like, and to reduce the burden on the investigator. Then, by making it possible to present the status of the survey request to the delivery destination user, it becomes possible to easily determine whether or not to execute the survey request in advance by visually checking the status for each part.

  Therefore, it is possible to appropriately suppress duplication of survey requests for the same product, organize the survey requests from the viewpoint of response deadlines, and propose a reasonable response work to the survey execution side.

  As mentioned above, although embodiment of this invention was described concretely based on the embodiment, it is not limited to this and can be variously changed in the range which does not deviate from the summary.

It is a network block diagram including the term management support system in this embodiment. It is a figure which shows each data structure example of (a) status table 125, (b) investigation request table 126, and (c) answer margin storage table 127 in this embodiment. It is a figure which shows each data structure example of (a) forward limit storage table 128, (b) reply information table 129, and (c) variable information table 130 in this embodiment. It is a figure which shows the example of a processing concept in this embodiment. It is a figure which shows process sequence example 1 of the time limit management assistance method of this embodiment. It is a figure which shows process sequence example 2 of the term management support method of this embodiment. It is a figure which shows process sequence example 3 of the time limit management assistance method of this embodiment. It is a figure which shows the example of a function of the answer margin period of this embodiment. It is a figure which shows the example of a condition of the reply time limit management of this embodiment.

Explanation of symbols

100 deadline management support system 101 program database 102 program 103 memory 104 CPU
105 Input Interface 106 Output Interface 107 Communication Means 110 Survey Request Accepting Unit 111 Filter Unit 112 First Deadline Determination Unit 113 Response Time Limit Calculation Unit 114 Time Limit Setting Unit 115 Reminder 116 Time Period Calculation Unit 117 Time Limit Determination Unit 118 Response Acquisition Unit 119 Status Output Unit 120 level acquisition unit 121 function estimation unit 122 response margin period setting unit 125 status table 126 survey request table 127 response margin storage table 128 forward limit storage table 129 answer information table 130 variable information table 140 network 200 destination user terminal 300 supplier User terminal

Claims (8)

A system for managing survey requests for products, including response deadlines,
A status table that manages information on the response deadline for the survey request for each product ID of the product for each survey request;
A survey request table for storing data of the survey request;
An answer margin storage table storing an answer margin period necessary for the processing of the survey request for each item ID of each item;
A survey request accepting unit that receives survey request data including information on a response deadline from a delivery destination user terminal provided by a user of the product via a network, and stores this in the survey request table together with a request acceptance time; ,
Each survey request data stored in the survey request table is read, and the survey request data having a common product ID is identified as a duplicate product ID, and each survey including the duplicate product ID and the duplicate product ID is identified. A filter unit that stores information on the response deadline associated with the request data in a memory;
The duplicate product ID and the answer deadline information for each survey request data are read from the memory, the answer deadline information corresponding to the read duplicate product ID is extracted from the status table, and each read from the memory Identify the earliest answer deadline from the answer deadline information for each survey request data, and set the earliest answer deadline between this earliest answer deadline and the answer deadline extracted from the status table The earliest deadline determination unit, which is determined as the response deadline;
Of the survey requests corresponding to the duplicate product ID, the reception time of the first received is extracted from the survey request table as the first reception time, and from the initial reception time, the corresponding duplicate product ID read from the answer margin storage table is extracted. A response time limit calculation unit for calculating a response time limit for which a response margin period has passed,
The response limit time limit is compared with the earliest response time limit, and if the earliest response time limit is after the response limit time limit, the response time limit corresponding to the duplicate product ID in the status table is set as the first response time limit. If the earliest answer deadline is before the answer limit deadline, a deadline setting unit that sets the answer deadline corresponding to the duplicate product ID in the status table as the answer limit deadline;
Detects a response deadline setting event in the status table, and sends a reply request including the set reply deadline information and the corresponding product ID to a supplier user terminal provided in the provider of the corresponding product via the network A reminder to
A deadline management support system. A forward limit storage table storing the limit period of the advance processing of the survey request for each product ID of each product,
The duplicate product ID and the answer deadline information for each survey request data are read from the memory, the answer deadline information corresponding to the read duplicate product ID is extracted from the status table, and each read from the memory Specify the earliest answer deadline from the answer deadline information for each survey request data, and calculate the time difference between this earliest answer deadline and the answer deadline extracted from the status table And
The calculated period difference is compared with the advance limit period of the corresponding product ID in the advance limit storage table, and according to the comparison result between the difference and a predetermined value, the response time limit for the corresponding product ID in the status table is A deadline determination unit that stores in a memory the latest answer deadline of the corresponding product ID, the deadline obtained by subtracting the period difference or the advance limit period;
The time limit setting unit compares the response limit time limit with the latest response time limit of the memory, and if the latest response time limit is after the response limit time limit, the response time limit corresponding to the duplicate product ID in the status table is set. The latest answer deadline is set, and if the earliest answer deadline is before the answer limit deadline, the answer deadline corresponding to the duplicate product ID in the status table is set as the answer limit deadline.
The term management support system according to claim 1 characterized by things.   From the supplier user terminal that has received the response request, the response information for the survey request obtained at the supplier user terminal is received and registered in the response information table, and the record of the corresponding product ID in the status table The time limit management support system according to claim 1, further comprising an answer acquisition unit that updates and registers the answer status.   A status output unit is provided that outputs storage information in the status table to the delivery destination user terminal or the customer user terminal in response to a browsing request from the delivery destination user terminal or the customer user terminal. Item 4. The term management support system according to any one of Items 1 to 3.   The time limit management support system according to any one of claims 1 to 4, wherein the survey request is a request for a survey of chemical substance information contained in a target product with a response time limit. Response margin period at any level as long as the variable information and variable information attributes are below a certain level, including the number of component parts of the product, the characteristics of the contained chemical substances, and the number of contained chemical substances The first attribute level that does not change, the first response margin period at the first attribute level, and the second attribute level that does not change the response margin period at any level as long as the variable information attribute is at or above a certain level A level acquisition unit that receives the second response margin period at the second attribute level from the supplier user terminal or the input interface and stores it in the variable information table;
The attribute information between the first response margin period and the second response margin period is read out from the variable information table by reading out information on the first attribute level and the first response margin period and the second attribute level and the second response margin period. A function estimation unit that estimates a change in an answer margin period according to a level as a function including the attribute level as an argument and the first and second answer margin periods in an answer value, and stores the function in a memory;
From the survey request data of the survey request table, extract information on the target product as attribute level information of the variable information, apply this target product information to the function of the memory, calculate the response margin period, An answer margin period setting unit that stores the answer margin period calculated here for each product ID of the corresponding product in the answer margin storage table;
A time limit management support system according to claim 5. The computer that manages the survey request for the product, including the response deadline,
A status table that manages information on the response deadline for the survey request for each product ID of the product for each survey request;
A survey request table for storing data of the survey request;
A response margin storage table storing a response margin period necessary for processing the survey request for each product ID of each product,
From the delivery destination user terminal provided by the user of the product, receiving the survey request data including information on the response deadline via the network, storing this in the survey request table together with the request acceptance time;
Each survey request data stored in the survey request table is read, and the survey request data having a common product ID is identified as a duplicate product ID, and each survey including the duplicate product ID and the duplicate product ID is identified. Processing to store information on the response deadline associated with the request data in the memory;
The duplicate product ID and the answer deadline information for each survey request data are read from the memory, the answer deadline information corresponding to the read duplicate product ID is extracted from the status table, and each read from the memory Identify the earliest answer deadline from the answer deadline information for each survey request data, and set the earliest answer deadline between this earliest answer deadline and the answer deadline extracted from the status table Processing to determine the request deadline,
Of the survey requests corresponding to the duplicate product ID, the reception time of the first received is extracted from the survey request table as the first reception time, and from the initial reception time, the corresponding duplicate product ID read from the answer margin storage table is extracted. Processing to calculate the response deadline when the response margin period has passed,
The response limit time limit is compared with the earliest request time limit. If the earliest request time limit is after the response limit time limit, the response time limit corresponding to the duplicate product ID in the status table is set as the earliest request time limit. If the earliest request deadline is before the answer limit deadline, a process for setting the answer deadline corresponding to the duplicate product ID in the status table as the answer limit deadline;
Detects a response deadline setting event in the status table, and sends a reply request including the set reply deadline information and the corresponding product ID to a supplier user terminal provided in the provider of the corresponding product via the network Processing to
A deadline management support method characterized by executing Manage survey requests for products, including response deadlines,
A status table that manages information on the response deadline for the survey request for each product ID of the product for each survey request;
A survey request table for storing data of the survey request;
In a computer provided with a response margin storage table storing a response margin period necessary for processing of the survey request for each product ID of each product,
From the delivery destination user terminal provided by the user of the product, receiving the survey request data including information on the response deadline via the network, and storing it in the survey request table together with the request acceptance time;
Each survey request data stored in the survey request table is read, and the survey request data having a common product ID is identified as a duplicate product ID, and each survey including the duplicate product ID and the duplicate product ID is identified. Storing the response deadline information associated with the request data in a memory;
The duplicate product ID and the answer deadline information for each survey request data are read from the memory, the answer deadline information corresponding to the read duplicate product ID is extracted from the status table, and each read from the memory Identify the earliest answer deadline from the answer deadline information for each survey request data, and set the earliest answer deadline between this earliest answer deadline and the answer deadline extracted from the status table Determining the request deadline;
Of the survey requests corresponding to the duplicate product ID, the reception time of the first received is extracted from the survey request table as the first reception time, and from the initial reception time, the corresponding duplicate product ID read from the answer margin storage table is extracted. A step of calculating a response time limit for which a response margin period has elapsed;
The response limit time limit is compared with the earliest request time limit. If the earliest request time limit is after the response limit time limit, the response time limit corresponding to the duplicate product ID in the status table is set as the earliest request time limit. If the earliest request deadline is before the reply limit deadline, setting a reply deadline corresponding to the duplicate product ID in the status table as the reply limit deadline;
Detects a response deadline setting event in the status table, and sends a reply request including the set reply deadline information and the corresponding product ID to a supplier user terminal provided in the provider of the corresponding product via the network And steps to
A deadline management support program that executes

Images