July 26, 2023

Python: Time and Datetime Libraries

Self-learning Python: using Yahoo Finance to extract stock quotes data, the purpose of this exchange with ChatGPT is to alert when the fiscal year is not standard, with formatting that grabs attention.

March 25, 2023

Quick solution, problems to come.

In a hurry, one set up a dedicaded payroll item and…

August 24, 2022

Some queries to help the DevOp

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.

August 24, 2022

SQL to list rule system codes that trigger pay items

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

August 24, 2022

SQL to work on employees

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

August 24, 2022

ZDDFA The List of AOTs and Associated Transport Payment

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

December 18, 2020

Closing the gap between accounting and the DSN

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