Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
analysis_name	CHAR	varchar		32			Analysis name, e.g churn, credit
analysis_type	CHAR	varchar		32			Name of the item/element
last_update_time	CLK_TIME	datetime					Last update time of the table
object_name	CHAR	varchar		32			Name of the object
objid	LONG	int	3			DIRECT	Internal record number

SQL:

(select table_dm_analysis.objid, table_dm_analysis.name as analysis_name,
table_gbst_elm.title as analysis_type, table_anls_object.name as object_name,
table_extrnl_data.last_updated as last_update_time
from table_dm_analysis
join table_gbst_elm on table_gbst_elm.objid = table_dm_analysis.analysis2gbst_elm
left outer join table_anls_object on table_anls_object.objid = table_dm_analysis.anls_modeling2anls_object
left outer join table_extrnl_data on table_anls_object.objid = table_extrnl_data.external2anls_object)