Agree with Palum and Khane. Below is one way, assuming you only want one record per employee across any number of nom_day_key (and assuming mod_dt is unique within an employee_key):
select
a.nom_day_key,
a.employee_key,
a.local_start_dt,
a.local_end_dt,
a.mod_dt
from...