ZenotiHelp

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.