JP2007219675A - Chemical substance management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a chemical substance management system capable of efficiently managing both included chemical substance information submitted by a customer and the analysis result of an own company at the same time and automatically determining whether the use of a purchased product is permissible. <P>SOLUTION: The chemical substance management system comprises a first storage means for storing information for identifying parts or material of the customer, in relation to the amount of chemical substance included in the parts or material; a second storage means for storing the amount of chemical substance inspected in a delivery destination on the amount of chemical substance in the parts or material of the customer stored in the first storage means, in relation to the information for identifying the parts or material of the customer; and a determining means for computing the difference between the amount of chemical substance stored in the first storage means, and the amount of substance stored in the second storage means, and determining whether the use of the parts or material of the customer is permissible based on the difference value and a criterion defined beforehand. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a chemical substance management system for managing chemical substance information contained in a product.

  In recent years, social interest in environmental issues has increased, and the European Directive on the restriction of the use of certain hazardous substances in electrical and electronic equipment (RoHS Directive) With the strengthening of laws and regulations such as these, the manufacturing industry is required to manufacture products with less environmental impact and to disclose specific information on chemical substances contained in products. From such a background, when the manufacturing industry purchases raw materials and parts, it is required to provide suppliers with information on contained chemical substances.

  For example, Non-Patent Document 1 discloses a system that transmits a response request for the content of a chemical substance in a purchased part to a supplier of the purchased part that constitutes the product in accordance with a survey request from the supplier of the product. ing.

  Non-Patent Document 2 discloses an example of a company that, as an environmental measure, establishes a system in which the environmental department and a department such as procurement and production technology cooperate to conduct a content survey of regulated substances. Yes.

Edited by the Green Procurement Survey Standardization Council "Practice of Green Procurement Guidelines for Standardization of Green Procurement Surveys for Components for Electric and Electronic Equipment" Published by Japan Industrial Environment Management Association September 20, 2003, pages 20-101 "Manufacturing industry, group total war", Nikkei Sangyo Shimbun December 2, 2005

  The system disclosed in Non-Patent Document 1 manages the information on contained chemical substances submitted by business partners, and can be viewed by the business partners and the company itself. The information managed by this system is used when the actual product-containing chemical substance information is disclosed. However, for the manufacturing industry that sells the final product, the disclosure of product information involves significant risks. For this reason, from the viewpoint of self-defense, an increasing number of companies conduct incoming inspection of purchased products and analyze chemical substances subject to law. However, the system disclosed in Non-Patent Document 1 does not consider managing the inspection results of the company, and manages only the information submitted by the business partner. Although a method of overwriting the analysis result on the information of the supplier is also conceivable, this method is not appropriate because the original management becomes impossible and the division of responsibilities with the supplier becomes ambiguous. If you want to analyze contained chemical substances, there is an idea that you do not need to receive information from business partners, but it is not realistic to analyze all contained chemical substances in your company, There is also information that only business partners can understand.

  In addition, in the future, the use of products containing chemical substances that are subject to regulation or products containing chemical substances exceeding the specified value will be regulated by laws and regulations. Accordingly, each company is required to have a chemical substance management system that can automatically determine whether or not a purchased product can actually be used. However, the non-patent document 1 and the non-patent document 2 do not disclose a mechanism for realizing this.

  The present invention has been made in view of the above circumstances, and the chemical substance management that can efficiently manage both the information on the contained chemical substances submitted by the business partners and the analysis results of the company based on the principle of original management. The purpose is to provide a system.

  Another object of the present invention is to provide a chemical substance management system that can automatically determine whether or not use of a purchased product can be permitted.

  In order to solve the above-mentioned problem, the chemical substance management system according to the present invention is a supplier chemical substance information table for registering supplier information, and a destination for which use permission or non-permission judgment results are registered. Both of the contained chemical substance information tables are prepared, and each table is linked and managed by a unique index (partner product number) that identifies the product. In the supplier chemical substance information table, information such as supplier product number, chemical substance content, CAS number, etc. is associated and registered. In the delivery destination chemical substance information table, not only the data stored in the supplier chemical substance information table, but also the determination result regarding permission or non-permission of product use is registered. Access rights are set for each table.

  Specifically, it is realized by the following means. First, the contained chemical substance information is registered in the two contained chemical substance tables for the supplier and the delivery destination that the chemical substance management system has. At this time, since each table has an access right, the supplier registers for the supplier and the person in charge of the supplier registers the contained chemical substance information for the supplier. After registration, the control device provided in the chemical substance management system extracts the content of the corresponding chemical substance from the supplier contained chemical substance information table and the supplier contained chemical substance information table for a certain product and compares them. I do. At the time of comparison, use permission or non-permission is determined based on the contents of the determination reference data stored in the storage device in advance, and the result is registered in the delivery destination contained chemical substance information table. At this time, if it is determined that the use is not permitted, the control device transmits a survey request mail to the customer terminal or the procurement terminal.

  According to the present invention, it is possible to provide a chemical substance management system capable of efficiently managing both the contained chemical substance information submitted by the supplier and the analysis result of the company based on the principle of original management.

  Moreover, according to this invention, the chemical substance management system which can determine automatically whether use of the purchased product can be permitted can be provided.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a block diagram showing an overall configuration of a system 1 to which a chemical substance management system (server or the like) 12 according to the present invention is applied. In the present embodiment, the chemical substance management system 12 is provided on the supplier side, and is connected to a plurality of customer terminals 10 via the Internet 11. Further, the chemical substance management system 12 is connected to a plurality of delivery destination terminals (for managers 14, for procurement side 15...) Via an intranet 13.

  As shown in FIG. 1, a chemical substance management system 1 according to the present invention includes a control device (CPU) 100 and a storage device 101. The storage device 101 includes a control program 110 executed by the control device 1110, a component or (hereinafter referred to as /) material ID table 111, a supplier-containing chemical substance information table 112, a supplier-containing chemical substance information table 113, An access right management table 114, a determination condition table 115, an error determination reference value table 116, a legal reference value table 117, and a group management table 118 are stored. The use permission / non-permission determination unit 20 of the control device 100 (hereinafter referred to as “/”) uses a part / material described later using data stored in various tables in accordance with the control program 110 provided in the storage device 101. Permission / non-permission judgment processing is performed. In the present embodiment, the supplier-containing chemical substance information table 112 and the supplier-containing chemical substance information table 113 are linked by the supplier product number in the parts / material ID table 111, and access to these tables is made. By restricting the rights, double management of chemical substance information for each product (part / material) can be realized.

  FIG. 2 is a diagram showing a configuration of the component / material ID table 111. As shown in FIG. 2, the parts / material ID table 111 is associated with information such as a supplier product number 200, a delivery destination product number 201, a drawing number 202, a product number 203, and a name 204, respectively. Yes. These pieces of information are registered in the parts / material ID table 111 at the delivery destination. The delivery destination product number 201, the figure number 202, and the product number 203 are registered when there is a number managed independently by the delivery destination, in addition to the customer product number determined by the business partner.

  FIG. 3 is a diagram showing a configuration of the supplier-containing chemical substance information table 112. As shown in FIG. 3, the supplier-containing chemical substance information table 112 includes a supplier product number 300 for specifying a product (part / material), a chemical substance content 301 included in the product, Information such as unit 302 and CAS (Chemical Abstract Services) number 303 is stored in association with each other.

  FIG. 4 is a diagram showing the configuration of the delivery destination contained chemical substance information table 113. As shown in FIG. 4, the contained chemical substance information table 113 stores information such as supplier number 400, chemical substance content 401, unit 402, CAS number 403, and determination result 404 in association with each other. Has been. As the determination result 404, the determination result of use permission / non-permission of parts / materials determined by a use permission / non-permission determination unit 20 described later is registered.

  FIG. 5 is a diagram showing the configuration of the access right management table 114. This is a table for managing access rights to the part / material ID table 111, the chemical substance information table 112 for suppliers, and the chemical substance information table 113 for suppliers for each user who uses the chemical substance management system 12. In FIG. 5, for example, the supplier side can only refer to the parts / material ID table 111, can only refer to the supplier chemical substance information table 112, and can only refer to the supplier chemical substance information table 113. This is shown (510). Note that procurement refers to a user who directly contacts a business partner among delivery destination users. The delivery destination manager indicates that the part / material ID table 111 can only be referred to, the supplier chemical substance information table 112 can only be referred to, and the delivery destination chemical substance information table 113 can be edited. 511). In addition, the manager here is an expert with specialized knowledge about chemical substances. The administrator analyzes the content of the chemical substance contained in the part and registers the result in the delivery destination contained chemical substance information table 113. Other users at the delivery destination can only refer to the parts / material ID table 111, can only refer to the supplier chemical substance information table 112, and can only refer to the delivery destination chemical substance information table 113. (512). The supplier indicates that the parts / material ID table 111 can only be referred to, the supplier chemical substance information table 112 can be edited, and the supplier chemical substance information table 113 cannot be referred to (513).

  FIG. 6 is a diagram illustrating the configuration of the determination condition table 115. The determination condition table 115 is a table used when the use permission / non-permission determination unit 20 executes a process for determining whether to permit / deny use of a product (part / material). As shown in FIG. 6, the determination condition table 115 includes a determination reference index 600, a determination condition 601, a determination result 602, and an exception flag 603. Here, in the present embodiment, the numerical values shown in the determination result 602 in FIG. 6 are defined as follows. For example, if the difference between the content of the chemical substance provided by the supplier and the content of the chemical substance based on the inspection result is within the error range, use permission (“3”) is set (610). If there is no in-house defined value, use permission (“3”) is set (611). If there is an error in the difference between the chemical substance content provided by the supplier and the chemical substance content based on the inspection results, if the error is within the allowable range, permission with reconfirmation (“2”) is assumed. (612). If a chemical substance that violates the law is used, it is not permitted (“1”) (613). If there is an error in the difference between the content of the chemical substance provided by the supplier and the content of the chemical substance based on the inspection result, and the error exceeds the allowable range, it is disallowed (“1”) (614) ). If the content of the chemical substance provided by the business partner is “0”, there is a possibility that nothing has been investigated by the business partner, so it is set as “not permitted” (“1”) (615). Further, when the content of the chemical substance provided by the business partner is “blank”, it can be determined that measurement is impossible. Therefore, if it is desired to permit use, it is sufficient to define the determination condition 601 as “chemical substance content is 0” and the determination result 602 as use permission (“3”). In this embodiment, as indicated by the exception flag 603 in FIG. When there is no in-house measurement value (611), or when the content of a chemical substance provided by a business partner is “0” or “blank” (615), it is defined as exception processing.

  FIG. 7 is a diagram showing the configuration of the error determination reference value table 116. The error determination reference value table 116 is a table used when the use permission / non-permission determination unit 20 executes a process for determining whether to permit or deny use of a product (part / material). As shown in FIG. 7, in the error determination reference value table 116, information such as a CAS number 700, a chemical substance name 701, an error range 702, an allowable range 703, and a group number 704 are stored in association with each other. ing. The use permission / denial determination unit 20 calculates the difference between the chemical substance content 301 in the supplier-containing chemical substance information table 112 and the chemical substance content 401 in the supplier-containing chemical substance information table 113, Further, referring to the error range 702 and the allowable range 703 of the error determination reference value table 116, it is determined whether the difference is within the error range or whether there is an error but the error is within the allowable range.

  FIG. 8 is a diagram showing the configuration of the legal reference value table 117. As shown in FIG. 8, in the legal reference value table 117, information such as a CAS number 800, a chemical substance name 801, a reference value 802, and a group number 803 is stored in association with each other. The use permission / denial determination unit 20 compares the reference value 802 in the legal reference value table 117 with the chemical substance content 401 in the delivery destination contained chemical substance information table 113, and based on the comparison result, the part / material Use permission / denial of

  FIG. 9 is a diagram showing the configuration of the group management table 118. The group management table 118 is used to manage chemical substances corresponding to laws and regulations and chemical substances managed by each company in units of groups. As shown in FIG. 9, the group management table 118 includes items such as a group number 900, a group name 901, and a law flag 903. The error determination reference value table 116, the legal reference value table 117, and the group management table 118 are linked by group numbers.

  10 and 11 are flowcharts showing an outline of processing in the chemical substance management system 12. In FIG. 10, the supplier registers the chemical substance information contained in the parts / materials into the supplier chemical substance information table 112 from the terminal 10 via the Internet 11 (step 1000). After that, the delivery manager performs in-house parts / material acceptance inspections and analyzes the content of chemical substances. In the acceptance inspection, not all chemical substances are necessarily investigated, and only chemical substances related to laws and regulations may be analyzed. In this case, for chemical substances not related to laws and regulations, the information on contained chemical substances submitted by suppliers is used as it is.

  Further, according to the operation of the manager, the chemical substance comprehensive management system 1 creates a delivery destination contained chemical substance information table 113 in which data of the supplier contained chemical substance information table 112 is copied (step 1001). Next, the administrator registers the analysis result (chemical substance content) from the terminal 14 to the content 401 of the delivery destination contained chemical substance information table 113 for the corresponding part / material (step 1002). Next, the administrator inputs a supplier product number from the input screen of the terminal 14, for example. The inputted supplier product number is transmitted to the chemical substance management system 1 (step 1003). Next, in the chemical substance management system 12, the use permission / non-permission determination unit 20 of the control device 100 includes a component / material ID table 111 stored in the storage device 101, a supplier-containing chemical substance information table 112, and a delivery destination. -Based chemical substance information table 113 and determination criterion data (determination condition table 115, error determination reference value table 116, legal reference value table 117, group management table 118) stored in advance in storage device 101. It is determined whether or not the use of parts / materials is permitted (step 1004). In step 1004, if the use is permitted, the use permission / denial determination unit 20 registers the result in the determination result 404 of the delivery destination chemical substance information table 113 (step 1005). If the use is not permitted in step 1004, the use permission / denial determination unit 20 registers the result in the determination result 404 of the delivery destination contained chemical substance information table 113 (step 1006). After the processing in step 1006, the control device 100 transmits a survey request mail to the business partner (step 1007) or contacts the person in charge of the delivery destination.

  12 and 13 are flowcharts showing details of processing executed by the use permission / denial determination unit 20. The determination process is executed in units of group numbers 900 registered in the group management table 118. This is because there is a possibility that the permission condition of a certain chemical substance may be spread over a plurality of groups, and it is considered that it is not presently possible to determine the priority order for each group. The flowcharts shown in FIGS. 12 and 13 show flowcharts for determining one component on the condition of a certain group. For this reason, this processing is executed by the number of corresponding parts / materials × the number of groups.

  First, the use permission / denial determination unit 20 searches for a target part / material from the part / material ID table 11 based on the supplier product number from the administrator terminal 14 (step 1200). Next, based on this supplier product number, the use permission / non-permission determination unit searches for the corresponding parts / materials from the supplier chemical substance information table 112 and the supplier chemical substance information table 113. The chemical substance content data (301, 401) is read from the table (step 1201). Next, the use permission / non-permission determination unit 20 refers to the determination condition table 115 and determines use permission / non-permission of the searched part / material (step 1202). The determination in step 1202 is based on determination criteria obtained empirically rather than data such as reference values and error ranges defined by laws and regulations. For example, when the content submitted by the supplier is “0 (zero)”, it is presumed that no investigation has been performed, and in this case, the use is not permitted.

  Next, the use permission / denial determination unit 20 calculates the difference in the content of the chemical substance read in Step 1201 (Step 1203). Next, the use permission / denial determination unit 20 reads the error range 702 and the allowable range 703 of the corresponding chemical substance from the error determination reference value table 116, and corresponds to the difference between the calculated content and the content calculated in step 1203. Whether to permit / deny use of parts / materials is determined (step 1204). The error range 702 is expressed as a ratio to the content registered in the delivery destination contained chemical substance information table 113. The allowable range 703 is an allowable range for the error and is expressed as a ratio to the obtained error. For example, if the content of a certain chemical substance registered in the delivery destination chemical substance information table 113 is 100 g, the error range is 0.1 and the allowable range is 0.2, the error range is 100 g ± 10, and the allowable range is 100 g ± 12. Judging by using the judgment condition table 115, if the content registered in the supplier chemical substance information table 112 is 105g, it is allowed because it is within the error range, 111g is within the acceptable range, and it is allowed with reconfirmation, if 120g Is not allowed. In step 1204, when the determination result is permission or permission with reconfirmation, the use permission / denial determination unit 20 reads the reference value 802 of the corresponding chemical substance from the legal reference value table 117, and contains the chemical substance for the delivery destination. The content of the corresponding part / material in the information table 113 is compared (step 1205). As a result of comparison, if the content is smaller than the reference value, use is permitted, and if the content is large, use is not permitted. If the use permission is determined in step 1205, the final determination differs depending on the result in step 1204. If the use permission with reconfirmation is determined in step 1204 and the use permission is determined in step 1205, the final determination result is the use permission with reconfirmation, and the use permission / non-permission determination unit 20 The result is registered in the determination result 404 of the information table 113 (step 1206). If the use permission is determined in both step 1204 and step 1205, the final determination result is the use permission, and the use permission / denial determination unit 20 displays the determination result 404 in the delivery destination chemical substance information table 113. The result is registered (step 1207). If it is determined in step 1202, step 1204, and step 1205 that use is not permitted, the final determination result is not permitted, and the use permission / denial determination unit 20 determines in the delivery destination contained chemical substance information table 113. The result is registered in the result 404 (step 1208). When the use is not permitted, the use permission / denial determination unit makes a re-investigation request to the procurement or business partner by e-mail or the like (step 1209). After the above determination process is performed for all parts, substances, and groups, the process by the use permission / denial determination unit 20 ends.

It is a block diagram which shows the whole structure of the system 1 to which the chemical substance management system 12 by this invention is applied. It is a figure which shows the structure of the components / material ID table 111. FIG. It is a figure which shows the structure of the contained chemical substance information table 112 for suppliers. It is a figure which shows the structure of the contained chemical substance information table for customers. It is a figure which shows the structure of the access right management table. It is a figure which shows the structure of the determination condition table. It is a figure which shows the structure of the reference value table 116 for error determination. It is a figure which shows the structure of the legal reference value table. It is a figure which shows the structure of the table 118 for group management. 3 is a flowchart showing an outline of processing in the chemical substance management system 12. Similarly, it is a flowchart showing an outline of processing in the chemical substance management system 12. 5 is a flowchart showing details of processing executed by a use permission / denial determination unit 20. Similarly, it is a flowchart showing details of processing executed by the use permission / denial determination unit 20.

Explanation of symbols

10 ... supplier terminal, 11, 13 ... internet, 12 ... chemical substance management system (server), 14 ... delivery destination terminal (for managers), 15 ... delivery destination terminal (procurement) Side), 100 ... control device (CPU), 101 ... storage device, 110 ... control program, 111 ... part / material ID table, 112 ... container chemical information table for suppliers 113 ... Destination contained chemical substance information table, 114 ... Access right management table, 115 ... Determination condition table, 116 ... Error determination reference value table, 117 ... Legal reference value Table 118 ... Group management table.

Claims (5)

In a chemical substance management system connected to multiple customer terminals via a network,
First storage means for storing information for identifying a part or material of a supplier and a chemical substance amount contained in the part or material in association with each other;
The chemical substance amount inspected at the delivery destination with respect to the chemical substance amount of the supplier's part or material stored in the first storage means is stored in association with the information for identifying the supplier's part or material. A second storage means;
For each part or material of the supplier, the difference between the chemical substance amount stored in the first storage means and the chemical substance amount stored in the second storage means is calculated, and the difference value A determination means for determining whether or not the use of the parts or materials of the supplier can be permitted based on a predetermined determination criterion;
A chemical substance management system characterized by comprising:   The determination means determines whether or not use of the supplier's part or material can be permitted based on the difference value and predefined error range data or allowable range data, and the result of the determination If the use of the part or material is permitted, the use of the part or material can be determined by comparing the reference value stipulated by laws and regulations with the amount of chemical substance stored in the second storage means. The chemical substance management system according to claim 1, wherein it is determined whether or not it can be permitted.   The chemical substance management system according to claim 2, wherein the determination unit registers the determination result in the second storage unit in association with information for identifying a corresponding part or material.   When it is determined that the use of the part or material is not permitted as a result of the determination by the determination means, a transmission means is provided for transmitting a survey request mail regarding the part or material to the corresponding customer terminal. Item 4. The chemical substance management system according to Item 3. 5. The chemical substance management system according to claim 1, wherein an access right is set for the first storage unit and the second storage unit.

Images