Human Resource database template

[Guest]

We have a need for building a system where we can get an overview over the
competence in the organisation. The individual competence structure is
department specific. I.e. if you belong to department XX, then the competence
structure should be specific for that particular department. In this database
we also need to have the standard basic employee information.

(I have not yet found a database template, but have been thinking that in
principle this is like an order log. Each order has a "heading" with its
basic information, but also contains order-line information)

Anybody that could help me?

Best regards
Halfdan

 

[Guest]

We have a need for building a system where we can get an overview over the

competence in the organisation. The individual competence structure is
department specific. I.e. if you belong to department XX, then the competence
structure should be specific for that particular department. In this database
we also need to have the standard basic employee information.

You have employees:

tbl_Employees
EmployeeID
EmployeeInfo

You have departments:

tbl_Departments
DepartmentID
DepartmentInfo

There are competencies which you wish to track:

tbl_Competencies
CompetencyID
CompetencyInfo

There are some competencies which are important to a department, or to
several departments. Being able to spell is something that could help in a
lot of situations.

tbl_DepartmentCompetencies
DepartmentCompetencyID
DepartmentID
CompetencyID
DepartmentCompetencyInfo

There are the competencies which various employees have. Don't just find
out which competencies they have which apply to their department. Being able
to speak French may be something that has nothing to do with your department,
but could be helpful to the company.

tbl_EmployeeCompetencies
EmployeeCompetencyID
EmployeeID
CompetencyID
EmployeeCompetencyInfo

 

[Guest]

Thansk mnature, this is very helpful. Do you happen to know anybody that
already have done the work. I'm not very experienced in access
(understatement of the year..), but can clearly see the benefits of using
db'es.

Halfdan

 

[Guest]

I don't see any templates on the Microsoft site that would fit your
parameters very well. That is the reason people will pay someone to design a
database, because so many of the needs for one are quite unique. Nobody in
your company has an Access competence? This could be a good opportunity for
inter-departmental cooperation, and perhaps give someone who knows a little
about Access a chance to learn more. This forum can be very helpful for
beginners.

 

[Guest]

We don't have any DB knowledge at all. We have previously used various excel
sheets, but this is not an acceptable solution. The company has grown 500%
since 2001, and the requirements to manage intellectual capital increased. We
plan to implement a new ERP system in one year, but the HR module probably
early 2008. We need a quick temporary fix! The organisation is fully
streched, so buying the services may well be our only realistic option.

 

[Guest]

You could try doing a search for human resources software. I found quite a
few on google (two are listed below, just because they were on the top of the
list). If you are growing rapidly, then you will want to go with software
that has some built-in security (have to protect that sensitive information),
with a number of features that you may want to implement in the future.

This has a demo available:

http://www.ascentis.com/products/hroffice.asp

This one actually tells you up-front how much it costs:

http://www.auxillium.com/Pricing.htm

 

[Guest]

Thanks a lot, mnature. Very helpful indeed!

Best regards, Halfdan

 

[Guest]

Hafdan,

I'm in the same boat looking for a FREE download for access to track HR
data. Did you ever find anything free?

Thanks,
michele