osevents

The column list comes from the schema dump; the column meanings have been derived from the JSON returned by dms.GetOsEvents and the input parameters of dms.CreateOsEvent / dms.UpdateOsEvent. A few columns remain marked as uncertain.

Holds the OS events defined in the enaio® application. One entry per event with the event type (eventcode), the target object type (osclassname), the script code (vbcode) and an optional context parameter (oseventparams). Meaning of the individual values, lifecycle and the full format of the JSON representation: see OS events in the DMS reference.

DMS API read path: dms.GetOsEvents; write paths: dms.CreateOsEvent / dms.UpdateOsEvent / dms.DeleteOsEvent.

1. Columns

Name Type Length Description

id

int

—

Primary key — corresponds to the field id in the JSON returned by dms.GetOsEvents. Used by dms.UpdateOsEvent and dms.DeleteOsEvent as OsEventId.

eventcode

int

—

Event type — determines when the script is executed. Corresponds to the JSON field event_code. Can be resolved against oseventcodes.eventcode. Full value list: event code list.

osclassname

nvarchar

100

Target object type — "Application" for server- or application-wide events, otherwise the type_id of the object type as a string. Corresponds to the JSON field os_class_name.

oseventpos

int

—

UI context as a numeric representation (1 = query, 2 = application, 3 = data sheet, 5 = object type, 6 = bulk change, 7 = cabinet, 8 = server events, 9 = result list). Redundant with eventcode. Corresponds to the JSON field object_class.

osuserid

int

—

Numeric user ID — presumably the user who last edited the event (internal ID matching the login name in modifyuser). Exact semantics not fully confirmed.

oseventtype

int

—

Target platform as a numeric representation (1 = client, 2 = server, 3 = WebClient). Corresponds to the JSON field app_class.

vbcode

image

max

Executable script code of the event. Despite the column name, the content can be either VBScript or JavaScript — see field vb_code and field is_js. Whether and where is_js is stored separately in osevents is not unambiguously identified — for JavaScript libraries (eventcode 10005/10006) and WebClient events (eventcode 11000–11024) the script language is implicitly JS.

oseventparams

nvarchar

100

Context parameter — content depends on the eventcode: field GUID, job name or library name. Corresponds to the JSON field os_event_params. Full mapping: os_event_params — mapping.

lastmodified

int

—

Unix timestamp (seconds since 1970-01-01 UTC) of the last modification. Corresponds to the JSON field last_modified.

modifyuser

nvarchar

255

Login name of the user who last edited (created or modified) the event. Corresponds to the JSON field modify_user.

2. Related Tables

  • oseventcodes — lookup table of all known event codes with name, objectclass (as text) and appclass (as text).

  • oseventaccess — access permissions on events per user/group (eventid → osevents.id).

3. Usage by Server API jobs