REQ: Salary Database

[Neville310]

Please let me know if anybody has seen a salary history database. The database would track job descriptions and various salaries for positions. Each job description should include multiple rates ranging from low to high quotes. It would classify jobs in several ways like union, non-union, flat, daily, hourly, etc. It should calculate various salaries based on hourly, daily, or flat rate in conjunction with the number of hours worked. In addition, a salary calculator would help as well. Reports should display all high rates for a department or all rates for a job description.

My initial thoughts revolve around two tables; one table represents the job description; and the second table presents these rates. I just need a start point for ideas. Screenshots or a working model would be ideal. This database is not a human resources solution. It serves to track rates across similar positions when the titles have small deviations. It has more in common with a project management solution.

Edited September 23, 2005 by Guest