SmartERP Documentation An Ashewa Technology Solutions Platform

Medical Record Audit Trail & Legal Compliance

Maintain tamper-evident clinical audit logs, legal hold locks, medical record archiving, and statutory retention compliance.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Medical Record Audit Trail & Legal Compliance within SmartERP.

Healthcare OPD and IPD Admission, Discharge, and Transfer (ADT) operational swimlane workflow.
SmartERP Healthcare Outpatient (OPD) and Inpatient (IPD) clinical workflow lifecycle.

Maintain tamper-evident clinical audit logs, legal hold locks, medical record archiving, and statutory retention compliance.

2. Prerequisites & Security Access Groups#

  • Required Modules: smarterp_healthcare, smarterp_clinical_core, smarterp_pharmacy
  • Security Groups:
    • Healthcare Receptionist (Technical ID: smarterp_healthcare.group_medical_receptionist)
    • Physician / Attending Doctor (Technical ID: smarterp_healthcare.group_medical_doctor)
    • Pharmacy Dispenser (Technical ID: smarterp_healthcare.group_medical_pharmacist)
  • Master Data Dependencies: Patient master registry (Medical Record Number - MRN), EFDA drug formulary, Ethiopian Ministry of Health (MoH) HMIS disease codes, and EHIS insurance tariffs.

3. Step-by-Step Configuration & Execution#

Step 1: Navigating to the Interface#

  1. Log into your SmartERP instance at https://smarterp.et/odoo.
  2. Open the main App Switcher (grid icon in the top-left corner).
  3. Navigate to Hospital → Patient Management → OPD / IPD.

Step 2: Operational Data Parameters & Controls#

Ensure all mandatory parameters comply with enterprise operational standards:

  • Authorized Operator: Action executed under assigned RBAC permissions (Chief Medical Officer, Clinical Nurse, Receptionist, Pharmacist).
  • Relational Integrity: Linked to upstream master records, approval requests, or transactional ledgers.
  • Statutory & Quality Controls: Verified against Ethiopian statutory regulations and corporate governance standards.

Step 3: Operational Execution & State Progression#

  • State Progression Gate: Advance record from Draft through Audited to Confirmed / Certified.
  • Integrated System Impact: Automatically updates real-time operational states and posts financial/inventory journal moves.
  • Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.

Statutory Medical Record Retention in Ethiopia#

Under Ethiopian health law and civil liability statutes:

  • Adult Medical Records: Retained for a minimum of 10 years following the date of the last clinical encounter.
  • Pediatric & Obstetric Records: Retained for 21 years (until the newborn reaches the age of majority plus legal statute of limitations).
  • Forensic & Medico-Legal Records: Retained indefinitely under permanent legal hold status.

Cryptographic Audit Logging#

Every access or modification to patient data triggers an immutable audit log entry in medical.audit.log:

  • timestamp: UTC timestamp synchronized with atomic clock servers.
  • user_id: Authenticated staff account.
  • patient_id & record_id: Target clinical record.
  • action_type: READ, CREATE, UPDATE, PRINT, EXPORT, BREAK_THE_GLASS.
  • previous_values and new_values: JSON delta of modified attributes.
  • client_ip: Terminal network IP and device MAC address.

Audit records are append-only; database constraints strictly prohibit DELETE or UPDATE queries against audit log tables.

When formal legal requests or court subpoenas demand medical documentation:

  1. Navigate to Healthcare > Legal & Compliance > Medico-Legal Requests.
  2. Record requesting authority (Court Name, Case Docket Number, Investigating Officer).
  3. Select the patient and specific date range covered by the legal mandate.
  4. Click Generate Watermarked Medico-Legal Record:
    • The system compiles signed physician notes, operative records, and laboratory reports into an encrypted PDF.
    • Every page features dynamic watermarks displaying the requesting court docket, generation date, and issuing medical records officer credentials.

4. Advanced Configuration Points#

  • Automated Actions & Scheduled Tasks (Crons):
    • Healthcare: Generate daily MoH HMIS aggregate tally (smarterp_healthcare.ir_cron_hmis_sync): Runs daily at 23:00 to prepare DHIS2 health data summaries
    • Pharmacy: Flag expiring EFDA medicine batches (smarterp_healthcare.ir_cron_fefo_expiry): Runs daily at 06:00 to alert dispensers of lots expiring within 60 days
  • Custom Print Templates & Reports:
    • Official Patient Encounter Summary & Medical Certificate
    • Electronic Prescription Order Form (Model 19 Compliant)
    • Ethiopian Health Insurance Service (EHIS) Claim Dossier
    • Daily MoH Outpatient / Inpatient Morbidity Tally Sheet
  • Multi-Company Rules: Record-level security isolation under Company 1 (Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.

5. Comprehensive Troubleshooting Matrix#

Error Symptom / ExceptionProbable Root CauseCorrective Action / Resolution
Access Block: Confidential clinical diagnosis restrictedUser is not listed as the patient's attending physician or authorized consultant.Request explicit clinical consultation delegation from the department head.
Credit Ceiling Block: Corporate insurance expiredPatient corporate insurance policy limit exceeded or expired.Switch billing mode to private cash settlement or upload pre-authorization approval from the insurer.
FEFO Allocation Error: Expired medicine batch blockedDispenser selected medicine lot past statutory EFDA expiry date.Isolate expired lot to quarantine storage and dispense compliant active lot.
Last updated: 2026-11-15