Team members tracked
12
Plant B maintenance
Fully compliant
8
All certs valid
Expiring <30 days
3
Action required
Overdue / expired
1
Immediate action
Compliance rate
92%
Target: 100%
Team HSE compliance register
1 overdue
3 expiring
+ Add member
| Team member | Role | Certifications held | Medical expiry | HV license | Forklift | Heights cert | Overall | Actions |
|---|---|---|---|---|---|---|---|---|
TN T. Nkosi Sr Technician |
Electrician | ✓ HV✓ Heights✗ Forklift exp | 14 Jun 2026 75d remaining |
01 Sep 2026 153d |
12 Mar 2026 EXPIRED 20d |
15 Nov 2026 228d |
Partial | |
MP M. Pieterse Technician |
Mechanical | ✓ Heights✓ Forklift— HV N/A | 03 Mar 2026 OVERDUE 29d |
N/A Not required |
08 Aug 2026 129d |
08 Aug 2026 129d |
Overdue | |
SD S. Dlamini Technician |
HVAC | ⚠ Heights exp✓ Forklift— HV N/A | 22 Jul 2026 112d |
N/A Not required |
30 Sep 2026 182d |
18 Apr 2026 17d left |
Expiring | |
RN R. Ndlovu Shift Supervisor |
Supervisor | ✓ HV✓ Heights✓ Forklift | 10 Oct 2026 192d |
10 Oct 2026 192d |
10 Oct 2026 192d |
10 Oct 2026 192d |
Compliant | |
JV J. van der Berg Technician |
Hydraulics | ✓ Forklift⚠ HV exp— Heights N/A | 05 May 2026 34d |
28 Apr 2026 27d left |
15 Dec 2026 258d |
N/A Not required |
Expiring |
HSE compliance schemaPostgreSQL
CREATE TABLE HSE_Competencies (
comp_id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users,
cert_type VARCHAR(50),
-- HV_License/Forklift/Heights
-- Medical/Confined_Space/Rigging
cert_number VARCHAR(50),
issued_by VARCHAR(100),
issued_date DATE,
expiry_date DATE,
is_valid BOOLEAN
GENERATED ALWAYS AS
(expiry_date >= CURRENT_DATE) STORED,
doc_url TEXT,
-- Scanned cert upload
reminder_sent BOOLEAN DEFAULT FALSE
);
CREATE TABLE Medical_Assessments (
med_id SERIAL PRIMARY KEY,
user_id UUID REFERENCES Users,
assessed_by VARCHAR(100),
assessment_date DATE,
expiry_date DATE,
outcome VARCHAR(20),
-- Fit/Fit_With_Restrictions/Unfit
restrictions TEXT NULL,
is_valid BOOLEAN
GENERATED ALWAYS AS
(expiry_date >= CURRENT_DATE) STORED
);
Compliance statsISO 45001
HV licenses — compliant3 / 3 required
Forklift licenses — compliant4 / 5 (1 expired)
Working at heights — compliant3 / 4 (1 expiring)
Medical assessments — valid4 / 5 (1 overdue)
Technicians cleared for HV work2 of 5
Auto-reminders sent this month7
Renewals completed this quarter4
Competency matrix — Plant B maintenance team
✓Valid
!Expiring
✗Expired
—N/A
PPending
| Team member | HV Electrical | Working at Heights | Forklift Op. | Confined Space | First Aid | Fire Fighting | Rigging & Slinging | Annual Medical | LOTO Procedure |
|---|---|---|---|---|---|---|---|---|---|
| T. Nkosi Sr Tech | ✓ |
✓ |
✗ |
✓ |
✓ |
✓ |
— |
✓ |
✓ |
| M. Pieterse Tech | — |
✓ |
✓ |
✓ |
✓ |
— |
✓ |
✗ |
✓ |
| S. Dlamini HVAC Tech | — |
! |
✓ |
— |
✓ |
✓ |
— |
✓ |
✓ |
| R. Ndlovu Supervisor | ✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
| J. van der Berg Tech | ! |
— |
✓ |
— |
✓ |
— |
✓ |
! |
✓ |
| K. Mokoena Tech | — |
✓ |
✓ |
P |
✓ |
✓ |
— |
✓ |
✓ |
HV-cleared technicians
2 of 6
Heights-cleared
4 of 6 (1 expiring)
Total gap cells
4
IATF audit readiness
⚠ 4 items require resolution before audit
License & certification register3 expiring <30d
T. Nkosi — Forklift Operator License
FKLFT-2023-TN04 · Issued by: TETA SA
Expired 12 Mar 2026
20 days overdue
Forklift access blocked
J. van der Berg — HV Electrical License (25kV)
HV-LIC-2024-JVB · Issued by: ECSA
Expires 28 Apr 2026
27 days remaining
Renewal required
S. Dlamini — Working at Heights Certificate
WAH-2024-SD07 · Issued by: SACPCMP
Expires 18 Apr 2026
17 days remaining
Renewal required
T. Nkosi — HV Electrical License (25kV)
HV-LIC-2025-TN01 · Issued by: ECSA
Expires 01 Sep 2026
153 days remaining
Active
R. Ndlovu — HV Electrical License (25kV)
HV-LIC-2025-RN02 · Issued by: ECSA
Expires 10 Oct 2026
192 days remaining
Active
Annual medical assessment register1 overdue
| Team member | Last assessment | Expiry | Outcome | Restrictions | Status | Action |
|---|---|---|---|---|---|---|
MP M. Pieterse Technician |
03 Mar 2025 | 03 Mar 2026 | Fit | None | OVERDUE 29d | |
JV J. van der Berg Technician |
05 May 2025 | 05 May 2026 | Fit | None | Due in 34d | |
TN T. Nkosi Sr Technician |
14 Jun 2025 | 14 Jun 2026 | Fit | None | 75d remaining | |
RN R. Ndlovu Supervisor |
10 Oct 2025 | 10 Oct 2026 | Fit | None | 192d remaining | |
SD S. Dlamini HVAC Tech |
22 Jul 2025 | 22 Jul 2026 | Fit w/ restrictions | No confined space | 112d remaining |
System rule: Any technician with an overdue medical assessment is automatically blocked from being assigned high-risk job cards (HV, Heights, Confined Space) until the medical is renewed. M. Pieterse is currently restricted.
Calibration & testing register — gauge lockout trackerISO 9001 MSA
Torque gauge TG-09
SER: TG-09-2022 · Range: 0–500 Nm · Location: Tool store B
Expired 29 Mar 2026
3 days overdue
🔒 LOCKED OUT
Pressure gauge PG-04
SER: PG-04-2023 · Range: 0–400 bar · Location: Hydraulic bay
Expires 15 Apr 2026
14 days remaining
Expiring soon
Vibration sensor VB-04 (HVAC-A)
SER: VB-04-2024 · Range: 0–50 mm/s · Asset: HVAC Motor-A
Expires 21 Sep 2026
173 days remaining
✓ Active
Insulated gloves GL-HV-03 (T. Nkosi)
SER: GL-HV-03 · Class 00 · Last tested Jan 2026
Expires 01 Jul 2026
91 days remaining
✓ Active
Temperature probe TP-07
SER: TP-07-2024 · Range: -20–200°C · Location: HVAC bay
Expires 14 Nov 2026
227 days remaining
✓ Active
Lockout rule: Any instrument with an expired calibration certificate is automatically locked in the system. Job cards that reference a locked instrument cannot be started until the instrument is recalibrated and re-certified. TG-09 is currently blocked from use on all job cards.
Configure exactly who gets notified, by what channel, and when — for every trigger event in the system. All triggers are immutably logged for audit purposes.
🚨
Production breakdown
Fires when a technician logs a critical breakdown on any asset · Immediate
Active
▾
Email recipients
Webhook URL (optional)
Delay before firing
Channels
Escalation chain
1
Immediate: Maintenance Group + Production Lead notified via email + push
T+0 min
2
If not acknowledged in 15 min: Maintenance Manager escalated
T+15 min
3
If not resolved in 60 min: Plant Manager notified with downtime cost estimate
T+60 min
✓ Test sent to [email protected]
📦
Low critical stock — auto-PR
Fires when any critical spare drops to or below min_threshold · Database trigger
Active
▾
Email recipients
Auto-attach PDF purchase requisition
✓ Test PR email sent to [email protected]
⚠
Safety violation / missing PPE
Fires when a technician bypasses a PPE check or fails a toolbox audit · Immediate
Active
▾
Email recipients
Include GPS evidence in email
✓ Test alert sent to [email protected]
⚖
Calibration / certification expiry
Fires 30 days, 14 days, and 1 day before expiry — and immediately on expiry lockout
Active
▾
Email recipients
Reminder schedule
✓ Test reminder sent to [email protected]
🪪
HSE license / medical expiry
Fires when a team member's license, cert, or medical assessment is expiring or overdue
Active
▾
Email recipients
Auto-block job assignment on expiry
✓ Test alert sent to [email protected]
📋
PTW awaiting sign-off
Fires when a permit step is awaiting the next signatory — escalates after 30 min silence
Active
▾
Notified signatory
Recipients are dynamically set by the PTW signatory chain — the next required signer is notified automatically. Escalation goes up the chain after the configured delay.
Escalation delay
✓ Test PTW nudge sent to pending signatory
📈
PdM engine — MTBF threshold breach
Fires when an asset MTBF drops >20% below historical average in 3 cycles
Active
▾
Email recipients
MTBF drop threshold (%)
✓ Test PdM alert sent to [email protected]
🏭
Supplier contingency activation
Fires when a primary supplier order is unacknowledged >24h or a force majeure is logged
Active
▾
Email recipients
Unacknowledged order timeout
✓ Test contingency alert sent to [email protected]
Notification audit log — last 24 hours
Immutable — ISO 45001 audit trail
Safety violation — T. Nkosi PPE bypass on Job #1042. Alert sent to [email protected], [email protected]. GPS coordinates + device ID attached. Delivered ✓
09:43 today
Production breakdown — BP-3 offline. Alert sent to [email protected], [email protected] via email + Slack webhook. Escalation pending (15 min). Delivered ✓
09:30 today
Low critical stock — PLC-CPU-X2 at 1 unit (min: 3). Auto-PR PDF generated and sent to [email protected], [email protected]. Siemens SA contact details included. Delivered ✓
09:28 today
Calibration expiry lockout — Torque gauge TG-09 expired. Item locked in system. Alert sent to [email protected], [email protected]. Delivered ✓
08:00 today (scheduled)
PTW pending sign-off — PTW-003 awaiting GM approval (R. Adams). Notification sent. No response after 30 min — escalated to Plant Manager. Delivered ✓
10:05 today
Medical assessment overdue — M. Pieterse medical 29 days overdue. Alert sent to [email protected], [email protected]. Job card assignment blocked for high-risk tasks. Delivered ✓
08:00 today (scheduled)
License expiring (14d warning) — S. Dlamini Heights cert expires 18 Apr 2026. Sent to [email protected], [email protected]. Delivered ✓
08:00 today (scheduled)