How to tack employees employee levels and jobs

DocD

New member
Local time
Today, 01:22
Joined
Jan 28, 2002
Messages
6
I want to be able to track employees and the jobs that they do at different levels in their career.

A job can be carried out by an employee at level1. That same job type can be carried out by the employee when they reach level2. How can I set this up.

I have

tblJobs
JobID (autonum, primary key)
JobTypeID (number, child key)
EmployeeID (number, child key)
Date (date)
JobNotes (memo)

When I create the queries/reports I want to list all the Jobs carried out by the employee for a set time, but want to also break it down by their level. They can only be at one level at any one time, and usually progress up the level ladder with time.

EG
Jan 1990 – Jan 2000
Employee John Smith
Job Type A
Level 1 = 100
Level 2 = 200
TOTAL = 300

If more than one employee worked on a Job, I would need to break it out into a junction table for the many-to-many relationship (a Job can contain many employees and an employee can be involved in many Jobs). How would I incorporate their level into this structure too?

Thanks.
 
Maybe what you need is 3 tables:

Employee Table (containing Employee Data)
EmpJob_Xref (Contains links between Job and Employee)
Job Table (Contains Job information)

This would assum Job information is static for a job.
This would allow you to define the job/s only once, and tie as many as you want to an employee and not have to create the job data over and over. The EmpJob_Xref could contain date information, and any other information that pertains to the link only.

Just a thought.
 
Each "Job" is unique, but is of a specific JobType.

I have a table tracking jobs by employee (tblJobs) and I can add info about the job in there, but it's the level that the employee is at when they do that job I want to track. I don't want to have to enter the employee's level each time I enter job info. There must be a more elegant solution.

I can then print out a rpt of the employee's record showing there levels and the dates they were at those levels.
 
Create a table that holds the employeeID, the level and the date that level became effective.

Then you can run a query that pulls in the date they entered the job and finds the date from the level that comes before the job date, and so find out the level at that time.
 

Users who are viewing this thread

Back
Top Bottom