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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Latest Tax not Pulling through Subquery Results

edited Oct 19, 2022 12:41PM in Reporting and Analytics for HCM 2 comments

Summary:

Latest Tax not Pulling through Subquery Results

Content (required):

The sub query set up correctly pulls back latest tax code effective start date in a calculated column as below:

MAX("Calculation Component Details"."Calculation Component Details Effective Start Date" BY "Worker"."Person Number")

The sub query report also includes the Person Number, First Name and Last Name from the Payroll - Calculation Cards Real Time subject area.

However there is a another report that I've linked to the sub query via Person Number and the calculated Latest Tax Start Date columns which includes the Tax Code , Tax Basis as well as Person Number, First Name, Last Name and Effective Start Date, but this is bringing back all the tax codes an employee has had. This report uses the same subject areas.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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