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
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.