KZN HEALTH · SCM-NUMS Enterprise | System Architecture

SCM-NUMS
System Architecture

Supply Chain Management – Nurse Uniform Management System

For Management & Auditors · Audit-Ready Architecture

Version: 3.0 Date: August 2026 Classification: Internal
Purpose: A unified, transparent, and auditable platform for nurse registration, uniform ordering, supervisor approval, distribution tracking, financial reporting, and compliance monitoring.
32,000+
Nurses & Users
Province-wide coverage
11
Health Districts
KwaZulu-Natal
700+
Health Facilities
Hospitals · Clinics · CHCs
32000+
Total Orders
Yearly
✅ Key Management Benefits
  • Provincial standardisation of uniform ordering
  • Real-time visibility of orders and approvals
  • Complete financial accountability
  • Audit-ready transaction logs
  • Fraud prevention and detection
📋 Audit Readiness
  • Every transaction is logged and time-stamped
  • Full traceability to individual users
  • Continuous audit evidence
  • Internal & external audit support
  • PHSDSBC Resolution 1 of 2022 compliant

Table of Contents

01 Executive Summary
02 System Overview & Scale
03 Enterprise Architecture Layers
04 Governance & Audit Framework
05 Security Architecture
06 Role-Based Access Control
07 Data Architecture & Schema
08 Process Flows
09 Integration & Deployment
10 Audit Assurance & Benefits

2. System Overview

SCM-NUMS is a provincial enterprise platform that digitizes and automates the uniform management process for all nurses in KwaZulu-Natal. It replaces manual paper-based systems with a secure, web-based solution that provides end-to-end visibility and control.

32,000+
Active Users
Nurses & staff
5,000+
Monthly Orders
Average volume
100%
Audit Coverage
All transactions

Stakeholder Groups

StakeholderRoleAccess
NursesPlace orders, view historyNurse Portal
SupervisorsApprove/reject, activateSupervisor Dashboard
District AdminsManage district operationsDistrict Admin
Head OfficeOversee provinceHead Office Portal
AuditorsReview logs, complianceAudit Reports

3. Enterprise Architecture Layers

A four-layer architecture designed for security, scalability, performance, and maintainability

Presentation
Nurse Portal Supervisor Dashboard District Admin Head Office Responsive
Application
Auth Orders Approvals Catalogue Reports Audit
Data
User & HR Orders Catalogue Audit Logs Reference
Infrastructure
Linux Apache PHP 8.2 MariaDB HTTPS Backup
🔐 Authentication

Session-based login with password hashing

🛡️ RBAC

Role-Based Access Control with data filtering

📋 Audit

Complete transaction logging with IP tracking

☁️ Scalable

Supports 32,000+ users with high availability

4. Governance & Audit Framework

A comprehensive governance model ensuring accountability, transparency, and compliance at every level of the organisation.

🔑 Accountability
  • All actions traceable to individuals
  • Clear role-based responsibilities
  • Audit trail for every transaction
👁️ Transparency
  • Real-time visibility of orders
  • Status tracking for all orders
  • Open reporting and analytics
📜 Compliance
  • PHSDSBC Resolution 1 of 2022
  • KZN Health ICT governance
  • Public service regulations

4.1 Audit Trail Architecture

👤
Who
User ID, Role
🕐
When
Date, Time
📝
What
Action, Values
📍
Where
IP, Device
Why
Reason

4.2 Audit Logging Tables

TableLogged ActionsKey Fields
admin_audit_logAdmin actions: activate, deactivate, editadmin_id, action, description, ip_address, created_at
supervisor_approvalsOrder approvals, rejections, re-openingssupervisor_id, nurse_id, action, rejection_reason
document_audit_trailDocument uploads and changesuser_id, action, filename, file_size, ip_address
uniform_ordersOrder status changesid, status, approved_by, approved_date

Audit Assurance: The system provides continuous audit evidence rather than retrospective manual verification. All electronic records are time-stamped and tamper-evident.

5. Security Architecture & 6. RBAC

Multi-layer security with clear role hierarchy

🔐 Layer 1: Authentication
  • Password hashing (bcrypt)
  • Session-based authentication
  • Session timeout (30 minutes)
  • Secure password reset flow
  • Failed login attempt tracking
Secure
🛡️ Layer 2: Authorization
  • Role-Based Access Control (RBAC)
  • Menu-level permissions
  • Action-level permissions
  • Data-level filtering
RBAC
🔒 Layer 3: Data Security
  • Input sanitization
  • Prepared statements
  • XSS prevention
  • CSRF protection
  • SSL/TLS encryption
Protected
📋 Layer 4: Audit
  • Admin action logging
  • Supervisor approval logging
  • IP address tracking
  • User agent tracking
Audited

Role Hierarchy

Head Office

  • Full System access
  • All districts & settings

District Admin

  • Limited District ops
  • District reporting

Supervisor

  • Restricted Approve/reject
  • Activate supervisees

Nurse

  • Basic Place orders
  • View own history

7. Data Architecture & Database Schema

Centralized data management with 14 core tables

MariaDB 10.4+

Relational database

Transaction-Safe

ACID compliance

Centralized

Single source of truth

Indexed

Optimized for reporting

🔑 PK 🔗 FK
nurses_users
🔑 id INT
🔑 persal_number
surname, name, district
🔗 position_id
🔗 department_id
is_supervisor, is_active
uniform_orders
🔑 id INT
🔗 user_id
order_date, status
approved_by, approved_date
total_amount DECIMAL
uniform_catalogue
🔑 id INT
category, item_name
price DECIMAL
sizes TEXT
max_quantity_per_order
order_items
🔑 id INT
🔗 order_id
🔗 uniform_id
size, quantity
price, subtotal
admin_users
🔑 id INT
username UNIQUE
password, email
full_name, role
district, is_active
admin_audit_log
🔑 id INT
🔗 admin_id
action, description
ip_address, user_agent
created_at TIMESTAMP

8. Process Flows

Registration & Activation

Register
Validate
Pending
Activate
Active

Order & Approval

Order
Pending
Review
Approve
Reject
Re-open
Approved
Delivered
Rejected

9. Integration Points

✅ Active Integrations
  • HR Database – Persal validation
  • Excel/CSV Export – Reporting
  • Browser Print – Report generation
Active
⏳ Future Integrations
  • SCM Stores Module – Inventory
  • Active Directory/LDAP – SSO
  • Mobile App – iOS & Android
Planned

10. Deployment & Infrastructure

Development

  • Local XAMPP/WAMP
  • Git version control

Staging

  • Mirror of production
  • UAT & Performance

Production

  • Red Hat Enterprise Linux
  • Daily backups

11. Audit Assurance & Compliance

Audit Assurance Statement: SCM-NUMS provides continuous, tamper-evident audit evidence for all uniform management transactions. Every action is logged, time-stamped, and traceable to an individual user.

11.1 Audit Evidence Captured

Audit AreaWhat is CapturedWhereRetention
User ActivityLogins, logouts, failed attemptsSystem logsIndefinite
Account ChangesActivations, deactivations, editsadmin_audit_logIndefinite
Order LifecycleCreation, approval, rejectionuniform_ordersIndefinite
Catalogue ChangesAdd, edit, delete, activateadmin_audit_logIndefinite
System ConfigurationOrder cycles, settings changesadmin_audit_logIndefinite

12. Management Benefits

Full Visibility
Real-time tracking
Financial Control
Complete reporting
Audit Readiness
Continuous evidence
Fraud Prevention
Full traceability
Operational Efficiency
Eliminates manual
Provincial Standardisation
Consistent across districts

SCM-NUMS provides the KwaZulu-Natal Department of Health with a fully auditable, transparent, and efficient uniform management platform.