There was a warrant issued that meant I was going to be involuntarily committed for 30 days. Thankfully I showed up at my pdocs office and showed I wasn’t a danger to myself or others so they didn’t see a hospitalization necessary.
The police know what you’ve been charged with and not convicted, that sticks with you forever. A criminal background check for employment won’t turn up anything that isn’t a conviction, however.