in my experience, after a failed or aborted attempt (depending on the severity of the situation), you first end up with physical medical intervention and monitoring in emergency (or sometimes icu). after you are stable they will send a social worker and eventually a psychiatrist to speak to you, you most likely will be admitted to inpatient in the same hospital, or, due to a lack of beds, you will be transferred elsewhere. there you will be put on a 72-hour hold, where you receive crisis-intervention care, you're deemed a danger to yourself so you have to be monitored (again this depends on the severity of the situation). after this you join basically the "general population" of the psychiatric unit, where you are to participate in group therapy, individual therapy/psychiatry, and receive medication prescriptions. there is also leisure time, spent individually (reading, drawing, or writing in your room) and as a group (movie and tv time, snack time, playing board games-- in my youth rehab unit we had a cooking group once a week). once you are deemed stable, doctors may see you eligible for passes where you can go off the unit, however, if you try and run away before discharge they will come to look for you, so don't bother with that it's totally pointless to try. passes are tests in a way to see if you are stable enough for discharge. when passes start to come, you know you're getting out soon, so fucking them up just means more time inside. once you are ready for discharge you are given options for referrals to therapists and outpatient support programs. this whole process can take from 1 week-multiple months depending on the severity of the situation, and your honesty.
some facilities are good, and some are quite bad. it can be bad because of patients and/or staff.
one edit: during 72-hour hold is where you receive the most intensive psychiatric care. this is where they assess your needs out of the inpatient program.