Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

How to get Dependents details for a plan code enrolled by a Employee?

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Sampath S
Basic Member
Posts: 17
Basic Member
10/24/2011 10:34 AM
    Hi All,

    I am trying to get the dependents details(batch pgm) who are all enrolled by a Employee into some new Plan codes under the Health Plan type.  I am usingBENEFIT---> EMPLOYEE-->EMDEPEND table to get dependents details attached to a plan-code.By using EMD-HL-COV-FLAG  = "Y" i am easily able get all the dependents(spouse and child) details. But our Benefit user is saying this flag might not be consistent and she is asking for any other way to get the dependents details.
    This looks to be true aswell for some of employee's this flag works and for someother it will select dependents even thoe employee doesn't select/opt them for a perticular plan code.

     
    Can you suggest me how get depenedents details who are enrolled by employee for a perticular plan codes and plan types.


    Any suggestions will be greatly appreciated!!!

    Thanks& Regards
    Sam
    Margie Gyurisin
    Veteran Member
    Posts: 538
    Veteran Member
    10/24/2011 11:16 AM
      Have you tried running the Lawson report BN321 as an alternative to creating a separate report? Otherwise, you probably need the table HRDEPBEN.
      Paul Berkowitz
      Basic Member
      Posts: 14
      Basic Member
      10/24/2011 11:20 AM
        Hi Sam,

        The dependent enrollments are in HRDEPBEN,  the relationship is employee number and SEQ_NBR = N.DEPENDENT. and stop_date = 1/1/1700

        Let me know if you need more information

        from LAWSON9.EMDEPEND M
        JOIN LAWSON9.HRDEPBEN N
        ON M.EMPLOYEE = N.EMPLOYEE AND M.SEQ_NBR = N.DEPENDENT
        JOIN  lawson9.employee O
        ON N.EMPLOYEE = O.EMPLOYEE
        join lawson9.employee q
        on q.employee = m.employee and q.company = m.company