Apprenticeship tracking software that keeps every apprentice's hours, skills and mentor sign-offs on one record, and warns a year ahead
Apprentice to journeyman with every sign-off on record.
See one case, screen by screen ↓Apprenticeship Program Management is software for a utility's training team that tracks every apprentice's on-the-job hours, related instruction and mentor sign-offs in one skills passport, from the first day to journeyworker. Lineworker, cable jointer, substation and water network apprenticeships run three to four years. Each apprentice has to log thousands of OJT hours across set work areas, pass the college modules and collect a journeyworker's sign-off on every skill, and every wage step depends on those records.
Today the hours sit in paper logbooks and timecards, the sign-offs in binders, and the coordinator reconciles them in spreadsheets each month for wage steps and the agency return. Mentors stamp days or weeks after the job, from memory. An apprentice can be on pace overall and still be hundreds of hours short in one work area that only some crews do — HV jointing, live-line, protection testing — and nobody sees it until the trade-test application, when it costs a year. A wage step paid late is a grievance, a step paid early is an overpayment, and a wrong return is a finding at the sponsor's next review.
Estimated split for a program of about 46 apprentices, in working days per quarter, by hand and with the solution.
Seven agents keep every apprentice's skills passport from the logbook and warn early; mentors stamp and the coordinator decides.
Kofi Mensah is a year-3 apprentice cable jointer on the Dunmore LV jointing crew at Lumina Utilities. He started on 15 Jan 2024 and qualifies on 10 Jan 2028. On Mon 12 Oct he spends a day lent to the Halden Cross HV crew. Here is what happens next, screen by screen, in the working solution.
At the end of the shift Kofi types his entry in the phone app and attaches a photo of the joint shell before closing. The logbook reader finds six things in it: the supervisor, the skill, the job, the hours, the part Kofi did himself and the photo, each quoted from his own words.
“Asst M Novak w/ 11kV trans joint PILC to XLPE at Halden X sub, feeder HX-14. 6.5 hrs. Did the screen + armour bond, Marta did the paper strip.”
The logbook reader maps the entry to skill HVJ-04, the 11 kV transition joint, paper to polymer, with Marta Novak as supervisor. The timecard matcher finds job 26-44817: cost code HV-JNT, 6.5 h, supervisor M. Novak — the hours agree. The passport keeper moves HV jointing from 311.5 to 318 h and puts HVJ-04 in Marta's queue. Then the pace watcher raises the warning.
Pace watcher: “Needs 39 h a month to 10 Jan 2028; 12 since April → Nov 2030. Warning raised.”
Priya runs 46 apprentices in four trades for Lumina Technical Academy. Kofi's skills passport shows 5,312 of 8,000 OJT hours with 69 % of his time elapsed — on pace overall. But one gauge is red: HV cable jointing, 11 and 33 kV, 318 of 900 hours. His 64 skills show 41 stamped, 3 awaiting a stamp and 20 to go.
“Behind pace · qualifies Nov 2030, nearly 3 years late — needs 582 more HV hours in 15 months · the Dunmore crew logs 12 a month”
Priya clicks the amber HVJ-04 box. The rail shows the skill done on 12 Oct and awaiting Marta Novak's stamp, the logbook entry, the timecard and the photo from Halden Cross substation, feeder HX-14. A skill stamped earlier shows who stamped it and when; an outstanding HV skill shows the jobs where Kofi can do it.
Passport keeper: never marks a skill stamped — only a named mentor can.
The planner proposes 12 weeks with the Halden Cross 33 kV crew under Marta Novak, 2 Nov 2026 to 22 Jan 2027. The crew's job book has 14 HV jobs in that window, 384 apprentice hours, and covers all four outstanding HV skills, HVJ-05 to HVJ-08. HV hours go from 318 to 710, then one HV day a week takes Kofi to 900 by Aug 2027. His wage step is unchanged by the move.
“Qualification: On time — five months before 10 Jan 2028 · was Nov 2030”
The planner read the job books of 7 crews for the window, 61 HV jobs in all. Riverside's mentor ratio is full. Fernvale Cabling, a contractor, has 410 HV hours but is excluded: no registered journeyworker mentor on site. It also finds a backfill for Dunmore — Lena Ortiz, year 2, who needs LV fault hours — and drafts the message to Ray Okonkwo, the crew lead.
Excluded: “Fernvale Cabling: no registered journeyworker on site (rule: HV work 1 apprentice to 2 journeyworkers)”
Ray Okonkwo was asked at 08:10. Priya approves the placement, and Kofi, Marta Novak, Ray Okonkwo, Lena Ortiz and the Dunmore and Halden Cross rosters are told. Her approval goes on the record with the planner's draft and the pace projection. Back on the passport, HV jointing reads placed and the projected line reaches 900 h in Aug 2027.
“On pace after the placement · 900 h by Aug 2027 · five months before 10 Jan 2028 · approved by Priya Natarajan”
Marta's queue holds four skills: Kofi's HVJ-04 and three for Sam Adeyemi, who needs them to top out on 6 Nov. Each shows the apprentice's words, the timecard with “you were the supervisor”, the photos and, for Kofi, his passed college module CJ-305. She stamps HVJ-04 inside the 7-day stamp clock; one of Sam's is already over it.
“HVJ-04 stamped for Kofi Mensah · on the passport and the record”
Two steps are ready: Lena Ortiz, 2 → 3, and Grace Mwangi, 5 → 6, both effective 19 Oct. Kofi is on step 5 (70 %, $36.68 an hour); step 6 (75 %, $39.30) needs 5,500 h, where he has 5,312, and HVJ-04 and LVJ-08 stamped. HVJ-04 is now stamped; LVJ-08 awaits Ray Okonkwo, and the step is est. 20 Nov. Tom Brennan's step is held until his hours are settled.
Wage-step checker: never sends a step to payroll without the coordinator.
The return preparer builds the registered apprenticeship program return for 1 Jul to 30 Sep: 46 active, 6 starts, 3 completions, 1 cancellation, 21,940 OJT hours, 1,612 related-instruction hours, 9 wage steps, 0 sites over the journeyworker ratio. Click any figure to see where it comes from: 21,940 h from 2,861 logbook entries, every one matched to a timecard, 14 corrected by a person with reasons.
“The return preparer counts; Sean Gallagher signs. Nothing is sent to the agency until he does.”
One apprentice's year, seen by the five people who carry it — what their month looked like, and what it looks like now.
Seven agents keep every apprentice's skills passport from the logbook and warn early; mentors stamp and the coordinator decides.
Reads each logbook entry — phone text, a photo of a paper page or a voice note — and finds the job, the hours, the work area in the program standard, the skill units it is evidence for and who supervised, quoting the words each finding comes from.
Finds the timecard for the entry's date and job and compares hours, cost code and supervisor. Travel and standby are not on-the-job hours.
Updates each apprentice's skills passport: hours by work area, skills done and awaiting a stamp, and the evidence attached to each.
Every night, projects each apprentice's hours in every work area to their qualification date at the last six months' rate and raises behind-pace and watch warnings.
Finds crews whose job books cover the missing hours and skills, within mentor ratios, and drafts a placement with a backfill and the message to the crew lead.
Checks hour thresholds and skill gates against the wage schedule and drafts step-ups with their effective dates for the payroll file.
Builds the quarterly agency return and the committee pack from the roster, timecards and college transcripts, each figure tied to its records.
Stamps skills · approves placements and steps. The agents propose; a named person decides.
Ask about any apprentice, skill, crew or report — or say what to change. Every answer points to its records.
Why is Kofi behind on HV jointing?
Kofi has 318 of the 900 HV hours the standard needs, with 15 months to his date. Since April he has logged 12 HV hours a month because the Dunmore crew does almost only LV work; he needs 39. His last HV hours came from a day lent to Marta Novak on 12 Oct. At this pace he qualifies in Nov 2030.
Who will miss their qualification date?
5 apprentices are behind pace and 3 are on watch. Kofi Mensah is short 582 h in HV jointing, Tom Brennan 936 h in live-line, Mei Lin 804 h in protection testing, Aisha Rahman 712 h in leak detection and Daniel Osei 390 h in storm and fault, with 4 months left. Daniel is the most urgent.
Propose a placement for Kofi
The best fit is 12 weeks with the Halden Cross 33 kV crew under Marta Novak, 2 Nov – 22 Jan: 14 HV jobs, 384 hours, and all 4 outstanding HV skills. Marta has room under the 1-to-2 HV ratio. Lena Ortiz can backfill at Dunmore. With one HV day a week after, Kofi reaches 900 h in Aug 2027, five months before his date. It needs your approval.
Is the Q3 return ready to sign?
Yes, the draft is ready for Sean Gallagher: 46 active, 6 starts, 3 completions, 1 cancellation, 21,940 on-the-job hours and 1,612 instruction hours. Every hour is matched to a timecard or a college transcript; 14 entries were corrected by a person, each with a reason. It is due 15 Oct.
13 screens from the working solution, on its sample data. Pick one to see it large.
Pace warnings, sign-off rules, ratios and approvers are settings Lumina's training team configures. Changes are versioned and need the program manager.
| Setting | Default | Choose from |
|---|---|---|
| Behind when a work area finishes after the | qualification date | projected at the last 6 months' rate |
| Watch when it finishes within | 3 months | of the qualification date |
| Warn at least | 12 months ahead | so a placement can still close the gap |
| Who may stamp | Journeyworker on the timecard | agents never stamp |
| Stamp within | 7 days | reminder on day 5, coordinator told on day 8 |
| Hours credited when | logbook and timecard agree | otherwise a person decides |
| HV and live-line work | 1 apprentice : 2 journeyworkers | checked against every placement and roster · other work 1 : 1 · 2 apprentices per mentor |
| Approvers | Priya Natarajan · Sean Gallagher | placements: Priya Natarajan, crew leads asked first · wage steps: Priya Natarajan → payroll, cut-off Thursday · quarterly return: Sean Gallagher, due 15 days after quarter end |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
“demo” = seen in the working solution, on its sample program data · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (AWWA, 2025 — 21 % of water utility staff can retire within five years; BLS Census of Fatal Occupational Injuries via Relia, 2024 — line installers 13.8 deaths per 100,000 full-time workers against 3.3 for all workers, not re-checked against the BLS table). Regulatory context: 29 CFR 29.5 (registered apprenticeship standards: work processes, related instruction, progressive wages, records). Lumina Utilities, the academy, crews, college and the people named on this page are fictional — characters and sample data in the working solution.
Software that tracks each apprentice's on-the-job hours, related instruction and skill sign-offs from the first day to journeyworker, and turns them into wage steps and the agency return. Apprenticeship Program Management keeps all of it in one skills passport per apprentice, kept current by seven agents from the logbook and the timecard. Mentors stamp skills and the coordinator decides.
Apprentices keep logging the way they do now — a phone text, a photo of a paper page or a voice note. Each night the logbook reader finds the job, hours, work area, skill and supervisor; the timecard matcher checks the hours against the timecard and cost code; and the passport keeper adds them to the right work area. Hours that disagree with the timecard are not credited until a person decides.
Every night the pace watcher projects each work area to the apprentice's qualification date at the last six months' rate. In the sample program it flagged Kofi Mensah 582 HV jointing hours short with 15 months left, projecting Nov 2030 against a 10 Jan 2028 date. The placement planner then drafts a crew placement that closes the gap, within the mentor ratios.
Each journeyworker gets a queue of only the jobs they supervised, with the apprentice's words, the timecard, the photos and, where it applies, the college module. They stamp or return each one, within a 7-day clock with a reminder on day 5. Only the journeyworker on the timecard may stamp, and a photo is required for HV and live-line skills.
Yes. The return preparer builds the quarterly return — active apprentices, starts, completions, cancellations, OJT and related-instruction hours, wage steps, ratios and demographics — with every figure linked to the records behind it. It never submits; the committee secretary signs, and nothing is sent to the agency until he does.
The wage-step checker tests each apprentice's logged hours and skill gate against the wage schedule and drafts the step with its effective date. A step whose hours depend on a disputed logbook entry is held. The coordinator approves the ready steps before anything goes to payroll.
Yes. The agents read, match, project and draft. Only a named mentor stamps a skill, the coordinator approves placements and wage steps after the crew leads are asked, and the committee secretary signs the return. Every agent reading, stamp and approval is on the record with who and when.
The Agentic Solution Engine builds and deploys it from your requirements and documents — your program standards, wage schedules, competency checklists and a sample of logbooks and timecards — and it goes live once every quality gate has passed. We will walk you through it on your own apprentices first.
We'll run Apprenticeship Program Management on a sample of your own logbooks, timecards and program standards.