00 — Background: KPI Matrix Module

Document: 00_BACKGROUND.md Module: KPI Matrix (Employee Performance Management) Author: AI Research Agent Date: February 2026 Status: Implemented — original research/rationale retained for context (the module is now built; see README)

1. Project Brief

The KPI Matrix module introduces a structured employee performance management system into ERPat. It automatically collects, calculates, and presents Key Performance Indicators (KPIs) for every employee by leveraging operational data already captured across 12+ existing modules.

Core Principle: ERPat already collects the raw data — attendance logs, task completions, ticket resolutions, timesheet hours, disciplinary records, leave usage, certifications, and skillsets. The KPI Matrix transforms this scattered operational data into a unified, quantifiable performance score that supports:

• Objective employee evaluations (removing subjective bias)
• Automated salary grade step advancement recommendations
• Department-level performance analytics
• Data-driven promotion and development decisions
• Regulatory compliance for performance-based compensation changes

2. Problem Statement

2.1 Current Gaps

ERPat currently has no unified mechanism to evaluate employee performance across modules. Managers must:

1. Manual data gathering — To evaluate an employee, a manager must manually check attendance records, review task completion, look at disciplinary history, check leave patterns, and verify certifications across 6+ separate screens. This process takes 30-60 minutes per employee.

2. No quantified scoring — There is no standardized scoring system. Two managers evaluating the same employee may arrive at different conclusions because there are no defined metrics, weights, or thresholds.

3. Disconnected salary decisions — Salary grade step progression (via salary_grades and salary_history) has no data-driven input. Salary increases are based on tenure or subjective manager assessment, not on measurable performance data.

4. No historical trending — There is no way to track an employee's performance trajectory over time. Without period-over-period comparison, it's impossible to identify improving or declining performance trends.

5. Department-level blindness — Organizational leaders cannot compare department performance, identify high-performing teams, or spot departments that need intervention.

6. No target-setting framework — There are no mechanisms to set performance targets (expected values) and measure actuals against them. Without targets, KPI values are just numbers with no context.

7. Audit trail gaps — Performance evaluations that lead to salary decisions lack a formal audit trail linking "this employee scored X on these metrics, therefore they qualify for Y salary step advancement."

2.2 Impact of Gaps

3. Objectives

3.1 Primary Objectives

1. Automated KPI Calculation — Build a computation engine that automatically pulls data from existing modules (attendance, tasks, tickets, timesheets, discipline, leaves, certifications, skillsets) and calculates standardized KPI scores per employee per evaluation period.

2. Configurable KPI Templates — Allow administrators to define KPI templates with customizable categories, metrics, weights, scoring scales, and target values. Different departments or job roles may have different KPI templates.

3. Salary Progression Integration — Link KPI scores to the salary grade step system so that employees who meet or exceed performance targets are automatically recommended for step advancement. This creates a traceable, data-driven path from performance to compensation.

4. Multi-Level Dashboards — Provide performance visibility at three levels:

   • Employee level: Personal KPI card with scores, trends, targets
   • Department level: Team matrix showing all members' scores
   • Organization level: Cross-department analytics and executive summary

5. Review Cycle Management — Support formal review cycles (monthly, quarterly, semi-annual, annual) with manager review, employee acknowledgment, and HR approval workflow.

6. Historical Tracking & Trending — Store calculated KPI scores per period to enable period-over-period comparison, trend analysis, and long-term performance trajectory visualization.

3.2 Secondary Objectives

1. Target Management — Allow setting of individual, department, or role-based targets for each KPI metric. Actuals are measured against these targets to produce context-aware scores.

2. Automated Alerts — Notify managers when employees fall below minimum thresholds or when KPI trends indicate declining performance.

3. Integration with Existing Profile Tab — Add a "KPI" tab to the Team Members profile page (following the existing tab architecture) showing individual performance data.

4. Report Generation — Generate printable/exportable KPI reports for HR records, salary review committees, and regulatory compliance.

5. Timeline Integration — Add KPI-related activities to the system logs and timeline feeds for audit purposes.

6. Future-Proofing — Design the schema and engine to accommodate future KPI types (customer satisfaction scores, revenue metrics, custom formula-based metrics) without schema changes.

4. Scope

4.1 In Scope

4.2 Out of Scope (Future Phases)

4.3 Dependencies

5. Stakeholders

6. Success Criteria

7. Terminology