I’m just wondering if anyone has any good ideas on how to resolve this issue?
We have a Time and Attendance System which produces a clock card with a barcode printed on it for scanning purposes e.g their clock machines. It uses information from their program which is stored in a SQL database for that given employee.
Unfortunately, we are moving away from their SFDC system and moving to MES but it will require the EmployeeID. We’re hoping to use the barcodes on the cards but from the example data below… It won’t work.
EmployeeID
Barcode Scan
93AG
E097647
46JL
E021552
I need to some how map the E097647 to 93AG while they’re logging into MES
Sorry - when you said “moving away from” I took that as completely converting to MES.
I agree with the other suggestions for fixing this on the Epicor side, but I’ll ask - Can you alter the Time and Attendance system that prints the card to store and use the Epicor Employee ID for the barcode?
I wanted to chime in, changing the EmployeeID to match the badge barcode isnt a good solution because the badge can change/replaced. I’m assuming thats why the Barcode Scan is such random numbers.
If I’m wrong about that, than ignore what I said above. (In another system, I put the barcode # as an alias so the DB recognizes both the Employee ID and barcode, built into the system) Whenever the badge changes, I just update the badge into that database.
For Epicor, like others mentioned, have a custom function built to use your badge.
We have a 4 digit Employee ID. For reasons, we have a customization built by a consultant that cross references a fingerprint scan, associates it with a specific EmployeeID in Employee_UD and uses that EmployeeID. I dont know everything involved to get that working. But replace Fingerprint Scan with your Badge info and same premise, probably even easier.
@aarong We had a hybrid system and then moved to MES only, but still use their time and attendance to export to our payroll vendor. Initially we ignored the clock in/out functions from MES, but I sent punches to their system for department changes that they imported every minute. A few years ago we dumped all of their terminals and they now import in/out as well as the start/end activity punches from MES.
We tried also to keep all of the old badges, but eventually bit the bullet and reprinted 400 cards to work with MES and then I send the time and attendance software their employee id.
It is possible in a customization to flip the badge entered to another value by changing whereClauseLaborHed on clock in.
Maybe I am missing a salient point here but the EmpBasic table already has a CnvEmpID field that, at least on my system, is blank. This field it is not exposed on a form so you would need to add this in a customization. There is also a search cross reference attached to this table that could be leveraged to add different employee numbers.
Obviously Epicor has had this issue before so they built it into the system.
I can sympathize with how people get attached to their employee numbers. We had to wait for someone that had 30 years in to retire so we can remove employee number “7” in the system!
We created a UD field to store RFID keys in that relate to someone’s employee ID. They scan the read-only RFID card and we translate it to employee ID. Probably would work just the same in your case.
