Table SEMANTICLAYER

Semantic Layer (Universe, UNX) metadata.

Column Name	Data Type	Description
CMSID	varchar	The actualy name of the CMS host machine without the port number, if used. В This is used in conjunction with OBJECTID or CUID to uniquely identify an object across environments
CONNECTIONID	varchar	Connection ID of the semantic layer (foreign key to DATA_CONNECTIONS.ID when applicable)
CREATED	datetime	The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME
CUID	varchar	The unique ID of the object, but does not stay unique across environments (CMS/Query Builder equivalent of SI_ID )
DESCRIPTION	varchar	Description of the Semantic Layer
ID	int	Primary key
ISDELETED	bit	Indicates whether this object was deleted from the BusinessObjects CMS. В When set to "1", the object was deleted and MetaMiner keeps a "soft delete" record of its metadata.
ISINSTANCE	bit	Indicates whether this object is an instance В (scheduled object) or not; Instances are usually only stored in the DOCUMENTS or V_DOCUMENTS table/view. Instances are NOT captured in base tables such as CRYSTAL_DOCUMENTS, WEBIxx_DOCUMENTS, DESKI_DOCUMENTS
KIND	varchar	The type of the object, equivalent to SI_KIND in the CMS/Query Builder
LASTSUBMITTER	varchar	Last submitter of the Semantic Layer
NAME	nvarchar	The name of the object, in many cases the equivalent of SI_ID in the CMS/Query Builder when referring to a base CMS object type (USERS, SEMANTICLAYER etc.)
OBJECTID	int	The SI_ID of the object as its known to the BusinessObjects CMS
PARENTCUID	varchar	Parent CUID of the Universe or Semantic Layer
PARENTFOLDERCUID	varchar	Parent Folder CUID
PARENTID	int	The object's Parent ID, which could be an instance or folder or object package or publication. В Equivalent of SI_PARENTID
TYPE	varchar	Type (UNV or UNX)
UPDATED	datetime	Datetime that this object was updated in the BusinessObjects CMS
UPDATEDUTCMILLIS	bigint	Time in milliseconds that this object was updated in the BusinessObjects CMS