User Flags

Hi Everyone...... A simple question ? When one do a onstat -u you get all the users currently logged onto the database. You also get the flags per session ie. Y--P--- Now the question. Where in the SMI tables can I do a select to give the flags for a session ? If I select from userthreads, i get a column called flags, but it is an integer. Is there a way to "decode" that ? Many thanks in advance Cheers Marius