Appointment Fact Table
ZTZenoti Docs Team Updated April 10, 2026 6 min readGuide
Stores appointment-level detail including scheduling, service delivery, therapist assignment, feedback scores, rebook tracking, and cancellation/no-show information.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factappointmentwid | BIGINT IDENTITY | No | Surrogate primary key (auto-generated) |
| factappointmentid | INTEGER | Yes | Source system identifier for the appointment fact |
| centerwid | BIGINT | Yes | Foreign key to the center dimension |
| userwid | BIGINT | Yes | Foreign key to the guest/user dimension |
| therapistwid | BIGINT | Yes | Foreign key to the therapist (user) dimension |
| servicewid | BIGINT | Yes | Foreign key to the service dimension |
| appointmentpk | INTEGER | Yes | Source primary key of the appointment |
| appgrouppk | INTEGER | Yes | Source primary key of the appointment group |
| invoice_no | VARCHAR(40) | Yes | Human-readable invoice number |
| invoiceid | VARCHAR(36) | Yes | Unique identifier (GUID) of the related invoice |
| starttimeincenter | TIMESTAMP | Yes | Appointment start time in center timezone |
| endtimeincenter | TIMESTAMP | Yes | Appointment end time in center timezone |
| startdateincenter | DATE | Yes | Appointment start date in center timezone |
| enddateincenter | DATE | Yes | Appointment end date in center timezone |
| serviceminutes | INTEGER | Yes | Duration of the service in minutes |
| resourcewid | BIGINT | Yes | Foreign key to the resource (room/bed) dimension |
| appstatuswid | BIGINT | Yes | Foreign key to the appointment status dimension |
| isrebookwid | BIGINT | Yes | Boolean WID flag indicating if this is a rebook |
| rebookedappointmentpk | NUMERIC(19,0) | Yes | Source PK of the rebooked appointment |
| therapistrequesttype_statuswid | BIGINT | Yes | Foreign key to therapist request type/status dimension |
| servicesoldcount | INTEGER | Yes | Count of services sold in this appointment |
| isaddonservicewid | BIGINT | Yes | Boolean WID flag indicating if this is an add-on service |
| isaddon | INTEGER | Yes | Flag indicating if this is an add-on |
| podid | INTEGER | Yes | Pod identifier for multi-tenant partitioning |
| createdbywid | BIGINT | Yes | Foreign key to the user who created the appointment |
| soldbywid | BIGINT | Yes | Foreign key to the user who sold the appointment |
| isprimaryappointmentwid | BIGINT | Yes | Boolean WID flag indicating if this is the primary appointment |
| membergueststatuswid | BIGINT | Yes | Foreign key to the member/guest status dimension |
| void | BOOLEAN | Yes | Indicates if the record is voided |
| invoicestatus | SMALLINT | Yes | Enumerator for invoice status |
| closebywid | BIGINT | Yes | Foreign key to the user who closed the invoice |
| equipmentwid | BIGINT | Yes | Foreign key to the equipment dimension |
| saleprice | DOUBLE PRECISION | Yes | Sale price of the service |
| finalsaleprice | DOUBLE PRECISION | Yes | Final sale price after adjustments |
| taxes | DOUBLE PRECISION | Yes | Tax amount |
| discount | DOUBLE PRECISION | Yes | Discount amount applied |
| daypackageversionwid | BIGINT | Yes | Foreign key to the day package version dimension |
| isrebooktargetwid | BIGINT | Yes | Boolean WID flag indicating if this is a rebook target |
| appointmentsourcewid | BIGINT | Yes | Foreign key to the appointment source dimension |
| invoicecloseddatetimeincenter | TIMESTAMP | Yes | Invoice closed datetime in center timezone |
| invoicecloseddateincenter | DATE | Yes | Invoice closed date in center timezone |
| checkindatetime | TIMESTAMP | Yes | Guest check-in datetime |
| note | VARCHAR(8000) | Yes | Appointment notes |
| packagegroupno | INTEGER | Yes | Package group number |
| cancelledsource | INTEGER | Yes | Source that initiated the cancellation (enumerator) |
| actualstarttime | TIMESTAMP | Yes | Actual start time of the appointment |
| completedtime | TIMESTAMP | Yes | Time when the appointment was completed |
| feedbackwid | BIGINT | Yes | Foreign key to the feedback dimension |
| feedbackgiven | BOOLEAN | Yes | Flag indicating if feedback was provided |
| ambiencefdbk | INTEGER | Yes | Ambience feedback score |
| cleanlinessfdbk | INTEGER | Yes | Cleanliness feedback score |
| servicefdbk | INTEGER | Yes | Service quality feedback score |
| therapistfdbk | INTEGER | Yes | Therapist feedback score |
| avgfeedback | DOUBLE PRECISION | Yes | Average feedback score |
| recommended | BOOLEAN | Yes | Flag indicating if the guest recommended the service |
| sharefeedback | INTEGER | Yes | Flag/type for sharing feedback |
| feedbacknotes | VARCHAR(32000) | Yes | Free-text feedback notes from the guest |
| isappointmentrescheduled | SMALLINT | Yes | Flag indicating if the appointment was rescheduled |
| actualappointmenttime | TIMESTAMP | Yes | Originally scheduled appointment time |
| actionperformeddatetimeincenter | TIMESTAMP | Yes | Datetime when the action was performed in center timezone |
| creationdatetimeincenter | TIMESTAMP | Yes | Appointment creation datetime in center timezone |
| creationdateincenter | DATE | Yes | Appointment creation date in center timezone |
| cancelornoshowstatus | INTEGER | Yes | Enumerator for cancel or no-show status |
| rebookedappointmentcount | INTEGER | Yes | Count of rebooked appointments |
| appointmentcategorywid | BIGINT | Yes | Foreign key to the appointment category dimension |
| appointmentcancelreasonwid | BIGINT | Yes | Foreign key to the appointment cancel reason dimension |
| feedbackupdateddatetime | TIMESTAMP | Yes | Datetime when feedback was last updated |
| feedbackupdatedbywid | BIGINT | Yes | Foreign key to the user who updated the feedback |
| appointmentrecurrencewid | BIGINT | Yes | Foreign key to the appointment recurrence dimension |
| feedbacksourcewid | BIGINT | Yes | Foreign key to the feedback source dimension |
| rebookedsourceappointmentpk | BIGINT | Yes | Source PK of the original appointment that was rebooked |
| rebookedsourcegroupid | VARCHAR(36) | Yes | GUID of the original appointment group that was rebooked |
| appgroupid | VARCHAR(36) | Yes | GUID of the appointment group |
| feedbackversion | INTEGER | Yes | Version of the feedback form used |
| cancelledsourcewid | BIGINT | Yes | Foreign key to the cancelled source dimension |
| recoveryminutes | INTEGER | Yes | Recovery time in minutes between appointments |
| serviceinternalcost | DOUBLE PRECISION | Yes | Internal cost of the service |
| issegmented | INTEGER | Yes | Flag indicating if the appointment is segmented |
| issegment | INTEGER | Yes | Flag indicating if this is a segment |
| recurrenceappointmentgroupprimarykey | BIGINT | Yes | PK of the recurrence appointment group |
| recurrenceappointmentpk | BIGINT | Yes | PK of the recurrence appointment |
| recurrenceappointmentinvoiceno | VARCHAR(40) | Yes | Invoice number of the recurrence appointment |
| issurprise | INTEGER | Yes | Flag indicating if this is a surprise appointment |
| parentappointmentpk | BIGINT | Yes | PK of the parent appointment |
| isaddonprimaryappointmentpk | BIGINT | Yes | PK of the primary appointment for an add-on |
| servicesegmentwid | BIGINT | Yes | Foreign key to the service segment dimension |
| appointmentid | VARCHAR(36) | Yes | GUID of the appointment |
| InitialSuggestedStartTimeInCenter | TIMESTAMP | Yes | Initially suggested start time in center timezone |
| UtmSource | NVARCHAR(128) | Yes | UTM source for marketing attribution |
| UtmMedium | NVARCHAR(128) | Yes | UTM medium for marketing attribution |
| bundlepackageversionwid | BIGINT | Yes | Foreign key to the bundle package version dimension |
| bundlepackageno | INTEGER | Yes | Bundle package number |
| isqueue | BOOLEAN | Yes | Flag indicating if the appointment is from a queue |
| actualwaittimeinseconds | BIGINT | Yes | Actual wait time in seconds for queued appointments |
| initialpreferredtimeincenter | TIMESTAMP | Yes | Initial preferred time in center timezone |
| initialtherapistrequesttype_statuswid | INTEGER | Yes | Initial therapist request type/status |
| isredo | BOOLEAN | Yes | Flag indicating if this is a redo appointment |
| sourceappointmentid_redo | VARCHAR(36) | Yes | GUID of the source appointment for the redo |
| cancelledon | TIMESTAMP | Yes | Datetime when the appointment was cancelled |
| queueappointmenttype | INTEGER | Yes | Type of queue appointment (enumerator) |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factappointmentwid
Foreign Keys
| Column | References |
|---|---|
| centerwid | Bi_DimCenter.centerwid |
| userwid | Bi_DimUser.userwid |
| therapistwid | Bi_DimUser.userwid |
| createdbywid | Bi_DimUser.userwid |
| soldbywid | Bi_DimUser.userwid |
| closebywid | Bi_DimUser.userwid |
| feedbackupdatedbywid | Bi_DimUser.userwid |
| resourcewid | Bi_DimResource.resourcewid |
| startdateincenter | Bi_DimDate.datewid |
| enddateincenter | Bi_DimDate.datewid |
| creationdateincenter | Bi_DimDate.datewid |
| invoicecloseddateincenter | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| void | true = Voided, false = Active |
| feedbackgiven | true = Feedback given, false = No feedback |
| recommended | true = Recommended, false = Not recommended |
| issurprise | true = Surprise, false = Not a surprise |
| isqueue | true = Queue appointment, false = Regular |
| isredo | true = Redo, false = Not a redo |
| invoicestatus | 0 = Open 1 = Open 2 = Open 3 = Open 4 = Closed |
| cancelornoshowstatus | -2 = No Show -1 = Cancelled 0 = New/Open 1 = Closed 2 = Checkin 4 = Confirm 5 = Cancel 7 = Void 10 = Noshow (Redo Penalty) 11 = Cancelled (Redo Penalty) 12 = Closed (Redo Penalty) |
| cancelledsource | 0 = Store (MMS) 1 = Mobile 2 = Web 3 = Imports 4 = Offline 5 = Dunning 6 = Employee App 7 = Manager App 8 = Auto Collection 9 = Biometric App 10 = Support Login 11 = Take 5 12 = Therapist App Android 13 = Therapist App iOS 14 = Mobile POS (Point of Sale) Android 15 = Mobile POS iOS 16 = PoS 17 = Shopify 18 = ECommerce 19 = Instore App 20 = Api Direct 21 = Unknown 22 = Extension 23 = Queue 24 = Kiosk 25 = Kiosk CMA (Customer Mobile App) 26 = Kiosk Web 27 = Invoice Refund 28 = Membership Unfreeze 29 = Membership Cancellation 30 = External CMA 31 = External Webstore 32 = Client App 33 = Bot |
| queueappointmenttype | 0 = Group Booking 1 = Bulk Booking 2 = Single Booking 3 = Couple Booking 4 = Family Booking 11 = Class |
Was this article helpful?
Your feedback helps us improve our documentation.