Search results for query: *

I'm trying to create a derived field that looks at salary ranges. For example if salary range is between 30000 and 40000 then '30-40' else if salary range is between 40000 and 50000 then '40-50' and so on.

How would you create a report that would list every Deduction code total on one row by employee?

Trying to extract employees that are not enrolled in ACH and not successful. Using PS_AL_DIR_DEP and PS_AL_DIR_DEP_DATA tables and selection criteria where dedcd is null. MAX(DISTINCT NVL("PS_AL_DIR_DEP_DATA"."DEDCD",'NULL' ) )

I am sucessful in listing employees paid on the 15th of each month with their gross wages, hours worked and earnings. They would also like to see the previous month's gross wages on the report. Please explain how I can include the previous month's earnings on the report that list the current...

I am trying to create a derive field that will sum employees with life insurance for a certain age range. For example Total life insurance for age range 00 - 29 or 30-39 etc....

I am trying to create a report that will calculate a field depending on years of service. I need to determine years of service first then calculate an amount for # of years. For example if an employee has less than 5 years then I need to calculate a field by 1% ELSE IF YEARS IS LT 10 YEARS...

I am trying to create a report that displays headcounts by company number in two groups. Group I consist of exempt employees in a particular company with salary GE 50000. Group II consist of exempt, non-exempt employees in a particular company with salary LT 50000. Example: Group 1 Salary GE...

I created a report that list employees with a certain accumulator and the amount, but one employee does not have this accumulator and I am trying to list this employee with zero values? Is this possible?