Table DESKI_DOCUMENTS

Desktop Intelligence document metadata at the document level.

Column Name	Data Type	Description
AUTHOR	nvarchar	Author of the report
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
DESKICUID	varchar	CUID of the Deski document
DESKIMUID	varchar	CUID + CMS Server name of the Deski document
DOCUMENTID	int	SI_ID of the Deski object (similar to OBJECTID in other tables)
DOCUMENTNAME	nvarchar	Name of the document (NOT USED)
FILENAME	nvarchar	Filename of the physical deski report, e.g. "Sales_Revenue.rep"
FILEPATH	nvarchar	Filepath in the FRS of the Deski report
FILESIZE	int	Filesize of the file
FOLDERNAME	nvarchar	Folder name of the report (direct parent)
FOLDERPATH	nvarchar	Folder path of the report (where the folder resides all the way to the Public Folders (root) branch
HASPROMPTS	bit	Does the report have prompts?
HASVBAMACROS	bit	Does the report have VBA macros? Useful when determining migration efforts of Deski reports; VBA macros unable to migrate
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.
ISDIRTY	bit	NOT USED
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
ISREFRESHONOPEN	bit	Is the report set to "Refresh on Open?"
ISVALID	bit	Is the report valid? (some cases, the report is corrupt and cannot be opened and hence INVALID = 1 or true)
KIND	nvarchar	The type of the object, equivalent to SI_KIND in the CMS/Query Builder
LOADERRORDESC	nvarchar	Description of any loading errors that occur while processing Deski reports
OWNER	nvarchar	Owner of the Deski report
PARENTCUID	varchar	Parent CUID of the report
PARENTID	int	The object's Parent ID, which could be an instance or folder or object package or publication. В Equivalent of SI_PARENTID
POSTPROCESSINGFLAG	int	Post processing flags (NOT USED)
UNBOUNDDATAPROVIDERS	bit	Is the deski dataprovider unbound? В (which means,
UPDATED	datetime	Datetime that this object was updated in the BusinessObjects CMS