ZenotiHelp

Deleted Appointment Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Records details of deleted appointments including the service, guest, therapist, associated invoice, and timestamps for creation, modification, and scheduled start/end times.

Columns

Column Name Data Type Nullable Description
factsegmentwid BIGINT IDENTITY NOT NULL Surrogate key for the deleted appointment fact record
factsegmentid INTEGER NULL Business/natural key for the fact segment
appointmentpk INTEGER NULL Source system primary key for the appointment
appointmentid VARCHAR(36) NULL Unique identifier (GUID) of the appointment
servicewid BIGINT NULL Foreign key to the service dimension
centerwid BIGINT NULL Foreign key to the center dimension
userwid BIGINT NULL Foreign key to the guest/customer user dimension
therapistwid BIGINT NULL Foreign key to the therapist/provider user dimension
modifiedbywid BIGINT NULL Foreign key to the user who last modified the record
createdbywid BIGINT NULL Foreign key to the user who created the record
invoice_no VARCHAR(40) NULL Human-readable invoice number
invoiceid VARCHAR(36) NULL Unique identifier (GUID) of the invoice
invoiceitemid VARCHAR(36) NULL Unique identifier (GUID) of the invoice item
modifieddatetimeincenter TIMESTAMP NULL Modification date and time in center timezone
modifieddateincenter DATE NULL Modification date in center timezone
createddatetimeincenter TIMESTAMP NULL Creation date and time in center timezone
createddateincenter DATE NULL Creation date in center timezone
startdatetimeincenter TIMESTAMP NULL Appointment start date and time in center timezone
enddatetimeincenter TIMESTAMP NULL Appointment end date and time in center timezone
startdateincenter DATE NULL Appointment start date in center timezone
enddateincenter DATE NULL Appointment end date in center timezone
comments VARCHAR(65535) NULL Comments or notes about the deleted appointment
podid INTEGER NULL Identifier of the source pod/database
void BOOLEAN NULL Indicates whether the record has been voided

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
centerwid Bi_DimCenter.centerwid
userwid Bi_DimUser.userwid
therapistwid Bi_DimUser.userwid
modifiedbywid Bi_DimUser.userwid
createdbywid Bi_DimUser.userwid
modifieddateincenter Bi_DimDate.datewid
createddateincenter Bi_DimDate.datewid
startdateincenter Bi_DimDate.datewid
enddateincenter Bi_DimDate.datewid

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.