TruSoft Consulting

SYSLOG

DBase Directory Location: GMBASE
Table Description: System log, contains details about database maintenance and other database-related activities.

Table Indexes
Name	DBase Index	SQL Index	ID
SYSDATE	RECTYPE+DTOS(ONDATE)+ONTIME	RECTYPE+ONDATE+ONTIME	-
SYSPID	RECTYPE+PID+DTOS(ONDATE)+ONTIME	RECTYPE+PID+ONDATE+ONTIME	-
SYSSITEID	RECTYPE+SITEID+DTOS(ONDATE)+ONTIME	RECTYPE+SITEID+ONDATE+ONTIME	-
SYSRECID	RECID	RECID	-

Table Relationships

Field

None

Table Fields Structure
Field Name	Field Type	Length	Description
RECTYPE	String	1	Record Type. Possible values are listed below. Value Description E Error G Gold Sync M Maintenance Task P Process Monitor Window W Sync Wizard
PID	String	33	Process ID
SITEID	String	20	Site ID - Contains the Site ID the entry relates to
ONDATE	Date	8	Date of entry (m/d/yy)
ONTIME	String	5	Time of entry (hh:mm)
RESULTCODE	String	3	Type of message (i.e. ERR)
USERID	String	8	User logged in at time of message
REF	String	50	Typically first line or primary message
PARAMS	Memo	-	Full text of the message
RECID	String	15	Record ID