As faculty, I've had to report academic misconduct (usually plagiarism) many times but that doesn't mean I know everything about how it works. My understanding has always been that the only people who know about the report are the faculty who reported the incident, the student being reported and the conduct officer or honor committee (depending on the institution) investigating the report. The student can certainly tell whoever they like but regardless of the outcome, everyone else is required to keep the information confidential.
But what happens if the result is dismissal (permanent separation from the university)? Is there typically any indication of this on the student's transcript? I've heard from colleagues that at some institutions, it will be indicated on the transcript but I'm not sure if that's correct. If the dismissal is indicated and the misconduct was especially serious, e.g., rape, is that fact also reported? What would it say?