×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Keeping Line Manager information up to date

Keeping Line Manager information up to date

Keeping Line Manager information up to date

(OP)
I look after a database for my HR department.  One of the most difficult areas we have to keep up to date is the Line Manager - "Direct Report" relationship.  
As is (I believe) fairly standard, each employee has on their Jobs table (one to many with main table) a field for recording who their line manager is.
But what happens is if a line manager leaves, that leaves a number of 'orphaned' direct reports, who might not get a replacement for a week to several months.
Help, any suggestions on the problem, or alternative ways of looking at it would be really useful

RE: Keeping Line Manager information up to date

Instead of organizing by person/employee, perhaps the "report to" should go by position/title, i.e. like an org chart. A little more complicated and a lot more flexible.

EmployeeTable
EmployeeID
FirstName
LastName
etc.

PositionTable
PositionID
PositionTitle (or this may belong in the table below)
PositionReportsTo (foreign key to PositionID, self join)
etc.

EmployeePositionTable
EmployeePositionID (unique identifier)
EmployeeID (foreign key to EmployeeTable)
PositionID (foreign key to PositionTable)
StartDate
EndDate
Salary
etc.








-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close