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.