C
CEV
Hi, I am attempting to create a turnover databse for our organization. The
main things they want to see info on is the "Postition Number". Like how
many times that position has turned over in a period of time, and details
about the position such as FT or PT and the hours related to that position
(we have hours that vary around the clock). They would also like details
about the employees that have been in that position; like there age, if they
are a college student, there wage, what training they have completed, and so
on. We are a non-profit organization that provides services to people with
disabilities.
These are the tables I have come up with so far:
POSITIONS - Fields:
Position Number - *Primary Key &
Relationship Field
Department
Title
FT or PT
Position Hours - 40hrs, 20hrs, etc.
Scheduled Hours - 8am-3pm, 9am-5pm, etc.
Active or Inactive
Open or Filled
Benefits
Notes
EMPLOYEES - Fields:
Name
Employee Number - *Primary Key
Position Number - Relationship Field
Date of Hire
Date Left
DOB
Gender
Student or Non-Student
Training Completed
Wage
Please let me know if I am on the right track. Each "Position Number" can
have multiple entries as we want to keep a record of employees that have
been in that position.
Thank You,
CEV
main things they want to see info on is the "Postition Number". Like how
many times that position has turned over in a period of time, and details
about the position such as FT or PT and the hours related to that position
(we have hours that vary around the clock). They would also like details
about the employees that have been in that position; like there age, if they
are a college student, there wage, what training they have completed, and so
on. We are a non-profit organization that provides services to people with
disabilities.
These are the tables I have come up with so far:
POSITIONS - Fields:
Position Number - *Primary Key &
Relationship Field
Department
Title
FT or PT
Position Hours - 40hrs, 20hrs, etc.
Scheduled Hours - 8am-3pm, 9am-5pm, etc.
Active or Inactive
Open or Filled
Benefits
Notes
EMPLOYEES - Fields:
Name
Employee Number - *Primary Key
Position Number - Relationship Field
Date of Hire
Date Left
DOB
Gender
Student or Non-Student
Training Completed
Wage
Please let me know if I am on the right track. Each "Position Number" can
have multiple entries as we want to keep a record of employees that have
been in that position.
Thank You,
CEV