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.