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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Calculation cards query questions

in Payroll and Global Payroll Interface (GPI) 17 comments

I’ve reviewed the calculation cards query questions on Customer Connect (very helpful) with a few additional questions about querying calculation card data. My SQL attached if helpful.

1) How do we query the Cumulative Taxation field for calc card associations?

2) What is the best source for determining start and end dates for federal and regional components? Need history as well as current. I see these dates in the PAY_RANGE_ITEMS_F table but it doesn’t seem like that would be the source.

3) Best way to consistently query Calculation Component name like Federal Taxes, Retiree Federal Tax, Retiree Reporting Information, etc. Looks like PAY_DIR_CARD_COMP_DEFS_VL.COMPONENT_NAME is a good source which I’ve tried to join with PAY_DIR_CARD_COMPONENTS_F.DIR_CARD_COMP_DEF_ID but results are inconsistent

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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