Salary data processing method, device, equipment and storage medium

By obtaining and matching holiday information, and combining the salary level table, salary information is automatically generated, the problems of accuracy and inefficiency in traditional salary data processing are solved, and the unified processing of salary information stipulated by different departments and holidays is realized.

CN114092066BActive Publication Date: 2024-11-05CHINA RAILWAY NO 8 ENG GRP CO LTD +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202111437856.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-11-29
Publication Date
2024-11-05
Estimated Expiration
2041-11-29

AI Technical Summary

Technical Problem

Traditional salary data processing has problems of accuracy and inefficiency, especially when facing complex salary systems and dynamic holiday regulations, manual processing is difficult to ensure the accuracy and efficiency of data.

Method used

By obtaining holiday information, generating a holiday information record table, and extracting date information when receiving salary data processing instructions for matching, calling the preset salary level table, and automatically generating salary information using attendance information to achieve the unification of different departments, ranks and holiday regulations. deal with.

Benefits of technology

It improves the accuracy and efficiency of salary data processing, can dynamically process different holiday regulations, reduces the workload of manual processing, and realizes the unified processing of salary information.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114092066B_ABST
    Figure CN114092066B_ABST
Patent Text Reader

Abstract

The present invention discloses a salary data processing method, device, equipment and storage medium, the method comprising obtaining holiday information and generating a holiday information record table; upon receiving a salary data processing instruction, extracting the first date information of the holiday information record table and the second date information of the target employee; matching the first date information with the second date information to generate the attendance information of the target employee; calling a preset salary grade table to obtain the salary rules of the target employee, and using the salary rules and attendance information to generate the salary information of the target employee. The present invention sets the holiday information in advance, matches the holiday information with the employee's attendance date, generates the attendance information corresponding to the target employee, and then automatically generates the employee's salary information by calling the target employee's salary rules, so as to realize the unified processing of the salary information of employees of different departments, different ranks and different holiday regulations, and improve the accuracy and efficiency of salary data processing.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a salary data processing method, device, equipment and storage medium. Background Art

[0002] The salaries of employees in modern enterprises are often determined by a variety of factors; for example, employees in different departments have different attendance requirements, employees at different levels have different salary plans, and different regions have different holiday regulations. This greatly increases the workload of salary management personnel when calculating salaries.

[0003] At present, traditional salary data is processed manually. In the face of increasingly complex salary systems and dynamic holiday regulations, the accuracy and efficiency of salary data processing are difficult to be effectively guaranteed. Therefore, how to improve the accuracy and efficiency of salary data processing is a technical problem that needs to be solved urgently.

[0004] The above contents are only used to assist in understanding the technical solution of the present invention and do not constitute an admission that the above contents are prior art. Summary of the invention

[0005] The main purpose of the present invention is to provide a salary data processing method, device, equipment and storage medium, aiming to solve the current technical problems of low accuracy and efficiency in salary data processing.

[0006] To achieve the above object, the present invention provides a salary data processing method, which comprises the following steps:

[0007] Get holiday information and generate a holiday information record table;

[0008] Upon receiving the salary data processing instruction, extracting the first date information of the holiday information record table and the second date information of the target employee; wherein the target employee is the employee corresponding to the salary data processing instruction;

[0009] Performing date matching on the first date information and the second date information to generate attendance information of the target employee;

[0010] The preset salary grade table is called to obtain the salary rules of the target employee, and the salary information of the target employee is generated by using the salary rules and the attendance information.

[0011] Optionally, the holiday information includes statutory holidays and / or special holidays; the step of obtaining the holiday information specifically includes:

[0012] Receiving a statutory holiday table imported by a user, and extracting dates corresponding to statutory holidays in the statutory holiday table; and / or

[0013] Receive special holiday information input by a user, and extract the date corresponding to the special holiday in the special holiday information.

[0014] Optionally, the step of generating a holiday information record table specifically includes:

[0015] A calendar is generated using the holiday information, and the holiday days in the calendar are marked to obtain a holiday information record table.

[0016] Optionally, the salary data processing instruction includes a target employee; the step of extracting the first date information of the holiday information record table and the second date information of the target employee specifically includes:

[0017] Traversing the holiday information record table, extracting dates without marks to generate first date information;

[0018] The attendance sheet of the target employee is imported, and the date with the attendance record is extracted to generate the second date information.

[0019] Optionally, the salary data processing instruction further includes a target period; the step of extracting the first date information of the holiday information record table and the second date information of the target employee specifically includes:

[0020] Traversing the holiday information record table, extracting the dates without marks in the target period to generate first date information;

[0021] The attendance sheet of the target employee is imported, and the date with attendance record in the target time period is extracted to generate second date information.

[0022] Optionally, the attendance information includes working days and overtime days; the step of performing date matching between the first date information and the second date information to generate the attendance information of the target employee specifically includes:

[0023] Based on the first date information, the dates in the second date information that are the same as the first date information are marked as working days, and the dates in the second date information that are different from the first date information are marked as overtime days.

[0024] Optionally, the step of calling a preset salary grade table, obtaining the salary rules of the target employee, and using the salary rules and the attendance information to generate the salary information of the target employee specifically includes:

[0025] Calling a preset salary grade table to obtain the salary rules of the target employee; wherein the salary rules include working day salary rules and / or overtime day salary rules;

[0026] The working day salary rule and / or the overtime day salary rule are used to calculate the salary of the target employee on working days and the salary on overtime days, respectively, so as to obtain the salary information of the target employee.

[0027] In addition, in order to achieve the above-mentioned purpose, the present invention also provides a salary data processing device, the salary data processing device comprising:

[0028] The acquisition module is used to obtain holiday information and generate a holiday information record table;

[0029] An extraction module, configured to extract the first date information of the holiday information record table and the second date information of the target employee upon receiving the salary data processing instruction; wherein the target employee is the employee corresponding to the salary data processing instruction;

[0030] A matching module, used for performing date matching between the first date information and the second date information to generate attendance information of the target employee;

[0031] The generation module is used to call a preset salary grade table, obtain the salary rules of the target employee, and generate the salary information of the target employee by using the salary rules and the attendance information.

[0032] Optionally, the holiday information includes statutory holidays and / or special holidays; the acquisition module is also used to receive a statutory holiday table imported by a user, and extract the dates corresponding to the statutory holidays in the statutory holiday table; and / or receive special holiday information input by a user, and extract the dates corresponding to the special holidays in the special holiday information.

[0033] Optionally, the acquisition module is further used to generate a calendar using the holiday information, and mark the holiday days in the calendar to obtain a holiday information record table.

[0034] Optionally, the salary data processing instruction includes a target employee; the extraction module is further used to traverse the holiday information record table, extract dates without marks to generate first date information; import the attendance sheet of the target employee, extract dates with attendance records to generate second date information.

[0035] Optionally, the salary data processing instruction also includes a target time period; the extraction module is also used to traverse the holiday information record table, extract the dates without marks in the target time period to generate first date information; import the attendance sheet of the target employee, extract the dates with attendance records in the target time period to generate second date information.

[0036] Optionally, the attendance information includes working days and overtime days; the matching module is also used to mark the dates in the second date information that are the same as the first date information as working days, and mark the dates in the second date information that are different from the first date information as overtime days based on the first date information.

[0037] Optionally, the generation module is also used to call a preset salary grade table to obtain the salary rules of the target employee; wherein the salary rules include working day salary rules and / or overtime day salary rules; using the working day salary rules and / or the overtime day salary rules, the salary of the target employee on working days and the salary on overtime days are calculated respectively to obtain the salary information of the target employee.

[0038] In addition, in order to achieve the above-mentioned purpose, the present invention also provides a salary data processing device, which includes: a memory, a processor, and a salary data processing program stored in the memory and executable on the processor, and the salary data processing program implements the steps of the above-mentioned salary data processing method when executed by the processor.

[0039] In addition, in order to achieve the above-mentioned purpose, the present invention also provides a storage medium, on which a salary data processing program is stored, and when the salary data processing program is executed by a processor, the steps of the above-mentioned salary data processing method are implemented.

[0040] A salary data processing method, device, equipment and storage medium proposed in an embodiment of the present invention includes obtaining holiday information and generating a holiday information record table; upon receiving a salary data processing instruction, extracting the first date information of the holiday information record table and the second date information of the target employee; matching the first date information with the second date information to generate the attendance information of the target employee; calling a preset salary grade table to obtain the salary rules of the target employee, and using the salary rules and attendance information to generate the salary information of the target employee. The present invention pre-sets the holiday information, matches the holiday information with the employee's attendance date, generates the attendance information corresponding to the target employee, and then automatically generates the employee's salary information through the target employee's salary rules, so as to realize the unified processing of the salary information of employees in different departments, different ranks and different holiday regulations, and improve the accuracy and efficiency of salary data processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 This is a schematic diagram of the structure of a salary data processing device in an embodiment of the present invention;

[0042] Figure 2 It is a flowchart of the first embodiment of the salary data processing method of the present invention;

[0043] Figure 3 It is a flowchart of a second embodiment of the salary data processing method of the present invention;

[0044] Figure 4 is a flow chart of a third embodiment of a salary data processing method of the present invention;

[0045] Figure 5 is a flow chart of a fourth embodiment of a salary data processing method of the present invention;

[0046] Figure 6 The figure is a structural block diagram of a salary data processing device in an embodiment of the present invention.

[0047] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0048] It should be understood that the specific embodiments described herein are only used to explain the present invention, and are not used to limit the present invention.

[0049] The salary of employees in modern enterprises is often determined by a variety of factors; for example, employees in different departments have different attendance requirements, employees at different levels have different salary plans, and different regions have different holiday regulations, which greatly increases the workload of salary management personnel when calculating salaries. At present, traditional salary data is processed manually. In the face of increasingly complex salary systems and dynamic holiday regulations, the accuracy and efficiency of salary data processing are difficult to be effectively guaranteed. Therefore, how to improve the accuracy and efficiency of salary data processing is a technical problem that needs to be solved urgently.

[0050] In order to solve this problem, various embodiments of the salary data processing method of the present invention are proposed. The salary data processing method provided by the present invention generates the attendance information corresponding to the target employee by presetting the holiday information and matching the holiday information with the employee's attendance date, and then automatically generates the employee's salary information through the salary rules of the target employee, so as to realize the unified processing of the salary information of employees of different departments, different ranks and different holiday regulations, and improve the accuracy and efficiency of salary data processing.

[0051] Reference Figure 1 , Figure 1 It is a schematic diagram of the structure of a salary data processing device involved in an embodiment of the present invention.

[0052] The device may be a user equipment (UE) such as a mobile phone, a smart phone, a laptop, a digital broadcast receiver, a personal digital assistant (PDA), a tablet computer (PAD), a handheld device, a vehicle-mounted device, a wearable device, a computing device or other processing device connected to a wireless modem, a mobile station (MS), etc. The device may be called a user terminal, a portable terminal, a desktop terminal, etc.

[0053] Generally, the device includes: at least one processor 301, a memory 302, and a salary data processing program stored in the memory and executable on the processor, wherein the salary data processing program is configured to implement the steps of the salary data processing method as described above.

[0054] The processor 301 may include one or more processing cores, such as a 4-core processor, an 8-core processor, etc. The processor 301 may be implemented in at least one hardware form of DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). The processor 301 may also include a main processor and a coprocessor. The main processor is a processor for processing data in the awake state, also known as a CPU (Central Processing Unit); the coprocessor is a low-power processor for processing data in the standby state. In some embodiments, the processor 301 may be integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content to be displayed on the display screen. The processor 301 may also include an AI (Artificial Intelligence) processor, which is used to process relevant salary data processing operations, so that the salary data processing model can be trained and learned autonomously to improve efficiency and accuracy.

[0055] The memory 302 may include one or more computer-readable storage media, which may be non-transitory. The memory 302 may also include a high-speed random access memory and a non-volatile memory, such as one or more disk storage devices and flash memory storage devices. In some embodiments, the non-transitory computer-readable storage medium in the memory 302 is used to store at least one instruction, which is used to be executed by the processor 301 to implement the salary data processing method provided in the method embodiment of the present application.

[0056] In some embodiments, the terminal may further optionally include: a communication interface 303 and at least one peripheral device. The processor 301, the memory 302 and the communication interface 303 may be connected via a bus or a signal line. Each peripheral device may be connected to the communication interface 303 via a bus, a signal line or a circuit board. Specifically, the peripheral device includes: at least one of a radio frequency circuit 304, a display screen 305 and a power supply 306.

[0057] The communication interface 303 can be used to connect at least one peripheral device related to I / O (Input / Output) to the processor 301 and the memory 302. The communication interface 303 is used to receive the movement trajectories and other data of multiple mobile terminals uploaded by users through the peripheral device. In some embodiments, the processor 301, the memory 302 and the communication interface 303 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 301, the memory 302 and the communication interface 303 can be implemented on a separate chip or circuit board, which is not limited in this embodiment.

[0058] The radio frequency circuit 304 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The radio frequency circuit 304 communicates with the communication network and other communication devices through electromagnetic signals, so as to obtain the movement trajectory and other data of multiple mobile terminals. The radio frequency circuit 304 converts the electrical signal into an electromagnetic signal for transmission, or converts the received electromagnetic signal into an electrical signal. Optionally, the radio frequency circuit 304 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, and the like. The radio frequency circuit 304 can communicate with other terminals through at least one wireless communication protocol. The wireless communication protocol includes but is not limited to: a metropolitan area network, various generations of mobile communication networks (2G, 3G, 4G and 5G), a wireless local area network and / or a WiFi (Wireless Fidelity) network. In some embodiments, the radio frequency circuit 304 may also include circuits related to NFC (Near Field Communication), which is not limited in this application.

[0059] The display screen 305 is used to display the UI (User Interface). The UI may include graphics, text, icons, videos and any combination thereof. When the display screen 305 is a touch display screen, the display screen 305 also has the ability to collect touch signals on the surface or above the surface of the display screen 305. The touch signal can be input to the processor 301 as a control signal for processing. At this time, the display screen 305 can also be used to provide virtual buttons and / or virtual keyboards, also known as soft buttons and / or soft keyboards. In some embodiments, the display screen 305 can be one, the front panel of the electronic device; in other embodiments, the display screen 305 can be at least two, respectively arranged on different surfaces of the electronic device or in a folding design; in some further embodiments, the display screen 305 can be a flexible display screen, arranged on a curved surface or a folding surface of the electronic device. Even, the display screen 305 can also be set to a non-rectangular irregular shape, that is, a special-shaped screen. The display screen 305 can be made of materials such as LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode, organic light-emitting diode).

[0060] The power supply 306 is used to power various components in the electronic device. The power supply 306 can be an alternating current, a direct current, a disposable battery, or a rechargeable battery. When the power supply 306 includes a rechargeable battery, the rechargeable battery can support wired charging or wireless charging. The rechargeable battery can also be used to support fast charging technology.

[0061] Those skilled in the art will understand that Figure 1 The structure shown in the figure does not constitute a limitation on the salary data processing device, and may include more or less components than shown in the figure, or combine some components, or arrange the components differently.

[0062] The embodiment of the present invention provides a salary data processing method, referring to Figure 2 , Figure 2 Schematic diagram of the flow chart of the first embodiment of the salary data processing method of the present invention.

[0063] In this embodiment, the salary data processing method includes the following steps:

[0064] Step S100, obtaining holiday information and generating a holiday information record table.

[0065] In actual applications, companies often have different holiday regulations in different work areas; for example, in the countries where different branches are located, holidays are set according to national policies; in the provinces where different offices are located, holidays are set according to the holiday policies of local ethnic minorities; and even in different departments, holidays are set according to the requirements of the department's corresponding functions.

[0066] It is easy to understand that in order to solve the problem that different employees may have different holidays due to differences in country, province or department, and thus have a large workload when processing the employee's salary data, before the salary management personnel process the salary data, they need to obtain the holiday information first, and then process the employee's attendance according to the holiday information to obtain accurate employee salary data.

[0067] It should be noted that the holiday information obtained may be holiday information of different countries, holiday information of different provinces or holiday information of different departments, or holiday information corresponding to other factors causing employees to have different holidays. This embodiment does not limit this, and personnel in this field may make specific settings according to actual conditions.

[0068] Specifically, after obtaining the holiday information, according to different holiday regulations, a holiday information record table corresponding to the holiday regulations can be generated. In the holiday information record table, different holiday information of different employees due to factors such as different countries, different provinces or different departments can be recorded. In order to more clearly illustrate the implementation content of this step, the following example illustrates different holiday information of different employees:

[0069] It is learned that the country where Branch A is located is the United States. The holiday regulations of the United States are queried, and the holiday information of Branch A in the United States is imported into the holiday information record table; the holiday information of the United States may include Christmas, Thanksgiving, Veteran's Day, Labor Day, and Independence Day;

[0070] It is learned that the province where Branch B is located is Xinjiang, and the holiday regulations for ethnic minorities in Xinjiang are queried, and the obtained holiday information of Branch B in Xinjiang is imported into the holiday information record table; among them, the holiday information for ethnic minorities in Xinjiang includes Eid al-Fitr and Eid al-Adha, etc.;

[0071] It is learned that the functional requirement of Department C is to work from the 1st to the 15th of each month, and the dates of Department C's non-working days are imported into the holiday information record table as the holiday information of the department.

[0072] It is easy to understand that when faced with different holiday regulations in different countries, provinces, and departments, before processing salary data, it is necessary to obtain the holiday information corresponding to the holiday regulations in advance, and generate holiday information that records different holiday regulations, so that when receiving the salary data processing instruction, the salary data of the target employees can be processed quickly, efficiently, and accurately.

[0073] Step S200, when receiving the salary data processing instruction, extracting the first date information of the vacation information record table and the second date information of the target employee; wherein the target employee is the employee corresponding to the salary data processing instruction.

[0074] In actual application, if a holiday information record sheet is generated, the system can wait for the salary management personnel to input salary data processing instructions. After receiving the salary data processing instructions, the system starts to execute the salary data processing steps for the holiday information record sheet and the target employee.

[0075] Specifically, when a salary data processing instruction is received, the salary data processing instruction is an instruction for the salary management personnel to process the salary data of the target employee. According to the instruction, the first date information of the holiday information record table and the second date information of the target employee can be extracted, and the first date information and the second date information can be used to obtain the attendance information of the target employee.

[0076] It is easy to understand that the first date information is the working day recorded in the holiday information record table, and the second date information is the attendance day of the target employee. By extracting the working day recorded in the holiday information record table and the attendance day of the target employee corresponding to the salary data processing instruction, the attendance information of the target employee under the corresponding holiday rules can be obtained, and then the salary of the target employee can be calculated based on the attendance information. In order to more clearly illustrate the implementation content of this step, the following example is used to extract the first date information of the holiday information record table and the second date information of the target employee:

[0077] When receiving the salary data processing instruction about Employee A, the first date information of the holiday information record sheet of Branch A where Employee A is located is extracted to obtain the expected attendance dates of Employee A (1st to 5th, 8th to 12th, 15th to 18th, 21st to 22nd, 30th to 31st of this month). At the same time, the second date information of Employee A's attendance record sheet is extracted to obtain the actual attendance dates of Employee A (1st to 4th, 9th to 12th, 15th to 18th, 21st to 22nd, 30th to 31st of this month).

[0078] In this embodiment, when a salary data processing instruction is received, the first date information of the ideal leave information record table corresponding to the target employee and the second date information in the attendance information are extracted to obtain the employee's expected attendance date and actual attendance date, and then the corresponding attendance date and actual attendance date are processed to obtain the salary that the employee should receive in the current month.

[0079] It is easy to understand that by parsing the received salary data processing instructions, the salary data processing instructions for the target employees are obtained, and the first date information and the second date information used to calculate the attendance information of the target employees are automatically extracted by using the attendance information of the target employees and the pre-generated holiday information record table corresponding to the target employees. The expected attendance date and the actual attendance date for salary data processing can be dynamically and conveniently extracted without being affected by changes in holiday information and attendance information, thereby improving the processing efficiency and accuracy of salary data processing.

[0080] Step S300: performing date matching on the first date information and the second date information to generate attendance information of the target employee.

[0081] In practical applications, if the first date information (ie, expected attendance date) and the second date information (ie, actual attendance date) of the target employee are obtained, the attendance information of the target employee can be obtained, and the salary data of the target employee can be calculated using the attendance information.

[0082] Specifically, the attendance information can be the ratio of the target employee's expected attendance to his actual attendance; for example, Employee A's expected attendance dates at Branch A are (1st to 5th, 8th to 12th, 15th to 18th, 21st to 22nd, and 30th to 31st of this month), and his actual attendance dates are (1st to 4th, 9th to 12th, 15th to 18th, 21st to 22nd, and 30th to 31st of this month). Employee A's expected attendance is 18 days, and his actual attendance is 16 days. His attendance information (ratio of expected attendance to actual attendance) is 18 / 16. Finally, the attendance information can be used to calculate Employee A's salary data.

[0083] It should be noted that the attendance information may be the ratio of the target employee's required attendance to his actual attendance, or other indicators that can reflect the target employee's attendance. This embodiment does not limit this, and those skilled in the art may make specific settings according to actual conditions.

[0084] Step S400, calling a preset salary grade table, obtaining the salary rules of the target employee, and using the salary rules and the attendance information to generate the salary information of the target employee.

[0085] In actual applications, different employees in an enterprise have different salary rules or salary grades. Therefore, even if different employees have the same corresponding holiday information and attendance information, their final salary data may be different. Therefore, when processing the salary data of the target employees, the salary rules or salary grades of the target employees should also be considered.

[0086] Specifically, after obtaining the attendance information of the target employee, the preset salary grade table is called to obtain the salary rules of the target employee, and then the salary information of the target employee can be generated according to the attendance information of the target employee and the corresponding salary rules. In order to more clearly illustrate the implementation content of this step, the following example is used to illustrate the attendance information of the target employee and the corresponding salary rules:

[0087] The preset salary grade table is called. When it is determined that the salary rule of employee A is a fixed salary, the fixed salary value (e.g., 8000) of the corresponding salary grade of employee A is extracted, and the fixed salary value is processed using employee A's attendance information (e.g., the ratio of required attendance / actual attendance is 15 / 16), thereby obtaining the salary data of employee A. Specifically, the salary data may be the product of the fixed salary value and the attendance information (8000×15 / 16=7500). Similarly, the salary data may also be the fixed salary value minus the specified value (8000-(16-15)200=7600). Personnel in this field may set the specific value according to the situation.

[0088] Call the preset salary grade table. When it is determined that the salary rule of employee B is basic salary + commission, extract the basic salary value of employee A corresponding to the salary grade (for example, 3000), use employee B's attendance information (for example, the ratio of required attendance / actual attendance is 14 / 15) to process the basic salary value, and then obtain the basic salary of employee B's salary data; specifically, the basic salary of the salary data can be the product of the basic salary value and the attendance information (3000×14 / 15=2800). In addition, employee B's commission can be obtained by calling the commission table and directly adding the basic salary and commission. It can also be deducted from the commission for absence according to the company's regulations. People in this field can make specific settings according to the situation.

[0089] In another embodiment, when calculating the target employee's salary information, in addition to considering the target employee's attendance information and salary grade, a salary remaining factor table of the target employee may be generated at the same time as receiving the salary data processing instruction. After obtaining the salary information corresponding to the attendance information and salary grade, the salary remaining factor table is used to process the salary information to obtain the final target employee's salary data. Specifically, the salary remaining factor table may also include: deduction amount, reward amount, allowance or subsidy, etc.

[0090] In this embodiment, by pre-setting holiday information and matching the holiday information with the employee's attendance date, the attendance information corresponding to the target employee is generated, and then the employee's salary information is automatically generated through the target employee's salary rule. This can achieve unified processing of salary information for employees in different departments, different ranks, and different holiday regulations, thereby improving the accuracy and efficiency of salary data processing.

[0091] For easier understanding, see Figure 3 , Figure 3 FIG. 1 is a flow chart of a second embodiment of the salary data processing method of the present invention. Figure 2 The first embodiment of the salary data processing method shown in the figure, this embodiment proposes a second embodiment of the salary data processing method, which is specifically as follows:

[0092] In this embodiment, the holiday information includes statutory holidays and / or special holidays. Based on this, the step of obtaining the holiday information specifically includes:

[0093] Step S101, receiving a statutory holiday table imported by a user, and extracting dates corresponding to statutory holidays in the statutory holiday table.

[0094] Specifically, in this embodiment, the holiday information obtained can be a statutory holiday table imported by the user. The salary management personnel can obtain the target employee's current holiday information table by querying the holiday regulations of the target employee's country, province, and department, and then extract the holiday information in the holiday information table to obtain the attendance information for the subsequent salary data processing steps.

[0095] Step S102, receiving special holiday information input by the user, and extracting the date corresponding to the special holiday in the special holiday information.

[0096] Specifically, in this embodiment, the holiday information obtained can be special holiday information input by the user. People skilled in the art can know that in the actual operation process, enterprises will arrange corresponding holidays due to special circumstances, such as the postponement of working days due to the epidemic, and the adjustment of holidays due to power rationing policies. Therefore, in view of the above-mentioned characteristic situations, before sending the salary data processing instruction, the salary management personnel need to input the holiday information of special circumstances into the system, and then extract the special holiday information from the special holiday information to obtain the attendance information of the subsequent salary data processing steps.

[0097] In some embodiments, after the holiday information is acquired, a holiday information record table is generated according to the holiday information.

[0098] Specifically, in this embodiment, after obtaining the holiday information, a calendar table can be generated first, and then the holiday days in the calendar table can be marked using the holiday information. For example, after obtaining the dates corresponding to statutory holidays and special holidays, the corresponding dates in the calendar table are marked, and the marking is used to quickly obtain the attendance days and holiday days in the calendar table when processing the holiday information record table.

[0099] For easier understanding, see Figure 4 , Figure 4 FIG. 1 is a flow chart of the third embodiment of the salary data processing method of the present invention. Figure 3 The second embodiment of the salary data processing method shown in the figure, this embodiment proposes a third embodiment of the salary data processing method, which is as follows:

[0100] In this embodiment, the salary data processing instruction includes a target employee, based on which, the step of extracting the first date information of the vacation information record table and the second date information of the target employee specifically includes:

[0101] Step S201, traverse the holiday information record table, extract the dates without marks, to generate first date information.

[0102] Specifically, after generating a holiday information record sheet, in order to obtain the target employee's attendance date, the holiday information record sheet can be used to remove the holiday days corresponding to the marks in the holiday information record sheet, retain the unmarked dates, and finally, use the date information corresponding to the retained dates as the first date information.

[0103] Step S202: import the attendance sheet of the target employee, extract the date with attendance record, and generate second date information.

[0104] Specifically, after generating the holiday information record table, in order to obtain the actual attendance date of the target employee, the target employee's attendance sheet can be imported, the dates without attendance records in the attendance sheet can be removed, and the dates with attendance records can be retained. Finally, the date information corresponding to the retained dates can be used as the second date information.

[0105] It is easy to understand that the first date information is the working day recorded in the holiday information record table, and the second date information is the attendance day of the target employee. By extracting the working day recorded in the holiday information record table and the attendance day of the target employee corresponding to the salary data processing instruction, the attendance information of the target employee under the corresponding holiday rules can be obtained, and then the salary of the target employee can be calculated based on the attendance information.

[0106] In another embodiment, the salary data processing instruction includes a target employee and a target period, based on which, the step of extracting the first date information of the vacation information record table and the second date information of the target employee specifically includes:

[0107] Step S211, traverse the holiday information record table, extract the dates without marks in the target period, to generate first date information.

[0108] Specifically, in some cases, it is necessary to obtain salary data in different time periods in the holiday information record table. Therefore, after generating the holiday information record table, in order to obtain the attendance date of the target employee in the target time period, the holiday days with corresponding marks in the target time period of the holiday information record table can be removed by facilitating the holiday information record table, and the dates without marks are retained. Finally, the date information corresponding to the retained dates is used as the first date information.

[0109] Step S212, importing the attendance sheet of the target employee, extracting the date with attendance record in the target period, to generate second date information.

[0110] Specifically, in some cases, it is necessary to obtain salary data in different time periods in the vacation information record table. Therefore, after generating the vacation information record table, in order to obtain the actual attendance date of the target employee in the target time period, the attendance sheet of the target employee can be imported, and the dates without attendance records in the attendance sheet in the target time period can be removed, and the dates with attendance records can be retained. Finally, the date information corresponding to the retained dates is used as the second date information.

[0111] It is easy to understand that the first date information is the working day recorded in the target period in the holiday information record table, and the second date information is the attendance day of the target employee in the target period. By extracting the working day recorded in the target period in the holiday information record table and the attendance day of the target employee in the target period corresponding to the salary data processing instruction, the attendance information of the target employee in the target period under the corresponding holiday rule can be obtained, and then the salary of the target employee in the target period can be calculated based on the attendance information.

[0112] In this embodiment, by receiving a salary data processing instruction including a target employee and a target time period, and then extracting the attendance information of the target employee in the target time period, the salary of the target employee in a flexible and dynamic time period is calculated based on the attendance information, thereby improving the efficiency and flexibility of salary data processing.

[0113] For easier understanding, see Figure 5 , Figure 5 FIG. 4 is a flow chart of the fourth embodiment of the salary data processing method of the present invention. Figure 4The third embodiment of the salary data processing method shown in the figure, this embodiment proposes a fourth embodiment of the salary data processing method, which is specifically as follows:

[0114] In this embodiment, the attendance information includes working days and overtime days. Based on this, the first date information is matched with the second date information to generate the attendance information of the target employee, which specifically includes:

[0115] Based on the first date information, the dates in the second date information that are the same as the first date information are marked as working days, and the dates in the second date information that are different from the first date information are marked as overtime days.

[0116] In actual applications, usually, the duration corresponding to the first date information of the holiday information record table will be greater than or equal to the second date information of the target employee, and the target employee's attendance will be greater than or equal to the actual attendance. However, in order to meet the needs of production and work, companies usually arrange overtime on non-working days, and employees will also receive compensation for the corresponding overtime days. Therefore, when processing the salary data of the target employee, it is also necessary to consider that the second date information may include working days and overtime days, which will affect the processing of salary data.

[0117] Specifically, after obtaining the first date information, the dates in the second date information that are the same as the first date information are marked as working days, and the dates in the second date information that are different from the first date information are marked as overtime days. Then, the basic salary is obtained by calculating the employee's attendance information on working days, and the employee's overtime pay is calculated by overtime days, so as to finally obtain accurate salary data.

[0118] In this embodiment, the steps of calling a preset salary grade table, obtaining the salary rules of the target employee, and using the salary rules and the attendance information to generate the salary information of the target employee specifically include:

[0119] Step S401, calling a preset salary grade table to obtain the salary rules of the target employee; wherein the salary rules include working day salary rules and / or overtime day salary rules.

[0120] Step S402: using the working day salary rule and / or the overtime day salary rule, respectively calculate the salary of the target employee on working days and the salary on overtime days to obtain the salary information of the target employee.

[0121] Specifically, after knowing the working days and overtime days in the second date information of the target employee, the salary rules of the target employee can be obtained by calling the preset salary grade table, and then the salary of the target employee on working days and on overtime days can be uniformly calculated according to the working day salary rules and overtime day salary rules corresponding to the salary rules, so as to finally obtain the salary information of the target employee.

[0122] In this embodiment, a method for calculating the working day salary and overtime day salary of a target employee is provided in which attendance information includes working days and overtime days. The date corresponding to the working day for calculating the working day salary and the date corresponding to the overtime day for calculating the overtime day salary are obtained by matching the first date information and the second date information. By matching the first date information and the second date information, high efficiency and high accuracy of salary data processing can be achieved. At the same time, overtime salary of employees can be calculated, thereby improving the flexibility of salary data processing.

[0123] Reference Figure 6 , Figure 6 It is a structural block diagram of the first embodiment of the salary data processing device of the present invention.

[0124] like Figure 6 As shown, the salary data processing device proposed in the embodiment of the present invention includes:

[0125] The acquisition module 10 is used to acquire holiday information and generate a holiday information record table;

[0126] The extraction module 20 is used to extract the first date information of the holiday information record table and the second date information of the target employee when receiving the salary data processing instruction; wherein the target employee is the employee corresponding to the salary data processing instruction;

[0127] A matching module 30, configured to perform date matching on the first date information and the second date information to generate attendance information of the target employee;

[0128] The generating module 40 is used to call a preset salary grade table, obtain the salary rule of the target employee, and generate the salary information of the target employee by using the salary rule and the attendance information.

[0129] As an embodiment, the holiday information includes statutory holidays and / or special holidays; the acquisition module 10 is also used to receive a statutory holiday table imported by a user, and extract the dates corresponding to the statutory holidays in the statutory holiday table; and / or receive special holiday information input by a user, and extract the dates corresponding to the special holidays in the special holiday information.

[0130] As an implementation manner, the acquisition module 10 is further used to generate a calendar table using the holiday information, and mark the holiday days in the calendar table to obtain a holiday information record table.

[0131] As an implementation mode, the salary data processing instruction includes a target employee; the extraction module 20 is further used to traverse the holiday information record table, extract the dates without marks to generate the first date information; import the attendance sheet of the target employee, extract the dates with attendance records to generate the second date information.

[0132] As an implementation mode, the salary data processing instruction also includes a target period; the extraction module 20 is further used to traverse the holiday information record table, extract the dates without marks in the target period, to generate the first date information; import the attendance sheet of the target employee, extract the dates with attendance records in the target period, to generate the second date information.

[0133] As an implementation mode, the attendance information includes working days and overtime days; the matching module 30 is also used to mark the dates in the second date information that are the same as the first date information as working days, and mark the dates in the second date information that are different from the first date information as overtime days based on the first date information.

[0134] As an implementation mode, the generation module 40 is also used to call a preset salary grade table to obtain the salary rules of the target employee; wherein the salary rules include working day salary rules and / or overtime day salary rules; using the working day salary rules and / or the overtime day salary rules, the salary of the target employee on working days and the salary on overtime days are calculated respectively to obtain the salary information of the target employee.

[0135] In this embodiment, by pre-setting holiday information and matching the holiday information with the employee's attendance date, the attendance information corresponding to the target employee is generated, and then the employee's salary information is automatically generated through the target employee's salary rule. This can achieve unified processing of salary information for employees in different departments, different ranks, and different holiday regulations, thereby improving the accuracy and efficiency of salary data processing.

[0136] Other embodiments or specific implementations of the salary data processing device of the present invention can refer to the above-mentioned method embodiments, which will not be described in detail here.

[0137] In addition, an embodiment of the present invention further proposes a storage medium, on which a salary data processing program is stored, and when the salary data processing program is executed by a processor, the steps of the salary data processing method described above are implemented. Therefore, it will not be repeated here. In addition, the description of the beneficial effects of adopting the same method will not be repeated. For technical details not disclosed in the computer-readable storage medium embodiment involved in the present application, please refer to the description of the method embodiment of the present application. As an example, the program instructions can be deployed to be executed on one computing device, or on multiple computing devices located at one location, or on multiple computing devices distributed at multiple locations and interconnected by a communication network.

[0138] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program, and the above-mentioned program can be stored in a computer-readable storage medium, and when the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, the above-mentioned storage medium can be a disk, an optical disk, a read-only memory (ROM) or a random access memory (RAM), etc.

[0139] It should also be noted that the device embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. In addition, in the accompanying drawings of the device embodiments provided by the present invention, the connection relationship between the modules indicates that there is a communication connection between them, which may be specifically implemented as one or more communication buses or signal lines. A person of ordinary skill in the art may understand and implement it without creative work.

[0140] Through the description of the above implementation mode, the technicians in the relevant field can clearly understand that the present invention can be implemented by means of software plus necessary general hardware, and of course, it can also be implemented by special hardware including special integrated circuits, special CPUs, special memories, special components, etc. In general, all functions completed by computer programs can be easily implemented by corresponding hardware, and the specific hardware structure used to implement the same function can also be various, such as analog circuits, digital circuits or special circuits. However, for the present invention, software program implementation is a better implementation mode in more cases. Based on such an understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product is stored in a readable storage medium, such as a computer floppy disk, a U disk, a mobile hard disk, a read-only memory (ROM, Read-Only Memory), a random access memory (RAM, Random Access Memory), a disk or an optical disk, etc., including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment of the present invention.

Claims

1. A method for processing salary data, It is characterized in that The method comprises the following steps: Get holiday information and generate a holiday information record table; Upon receiving the salary data processing instruction, extracting the first date information of the holiday information record table and the second date information of the target employee; wherein the target employee is the employee corresponding to the salary data processing instruction; Performing date matching on the first date information and the second date information to generate attendance information of the target employee; Calling a preset salary grade table to obtain the salary rules of the target employee, and using the salary rules and the attendance information to generate the salary information of the target employee; The holiday information includes statutory holidays and / or special holidays; the step of obtaining the holiday information specifically includes: Receiving a statutory holiday table imported by a user, and extracting dates corresponding to statutory holidays in the statutory holiday table; and / or Receiving special holiday information input by a user, and extracting a date corresponding to the special holiday in the special holiday information; The step of generating a holiday information record table specifically includes: Using the holiday information, a calendar is generated, and the holiday days in the calendar are marked to obtain a holiday information record table; The salary data processing instruction includes a target employee; the step of extracting the first date information of the holiday information record table and the second date information of the target employee specifically includes: Traversing the holiday information record table, extracting dates without marks to generate first date information; Importing the attendance sheet of the target employee, extracting the date with attendance record to generate second date information; The salary data processing instruction also includes a target period; the step of extracting the first date information of the holiday information record table and the second date information of the target employee specifically includes: Traversing the holiday information record table, extracting the dates without marks in the target period to generate first date information; The attendance sheet of the target employee is imported, and the date with attendance record in the target time period is extracted to generate second date information.

2. The salary data processing method according to claim 1, It is characterized in that The attendance information includes working days and overtime days; the step of matching the first date information with the second date information to generate the attendance information of the target employee specifically includes: Based on the first date information, the dates in the second date information that are the same as the first date information are marked as working days, and the dates in the second date information that are different from the first date information are marked as overtime days.

3. The salary data processing method according to claim 2, It is characterized in that The step of calling a preset salary grade table, obtaining the salary rules of the target employee, and using the salary rules and the attendance information to generate the salary information of the target employee specifically includes: Calling a preset salary grade table to obtain the salary rules of the target employee; wherein the salary rules include working day salary rules and / or overtime day salary rules; The working day salary rule and / or the overtime day salary rule are used to calculate the salary of the target employee on working days and the salary on overtime days, respectively, so as to obtain the salary information of the target employee.

4. A salary data processing device, It is characterized in that The steps for implementing the salary data processing method according to any one of claims 1 to 3, the salary data processing device comprises: The acquisition module is used to obtain holiday information and generate a holiday information record table; An extraction module, configured to extract the first date information of the holiday information record table and the second date information of the target employee upon receiving the salary data processing instruction; wherein the target employee is the employee corresponding to the salary data processing instruction; A matching module, used for performing date matching between the first date information and the second date information to generate attendance information of the target employee; The generation module is used to call a preset salary grade table, obtain the salary rules of the target employee, and generate the salary information of the target employee by using the salary rules and the attendance information.

5. A salary data processing device, It is characterized in that The salary data processing device comprises: a memory, a processor and a salary data processing program stored in the memory and executable on the processor. When the salary data processing program is executed by the processor, the steps of the salary data processing method according to any one of claims 1 to 3 are implemented.

6. A storage medium, It is characterized in that The storage medium stores a salary data processing program, and when the salary data processing program is executed by the processor, the steps of the salary data processing method according to any one of claims 1 to 3 are implemented.