Checking if Parent ID has corresponding child IDs

Hi Asking for your help how can I tag the rows based on a condition.   I want to tag the row as "Yes" if the Parent ID has Child IDs  under it. So for example BOP23-016 in ID Level 1 has sub IDs i...