Not an LEO but work at an Agency (and stayed at a Holiday Inn last night)
I don't know the exact process for it, but I'm fairly certain the DA's office is immediately notified and the LEO is placed on a list (forget the name of it, but it is significant in that all the busts are now suspect).
As for the LEO, I can only speak for my organization (in central Colorado), there would be an IA investigation probably beginning within a day. Once completed that LEO would be bounced, I've seen it happen several times.
One of the easiest ways out the door here is violating the "Departure from the Truth" policy.