There isn't a specific fields for all of them, most are calculated and look at several different tables. For instance if you run the below query, you'll get the most current version for a document/page. In that version record you'll get can see if the version is archived or not. If not, then you have to look at the workflow ID and see what step in workflow the document is in.
select t.*, vh.*
from View_CMS_Tree_Joined t
inner join cms_versionhistory vh on t.DocumentPublishedVersionHistoryID = vh.VersionHistoryID