The only reason you are worried about whether this will appear in a record check is because you don't plan on disclosing it when you apply.
1) With the recent alcohol problems it sounds like you have a problem with maturity as well as alcohol.
2) A background investigation will discover this stuff. If you failed to disclose it you will be disqualified from LE forever as a deceptive candidate.
For you to have any chance at all in LE you need to stop drinking so you can avoid getting in trouble. You are on a path that is incompatible with LE.
You will also need at least 3-5 years of no trouble at all to even be considered in an application process.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The beatings will continue until morale improves.