Appointment
For every Appointment that is created, there is an entity here. When the appointment is updated, the entity is updated with the new information. An Appointment that was served in a Visit is included in the stat message for the Visit and is inserted after the VisitTransaction table has been updated.
AppointmentCustomers
Type: DataConnect.AppointmentCustomer
AppointmentDuration
Number of minutes that the Appointment was planned to take.
Type: Edm.Int64
AppointmentService
Type: DataConnect.AppointmentService
AppointmentStatusKey
Note: The Appointment status is never updated from CREATED if the Visit is never put in an Appointment Queue.
Type: Edm.Int32
ArrivalStatus
Type: DataConnect.AppointmentArrivalStatus
ArrivalStatusKey
Reference to the id of the Arrival Status in the table dim_arrival_status.
Type: Edm.Int32
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
CancelledDate
Type: DataConnect.AppointmentCancelledDate
CancelledDateKey
The date when the Appointment was canceled.
Type: Edm.Int32
ClientKey
Reference to the id of an entry in the table dim_client which holds the license.
Type: Edm.Int64
CountServices
The number of Services that were delivered.
Type: Edm.Int32
CreatedDate
Type: DataConnect.AppointmentCreatedDate
CreatedDateKey
The date when the Appointment was created (booked).
Type: Edm.Int32
CreatedTime
Type: DataConnect.AppointmentCreatedTime
CreatedTimeKey
Timestamp for when the Appointment was created (booked).
Type: Edm.Int32
Date
Type: DataConnect.Date
DateKey
Date for the Appointment.
Type: Edm.Int32
DaysCancelledBefore
Number of days before the Appointment start time that it was cancelled.
Type: Edm.Int32
DaysToAppointment
The number of days between when the Appointment was booked and the Appointment start time.
Type: Edm.Int64
EndTime
Type: DataConnect.AppointmentEndTime
EndTimeKey
End time for the Appointment.
Type: Edm.Int32
Id
The appointment identifier.
Type: Edm.Int32
Lateness
The time from when the Appointment should have started until the Customer was called.
Type: Edm.Int64
OriginId
The unique id for the Appointment, used to keep track of changes. This value is never changed.
Type: Edm.Int64
Resource
Type: DataConnect.Resource
ResourceKey
The Id of the Resource that was assigned to the Appointment.
Type: Edm.Int64
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
StartTime
Type: DataConnect.AppointmentStartTime
StartTimeKey
The start time for the Appointment.
Type: Edm.Int32
Status
Type: DataConnect.AppointmentStatus
Tardiness
The time from when the Customer arrived, until the Appointment should have started. This is always a positive value.
Note: Only used for backward compatibility. Lateness should be used instead!
Type: Edm.Int64
TransactionTime
The sum of all transaction times within the Appointment (with the same Appointment.Id)
Type: Edm.Int64
UpdatedCount
The number of times this Appointment has been changed (for example rescheduled).
Type: Edm.Int32
WaitingTime
The waiting time for the Appointment. The waiting time is exactly the same as for the Visit transaction (an Appointment becomes a Visit when the Customer arrives).
Type: Edm.Int64
WalkingTime
The walking time for the first transaction in the Appointment. We assume that all other transactions were delivered within the same Appointment, without any walking times.
Type: Edm.Int64
WrapupTime
The total wrap-up time for all transactions within the Appointment.
Type: Edm.Int64