StaffSession

Contains the sessions of the users (Staff).

Branch

Type: DataConnect.Branch

BranchKey

Reference to the id of a Branch in the Branch Dimension table.

Indicates that this entry is a Branch, not a Branch Group. If this value is NULL, the entry is a Branch Group.

Type: Edm.Int64

Date

Type: DataConnect.Date

DateKey

Date for when the delivered service was added.

Type: Edm.Int32

EndTime

Type: DataConnect.StaffSessionEndTime

EndTimeKey

The end time for the Staff Session.

Type: Edm.Int32

EndTimestamp

The time stamp for the end of the Staff Session.

Type: Edm.DateTimeOffset

Id

The Staff Session identifier.

Type: Edm.Int32

IdleTime

The part of the session time not spent on any Customer.

Type: Edm.Int64

ServedCount

The number of Customers that were served during the session.

Type: Edm.Int32

ServingTime

The part of the session time that was transaction time.

Type: Edm.Int64

SessionOutcomeKey

Reference to the id of a Staff Session Outcome in the Staff Session Outcome dimension table.

Type: Edm.Int32

Staff

Type: DataConnect.Staff

StaffKey

Reference to the id of a Staff in the Staff dimension table.

Type: Edm.Int64

StaffSessionOutcome

Type: DataConnect.StaffSessionOutcome

StartTime

Type: DataConnect.StaffSessionStartTime

StartTimestamp

The timestamp for the start of the Staff Session.

Type: Edm.DateTimeOffset

StoreNextTime

The time, in seconds, that the Staff member spent in store next during the session.

Type: Edm.Int32

TimeKey

Reference to the id of a Time in the Time dimension table.

Type: Edm.Int32

TimeSeconds

The time, in seconds, that the staff member spent in store next during the session.

Type: Edm.Int32

TotalTime

The session time.

Type: Edm.Int64

VisitsServed

The number of transactions during the session, no matter of the outcome - for example, no shows are included.

Type: Edm.Int64

WrapupTime

The total wrap-up time for all transactions within the Staff Session.

Type: Edm.Int64