You will be labelled as a troublemaker. That college hire will be in trouble as well (not for what he did, but because he has made the company vulnerable to action), but your record will be marked (almost certainly not literally; they're not stupid enough to outright leave actionable evidence like that).
However, if your manager did something inappropriate in private then whose side do you think HR will take?