Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How can I pull the same Calculation Components that I see on the Tax Withholding screen in a report? — Cloud Customer Connect
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

How can I pull the same Calculation Components that I see on the Tax Withholding screen in a report?

Received Response
32
Views
5
Comments

Summary:

I am in the process of creating a report to pull Tax Withholding card information for US employees. I need help in figuring out how I can pull the same calculation components that Oracle's Tax Withholding cards are showing on the front-end. I found a field called COMPONENT_NAME in the PAY_DIR_CARD_COMP_DEFS_VL table, but there appear to be duplicates for several calculation components.

Content (required):

In the below snip-it, which I pulled from PAY_DIR_CARD_COMP_DEFS_VL, there are three records for city component names, three for county component names, three for federal component names, and two for state component names. When I look at tax withholding cards on the front-end, it looks like the ones that I put in green font are being used (City Taxes, County Taxes, Federal Taxes, and State Taxes). However, in the below table, all of the rows have the same EFFECTIVE_END_DATE, so I don't know how to exclude the ones that aren't being used without hard-coding them in my data

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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