A 3,000-employee welding products manufacturing campus automated a multi-variable piecework formula — units, performance multipliers, shift premiums, team proration — inside UKG Pro WFM by migrating 30 pages of MES PL/SQL logic to CloudApper AI Platform.
Table of Contents
At a large welding products manufacturing campus in the Cleveland area with approximately 3,000 employees, the payroll team and IT leadership faced a problem that had been deferred for years: 30-plus pages of PL/SQL stored procedures, living inside their manufacturing execution system, were the only things standing between their workforce and accurate piecework pay. That’s who and what. The where: all of it embedded in production MES code that nobody had touched — or dared to touch — in over a decade. The when: it surfaced during a broader payroll infrastructure migration to UKG Pro WFM. The why, and the reason this matters beyond one facility: that PL/SQL was undocumented, unmaintainable, and completely non-transferable to any modern HR platform. When they needed to move piecework calculation out of the MES and into UKG Pro WFM, they worked with CloudApper AI Platform.
The Pay Rule Nobody Wants to Touch
Piecework pay in manufacturing is simple in concept and deeply complex in practice. The formula at this campus required: units produced multiplied by a unit piecework price, then multiplied again by a Lincoln Dollar (LE$) performance multiplier, then added to a team pay proration based on group output, with shift premiums layered in for second and third shift and a minimum wage guarantee floor applied as a fallback check. Indirect time — setup, cleaning, machine downtime — had to be tracked and compensated separately from productive output time.
Workbridge
UKG Personalization
Missed punches dropped from 30% to under 5% — without touching UKG's core.
Every component of that formula lived inside stored procedures written in PL/SQL, inside an MES system that managed production — not people. No HR leader had visibility into the logic. No payroll team member could audit it.
“We had people who knew that code existed and roughly what it did. We had nobody who could explain it, change it, or certify that it was right. That’s not a sustainable position to migrate payroll from,” said the Payroll Director at the manufacturing campus.
The challenge isn’t unique to this company. In complex manufacturing environments — particularly those running incentive pay tied to production metrics — the calculation engine often predates the HR platform by years. When UKG Pro WFM is adopted for time and attendance and payroll processing, piecework logic frequently has no native home. The calculation is too specific, too formula-heavy, and too variable to configure inside standard earnings code tables. For organizations managing equally complex custom pay structures — including those handling certified payroll and prevailing wage rules inside UKG — the underlying problem is the same: the rule belongs inside the payroll platform, not in a legacy system that payroll cannot access or control.
What the Calculation Actually Requires
Workbridge
UKG Personalization
Migrating UKG Ready to Pro? Your customizations come with you. No rebuilds.
Documenting the formula for migration took three months. The HR Operations Director at the campus described the process as equal parts archaeology and translation: “We had to reverse-engineer what the stored procedures were actually doing, document it in terms the payroll team could work with, and then validate the output against two years of historical pay records before we could trust it.”
The result was a structured pay rule that required a decoupled calculation engine — something that could read production output data, apply the multi-variable formula, and write compensation results into UKG Pro WFM’s payroll tables without requiring custom development inside UKG itself. CloudApper AI Platform operates precisely this way: it sits alongside UKG Pro WFM, ingests the relevant inputs (units, rates, performance multipliers, shift codes), runs the piecework logic, and posts the resulting earnings values back to UKG for payroll processing. The same decoupled approach has worked in contexts where pay complexity spikes for different reasons — including payroll teams managing threshold-based physician incentive pay across shift counts inside UKG Pro WFM. The pattern holds: give UKG clean, validated earnings data; let the rules engine handle the calculation upstream.
How the Decoupled Engine Works
Once the pay rules were documented and the CloudApper AI Platform configuration validated, the MES stored procedures became reference material, not production dependencies. The campus retired the PL/SQL logic from the MES — removing a longstanding operational risk — and moved all piecework calculation into a system the payroll team could audit, the IT team could maintain, and HR leadership could understand.
Workbridge
UKG Personalization
50+ HR gaps UKG leaves open. WorkBridge closes them in days, not months.
The efficiency gains were predictable: period-close time dropped when the payroll team no longer had to reconcile MES output with UKG records manually. The less expected outcome was what happened on the employee side.
Giving Workers Visibility Into Their Numbers
As part of the CloudApper AI Platform implementation, the campus enabled an employee-facing audit dashboard. Workers could see their unit counts, their piecework rate, the performance multiplier applied in the current period, and what their shift premium and minimum wage check looked like — before payroll closed.
“We expected people to use it when they had questions. We didn’t expect them to check it every Thursday,” said the Compensation Manager at the facility. “It turned out that visibility into the formula built more trust in the number than any explanation we could give in a memo.”
For a workforce whose pay varies with production output, that transparency is meaningful. Disputes about short pay periods dropped. Questions to the payroll team during processing windows declined. The IT Director at the campus noted the operational endpoint plainly: “We took 30 pages of stored procedure logic out of a system it never should have lived in, and we put it somewhere the payroll team can actually see and maintain it.” Manufacturing payroll teams operating under similarly complex incentive structures — including those managing non-standard pay cycle calculations inside UKG — have followed comparable paths to move their pay logic into platforms they can govern.
What the Cleveland-area campus demonstrated is that the migration risk for piecework pay isn’t the formula itself — it’s the hidden, unmaintainable form it takes when left inside a system that wasn’t built for it. Surfacing it, documenting it, and connecting it to UKG Pro WFM through CloudApper AI Platform turned a deferred risk into a resolved one.
If your manufacturing operation runs piecework pay alongside UKG Pro WFM and the calculation still lives outside the payroll team’s reach, CloudApper AI Platform can build the bridge between production data and UKG payroll — without modifying UKG or replacing what you have in place.
September 10, 2026
When the Bonus Triggers at Shift 169: How Hospitals Automate Physician Incentive Pay in UKG Pro WFM
A large public hospital automated physician shift-count bonuses, on-call pay, and night differentials inside UKG Pro WFM using CloudApper AI Platform for UKG — eliminating paper timesheets and pay disputes without replacing their existing HR infrastructure.
September 8, 2026
Acquisition Payroll Integration in UKG: How Roll-Ups Make Technician Commissions Audit-Ready
A PE-backed HVAC and plumbing group acquiring five to ten businesses a year stopped rebuilding technician pay logic at every deal. The reason was not cycle time. It was that whatever calculates technician commissions eventually gets read by somebody doing diligence on you.
September 7, 2026
One Punch, Two Audits: Piece Counts and Jobsite Inspection Records in UKG Ready
A Southern California drywall subcontractor used to run two month-end reconciliations: whether the square footage claimed for piece-rate pay was right, and whether the inspections had been done and signed. Those are now one record, which changed the controller's job more than it changed anyone's data entry.
September 2, 2026
Daily, Not Weekly: Automating a Bargained Overtime Rule in UKG Pro WFM
A Canadian paper and packaging manufacturer's agreement does not set an overtime threshold. It sets a delta: hours added beyond an employee's scheduled baseline are overtime that day. Automating that raises a question most integration write-ups skip, which is who can still check the math once the logic leaves the agreement.
