Database Table LogEntry

[This is preliminary documentation and is subject to change.]

This table holds entries for logged events in the user interface.

Note that data model add-ons may extend this table (e.g. add fields to it) when installed. For example, installing the accreditation data model add-on adds sevaral fields to this table - see LogEntry - accr. data model add-on.

Fields

Field name	Type	Note	Description
Id	INT	PrimaryKey	Internal auto generated unique id for the log entry
ActionType	INT	Foregin key to LogActionType	Identifies the event type.
DateTime	DATETIME		The date and time for logging the event
DateTimeStop	DATETIME		The date and time the event ended if applicable. Mostly used in connection with long running events such as import of data.
MilliSeconds	INT		The duration of the event if applicable
UserId	INT	Foreign key to Employee	Id of the logged in user that performed the action
EmployeeId	INT	Reference to Employee	Id of the employee being created/updated/deleted
PatientId	INT	Reference to Patient	Id of the patient associated with the event if applicable
TableName	VARCHAR(50)	Reference to DatadictionaryTable	Name of the datadictionary table(dynamic table) associated with the event if applicable.
RecordId	INT	Reference to dynamic record	Id of the datadictonary (dynamic table) record associated with the event if applicable
OrgUnitType	VARCHAR(20)	Partial foreign key to OrgUnit	Type of organizational unit associated with the event if applicable
OrgUnitCode	VARCHAR(20)	Partial foreign key to OrgUnit	Code of organizational unit associated with the event if applicable
ImportType	VARCHAR(20)		Type of import associated to the event. Applies only to import of data.
ImportFileName	TEXT	Editable	Name of file containing data for import associated to the event. Applies only to import of data.
ResultType	VARCHAR(20)	Partial foreign key to ResultLookUp	Type of result associated to the event if applicable. Applies mostly to import of data.
ResultCode	INT	Partial foreign key to ResultLookUp	Code of result associated to the event if applicable. Applies mostly to import of data.
Parameters	TEXT		Parameters associated with the event if applicable. Often usen in connection with searching for or importing data
Description	TEXT		Additional information in connection to the event if applicable. Often used in connection with creating new reords.
IPAddress	VARCHAR(50)		IPAddress of the web request initiating the event. Depending on network configuration (routers, firewalls, DHCP, etc.), this may identy the client PC that initiated the event.
SessionId	VARCHAR(50)		Id of the session in which the event took place.

Relations

Table	Key fields	Description
Employee	UserId	Identifies user
Employee	EmployeeId	Identifies the employee being created/updated/deleted.
Patient	PatientId	Identifies the patient
OrgUnit	OrgUnitType, OrgUnitCode	Organizational unit associated to the event
DataDictionary	TableName	The datadictionary (dynamic) table associated to the event
LogActionType	ActionType	The type of the action
ResultLookUp	ResultType, ResultCode	N:1 relation - the result associated to the event