W4 Calculation Card Filing Status Details not found in backend tables
We are facing challenge with extracting the W4 tax witholding calculation card details for some of our employees via back-end tables. In the front end, we are able to see federal components of a bunch of employees starting 17 Dec 2023 with a particular filing status, however the same is not reflecting in the back end tables when we are trying to query that, we are getting the older dates with that particular status while querying the PAY_RANGE_ITEMS_F table.
Some background we went through a Mass LE transfer process recently effective 12/17. We are looking to validate W4 Federal Filing Status before and after for any changes. In the front end we see 12/17 rows for employees (for all who were in Mass LE txr) and in the SQL we dont see 12/17 rows and the filing status is not accurate