Aligning PRDB Data and Rules System's items

• HR Access
• Technical White Book

The purpose of this feature is to achieve the following result:

Indeed, the HR Access payroll inspector displays the valued items. While it explains the final result, it does not show the possible alternatives, the ones that are expected… The attentive reader will object that the screenshot does not show any non-valued elements: they are right; due to the lack of access to an HR Access environment at the time of writing this article, it will have to wait…

Here, it is necessary to recall that the LBT is not a connected tool. Therefore, the PRDB data needs to be retrieved.

This is done using an SQL query, generated by the LBT for each upstream analysis:

At this stage of the feature development, this query should only extract data for a single employee.

Then, after initializing a dedicated tab, the PRDB data is copied/pasted from the database into the LBT. The final step is to launch the reconciliation: although the operation may seem a bit tedious, it still saves time!