高校薪酬系统的设计与实现

发布时间：2018-03-04 22:26

本文选题：高校薪酬　切入点：工资模板　出处：《山东大学》2016年硕士论文　论文类型：学位论文

【摘要】：随着计算机技术的不断发展,各行各业的管理系统也渐渐走向信息化,高校作为社会人才培养基地,更加需要走在信息化发展的前列,所以高校的信息化建设是一项十分重要的项目,高校薪酬管理系统的信息化建设也是其中重要的一部分,高校薪酬管理系统将学校教师、行政人员等的工资发放进行管理,薪酬系统对工资的计算准确性和数据的准确存储都有较高的要求,因此系统的设计要有一个良好的工资计算算法、数据库设计和良好的交互。高校的教师队伍分为非事业编制人员和事业编制人员,他们的工资计算都有不同的准则,需要进行不同的计算算法的设计。非事业编制人员和学校签订劳动合同,根据基本的工资标准来确定基础工资。并对其公积金和社保进行单独的管理,公积金和社保基数的确定是其计算的基础,公积金和社保要根据我国相关政策的规定来确定个人缴纳比例和学校缴纳比例。事业编制人员的工资计算要根据工资套改表中的规定来进行,工资套改表是基于我国的具体政策来制定的,事业编制人员的绩效计算则是通过学校拨款给各学院,学院根据相关的政策规定进行发放。由于薪酬的准则都是根据国家的政策来制定的,所以当政策有调整时,要求系统的管理功能要进行相应的调整,所以对系统的灵活性和适应性有较高的要求。系统中工资计算方法是通过为每一个人维护一个工资模板来实现的,工资模板中记录所有工资项的实际金额的静态数据,而将各个工资项的动态变化过程单独进行管理,系统根据每一个工资项的变化法则将其动态变化过程进行封装。要修改工资模板时,首先确定需要修改的工资项,然后根据封装起来的法则进行计算,最后将计算结果写入到工资模板中。月工资的计算只需要将工资模板中各个工资项进行加减操作即可得到当月工资。将静态的数据和动态的变化过程进行分离,使各个模块的功能更加专一化,方便对每一个工资项的维护,同时也方便对月工资的计算。工资数据要求较高的计算准确性,并且要求工资数据保留小数点后两位,对于薪酬涉及到的所有变动都要记录下来,包括人员的变动情况和每月的工资发放情况等。将所有的工资变动情况都记录在数据库中,通过优化sql语句和增加查询条件等方式提高查询的速度,并且提供人员和月工资等记录导出以及薪酬计算的功能。系统工资计算过程正确,目前大部分功能已上线使用。
[Abstract]:With the continuous development of computer technology, the management system of various industries is gradually moving towards informatization. As a social talent training base, colleges and universities need to be in the forefront of the development of information technology. Therefore, the informatization construction of colleges and universities is a very important project, and the informatization construction of the salary management system of colleges and universities is also an important part of it. The salary management system of colleges and universities will manage the salaries of teachers, administrators, etc. The salary system has high requirements for the accuracy of salary calculation and accurate storage of data, so the design of the system should have a good wage calculation algorithm, Database design and good interaction. College teachers are divided into non-career staff and career staff, their salary calculation has different criteria, It is necessary to design different calculation algorithms. Non-career staff and schools sign labor contracts, determine basic wages according to basic wage standards, and separately manage their provident funds and social security. The determination of the base of provident fund and social security is the basis of their calculation. The provident fund and social security shall be determined according to the provisions of the relevant policies of our country to determine the proportion of individual contributions and the proportion of school contributions. The salary calculation of the career establishment personnel should be carried out in accordance with the provisions in the wage set change schedule. The salary package is based on China's specific policies, and the performance of career staff is calculated through school grants to colleges. The college pays according to the relevant policy regulations. Since the salary criteria are all formulated according to the national policy, when the policy is adjusted, the management function of the system is required to be adjusted accordingly. Therefore, there is a high requirement for flexibility and adaptability of the system. In the system, the method of wage calculation is realized by maintaining a wage template for each person, which records the static data of the actual amount of all wage items in the wage template. The dynamic change process of each wage item is managed separately, and the system encapsulates the dynamic change process of each wage item according to the change rule of each wage item. In order to modify the wage template, the salary item that needs to be modified is first determined. And then we do the calculations according to the encapsulated rules, Finally, the calculation results are written into the wage template. The calculation of monthly wage only needs to add and subtract each wage item in the wage template to get the current month's wage. The static data is separated from the dynamic change process. Make the functions of each module more specialized, facilitate the maintenance of each wage item, at the same time, it is convenient to calculate the monthly wage. The wage data require higher calculation accuracy, and require the wage data to retain two decimal places. For all changes related to remuneration, including changes in personnel and monthly payroll, etc. All salary changes are recorded in the database, This paper improves the speed of query by optimizing sql statements and adding query conditions, and provides the functions of record exporting and compensation calculation of personnel and monthly wages. The calculation process of system wages is correct, and most of the functions have been used online at present.
【学位授予单位】：山东大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.52

【相似文献】