JP2006244525A - Chemical substance total management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a chemical substance total management system aiding in reduction of releasing and transferring amount of managing substance in business entities. <P>SOLUTION: The chemical substance total management system produces records in the middle of process in an arithmetic processing section, and when the arithmetic processing section produces the records, the system produces link information correlating each record with a source record from which the record has been produced, and stores these records and link information in a result database of a storage unit, thereby performing reverse retrieval processing. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a chemical substance comprehensive management system for managing chemical substances contained in materials handled by business operators.

  Various materials currently in circulation contain hundreds of chemical substances that have a large impact on the environment. When a company handles such materials in processes such as manufacturing, distribution, and storage, There is a need to know how much of the chemicals are transferred, how much is released into the air, soil and water, or contained in shipped products and provided to the market. Therefore, business operators must manage the chemical substances they handle. Hereinafter, chemical substances managed by business operators are referred to as “managed substances”.

  Therefore, business operators also started a legal system to estimate the environmental impact of the entire country by reporting quantitative data on the release and transfer of controlled substances in factories, offices and companies to the national and local governments. is doing.

  The conventional data collection system has a function of inputting basic data of controlled substances for each department or process and summing up the results in units of higher-level organizations (offices and companies). This is because only this result is required for the legal system. This conventional technique is described in, for example, a special feature of Non-Patent Document 1.

"Environmental Resources" December 1999 issue

However, since the above conventional technique merely creates a document corresponding to a legal system, no consideration is given to a specific method for reducing the management substances in question. In other words, by simply displaying or printing the final release destination of the controlled substance (air, water, soil, etc.) and the amount of the released transfer, what kind of material the controlled substance was contained in, or It is specific when the business operator cannot grasp what process the controlled substance was handled, and the business operator is reducing the amount of controlled substance released or transferred (hereinafter referred to as “discharge transferred amount”). Can't take the right measures.

  Then, an object of this invention is to provide the chemical substance comprehensive management system which assists the reduction | decrease of the discharge | release transfer amount of the management substance in a provider.

  In the chemical substance comprehensive management system according to the present invention, when the arithmetic processing unit creates a record that is halfway, and when the arithmetic processing unit creates the record, the record and the record from which the record is created Link information is created, and these records and link information are stored in the result database of the storage unit to perform reverse search processing.

  According to the present invention, there is an effect that it is possible to support the reduction of the discharge and transfer amount of the managed substance in the business operator.

  Below, the chemical substance comprehensive management system of embodiment of this invention is demonstrated in detail with reference to drawings.

  In FIG. 1, the block diagram of the chemical substance comprehensive management system of embodiment of this invention is shown.

The chemical substance comprehensive management system includes an investigation processing unit 101, an MSDS database 102, a data input processing unit 103, a material composition database 104, a managed substance database 105, an emission factor database 106, a process tabulation processing unit 107, The evaluation total processing unit 108, the total total processing unit 109, the result database 110, the result display processing unit 111, the search processing unit 112, and the risk communication support processing unit 113 are provided.

The MSDS database 102 stores a product safety information sheet (MSDS) for each material, indicating material handling precautions, hazards, and applicable items for laws and regulations. Materials are materials that are used as raw materials for finished products (for example, raw products such as ore and crude oil, primary processed products such as iron plates, semi-finished products such as foundations), and materials used for production of finished products (for example, Coating agent, cleaning agent, paint, coolant). A finished product means a product that is mainly shipped by a business as a product, such as an automobile, a camera, a personal computer, a film, a TV, a CPU, a board, a cable, clothes, a food, a building, electricity, water, etc. Applicable.

The material composition database 104 is a database of material composition information. One material is usually composed of a plurality of substances or molecules. Substances (molecules) have identifiers such as CAS numbers (Chemical Abstract Services). Therefore, the record of the material composition database 104 includes the name of the material, the identifier of the management substance contained in the material (for example, the name of the management substance, the CAS number of the management substance, etc.), and the content ratio (preferably, the mass ratio) of the management substance. Each of the lower limit and the upper limit is preferably configured as a field. Controlled substances are chemical substances (first-class designated chemical substances), prefectures, or government-designated cities that are subject to the PRTR Law (Act on Understanding the Emissions of Specific Chemical Substances to the Environment and Promoting Improvement of Management) Substances that have a significant impact on the environment, such as chemical substances that are subject to the chemical substance management guidelines and environmental conservation guidelines, and substances that need to be managed as surrounding substances, such as toluene, xylene acid, Examples include methyl isobutyl ketone, isopropanol, lead chromate, eboxy resins, methylene chloride, benzene, diethyl zinc, acrylamide, mercury, vinyl chloride.

The managed substance database 105 is a database listing managed substances. Stores a record group having an arbitrary genre (poisonous substance, deleterious substance, management target, legally specified substance, self-managed substance, etc.) and an identifier of the corresponding managed substance as fields. Furthermore, the record group which uses the identifier of a controlled substance and its physical property as a field is also stored. Physical properties include values such as coefficient, vapor pressure and density when converted from molecular mass to pure metal mass.

The emission factor database 106 includes the controlled substances and their management for each process and the combination of materials handled in each process (atmosphere, water area, soil, consumption, commissioned disposal, recycling, production inclusion, etc.). A record having a field of the amount of material movement (preferably, a weight ratio) is stored. The process means a production process of a product, a product inspection process, a product development process, for example, a molding process, a machining process, a heat treatment process, a painting process, a cleaning process, an etching process, a surface treatment process, an assembly process. Etc. For example, in a painting process in a production line of a certain department, 80% of toluene, which is a component in the paint A, is discharged to the atmosphere when the paint A is charged.

  The investigation processing unit 101 searches the record groups stored in the MSDS database 102, the material composition database 104, the managed substance database 105, and the emission coefficient database 106 by associating the common fields with each other, and the name of the managed substance, the CAS number, etc. It is possible to search for records by identifiers or to search for records by partial matching of text in a field and output them as screens or files.

  The result database 110 includes records used by the data input processing unit 103, the process tabulation processing unit 107, the evaluation tabulation processing unit 108, and the total tabulation processing unit 109, and records created as a result thereof (material handling amount records, substance handling amount records, This is a database that also stores discharge transfer amount records, totaling result records), and link information between the records (process totaling link information, evaluation totaling link information, general totaling link information, etc.).

  The result display processing unit 111 searches and reads the contents of the result database 110 and displays various tabulation results. For example, the name of a managed substance, the CAS number of the managed substance, the discharge transfer amount for each discharge destination of the managed substance, and the total discharge transfer amount totaling the discharge transfer amount for each discharge destination of the managed substance are associated with each other The name of the managed substance, the CAS number of the managed substance, the department that handled the managed substance, the process that handled the material containing the managed substance, and the annual amount handled of the managed substance in the process Display in association.

  The risk communication support processing unit 113 stores the data stored in the MSDS database 102, the material composition database 104, the controlled substance database 105, and the emission factor database 106 not only in terms of processing correlation but also in terms of the fields of each record. It fulfills the function of following link information. In risk communication, it is important to eliminate residents' concerns about the fact of the release of controlled substances. However, by investigating the process and materials used to identify how the substances are being discharged, the characteristics of the process Communication is necessary with reference to material safety data (including the height of the chimney). Therefore, regarding the material, the material composition data of the material is retrieved from the material composition database 104 and displayed, or the MSDS data is retrieved from the MSDS database 102 and displayed. Further, with respect to the managed substance, the managed substance data is retrieved from the managed substance database 105 and displayed. Further, emission coefficient data relating to the process of the managed substance is retrieved from the emission coefficient database 106 and output and displayed. With this function, it is possible to communicate with confidence based on the grounded data in response to inquiries regarding emissions transfer data from nearby residents and interested parties.

  A recording medium (for example, FD, hard disk, memory card, memory stick, MO, PD, CD-ROM, CD-R / RW, DVD-ROM, DVD) on which the chemical substance comprehensive management program of the embodiment of the present invention is recorded. -RAM) is a survey process performed by the survey process unit 101, a data input process performed by the data input process unit 103, a process total process performed by the process total process unit 107, and an evaluation total process performed by the evaluation total process unit 108. The total tabulation processing performed by the total tabulation processing unit 109, the result display processing performed by the result display processing unit 111, the search processing performed by the search processing unit 112, the risk communication support processing performed by the risk communication support processing unit 113, and the input An input process performed by the processing unit 114, a display switching process performed by the display switching processing unit 115, and a display process And a display processing section 116 performs those to be executed by the comprehensive chemical management system.

  In addition, a recording medium (for example, FD, hard disk, memory card, memory stick, MO, PD, CD-ROM, CD-R / RW, DVD-ROM, DVD) on which the chemical substance comprehensive management data of the embodiment of the present invention is recorded. -RAM) MSDS data stored in the MSDS database 102, material composition data stored in the material composition database 104, managed substance data stored in the managed substance database 105, and emission coefficient data stored in the emission coefficient database 106 And result data stored in the result database 110 (for example, material handling amount record, substance handling amount record, discharge transfer amount record, totaling result record, process totaling link information, evaluation totaling link information, general totaling link information, etc.) .

  FIG. 2 shows an example of the data structure of the database in the embodiment of the present invention.

  In the material composition database 104, the material composition data, for example, the material as the key index, the CAS number of the managed substance contained in the material, the upper limit of the content ratio (preferably, wt%) of the managed substance and the managed substance, and Data that associates the lower limit is stored for each material. As the material name, a name as a marketed product or a product number when purchased by a business office is used. Any code system that is always uniquely determined may be used.

  The managed substance database 105 stores managed substance data, for example, data that associates a managed substance, a group to which the managed substance is designated, and physical properties of the managed substance with the CAS number of the managed substance as a key index. Physical properties refer to the molecular weight, melting point, boiling point, vapor pressure, water solubility, specific gravity, etc. of controlled substances.

  In the emission factor database 106, emission factor data, for example, the process of the operator is used as a key index, and the managed substance handled in the process, the discharge destination of the managed substance, and the emission factor of the managed substance are associated with each other. Stored data. The emission factor of the controlled substance means the discharge transfer ratio (preferably the weight ratio) for each discharge destination of the controlled substance.

  In the MSDS database 102, MSDS data, for example, a managed substance or material is used as a key index, and the chemical name, English name, CAS number, property, raw material, price, manufacturing method, use, packaging, and management substance of the managed substance Stores data such as handling precautions, toxicity, and applicable laws and regulations.

  In FIG. 3, the handling example of the management substance in embodiment of this invention is shown. Description will be made in order according to the numbers in FIG.

First, it starts from purchasing a material called paint A (procedure (1)). Since the purchase amount of the paint A is 100 cubic meters / month and the storage fee in the tank is usually constant, the amount handled in the process is also assumed to be 100 cubic meters / month. Since the density of the paint A is 1200 kg / m ³ , the handling amount is 120,000 kg / month. Everything is put into the painting process (procedure (2)). The processing so far is performed by the data input processing unit 103.

  Next, since it can be read from the material composition database 104 that paint A contains 30% toluene and 1% cadmium, respectively, the handling amount of controlled substances in the coating process is 36000 kg / month for toluene. , Cadmium is calculated to be 1200 kg / month. This calculation is performed by the process totalization processing unit 107.

  Next, in the painting process, the paint is applied onto the shipped product by spraying, but a part of the paint is dried and released into the atmosphere (procedure (3)). Since it can be read from the emission coefficient database 106 that the emission ratio to the atmosphere is 94% of toluene and 0% of cadmium, it is evaluated that 33840 kg of toluene is discharged into the atmosphere every month. Similarly, as industrial waste (procedure (4)), 1800 kg of toluene and 120 kg of cadmium are discarded per month, and the shipment product contains 360 kg of toluene and cadmium of 1080 kg. Can be evaluated. This evaluation is performed by the evaluation tabulation processing unit 108.

  FIG. 4 shows a flowchart of data input processing in the embodiment of the present invention.

  The data input processing unit 103 performs data input processing. The data input process includes a reading process 2a, a date specifying process 2b, a mass specifying process 2c, a process specifying process 2d, and a storing process 2e.

In the data input process, information related to material input and purchase is read from a material management record such as a material purchase form or an inventory management form. Here, as an example, the process starts with reading the material input record into the process as a material management record (reading process 2a).
. First, a date is specified from this record (date specifying process 2b). Since there is always a data field meaning the Western calendar or the Japanese calendar in the purchase record, it is extracted and converted to the Western calendar. Next, after specifying the mass of the material (mass specifying process 2c), the process in which the material is handled is specified using the name of the orderer (process specifying process 2d). The series of result data is stored in the result database 110 as a process handling amount record (storage process 2e). In addition, data input link information that is link information that relates a material handling amount record that is a result record and a material management record that is a source record from which the result record is obtained is also stored in the result database 110 (storage process 2e). ).

  The link information refers to a data record (original record) that a processing unit (data input processing unit 103, process tabulation processing unit 107, evaluation tabulation processing unit 108, and total tabulation processing unit 109) pre-exists, Information that relates the two when a new data record (result record) is created through arithmetic processing or aggregation processing. A one-to-one relationship can be realized by adding a pointer to the other party to either. When both are plural and have an N-to-N relationship, pointers to all result records are added to the original record, and pointers to all original records are added to the result record. Alternatively, the relationship between the original record and the result record may be held as a table.

  FIG. 5 shows a flowchart of the process tabulation process in the embodiment of the present invention.

  The process total processing unit 107 performs process total processing. The process aggregation process includes a reading process 5a, a conversion process 5b, and a storage process 5c.

  First, the mass of the material put into the process is read from the process handling amount record stored in the result database 110 (reading process 5a). Next, the management substance contained in the material is searched from the material composition data stored in the material composition database 104, and converted into the amount handled for each management substance (conversion process 5b). If you manage the amount of material handled in mass (kg) and manage the content of controlled substances contained in the material in mass percent, the amount of material handled in mass (kg) and the percentage of managed substances contained in the material Is multiplied by the amount of the managed substance handled in mass (kg). Finally, the substance handling amount record as the result record is stored in the result database 110 (storage process 5c). In addition, process aggregate link information, which is link information between the substance handling amount record as the result record and the process handling amount record and the material composition record as the original record, is also stored in the result database 110 (storage process 5c).

  FIG. 6 shows a flow chart of the evaluation tabulation process in the embodiment of the present invention.

  The evaluation totalization processing unit 108 performs evaluation totalization processing. The evaluation aggregation process includes a reading process 6a, 6b, 6c, a calculation process 6d, and a storage process 6e.

  First, the mass of each controlled substance input into the process is read from the substance handling amount record stored in the result database 110 (reading process 6a). Next, the emission transfer coefficient of the controlled substance in the process is read from the emission coefficient data stored in the emission coefficient database (reading process 6b). Further, the physical properties (such as conversion coefficient) of the managed substance are read from the managed substance data stored in the managed substance database 105 (reading process 6c). Next, the discharge amount of the controlled substance in the process to the atmosphere, water area, soil, the transfer amount to the product, and the transfer amount as waste is calculated (calculation process 6d). The emission transfer coefficient is a numerical value that indicates the ratio between the amount of controlled substances handled in the process and the amount of controlled substances discharged and transferred in the process. Therefore, the amount of managed substances handled is multiplied by this emission transfer coefficient. It is possible to calculate the amount of discharge and transfer for each material discharge and transfer destination. When this substance is a metal salt or the like, a pure metal element is required as a discharged or transferred control substance. In this case, it is converted to the mass of a pure metal element using the physical property data of the controlled substance. Finally, a discharge transfer amount record as a result record is stored in the result database 110 (storage process 6e). In addition, the result movement record 110 is also stored in the result database 110 as the result transfer record, the substance handling amount record as the original record, and the evaluation aggregation link information as the link information between the emission coefficient record and the managed substance record (storage process 6e). .

  FIG. 7 shows a flowchart of the total tabulation process in the embodiment of the present invention.

  The total tabulation unit 109 performs total tabulation processing. The total counting process includes a process specifying process 7a, a reading process 7b, a reading process 7c, a counting process 7d, and a storage process 7e.

  First, a process group corresponding to a designated total range (for example, workplace, department, section, line, process, factory, business office, business group, region, etc.) is identified (process identification process 7a). Next, the discharge movement amount record of the process group in the designated period (for example, from April 1, 1999 to May 31, 1999) is read from the result database (reading process 7b). Furthermore, only the discharge / transfer amount record of the designated managed substance group (for example, the Environmental Agency designated substance) is taken out (reading process 7c). Then, these records are totaled (total processing 7d). The survey processing unit 101 designates the total range, the period, and the controlled substance group. Finally, the total result record that is the result record is stored in the result database 110 (storage process 7e). Also, the total total link information that is the link information between the total result record that is the result record and the discharge transfer amount record that is the original record is displayed. Store in the result database 110 (storage process 7e).

  FIG. 8 shows a flowchart of search processing in the embodiment of the present invention.

  The search processing unit 112 performs search processing. The search process performs a reverse trace function, and a first reception process 8a, a first search process 8b, a first display process 8c for performing the first stage search process, and a second reception process for performing the second stage search process. 8d, a second search process 8e, a second display process 8f, and a third input process 8g, a third search process 8h, and a third display process 8i for performing a third-stage search process. The search process only needs to include at least one of the first-stage search process, the second-stage search process, and the third-stage search process. For example, only the first-stage search process is included. May be provided, or only the second-stage search process may be provided, or only the third-stage search process may be provided, or the first-stage search process and the second-stage search process may be provided. Only two of the stage search processes may be provided, or all of the first stage search process, the second stage search process, and the third stage search process may be provided.

  First, the operator selects an aggregation result record on the output screen and receives an instruction for a first-stage search process (first reception process 8a). From the result database 110, the discharge transfer amount record of the process from which the instructed count result record is tabulated is searched by tracing the total count link information (first search process 8b). The plurality of searched discharge movement amount records are output and displayed (first display process 8c).

  Next, when the operator selects one of the plurality of discharge movement amount records output and displayed as described above, an instruction for the second stage search process is received (second reception process 8d). The substance handling amount record from which the instructed discharge / transfer amount record is created is searched from the result database 110 by tracing the evaluation aggregation link information (second search process 8e). A plurality of searched substance handling amount records are output and displayed (second display process 8f).

  Further, when the operator selects one record of the plurality of substance handling amount records output and displayed as described above, an instruction for the search process at the third stage is received (third input process 8g). The material handling amount record from which the instructed substance handling amount record is created is retrieved from the result database 110 by tracing the process total link information (third search process 8h). A plurality of selected material handling amount records are output and displayed, and material order codes and orderer codes are similarly retrieved and output and displayed as supplementary information (third display processing 8i). It should be noted that the supplemental information display process is preferably not present in the present system.

  FIG. 9 is a conceptual diagram for supplementarily explaining the counting process and the search process in the embodiment of the present invention.

  Five types of records processed or created by this system, that is, a material management record, a material handling amount record, a substance handling amount record, a discharge transfer amount record, and a totaling result record are shown. The flow indicated by the arrow on the left shows the flow of forward operation processing, that is, data input processing, process tabulation processing, evaluation tabulation processing, and total tabulation processing. On the other hand, an arrow indicated by a wavy line on the right side indicates a search process using link information in each record which is the main object of the present invention, that is, a first search process, a second search process, a third search process, and an auxiliary information search process. Show the flow.

  In FIG. 9, it seems that one record is created from one record, but actually, there are cases where a plurality of records are created from one record, and one record is created from a plurality of records. There is also a case. Basically, there is an N to N relationship. Although it is not necessary if only a legal notification document is created, in order to perform the search process, it is necessary to save a record that is in the middle of the process as shown in FIG. In this case, as a new problem, there arises a need to delete a past record that has already been created and re-create it under a new condition. For example, there is a case in which composition information (a managed substance contained in a material and a content ratio of the managed substance) of a certain material has been uncertain in the past, but reliable composition information can be obtained recently. At this time, an update process is provided in which a range such as a predetermined period and a predetermined material is designated, all corresponding records are deleted, and the calculation process is performed again under new conditions.

  FIG. 10 shows a flowchart of the update process in the embodiment of the present invention.

  Update processing is performed in an update processing unit (not shown). The update process includes an input process 10a, an erasure process 10b, and a recalculation process 11c. It should be noted that the update process is preferably not in the present system.

  First, an erasure target period, an erasure target material, an erasure target process, an erasure target substance, or a combination thereof is input to determine the range of records to be deleted (input processing 10a). Next, the material handling amount record, the material handling amount record, the discharge transfer amount record, and the totaling result record in this designated range are erased (erasing process 10b). Finally, based on the new information, recalculation is performed on the deleted record (recalculation process 11c).

  FIG. 11 shows a system configuration example of the chemical substance comprehensive management system in the embodiment of the present invention.

A dedicated server computer 1101 is installed in the overall management department and stores all of the database and processing unit shown in FIG. By connecting the in-house network 1102 to the dedicated server computer 1101, all functions can be used in the terminal computers 1103 in various departments in various old castles / offices in the company. In addition, by placing the database shown in FIG. 1 on the external general-purpose data providing site 1105 and connecting to it via the Internet 1104, a wide range of data that cannot be stored in the dedicated server computer 1101, or frequent revisions It is possible to utilize the data that is generated. MSDS data, material composition data, controlled substance data, and emission factor data are preferably distributed and updated from the general-purpose data providing site 1105 to the dedicated server computer 1101 via the Internet 1104 and the in-house network 1102.

  FIG. 12 shows an example of a display input screen of the chemical substance comprehensive management system in the embodiment of the present invention.

  First, on the first display input screen 12a, the data of the aggregation result record relating to “Abc office” designated as the organization of the aggregation range is output and displayed. This result shows the amount of emission and transfer related to the three controlled substances of “toluene”, “arsenic”, and “phenol”. For example, if you specify “toluene” and instruct search processing, search As a result, the second display input screen 12b appears, and the breakdown of numerical values in this “toluene” line is output and displayed for the process. In this second display input screen, the breakdown is broken down into each process of “painting”, “cleaning”, and “surface treatment” under the condition of “toluene discharge / transfer of Abc office” and discharged. The sum of the numerical values in each of the moving items is shown to match the numerical value on the first display input screen. That is, on the second display input screen 12b, data extracted from the discharge transfer amount record related to the instructed count result record is output and displayed.

  Furthermore, on this second display input screen 12b, for example, when “painting” is instructed and search processing is instructed, the third display input screen 12c appears, and the breakdown of numerical values in this “painting” line is output regarding the material. Is displayed. In this third display input screen 12c, the breakdown is broken down for each material of “A Fah Paint” and “Behute Diluent” under the condition of “dispatch and transfer in the toluene painting process at the Abc office”. The sum of the numerical values in each of the items to be discharged and moved is shown to match the numerical values on the second display input screen 12b. That is, on the third display input screen 12c, the substance handling amount record related to the instructed discharge transfer amount record and the data extracted from the material handling amount record are output and displayed. Both records are created by continuously performing the second search process and the third search process among the search processes.

  Further, when a search process is instructed by designating, for example, “some paint” on the third display input screen 12c, a fourth display input screen 12d appears, and information on the input results of this “some paint” is output and displayed. Is done. Shows raw information such as purchase slips and inventory management slips. That is, on the fourth display input screen 12d, data extracted from the material management record related to the instructed material handling amount record is output and displayed.

  As the breakdown of the total results, there are two main meanings, namely, the amount of discharge and transfer of each controlled substance in the process for each destination and the amount of discharged substance for each of the controlled substances in the process. Therefore, the breakdown for each process, that is, the data extracted from the discharge transfer amount record is also displayed in advance on the first display input screen, and when the search processing is instructed by specifying one line, the breakdown for each material, that is, the substance Data extracted from the handling amount record and the material handling amount record may be output and displayed. Alternatively, the breakdown for each material is also displayed in advance on the first display input screen, and when the search processing specifying one line is instructed, the breakdown for each process, that is, the data extracted from the discharge transfer amount record is output and displayed. May be.

  According to the embodiment of the present invention described above, the breakdown of the discharge transfer amount for each discharge destination of the controlled substance, that is, the process in which the control substance is handled and the discharge transfer amount for each discharge destination of the control substance in the process is specified. In addition, since it is possible to specify a material containing a managed substance and a discharge / transfer amount for each discharge / transfer destination of the managed substance in the material, it is possible to support the management or reduction of the managed substance of the business operator.

  Further, according to the embodiment of the present invention described above, when specifying a process in which a managed substance is handled and a discharge transfer amount for each discharge destination of the managed substance in the process, or a material containing the managed substance and the material In order to search the source record from the result record based on the link information when specifying the release transfer amount for each release transfer destination of the controlled substance in the process, the process where the controlled substance is handled and the release destination of the controlled substance in the process There is an effect that the specification of the discharge transfer amount for each, or the specification of the material containing the management substance and the discharge transfer amount for each discharge transfer destination of the management substance in the material is speeded up. Since it is necessary to search from a huge amount of records, it takes a long time to search by a keyword or the like, and it is difficult to obtain a breakdown of the discharge transfer amount for each discharge destination of the controlled substance.

  Further, according to the embodiment of the present invention, since the link information is also created when the result record is created, the process in which the managed substance is handled and the discharge of each managed substance in the process for each discharge destination The operator does not have to prepare for identifying the amount of transfer, or for identifying the material containing the controlled substance and the amount of discharge and transfer of the controlled substance in that material for each destination of discharge and transfer, that is, creating link information. This has the effect of reducing the labor of the operator. In particular, the present invention has an effect that it is possible to flexibly cope with a change in material handled by a business operator and a change in a managed substance that the business enterprise needs to manage by automatically creating link information.

  Therefore, the chemical substance comprehensive management system according to the embodiment of the present invention includes, for example, a process in which a material is handled, a management substance contained in the material, and a discharge transfer amount for each discharge transfer destination of the management substance in the process. A result database that stores discharge transfer amount records to be managed in association with each other, an input processing unit that receives an instruction of a predetermined managed substance, and a material containing a predetermined managed substance that is instructed based on the discharge transfer amount record A search processing unit that searches for a designated process and a discharge transfer amount for each discharge transfer destination of the instructed predetermined management substance in the process, and a process in which a material containing the instructed predetermined management substance is handled And a display processing unit for displaying a discharge transfer amount for each discharge transfer destination of the designated predetermined managed substance in the process.

  In the chemical substance comprehensive management system according to the embodiment of the present invention, for example, the material handling amount record for managing the process in which the material is handled and the handling amount of the material in the process in association with each other and the process and the material are Stores the result database that stores the managed substances contained and the substance handling quantity records that manage the managed substances in the process in association with each other, and the emission transfer coefficient for each discharge and transfer destination of the managed substances in the process Emission coefficient database, input processing unit for receiving an instruction of a predetermined process, material handled in a predetermined process instructed based on the material handling amount record and the substance handling amount record, and the controlled substance in the material A search processing unit that searches for a discharge transfer amount for each discharge transfer destination, and the specified predetermined program And a display processing unit for displaying a discharge amount of movement of the discharge destination for each of the controlled substance scan handled material and in the said material.

  In addition, the chemical substance comprehensive management system according to the embodiment of the present invention includes, for example, a process in which a material is handled, a management substance contained in the material, and a discharge transfer amount for each discharge transfer destination of the management substance in the process. Aggregation results for managing the discharge transfer amount for each discharge transfer destination of the managed substance by counting the discharge transfer amount records to be managed in association with at least one of the organization in which the material is handled or the period in which the material is handled A total aggregation processing unit that creates a total aggregation link information that creates a record and relates the emission transfer amount record and the aggregation result record; an input processing unit that receives an instruction of a controlled substance in the aggregation result record; A search processing unit for searching for a discharge transfer amount record related to the controlled substance instructed based on the total aggregation link information, and a searched discharge transfer Based on the amount record and a display processing unit for displaying the discharge and transfer amount of discharge and transfer destination for each of the controlled substances in the process.

  In addition, the chemical substance comprehensive management system according to the embodiment of the present invention includes, for example, a material handling amount record for managing a process in which a material is handled and a handling amount of the material in the process in association with each other, and a management contained in the material. Create a substance handling quantity record for managing the handling quantity of the managed substance in the process based on the substance and the content ratio of the managed substance in the material, and associate the material handling quantity record with the substance handling quantity record Process aggregation processing unit for creating process aggregation link information, discharge of each managed substance discharge destination in the process based on the substance handling amount record and a discharge transfer coefficient for each discharge destination of the controlled substance in the process Create a discharge transfer record to manage the transfer, and the substance handling record and the discharge An evaluation aggregation processing unit that creates evaluation aggregation link information that correlates a dynamic amount record, an input processing unit that receives an instruction of a process in the discharge transfer amount record, and a process instructed based on the evaluation aggregation link information A search processing unit for searching for a mass transfer amount record to be performed and searching for a material handling amount record related to the mass transfer amount record based on the process aggregation link information, a searched mass transfer amount record and a searched material handling A display processing unit that displays a discharge transfer amount for each discharge transfer destination of the managed substance in the material based on the quantity record.

  In addition, the chemical substance comprehensive management system according to the embodiment of the present invention includes, for example, a material handling amount record that manages a process in which a material is handled and a handling amount of the material in the process in association with each other, and the process and the material. A substance handling amount record for managing the managed substance contained in the process and the handling amount of the managed substance in the process, and a discharge transfer amount for each discharge transfer destination of the process, the managed substance and the managed substance in the process, A discharge transfer amount record that manages the association of the material, at least one of the organization in which the material is handled or the period in which the material is handled, and the total result record that associates and manages the managed substance and the discharge transfer amount; , Process aggregation link information relating the material handling record and the substance handling record, and the substance handling record The store and evaluate aggregate link information relating the discharge and transfer amount record and a comprehensive summary link information relates the said counting result record and the discharge amount of movement records with.

  Further, the recording medium on which the chemical substance comprehensive management program according to the embodiment of the present invention is recorded includes, for example, a reception process for receiving an instruction of a predetermined management substance, a process in which a material containing the management substance is handled, and the above process. A search process for searching for a discharge transfer amount record corresponding to a predetermined controlled substance from a discharge transfer amount record that manages the discharge transfer amount for each discharge transfer destination of the managed substance, and the searched discharge transfer A business operator performs a display process for displaying a process in which a material containing the specified prescribed controlled substance based on the quantity record is handled and a discharge transfer amount for each discharge transfer destination of the controlled substance in the process in association with each other The chemical substance management system that manages the chemical substances contained in the materials handled by is executed.

  Further, the recording medium on which the chemical substance comprehensive management program of the embodiment of the present invention is recorded includes, for example, a reception process for receiving an instruction of a predetermined process, a process in which the material is handled, and a handling amount of the material in the process. Corresponding to a predetermined process instructed from a material handling amount record to be managed in association with each other, and the process, a managed substance contained in the material, and a handling amount of the controlled substance in the process in association with each other Search processing for searching the material handling amount record and the substance handling amount record to be performed, and the material and the material handled in the designated predetermined process based on the searched material handling amount record and the searched substance handling amount record The business operator performs a display process for displaying the discharge transfer amount for each discharge transfer destination of the controlled substance in Contained in the material dealing Ri to be executed by the comprehensive chemical management system for managing chemicals.

  Further, the chemical substance comprehensive management method according to the embodiment of the present invention may be configured such that, for example, the management substance is displayed on a display screen in which the name of the management substance and the discharge transfer amount for each discharge transfer destination of the control substance are associated with each other. When the name of the substance is specified, the breakdown of the discharge and transfer amount for each discharge and transfer destination of the managed substance is displayed for the process in which the material containing the managed substance is handled.

  In addition, the chemical substance comprehensive management method according to the embodiment of the present invention associates, for example, the name of a process in which a material containing a managed substance is handled with the discharge transfer amount for each discharge transfer destination of the managed substance in the process. When the name of the process is designated on the displayed display screen, a breakdown of the discharge transfer amount for each discharge transfer destination of the managed substance with respect to the material containing the managed substance is displayed.

  Moreover, the chemical substance comprehensive management method according to the embodiment of the present invention includes, for example, the management substance on the display screen in which the name of the management substance and the discharge transfer amount for each discharge transfer destination of the control substance are displayed in association with each other. When the name of the control substance is designated, the breakdown of the discharge and transfer amount for each discharge and transfer destination of the control substance with respect to the material containing the control substance is displayed.

  In addition, the chemical substance comprehensive management method according to the embodiment of the present invention associates, for example, the name of a process in which a material containing a managed substance is handled with the discharge transfer amount for each discharge transfer destination of the managed substance in the process. When the name of the process is designated on the displayed display screen, a breakdown of the discharge transfer amount for each discharge transfer destination of the managed substance is displayed for the process in which the material containing the managed substance is handled.

The block diagram of the chemical substance comprehensive management system in embodiment of this invention. The conceptual diagram of the data structure example of the database in embodiment of this invention. The conceptual diagram of the example of handling of the management substance in embodiment of this invention. The flowchart of the data input process in embodiment of this invention. The flowchart of the process totalization process in embodiment of this invention. The flowchart of the evaluation totalization process in embodiment of this invention. The flowchart of the total tabulation process in the embodiment of the present invention. The flowchart of the search process in embodiment of this invention. The conceptual diagram explaining supplementary the totaling process and search process in embodiment of this invention. The flowchart of the update process in embodiment of this invention. The system configuration | structure figure of the chemical substance comprehensive management system in embodiment of this invention. The block diagram of the display input screen of the chemical substance comprehensive management system in embodiment of this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 101 ... Investigation processing part, 102 ... MSDS database, 104 ... Material composition database, 105 ... Controlled substance database, 106 ... Emission factor database,
DESCRIPTION OF SYMBOLS 107 ... Process totalization means, 108 ... Evaluation calculation process part, 109 ... Comprehensive total process part, 110 ... Result database, 111 ... Result display process part, 112 ... Search process part, 113 ... Risk communication support process part.

Claims (4)

In a chemical substance management system that manages chemical substances (managed substances) contained in materials handled by business operators,
A result record created on the basis of the amount of material handled in the process and the content ratio of the controlled substance contained in the material, including the process in which the material is handled, the controlled substance contained in the material, and the controlled substance It is a result record created based on a plurality of substance handling quantity records that manage handling quantities in association with each other, information on the substance handling quantity records, and emission transfer coefficients for each discharge transfer destination of managed substances in the process, A plurality of discharge movement amount records for managing a process in which a material is handled, a management substance contained in the material, and a discharge movement amount for each discharge movement destination of the management substance in the process, and the discharge movement amount; A plurality of aggregation result records obtained by aggregating the discharge and transfer records of controlled substances specified as the original records, the aggregation result records, and the aggregation result records The link information relating the discharge transfer amount record from which the data is collected is related to the discharge transfer amount record and the substance handling amount record from which the discharge transfer amount record is created A result database for storing link information;
Of the plurality of totaled result records and the plurality of discharge movement amount records, information on the record from which the record selected by the operator is created is searched from the result database based on any of the link information. And a chemical substance management system having a search processing unit for outputting. In a chemical substance management system that manages chemical substances (managed substances) contained in materials handled by business operators,
A plurality of material handling amount records for managing a process in which a material is handled and a material handling amount in the process in association with each other, information on the material handling amount record, a management substance contained in the material, and a content of the management substance A plurality of substance handling amount records, which are created based on the ratio and manage the process, the managed substance contained in the material and the handling quantity of the managed substance in association with each other, and the substance handling quantity It is a result record created based on the record information and the discharge transfer coefficient for each discharge transfer destination of the controlled substance in the process, the process in which the material is handled, the control substance contained in the material, and the control substance in the process A plurality of discharge movement amount records for managing the discharge movement amounts for each of the discharge movement destinations, the discharge movement amount records, and the discharge movement amount records Link information relating the substance handling amount record that is the source of the generated information, and link information relating the substance handling amount record and the material handling amount record from which the substance handling amount record is created And a result database for storing
Based on any one of the link information, the result database is searched for information on the record from which the record selected by the operator is created out of the plurality of discharge transfer amount records and the plurality of substance handling amount records. And a chemical substance management system having a search processing unit for outputting. The result database further includes a record from which the material handling amount record is created, and a plurality of material management records for managing information related to material input and purchase in association with each other, and the material handling record Link information relating the quantity record and the material management record from which the material handling quantity record is created is stored,
The search processing unit, based on the link information, retrieves information on the material management record from which the material handling amount record selected by the operator from among the plurality of material handling amount records is created from the result database. 3. The chemical substance comprehensive management system according to claim 2, wherein the system is searched and output. In a chemical substance management system that manages chemical substances (managed substances) contained in materials handled by business operators,
A plurality of material management records for managing information related to material input and purchase in association with each other, and a result record created based on the information of the material management record, the process in which the material is handled and the material in the process This is a result record created based on a plurality of material handling amount records that are managed in association with each other, and information on the material handling amount record, managed substances contained in the material, and content ratios of the managed substances. A plurality of substance handling quantity records for managing the process, the managed substance contained in the material and the handling quantity of the managed substance in association with each other, the substance handling quantity record, and the source from which the substance handling record is created Link information relating to the material handling amount record, and the material pipe from which the material handling record and the material handling record are created A result database for storing the link information associating the record,
From the plurality of substance handling amount records and the plurality of material handling amount records, information on the record from which the record selected by the operator is created is retrieved from the result database based on any of the link information. And a search processing unit for outputting the information.

Images