Universe Tables.
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 |
CREATED |
datetime |
The datetime an object was created (for the first time) in the BusinessObjects CMS; Equivalent to SI_CREATION_TIME |
ID |
int |
Primary key |
ISALIASED |
bit |
Is table an alias table? |
ISDERIVED |
bit |
Is table a derived SQL table? |
ORIGINALTABLE |
int |
Original Table ID (Foreign key to UNV_TABLES.ID) |
SQLDERIVED |
nvarchar |
SQL used if derived table |
TABLEID |
int |
Table ID |
TABLENAME |
nvarchar |
Table Name |
UNIVERSECUID |
varchar |
Universe CUID |
UNIVERSEMUID |
varchar |
Universe CUID + CMS Server |
UNV_UNIVERSES_ID |
int |
Foreign key to UNV_UNIVERSES.ID |
UPDATED |
datetime |
Datetime that this object was updated in the BusinessObjects CMS |
UPDATED_CMS |
datetime |
Last time object was updated in the CMS |
See also