M_HEALTH_DEPEN query

posted Jun 7, 2016, 11:28 AM by Peyri Herrera
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:
M_HEALTH_DEPEN