Multi Skill Expiry Date Check

for each skill:
  base = skill.expiry_date
  if skill.recurrence:
    while base < today:
      base = addYears(base, skill.recurrence)
  days_left = dateDiff(today, base, user.timezone)
  status = (base < today) ? "overdue" : (days_left <= window ? "expiring_soon" : "valid")

Each skill record must contain:

| Field | Example | |-------|---------| | Employee ID | E-1024 | | Employee Name | Jane Smith | | Skill/Certification Name | CPR, Forklift Operation, PMP, Scrum Master | | Issue Date | 2023-05-10 | | Expiry Date | 2025-05-09 | | Reminder Threshold (days) | 30, 60, 90 | | Renewal Required (Yes/No) | Yes | | Grace Period Allowed (days) | 0 | | Document Reference | cert_CPR_1024.pdf | | Status | Active / Expiring / Expired | multi skill expiry date check

A Multi-Skill Expiry Date Check is not merely an administrative task — it is a risk control mechanism. Organizations that implement proactive expiry tracking reduce compliance violations, improve safety, and avoid sudden skill gaps. The recommended approach combines structured data, automated alerts, and role-based dashboards. for each skill: base = skill

Prepared by: [Your Name / Department]
Next review date: [6 months from today]
Appendix: Sample SQL/Python script for expiry calculation attached upon request. Each skill record must contain: | Field |

Recommended KPIs:

| Metric | Formula | |--------|---------| | Skill compliance rate | (Active skills / Total required skills) × 100 | | Expiring in 30 days | Count of skills with 1–30 days left | | Expired skills by department | Group by department | | Renewal lead time avg | Avg (Renewal date - Expiry date) for renewed skills |

For each skill, expiry date = acquisition date + validity period – adjustments (e.g., early renewal). The engine must handle:

Back
Top