Table CRYSTAL_DOCUMENTS

Crystal Reports core metadata.

 

Column Name

Data Type

Description

CMSID

varchar

The actual 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

Datetime the object was created

CUID

varchar

The unique ID of the object, but does not stay unique across environments (CMS/Query Builder equivalent of SI_ID )

DOCUMENTS_ID

int

NOT USED

GROUPFORMULA

nvarchar

Group formula

ID

int

Internal MetaMiner DB id

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

KIND

varchar

The type of the object, equivalent to SI_KIND in the CMS/Query Builder

MAJOR_VERSION

int

Major report version

MINOR_VERSION

int

Minor report version

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, so on)

OBJECTID

int

The SI_ID of the object as its known to the SAP BusinessObjects CMS

PARENTID

int

The object's Parent ID, which could be an instance or folder or object package or publication. В Equivalent of SI_PARENTID

PROCESSINGERROR

varchar

Describes any processing errors that occurred while loading metadata for this object

RECORDFORMULA

nvarchar

Record formula used on the report

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

 

 

 

 
See also

MetaMiner Database Fields

 

© 2013-2015 by Infolytik