Need to left join pgm incase there are some records with null status