MicroStrategy ONE
STG_IS_REP_STEP_STATS
Tracks each step in the report execution process. This table is used when the Report 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_REP_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 report was requested for execution. |
DATE |
TIMESTAMP |
DATE |
DATE |
DATE |
DATE |
|
HOUR_ID |
Hour the report was requested for execution. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
MINUTE_ID |
Minute the report was requested for execution. |
SMALLINT |
NUMBER(5) |
SMALLINT |
SMALLINT |
SMALLINT |
SMALLINT |
|
JOBID |
Job ID. |
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 Intelligence Server processing the request. |
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 between last step finish and the next step start, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
CPUTIME |
CPU time used during this step, in milliseconds. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STEPDURATION |
FINISHTIME - STARTTIME, in milliseconds |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
RECORDTIME |
Timestamp of when the record was logged in 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) |