STG_IS_SCHEDULE_STATS

Tracks which reports have been run as the result of a subscription. This table is used when the Subscriptions option is selected in the Statistics category of the Project Configuration Editor. The data load process moves this table's information to the IS_SCHEDULE_STATS table, which has the same columns and datatypes.

Column	Description	SQLU Server Datatype	Oracle Datatype	DB2 Datatype	Teradata Datatype	Sybase Datatype	MySQL Datatype
DAY_ID (I)	Day the job was requested for execution.	DATE	TIMESTAMP	DATE	DATE	DATE	DATE
HOUR_ID (I)	Hour the job was requested for execution.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
MINUTE_ID (I)	Minute the job was requested for execution.	SMALLINT	NUMBER(5)	SMALLINT	SMALLINT	SMALLINT	SMALLINT
SCHEDULEID (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)
SERVERID	GUID for server definition.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
TRIGGERID (I)	GUID of the object that triggered the subscription.	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)	CHAR(32)
SCHEDULETYPE (I)	Type of schedule:0 if it is a report, 1 if it is a document	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
HITCACHE	0 if the job does not hit the cache, 1 if it does.	TINYINT	NUMBER(3)	SMALLINT	BYTEINT	TINYINT	TINYINT
STARTTIME	Timestamp of the schedule start time.	DATETIME	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATETIME	DATETIME
RECORDTIME (I)	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 (I)	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)