Salary History Database -
09-27-2005
, 10:52 PM
Please let me know if anybody has seen a salary history database for
download. 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. This salary calculator
would help. 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 starting point for ideas. Screenshots or a working model would
be ideal. This database is not a human resource 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.
It's a simple database, yet I could use suggestions on categorizing
the data. |