Here is what an employer database could track,
Usually Checks are issued in a warrant, and all the line items are actually
tracked in a detailed table by Warrant ID, and Employee ID,
The actual checks are run as a report that selects all the fields needed to
print on the check.
All do evolve around the key fields, Employee ID, Deduction ID, Warrant ID
(which has ties to the date) and the detailed items.
The check run programs usually run a query that creates a temp table with
the YTD information in it.
Do deductions are actually one table, with several deduction types based on
your schedule.
Union Dues, insurance, ect.
Hope this helps guide you a little.
The
-----Original Message-----
From: David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 8:40 PM
To: [EMAIL PROTECTED]
Subject: Paycheck database Design
I want to log my paychecks in my own database for my own personal use. I
am in the design phase: Do I need a table for year to date since this
can be calculated automatically? I don't want to have to enter a lot of
information when entering the data for each pay period. How many tables
are normally used for something like this? Here is what I have so far
Table 1: Rarely changes
Company:
Address:
Phone:
Employee ID:
Table 2:
Pay Period: Some sort of formula and auto-populate bi-weekly
Rate: rarely change maybe should move up
Hours Default to value
Earnings Rate * Hours worked =Earnings so dont need to store:
Taxes: (should I make another table here)
Federal: //will have to update bi-weekly
FED 2: //will have to update bi-weekly
FED 3: //will have to update bi-weekly
State: //will have to update bi-weekly
City: $2.00 every month
Deductions:
medicalbeforetaxes //will have to update bi-weekly
dentalbeforetaxes //will have to update bi-weekly
visionbeforetaxes //will have to update bi-weekly
401kbeforetaxes //will have to update bi-weekly
Hours worked:
Sick: //will have to update bi-weekly
Vacation:
Holiday
Other:
Can be calculated automagically(no need for table)
YTD
Net
Gross
Total Taxes
Total Deductions
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
