STG_IS_REP_SEC_STATS

Tracks executions that used security filters. 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_REP_SEC_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 job was requested for execution.	DATE	TIMESTAMP	DATE	DATE	DATE	DATE
HOUR_ID	Hour the job was requested for execution.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
MINUTE_ID	Minute the job 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)
SECURITYFILTERSEQ	Sequence number of the security filter, when multiple security filters are used.	SMALLINT	NUMBER(5)	SMALLINT	SMALLINT	SMALLINT	SMALLINT
SERVERID	Server definition GUID.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
SECURITYFILTERID (I)	Security filter GUID.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
STARTTIME	Timestamp of when the job started.	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)