SmartERP Documentation An Ashewa Technology Solutions Platform

Data model

Complete data dictionary of all HR and payroll models, key fields, relational constraints, and database indexes.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Data model within SmartERP.

Entity relationship diagram of SmartERP HR and Payroll data models.
Relational architecture of HR and Payroll data models.

HR and Payroll Relational Data Model Schema

This page is the technical data dictionary for SmartERP Human Resources & Payroll models.

Entity relationship diagram of SmartERP HR and Payroll data models.
Relational architecture of HR and Payroll data models.

2. Prerequisites & Security Access Groups#

  • Required Modules: hr, hr_payroll, hr_holidays, smarterp_ethiopian_payroll
  • Security Groups:
    • Officer: Manage all employees (Technical ID: hr.group_hr_user)
    • Payroll Officer (Technical ID: hr_payroll.group_hr_payroll_user)
    • HR Administrator (Technical ID: hr.group_hr_manager)
  • Master Data Dependencies: Company departments, job positions, salary structures, 7-tier Ethiopian income tax brackets, POESSA/PSSPA pension rates, and employee contracts.

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 Settings → Technical → Database Structure → Models.

HR and Payroll Relational Data Model Schema

Step 2: Workforce Data Parameters & Statutory Controls#

Ensure all personnel and compensation records adhere to statutory labor regulations:

  • Designated Authority / Role: Operation authorized under verified RBAC role (Database Administrator, Backend Developer).
  • Employee Master & Contract Binding: Linked to active employee profile, verified TIN, and active employment contract.
  • Statutory Labor & Pension Validation: Compliant with Ethiopian Labour Proclamation No. 1156/2019, POESSA Pension Proclamation No. 1268/2022 (11% employer / 7% employee), and Income Tax Proclamation No. 979/2016.

Step 3: Operational Execution & State Progression#

  • State Progression Gate: Advance record from Draft through Reviewed to Confirmed / Certified.
  • Integrated Workforce Impact: Synchronizes attendance hours, adjusts leave entitlement balances, and feeds gross-to-net payroll journal disbursements (account.move).
  • Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.

Core models#

hr.employee (Employee Master)#

Field NameTypeDescription
nameCharFull legal name.
tin_numberChar10-digit Tax Identification Number.
pension_numberCharPOESSA pension identifier.
department_idMany2oneRelational pointer to hr.department.
job_idMany2oneRelational pointer to hr.job.
grade_idMany2oneRelational pointer to hr.grade.

hr.contract (Employment Contract)#

Field NameTypeDescription
nameCharContract reference code.
employee_idMany2oneEmployee record.
wageMonetaryMonthly basic wage in ETB.
stateSelectiondraft, running, close, cancel.
struct_idMany2oneSalary structure pointer.

hr.payslip (Computed Payslip)#

Field NameTypeDescription
numberCharSequential payslip number.
employee_idMany2oneEmployee pointer.
date_fromDateStart date of salary period.
date_toDateEnd date of salary period.
line_idsOne2manyComputed salary rule lines (hr.payslip.line).

4. Advanced Configuration Points#

  • Automated Actions & Scheduled Tasks (Crons):
    • HR: Compute scheduled leave accruals (hr_holidays.ir_cron_leave_accruals): Runs bi-weekly to accrue annual leave balances per Ethiopian labor law
    • Payroll: Auto-generate monthly payslip batches (hr_payroll.ir_cron_generate_payslips): Runs on the 25th of each calendar month
    • Attendance: Validate biometric clock-in logs (hr_attendance.ir_cron_sync_attendance): Runs hourly to sync biometric terminal events
  • Custom Print Templates & Reports:
    • Official Ethiopian Monthly Payslip
    • POESSA / PSSPA Statutory Pension Contribution Schedule
    • MOR Employment Income Tax (PAYE) Monthly Summary
    • Employee Service & Severance Certificate
  • 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 Rights Error: Employee private data hiddenUser lacks HR Officer security clearance.Assign the user to hr.group_hr_user under Settings → Users & Companies.
Computation Error: Missing contract or salary structureEmployee has no active contract in 'running' state.Confirm contract terms under Employees → Contracts and ensure contract status is 'Running'.
Validation Error: Leave allocation exhaustedRequested time off exceeds accrued balance under Ethiopian Labor Proclamation 1156/2019.Review historical attendance and submit a formal allocation adjustment request.
Payroll Blocked: Unlinked TIN or Pension numberStatutory rule requires mandatory tax and pension coordinates for payslip calculation.Update the statutory tab on the employee profile with valid MOR and POESSA registration details.

Next#

Last updated: 2026-11-15