Employee record & Change Notice

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
mil0n023
Veteran Member
Posts: 63
Veteran Member
    recently we applied CTP 45859 (Program PA702) which transitioned our PAEMPLOYEE.NEXT_REVIEW_DTE to the Table REVIEW. PA702 runs and updates the REVIEW table with the PAEMPLOYEE info. The problem I am having now, is the report mentioned above - I had to incorparate the REVIEW table, delete the PAEMPLOYEE.Next_Review_DTE field, and put in place REVIEW.NEXT_REVIEW_DTE. We still use PAEMPLOYEE for Hm Phone, Gender, and Birthdate. Below are the tables I am linking in the report:

    (("EMPLOYEE"."EMPLOYEE"="PAEMPPOS"."EMPLOYEE") AND ("EMPLOYEE"."COMPANY"="PAEMPPOS"."COMPANY")) AND (("EMPLOYEE"."EMPLOYEE"="PAEMPLOYEE"."EMPLOYEE") AND ("EMPLOYEE"."COMPANY"="PAEMPLOYEE"."COMPANY")) AND (("EMPLOYEE"."COMPANY"="REVIEW"."COMPANY") AND ("EMPLOYEE"."EMPLOYEE"="REVIEW"."EMPLOYEE")) AND (("PAEMPPOS"."COMPANY"="JOBCODE"."COMPANY") AND ("PAEMPPOS"."JOB_CODE"="JOBCODE"."JOB_CODE"))

    All inner joined. I have a details A, and details b. The Details b area has all the PAEMPPOS data, and this is now duplicating! I have tried numerous typese of linking, and arranging, but can't stop the duplication...Any ideas?????
    M. C. Miller
    Analyst
    Salem, Oregon
    John Henley
    Posts: 3353
      Without seeing the report, my assumption would be that you have multiple REVIEW or PAEMPPOS records for each employee. You'd have to figure out which of them is the most recent, and suppress all the others...
      Thanks for using the LawsonGuru.com forums!
      John