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 maintenance_group@sieben.co.za
๐ฆ
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 stores_manager@sieben.co.za
โ
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 hse_manager@sieben.co.za
โ
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 procurement@sieben.co.za
๐ชช
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 hse_manager@sieben.co.za
๐
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 production_lead@sieben.co.za
๐ญ
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 management@sieben.co.za
Notification audit log โ last 24 hours
Immutable โ ISO 45001 audit trail
Safety violation โ T. Nkosi PPE bypass on Job #1042. Alert sent to hse_manager@sieben.co.za, hse_manager@sieben.co.za. GPS coordinates + device ID attached. Delivered โ
09:43 today
Production breakdown โ BP-3 offline. Alert sent to hr@sieben.co.za, maintenance_manager@sieben.co.za 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 procurement@sieben.co.za, plant_manager@sieben.co.za. Siemens SA contact details included. Delivered โ
09:28 today
Calibration expiry lockout โ Torque gauge TG-09 expired. Item locked in system. Alert sent to safety_officer@sieben.co.za, hse_manager@sieben.co.za. 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 maintenance_group@sieben.co.za, production_lead@sieben.co.za. 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 procurement@sieben.co.za, stores_manager@sieben.co.za. Delivered โ
08:00 today (scheduled)
PdM MTBF breach โ HVAC Motor-A MTBF dropped 22% below historical average. Alert sent to management@sieben.co.za. PM interval adjustment suggested. Delivered โ
06:15 today
Supplier contingency โ Siemens SA order PO-2026-041 unacknowledged for 24h. Alert sent to procurement@sieben.co.za, plant_manager@sieben.co.za. Schneider Electric contingency pre-filled. Delivered โ
Yesterday 15:15
Notification engine schemaPostgreSQL
CREATE TABLE Notification_Triggers (
trigger_id SERIAL PRIMARY KEY,
trigger_type VARCHAR(50) UNIQUE,
is_active BOOLEAN DEFAULT TRUE,
recipients TEXT[],
channels TEXT[],
webhook_url TEXT NULL,
delay_minutes INT DEFAULT 0,
escalation_json JSONB
);
CREATE TABLE Notification_Log (
log_id BIGSERIAL PRIMARY KEY,
trigger_type VARCHAR(50),
fired_at TIMESTAMP DEFAULT NOW(),
recipients TEXT[],
delivered BOOLEAN DEFAULT FALSE,
is_immutable BOOLEAN DEFAULT TRUE
);