What is the DB table that houses the keywords for a document type?

[Lynn_Slaga]

When you configure a document type, one of the configuration items is assigning keywords to document type.  What is the database table that houses that information?  I need to provide my HR team a listing of all the HR document types and the associated keywords for each of those document types.

[AdamShaneHyland]

Hi @Lynn Slaga ,

You are looking for hsi.itemtypexkeyword.  Here is a query which will return the Keyword Types associated with the respective Document Types ...

SELECT	ixk.itemtypenum AS "Document Type Number",	dt.itemtypename AS "Document Type Name",	ixk.keytypenum AS "Keyword Type Number", 	ktt.keytype AS "Keyword Type"FROM hsi.itemtypexkeyword ixkJOIN hsi.doctype dt ON dt.itemtypenum = ixk.itemtypenumJOIN hsi.keytypetable ktt ON ktt.keytypenum = ixk.keytypenumWHERE ixk.itemtypenum IN (XXX, YYY)ORDER BY 2, 4

Hope this helps.