• Search Forums
    Advanced Search
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
 69 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
New Member
Posts: 0
New 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
New Poster
New Poster
Congrats on posting!
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