VisitTransaction

Branch

Type: DataConnect.Branch

BranchKey

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

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

CallTime

Type: DataConnect.CallTime

CallTimeKey

Reference to a Call Time identifier in the Call Time dimension table.

Type: Edm.Int32

CallTimeOfDay

The time that a Customer was called.

Type: Edm.Int64

CallTimestamp

The timestamp for when the Customer was called.

Type: Edm.DateTimeOffset

Date

Type: DataConnect.Date

DateKey

Reference to a Date identifier in the Date dimension table.

Type: Edm.Int32

EndTime

Type: DataConnect.EndTime

EndTimeKey

Reference to an End Time identifier in the End Time dimension table.

Type: Edm.Int32

EndTimeOfDay

The Visit Transaction end time.

Type: Edm.Int64

EnterQueueTimeOfDay

The time that a Customer entered the Queue.

Type: Edm.Int64

EnteredQueueTime

Type: DataConnect.EnteredQueueTime

EnteredQueueTimeKey

Reference to an Entered Queue Time identifier in the Entered Queue Time dimension table.

Type: Edm.Int32

EnteredQueueTimestamp

The timestamp for when a Customer entered the Queue.

Type: Edm.DateTimeOffset

EntryPoint

Type: DataConnect.EntryPoint

EntryPointKey

Reference to an Entry Point identifier in the Entry Point dimension table.

Type: Edm.Int64

Id

The Visit transaction identifier.

Type: Edm.Int32

IsAppointment

Shows if the Visit is an Appointment or not.

Type: Edm.Boolean

Outcome

Type: DataConnect.Outcome

OutcomeKey

Reference to an Outcome identifier in the Outcome dimension table.

Type: Edm.Int64

Queue

Type: DataConnect.Queue

QueueKey

Reference to a Queue identifier in the Queue dimension table.

Type: Edm.Int64

QueueType

Type: DataConnect.QueueType

QueueTypeKey

Reference to a Queue Type identifier in the Queue Type dimension table.

Type: Edm.Int64

RecycleCount

The number of times the transaction was recycled. A recycle does not result in a new transaction.

Type: Edm.Int32

Service

Type: DataConnect.Service

ServiceKey

ServiceKey remains for backwards compatibility and is populated with the id for the first service if it is a multi service Appointment.

Type: Edm.Int64

ServicePoint

Type: DataConnect.ServicePoint

ServicePointKey

Reference to the id of an Service Point in the Service Point dimension table.

Type: Edm.Int64

ServiceTransactionTimeLevel

The Transaction Time Service Level, in seconds, from the Service configuration in the Business Configuration.

Type: Edm.Int64

Staff

Type: DataConnect.Staff

StaffKey

Reference to a Staff identifier in the Staff dimension table.

Type: Edm.Int64

StaffTransactionTime

The transaction time for a staff member is the total time spent for Customer transactions including store next, walk time, face-to-face time and wrap- up time.

Type: Edm.Int64

TimeSeconds

The seconds part of the time stamp.

Type: Edm.Int32

TransactionTime

The time from the Customer call was shown on the main display, until the transaction ends (next Customer is called, Visit ends, Customer is transferred to another Queue or Counter is closed) Note that the last VISIT_CALL is used when recall has been used (recall time is not included in the transaction time).

Type: Edm.Int64

TransactionTimeVsServiceLevel

The relationship between the Transaction Time and the Service Level, i.e. if the Transaction Time is Above or Below the Service Level.

Type: Edm.String

VerticalMessageKey

Reference to a Vertical Message in the Vertical Message dimension table.

This table holds information about Vertical Messages that are configured in the Surface Editor and Context Marketing applications. Every time a new or updated Vertical Message is encountered in an inserted Visit, a new entry is generated in the table. When a Vertical Message is updated, an end date will be set to the previous version.

Type: Edm.Int64

Visit

Type: DataConnect.Visit

VisitCallType

Type: DataConnect.VisitCallType

VisitCallTypeKey

This is how the Customer was called and is only valid for events calling Customers, otherwise it is NULL.

Type: Edm.Int64

VisitKey

The Visit key is unique for the Visit (ticket number).

Type: Edm.Int64

VisitOutcome

Type: DataConnect.VisitTransactionOutcome

VisitOutcomeKey

The outcome of the transaction. There is only a value for events that ended a transaction, otherwise it is NULL.

Type: Edm.Int64

WaitingTime

Single Service: The time from the customer entered the queue by taking a ticket or a transfer and until the call is shown on the main display

Multi Service: This is when multiple Services are delivered in the same transaction. The waiting time for the first transaction is the same as described above. For the following transactions, started with the ADD_SERVICE event, the waiting time is NULL because the Customer was not in any Queue before being served.

Type: Edm.Int64

WaitingTimeServiceLevel

The Waiting Time Service Level, in seconds, from the Queue configuration in the Business Configuration. This is 0 when the Customer is called from a Service Point Pool, or a Staff Pool.

Type: Edm.Int64

WaitingTimeVsServiceLevel

The relationship between the Waiting Time and the Service Level, i.e. if the Waiting Time is Above or Below the Service Level.

Type: Edm.String

WalkingTime

The time from the call was shown on the main display and until the Customer arrived to the Counter.

Type: Edm.Int64

WorkProfile

Type: DataConnect.WorkProfile

WorkProfileKey

Reference to a Work Profile identifier in the Work Profile dimension table.

The Work Profile key has a value for the SET_WORK_PROFILE event and the ADD_USER_TO_STORE_NEXT event, otherwise it is NULL.

Type: Edm.Int64

WrapupTime

The time from wrap-up started and until the transaction ended.

Type: Edm.Int64