Turn Aways Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Tracks guest turn-away events when appointments could not be fulfilled, including the reason, associated appointment details, service, therapist, and estimated lost revenue.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| turnawaywid | BIGINT IDENTITY | NOT NULL | Surrogate key for the turn-away fact record. |
| factsegmentid | BIGINT | NULL | Business/natural key for the fact segment. |
| centerwid | BIGINT | NULL | Foreign key to the center dimension. |
| turnawayid | VARCHAR(36) | NULL | Unique identifier (GUID) of the turn-away record. |
| userwid | BIGINT | NULL | Foreign key to the guest/customer user dimension. |
| appointmentstarttimeincenter | TIMESTAMP | NULL | Appointment start time in center timezone. |
| appointmentstartdateincenter | TIMESTAMP | NULL | Appointment start date in center timezone. |
| appointmentendtimeincenter | TIMESTAMP | NULL | Appointment end time in center timezone. |
| appointmentenddateincenter | TIMESTAMP | NULL | Appointment end date in center timezone. |
| turnawayreasonwid | BIGINT | NULL | Foreign key to the turn-away reason dimension. |
| comments | VARCHAR(16000) | NULL | Comments or notes about the turn-away. |
| createdbywid | BIGINT | NULL | Foreign key to the user who created the record. |
| turnawaystatus | VARCHAR(30) | NULL | Status of the turn-away record. |
| turnawaydatetimeincenter | TIMESTAMP | NULL | Turn-away date and time in center timezone. |
| turnawaydateincenter | TIMESTAMP | NULL | Turn-away date in center timezone. |
| appointmentid | VARCHAR(36) | NULL | GUID of the associated appointment. |
| void | BOOLEAN | NULL | Indicates whether the record has been voided. |
| podid | BIGINT | NULL | Identifier of the source pod/database. |
| createddatetimeincenter | TIMESTAMP | NULL | Record creation date and time in center timezone. |
| createddateincenter | DATE | NULL | Record creation date in center timezone. |
| servicewid | BIGINT | NULL | Foreign key to the service dimension. |
| therapistwid | BIGINT | NULL | Foreign key to the therapist/provider user dimension. |
| serviceprice | DOUBLE PRECISION | NULL | Price of the service that was turned away (estimated lost revenue). |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
turnawaywid
Foreign Keys
| Column | References |
|---|---|
| centerwid | Bi_DimCenter.centerwid |
| userwid | Bi_DimUser.userwid |
| therapistwid | Bi_DimUser.userwid |
| createdbywid | Bi_DimUser.userwid |
| createddateincenter | Bi_DimDate.datewid |
| turnawaydateincenter | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| turnawaystatus | Active Resolved Converted |
| void | FALSE = Active, TRUE = Voided |
Was this article helpful?
Your feedback helps us improve our documentation.