Documentation on hidden tables

[println-titan]

Hi all,

Are there any documentation on hidden tables (i.e. WORKFLOWHISTORY)?
I tried to search through Saviynt documentation but didn't find anything about it.

Any help is much appreciated!

[rushikeshvartak]

Its not documented let me know if what information you are looking for

[println-titan]

Hi @rushikeshvartak ,

I just want to understand the columns available in the table so we can write the query for analytics

[rushikeshvartak]

s

TABLE_NAME COLUMN_NAME IS_NULLABLE DATA_TYPE COLUMN_TYPE

workflowhistory	WORKFLOWKEY	NO	bigint	bigint(20)
workflowhistory	CREATEDATE	YES	datetime	datetime
workflowhistory	CREATEDBY	YES	bigint	bigint(20)
workflowhistory	DESCRIPTION	YES	longtext	longtext
workflowhistory	FROMWORKFLOW	YES	bigint	bigint(20)
workflowhistory	JSONDATA	YES	longtext	longtext
workflowhistory	MD5XMLDATA	YES	varchar	varchar(255)
workflowhistory	OWNER	YES	bigint	bigint(20)
workflowhistory	OWNERTYPE	YES	bigint	bigint(20)
workflowhistory	STATUS	YES	bigint	bigint(20)
workflowhistory	UPDATEDATE	YES	datetime	datetime
workflowhistory	UPDATEDBY	YES	bigint	bigint(20)
workflowhistory	WFTYPE	YES	varchar	varchar(255)
workflowhistory	WFLOADED	YES	bit	bit(1)
workflowhistory	WFNAME	NO	varchar	varchar(255)
workflowhistory	WFVERSION	YES	bigint	bigint(20)
workflowhistory	XMLDATA	NO	longtext	longtext
workflowhistory	COMMENTS	YES	longtext	longtext
workflowhistory	SOURCE	YES	varchar	varchar(255)
workflowhistory	SOURCEID	YES	varchar	varchar(255)