Incidents Table

This table contains all the information collected by Watchdoc on incidents that have occurred.

Field	Type	Required	Primary key	Description
incID	bigint	*	*	Unique incident identifier
incCODE	tinyint	*		Incident code
incDOCUMENTID	bigint			Identifier of the document concerned by the incident
incDATE	datetime	*		Date of the incident
incQUEUE	varchar(64)			File concerned by the incident.
incERROR	nvarchar(255)			Incident error code.
incDESCRIPTION	text			Description de l'incident.
incREFUND	tinyint	*
incDELETED	tinyint	*
incTYPE	tinyint	*
incUSER	nvarchar(128)			User who caused the incident.
incTITLE	nvarchar(255)			Title of the print job that caused the incident.
incSTATION	nvarchar (128)	(1208)		DNS name of the workstation that caused the incident
incCACHEYEAR	smallint			optimization key
incCACHEMONTH	tinyint			optimization key
incCACHEDAY	tinyint			optimization key
incCACHEHOUR	tinyint			optimization key
incCACHEDAYOFWEEK	tinyint			optimization key
incCACHEMINUTE	tinyint			optimization key
incQGROUP	varchar (64)			Identifier of the group of queues on which the incident took place.
incQSITE	varchar (64)			Identifier of the site (Watchdoc server identifier) on which the queue on which the incident took place depends.
incDATERESOLVED	datetime			Date of resolution of the incident
incMOVED	tinyint			System field used in a master architecture and used on Watchdoc servers to specify whether the value of the field has been replicated on the master and can therefore be deleted (if NULL or 0, "local" document, if >= 254, archived document that can be deleted).
incSOURCEID	bigint			System field: temporary identifier of the incident during the replication transaction.