What database table contains the document types that are configured for a lifecyle?

[Corey_Gillingha]

I have a report request that requires to only include document types that are configured for a particular lifecycle.  I have looked but am unable to find the database table that contains this list of document types. 

Thank you in advance for any help that you can provide.

[Alexander_Tsike]

I believe the table you are looking for is hsi.itemtypelc.

[Corey_Gillingha]

Thank you for the quick response!  However, this table does not appear to contain the data that I am looking for.  I am trying to find the table that holds the document types that are configured for a lifecycle.

[Mike_Walkuski · Accepted solution]

Hi @Corey Gillingham 

There are two tables you will need to look at for this depending on how your Lifecycle is configured. If it is configured as a Unity Lifecycle you will look at hsi.workitemtypelc if it is configured as a legacy lifecycle, then you will look at itemtypelc.

You can determine this by looking at the flags column in hsi.lifecycle. This is a bit column and the bit to indicate a Unity Lifecycle is "0x0010000" (65536) - Unity Lifecycle

You can then look at the wfcontenttype column to determine what type of item it is.

Legacy Document = 0

Document = 1
Folder = 2
WorkviewItem = 3
MedicalChart = 4
External Access = 5

I hope this helps!

[Corey_Gillingha]

Hi Mike, thank you for this information.  It was exactly what I was looking for!

Also, my apologies to Alex.  The information that Alex provided was also correct.  The reason I did not find any data in the hsi.itemtypelc table was because all of our lifecycles are Unit Lifecycles.