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)