ZenotiHelp

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.