Universes Main Metadata Table.
Column Name |
Data Type |
Description |
|---|---|---|
AUTHOR |
nvarchar |
Universe author |
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 |
CONNECTIONCMSNAME |
nvarchar |
Connection name |
CONNECTIONID |
int |
Connectin ID |
CREATED |
datetime |
The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME |
CREATEDBYUSER |
nvarchar |
Created By |
DATASOURCENAME |
nvarchar |
Datasource Name |
DESCRIPTION |
nvarchar |
Description |
EXISTSINCMS |
bit |
NOT USED |
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. |
ISDIRTY |
bit |
NOT USED |
ISLATESTSNAPSHOT |
bit |
Is latest snapshot? (Used when versions are being captured) |
LINKEDUNIVERSEID |
int |
Linked Universe ID |
MODIFIEDBYUSER |
nvarchar |
Modified By User |
POSTPROCESSINGFLAG |
int |
INTERNAL |
REVISIONNUMBER |
int |
Revision Number (when multiple versions are published and each is captured by MetaMiner) |
UNIVERSECREATED |
nvarchar |
Universe Create Date |
UNIVERSECUID |
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. |
UNIVERSEID |
int |
Universe ID |
UNIVERSEMODIFIED |
nvarchar |
Universe Modified Date |
UNIVERSEMUID |
varchar |
Universe CUID + CMS Server |
UNIVERSEMUIDSTD |
nvarchar |
INTERNAL |
UNIVERSENAME |
nvarchar |
Universe Name |
UNVFOLDERPATH |
nvarchar |
Universe Folderpath |
UPDATED |
datetime |
Datetime that this object was updated in the BusinessObjects CMS |
UPDATED_CMS |
datetime |
Updated |
UPDATEDUTCMILLIS |
bigint |
Time in milliseconds that this object was updated in the BusinessObjects CMS |
See also