Table FOLDERS

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

CUID

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.

DESCRIPTION

varchar

Description of the folder

FOLDERPATHCOMPLETE

nvarchar

Complete folder path

ID

int

Globally unique ID of the Folder (within the MMDB)

ISCONTAINER

bit

Is Container? (always true)

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

ISRECURRING

bit

Is Recurring?

KEYWORD

varchar

Keywords associated with the folder

KIND

varchar

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

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 etc.)

OBJECTID

int

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

PARENTFOLDERCUID

varchar

Parent Folder CUID

PARENTID

int

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

PATH1

nvarchar

Path 1 of the Folder (in the context of the complete folder path)

PATH10

nvarchar

Path 10 of the Folder (in the context of the complete folder path)

PATH11

nvarchar

Path 11 of the Folder (in the context of the complete folder path)

PATH2

nvarchar

Path 2 of the Folder (in the context of the complete folder path)

PATH3

nvarchar

Path 3 of the Folder (in the context of the complete folder path)

PATH4

nvarchar

Path 4 of the Folder (in the context of the complete folder path)

PATH5

nvarchar

Path 5 of the Folder (in the context of the complete folder path)

PATH6

nvarchar

Path 6 of the Folder (in the context of the complete folder path)

PATH7

nvarchar

Path 7 of the Folder (in the context of the complete folder path)

PATH8

nvarchar

Path 8 of the Folder (in the context of the complete folder path)

PATH9

nvarchar

Path 9 of the Folder (in the context of the complete folder path)

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