Lifecycle
go to Rev table and get the latest rev for an item and get the release_type column value,
then
select description from nodetable where id=’release_type column value’;
The nodetable will hold the name of the lifecycle. Was this the same post on linked in? If so, you can join with a view to get the number, rev and lifecycle. Please post what you are really after and maybe I can help