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
| Stakeholder | Role | Access |
| Nurses | Place orders, view history | Nurse Portal |
| Supervisors | Approve/reject, activate | Supervisor Dashboard |
| District Admins | Manage district operations | District Admin |
| Head Office | Oversee province | Head Office Portal |
| Auditors | Review logs, compliance | Audit 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
4.2 Audit Logging Tables
| Table | Logged Actions | Key Fields |
| admin_audit_log | Admin actions: activate, deactivate, edit | admin_id, action, description, ip_address, created_at |
| supervisor_approvals | Order approvals, rejections, re-openings | supervisor_id, nurse_id, action, rejection_reason |
| document_audit_trail | Document uploads and changes | user_id, action, filename, file_size, ip_address |
| uniform_orders | Order status changes | id, 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
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 Area | What is Captured | Where | Retention |
| User Activity | Logins, logouts, failed attempts | System logs | Indefinite |
| Account Changes | Activations, deactivations, edits | admin_audit_log | Indefinite |
| Order Lifecycle | Creation, approval, rejection | uniform_orders | Indefinite |
| Catalogue Changes | Add, edit, delete, activate | admin_audit_log | Indefinite |
| System Configuration | Order cycles, settings changes | admin_audit_log | Indefinite |
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.