Turnaway Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 5 min readGuide
Consolidated fact table storing turnaway (walk-out/missed appointment) events including guest, therapist, service details, and turnaway reasons.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization name | VARCHAR(512) | YES | Name of the organization. Sourced from DimOrganization.organization_name. |
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| center name | VARCHAR(128) | YES | Name of the center. Sourced from DimCenter.center_name. |
| center company name | VARCHAR(128) | YES | Company name associated with the center. Sourced from DimCenter.center_company_name. |
| is center franchise | BOOLEAN | YES | Indicates whether the center is a franchise location. Sourced from DimCenter.is_center_franchise. |
| center cstn number | VARCHAR(80) | YES | CSTN number of the center. Sourced from DimCenter.center_cstn_number. |
| center tin number | VARCHAR(80) | YES | TIN number of the center. Sourced from DimCenter.center_tin_number. |
| center tot number | VARCHAR(80) | YES | TOT number of the center. Sourced from DimCenter.center_tot_number. |
| center service tax number | VARCHAR(80) | YES | Service tax number of the center. Sourced from DimCenter.center_service_tax_number. |
| center vat number | VARCHAR(80) | YES | VAT number of the center. Sourced from DimCenter.center_vat_number. |
| center luxary tax number | VARCHAR(80) | YES | Luxury tax number of the center. Sourced from DimCenter.center_luxary_tax_number. |
| turnaway wid | BIGINT | YES | Warehouse ID for the turnaway record. |
| appointment start date time in center | TIMESTAMP WITHOUT TIME ZONE | YES | Start date and time of the original appointment in center local time. |
| appointment start date in center | DATE | YES | Start date of the original appointment in center local time. |
| appointment end date time in center | TIMESTAMP WITHOUT TIME ZONE | YES | End date and time of the original appointment in center local time. |
| appointment end date in center | DATE | YES | End date of the original appointment in center local time. |
| comments | VARCHAR(16000) | YES | Comments associated with the turnaway event. |
| turnaway status | VARCHAR(30) | YES | Status of the turnaway (e.g., Completed, Cancelled). |
| turnaway date time in center | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time when the turnaway occurred in center local time. |
| turnaway date in center | DATE | YES | Date when the turnaway occurred in center local time. |
| appointment id | VARCHAR(36) | YES | Unique identifier of the associated appointment. |
| void | BOOLEAN | YES | Indicates whether the turnaway record has been voided. |
| created date time in center | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time when the record was created in center local time. |
| created date in center | DATE | YES | Date when the record was created in center local time. |
| guest first name | VARCHAR(160) | YES | First name of the guest. Sourced from DimUser.firstname. |
| guest last name | VARCHAR(256) | YES | Last name of the guest. Sourced from DimUser.lastname. |
| guest middle name | VARCHAR(128) | YES | Middle name of the guest. Sourced from DimUser.middlename. |
| guest code | VARCHAR(128) | YES | Code assigned to the guest. Sourced from DimUser.usercode. |
| user wid | BIGINT | YES | Warehouse ID of the guest. Sourced from DimUser.userwid. |
| guest address 1 | VARCHAR(2048) | YES | Primary address of the guest. Sourced from DimUser.address1. |
| guest address 2 | VARCHAR(2048) | YES | Secondary address of the guest. Sourced from DimUser.address2. |
| guest city | VARCHAR(128) | YES | City of the guest. Sourced from DimUser.city. |
| guest zipcode | VARCHAR(128) | YES | ZIP/postal code of the guest. Sourced from DimUser.zipcode. |
| guest type name | VARCHAR(128) | YES | Type classification of the guest. Sourced from DimUser.usertypename. |
| guest email | VARCHAR(256) | YES | Email address of the guest. Sourced from DimUser.email. |
| guest mobile phone | VARCHAR(64) | YES | Mobile phone number of the guest. Sourced from DimUser.mobilephone. |
| guest home phone | VARCHAR(64) | YES | Home phone number of the guest. Sourced from DimUser.homephone. |
| guest phone code | INTEGER | YES | Phone country code of the guest. Sourced from DimUser.phonecode. |
| guest gender | VARCHAR(14) | YES | Gender of the guest. Sourced from DimUser.gender. |
| guest dob | TIMESTAMP WITHOUT TIME ZONE | YES | Date of birth of the guest. Sourced from DimUser.dob. |
| referred by guestid | VARCHAR(36) | YES | ID of the guest who referred this guest. Sourced from DimUser.referredby. |
| guest anniversary date | TIMESTAMP WITHOUT TIME ZONE | YES | Anniversary date of the guest. Sourced from DimUser.anniversarydate. |
| guest state | VARCHAR(4096) | YES | State of the guest. Sourced from DimUser.statedispname. |
| guest country name | VARCHAR(4096) | YES | Country of the guest. Sourced from DimUser.countrydname. |
| is guest inactive | BOOLEAN | YES | Indicates whether the guest is inactive. Sourced from DimUser.void. |
| guest tags | VARCHAR(65535) | YES | Tags associated with the guest. Sourced from DimUser.usertags. |
| createdby employee first name | VARCHAR(160) | YES | First name of the employee who created the turnaway. Sourced from DimEmployee.employee_first_name. |
| createdby employee last name | VARCHAR(256) | YES | Last name of the employee who created the turnaway. Sourced from DimEmployee.employee_last_name. |
| createdby employee middle name | VARCHAR(128) | YES | Middle name of the employee who created the turnaway. Sourced from DimEmployee.employee_middle_name. |
| createdby employee mobile phone | VARCHAR(64) | YES | Mobile phone of the employee who created the turnaway. Sourced from DimEmployee.employee_mobile_phone. |
| createdby employee code | VARCHAR(128) | YES | Code of the employee who created the turnaway. Sourced from DimEmployee.employee_code. |
| createdby employee - code | VARCHAR(128) | YES | Alternate code format for the creating employee. Sourced from DimEmployee.employee_code. |
| createdby employee gender | VARCHAR(14) | YES | Gender of the employee who created the turnaway. Sourced from DimEmployee.employee_gender. |
| createdby employee job name | VARCHAR(1020) | YES | Job title of the creating employee. Sourced from DimEmployee.employee_job_name. |
| createdby employee job code | VARCHAR(8000) | YES | Job code of the creating employee. Sourced from DimEmployee.employee_job_code. |
| is createdby employee inactive | BOOLEAN | YES | Indicates whether the creating employee is inactive. Sourced from DimEmployee.is_employee_inactive. |
| createdby employee tags | VARCHAR(65535) | YES | Tags associated with the creating employee. Sourced from DimEmployee.employee_tags. |
| turnaway reason code | VARCHAR(1024) | YES | Code for the turnaway reason. |
| turnaway reason | VARCHAR(65535) | YES | Description of the turnaway reason. |
| minutes to add | INTEGER | YES | Time zone offset in minutes to convert to center local time. |
| therapist id | VARCHAR(256) | YES | Unique identifier of the assigned therapist. Sourced from DimEmployee.employee_id. |
| therapist first name | VARCHAR(256) | YES | First name of the assigned therapist. Sourced from DimEmployee.employee_first_name. |
| therapist last name | VARCHAR(256) | YES | Last name of the assigned therapist. Sourced from DimEmployee.employee_last_name. |
| therapist middle name | VARCHAR(256) | YES | Middle name of the assigned therapist. Sourced from DimEmployee.employee_middle_name. |
| therapist code | VARCHAR(128) | YES | Code of the assigned therapist. Sourced from DimEmployee.employee_code. |
| therapist employee - code | VARCHAR(128) | YES | Alternate code format for the therapist. Sourced from DimEmployee.employee_code. |
| therapist gender | VARCHAR(14) | YES | Gender of the assigned therapist. Sourced from DimEmployee.employee_gender. |
| therapist job name | VARCHAR(1020) | YES | Job title of the assigned therapist. Sourced from DimEmployee.employee_job_name. |
| therapist job code | VARCHAR(8000) | YES | Job code of the assigned therapist. Sourced from DimEmployee.employee_job_code. |
| service name | VARCHAR(512) | YES | Name of the service associated with the turnaway. Sourced from DimService.service_name. |
| service length | INTEGER | YES | Duration of the service in minutes. Sourced from DimService.service_length. |
| service category | VARCHAR(256) | YES | Category of the service. Sourced from DimService.service_category. |
| service parent category | VARCHAR(256) | YES | Parent category of the service. Sourced from DimService.service_parent_category. |
| service has variant | VARCHAR(14) | YES | Indicates whether the service has variants. Sourced from DimService.service_has_variant. |
| service is variant | VARCHAR(14) | YES | Indicates whether the service is a variant. Sourced from DimService.service_is_variant. |
| is addon | BOOLEAN | YES | Indicates whether the service is an add-on. Sourced from DimService.is_addon. |
| service businessunit | VARCHAR(200) | YES | Business unit of the service. Sourced from DimService.service_businessunit. |
| service tags | VARCHAR(65535) | YES | Tags associated with the service. Sourced from DimService.service_tags. |
| service price | DOUBLE PRECISION | YES | Price of the service. Sourced from DimService.service_price. |
| Center Code | VARCHAR(40) | YES | Code assigned to the center. Sourced from DimCenter.center_code. |
Primary Key
turnaway wid (BIGINT)
Foreign Keys
user widreferences DimUser (guest)appointment idreferences FactAppointment- Created-by employee columns reference DimEmployee
- Therapist columns reference DimEmployee
- Service columns reference DimService
Enumerator Values
| Column Name | Known Values |
|---|---|
| turnaway status | Completed, Cancelled |
| guest gender | Male, Female, Other |
| createdby employee gender | Male, Female, Other |
| therapist gender | Male, Female, Other |
| service has variant | Yes, No |
| service is variant | Yes, No |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.