The Design And Implementation Of Salary Project System In Colleges

With the continuous development of computer technology, all walks of life have gradually moved towards to information. Colleges are training base of social talents and they need to lead the development of information technology, so the information of colleges is a very important project. College salary management is an important part of information construction. The management system of college salary manages the process of salary of teachers and administrators. The system requires higher wage calculation accuracy and data storage. So the system is designed to have a calculation algorithm of wages, database design and good interaction.In terms of wage calculation, the wages have different wage guidelines as the teachers are mainly divided into institutional people and unofficial staff, who have different wage guidelines and they need to carry out the design of different algorithms. These people who are not official staff need sign labor contract with school. The base salary is determined by basic wage standards and the accumulation fund. The social insurance is managed separately. The accumulation fund and social insurance are determined to pay personal part and school part by different proportions according to the provisions of the policy. The wage calculation of institutional people is determined by salary cover change table and salary cover change table is designed by country’s specific policy. The performance of institutional people is appropriation which is appropriated by the school to the college and the college handed out by the relevant policies. As the criterion of the salary is determined according to the national policy, so when policies are adjusted, the system of salary needs to make the corresponding adjustment. As a result, the system has higher requirements in flexibility and adaptability.The wage is calculated by maintaining wage a template for each individual in this system. The template records the actual amount of all salary items through static data and the dynamic process of each wage are packaged according to the law of wage terms. To modify wage template, first we should determine the salary item that need to modify and second we should write the result which is calculate based on encapsulated rule to the salary template. The calculation of month salary is just to add and subtract terms of salary template. The separation of static data and dynamic process makes the function of each module more single-minded and is easy to maintain a wage for each item and facilitate the calculation of the monthly wage.Salary data require high accuracy of the calculation, so the accuracy of the salary data should be retained two digits after the decimal point and all the related changes need to record. The whole system using the decimal data type to retained two digits. All wage changes are recorded in the database. We use some methods to enhance the speed of query by optimizing the sql statements and increasing query conditions, and the system provide personnel records and monthly wages derived function.The calculation of salary is correct, most of the current features have been used on the line.