ZenotiHelp

Appointment Multiple Employee Fact Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Records appointment segments involving multiple employees (therapists), tracking service assignments, commission, pricing, and cost breakdowns per employee.

Columns

Column Name Data Type Nullable Description
FactSegmentWID BIGINT IDENTITY NOT NULL Surrogate warehouse key for the appointment segment record.
FactSegmentId BIGINT NULL Source system identifier for the appointment segment.
AppGroupID VARCHAR(36) NULL Application group identifier for the appointment.
AppointmentID VARCHAR(36) NULL Unique identifier of the appointment in the source system.
TherapistWID BIGINT NULL Warehouse key referencing the therapist (employee) dimension.
ServiceWID BIGINT NULL Warehouse key referencing the service dimension.
CenterWID BIGINT NULL Warehouse key referencing the center dimension.
InvoiceItemID VARCHAR(36) NULL Unique identifier of the invoice item in the source system.
InvoiceID VARCHAR(36) NULL Unique identifier of the invoice in the source system.
ParentAppointmentID VARCHAR(36) NULL Identifier of the parent appointment for grouped appointments.
AppointmentStatusType INT NULL Status type code of the appointment.
CancelOrNoShowStatus INT NULL Status code indicating cancellation or no-show reason.
PrimaryEmp BOOLEAN NULL Indicates if this employee is the primary therapist for the appointment.
Commission FLOAT NULL Commission amount earned by the employee.
PackageType INT NULL Type code of the package associated with the appointment.
ItemListPrice FLOAT NULL List price of the service item.
ServiceNewGuestCost FLOAT NULL Cost of the service for new guests.
ServiceShopCost FLOAT NULL Shop cost of the service.
ServiceLabourCost FLOAT NULL Labour cost of the service.
EmpServiceNewGuestCost FLOAT NULL Employee-specific new guest cost for the service.
EmpServiceShopCost FLOAT NULL Employee-specific shop cost for the service.
EmpServiceLabourCost FLOAT NULL Employee-specific labour cost for the service.
IsBundlePackage BOOLEAN NULL Indicates if the appointment is part of a bundle package.
Quantity INT NULL Quantity of services in the appointment.
void INT NULL Flag indicating whether the record is voided (soft delete).

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

FactSegmentWID

Foreign Keys

Column References
TherapistWID Bi_DimUser.userwid
CenterWID Bi_DimCenter.centerwid

Enumerator Values

Column Values
AppointmentStatusType -2 = No Show
-1 = Cancelled
0 = New/Open
1 = Closed
2 = Checkin
4 = Confirm
5 = Cancel
6 = Deleted
7 = Void
CancelOrNoShowStatus -2 = No Show
-1 = Cancelled
0 = New/Open
1 = Closed
2 = Checkin
4 = Confirm
5 = Cancel
6 = Deleted
7 = Void
10 = Noshow (Redo Penalty)
11 = Cancelled (Redo Penalty)
12 = Closed (Redo Penalty)
PackageType 4 = Series Package
5 = Day/Promo Package
void 0 = Active, 1 = Voided
Was this article helpful?
Your feedback helps us improve our documentation.