ERP system of Philwong for petroleum service industry
2006-10-27

1.3.1 system abstract

These systems are the integrated scheduling system of business resources for the petroleum service business of oil field. The modules are composed by the basic the data management, the operation planning management, the engineering management, the contract management, the production control, the facility management, the inventory management, the cost control, the well historical data management, the personnel management, the records management, the training supervise, the quality safety and environmental protection management, group management, the system maintenance management and the business application integration and the subsystem such as OA and the shared SQLServer database and ORACLE database and the document database. The relation of each subsystem is the “coupling relation of the common environment” and it’s not existed the invoke relation for each other. And the relevancy is done through the shared database. For reporting data from all levels branch to head office of the oil field enterprise engineering services corporationmonthly reportquarterly reportannualand realizing data high shared, the maintain decision support and analyses is supplied, to increase work efficiency.

 

 

1.3.2 the abstract for the function

1business integration and official platform

Making full use of the available resources of the petroleum service company, (include the existed resource of the network and application system), following the principle without influencing the original system, the unified enterprise-level application platform (Internet / Intranet unity) of the drilling engineering company is builtto form one integrated information platform with possessing produce, supervise, decision-making, and to form one integrated system with the visualization interactive supervision, query, release, analyses, application for the production information. So the unified business application integration platform with the flow of the data, the information and document (Office Automation System contained) is formed. The integrated inquiry interface of the ERP business application system is established based on Internet. The business application integration platform uses the WEB mode to show the enterprise information, and to centralize management information, and to realize the opening supervise of the corporate, and to enlarge vision of the leader’s decision.

The business application integration includes the synthesis query for each module in the ERP system, the statistical analysis for history data, decision analysis, the OA system and the other common information, etc.

2basic data management

The basic data refer to public-used, common data of each subsystem which erected before operation of the systems, few amended during operation. In these systems, the standard coding and base attribute descriptor of the basic data and systemic role authority is managed partially. In addition, the subsystem possesses the function with system maintenance. The relation of each subsystem is referred to “the coupling relation of the common environment”. It is through designing for shared basic subsystem that insure high shared of each subsystem data and the consistency of data. The shared basic data code is specified as follows, in order to make easy to invoke each subsystem. The data basic management subsystem is designed primarily for maintenance of different kinds of data base and operation authority, to increase system performance of the mobility, expandability, versatility, manageability, functional mightiness.

3operation planning management

The management plan can be broken into two divisions as overall planning and project plan. The overall plan mostly establish map each term technical and economic target of the enterprise year and quarter, and includes business cost indices, performance indicator, indicator of labor productivity, safety figure, environmental record, quality index, etc. The project plan mostly establish the special item plan such as technological transformation, technical measures, engineering fixes, equipment rebuilding, construction schedule, and include ?the fund plan, scheduled plan, manpower, disposition of equipment distribution of the item. So thatwe could divide the subsystem of the operation planning management to the overall planning and the project planning. The working for planning management is in charged of the program manage ministry, and each functional department preside establish this own plan of operation which is overall balanced by the planning management ministry before distribution to executive, so it possess features of overall balance and merging management.

4engineering management

The engineering management focus on the project, include beckon tender, project budget, project implementation, the qualification and credit. The project budget include the periodic budget, the petroleum engineering services expense standard, the periodic budget of the standard budget, straight well, horizontal well, directional well. The method of which is based on periodic standard and the expense standard budget and the related calculated formula of the petroleum engineering services, and come out the period of the related item and expense budget with them. It supplies convenience for the project budget of expenditure. The priority of the petroleum service engineering management mostly is the project budget, furthermore, include other managements such as the beckon tender, the qualification and credit, project operation.

5contract management

The contract management subsystem is composed by the contract declaration management, contract text management, contract registration management. The contract declaration management realizes the function for examination and verification and approval in electron. And the contract text management realizes the function of form management for contract. And the contract registration management realizes the function of registration for contract basic data and summary for the data statistics, exportation management for the contract machine account journaling accounting.

6production control

The production control subsystem involves each post’s business of the production department of the petroleum engineering services corporation, and accelerate the speed of transfer and share of different kinds of production data informational, to collect and analyze timely, accurately, scientifically, to apply secure for all levels production unit of the drilling engineering corporate, to provide scientific basis for correlation all levels leading decision, to lead everyday production operations management from “experience type” to “science type”. Thereby, the producing cost is reduced, to increase the economic benefit of wholly drilling engineering corporate.

7well history data management

The well history data management is processed for overall procedural data dynamic data, the technical parameter during drilling. Which contains the technology parameter of daily well drilling data, the service condition data of drilling tool, the coring data, the data of drilling fluid and completion fluid, the drilling crew background data, the drilling crew, the hole geology, the drilling tools, the hole base situation data, the directional well data, the accident complex data, the well logging data, the fixed well data, the completed well data, the well control information, the drilling tech, the drilling reports, etc.

8cost control

The cost control is primarily integrated management for the consumption and outlay during the process of production, and the one large mission of the cost control is cost accounting. This module is just reflected exactly that consumption and outlay, and through strengthening the inner management, the consumption and cost could be reduced, run up to increase the economic benefit. In order to ensure accuracy and credibility for cost accounting, this system realize operable scientific means for cost accounting, to check generally and calculate correctly for data, then the cost budget, cost analysis is processed based on cost accounting.

9Customer management subsystem

The customer management subsystem is managed in all round way from such several aspects as the market analysis, the market development, and service after sale. It can be generated record to keep kinds of bolls of transaction for basic daily business, to form machine account of completed well, to statistically analyze status of client. The more outstanding function of the system is as follows: collecting market information to forecast market position for outside; inquiring and statistical analyzing widely for inside, to handle the situation as produce, finance, equipment and stock. Thereby it would be serviced for establishing best market strategy, decreasing fund backlogging and increasing economic benefit. The customer management can be able to trace client information timely, to manage payee and no-payee. In this way, it facilitate corporation inquiring possession situation of client, to increase collecting scope and depth of corporation market information, and to be history data as replicate analysis. This system mostly covers such as the client gathering supervise, the client inquiry supervise, the market forecast supervise, the foundation client machine account, the setting-up for kinds of analytical diagram. And it could help administrator analyzing the current market actuality and the market development trendto show the data of client with different kinds of diagrammatic mode.

10Facility management.

With the help of the Facility management, all the equipments are always under in a state of favorable technology, because they are used on the basis of integrated management, overall planning, reasonable configuration, good selection, correctly using, carefully maintenance, science overhaul, renewal and reclaim in time. It can ensure the enterprise work proportionately, the life of the equipments the most economic. As a result, it can get better investing benefit. This subsystem works for? the function of coding, foundation, configuration, allocation, disposal, stock-taking, repair of equipments and dynamic data management.

11Inventory Management.

Inventory management subsystem includes material planning subsystem, store management subsystem. The material planning subsystem material linking the dealing activities of the petroleum project service companies and others belonging to the formal, includes not only the common dealing in enterprise management, but common decision of all the levels of management. In the require of materials planning subsystem, users working in different level of the subsystem should be not only dependent, but be easy to link, so that it will become a good way for our enterprise to control the cost, guide the supervision of the planning, product at the lowest cost. On the other hand, the requirement of materials planning subsystem can help material administrator on duty control and complete the ability to apply, check, report the materials and accept them to the stock. Therefore, it can be efficient to control the implementation of the requirement of materials planning system, and make the work of materials management run efficient at high quality, and low cost.

12Quality and Environment Management

This system should closely surround human, environment, quality and establishment four elements, with the goal of "higher quality, prevent accident, protect environment, promote health.” In addition, the function of this system includes managing security, environment, health, accident and risk.?

13Training Management

       This subsystem aims at correctly collecting detailed training managerial materials in time in order to provider the leadership, each all concerned department and all the employees efficient, accurate training managerial information. The Training Management Subsystem includes personal demand training, training in planning project, training out of planning project, training file card, inquiry for the effect of training, assessment of the effect of training, training query, training account management and so on.

14Human resource Management

The Human resource Management subsystem includes management of the archives, education, attendance, transfer, salary, and insurance of the employees. With the help of this system, all the information of the enterprise including his position, achievement, experience of education, personal quality and so on, can be showed dynamically. So, by using this subsystem, it will be very convenient to get after each all department to carry out related education and training activities for employees, show the attendance of each employee monthly, arrange and analyze the attendance information, enforce the management of people, strengthen the force of condensation, provide the accurate and all-around requirement information to the final decision of the leadership, greatly detract the labor intensity of the accountants. Besides, it can announce the post requirement information online. Correspondingly, the employees can select the right position, which greatly promotes the employee more active and positive.

15Files Management

The Files Management System can integrally manage all the files in the project of petroleum Service Company. Via advanced computer network technology, the system can combine writ record, science record, and accountant record. So, it can manage the file information scientifically as well as use it efficiently. Fully developing the file resource, it will enable petroleum Service Company record modern management get ahead.

  (16)Party-group Management Subsystem

It’s a subsystem that is mainly used to manage the party business, China Young League and labor union. It is used to strengthen the management of member and to encourage each employee to play an active role in the process of production; to reinforce the management of labor union organization and protect the legitimate rights and interests of employees so that they will not have anything to worry about;

To increase the grade of advertisement of the corporate image, create a good atmosphere for enterprise culture, and enhance their market competitiveness.

The system include these three parts below:

Party business management: it includes registering account of important work of the committee of party, recording the superintend, checking instance, announcing information to the concerned departments as well as constructing name list of party member, registration form of the fee, statistical result about the situation of developing party member, the account of party member, and the detailed information of each party member. In addition, the subsystem can provide convenient query function to inquiry the information about the party member in order to master the information dynamically.

Labor union management: it will construct the name list of member; make the fee statistics of member; found the account of ill employees; provide convenient and flexible query function. And then the company can arrange their activities to look and condole their ill employees in terms of the above information.

Communist Youth League management: it can establish the member name register, the statistics and member account; dynamically analyze the member’s composition situation; promptly grasp the member's tendency; recommend the excellent league member to the party; master the situation about the application to join the party. All in all, the subsystem can establish registration account of people in the right age and keep abreast of their each kind of situation.

1.3.3 Operating environment

  1. Server

HardwarePC Server

Platform of SoftwareMS SQLSERVER

Operating SystemWinNT/Win2K

  1. Client:

Operating SystemWin98/WinXP

1.3.4 Typical Users

    • DaGang well drilling company
    • CangQing oil field mine shaft company
    • TuHa oil field well drilling company