Popped hot, police job in danger?

A soldier of mine popped hot for THC-8, the chapter counseling included verbiage that the incident was going to be put into FBI NICS system. Soldier is a police officer and is really stressed about this possibly ending his civilian career. Does anyone have any experience with this?

Essentially, our state allows for police officers to smoke weed while off duty, so something that should only be affecting his military career may end up costing him his civilian career for something he’s allowed to do at his civilian job. It’s a gray area in terms of federal law vs state law.

I wouldn’t be on here asking if this guy was an idiot, this is a far exceeds soldier that had one bad month, but what’s done is done. I’m literally just asking about how the NICS may affect his job given the weird circumstance. All of these “der he dumb for doing that” comments don’t mean anything at this point.