MicroStrategy ONE
STG_IS_REP_COL_STATS
Tracks the column-table combinations used in the SQL during report executions. This table is used when the Report job tables/columns accessed 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_COL_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 |
Report job ID. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
SESSIONID |
GUID of the user session. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(23) |
CHAR(23) |
|
SERVERID |
GUID of the server definition. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
TABLEID |
GUID of the database tables used. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
COLUMNID |
GUID of the columns used. |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
CHAR(32) |
|
COLUMNNAME |
Description of the column used. |
VARCHAR(255) |
VARCHAR2(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
VARCHAR(255) |
|
SQLCLAUSETYPEID |
The SQL clause in which the column is being used. |
TINYINT |
NUMBER(3) |
SMALLINT |
BYTEINT |
TINYINT |
TINYINT |
|
COUNTER |
The number of times a specific column/table/clause type combination occurs within a report execution. |
INTEGER |
NUMBER(10) |
INTEGER |
INTEGER |
INTEGER |
INTEGER |
|
STARTTIME |
Timestamp of the job start time. |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP |
DATETIME |
DATETIME |
|
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) |