Healthcare Clinical Data Model & Schema Architecture
Technical reference of underlying database models, table relationships, foreign keys, and relational schemas governing SmartERP Healthcare.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Healthcare Clinical Data Model & Schema Architecture within SmartERP.

Technical reference of underlying database models, table relationships, foreign keys, and relational schemas governing SmartERP Healthcare.
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#
- Log into your SmartERP instance at
https://smarterp.et/odoo. - Open the main App Switcher (grid icon in the top-left corner).
- 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.
Relational Entity Architecture#
SmartERP Healthcare connects patient master data, clinical encounters, diagnostic requests, and fiscal accounting models into an ACID-compliant PostgreSQL schema:

Core Model Specifications#
1. Patient Master: medical.patient#
Maintains demographic and master index records:
name(Char): Full patient name.mrn(Char, unique, index): Master Record Number (CL-YYYY-NNNNNN).dob(Date): Date of birth.gender(Selection):male,female,other.national_id(Char, index): Ethiopian National ID / Kebele card number.partner_id(Many2one->res.partner): Financial accounting entity.blood_group(Selection):A+,A-,B+,B-,AB+,AB-,O+,O-.allergy_ids(Many2many->medical.allergy): Flagged active clinical allergies.
2. Clinical Encounter: medical.encounter#
Represents outpatient visits, emergency episodes, and admissions:
patient_id(Many2one->medical.patient, ondelete="cascade").encounter_type(Selection):opd,emergency,inpatient,teleconsult.doctor_id(Many2one->res.users): Attending physician.triage_id(Many2one->medical.triage): Linked triage assessment.state(Selection):draft,triage,consultation,diagnostics,billing,done,cancelled.diagnosis_ids(One2many->medical.diagnosis.line): ICD-10 diagnostic lines.
3. Triage & Vitals: medical.triage#
Captures physiological observations and acuity:
systolic_bp(Integer),diastolic_bp(Integer).heart_rate(Integer),respiratory_rate(Integer).temperature(Float),spo2(Float).weight(Float),height(Float),bmi(Float, computed).triage_zone(Selection):red,orange,yellow,green,blue.news2_score(Integer, computed).
4. Prescription & Medication: medical.prescription.order#
Drives pharmacy fulfillment and lot tracking:
encounter_id(Many2one->medical.encounter).line_ids(One2many->medical.prescription.line):product_id(Many2one->product.product): Pharmaceutical product.dose(Float),uom_id(Many2one->uom.uom).frequency_id(Many2one->medical.dosage.frequency).duration_days(Integer).lot_id(Many2one->stock.lot): FEFO picked batch.state(Selection):draft,prescribed,dispensed,cancelled.
5. Insurance & EHIS Claims: medical.insurance.claim#
Manages health insurance claims reconciliation:
patient_id(Many2one->medical.patient).insurance_partner_id(Many2one->res.partner): EHIS or Corporate Insurer.claim_batch_id(Many2one->medical.claim.batch).total_claimed_amount(Monetary),co_pay_amount(Monetary).approved_amount(Monetary),deducted_amount(Monetary).state(Selection):draft,submitted,approved,partially_paid,rejected,reconciled.
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 summariesPharmacy: 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 / Exception | Probable Root Cause | Corrective Action / Resolution |
|---|---|---|
Access Block: Confidential clinical diagnosis restricted | User 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 expired | Patient 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 blocked | Dispenser selected medicine lot past statutory EFDA expiry date. | Isolate expired lot to quarantine storage and dispense compliant active lot. |