Table UNV2_UNIVERSES

Universes Core (Alternate Java Method).

Column Name	Data Type	Description
AUTHOR	varchar	Author of the Universe
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
COMMENTS	nvarchar	Comments
CONN_CONNECTIONNAME	varchar	Connection Name Universe uses (Foreign key to DATA_CONNECTIONS.NAME)
CONN_CONNECTIONSTRING	varchar	Connection string
CONN_DATABASE	varchar	Connection database
CONN_NETWORKLAYER	varchar	Connection network layer
CONN_PARAMSTRING	varchar	Connectin parameter string
CONN_TYPE	int	Connection type
CONNECTION	varchar	Connection
CONNECTIONCMSNAME	nvarchar	Connection CMS Name (Compound key of Connection Name \|\| CMS )
CREATED	datetime	The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME
CUID	varchar	CUIDs are Cluster Unique Identifiers that uniquely identify an InfoObject, within a given cluster and also identify replicas or copies of an object across multiple CMS clusters. Because CUIDs are moderately lengthy strings they are less efficient to use and slower to query for.
DESCRIPTION	nvarchar	Description
FULLNAME	varchar	Full name
ID	int	Primary key (MMDB) (MMDB)
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
ISLATESTSNAPSHOT	int	Is the Universe the latest snapshot?
JOINSTRATEGY	varchar	Join strategy used
KIND	varchar	The type of the object, equivalent to SI_KIND in the CMS/Query Builder
LANGUAGE	varchar	Language
LONGNAME	varchar	Long name
MODIFIEDBYUSER	varchar	Modified By User
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
OBJECTSTRATEGY	varchar	Object Strategy
OWNER	varchar	Owner
PARENTID	int	The object's Parent ID, which could be an instance or folder or object package or publication. В Equivalent of SI_PARENTID
PROCESSING_CODE	varchar	Processing code
PROCESSINGERROR	varchar	Describes any processing errors that occurred while loading metadata for this object
QUALIFIER	varchar	Qualifier
REVISIONNUMBER	int	Revision Number
TABLESTRATEGY	varchar	Table Strategy
UNIVERSECREATED	varchar	Universe created
UNIVERSECUID	varchar	Universe CUID
UNIVERSEID	int	Universe ID (same as SEMANTICLAYER.OBJECTID)
UNIVERSEMODIFIED	varchar	Universe modified on
UNIVERSENAME	nvarchar	Universe Name
UNVFOLDERPATH	varchar	Universe Folderpath
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