Session Manager Tables

These tables are specific to the Session Manager extension and may not be edited.

MM_SESSION

The fields in this table appear in the user control for a session (Figure 1).

SESSION_ID

A primary key for the session. This field also acts as a foreign key for the MM_PX_SESSION_VERSIONS table.

SESSION_NAME

The user-assigned name of the session. This field contains the value entered in the Session Name field in Session Manager.

CREATE_USER

The name of the user who created the session.

CURRENT_OWNER

The name of the user who is responsible for the Session in its current state.

CREATE_DATE

The date that the session was created. This field is populated automatically.

DESCRIPTION

The user-entered description of the session. This field contains the information entered in the Description field in Session Manager.

HIDDEN

This field allows you to determine whether the node is visible to the user. 0 = visible, any other value = hidden.

DATABASE_ID

A unique identifier for Process Framework database from which the design originated. This value matches the value in the DATABASE_ID field of the MM_PX_DB_VERSION table. This is used only by Mobile.

ENTERPRISE_ID

A unique identifier for the enterprise database. This field is used only by Mobile.

SESSION_TYPE_ID

This field refers to the ID field in the MM_SESSION_TYPE table.

Figure 1, Session Manager user control

MM_SESSION_DB_VERSION

This table is for Schneider Electric internal use only. It holds the version of the Session Manager tables.

MM_SESSION_TYPE

This table holds a list of the possible types of Sessions that may be created. Values provided in the sample data are: Electric, Gas, Water.

ID

The primary key for the session type and a unique identifier for each possible session type.

SESSION_TYPE

The name of the session type as displayed in the Session Type menu.

Figure 2, The Session Type field.

MM_SESSION
The fields in this table appear in the user control for a session (Figure 1).
SESSION_ID	A primary key for the session. This field also acts as a foreign key for the MM_PX_SESSION_VERSIONS table.
SESSION_NAME	The user-assigned name of the session. This field contains the value entered in the Session Name field in Session Manager.
CREATE_USER	The name of the user who created the session.
CURRENT_OWNER	The name of the user who is responsible for the Session in its current state.
CREATE_DATE	The date that the session was created. This field is populated automatically.
DESCRIPTION	The user-entered description of the session. This field contains the information entered in the Description field in Session Manager.
HIDDEN	This field allows you to determine whether the node is visible to the user. 0 = visible, any other value = hidden.
DATABASE_ID	A unique identifier for Process Framework database from which the design originated. This value matches the value in the DATABASE_ID field of the MM_PX_DB_VERSION table. This is used only by Mobile.
ENTERPRISE_ID	A unique identifier for the enterprise database. This field is used only by Mobile.
SESSION_TYPE_ID	This field refers to the ID field in the MM_SESSION_TYPE table.

MM_SESSION_DB_VERSION
This table is for Schneider Electric internal use only. It holds the version of the Session Manager tables.

MM_SESSION_TYPE
This table holds a list of the possible types of Sessions that may be created. Values provided in the sample data are: Electric, Gas, Water.
ID	The primary key for the session type and a unique identifier for each possible session type.
SESSION_TYPE	The name of the session type as displayed in the Session Type menu.