Table – ActiveSessions

Purpose

Tracks which users currently have active sessions within the framework.

Every time the user interacts with the framework, the ActiveSessions table is queried by the GI_ValidateSession TSQL Stored Procedure to determine whether the session is still active and the Expires field is updated.

If a user does not interact with the framework before the Expires timestamp, then the user is signed out of the session and will need to re-authenticate.

Definition

CREATE TABLE [dbo].[ActiveSessions](
	[SessionGUID] [UNIQUEIDENTIFIER] NOT NULL,
	[UserGUID] [UNIQUEIDENTIFIER] NOT NULL,
	[Expires] [DATETIME2](7) NOT NULL,
	[TimeZoneOffset] [INT] NULL,
 CONSTRAINT [PK_ActiveSessions] PRIMARY KEY CLUSTERED 
(
	[SessionGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

Column Definitions

The combination of SessionGUID and UserGUID uniquely identifies an active session within the framework. SessionGUID is randomly generated when a user authenticates and the UserGUID is the InstanceGUID of the user’s record.

The Expires indicates when the active session will time out if the user is not interacting with the framework. The period of activity is determined by the GI_ValidateSession TSQL Stored Procedure and is set by default to four hours.

The TimeZoneOffset tracks the difference in seconds between the user’s local time and the UTC time tracked within the framework.