ZenotiHelp

Issues Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 5 min readGuide

Consolidated fact table capturing issue (ticket/case) records including issue details, associated guest information, owner/updater/therapist employee details, and center attributes.

Columns

Column Name Data Type Nullable Description
issue id VARCHAR(36) Yes Unique identifier (UUID) of the issue.
issue no INTEGER Yes Sequential issue number.
issue title VARCHAR(16000) Yes Title of the issue.
issue desc VARCHAR(65535) Yes Detailed description of the issue.
issue start date TIMESTAMP Yes Start date and time of the issue.
issue end date TIMESTAMP Yes End/resolution date and time of the issue.
issue type name VARCHAR(1020) Yes Name of the issue type.
issue status name VARCHAR(256) Yes Current status of the issue.
priority name VARCHAR(256) Yes Priority level of the issue.
category name VARCHAR(256) Yes Category name of the issue.
category description VARCHAR(4096) Yes Description of the issue category.
sub category name VARCHAR(512) Yes Sub-category name of the issue.
sub category description VARCHAR(65535) Yes Description of the issue sub-category.
treatment name VARCHAR(256) Yes Treatment or resolution approach name.
treatment description VARCHAR(4096) Yes Description of the treatment or resolution approach.
source name VARCHAR(256) Yes Source through which the issue was raised.
source description VARCHAR(4096) Yes Description of the issue source.
source code VARCHAR(256) Yes Code of the issue source.
appointment group id VARCHAR(36) Yes Associated appointment group identifier (UUID).
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.
zone name VARCHAR(800) Yes Zone name of the center. Sourced from DimCenter.zone_name.
center name VARCHAR(128) Yes Name of the center. Sourced from DimCenter.center_name.
center city VARCHAR(128) Yes City of the center. Sourced from DimCenter.city.
center zip VARCHAR(32) Yes Zip code of the center. Sourced from DimCenter.zip.
center state name VARCHAR(4096) Yes State of the center. Sourced from DimCenter.state_name.
country name VARCHAR(4096) Yes Country of the center. Sourced from DimCenter.country_name.
operating center BOOLEAN Yes Indicates whether the center is operating. Sourced from DimCenter.operating_center.
guest wid BIGINT Yes Warehouse identifier for the guest. Sourced from DimGuest.guest_wid.
guest id VARCHAR(36) Yes Unique identifier (UUID) of the guest. Sourced from DimGuest.guest_id.
guest first name VARCHAR(256) Yes First name of the guest. Sourced from DimGuest.first_name.
guest last name VARCHAR(256) Yes Last name of the guest. Sourced from DimGuest.last_name.
guest middle name VARCHAR(256) Yes Middle name of the guest. Sourced from DimGuest.middle_name.
guest city VARCHAR(128) Yes City of the guest. Sourced from DimGuest.city.
guest zipcode VARCHAR(128) Yes Zip code of the guest. Sourced from DimGuest.zipcode.
guest type name VARCHAR(128) Yes Guest type classification name. Sourced from DimGuest.type_name.
guest email VARCHAR(512) Yes Email address of the guest. Sourced from DimGuest.email.
guest mobile phone VARCHAR(64) Yes Mobile phone number of the guest. Sourced from DimGuest.mobile_phone.
guest phone code INTEGER Yes Phone country code of the guest. Sourced from DimGuest.phone_code.
guest gender VARCHAR(14) Yes Gender of the guest. Sourced from DimGuest.gender.
guest dob TIMESTAMP Yes Date of birth of the guest. Sourced from DimGuest.dob.
referred by guestid VARCHAR(36) Yes Guest ID of the referrer. Sourced from DimGuest.referred_by_guestid.
guest anniversary date TIMESTAMP Yes Anniversary date of the guest. Sourced from DimGuest.anniversary_date.
guest state VARCHAR(4096) Yes State of the guest. Sourced from DimGuest.state.
guest country name VARCHAR(4096) Yes Country name of the guest. Sourced from DimGuest.country_name.
is guest inactive BOOLEAN Yes Indicates whether the guest is inactive. Sourced from DimGuest.is_inactive.
guest tags VARCHAR(65535) Yes Tags associated with the guest. Sourced from DimGuest.tags.
guest code VARCHAR(128) Yes Unique guest code identifier. Sourced from DimGuest.guest_code.
guest referral source VARCHAR(3200) Yes Referral source of the guest. Sourced from DimGuest.referral_source.
guest email state INTEGER Yes Email subscription state of the guest. Sourced from DimGuest.email_state.
guest receive transactional email BOOLEAN Yes Whether the guest receives transactional emails. Sourced from DimGuest.receive_transactional_email.
guest receive marketing email BOOLEAN Yes Whether the guest receives marketing emails. Sourced from DimGuest.receive_marketing_email.
guest receive transactional sms BOOLEAN Yes Whether the guest receives transactional SMS. Sourced from DimGuest.receive_transactional_sms.
guest receive marketing sms BOOLEAN Yes Whether the guest receives marketing SMS. Sourced from DimGuest.receive_marketing_sms.
owner first name VARCHAR(256) Yes First name of the issue owner (employee). Sourced from DimEmployee.first_name.
owner last name VARCHAR(256) Yes Last name of the issue owner. Sourced from DimEmployee.last_name.
owner middle name VARCHAR(256) Yes Middle name of the issue owner. Sourced from DimEmployee.middle_name.
owner mobile phone VARCHAR(64) Yes Mobile phone of the issue owner. Sourced from DimEmployee.mobile_phone.
owner code VARCHAR(128) Yes Code of the issue owner. Sourced from DimEmployee.employee_code.
owner employee - code VARCHAR(512) Yes Alternate code of the issue owner. Sourced from DimEmployee.employee_code.
owner gender VARCHAR(14) Yes Gender of the issue owner. Sourced from DimEmployee.gender.
owner job name VARCHAR(1020) Yes Job title of the issue owner. Sourced from DimEmployee.job_name.
is owner inactive BOOLEAN Yes Indicates whether the issue owner is inactive. Sourced from DimEmployee.is_inactive.
updated by first name VARCHAR(256) Yes First name of the employee who last updated the issue. Sourced from DimEmployee.first_name.
updated by last name VARCHAR(256) Yes Last name of the updater. Sourced from DimEmployee.last_name.
updated by middle name VARCHAR(256) Yes Middle name of the updater. Sourced from DimEmployee.middle_name.
updated by mobile phone VARCHAR(64) Yes Mobile phone of the updater. Sourced from DimEmployee.mobile_phone.
updated by code VARCHAR(128) Yes Code of the updater. Sourced from DimEmployee.employee_code.
updated by employee - code VARCHAR(512) Yes Alternate code of the updater. Sourced from DimEmployee.employee_code.
updated by gender VARCHAR(14) Yes Gender of the updater. Sourced from DimEmployee.gender.
updated by job name VARCHAR(1020) Yes Job title of the updater. Sourced from DimEmployee.job_name.
is updated by inactive BOOLEAN Yes Indicates whether the updater is inactive. Sourced from DimEmployee.is_inactive.
therapist first name VARCHAR(256) Yes First name of the therapist assigned. Sourced from DimEmployee.first_name.
therapist last name VARCHAR(256) Yes Last name of the therapist. Sourced from DimEmployee.last_name.
therapist middle name VARCHAR(256) Yes Middle name of the therapist. Sourced from DimEmployee.middle_name.
therapist code VARCHAR(128) Yes Code of the therapist. Sourced from DimEmployee.employee_code.
therapist employee - code VARCHAR(512) Yes Alternate code of the therapist. Sourced from DimEmployee.employee_code.
therapist gender VARCHAR(14) Yes Gender of the therapist. Sourced from DimEmployee.gender.
therapist job name VARCHAR(1020) Yes Job title of the therapist. Sourced from DimEmployee.job_name.
minutes to add INTEGER Yes Timezone offset in minutes for the center.
issue wid BIGINT Yes Warehouse identifier for the issue fact record.
Center Code VARCHAR(40) Yes Code of the center. Sourced from DimCenter.center_code.

Primary Key

No explicit primary key is defined. issue id serves as the logical key. issue wid is used as the distribution key.

Foreign Keys

  • guest id, guest wid references DimGuest
  • center name, Center Code references DimCenter
  • owner first name, owner code references DimEmployee (owner)
  • updated by first name, updated by code references DimEmployee (updater)
  • therapist first name, therapist code references DimEmployee (therapist)
  • appointment group id references DimAppointment

Enumerator Values

Column Name Known Values
issue status name Open, Closed, In Progress, etc.
priority name Low, Medium, High, Critical, etc.
guest gender Male, Female, etc.
owner gender Male, Female, etc.
guest email state Integer codes representing email subscription states

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.