MicroStrategy ONE
STG_IS_DOC_STEP_STATS
Tracks each step in the document execution process. This table is used when the Document Job Steps option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_DOC_STEP_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 |
GUID of the document job. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STEPSEQUENCE |
Sequence number for a job's steps. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
SESSIONID |
GUID of the user session. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
SERVERID |
GUID of the server definition. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
STEPTYPE |
Type of step. For a description, see Report and Document Steps. 1: Metadata object request step 2: Close job 3: SQL generation 4: SQL execution 5: Analytical Engine server task 6: Resolution server task 7: Report net server task 8: Element request step 9: Get report instance 10: Error message send task 11: Output message send task 12: Find report cache task 13: Document execution step 14: Document send step 15: Update report cache task 16: Request execute step 17: Data mart execute step 18: Document data preparation 19: Document formatting 20: Document manipulation 21: Apply view context 22: Export engine 23: Find Intelligent Cube task 24: Update Intelligent Cube task 25: Post-processing task 26: Delivery task 27: Persist result task 28: Document dataset execution task |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
STARTTIME |
Timestamp of the step's start time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
FINISHTIME |
Timestamp of the step's finish time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
QUEUETIME |
Time duration, in milliseconds, between the last step finish and the next step start. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CPUTIME |
CPU time, in milliseconds, used during this step. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STEPDURATION |
FINISHTIME minus STARTTIME, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
RECORDTIME |
Timestamp of when the record was written to the database, according to database system time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
SERVERMACHINE |
(Server machine name:port number) pair. |
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) |
|
REPOSITORYID |
GUID of the metadata repository. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |