STG_IS_PROJ_SESS_STATS

Records statistics related to project session. 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_PROJ_SESS_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 project session was started.	DATE	TIMESTAMP	DATE	DATE	DATE	DATE
HOUR_ID	Hour the project session was started.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
MINUTE_ID	Minute the project session was started.	SMALLINT	NUMBER(5)	SMALLINT	SMALLINT	SMALLINT	SMALLINT
SESSIONID	Session object GUID. This is the same session ID used in STG_IS_SESSION_STATS. If you close and reopen the project connection without logging out from Intelligence Server, the session ID is reused.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
SERVERID	Server definition GUID.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
SERVERMACHINE	The Intelligence Server machine name and IP address.	VARCHAR(255)	VARCHAR2(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)	VARCHAR(255)
USERID	GUID of the user performing the action.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
PROJECTID	Project GUID.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
CONNECTTIME	Timestamp of when the session was opened.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
DISCONNECTTIME (I)	Timestamp of when the session was closed.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
RECORDTIME (I)	Timestamp of when the record was written to the statistics database.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
REPOSITORYID	GUID of the metadata repository.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)