MicroStrategy ONE
STG_IS_DOCUMENT_STATS
Tracks document executions that the Intelligence Server processes. This table is used when the Basic Statistics option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_DOCUMENT_STATS table, which has the same columns and datatypes.
| Column | Description | SQL Server Data-type | Oracle Data-type | DB2 Data-type | Teradata Data-type | Sybase Data-type | MySQL Data-type |
|
DAY_ID |
Day the document was requested for execution. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the document was requested for execution. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the document was requested for execution. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
JOBID (I) |
Job ID. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SESSIONID (I) |
GUID of the user session. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERID |
GUID of the Intelligence Server's server definition at the time of the request. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERMACHINE |
Server machine name or IP address. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
PROJECTID |
GUID of the project. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
USERID |
GUID of theuser. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
DOCUMENTID (I) |
GUID of the document. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
REQUESTRECTIME |
The timestamp at which the request is received. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
REQUESTQUEUETIME |
Total queue time of all steps in this request. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STARTTIME |
Time duration between request receive time and document job was created. An offset of the RequestRecTime. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
FINISHTIME |
Time duration between request receive time and document job last step was finished. An offset of the RequestRecTime. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXECERRORCODE |
Execution error code. If no error, the value is 0. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
REPORTCOUNT |
Number of reports included in the document. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
CANCELINDICATOR |
Was the document job canceled? |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
PROMPTINDICATOR |
Number of prompts in the report. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
CACHEDINDICATOR |
Was the document cached? |
BIT |
NUMBER(1) |
SMALLINT |
BYTEINT |
BIT |
TINYINT(1) |
|
RECORDTIME (I) |
Timestamp of when the record was written to the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
CPUTIME |
CPU time, in milliseconds, used for document execution. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STEPCOUNT |
Total number of steps involved in execution (not just unique steps). |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
EXECDURATION |
Duration of execution, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
ERRORMESSAGE |
Error message displayed to the user when an error is encountered. |
VARCHAR(4000) |
VARCHAR2(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
VARCHAR(4000) |
|
EXECACTIONS |
Intelligence Server-related actions that need to take place during document execution. |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXECFLAGS |
Intelligence Server-related processes needed to refine the document execution. |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
PROMPTANSTIME |
Total time, in milliseconds, the user spent answering prompts on the document. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
EXPORTINDC |
1 if the document was exported, otherwise 0. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
CACHECREATORJOBID |
If the job hit a cache, the job ID of the job that created the cache used by the current job. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CACHECREATORSESSONID |
If the job hit a cache, the GUID for the session in which the cache was created. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
MESSAGEID |
For MicroStrategy use. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |