The whole solution of dispatching information system of power Enterprise Informationization system

I. PURPOSE of CONSTRUCTION

Dispatching Agency information submission and disclosure is an important way for power regulator to supervise the operation of power grid company, and it is an important way for power generation enterprises to understand the operation situation of power grid and other power generation enterprises in time, which helps to strengthen the coordination of plant network and ensure the safe and stable operation of power grid.

In order to standardize the information submission and disclosure behavior of the dispatching agencies, to clarify the responsibilities and division of the company's departments, to strengthen the information collection, audit, escalation process, improve the accuracy and timeliness of the information submitted, according to the National Electricity Regulatory Commission, the power dispatching agency information submission and disclosure measures and National Grid company related work requirements, Carry out the dispatch of power dispatching information.

At present, many power companies use Excel files to collect and manage power dispatching information data.

Because Excel is a stand-alone version of the software, in the process of data collection and management, the need to the level two departments to issue documents, two departments and then by mail, u disk and other ways to submit data. However, due to this kind of submission is not timely, the revision of data cumbersome, the distribution of updated sample procedures, such as complex problems, has been unable to meet the needs of data management. Therefore, the use of online direct reporting is an inevitable trend.

The use of online direct reporting method can not only overcome the above shortcomings, but also reduce the processing time of data acquisition, save manpower and material resources, improve the efficiency of enterprises to meet the growing business needs. Therefore, the establishment of dispatching information system is one of the important means to dispatch and disclose the power dispatching information.

Ii. Business Requirements 1, overall objectives

The overall objective of the scheme is to establish the data collection and submission platform for power dispatching information of provincial power companies, to complete the annual and monthly power dispatching and related information collection, and to enhance the timeliness of dispatching information submission and disclosure. At the same time, strictly abide by the unified requirements of the supervision of the submission standards, and ensure the quality of data reporting.

The system is proposed by the Transfer Center dispatching Department, the system users are mainly two units and related functional departments of the company headquarters, including dispatching Center, Development Planning Department, Infrastructure Department, Biotechnology Department, marketing department, Security Department, etc., the use of personnel from each department designated one or more special workers.

The report of the system is made by the center of the adjustment, the two-level units and functional departments according to the requirements, fill out the report through the unit or the Department of the leadership of the approval, by the center of the summary output Excel and then reported to the National network company.

Report by time can be divided into monthly and annual reports of two types, monthly report a total of 9, annual Report a total of 6.

All departments at the end of February each year to complete the annual information collation, submission work, monthly 3rd complete monthly information collation, submission work, in the Spring Festival, Xi., 51 and other statutory holidays, the 3rd working day of the month to complete the monthly information collation, submission work.

Dispatch Communication Center to summarize and collate the information submitted by various departments before 8th each month, complete the drafting of the company's documents and submit it to the power Supervision Department; The office compiles and collates the annual information submitted by various departments by March 20, and completes the drafting of the company's documents and submits it to the power Supervision Department.

2. Basic function Requirement

The basic functional requirements of the Power dispatch system include:

Function module	Goals to achieve
Report Design	Because of the unit nature of the enterprise, the staff in the daily work, the mastery of Excel is very skilled, so want to replace the tool can be smooth over, require the system report design using the operation of Excel-like interface, see that is the resulting editing mode, convenient for users to grasp quickly. With Excel-like cell design ideas, a variety of complex report formats can be directly reflected on the computer screen. To provide a list of additions and deletions, any combination of split cells, text boxes, graphic objects, cell properties and other operations, to help users quickly design any complex report format, including Slash, two-dimensional table, irregular format reports, and can realize the input format and print format exactly the same. Supports seamless import of Excel forms.
Data online reporting	As the most important function of power dispatching information system is data collection and reporting, the system must provide online input report data function, support numeric type, character type, date type, drop-down selection and other types of data entry.
Offline reporting/excel Import and export	The report contained in the system is the form of annual reports and monthly reports, so the table needs to fill in the data is not scattered directly collected in the daily data, but the relevant data aggregated figures, so users need to pass through a number of communication confirmation to determine the accuracy of the data, so that requires users in the completion of the data once completed there are certain difficulties , so the system needs to provide the way of offline operation to realize the offline data entry. In addition, since the system has not been widely used, so the final report to the regulatory body data still need to use the Excel method, it is necessary to be able to export the system final data to excel for escalation.
Automatic data calculation	Because the main function of the report is to collect all kinds of power dispatching information related data, so the statistical data is one of the basic needs of the system, the page when filling data, provide report data calculation function, support the automatic summary of data in the table.
Data approval	As the data filling and approval there is a time lag, so when the completion of the completed, after the approval of the approver, the data is locked, the page supports displaying the current data review and approval status. At the same time, support the approval of the return function, to support the approval of the report to audit the data, to return the non-approved data.
Historical data Query and reuse	After final approval, the user's data will be stored in the database as historical data, and the user can query the history from the database at any time as reference by constructing the query criteria, or directly query a similar historical data directly for reuse before filling in the current data.
Submission Status Inquire	System for the completion, approval time has a relatively strict limit, so it is necessary to provide a record of each operation type, operator, time Point, in order to carry out the status of data submission query function, can query the report, audit, approval statistics and user list, convenient as the data basis for the work evaluation.

3. Other functional requirements

(1) Organization system supporting multi-level escalation unit

For enterprises, level two units, functions of multi-level reporting features, all levels of reporting units from top to bottom can be unified use of the submission platform, the completion of data reporting and receiving work.

(2) Report system supporting multi-report level and multiple report types

Because each report is covered in a number of different dimensions of the statistics, so the system needs to support the column fixed table (two-dimensional cross-table) of the completion, also support the number of rows can be arbitrarily increased table (row variable length table).

(3) Client should not need installation program, maintenance-free, 0 management

Using the system end users do not need to install the application, directly in the browser to fill out data, audit, escalation and other operations, if the software upgrade, do not need to download software and report parameters, directly in the browser update, do not affect the report task and data, do not need to spend time to maintain, management.

(4) Data classification management mechanism

System involves a number of different departments, the data are also varied, in order to ensure the security of data, support hierarchical management data mechanism, the system according to the role of the logged-in user, automatically lock the user access to the data range, to ensure the security of data.

(5) Using a report-oriented system design, users need not master database knowledge

Based on the need for data storage, the system should be able to design and manage the database according to the report format, making the database transparent to the user. As end users do not need to understand the report data storage and other knowledge, just care about their report format and reporting scope.

Given the complexity of the above functional requirements, Finereport is the only option to implement the tool.

Iii. general overview of System Construction 1. General Ideas

The power dispatching information submission system mainly relies on the network platform construction. The basic idea is: to build national and provincial unified dispatching information direct reporting platform and data center, to realize the power dispatching information on-line report or data collection; To set up unified dispatching information standard, including database structure and information exchange standard; Through permission setting, realize Vertical province, business department level two management; through firewalls, User login password and other hardware and software methods to solve the data transmission process of confidentiality and security issues, the realization of dynamic statistical analysis, resource sharing and data exchange. With this goal requirement, the overall scenario selects the Finereport Reporting tool as the implementation tool.

2. System Framework

The power dispatching information submission system consists of three-level system, which is a distributed application system. The database of the provincial center and the Other level two information center is considered as a node, which makes up the information node tree. On each node, the scheduling information Direct report system is built, and the local database is attached, and the nodes and nodes are connected by application route to form a tree topology which can pass the request to each other. This constitutes a nationwide, distributed information Network. As follows.

According to the overall design and construction ideas of the system, the application System framework is as follows:

3. System Features

? Data direct reporting, hierarchical management. The dispatching information system is the guarantee of timely and reliable decision-making, and the hierarchical management is the guarantee of the orderly operation of the whole system. The former is the need of business nature, is the necessary condition for establishing the information submission system of electric power dispatching, the latter is the decision of organizational structure at all levels, the precondition and guarantee that information system can run normally and play a role.

? Information sharing to improve efficiency. Realize the horizontal connection between power information dispatching system and other operation system of Provincial power company, achieve the purpose of information exchange and resource sharing, and improve the utilization efficiency of information resources.

? Centralized management of information applications. The establishment of a nationwide network of power dispatching system database, completely changed the previous report period long, the information upload release slow, the situation of poor timeliness. Through the joint use, the appropriate opening up these information resources, improve the timeliness of power information, accuracy, sensitivity, sharing and data analysis capabilities.

The whole solution of dispatching information system of power Enterprise Informationization system