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.

How to build a MES?

If you or your company want to build  a MES (Manufacturing Execution System), it's a big job can't do it by your self. And you may co-work with vendors and consultants to do it. The customize fee is charge by working hours. If you have a sample concept for MES, and you will less working time for these common sense discussions.

I had have build 3 MES for 3 companies, but all of them are LED industrial, and very different manage way their are.

What is MES?
A manufacturing execution system (MES) is a control system for managing and monitoring work-in-process on a factory floor. An MES keeps track of all manufacturing information in real time, receiving up-to-the-minute data from robots, machine monitors and employees. Although manufacturing execution systems used to operate as self-contained systems, they are increasingly being integrated with enterprise resource planning (ERP) software suites. The goal of a manufacturing execution system is to improve productivity and reduce cycle-time, the total time to produce an order. By integrating an MES with ERP software, factory managers can be proactive about ensuring the delivery of quality products in a timely, cost-effective manner.

The MES must cost effectively meet the business criteria.
1.improve manufacturing processes and  quality.
2.Reduce IT involving and low build and maintenance cost.
3. Easy support the production line future growth or development.
4.   Integrate with other critical systems in company, ex. ERP.
5.Readily and rapidly adapt FAB un-schedule change in production cycle in business.

How to get the manufacturing indices raw data?

One  of my friend told me, we don't have MES (manufacturing Execution System) in our company. How can I get that data?

有人跟我反映,我們公司沒有MES (製造執行系統),我要如何取得這些資料?

It's a big question, I have experience in 3 types of company, maybe I can shear some experience with you.

這是一個大問題,我曾經在三種不同狀況的公司待過,也許可以提供一些建議給你.

1. MES is setup, and implement very well. We have a CIM guy or a team for MES maintenance and development. If you need the raw data, you just ask the CIM guy, provide you a read only's Data Base account, and you can access the database by SQL language though Excel, Visual Basic,Access or other  program languages to develop your reports.

Access MES Database is a very serious thing, it may impact MES performance is your SQL is not good enough, CIM will provide you a DATA Mart's account, it's duplicate from MES database.
We will discuss SQL and  Excel VBA later. If you have such environment, it's very convenient for you develop these management report. All you need to do is ask.