Solution to the problem of PB dynamic wage project

Source: Internet
Author: User

When I was working on the Personnel Management software, I found out that the issue of payroll in payroll management was often changed, and that the calculation relationship between salary items was constantly changing, which caused a lot of trouble for actual programming. In fact, there are many similar situations in the actual work to be resolved, I hope to provide you with a number of ideas for reference.

My resolution is presented below.

The first step is to create a payroll Tbl_gztz that records the monthly payroll of employees, including the payment of wages. So this table field should be as much as possible, you can put more than 50.

Table structure is as follows: Tbl_gztz

Data column Name Data column type Data column meaning
Zgbh VARCHAR2 (10) Employee number
Mc VARCHAR2 (10) Employee Name
Yf VARCHAR2 (6) Payroll Month
Gz1 Number (12,2) (meaning see table below in the project table)
Gz2 Number (12,2) (meaning see table below in the project table)
Gz3 Number (12,2) (meaning see table below in the project table)
Gz4 Number (12,2) (meaning see table below in the project table)
Gz5 Number (12,2) (meaning see table below in the project table)

The second step is to create a payroll project Registration Form TBL_GZXMDY, which is used to record all the payroll items and the calculated relationships between projects in the actual work of payroll management. The computational relationship can be a simple arithmetic, or it can contain functions (limited to PB content functions).

The table structure is as follows:

Data column Name Data column type Data column meaning
Xm VARCHAR2 (10) Salary Item Name
Xmmc VARCHAR2 (20) The meaning of the salary item
Jsgs VARCHAR2 (40) The corresponding computational relationship
Flag VARCHAR2 (1) Whether the key is enabled (1 is enabled, 0 is inactive)

The Payroll project takes the field out of the payroll form TBL_GZTZ, which is easy to get out in Oracle (or other data), and then inserts the fetched field into the Payroll Project Definition Table Tbl_gzxmdy and defines its meaning for each item, which will not be displayed.

For the convenience of explanation, the examples are more clear. The SQL statement to remove the Release project field is as follows:

Select Cname from Col Where tname = ' Tbl_gztz ' and coltype = ' NUMERIC ' ORDER by Colno;

Payroll Project Data Maintenance Examples show:

Xm Xmmc Jsgs
Gz1 Skill pay
Gz2 Floating wages
Gz3 Insurance Wages
Gz4 Wages to be issued GZ1 + Gz2
Gz5 Rent
Gz6 Real wages Gz4-gz5

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.