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

SQL Help! - Get quarterly employee payroll results by using Querterly dimension name

edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 3 comments

Summary

I am getting one row for each payroll by using the following SQL. Please help what I am missing.

Content

with gross_pay as (SELECT SSN, PERSON_NAME,balance_name, CASE WHEN TO_CHAR(:pEndDate, 'MM') in ('01', '02', '03') THEN '1'||TO_CHAR(:pEndDate, 'YY')
         WHEN TO_CHAR(:pEndDate, 'MM') in ('04', '05', '06') THEN '2'||TO_CHAR(:pEndDate, 'YY')
         WHEN TO_CHAR(:pEndDate, 'MM') in ('07', '08', '09') THEN '3'||TO_CHAR(:pEndDate, 'YY')
         WHEN TO_CHAR(:pEndDate, 'MM') in ('10', '11', '12') THEN '4'||TO_CHAR(:pEndDate, 'YY')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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