Recent content by NOLA

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' ) )

Thanks Charles. It worked.

Charles, I also tried the code listed below and still receiving only 5. CASE when trunc((SYSDATE - "PS_PERSONAL_DATA"."BIRTHDATE")) < 5 then 1 when trunc((SYSDATE - "PS_PERSONAL_DATA"."BIRTHDATE")) < 10 then 2 when trunc((SYSDATE - "PS_PERSONAL_DATA"."BIRTHDATE")) < 15 then 3 when...

Charles, I am trying to get a headcount but when I use the logic listed below it only returns 5. CASE WHEN (SYSDATE - BIRTHDATE) BETWEEN 0 AND 29 THEN 1 WHEN (SYSDATE - BIRTHDATE) BETWEEN 30 AND 39 THEN 2 WHEN (SYSDATE - BIRTHDATE) BETWEEN 40 AND 49 THEN 3 WHEN (SYSDATE - BIRTHDATE)...

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....

Anytime you have a aggregate derived field you need to select database grouping.

Before I only had CEIL then I added sum AND FOLLOWING MESSAGE APPEARS ORA-00979: not a GROUP BY expression SUM (CEIL ("MEMO"."AL_AMOUNT" * case when trunc(((SYSDATE - "PERS"."ORIG_HIRE_DT") / 365.25)) < 5 then .03 when trunc(((SYSDATE - "PERS"."ORIG_HIRE_DT") / 365.25)) = 5 then 0.04 when...

When I added sum to the derived field I am now receiving the following error message. ORA-00979: not a GROUP BY expression What causes this?

Thank you for your help, but I am receiving error message ORA-00907 missing right parenthesis on the following code. when ((trunc(((SYSDATE - "PERS"."ORIG_HIRE_DT") / 365.25)) >=5) AND (trunc(((SYSDATE - "PERS"."ORIG_HIRE_DT") / 365.25) < 10)) then 0.04

The following is not working. When I add the comparison >=5 and <10 and also need to multiply the percent * amount. What is the correct syntax in doing this? case when trunc(((SYSDATE - "PERS"."ORIG_HIRE_DT") / 365.25)) < 5 then 0.03 when trunc(((SYSDATE - "PERS"."ORIG_HIRE_DT") / 365.25))...

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...

You need to create a derived field as listed below. (TO_CHAR(SYSDATE,'YYYY')) - TO_CHAR("PS_PERSONAL_DATA"."BIRTHDATE",'YYYY') Then in your selection criteria please select the following for a single age seletion derived field YY is equal to number 12 or for mulitple age...