JP2003308418A - Chemical substance management system, chemical substance management method and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To precisely manage retained chemical substances in the component material unit. <P>SOLUTION: This chemical substance management system manages the use quantities of the retained chemical substances every chemical substance by a computer. The use quantity of each retained chemical substance is managed by use of a database including a table for managing the use quantity, each component material contained in the chemical substance, and the content of the component material. The use quantity of each chemical substance, each component material of the chemical substance and the content of the component material are acquired from the database, and the user quantity of each chemical substance is calculated in the component material unit based on the use quantity of each chemical substance, each component of the chemical substance, and the content of the component material. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a chemical substance management system for managing chemical substances such as chemicals and gases, a method for managing the chemical substances, and a recording medium, and particularly for managing the influence on the natural environment and safety. The present invention relates to a chemical substance management system having a function for managing the chemical substance, a method for managing the chemical substance, and a recording medium.

[0002]

2. Description of the Related Art In recent years, safety management for various chemical substances such as chemicals and gas has been reviewed due to social increase in global environmental problems. Therefore, even in Japan, the environmental pollutant emission / migration registration system (PRTR: Po
llutant Release Transf
er Register) legislation work is in progress. The PRTR is a system in which a chemical substance used by a company at a business site or the like is checked by itself and publicized by an administrative agency.
The amount of chemical substances released into the natural environment such as the atmosphere and rivers, and the amount of substances that are transferred as waste to outside the business site are subject to publication.

However, at present, many systems for chemical substance management used in companies mainly aim at inventory management. For example, a paper survey of the amount of a regulated substance by paper is carried out in some departments. In most cases, it is easy to do it every time, manually collect the data, and then input it to the computer. In addition, since chemical substances are usually purchased under the name of a drug, the management unit thereof is also a unit of the drug name, and the mixture is often not managed in terms of its component substances. For this reason, it is practically difficult for the current system to accurately check the amount of chemical substances discharged into the natural environment.

In addition, at present, there is no mechanism for statistically examining the safety of chemical substances owned by companies at business establishments and the environmental impact of the possessed chemical substances.
Only the safety management based on the vague index by the experience of the manager could be performed.

As described above, in the conventional system, it is difficult to accurately control the retained chemical substances because the control of the retained chemical substances is a mixed substance unit.

The present invention has been made in view of the above circumstances, and provides a chemical substance management system, a chemical substance management method, and a recording medium capable of accurately managing a chemical substance possessed by each component substance unit. The purpose is to provide.

[0006]

In order to solve the above-mentioned problems, the present invention provides a chemical substance management system in which the amount of use of each chemical substance is controlled by a computer. The database containing the table that manages the amount used, each component substance contained in the chemical substance and the content amount of the component substance, and the use amount of each chemical substance held based on the input data. Usage management means managed by the database, usage of each chemical substance from the database, means for obtaining each component substance of the chemical substance and the content of the component substance, each chemistry obtained from the database Based on the usage amount of the substance and the content of each component substance of the chemical substance and the component substance, the usage amount of each chemical substance is In characterized by comprising a means for calculating.

Further, the present invention is a chemical substance management system in which the amount of each chemical substance possessed is controlled by a computer, and for each chemical substance possessed, its possession amount and its contained amount are included. A database including a table for managing each component substance and the content amount of the component substance, a means for managing the possession amount of each of the held chemical substances by the database based on input data, Chemical substance possession amount, means for acquiring each component substance of the chemical substance and the content amount of the component substance, possession amount of each chemical substance obtained from the database, each component substance of the chemical substance and its component And a means for calculating the amount of each chemical substance possessed on the basis of the content of the substance, in units of its component substances.

As described above, by controlling not only the usage amount or the possession amount of the mixed substance but also the component substances and the contents contained in the mixture substance, the usage amount or the possessed amount of each chemical substance is a pure substance. It can be managed correctly in units (units of substance).

[0009]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings.

[First Embodiment] (System Configuration) FIG. 1 shows the configuration of a chemical substance management system according to a first embodiment of the present invention. This chemical substance management system is for managing storage, use, movement, disposal, etc. of chemical substances using a computer database, and is constructed based on a client / server model relational database system. In this system, an application program (center management software) 11 for center management used by the manager of the center that is the supervisor and a user management application (software for user management) used by drug users of each department It is realized by 12 and. The center-side client computer on which the center management software 11 is executed and the client computers on each part where the user management software 12 is executed are connected via a network, and data (pharmaceutical data) obtained from each part is connected. ) Is managed by the center management software 11. That is, the chemical user himself / herself inputs data for managing the used chemical substances by the user management software 12, and the center side uses the center management software 11 to store and use the input data based on the input data. History management such as disposal and transfer, aggregation, and preparation of reports are performed. The total may be separately performed by a batch program on the server computer. The contents of the database managed by the center management software 11 can be referred to from the user management software 12. The user management software 12 is basically assumed to be used while being online connected to a computer network, but it has a function of caching a part of the contents of the database in the local storage of the computer of each department, and each department. The user management software 12 can also be used in an off-line state by the data synchronization function between the computer and the server computer in the center.

The main management functions of the center management software 11 are as follows: management of management codes such as substance code and storage code (new registration, change, deletion), grasp of current amount of chemical substances held, chemistry of each user Management of history of use, disposal and transfer of substances, management of history of purchase of chemical substances, and creation of reporting materials.

The main management functions of the user management software 12 are: -Management of the amount of chemical substances used and amount of waste-Transmission management of chemical substances between storages (including dispensing of chemicals) -To storage of purchased chemicals Management of warehouses ・ Registration of substances managed by departments ・ Management of Fire Service Law for each storage warehouse ・ Inventory management of storage warehouses (only for storage warehouse managers) ・ Recovery management of temporary storage warehouses for collected materials (temporary storage warehouses for collected materials only) Is.

In addition, this chemical substance management system is linked with the purchase request system 13 that is managed and operated in the material management department or the like for the purpose of purchasing a substance. ・ Regulation of purchase of unregistered chemical substances (approval required by superior) ) ・ Can purchase chemical substances and obtain acceptance information.

(Function) FIG. 2 conceptually shows the functional configuration of the chemical substance management system.

(1) Goods receipt processing Goods receipt processing for managing goods receipts is performed by the arrangement request system 1
This is a database operation that is required when storing chemical substances such as chemicals and gases purchased in response to a purchase request for No. 3 in the chemical substance storage of the relevant department. The arrival of the chemical substance requested for purchase is notified from the arrangement request system 13 to the user management software 12 by the arrival data. The user management software 12 provides a screen (receipt material registration form) for entering information such as the name of the received chemical substance, its amount, the date of receipt, and the person who received it into the database, and the user can enter it on that screen. Processing is performed. FIG. 3 shows an example of the screen of this incoming substance registration form.
The meaning of each field is as follows.

<Request number>: Request number when making an arrangement request <Arrangement date>: Arranged date <Receiving date>: Received date <Receiving substance name>: Chemical substance name requested for arrangement <Order quantity>: By arrangement request Ordered quantity <Unit>: Unit specified at the time of order request <Receiving department>: Select the department where the storage is to be received <Storage>: Select the storage to be received <Administrator>: Select the storage Manager's name <TEL>: Extension number of the manager of the selected vault <Incoming date>: Date when the substance was registered in the vault (usually the date of registration) <Fire Defense Law coefficient>: Fire law of the selected vault Display the coefficient. The Fire Defense Law coefficient is a parameter indicating the ratio of the selected storage to the maximum holding amount regulated by the Fire Defense Law, and details thereof will be described later.

<Material shape>: Select the form of material management such as solid, liquid, gas, etc. <Container capacity>: If you need to manage the material with the capacity of the container, select this radio button and select the capacity. input.

<Unit>: Select the volume unit when managing by container volume <Number>: Enter the number of containers when managing by container volume. The storage amount is the container volume x number <Receiving amount>: Select this radio button if you do not want to manage by container volume, and enter the receiving amount <Unit>: Unit of receiving amount (ml, l, g, kg) , N
m ³ ) <Specific gravity>: Specific gravity of the selected substance. Used to convert the unit to match the displayed unit <Management unit>: When registering a substance for personal use, check to clarify the person in charge of the substance. For example, 500 ml bottle When ethanol is received, it is possible to enter the arrival amount in the format of container capacity = 500 ml, number of bottles = 3, but not in such container capacity unit, but in the format of receipt amount = 1.5 l It is also possible to input in the form of quantity = 1.35 kg. The system is provided with an automatic unit conversion function, and whatever unit is input, the unit amount is automatically converted into another unit by using a specific gravity value or the like. As a result, for example, kg, N
It is possible to manage with a default unit amount such as m ³ .

(2) Transfer processing between storages When a chemical substance is transferred between different chemical storages, the transferred substance name, transfer amount, transfer date, transfer destination storage name, etc. The screen for entering information into the database (mobile substance registration form) is user management software 1
2 and the input processing by the user is performed on the screen. A screen example of this transfer substance registration form is shown in FIG. The meaning of each field is as follows.

<Movement amount>: Input the movement amount of the substance <Unit>: Select the unit of <Movement amount><Movementdate>: Determine the date when the substance was moved with the spin button <Receiving department name>: Select the department where <storage> is to be stored at the destination <Receiving storage>: Select the storage to be stored from the storage registered in <Storage><Administrator>: Selected Storage manager name <TEL>: Extension number of the selected storage manager <Fire Defense Law coefficient>: Displays the sum of the fire prevention law coefficient of <Incoming storage warehouse> (3) Used chemical substance storage warehouse When the chemical substance held in (1) is used, the process of inputting information such as the actually used amount is performed using the screen (used substance registration form) provided by the user management software 12. This process leaves a usage history. When a substance to be used is selected from the possessed substance list display screen, a used substance registration form is displayed on the screen, and information such as the amount used is input on the screen.
FIG. 5 shows a screen example of the used substance registration form. The meaning of each field is as follows.

<Used amount>: Input the used amount of the substance.

<Unit>: Select the unit of <Usage amount><Usedate>: Set the date when the substance was used with the spin button <Temporary storage of collected substances>: Whether to manage temporary storage of collected substances Select with radio button “No”… Recovery substance management is not performed “Yes”… Recovery substance management is performed <Usage form>: If <Recovery substance management> is “Yes”, select the usage form of the substance “Total amount” Disposal "... Discontinue (temporary storage) to the designated collection material temporary storage immediately after use" Continuous use "... Treated as in-use material <collected material temporary storage>: <Usage form>is" whole disposal "
In the case of, select the temporary collection store for collected substances to be discarded <Fire Defense Law Coefficient>: Display the sum of the coefficients for the Fire Defense Law of <Temporary Stored Substances><Disposalcontainer>:<Usageform> is “whole disposal” In this case, a comment such as a container to be discarded is input. The collected material temporary storage is a form of storage, that is, a storage dedicated to waste materials.

(4) Recovery / Disposal Treatment After use, there are chemical substances that are recovered for recycling and those that are moved to a temporary storage for recovered substances and discarded. Processing such as input and disposal amount input (collection processing, disposal processing) is performed using the screen provided by the user management software 12. In the disposal process, when a disposal material is selected from the list display of used materials, a disposal material registration form screen as shown in FIG. 6 is displayed, and information such as the disposal amount is input on the screen. A screen example of this waste substance registration form is shown in FIG. The meaning of each field is as follows.

<Disposal amount>: Enter the disposal amount of the substance <Unit>: Select the unit of <Disposal amount><Usedate>: Set the date when the substance was used with the spin button (usually the current day's date ) <Management of temporary storage of collected substances>: Select whether or not to manage temporary storage of collected substances by radio button “No”… No management of collected substances “Yes”… Management of collected substances <Usage form>: <Collection When “Material management>” is “Yes”, select the usage mode of the substance “Whole volume disposal”… Specified collection immediately after use Discontinue (temporary storage) in the temporary storage for substances “Continuous use”… Treat as a substance in use Temporary storage for substances>: <Usage form> is “whole disposal”
In the case of, select the temporary collection store for collected substances to be discarded <Fire Defense Law Coefficient>: Display the sum of the coefficients for the Fire Defense Law of <Temporary Stored Substances><Disposalcontainer>:<Usageform> is “whole disposal” In this case, enter a comment about the container to be discarded. (5) Aggregation processing In the aggregation processing, the data on the database is used to aggregate information about the amount of chemical substances discarded, the amount of environmental emissions, the amount recycled, and the report. Is a process for creating
It is performed by the center management software 11. Environmental emissions are
It indicates the amount of chemical substances released to the natural environment due to the use of chemical substances, and the amount released to the atmosphere, water, and soil is calculated by tabulation.

(Definition of Management Amount) Next, referring to FIG.
The definition of the control amount of chemical substances in this chemical substance management system will be explained.

-Incoming amount The amount of the delivered chemical substance stored in the chemical substance storage is shown.

[Amount of possession] Indicates the amount of chemical substances held in the chemical substance storage.

-Used amount Indicates the used amount of the possessed chemical substance. This usage amount is the amount taken out from the chemical container managed in the storage,
It corresponds to the sum of the amount of waste, the amount of environmental discharge, the amount of recycling, the amount of chemical change, and the amount of export. As described above, the amount of environmental emissions is the amount that is discarded into the atmosphere, water, soil, etc., and most of this amount is emitted during the use stage of chemical substances in possession. When a product is manufactured by using a possessed chemical substance, the amount contained in the product itself is also included.

When the product is manufactured by using the carried-out chemical substance,
Indicates the amount contained in the product itself and carried out from the manufacturing site.

Amount of waste The amount of chemical substances discarded in the temporary storage of collected substances. Some of the chemical substances in the collected substance temporary storage are collected as waste solvent, sent to wastewater treatment plants, and collected as unnecessary chemicals (waste chemicals).

Moving amount The moving amount includes a moving outgoing amount and a moving incoming amount. The transfer / delivery amount indicates the amount transferred from the transfer source by the transfer of the chemical substance between the storages, and the transfer / removal amount indicates the amount transferred to the transfer destination by the transfer of the chemical substance between the storages.

(Management Type) FIG. 8 is a diagram showing management types of chemical substances in the chemical substance management system.

As shown in the figure, the chemical substances are managed by dividing them into a center control substance and a department control substance.

-Centre controlled substances Chemical substances registered in the center, the center manages only this substance.

Department controlled substance A substance that manages a chemical substance that is not registered in the center by itself, such as a substance that is purified or mixed with the center controlled substance or obtained as a sample. This substance is managed only at the registered department, not at the center.

For example, when an intermediate product C not registered in the center is produced as a mixture by mixing the chemical substances A and B, the intermediate product C is partly managed. The chemical substances A and B, which are the constituent substances of the intermediate product C, are managed by the center.

(Management Unit) FIG. 9 is a view for explaining a management unit of chemical substances in the chemical substance management system.

In this chemical substance management system, a unique substance code is assigned to each possessed chemical substance, and the possessed chemical substances are managed in units of the substance code. Examples of chemical substances to be managed are shown below.

1) General chemical reagents 2) Industrial chemicals, fluorescent chemicals, distilled water, semiconductor chemicals, industrial chemicals, adhesives, adhesives, dust cleans, etching chemicals, other chemicals, plating solutions, etc. 3) Gas Helium, nitrogen, hydrogen, oxygen, argon, semiconductor gas,
Various gases such as acetylene, ammonia, and nitrous oxide, liquid substances, and possessed chemical substances are managed on a container volume basis and a warehousing unit basis.

Management of container capacity unit; management is carried out in capacity units of containers stored in the storage.

Receiving person unit management: management is performed in units of the warehousing person who has entered the storage and the container capacity.

The unit for managing these is, as described above,
Either can be selected and set for each substance when the chemical substance is registered for receipt.

(Environmental Emission Management): First Example (Example Based on Amount Used) Next, a mechanism for environmental emission management, which is one of the important features of this embodiment, will be described.

First, as a first example, the basic principle of environmental emission management based on the usage of chemical substances will be described.

In the present embodiment, the environmental emission rate of each chemical substance, for example, the environmental emission rate to the atmosphere, water, soil, etc. is determined by, for example, the substance species and its intended use (depending on predetermined conditions. (Determined in advance), the environmental emission ratio is modeled and controlled by parameters determined by the substance type and its intended use. That is, using the database, for each chemical substance possessed, its substance type (substance name, substance code, etc., a parameter indicating the substance itself), intended use,
Also, control the ratio of environmental emissions to the atmosphere, water, soil, etc.

In this way, if the environmental emission ratios to the atmosphere, water, soil, etc., which are determined by the type of substance and its use, are managed, then the amount of each chemical substance used It is possible to easily obtain the environmental emission amount to the atmosphere, water, soil, etc. simply by performing a simple tabulation process of multiplying the environmental emission amount ratio. Hereinafter, a suitable specific example for realizing this mechanism will be described.

(Holding Substance Management Table) FIG. 10 shows the field structure of the holding substance management table for managing the holding state of the chemical substances in the storages of each department. This possessed substance management table shows, for each chemical substance possessed, its substance type (substance name, substance code, and other parameters that indicate the substance itself), intended use (use as a pure application such as cleaning, etc.). , Including conditions such as temperature and pressure as the operating environment), and air, water,
Relational database is used to manage the environmental emission rate to each soil, etc. temporally (period) and spatially (by department, storage unit, whole place, whole storage, etc.). Of the multiple tables that make up
Is one. 1 record (1 for each chemical possessed
Rows) are assigned, and the fields shown in the figure are defined in each record. Here, some representative fields will be described.

<Storehouse code>: Shows the unique code of the storehouse holding the corresponding chemical substance. The storage code is composed of a building number, a room number, and the storage number indicating the location of the storage. With this <storage box code> field, even if there are a plurality of storage boxes in one copy, it is possible to manage the environmental impact, safety, etc. for each storage box.

<Substance code>: Unique substance code assigned to each chemical substance <Sub number>: Code for identifying chemical substances with the same substance type but different substance names <Component substance code>: <Substance code When the substance designated by the symbol> is a mixture, the substance code of the component substance is set, and when the substance designated by the <substance code> is a pure substance, the same code as the <substance code> is set.

<Component sub-number>: Code for identifying a chemical substance having the same substance type but different substance names or product names <Partial management flag>: Central management substance or local management substance <Identity name>: Substance name, in the case of a component substance, its substance name <Substance attribute>: Pure substance / compound / mixture / Ingredient identifier <Substance code>: <Substance code> A code that indicates the regulation that regulates the substance specified in 1. <Storage management flag>: Flag indicating whether it is personal management or management in storage units <Receiver name>: The storage processing was performed Person's name <Date and time of receipt>: Date and time of the last receipt processing <Type>: Indicates attributes such as liquid and solid <Usage unit>: Unit of use such as kg, ml and number <Holding amount>: Current possession Indicates the amount. This value increases or decreases depending on the warehousing process, the usage process, and the like.

<Retained amount KG>: A value obtained by converting the retained amount into kg, and a value converted into Nm ³ in the case of gas <Content>: Indicates the content (content rate) of the component substance. Used when determining the amount of possession of a component substance <Maximum possession KG of the Fire Defense Law>: This is the value set for the substances controlled by the Fire Defense Law, and the maximum amount of possession that can safely possess that substance in a specific area <Managed waste amount ratio>: Percentage of used amount that is managed after being stored in the temporary storage for collected substances <Environmental emission ratio (atmosphere)>: Concerning used amount, released to atmosphere Emission rate <Environmental emission rate (water)>: Proportion emitted to water quality due to use, relative to usage <Environmental emission rate (soil)>: Emission amount to soil due to use, Percentage <Chemical change rate>: The rate of chemical change to other substances during use <Recycle rate>: The rate that can be reused as a recycled substance after use <Export rate>: The product can be reused due to the use of possessed chemical substances When manufactured Amount contained in the product itself and carried out of the manufacturing site <Usage code>: Code indicating the intended use of the substance specified by <Substance code><Factor law code>: Maximum regulated by the Fire Law Indicates the ratio of the substance holding amount to the holding amount. By accumulating this ratio for each substance in storage units, the Fire Defense Law coefficient as a storage unit can be presented.

<Weighted value>: An environmental load index indicating the degree of influence of the corresponding substance on the environment. By accumulating the product of the environmental load index and the possession amount for each substance in each storage unit, it is possible to examine the environmental load in each storage unit.

In this possessed substance management table, when a substance name is entered, a preassigned substance code is automatically set in the possessed substance management table. Then, when you input the usage, the usage table described later is searched,
The atmosphere, which is determined by its substance code and usage
The values of the environmental emission rate to water and soil, the chemical change rate, and the recycling rate are acquired, and these are automatically set in the corresponding fields of the possessed substance management table.

The method of using the Fire Defense Law coefficient and the weighted value will be described later.

(History Table) FIG. 11 shows the field structure of the history table for managing the history of use, disposal, transfer, etc. of the chemical substances held in each department. This history table manages the amount used, amount discarded, amount transferred, etc. for each possessed chemical substance temporally (period) and spatially (unit of department, unit of storage unit, all units, storage unit, etc.) One of the multiple tables that make up a relational database.
Is one. 1 record (1 for each chemical possessed
Rows) are assigned, and the fields shown in the figure are defined in each record. Here, some representative fields will be described. The field having the same name as the possessed substance management table has the same meaning as that of the possessed substance management table.

<History type>: warehousing, movement, use, disposal,
<Increase / decrease amount> used for identification of processing such as collection: Indicates the increase / decrease amount of the holding amount held in the storage. When <History type> indicates “Decrease due to use”, the value of <Increase / decrease amount> is the value corresponding to the use amount (minus)
The value of <increase / decrease amount> indicates the amount used.

(Usage Table) FIG. 12 shows an example of the structure of the above-mentioned usage table. This usage table is a table that defines the environmental emission rate of each chemical substance to the atmosphere, water, and soil, the recycling rate, and the chemical change rate for each intended use. It consists of Each usage table is associated with the usage code set in the usage field of the substance management table described above.
In each usage table, one record (one row) is assigned for each chemical substance possessed, and as shown in the figure, <substance code>, <management waste amount ratio>,
The fields <Air emission rate>, <Water emission rate>, <Soil emission rate>, <Recycle rate>, <Chemical change rate>, <Export rate> are defined.

As described above, <ratio of atmospheric emissions>, <
The values of water quality discharge rate>, <soil discharge rate>, <recycling rate rate>, <chemical change rate rate>, <transportation rate rate> can be determined in advance depending on the relationship between the chemical substance and its usage. In other words, the coefficient values of the rate of release into the atmosphere, water, and soil, and the rate of chemical change, export and recycling, can be predicted in advance depending on the nature and usage of the substance. Since it is possible, you can register the predicted value in the usage table. Regarding the rate of environmental emissions to the atmosphere, water, and soil, the environmental emissions to the atmosphere, water, and soil for each substance were measured for each usage, and the statistical data of the measured values were used. The value to be registered in the usage table may be determined.

FIG. 12 exemplifies a usage table corresponding to usage code = 01, and substance code = 01.
When the chemical substance of is used for the purpose indicated by the usage code = 01, the air emission rate = 0.1 Water quality emission rate = 0 Soil emission rate = 0 Recycle rate = 0 Chemical change rate = 0 Export An example in which the amount ratio = 0 is shown.

Since the remainder obtained by subtracting the total value of these ratios from 1 is the management waste amount ratio to be discarded in the collected material temporary storage, the management waste amount ratio = 0.9.

When a chemical substance of substance code = 02 is used for the purpose indicated by usage code = 01, air emission rate = 0.2 water quality emission rate = 0.1 soil emission rate = 0 An example is shown in which the recycling amount ratio = 0, the chemical change ratio = 0.2, and the export amount ratio = 0. In this case, management waste rate =
It becomes 0.5.

(Aggregation Table) FIG. 13 shows an example of an aggregation table obtained by the aggregation process. This tabulation is used as a report or the like for disclosing environmental emissions etc. to administrative agencies, and is calculated using the possessed substance management table and history table described above. In the schedule,
As shown in the figure, for each possessed chemical substance, its substance code, substance name, unit, previous period inventory amount, receipt amount, current period inventory amount, usage amount, management disposal amount, transfer amount, recycling amount, atmospheric emission amount,
It includes values such as water quality discharge, soil discharge, chemical change, and discharge.

(Acquisition of Environmental Emission Ratio) FIG. 14 shows a procedure for automatically acquiring the environmental emission ratio from the use table and registering it in the possessed substance management table.

First, the substance code and the usage code are input to the possessed substance management table (step S10).
1). In this case, the manual work is the work of selecting the substance name from the substance name list menu and the work of selecting the usage from the usage list menu. By selecting the substance name, the corresponding substance code is automatically input.

Next, a usage table is searched by using the substance code and the usage code as keys, and in the usage table corresponding to the usage code key, from the record corresponding to the material code key, the management waste amount ratio, atmospheric emission The values of the amount ratio, the water quality discharge ratio, the soil discharge ratio, the recycling amount ratio, the chemical change amount ratio, and the carry-out amount ratio are acquired (step S102).

After this, the acquired management disposal amount ratio,
The values of air emission rate, water quality emission rate, soil emission rate, recycling rate, chemical change rate, and export rate are
It is automatically registered in the corresponding field position of the possessed substance management table (step S103).

(Aggregation Table Output) FIG. 15 shows the procedure of the aggregation process for outputting the aggregation table.

First, the temporal / spatial use amount of the chemical substance to be totaled is acquired from the increase / decrease amount field of the history table (step S111). Next, the controlled emissions rate, atmospheric emission rate, water emission rate, soil emission rate, recycle rate, export rate, and chemical change rate for the relevant substance are stored in the possessed substance management table or history. It is acquired from the table (step S112). The acquired usage amount is classified into the following items.

“Use amount” = “managed waste amount” + “environmental discharge amount (atmosphere, water, soil)” + “recycle amount” + “chemical change amount” + “carried amount” Therefore, for each chemical substance to be counted In addition, "usage" x "managed waste amount ratio" = "managed waste amount""usageamount" x "atmospheric emission ratio" = "atmospheric emission amount""usageamount" x "water quality emission ratio" = "water quality Emissions "Used" x "Soil discharge rate" = "Soil discharge""Used" x "Recycled rate" = "Recycled amount""Used" x "Chemical change rate" = "Chemical change""Amount""Usedamount" x "Delivery amount ratio" = "Delivery amount" should be calculated and output to the spreadsheet.
"Managed waste amount", "Atmospheric discharge amount", "Water quality discharge amount",
The values of "soil discharge amount", "recycle amount", "carry out amount", and "chemical change amount" are calculated (step S11).
3).

(Second Example of Environmental Emission Control): Management Based on Waste Volume Next, a second example of environmental emission control will be described.

In the above example, the usage, the rate of environmental emission (atmosphere, water, soil), the amount used, etc. were controlled for each chemical substance. This is a study in which a small amount of a wide variety of substances are used for various purposes. This is a management method suitable for institutions.

On the other hand, in factories or the like where the use of chemical substances is predetermined, the ratio of environmental emissions to the atmosphere, water, soil, etc., the ratio of chemical changes, the ratio of recycled amounts, and the ratio of transported amounts are chemical. It can be uniquely determined in advance for each substance. Therefore, even if the usage and environmental emission rate of each chemical substance is not managed individually in a table, only the storage amount, unused used amount, unused discarded amount, and used collected and discarded amount are managed. If you use a table, the amount of unused storage, unused waste, and used collection and disposal will be subtracted from the amount received, and the amount of environmental emissions to the atmosphere, water, soil, etc. will be multiplied. By doing so, it is possible to aggregate environmental emissions, as well as chemical change rate, recycling rate,
Multiplying the carry-out ratio, the amount of chemical change, the amount of recycling,
You can add up the amount of shipping.

In this case, however, impurities may be mixed in the waste stored in the recovered substance temporary storage due to the use treatment, so if the measured waste amount is used as it is, correct use The quantity may not be calculated. Therefore, it is preferable to calculate the actual amount of waste by removing impurities from the actually measured amount of waste, using an impurity coefficient table as shown in FIG.

The impurity coefficient table shown in FIG. 16 corresponds to a certain "usage" of a chemical substance. Here, as shown in the figure, the impurity coefficient for each substance code,
The values of air emission rate, water quality emission rate, soil emission rate, and chemical change rate are registered. The actual amount of waste can be calculated by (measured amount of waste) × (1-impurity coefficient).

(Second example of output of tabulation table) FIG. 17 shows the procedure of the tabulation process corresponding to the second example of environmental emission management.

First, a process of calculating the actual amount of waste is performed using the impurity coefficient table of FIG. 16 (step S121). In this process, as described above, the actual waste amount G is obtained by multiplying (measured waste amount) × (1-impurity coefficient).

Next, the actual amount of waste (■ G) aggregated in time and space is subtracted from the amount of inventory stored in time and space (■ inlet amount), and the subtraction result is corresponded. The atmospheric emission rate, water quality emission rate, soil emission rate, chemical change rate, etc. are calculated by multiplying by the values of the atmospheric emission rate, water quality emission rate, soil emission rate, chemical change rate, etc. of the substance (step. S122).

Under certain conditions, (■ Receiving amount)-(■ G) Can basically be regarded as environmental emissions.

[Second Embodiment] As described in the first embodiment, it is necessary to manage substances in units of pure substances in order to manage the environmental emission amount. Here, a specific mechanism of the pure substance management will be described as a second embodiment. The basic configuration of the chemical substance management system of the second embodiment is the same as that of the first embodiment, and the (system configuration), (function), (definition of management amount), (management) described in the first embodiment (Type), (Management unit), (Environmental emission control), (Holding substance control table), (History table), (Usage table), (Summary table), (Acquisition of environmental emission rate), (Summary table output) ), (Second example of environmental emission management), and (Second example of output of tabulation table) are directly applied to the second embodiment.

(Holding Substance Management Table) FIG. 18 shows the first table.
In the possessed substance management table described in FIG. 10 of the embodiment, only a portion related to pure substance management is extracted and shown. The meaning of each field in FIG. 18 is as described in the first embodiment. As can be seen from FIG. 18, one substance is assigned to one record for pure substances,
With regard to the mixed substance (aqua regia), records are individually assigned to the mixed substance and each of the component substances constituting the mixed substance.

In FIG. 18, for ethyl alcohol which is a pure substance, substance code = A1, sub number = 00, component substance code = A1, component sub number = 00, content = 1
Has become. Thus, in the case of a pure substance, the substance code and the component substance code are the same, and the content is 1.

Ethanol is a substance which is substantially the same as ethyl alcohol, but has a different name. For this ethanol, the substance code is A1 which is the same as ethyl alcohol, but the sub number is 01, which is different from ethyl alcohol. Further, the content is 1.

With respect to aqua regia which is a mixture, substance code = B1, sub number = 00, component substance code = B1, component sub number = 00. Then, in the record below that, records of nitric acid and hydrochloric acid, which are constituent substances of aqua regia, are arranged.

For nitric acid which is a component substance, the substance code is B1 which is the same as that of aqua regia, and sub number = 00, component substance code = C1, component sub number = 00, content =
It becomes 0.25. Content = 0.25 means that the aqua regia contains nitric acid in a ratio of 0.25. The component material content value is used to calculate the component material content from the mixture material content.

"Retention amount of component substance" = "retention amount of mixed substance" × "content of component substance" For hydrochloric acid which is the second component substance, the substance code is B1 which is the same as that of aqua regia, and the sub number = 00, component substance code = D1, component sub number = 00, content = 0.75
Becomes

As described above, by managing the component substances and the contents of the mixed substances in the possessed substance control table, it becomes possible to easily perform the control in the pure substance unit and the environment in the pure substance unit. It will be possible to collect emission data. This management of pure substance units is performed not only for the possessed substance management table but also for the history table.

Further, in the above-mentioned usage table, since the information such as the environmental emission ratio (air, water, soil) is registered in the unit of pure substance, in the case of the mixed substance, the environmental emission for each component substance is registered. The quantity ratio (air, water, soil) should be registered in the possessed substance management table.

Here, instead of preparing a field relating to a component substance in a record for managing each chemical substance, information regarding the component substance and information regarding the mixed substance are all recorded in one record like other pure substances. This is for the purpose of preventing the generation of useless fields and facilitating the calculation of environmental emissions.

The relationship between each mixed substance and its component substances and contents is previously defined in a database called a substance management database. All possessed chemical substances are centrally defined in the “substance management table”. Note that this table has the same structure as the possessed substance management table. Therefore, if only the mixed substance name is input, the information on the component substances can be retrieved from the substance management database and automatically registered. An example of this procedure is shown in the flowchart of FIG.

As shown in FIG. 19, when the user inputs a mixed substance code or mixed substance name on the screen for registering a substance (step S131), the mixed substance code or mixed substance name is input. The substance management database that is the key is searched, and information such as the component substance and the content is acquired from the substance management database (step S132). Then, the information is registered in the possessed substance management table (step S133).

Information such as component substances and contents obtained from the substance management database is displayed on the above-mentioned screen for substance registration, and components are selected, added, changed, or contained as necessary. It is also possible to be able to perform operations such as changing the. This is because the mixed substances also include mixed substances obtained by mixing in the local department, and it is considered that the default component information defined in the component database may not be sufficient.

(Substance Registration Screen) FIG. 20 shows an example of the substance registration screen (substance registration form). The meaning of each field is as follows.

<Name of substance controlled by department>: Name of the substance registered in the department. You cannot register a name that has already been registered.

<Drug shape>: Select the shape of the drug <Container volume>: If it is necessary to manage the substance by the container volume, select this radio button and enter the volume <Unit>: Container volume When managing, select the capacity unit <Number>: When managing by container capacity, enter the number of containers. <Receiving amount> where the container capacity x number is the receiving amount <Receiving amount>: Select this radio button if you do not manage by container capacity and enter the receiving amount <Unit>: Unit of receiving amount <Specific gravity>: Specific gravity of registered substance <Receiving Department>: Select the department that contains the receiving storage <Receiving Storage>: Select the receiving storage <Administrator>: Administrator name of the selected storage <TEL>: Select the storage Extension number of the manager <Fire Defense Law coefficient>: Fire Defense Law coefficient of the selected storage <Receiving date>: Date when the substance was registered in the storage <Component>: Information on the component is displayed in a list. By double-clicking the location of the component information to be changed, a dialog screen (component information change form) for changing information as shown in FIG. 21 is displayed. Here, the content of the component in the registered substance,
The unit and specific gravity can be set.

When the "add component" button in FIG. 20 is clicked, a dialog screen for adding components (additional component registration form) as shown in FIG. 22 is displayed, and the components can be additionally registered there.

(Calculation of Usage Amount of Component Substance) FIG. 23 shows a processing procedure for calculating the usage amount of the component substance.

First, the usage amount of the mixed substance is acquired from the increase / decrease amount field of the history table (step S151).
Next, the content of each component substance of the mixed substance is acquired from the possessed substance management table or the history table (step S152). Then, the obtained content is multiplied by the usage amount of the mixed substance to calculate the usage amount of each component, and the calculated usage amount is registered in the corresponding increase / decrease amount field of the history table (step S153).

(Aggregation Table Output) FIG. 24 shows the procedure of the aggregation process for outputting the aggregation table. This procedure is the first
It is exactly the same as the embodiment.

That is, first, the temporal and spatial usage amount of the pure substance (the component substance in the case of a mixed substance) to be totaled is acquired from the increase / decrease amount field of the history table (step S161). Next, the management waste rate, air emission rate, water emission rate, soil emission rate, recycling rate, and chemical change rate values for the corresponding pure substances (in the case of mixed substances, their component substances) Is acquired from the possessed substance management table or the history table (step S162). This acquired usage is
It is classified into the following items.

"Used amount" = "managed waste amount" + "environmental discharge amount (atmosphere, water, soil)" + "recycled amount" + "chemical change amount" Therefore, pure substances (in case of mixed substances) "Use amount" x "managed waste amount ratio" = "managed waste amount""usageamount" x "atmospheric emission ratio" = "atmospheric emission amount""usedamount" x "water quality emission""Amountratio" = "Water quality discharge amount""Usedamount" x "Soil discharge amount ratio" = "Soil discharge amount""Usedamount" x "Recycled amount ratio" = "Recycled amount""Usedamount" x "Chemical change amount""Proportion" = "Chemical change amount""Usedamount" x "Export amount ratio" = "Export amount" should be output to the spreadsheet,
"Managed waste amount", "Atmospheric discharge amount", "Water quality discharge amount",
The values of "soil discharge amount", "recycle amount", "carry-out amount", and "chemical change amount" are calculated (step S16).
3).

[Third Embodiment] Next, a mechanism for safety management using the aforementioned Fire Service Law coefficient will be described as a third embodiment. The basic configuration of the chemical substance management system of the third embodiment is the same as that of the first embodiment.

First, the basic principle of safety management will be described.

In the present embodiment, the safety index indicating the degree of safety is the amount of possession with respect to the maximum amount of possession (the upper limit value at which possession is permitted) specified by laws and regulations that regulate the handling of chemical substances. It is modeled by the ratio of.
That is, for each chemical substance possessed,
The maximum amount of possession (the maximum possession KG of the Fire Service Act) specified by the law that regulates the handling of the chemical substance is managed using the above-mentioned possessed substance management table, and the maximum amount of possession specified by the law is Calculate the ratio of the amount of controlled substances possessed (coefficients of the Fire Service Act) and output the calculation results as a safety index. In this case, the sum of the Fire Defense Law coefficients for each substance is the safety index for the storage. Hereinafter, a suitable specific example for realizing this mechanism will be described.

(Regulation Code Master Table) FIG. 25
Shows an example of a regulation classification code master table for managing regulation classification. In the regulation code master table, one record is assigned for each regulation classification, and <record of regulation code>, <record of regulation code> is assigned to each record.
The fields of legal classification name, <Fire Defense Law management classification>, <Fire Defense Law maximum possession KG>, <Fire Defense Law maximum possession l>, <Registration date>, <Update date> are defined. The units of maximum holding amount defined by the Fire Service Act are kg and l (liter). Since the unit of the maximum possession amount of the substances specified by the Fire Service Act Class 4 is l (liter), regarding the substances regulated by the Fire Service Act Type 4 the maximum possession KG of the Fire Service Act in the possessed substance management table mentioned above. Specific gravity in the field of (is dimensionless as a physical quantity, but is defined as follows for convenience: kg / l)
A value converted by multiplying the maximum holding amount (l) is registered in.

Based on this regulation classification code master table, the maximum KG possessed by the Fire Service Law for each regulation that regulates chemical substances
The maximum amount of fire protection law possessed is 1 (liter). The types of regulations include the Occupational Safety and Health Law, the Fire Service Law, and the law regarding waste treatment and cleaning, but only the Fire Service Law has a maximum holding amount.

(Fire Defense Law List) Next, the Fire Defense Law list display screen for displaying the Fire Defense Law coefficient for each substance will be described. FIG. 2 provided by the user management software 12
When the Fire Defense Law List tab is selected on the operation screen of 6, as shown in the figure, for each chemical substance held in the storage selected as the search target, its substance code, substance name, holding amount, unit, fire prevention A list of law coefficients and applicable law names is displayed.

Here, the Fire Defense Law coefficient is a value obtained by dividing the possessed amount of the chemical substance by the maximum possessed amount defined by the Fire Service Law which regulates the chemical substance as described above. For example,
When 0.01192 Kg of ethanol is stored, the Fire Defense Law coefficient is 0.00004. For substances with a Fire Defense Law coefficient of less than 1, it means that the substance is in a relatively safe state.

The sum of the Fire Defense Law coefficients for each of these substances is displayed in the "Fire Defense Law coefficient total" field at the bottom of the screen. The value in the "Total Fire Defense Code Coefficients" field is used as a safety index for the storage selected as the search target. If "Total Fire Defense Code Coefficients" = less than 1, then the storage is relatively safe. means. It is necessary to manage in accordance with the Fire Service Law for storage warehouses with "total Fire Service Law coefficient" = 1 or more.

(Fire Defense Law Coefficient Calculation Processing) The flowchart of FIG. 27 shows the procedure for calculating the Fire Defense Law coefficient. First, for each chemical substance held in the storage object of the survey specified on the screen of the Fire Defense Law List tab, the amount of possession and the value of the maximum Fire Defense Law possessed KG are acquired from the possessed substance management table (step S171). Next, the possessed amount is divided by the maximum possessed KG of the Fire Service Law to obtain the Fire Service Law coefficient for each substance (step S172). Then, by accumulating the Fire Service Law coefficients for each substance, the total value of the Fire Service Law coefficients for each chemical substance held in the storage subject to the survey is calculated, which is the "Fire Service Law coefficient total".
Is displayed (step S173).

[0110] As described above, if the possessed substance management table has the Fire Defense Law coefficient field,
Since the Fire Defense Law coefficient of each substance has been obtained in advance by the processing of steps S171 and S173, only the processing of step S173 is performed when the Fire Defense Law list tab is selected. Further, since the value of the maximum possession KG of the Fire Service Law is managed in the regulation classification code master table, the value of the maximum possession KG of the Fire Service Law is not from the possessed substance management table,
It may be acquired from the regulation classification code master table.

[Fourth Embodiment] Next, a mechanism for environmental load management using the above-mentioned weighting value will be described as a fourth embodiment. The basic configuration of the chemical substance management system of the fourth embodiment is the same as that of the first embodiment.

First, the basic principle of environmental load management will be described.

In the present embodiment, the environmental load index (environmental impact) indicating the degree of influence of each chemical substance on the environment is modeled using the amount of possession of the chemical substance and the weighting factor corresponding to the chemical substance. . Regarding the value of the weighting factor, the value of the weighting factor increases as the chemical substance having a greater effect on the environment. By modeling using the weight coefficient in this way, it is possible to accurately grasp the environmental load only by performing a simple calculation such as accumulating the product of the possession amount and the weight coefficient for each substance. Hereinafter, a suitable specific example for realizing this mechanism will be described.

(Substance Code Table) As shown in FIG. 28, in the substance code table for managing the unique substance codes assigned to the possessed substances, the weighting value ( Weighting factor) is defined. The value of the weighting factor is a unique value defined by this system, and as described above, the value of the weighting factor increases as the chemical substance having a greater effect on the environment. The environmental load index (environmental impact level), which indicates the degree of environmental impact of each substance, is the value of the weighting coefficient (toluene:
10000, hydrogen peroxide: 10 etc.) is the value obtained by multiplying the possessed amount of the substance.

(Environmental Impact Level Calculation Processing) The flowchart of FIG. 29 shows the procedure for calculating the environmental impact level.

First, the weight value of each chemical substance held in the storage subject to investigation is acquired from the substance code table or the possessed substance management table (step S18).
1). Then, the possessed amount of each chemical substance is acquired from the possessed substance management table, and the degree of influence (environmental load index) is calculated for each chemical substance based on the possessed amount and the weighted value (step S182). The degree of influence of each chemical substance is obtained by multiplying the weight value x the amount of possession. After that, by accumulating the degree of influence of each chemical substance, the total value of the degree of influence of each chemical substance is calculated as the environmental influence degree of the storage warehouse under investigation (step S183).

Note that the environmental impact degree may be calculated not only in units of one storage unit but also in a plurality of storage units installed adjacent to each other as one group.

(Display of environmental impact) User management software 1
When the possessed substance list tab is selected on the operation screen of FIG. 30 provided by No. 2, the chemical substances possessed in the retrieval target storage are displayed in a list as shown in the figure. On this screen, there is a field of "influence degree", in which the total value of the degree of influence of each chemical substance calculated based on the current amount of chemical substance possessed, that is, the storage warehouse to be searched The environmental impact degree of is displayed. Depending on the degree of influence, the display color of the "degree of influence" field is, for example, less than 9000: green, 90
00 or more and less than 10,000: yellow, 10,000 or more: red,
Changes to. In this way, by evaluating the degree of influence on the environment for each storage unit and making it possible to present it numerically, for example, a storage unit having an influence degree of 10,000 or more is searched and the manager of the storage unit is asked to It is possible to operate by giving guidance based on international environmental conservation standards such as ISO14001.

[Other Functions] Next, the above-mentioned first to fourth embodiments
Other functions provided in each system will be described.

(Container Deadline Management Function) This function is a function used to regularly inspect the safety of a container for chemical substances held and managed in container units such as gas cylinders. . For containers that require regular inspection (maintenance), such as gas cylinders, see Figure 3.
As shown in 1, the name of the storage box in which it is stored, maintenance target container information indicating the type of container, maintenance cycle information indicating how many months the maintenance should be performed, and the last maintenance execution date and time Information that indicates is managed.

FIG. 32 shows the procedure of container deadline management.

The system uses the table of FIG.
For each storage, deadline management of containers requiring maintenance is performed (step S191), and when a container whose value obtained by subtracting the previous maintenance date and time from the current date and time reaches the maintenance cycle (step S192), the container The storage manager and the like are notified of the storage and the container type to be maintained (step S193). It should be noted that a list of the corresponding containers may be output on paper or the like several days before the date and time when the next maintenance should be performed.

(Output table conversion function) Generally, country,
The chemical substance codes used for each administration such as prefectures and cities often differ. In addition, the chemical substance code used by these administrations and the chemical substance code used in this system are also different.
The output table conversion function is a function for converting mutually different code systems to each other and performing chemical substance management and report creation using the designated code system. In order to realize this function, the substance code correspondence table as shown in FIG. 33 is used in this system. This substance code correspondence table holds the correspondence relation between the substance code used in this system and the substance code used in the administration such as the country, prefecture, and city for each substance. The procedure of the output table conversion process using this substance code correspondence table is shown in FIG.

First, a designated code corresponding to the administration to which the report is to be submitted is input (step S201). Then, the substance code of each chemical substance managed in the possessed substance management table or history table (substance code of this chemical substance management system) is assigned to the administration specified by the designated code using the substance code correspondence table. It is converted into a corresponding code system (step S202). Then, various tabulation processing is performed using the converted substance code, and a report is created using the code system designated by the designated code (step S203).

(Automatic conversion of unit) This function is used as a unit (ml,
(l, g, kg, Nm ³ etc.) is a function for mutually converting, and whatever unit is input, it can be converted into other units and amounts necessary for management. . FIG. 35 shows the procedure of automatic conversion in this unit.

First, conversion into another unit is performed using the input unit and amount, specific gravity, etc. (including pressure in the case of gas) (step S211). Then, the input unit and amount and the converted value (unit and amount) are registered in the possessed substance management table or the like (step S212). By managing both the unit and the amount thus input and the converted value in the possessed substance management table, it becomes possible to flexibly cope with various tabulation formats.

(Custody Security Function) The user of each department can search for the substances held in all the vaults by using the possessed substance list tab of FIG. 30, and not only his or her own department, You can find out what kind of substances are stored in the vaults of all other departments.
However, for example, if free retrieval is allowed even for a storage that holds dangerous substances such as poisonous substances, there is a risk that the substances will be illegally taken out and used. Therefore, in this chemical substance management system, a storage security function is provided for a specific storage so that the content of the possessed substance cannot be referred to from other departments.

FIG. 36 shows the correspondence between each storage box and the presence / absence of a toxic substance, and a flag designating whether or not the user is allowed to search for a possessed substance. Here, since no toxic substances are stored in the storages A and B, search from other departments is allowed as usual, and in the storage C, toxic substances are stored.
This shows a state in which searches from other departments are prohibited.

The setting of the search permission / prohibition for each storage box is performed by the storage box administrator. The interface for that purpose will be described below.

FIG. 37 shows an example of a screen for managing the storage (storage management tab). This vault management tab is for vault information (vault code, vault name, vault manager) and vault user information (user ID of vault,
User name, etc.) is defined, and the contents can be modified by the storage manager. When the “change storage information” button on this storage management tab is clicked, the storage information change dialog screen of FIG. 38 is displayed. The meaning of each field on this storage information change dialog screen is as follows.

<Store name>: Enter the store name <Manager name 1>: Select a representative manager name from the pull-down menu <TEL>: Extension number of the representative manager <Manager name 2> : Select the sub administrator from the pull-down menu <TEL>: Extension number of the sub administrator.

<Disclosure to other departments>: It is set whether or not this storage is disclosed to users in other departments in the possessed substance list. Make this setting only for the storage of poisonous substances.

"Public" ... Users of other departments can also see the status of the amount of possession.

"Non-disclosure" ... Only the users of the local office can set the holding status.

<Available users>: The range of users of the relevant storage is set.

"Only storage user" ... Only the user of the relevant storage can enter the storage and use chemicals.

"All system users" ... Users in other departments can also use the medicines in the relevant storage.

<Storage Cabinet Type>: Select a storage cabinet or a temporary storage cabinet for collected substances.

(Bar Code Input Function) The bar code input function is a function of adding a bar code to each received substance, automatically reading information necessary for substance management from the bar code, and registering it in the database. . In this bar code, in addition to information for identifying the substance such as substance name and amount, the above-mentioned environmental emission rate, usage, weighted value (or environmental load index), applicable law type, maximum amount held by Fire Defense Law (Or the Fire Service Law coefficient) can be included. As a result, manual input work is reduced, and parameters for environmental emission management, safety management, and environmental load management can be automatically registered in the table, and the efficiency of such management can be improved. it can.

The bar code device (bar code input device) can be installed in each storage unit, but it is installed in a transfer device (eg, a dolly) for transferring a chemical substance in consideration of installation cost. Then, the chemical substance management system of the present invention can be wirelessly input from the bar code device provided in the carrying device. By constructing the entire system in this way, the installation of the bar code device can be minimized.

(Management Function of Unintentional Product) In the PRTR, an unintentional product represented by Dioquin may also be a substance to be notified.

As the control in that case, a resin containing chlorine or the like is added as a substance to be controlled and the above-mentioned chemical change rate field or the like is diverted for control, or an unintentional product field is newly added. It is possible to manage the generation amount of the unintentional product according to the management method of the above-described embodiment.

(Effects of Each Embodiment) As described above, the embodiments of the present invention have been described by being divided into the first to fourth embodiments. However, the chemical substance management system of the present invention is actually the first to fourth embodiments.
It will be understood that it is built as a system that also has four functions. Therefore, this chemical substance management system can manage and aggregate the environmental emission amount resulting from the use of the possessed substance, the potential environmental impact of the possessed substance, the Fire Defense Law coefficient, etc. from various angles. In particular, almost all parameters required for environmental emission management, environmental impact management, fire control coefficient management, etc. are registered and managed in the possessed substance management table, etc., so there are various effects on the natural environment and safety. It is possible to easily obtain statistical values from various viewpoints.

This is because 1) environmental emissions are modeled by parameters determined by the type of substance and its intended use, and 2) the safety index indicating the degree of safety regulates the handling of chemical substances. Modeled by the ratio of the possession amount to the maximum possession amount specified by laws and regulations such as the Fire Service Act, 3) Environmental impact is modeled using the possession amount of chemical substances and the weighting factor corresponding to the chemical substances It was realized for the first time by a technical idea that takes into account the unique properties of chemical substances and the characteristics of databases.

Further, usually, a plurality of storages are usually set in each part according to the type of chemicals,
As in each of the embodiments, starting with the history of warehousing, use, movement, disposal, etc., environmental emission management, environmental impact management, and Fire Service Act coefficient management are carried out in units of storage cabinets, making it more detailed. It is possible to manage substances and easily identify the storage manager to be instructed. In particular,
By combining management on a storage unit basis with environmental impact management or fire law coefficient management, it is possible to check the safety level on a storage cabinet basis or the environmental impact level on a storage cabinet basis.

Since each function of this chemical substance management system can be realized by software,
The same effect as each of the embodiments can be obtained by preparing a computer program including a procedure for realizing the function and introducing the computer program through a recording medium into an ordinary computer.

[0147]

As described above, according to the present invention,
It becomes possible to accurately manage the possessed chemical substances on a component substance basis.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of a chemical substance management system according to a first embodiment of the present invention.

FIG. 2 is a block diagram showing a functional configuration of the chemical substance management system of the same embodiment.

FIG. 3 is a diagram showing an example of an incoming substance registration screen used in the chemical substance management system of the embodiment.

FIG. 4 is an exemplary view showing an example of a transfer substance registration screen used in the chemical substance management system of the embodiment.

FIG. 5 is a view showing an example of a used substance registration screen used in the chemical substance management system of the embodiment.

FIG. 6 is a view showing an example of a waste substance registration screen used in the chemical substance management system of the embodiment.

FIG. 7 is a diagram showing a definition of a management amount used in the chemical substance management system of the embodiment and a processing flow.

FIG. 8 is a view for explaining substance management types used in the chemical substance management system of the same embodiment.

FIG. 9 is a diagram for explaining a substance management unit in the chemical substance management system of the embodiment.

FIG. 10 is an exemplary view showing an example of a possessed substance management table used in the chemical substance management system of the embodiment.

FIG. 11 is a view showing an example of a history table used in the chemical substance management system of the same embodiment.

FIG. 12 is a view showing an example of a usage table used in the chemical substance management system of the same embodiment.

FIG. 13 is a view showing an example of an aggregate table created by the chemical substance management system of the same embodiment.

FIG. 14 is a flowchart showing a procedure for registering an environmental emission ratio in a possessed substance management table in the chemical substance management system of the same embodiment.

FIG. 15 is an exemplary flowchart showing a procedure of aggregating process in the chemical substance management system of the embodiment.

FIG. 16 is a view showing an example of an impurity coefficient table used in the chemical substance management system of the same embodiment.

FIG. 17 is a flowchart showing a second example of the procedure of the aggregation processing in the chemical substance management system of the same embodiment.

FIG. 18 is a view for explaining a field configuration of a possessed substance management table necessary for realizing a pure substance management function provided in the chemical substance management system according to the second embodiment of the present invention.

FIG. 19 is a flowchart showing the procedure of component information registration processing in the chemical substance management system of the same embodiment.

FIG. 20 is a view showing an example of a substance registration screen used in the chemical substance management system of the embodiment.

FIG. 21 is a view showing an example of a component information change screen used in the chemical substance management system of the same embodiment.

FIG. 22 is a view showing an example of an additional component registration screen used in the chemical substance management system of the same embodiment.

FIG. 23 is a flowchart showing a procedure of a usage calculation process of component materials in the chemical management system of the embodiment.

FIG. 24 is an exemplary flowchart showing the procedure of the aggregation process used in the chemical substance management system of the same embodiment.

FIG. 25 is a diagram showing a configuration of a regulation classification code master table used in the chemical substance management system according to the third embodiment of the present invention.

FIG. 26 is a view showing an example of a fire prevention law list screen used in the chemical substance management system of the same embodiment.

FIG. 27 is a flow chart showing the procedure of Fire Defense Law coefficient calculation processing in the chemical substance management system of the same embodiment.

FIG. 28 is a view showing an example of a substance code table used in the chemical substance management system according to the fourth embodiment of the present invention.

FIG. 29 is an exemplary flowchart showing the procedure of environmental impact degree calculation processing in the chemical substance management system of the same embodiment.

FIG. 30 is an exemplary view showing an example of a possessed substance list screen used in the chemical substance management system of the embodiment.

FIG. 31 is a view showing a table for container deadline management in the chemical substance management system of the respective embodiments.

FIG. 32 is a flowchart showing a procedure of container deadline management applied to the chemical substance management system of the respective embodiments.

FIG. 33 is a view showing an example of a substance code correspondence table provided in the chemical substance management system of the respective embodiments.

FIG. 34 is a flowchart showing the procedure of an output table conversion process applied to the chemical substance management system of the respective embodiments.

FIG. 35 is a flowchart showing the procedure of a unit automatic conversion process applied to the chemical substance management system of the respective embodiments.

FIG. 36 is a view for explaining the principle of the storage security function applied to the chemical substance management system of the respective embodiments.

FIG. 37 is a diagram showing an example of a storage management screen used in the storage security function of FIG. 36.

38 is a diagram showing an example of a storage information changing screen used in the storage security function of FIG. 36.

[Explanation of symbols]

11 ... Center management software 12 ... User management software 13 ... Arrangement request system

─────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] April 14, 2003 (2003.4.1)
4)

[Procedure Amendment 1]

[Document name to be amended] Statement

[Correction target item name] 0077

[Correction method] Change

[Correction content]

Next, the actual waste amount (ΣG) aggregated in time and space is subtracted from the receipt amount (Σ receipt amount) aggregated in time and space, and the substance corresponding to the subtraction result is subtracted. The atmospheric emission rate, the water quality emission rate, the soil emission rate, the chemical change rate, etc. are multiplied to obtain the atmospheric emission rate, the water quality emission rate, the soil emission rate, the chemical change rate, etc. (step S122). ).

[Procedure Amendment 2]

[Document name to be amended] Statement

[Correction target item name] 0078

[Correction method] Change

[Correction content]

Under certain conditions, (Σ Received amount)-(ΣG) Can basically be regarded as environmental emissions.

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Masaru Amano             1st Komukai Toshiba-cho, Sachi-ku, Kawasaki-shi, Kanagawa             Inside the Toshiba Research and Development Center (72) Inventor Tadahisa Miyazawa             1-1 Shibaura, Minato-ku, Tokyo Co., Ltd.             Toshiba headquarters office (72) Inventor Naoki Otsuka             2-9 Suehiro-cho, Ome City, Tokyo Stock Market             Inside Toshiba Ome Office (72) Inventor Hiroki Nakae             1st Komukai Toshiba-cho, Sachi-ku, Kawasaki-shi, Kanagawa             Inside the Toshiba Research and Development Center (72) Inventor Shigeru Machida             1st Komukai Toshiba-cho, Sachi-ku, Kawasaki-shi, Kanagawa             Inside the Toshiba Research and Development Center (72) Inventor Toru Sugiyama             1st Komukai Toshiba-cho, Sachi-ku, Kawasaki-shi, Kanagawa             Ceremony Company Toshiba Microelectronics Sen             Inside (72) Inventor Tatsuo Nomaki             1st Komukai Toshiba-cho, Sachi-ku, Kawasaki-shi, Kanagawa             Inside the Toshiba Research and Development Center (72) Inventor Akinori Motomiya             8th Shinsugita Town, Isogo Ward, Yokohama City, Kanagawa Prefecture             Ceremony company Toshiba Yokohama office (72) Inventor Yuichi Tobayashi             2-4 Suehiro-cho, Tsurumi-ku, Yokohama-shi, Kanagawa               Toshiba Keihin Office

Claims (6)

[Claims] 1. A chemical substance management system in which a computer manages the usage amount of each of the held chemical substances, and the usage amount of each of the held chemical substances and each component substance contained in the chemical substance And a database including a table that manages the contents of the component substances thereof, a usage amount management unit that manages the usage amount of each of the held chemical substances by the database based on input data, and each chemical from the database. Amount of substance used, means for obtaining each component substance of the chemical substance and content of the component substance, amount of use of each chemical substance obtained from the database, each component substance of the chemical substance and its component substance And a means for calculating the amount of use of each chemical substance based on the content of Quality management systems. 2. A chemical substance management system in which the amount of each chemical substance possessed by a computer is managed by a computer, and the amount of each chemical substance possessed and the component substances contained in the chemical substance. And a database including a table for managing the contents of the component substances thereof, a means for managing the held amount of each of the held chemical substances by the database based on input data, and a holding of each of the chemical substances from the database Quantity, means for acquiring each component substance of the chemical substance and the content of the component substance, the possession amount of each chemical substance obtained from the database, each component substance of the chemical substance and the content of the component substance And a means for calculating the amount of possession of each chemical substance on a component substance basis based on Temu. 3. It is realized by a computer having a database including a table for managing the usage amount of each chemical substance possessed, each component substance contained in the chemical substance and the content amount of the component substance. A chemical substance management method for managing the usage amount of each of the chemical substances in possession by the chemical substance management system according to the above, wherein the usage amount of each chemical substance from the database, each component substance of the chemical substance and its Based on the step of the computer performing the process of acquiring the content of the component substance, based on the usage amount of each chemical substance acquired from the database and each component substance of the chemical substance and the content of the component substance And a step of causing the computer to execute a process of calculating the usage amount of each chemical substance in units of its component substances. Chemical substance management method for. 4. A computer provided with a database including a table for managing, for each chemical substance possessed, the amount possessed, each component substance contained in the chemical substance and the content amount of the component substance. A chemical substance management method for managing the amount of each chemical substance possessed by the chemical substance management system according to the present invention, wherein the amount of each chemical substance possessed from the database, each component substance of the chemical substance and its Based on the step of the computer performing the process of acquiring the content of the component substance, based on the amount of each chemical substance acquired from the database and each component substance of the chemical substance and the content of the component substance And a step of causing the computer to execute a process of calculating the amount of each chemical substance possessed by the component substance unit thereof. Chemical substance management method for. 5. A computer, using a database including a table for managing the usage amount of each chemical substance possessed, each component substance contained in the chemical substance and the content amount of the component substance, It is a computer-readable recording medium in which a computer program for controlling the usage amount of each of the held chemical substances is recorded, wherein the computer program includes the usage amount of each chemical substance from the database and the chemical substance. The procedure for causing the computer to execute the process of acquiring each component substance and the content of the component substance, the usage amount of each chemical substance acquired from the database, and each component substance of the chemical substance and the component substance thereof The computer calculates the amount of each chemical substance used based on the content and the amount of each component substance. And a procedure to be executed by the recording medium. 6. A computer, using a database including a table that manages, for each chemical substance held, the amount held, each component substance contained in the chemical substance and the content amount of the component substance, A computer-readable recording medium in which a computer program for controlling the amount of each held chemical substance is recorded, wherein the computer program includes the amount of each chemical substance held from the database, and the chemical substance. The procedure for causing the computer to execute the process of acquiring each component substance and the content of the component substance, the holding amount of each chemical substance acquired from the database, each component substance of the chemical substance and the component substance The process of calculating the amount of possession of each chemical substance based on the content and the component substance unit And a procedure to be executed by the recording medium.