Database columns of a Universe.
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  | 
COLUMNNAME  | 
nvarchar  | 
Column Name  | 
COLUMNTYPE  | 
nvarchar  | 
Column Type  | 
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  | 
TABLEID  | 
int  | 
Table ID (foreign key to UNV_TABLES.TABLEID)  | 
TABLENAME  | 
nvarchar  | 
Table Name  | 
UNIVERSECUID  | 
varchar  | 
Universe CUID  | 
UNIVERSEMUID  | 
varchar  | 
Universe MUID the class belongs to  | 
UNV_TABLES_ID  | 
int  | 
Foreign key to UNV_TABLES.ID  | 
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  | 
update time from the CMS  | 
 
See also