Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

sessn

  • Last UpdatedNov 20, 2024
  • 2 minute read

The sessn table contains details of which client sessions are currently active for each license type. The user_id field is populated with the current user on the session – needed as Operator clients may have multiple users logged on concurrently.

The client_address and reqd_events are for future use to allow the client to subscribe to certain events detected by the middleware.

This table was renamed from "session" to "sessn" in v2.0 as "session" is a reserved word in Oracle.

Field

Datatype

PK

Nulls

Description

client_type

int32

N

N

Note: The client type enumerations are no longer used.

Client EXE type for licensing control.

Enumerations are:

Configurator = 35 (this application was deprecated in MES 6.1)

Supervisor = 36 (this application was deprecated in MES 23.1)

Operator = 37

Background Process = 53

Data Editor = 54 (this application was deprecated in MES 23.1)

Scheduler = 57 (this application has been deprecated)

NDT = 63

UtilizationCapability = 64

OperationsCapability = 65

SampleRecording = 68

session_start

tdatetime

N

N

Datetime the session started in UTC

last_heartbeat

tdatetime

N

N

Last time heartbeat was refreshed in UTC – needed to automatically kill orphaned sessions without manually running a ‘Cleanup’ process

user_id

string40

N

Y

Active user on the session – can be changed with LogOn or SwitchUser. Updated when multiple users share a session,e.g., in Operator.

client_address

string40

N

Y

Sockets address for event notifications or middleware callbacks in the future.

Note: This field is currently not used.

reqd_events

string1700

N

Y

XML string representing which events client wants to be informed of.

Note: This field is currently not used.

tz_bias

int32

N

N

The difference in minutes between the client’s current local time and UTC. Default = 0.

Note: The region_id makes this obsolete.

std_time

logical

N

N

Whether the client is currently in standard time. Default = Yes.

Note: The region_id makes this obsolete.

session_id

ID 1

Y

N

Unique ID to identify session

region_id

string80

N

Y

The ID that defines the client’s current region.

FK from user_id to user_name. (Inhibit delete)

TitleResults for “How to create a CRG?”Also Available in