Design And Application Of University Personnel Management System With The Function Of Information Remote Collection

With the development of computer technology, Information Management System is widely used in walks of life. Personnel Management is complicated work. Labor management will result in low speed, inaccuracy and wasting resource.The research on Personnel Management System is developed earlier in China. However, at present there is not a uniform standard. So development systems are diverse with their advantages and disadvantages and limitations.Some of systems are stand-alone PC edition which can be operated on one computer and can not be widely used. Others adopt C/S mode development, which enlarges the applying scope but can not exceed the limitation of Local Network. Since Inner Mongolia University for Nationalities consists of three campuses and the three parts are far away from each other, C/S mode is obviously not suitable for the university. B/S system mode enlarges the applying scope but brings system safety hazard and it is not convenient to process a large amount of data.The Personnel Management System not only processes a large amount of integrated data but also enlarges applying scope. It is worth mentioning that the development of campus network manages to offer the hardware environment for this request.At present, Inner Mongolia University for Nationalities is in the critical period for innovation and development, whose faculty is over 2600 and personnel structure is complicated. Since the university administration set down the policy to attract talents, the increase of the high-level talents posts the big challenge for Personnel Management work.At the present time, the management of university is on the stage of labor controlling. Staff in Personnel Department is in charge of a volume of work. In this process, management is not in time and some errors may appear. Therefore, it is necessary to develop an efficient and convenient Personnel ManagementThe design of the system should fully meet the requirement of Personnel Department. The mixture of C/S and B/S mode needs to choose an efficient and reasonable database. It is known that MS SQL Server has good compatibility. In addition, it has the function of fast developing internet system besides expansibility and reliability. In particular, it can store XML data directly and output the searching result in XML format. So it constructs the interoperability of different structures and lays solid foundation for the application and service of internet enterprises. These features play an important role in NET strategy.So this paper adopts MS SQL Server 2000 Enterprise edition which can meet the requirement of integrated management in C/S system. Meanwhile, it can also collect remote information on the Internet.According to the requirement, we ought to design the database structure logically in order to meet the requirement of Application System.Organization form is set up to realize the function of system accordingly. Department form is convenient to manage the faculty in each department. Faculty basic information form is used to manage the basic information of the faculty and at the same time to provide essential basis for other enquiry functions like remote information management. Educational level and degree form is to manage the further study and the change of degrees of the faculty. Resume form is to manage and refer to the status of work change. Titles form is used to confer the academic titles of the faculty and refer to appointment things of them. Administrative and Party post form is to manage the change of the faculty's duty. Resignation form is used to manage the resigned of the faculty. Job transfer form is used to follow the specific conditions of the faculty. Post shift form is for managing and inquiry about post shift conditions of them. Retirement form is to manage the retired teachers. Award form is used to record and refer to award conditions of them. Punishment form is for recording and referring to the punishment conditions of teachers. Research paper form is to record the papers of the faculty in the scientific research. Research program form is for recording the works of the faculty in the scientific research. Scientific research program form is to record their programs in the scientific research. Contract form is used to record various contract signed between the faculty and the university and the performance and breach of contract. Archive form is used to record the saving, filing in, referring to, transferring the files of the faculty. Salary form is set up to realize all-around management of the faculty.Program mainly consists of the following modules:Setup organizing module deals with the details of the setups, coding, modification and inquiry of the university.Staff information module deals with staff information maintenance and inquiry.Curriculum vitae management module deals with educational level and degree, resume, titles evaluation, administrative post holding, etc. Job transfer module deals with the readjustment, transfer conditions of the faculty.Award and punishment module records and offers the awarding and punishment conditions of the faculty.Scientific research management module deals with the recording, modification and enquiry about the papers, books and scientific research programs of the faculty.Contract management module records various contract signed between the faculty and the university and the performance and breach of contract. Archive management module deals with the basic information, file inquiry recording, file transferring and file reading, etc.Salary management module offers the state of monthly salary, income tax formula, enquiry about the history of salary payment, the setup of the awarding and punishing salary.The software is explored in the mixture mode of C/S&B/S. MS SQL server is used as database with the characteristic of high speed, safety and stability. At the beginning, development tool adopts Power Builder and ASP thus making the personnel Department use of C/S System using Visual Basic as the development tool , setting up ActiveX control program, and coding and forming OCX control, and then insert it into ASP web pages.Staff can visit the website of Personnel Management Department in Inner Mongolia University for Nationalities at any computer which has access to internet without any limitation and they can fill in and modify their information about papers, books and scientific research programs and store the information in the database after verified by the Personnel Management Department. Therefore, the information remote collection is realized.The system of"Design and application of University personnel management system with the function of information remote collection"is developed according to the needs of Personnel Management Department in Inner Mongolia University for Nationalities, based on the fully analysis of demand.The software can manage daily personnel work, making the best of modern network environment and realizing remote information collection, and meet the need of Personnel Management in Inner Mongolia University for Nationalities.