JP2011197732A - Facility maintenance management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a facility maintenance management system for displaying an input candidate corresponding to a department or the type of a facility when a facility ledger is input.SOLUTION: The facility maintenance management system is provided with a database including: a code master table 13 in which a code/code name and a group to which the code belongs are defined; a department-based code table 14 that stores a prohibition list for prohibiting the display of the code for each department and group; a user table 15 for defining a user; and a column definition table 11 in which the tables are defined. When a user creates a facility ledger including the code name, a database operation part for operating the database refers to at least the code master table 13 and the department-based code table 14, and displays the code name corresponding to the department to which the user belongs and corresponding to the group as a selection candidate to be input to the facility ledger by excluding the code name of the prohibition list.

Description

  The present invention relates to an equipment maintenance management system that performs maintenance management of equipment to be managed regardless of the field.

For example, in a system related to maintenance management of managed equipment, such as power equipment management work of the power company engineering department and road equipment maintenance management work in local governments, the manufacturer and model of the managed equipment are such as `` Mitsubishi Electric '' Such a written character is not registered in the equipment ledger table in the database, but the code “Mitsubishi Electric” is assigned to “01” and “01” is registered in the equipment ledger table. The table that makes the meaning that “01” is “Mitsubishi Electric” in this way is called a code master table. By registering the code “01” of this code master table in the equipment ledger table, even when “Mitsubishi Electric” changes the notation to “Mitsubishi Electric Co., Ltd.”, it is possible to easily handle the equipment ledger data. In the scene to be registered, the contents of the code master table can be displayed as selection candidates.
In recent years, the use of databases has become widespread, and systems using such code master tables have become common. (See Patent Document 1). In an equipment management system for equipment management work, a plurality of construction departments often use the same system.

For example, there is an example in which a department that manages power plant equipment and a power transmission department that sends generated electricity to a substation facility use the same system. In such a case, even if the code master table is the same “manufacturer”, the “manufacturer” used in the power generation department and the power transmission department are clearly different. It is not good that the “manufacturer” of the department is displayed in the selection list, and there is an increasing demand for filtering and displaying the “manufacturer” used in the power generation department and the “manufacturer” used in the power transmission department. is doing.
Similarly, even a “manufacturer” used in the power transmission department can be clearly separated from the “manufacturer” used by the type of managed equipment (wires and insulators). In addition to filtering, there is an increasing demand for “manufacturer” filtering by equipment type.

  Recent developments such as the central processing unit (CPU) and main memory (memory) that make up the system are remarkable, and even if a small amount of processing is added to the selection candidate display, sufficient performance can be ensured. Even if the usage restriction is applied to the table, the performance of the system is not affected.

JP 2001-56810 A (pages 12-22, FIG. 5)

In the conventional equipment maintenance and management system, the “manufacturer” code group includes the “manufacturers” for power generation and substations and power transmissions. When displaying the manufacturer, all registered “ If the “manufacturer” is displayed as a selection candidate, only the “manufacturer” that matches the target business is not necessarily displayed, and there is a problem that the convenience of the system user is impaired.
Similarly, the “manufacturer” to be used is limited depending on the type of equipment ledger to be input, such as for power generation or for power transmission, that is, the type of equipment to be managed, which impairs convenience for system users. There was a problem.

  This invention was made in order to solve the above problems, and aims at obtaining an equipment maintenance management system that displays input candidates according to a department and equipment type to be processed at the time of equipment ledger input. Yes.

  The facility maintenance management system according to the present invention is a facility maintenance management system that creates a facility ledger including a code name related to the facility in order to maintain the facility, and the code and the corresponding code name are defined. Code master table in which the group to which the code belongs is defined, the department code table in which the prohibition list for prohibiting the display of the code by department and group to which the user belongs is stored, and the equipment ledger including the code name by the user Refer to the code master table and department-specific code table to create a code name that corresponds to the department to which the user belongs and that belongs to the group to the equipment ledger, excluding the code name in the prohibit list. The database operation unit is displayed as a selection candidate.

  As described above, the present invention is a facility maintenance management system for creating a facility ledger including a code name related to a facility in order to maintain the facility, wherein the code and the corresponding code name are defined. Code master table in which the group to which the code belongs is defined, the department code table in which the prohibition list prohibiting the display of the code by department to which the user belongs and the group is stored, and the equipment ledger including the code name by the user When creating, refer to the code master table and department-specific code table, the code name that corresponds to the department to which the user belongs, and the group, to the equipment ledger, excluding the code name of the prohibition list. Since the database operation unit is displayed as a selection candidate, it is optimal for the department to which the user belongs when entering the equipment ledger. It can be displayed over de name.

It is a figure which shows the database structure of the equipment maintenance management system by Embodiment 1 of this invention. It is a figure which shows the software structure of the whole equipment maintenance management system by Embodiment 1 of this invention. It is a block diagram which shows the equipment maintenance management system by Embodiment 1 of this invention. It is a figure which shows the example of data of the equipment maintenance management system by Embodiment 1 of this invention. It is a flowchart which shows the process of the equipment maintenance management system by Embodiment 1 of this invention. It is a flowchart which shows the process of the equipment maintenance management system by Embodiment 2 of this invention. It is a flowchart which shows the process of the equipment maintenance management system by Embodiment 3 of this invention. It is a figure which shows the example of data of the equipment maintenance management system by Embodiment 4 of this invention.

Embodiment 1 FIG.
Embodiment 1 of the present invention will be described below.
FIG. 1 is a diagram showing a database structure of an equipment maintenance management system according to Embodiment 1 of the present invention.
In FIG. 1, a column definition table 11 is a table definition table that defines the contents of other tables, and manages attributes such as column IDs, names, data types, and the like of the tables managed thereby. The code group table 12 is a table for grouping codes, and manages names for group numbers. The code master table 13 manages names for codes. Each line is a code master. The department code table 14 is a table for managing codes in which a certain department ID cannot be used, such as power generation and power transmission, and an unusable court is registered as a prohibition list for the court group number. The user table 15 manages department IDs and names of users managed in the system. The department table 16 manages IDs and names of departments such as power generation and power transmission managed in the system. The equipment ledger table 17 manages specifications related to equipment.

FIG. 2 is a diagram showing a software configuration of the entire equipment maintenance management system according to Embodiment 1 of the present invention.
In FIG. 2, a user 21 executes an equipment ledger application. The equipment ledger application 22 is an equipment ledger application that is actually used by the user 21. The database operation unit 23 performs data search, data addition, and update to the database 24. In the first embodiment, the database operation unit 23 particularly determines a code master that can be used for the user 21 and returns the result to the equipment ledger application 22. Do. The database 24 is a database having the structure shown in FIG.
That is, the database operation unit 23 controls data search, data addition, and update in the database 24, the equipment ledger application 22 operates the database operation unit 23, and the user 21 operates the equipment ledger application 22. It has become.
The equipment ledger application 22, the database operation unit 23, and the database 24 constitute an equipment maintenance management system.

FIG. 3 is a block diagram showing an equipment maintenance management system according to Embodiment 1 of the present invention.
In FIG. 3, FIG. 3 shows the software of FIG. 2 configured as a system. The database device 1 is a server device in which the database 24 is arranged. The application server device 2 is a server device in which the database operation unit 23 and the equipment ledger application 22 are arranged. The display device 3 displays the result processed by the facility ledger application 22 and displays the equipment ledger input screen for the equipment ledger application 22.

FIG. 4 is a diagram showing a data example of the equipment maintenance management system according to Embodiment 1 of the present invention.
In FIG. 4, 11 to 17 are the same as those in FIG. In FIG. 4, specific data is input.

  FIG. 5 is a flowchart showing processing of the equipment maintenance management system according to Embodiment 1 of the present invention.

Next, the operation will be described.
First, the use restriction of the code master for the department to which the user belongs will be described.
In the system, a department ID to which the user 21 belongs is assigned to the user 21 for management. As for the department ID, the department table 16 manages the ID and name. In addition, what is defined in the equipment ledger table 17 to be operated is defined in the column definition table 11. An item for which a value is set in the code group number column of the column definition table 11 refers to the code master table 13 and indicates that the code and name are to be converted.
Also, in the department code table 14, a code that cannot be used by a department represented by a certain department ID such as power generation or power transmission is set, and this is registered as a prohibition list for prohibiting use by the department. Yes. In the data example of FIG. 4, the department ID = 101 represents that the code = 02 (code name = repair) of the code group number = G001 cannot be used.

FIG. 5 shows a processing flow until the user “A0001” (department ID = 101, department name = hydropower substation) logs in and the selection target is displayed in the item “reason for installation” on the equipment ledger input screen. Therefore, describe. In the following description, when “system” is described, processing of the database operation unit 23 is indicated.
In step S1, the user “A0001” (in the user table 15 in FIG. 4) logs into the system. In step S <b> 2, the system refers to the user table 15 and acquires the department ID “101” for the user “A0001”. Next, in step S <b> 3, the user “A0001” executes the facility ledger application 22.
In step S <b> 4, the system acquires column information in the equipment ledger table 17 from the column definition table 11. Next, in step S <b> 5, the system recognizes that the code group number “G001” is set in the column “reason for installation” in the acquired column definition table 11.

In step S 6, the system acquires a record with department ID = 101 from the department code table 14. Next, in step S7, it is recognized from the record of department ID = 101 of the departmental code table 14 acquired in step S6 that the code group number “G001” and code “02” are a prohibited list.
In step S8, data other than the code “02” and the code group number “G001” is acquired from the code master table 13. In step S9, the system displays the result of step S8. Of the data registered in the code master table 13 of FIG. 4, the code “02” (code name: repair) is not displayed because it is unavailable, the code group number is “G001”, and the code “ Data of “01” (code name: newly established) and “03” (code name: replacement) are displayed.
In step S10, the user “A0001” selects an appropriate installation reason from the displayed selection candidates.
Thereby, since the items of the prohibition list are not displayed, only the candidates required by the department to which the user belongs can be displayed on the display device 3.

According to the first embodiment, an appropriate installation reason can be selected from the installation reason list excluding the code master in which the use restriction is applied to the entire department ID “101” to which the user “A0001” belongs. The time required for master selection can be reduced.
Even when a large number of codes are registered in one code group, only a list that can be used in the entire department can be selected, so that an effect of reducing the input work time can be obtained.

Embodiment 2. FIG.
FIG. 6 is a flowchart showing processing of the equipment maintenance management system according to Embodiment 2 of the present invention.

The second embodiment relates to the use restriction of the code master depending on the type of equipment to be input.
The column definition table 11 has a subgroup number in addition to the code group number. A column in which a value is set for the subgroup number performs processing different from that in the first embodiment when referring to the code master table 13.
The system (database operation unit 23) refers to the code group table 12 by the subgroup number. If a parent code group number is set for the referenced code group, the code master table 13 is searched based on the parent code group number (“G002” in FIG. 4).

However, at this time, a character string (such as “100” in FIG. 4) consisting of “0” and “1” set in the search key column of the code group table 12 is acquired, and the digit where “1” is set. And an SQL statement for performing a fuzzy search so that a digit set with “1” in the search key column of the code master table 13 is searched.
For example, if the search key of the code group table 12 is “100”, “select * from code master so as to obtain data in which the first digit of the search key column of the code master table 13 is“ 1 ”. where search key like
An SQL sentence “1__” is generated. This is a fuzzy search statement that indicates that the part of “search key like“ 1__ ”” is the first digit = “1”.
This structure realizes more detailed usage restrictions depending on the type of equipment in the department.

Next, a processing flow for realizing more detailed usage restrictions depending on the type of equipment in the department will be described with reference to FIG.
In step S1, the user “A0001” logs in to the system. In step S <b> 3, the user “A0001” executes the facility ledger application 22.
In step S <b> 11, the system recognizes that there are three types of “breaker”, “electric wire”, and “insulator” as the equipment ledger table 17. Next, in step S12, the user “A0001” selects an equipment ledger table of “breaker” from the above three types. In step S <b> 13, the system acquires column information of the “breaker” facility ledger table from the column definition table 11.
In step S14, the system recognizes from the result of step S13 that the “manufacturer” column is the code group number “G002” and the subgroup number “G002_1”.

Next, in step S15, the system searches for the code group number “G002_1” in the code group table 12, and recognizes that the parent group number is “G002” and the search key is “100”.
Further, in step S16, the system generates an ambiguous search expression “search key like“ 1__ ”” from the search key “100”, and searches the code master table 13 under this condition. In step S17, the system acquires two code masters of code “001” (Mitsubishi Electric) and code “002” (Mitsubishi Chemical) as the search result of step S16.
Next, in step S18, the system displays the result of step S17. In step S19, the user “A0001” selects an appropriate manufacturer from the displayed Mitsubishi Electric and Mitsubishi Chemical.

According to the second embodiment, even within the same department, the manufacturer to be selected can be changed by changing the type of equipment to be input.
Company-wide, it is possible to display only the true selection candidates by changing the input candidates according to the equipment type from the code that is centrally managed as the “manufacturer code”, which improves user convenience and business processing efficiency. There is an effect to improve.

Embodiment 3 FIG.
FIG. 7 is a flowchart showing processing of the equipment maintenance management system according to Embodiment 3 of the present invention.
In FIG. 7, the processes in steps S1 to S3 are the same as those in FIG. 5, and the processes in steps S11 to S15 and steps S17 to S19 are the same as those in FIG. In FIG. 7, step S21 and step S22 are added after step S15.

The third embodiment relates to a method for simultaneously controlling the use restriction in the department and the use restriction of the code master depending on the type of equipment.
In the second embodiment, the department ID set for each user is not used. By using this department ID also in the second embodiment, it is possible to realize a process that combines both the use restriction by the department and the use restriction of the code master by the equipment type.

The processing flow in this case will be described below with reference to FIG.
Steps S1 to S3 are the same as those in FIG. Also, steps S11 to S15 and steps S17 to S19 are the same processes as those in FIG.
In FIG. 7, the process of step S21 is performed after step S15.
In step S <b> 21, the system generates an ambiguous search expression “search key like“ 1__ ”” from the search key “100”.
Next, in step S22, a code master in which the department ID “101” obtained as a result of the process of step S2 is prohibited from use is extracted from the department-specific code table 14, and an ambiguous search expression “search key” is excluded. Like '1__' AND NOT IN (SELECT code FROM code master WHERE department ID = 101 AND code group number = G002) ”is generated by adding to the result of step S21, and the code master table 13 is searched under this condition. .
Thereby, in step S17, the system acquires two code masters of code “001” (Mitsubishi Electric) and code “002” (Mitsubishi Chemical) as the search result of step S22.
Thereafter, Step S18 and Step S19 are executed.

  According to the third embodiment, the code master whose use is prohibited only for the department ID “101” is excluded from the manufacturers managed in the entire company, and the use restriction by the equipment type can be realized. Form 2 or more has the effect of improving user convenience and business processing efficiency.

Embodiment 4 FIG.
FIG. 8 is a diagram showing an example of data of the equipment maintenance management system according to Embodiment 4 of the present invention.
In FIG. 8, 11 to 17 are the same as those in FIG. In FIG. 8, the search key of the code group table 12 and the search key of the code master table 13 are both 6 digits. Also, nothing is registered in the department code table 14.

The fourth embodiment relates to a method for implementing the use restriction of the code master according to the department and the operation target equipment type without using the department-specific code table 14.
As an application of the method shown in the second embodiment, code master usage restrictions can be provided for both departments and equipment types without using the department-specific code table 14.
Of the data example of FIG. 8, the difference from the data example of FIG. 4 is as follows.
(1) There is no record in the department code table 14.
(2) The search key “100” (FIG. 4) in the code group table 12 is “100000” and “0” is added to the last three digits.
(3) The search key “100” (FIG. 4) in the code master table 13 is “100000” and “0” is added to the last three digits.

  In FIG. 8, department information is included in the search key. That is, by setting the upper 3 digits for the department “101” and the lower 3 digits for the department “102”, each code master table 13 of the corresponding code master table 13 does not depend on what department ID the user belongs to. If the data can be used with the department ID “101”, “1” is set in the first 1 digits of the first 3 digits, and if the data is not usable, the first 1 digit is “0”. Since the processing flow is the same as that of Embodiment 2, the description thereof is omitted.

According to the fourth embodiment, it is possible to realize the use restriction of the code master by the department ID and the equipment type without using the department code. If there are about two or three departments, the fourth embodiment that does not use the department code is easier to understand than the second embodiment.
However, as the number of departments increases, it is necessary to increase the number of digits of the search key, and the data maintenance performance decreases. Which one is used can be selected according to the number of departments.

DESCRIPTION OF SYMBOLS 1 Database apparatus 2 Application server apparatus 3 Display apparatus 11 Column definition table 12 Code group table 13 Code master table 14 Department-specific code table 15 User table 16 Department table 17 Equipment ledger 21 User 22 Equipment ledger application 23 Database operation part 24 Database

Claims (3)

An equipment maintenance management system for creating an equipment ledger including code names related to the equipment in order to maintain the equipment,
A code master table in which a code and a corresponding code name are defined and a group to which the code belongs is defined;
A department code table storing a prohibition list for prohibiting the display of the above codes by department to which the user belongs and the above group,
When the user creates an equipment ledger including the code name, the code corresponding to the department to which the user belongs and the group is referred to with reference to the code master table and the department code table. An equipment maintenance management system comprising a database operation unit that displays names as selection candidates for the equipment ledger, excluding code names in the prohibition list. The code master table defines a search key for searching the code name according to the type of the equipment ledger,
2. The facility maintenance management system according to claim 1, wherein the database operation unit displays the code name searched by the search key as a selection candidate for the facility ledger. An equipment maintenance management system for creating an equipment ledger including code names related to the equipment in order to maintain the equipment,
Code master table in which a code, a corresponding code name, and a group to which the code belongs are defined, and a search key for defining the code name is defined according to the department to which the user belongs and the type of equipment ledger ,
When the user creates an equipment ledger including the code name, a database operation unit is provided for displaying the code name retrieved from the code master table using the search key as a selection candidate for the equipment ledger. Equipment maintenance management system characterized by that.

Images