Column Name |
Data Type |
Description |
|---|---|---|
AUTHOR |
varchar |
Author of the document (SI_AUTHOR) |
CALENDARID |
int |
Calendar ID |
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 |
The datetime an object was created (for the first time) in the SAP BusinessObjects CMS. |
DATA_CATEGORY |
varchar |
Category of the document |
DAY_OF_MON_START |
int |
Day of the month the schedule started |
DAY_OF_WEEK_START |
nvarchar |
Day of the week the schedule started |
DAYS_AGO_CREATED |
numeric |
Days ago the document was created from today |
DESCRIPTION |
nvarchar |
Description of the document |
DOCUMENTS_CUID |
varchar |
CUID of the document |
DOCUMENTS_ID |
int |
ID of the document, globally unique (DOCUMENTS.ID) |
DOCUMENTS_OBJECTID |
int |
SI_ID of the document, unique only within the CMS (DOCUMENTS.OBJECTID) |
ERRORMESSAGE |
nvarchar |
Error message of the failed instance (MSSQL/ORACLE) |
ERRORMESSAGE2 |
int |
NOT USED |
ERRORMESSAGE3 |
int |
NOT USED |
ERRORMESSAGE4 |
int |
NOT USED |
ERRORMESSAGE5 |
int |
NOT USED |
FILENAME |
varchar |
File name asits stored in the FRS of the document/object |
FILEPATH |
varchar |
File path of the object as its stored in the FRS |
FILESIZE |
bigint |
File size as its stored in the FRS |
FOLDERNAME |
nvarchar |
Folder name where the document can be found |
FOLDERPATHCOMPLETE |
nvarchar |
Folder path where the document can be found |
FOLDERS_CUID |
varchar |
CUID of the folder |
FOLDERS_ID |
int |
ID of the folder (globally unique, FOLDERS.ID) |
FOLDERS_OBJECTID |
int |
SI_ID of the folder |
INTERVALLENGTH |
int |
Interval length of the scheduled instance |
INTERVALUNIT |
varchar |
Internal unit of the schedule instance |
ISAPPLICATION |
varchar |
INTERNAL |
ISINSTANCE |
varchar |
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 |
varchar |
Is the document a recurring instance? |
JOB_DURATION_MIN |
int |
Job duration in minutes |
JOB_DURATION_SEC |
int |
Job duration in seconds |
JOB_ENDTIME |
datetime |
Job end time |
JOB_STARTTIME |
datetime |
Job start time |
KEYWORD |
varchar |
Keywords related to the object |
KIND |
varchar |
The type of the object, equivalent to SI_KIND in the CMS/Query Builder |
MACHINEUSED |
varchar |
Machine that was used to run this schedule instance |
MARKED_AS_READ |
varchar |
Is the document marked as being read? |
MONTH_CREATED |
int |
Month the document was created |
MONTH_YEAR_CREATED |
varchar |
Month-Year the document was created |
MONTH_YEAR_DATE_CREATED |
datetime |
Date the document was created |
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 |
Document's next run time (if it has a schedule instance attached to it) |
OUTCOMESTATUS |
varchar |
Outcome status of the schedule instance |
OWNER |
varchar |
Owner of the object (SI_OWNER) |
OWNERID |
int |
Owner ID of the object |
PARENTCUID |
varchar |
Parent CUID of the object; could be a folder , instance or something else |
PARENTFOLDERCUID |
varchar |
Parent folder CUID of the object/document |
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 |
Folder Path 1 |
PATH2 |
nvarchar |
Folder Path 2 |
PATH3 |
nvarchar |
Folder Path 3 |
PATH4 |
nvarchar |
Folder Path 4 |
PATH5 |
nvarchar |
Folder Path 5 |
PATH6 |
nvarchar |
Folder Path 6 |
PATH7 |
nvarchar |
Folder Path 7 |
PATH8 |
nvarchar |
Folder Path 8 |
PATH9 |
nvarchar |
Folder Path 9 |
RUNNOW |
varchar |
Run the object now? |
SCHED_ENDTIME |
datetime |
Instance schedule end time (when did the instance's job finish?) |
SCHED_STARTTIME |
datetime |
Instance schedule start time (when did the instance's job start?) |
SCHEDULESTATUS |
varchar |
Schedule status of the instance (FAILED, COMPLETED, PAUSED, PENDING, RUNNING) |
SUBMITTER |
varchar |
Who submitted the job? (SI_SUBMITTER) |
UPDATED |
datetime |
Datetime that this object was updated in the BusinessObjects CMS |
YEAR_CREATED |
int |
Year the document was created |
See also