There are situations where the only entry point is a payroll code. In this case, the need was to find a sample ID for a selection of codes. Once we have the codes, it becomes possible to identify the associated triggering rules.

It was worth taking a few minutes to try and find an SQL query that does the job…

Queries that helped me when the payroll was crashing, or simply extracting the dictionary for one of the RBM / NRB loading tools lingering in the HRA ecosystem.

Understanding a payslip often involves asking the question, ‘But why did this thing trigger?’

A medley of SQL about employees to assist, for instance, during tests.

SQL to extract the list of transport organizing authorities (AOM in french), and the associated configuration in the ZD7H information.

All data being generated by HR Access, a good old SQL allows identifying the source of discrepancies between the DSN and accounting.