You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need a report to extract TaxWithholding Card and it's component details

in Payroll and Global Payroll Interface (GPI)

Summary:

I attempted to use the query shown below, and while it works for some records, newly added records are not appearing, and some of the date values don’t match correctly.

I’ve read that the underlying architecture for these tables has changed. Does anyone have suggestions or guidance on how to correctly build this report under the new structure?

SELECT
PPRD.PAYROLL_RELATIONSHIP_NUMBER,
PDCD.BASE_DISPLAY_NAME Card_Name,
TO_CHAR(PDCF.DIR_CARD_ID) DIR_CARD_ID,
PDCF.CARD_SEQUENCE,
TO_CHAR(PDCF.EFFECTIVE_START_DATE, 'YYYY-MM-DD') Card_Start_Date,
TO_CHAR(PDCF.EFFECTIVE_END_DATE, 'YYYY-MM-DD') Card_End_Date,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!