SQL Query - Absence entries to Payroll Calculation Card

SQL Query - Absence entries to Payroll Calculation Card:

This query can be helpful for all users to validate that recent all absence hours are properly synced with the Payroll Calculation Card.

Using this, you can also verify absence entries, absence accruals, and absence payment hours.

Happy Learning !

SELECT *

FROM (

SELECT DISTINCT

pdcd.display_name,

pdccd.component_name,

vdl.name              AS "Display Value",

pdcc.context_value1   AS "Reference",

pri.value1            AS "Value",

TO_CHAR(pri.effective_start_date, 'YYYY/MM/DD') AS "Effective Start Date",

TO_CHAR(pri.effective_end_date, 'YYYY/MM/DD')   AS "Effective End Date",

papf.person_number,