The M_HEALTH_DEPEN - EE Health Dependent query was created to replace an older query called “M_HELTH_DEPEN” which had major performance issues (and a spelling error). We also added columns for Employee’s Name and Dependent’s Name. This query includes the following fields: Company, ID, Empl Record, Employee's Name, HR Status, CBR Evt ID, Plan Typ, Eff Date, Dep/Benef, Dependent's Name, Type, Provider ID, Eff Date, Covg Bgn, Covg End, Covrg Elec, Plan, Coverage Cd, and Descr.
Sample:
![]() |
Announcements > PeopleSoft Announcements >