Two things I've always wondered about The Sixth Sense (1999)

I don't think he was assigned, I think he was drawn to Cole's energy or whatever. Cole says something about how the ghosts are attracted to him, ad they don't even realize they're ghosts. One of those lines that really sticks out on rewatch.

Cole definitely knows he's a ghost.