DeliveredService

This entity holds information about delivered services added to Visits.

Branch

Type: DataConnect.Branch

BranchKey

Reference to the Branch identifier 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

DeliveredServiceKey

Reference to the Delivered Service Identifier in the Delivered Service dimension table.

Type: Edm.Int64

Id

The Delivered Service identifier.

Type: Edm.Int32

Outcome

Type: DataConnect.Outcome

OutcomeKey

Reference to the id of an Outcome in the Outcome dimension table.

Type: Edm.Int64

Queue

Type: DataConnect.Queue

QueueKey

Reference to the id of an Queue in the Queue dimension table.

Type: Edm.Int64

QueueType

Type: DataConnect.QueueType

QueueTypeKey

Reference to the id of an Queue Type in the Queue Type dimension table.

Type: Edm.Int32

Service

Type: DataConnect.Service

ServiceDelivered

Type: DataConnect.ServiceDelivered

ServiceKey

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

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

Staff

Type: DataConnect.Staff

StaffKey

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

Type: Edm.Int32

Time

Type: DataConnect.DeliveredServiceTime

TimeKey

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

Type: Edm.Int32

TimeSeconds

The seconds part of the time stamp.

Type: Edm.Int32

TransactionTime

The transaction time is from the Customer was called and until the Delivered Service was added, or between two added Delivered Services. The Delivered Service is added after it has been delivered.

Type: Edm.Int64

Visit

Type: DataConnect.Visit

VisitKey

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

Type: Edm.Int64

WaitingTime

There is no unique waiting time for a delivered service. It is the same as the for the transaction (FactVisitTransaction).

Type: Edm.Int64