Search results for query: *

I have a number of departments. In each department I have a manager. What I am looking for is a report to list each of the employees in that department with the managers ID after each employee. This is what I am trying (SELECT ("B"."EMPLID") FROM "PS_JOB" "B" WHERE (...

Can't you add a 3rd PERSONAL_DATA table and link PS_EMP_REVIEW_RVWR.REVIEWER_ID to PS_PERSONAL_DATA(3).EMPLID This is just a guess right now - let me know if it works

May I refer to you as Master Yoda from now on? THANK YOU - you rock!!!!!

ok that works perfectly to grab the total of all the checks. How do I limit it to a range of checks? for example just the checks from this year?

Thanks Charles - This is what I put together. When I test it - it says derived field ok but when I go to run the report it says SQL command not properly ended. I know you said you would not be able to debug it or test it but is there anyone else reading this who might venture a guess? Thanks...

Nevermind I figured it out =)

Is it possible to write a derived field that will pull a range of checks and give the check gross? something like... DECODE ( CHECK DATE , CHECK DATE RANGE , CHECK GROSS ) ?

I am trying to pull a report that will show all DEPTIDs between '000100' and '009000'. I need the report to then pull the active employee's EMPLID with JOBCODE 12104 (there will only be 1 employee with that jobcode) If there are only terminated employees with jobcode 12104 I still want the...

I have 1 Derived Field to pull the "benefit plan" I have 1 Derived Field to pull the "coverage plan" and I have 1 Derived Field to pull "dependants". If there is a "dependant" I want the "benefit plan" to pull over only if the "coverage plan" applies. If an employee has family coverage (4) I...

DECODE("PS_DEPENDENT_BENEF"."DEPENDENT_BENEF",'02',( DECODE((MAX(DECODE("PS_HEALTH_BENEFIT"."PLAN_TYPE",'10' ,"PS_HEALTH_BENEFIT"."COVRG_CD" ) )),'4', (MAX( DECODE("PS_HEALTH_BENEFIT"."PLAN_TYPE",'10' , "PS_HEALTH_BENEFIT"."BENEFIT_PLAN") )) ,'5', (MAX(...

THANKS!

Here is what I was trying SELECT ((SUM( DECODE("PS_AL_CHK_HRS_ERN"."ROW_NBR",'2',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) )) + (SUM( DECODE("PS_AL_CHK_HRS_ERN"."ROW_NBR",'1',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) )) + ( SUM( DECODE("PS_AL_CHK_HRS_ERN"."ERNCD",'H',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) ) ) +...

I would like to put together a report that pulls total hours. I would need one dirived field for January and another field for February. Any ideas how I can do this? Thanks