SESSION_PROPERTY
The SESSION_PROPERTY table contains the session properties, and is populated whenever there is new session data in either the SESSION_ATTRIBUTES or SESSION_HISTORY tables.
| Column name | Data type | Null (Y or N) | Key (PK or FK) | Comment |
|---|---|---|---|---|
| APP_NAME | VARCHAR(256) | N | PK | The name of the application. |
| CLUSTER_NAME | VARCHAR(128) | N | PK | The name of the cluster. |
| SESSION_ID | NUMERIC(10) | N | PK | The unique session ID. |
| SUBMISSION_USER | VARCHAR(128) | N | PK | The user name of the account client application used to create this session. |
| TIME_STAMP_GMT | NUMERIC(13) | N | PK | The record sample time in the time zone. This is the number of milliseconds from midnight, 1 January, 1970. |
| CONSUMER_NAME | VARCHAR(4000) | N | Not applicable | The name of the consumer. This is the fully-qualified consumer name. |
| SERVICE | VARCHAR(256) | Y | Not applicable | The name of this service. |
| SESSION_NAME | VARCHAR(256) | Y | Not applicable | The name of this session. |
| SESSION_TAG | VARCHAR(128) | Y | Not applicable | The tag given to a group of sessions belonging to a particular application. |