📋 Track Absence and Spot the Pattern

Absence is recorded inconsistently and I only notice a problem once it is serious. Build me an absence app. Record every absence with the person, the dates, the type such as sickness, unplanned, appointment or other, the working days lost, and whether it was notified in advance. Restrict any health information to named people who need it. Prompt a return to work conversation on every absence, with a short structured record of what was discussed and any support agreed. Calculate absence by frequency of separate occurrences as well as total days, since frequency is the more useful signal. Show patterns by person, team, day of week and time of year. Add an AI agent that reviews the records and flags where a pattern suggests someone would benefit from a supportive conversation, framing it as support rather than suspicion, and tells me which teams have absence well above the rest and whether it clusters around particular periods. Automate three things: a prompt for a return conversation when someone comes back, an alert to a manager when a trigger point I set is reached, and a scheduled monthly absence summary. Two logins: a manager who sees their own team, and an owner who sees the organisation.