Table DOCUMENTS

AUTHOR

varchar

Author of the document

AUTHORID

int

Author ID of the document (relates to USERS.OBJECTID, also the User's SI_ID)

CALENDARID

int

Calendar ID the document is scheduled to run within

CALENDARTYPE

varchar

Calendar type the document is scheduled to run within

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

nvarchar

Description of the document

ERRORMESSAGE

nvarchar

Error message of the document in case it was loaded with a problem

ID

int

Globally unique ID of the Document (MMDB)

INTERVALLENGTH

int

Interval length

INTERVALUNIT

varchar

Interval unit of the scheduled instance

ISAPPLICATION

bit

Is the object an application? (typically = 0, or false)

ISCONTAINER

bit

Is this object a container? (Yes = 1, No = 0)

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 this a recurring instance? (Yes В = 1, No = 0)

JOB_ENDTIME

datetime

Time at which the actual job execution started

JOB_STARTTIME

datetime

Time at which the actual job execution ended

KEYWORD

varchar

Keywords associated w/ the object (SI_KEYWORD)

KIND

varchar

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

MACHINEUSED

varchar

Machine used to schedule the report (SI_MACHINEUSED)

MARKEDASREAD

bit

Marked as read?

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

NEXTRUNTIME

datetime

Next run time of the schedule instances

OBJECTID

int

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

OUTCOMESTATUS

varchar

Outcome status of this instance

OWNER

varchar

Owner (SI_OWNER_

OWNERID

int

Owner ID (SI_OWNERID)

PARENTCUID

varchar

Parent CUID (SI_PARENTCUID)

PARENTFOLDERCUID

varchar

Parent Folder CUID (SI_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

PROCESSINGERROR

varchar

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

PROCESSINGSTATUS

int

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

RUNNOW

bit

Run now?

SCHED_ENDTIME

datetime

Scheduled end time of the instance

SCHED_STARTTIME

datetime

Scheduled start time of the instance

SCHEDULESTATUS

varchar

Schedule status of the instance (as it is now)

SUBMITTER

varchar

User who submitted the job for scheduling (SI_SUBMITTER)

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