Attendant tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am designing a database to track employee attendant daily so I can pull up
report filtered by date range to show my weekly manpower shortage and by
employee name so report shows their attendant status.

All employees are permanently assigned to a machine or location (if not
machine) and running on 3 shifts. Sometimes when people are on vacation we
find other workers from another location to fill that avoid daily.

What is the best way to design such as tables and relationship for this type
of database? Thank you.
 
I would certainly try to understand normalization principles first. I don't
think you want to assume that all work is scheduled based entirely on
existing shifts. You might be better off assuming that
- there is no such thing as a "permanent assignment"
- shifts may change
- machines and locations will change
I can see tables:
tblEmployees
tblShifts (for default start and end times)
tblPositions (could be a machine or location)
tblWorkSchedule (what person is filling what position at what period of time)

You might also have a default work schedule template the describes typical
staffing levels in various positions. This might be based on weekday or
weekend or whatever.
 
TblEmployee
EmployeeID
FirstName
LastName
EmployeeBasedAt (Home Office, Another Location)
<<Other employee data needed in database>>

TblLocation
LocationID
LocationName
<<Location address fields>>
LocationDescription

TblEmployeeAssignment
EmployeeAssignmentID
EmployeeID
LocationID

TblDailyAttendant
DailyAttendantID
EmployeeAssignmentID
DailyAttendantDate
DailyAttendantShift (1,2 or 3)
EmployeeWasThere (Yes/No)

If you have further questions, you can post back again to the news group or
if you need to get this database done quickly, I can help you for a very
reasonable fee.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Grow up steve, you know these newsgroups are for FREE peer to peer support.

John... Visio MVP
 
Steve said:
TblEmployee
EmployeeID
FirstName
LastName
EmployeeBasedAt (Home Office, Another Location)
<<Other employee data needed in database>>

TblLocation
LocationID
LocationName
<<Location address fields>>
LocationDescription

TblEmployeeAssignment
EmployeeAssignmentID
EmployeeID
LocationID

TblDailyAttendant
DailyAttendantID
EmployeeAssignmentID
DailyAttendantDate
DailyAttendantShift (1,2 or 3)
EmployeeWasThere (Yes/No)

If you have further questions, you can post back again to the news group or
if you need to get this database done quickly, I can help you for a very
reasonable fee.

PC Datasheet
Click to expand...

--
Hi Steve !
Did you get lots of new customers from the groups lately ??

http://home.tiscali.nl/arracom/whoissteve.html (Earthlink kicked you out ?? ==> updated 'abuse-reporting')
Until now 3700+ pageloads, 2375+ first-time visitors (these figures are *real* and rapidly increasing)

To all:
Anyone wants to help us getting rid of Steve ??
(e-mail address removed) (appropriate action will follow when there are enough complaints)

Arno R
 
Back
Top