There’s a table called system_status that stores all statuses and what they mean for the table they’re in.

You can link system_status to the table status_type, which gives more detail about where the information is stored. 

Here’s a sample query: 

             select ss.status_type
                   ,st.description
                   ,ss.sts
                   ,ss.description
                   ,ss.active_flag 

               from system_status  ss
                   ,status_type    st 

              where ss.status_type = st.status_type and 
st.description like '%<describe sts type>%'