ZenotiHelp

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 wid references DimUser (guest)
  • appointment id references 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.