Parent documents for SQLs (Webi/Deski) deconstructed from dataproviders.
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 |
int |
Connection ID of the associated document (META_CONNECTIONS.ID) |
DATATYPE |
varchar |
Data Type |
DOCUMENTID |
int |
Document ID (Foreign key to DOCUMENTS.ID) |
ID |
int |
ID of the DOCUMENT (globally unique) |
OBJECTID |
int |
The SI_ID of the object as its known to the BusinessObjects CMS |
SQLID |
int |
SQL ID, foreign key to one of the SQL Container tables (e.g. WEBI1200_SQLCONTAINERS.ID) |
SQLREFTABLE |
varchar |
SQL Reference table (e.g. WEBI1200_SQLCONTAINERS) |
UPDATEDUTCMILLIS |
bigint |
Time in milliseconds that this object was updated in the BusinessObjects CMS |
See also