How to build HRMS (Human Resource Management System) in MFG.

HRMS in MFG is a key management system for certify and DL personal data keep purpose.  I know HR should keep those data for all staffs data in company. But in MFG our production line are running 24 hours per day, 7 days per week, we can't waiting the DL data until HR provide it. Especially in emergence cases, such as DL no show when he/she is on duty, or he/her have some emergency cases in line. We need to reach their emergency contacts A.S.A.P. And certify data are not keep in HR's training data base normally, if your company are, your HR is a good support for you.

I created this HRMS is for our annual plan to encourage DL to become multi-function TE. We need a efficiency way to maintain those data replace EXCEL file. I try to use ACCESS database and VB.net to create a simple but useful system  for our TPS compute the multi-function DL score.

The basic function as picture shows.

It use Chinese as items title, 1st parts are DL personal data define and data maintain. Working area define, Section define, DL personal data maintain, education degree query, personal information  maintain etc. This part are the main function for DL's shift, section, personal data maintain functions.

1st part is about personal information maintain functions. include define working area, shift, sections and vacation type. And personal information and work related information a all maintain in this part.

2nd prat is about system account setup, I line to company windows account database, to retrieve all the windows account in company, and define who have the authority to create, modify, delete the HRMS's data. 

3rd part are about certify function, include define certify items, define which equipment are belong to this certify item and setup MES track in/out functions. Enroll certify record in the system or delete the keyin error's record in system. And you can do a simple query from here.

4nd part are all about report, include the average certify items in each shift, 4-2 shift name list query, seniority query, certify item query, new add record query and historical certify records query.

I will detail introduce these functions in the following articles.