data scrutinized to control insurance costs

To control the cost of their statutory insurance, local authorities know that containing absenteeism is one of the existing tools. Most have internal prevention policies in place. With more or less success. Why ? The lack of ambition of the means implemented, poorly orchestrated coordination of actors or poor targeting of actions. Now, it is on this subject that statistics can really help. Some have understood this well, like the Seine-et-Marne management center (750 communities, 30,000 agents) which points out the preventive actions to be carried out through statistical management.

Broker help

The steering has been carried out since 2016 with the help of the CDG insurance broker, Sofaxis. “Each quarter, we look at the results of the contract. We study the figures of absenteeism which persists, stoppages for work accidents of more than ninety days which have not given rise to an expert report. We look at the evolution of the contract according to the communities, with figures which help us to identify finely those where problems remain”, details Christel Thomas, manager of the service “social protection, group insurance and retirement” of the CDG.

The study of figures sometimes allows very targeted actions. As in this town which multiplied the stops linked to repeated falls. In question ? The too waxed stairs of the town hall! In order to further control this data, the CDG has an application on the absence entry platform. “Entitled “My Datamanagement Service”, it stems from the establishment of the steering committee and allows us to control the summary data of our group contract with better monitoring of files and anticipation in the procedures to be put in place”, relates Christel Thomas.

Although this follow-up, in conjunction with the insurer, did not lower the cost of the contracts, it made it possible to regulate price increases in specifications up to a maximum of 5% per year. But for Ludovic de Mornac, director of Alcega Conseil, a specialist in auditing and insurance risk management, this remains insufficient: “There is a challenge for local authorities to control their data internally and to go more in detail to extract their own work stoppage dashboards and assess what it is costing them. »

Decision portal

This is what the Ille-et-Vilaine departmental council worked on for two years with the creation of its own indicators and statistical data. “We had our absenteeism calculation method validated by an external statistician. This includes taking into account absences for health reasons and accidents at work,” explains Céline Pellerin, in charge of cross-functional projects in the HR department.

To do this, the department finalized, at the end of 2021, a decision-making portal. Called “DigDash”, this secure data warehouse provides access to dashboards summarizing absenteeism indicators, department by department. Anonymized, these data relate to four years of exercise with the possibility of making a comparison year by year. A manipulation that required the training of CD managers.

“We conducted two sessions on reading and interpreting this data for around 20 directors out of 50. The last training sessions will take place before the summer,” specifies Céline Pellerin.

“Indicators are warning points”

Alain David

“DigDash, the data warehouse, is secure and provides access to dashboards, department by department, with the highlighting of four key indicators: the average duration of downtime, the proportion of absent agents, the frequency stoppages – ratio between the number of stoppages in the year and the average duration – and the rate of absenteeism – ratio between the number of absent agents and the number of days of stoppage, explains Alain David, research officer, in the “audit” department of the Ille-et Vilaine department [4 250 agents]. These indicators are alert points on which managers have been trained. Everyone has access to the statistics of their department only and can filter by mission and by profession. Our goal is to enable them to further investigate possible problems in their department, to notify HR if necessary. It is a tool to better target prevention measures but also to invest managers more in this subject. »

Leave a Comment