Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ttrsnoob

    Display Manaagers EMPLID for each employee

    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 (...
  2. ttrsnoob

    2 Outer Joins - Is it possible?

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

    derived field to pull check gross in range of dates

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

    derived field to pull check gross in range of dates

    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?
  5. ttrsnoob

    derived field to pull check gross in range of dates

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

    derived field to pull check gross in range of dates

    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 ) ?
  7. ttrsnoob

    Pull active employee jobcode from dept unless

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

    ORA-00937: not a single-group group function

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

    ORA-00937: not a single-group group function

    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(...
  10. ttrsnoob

    Derived Fields to pull total hours for different months

    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 ) ) ) +...
  11. ttrsnoob

    Derived Fields to pull total hours for different months

    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

Part and Inventory Search

Back
Top