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 widreferences DimGuestcenter name,Center Codereferences DimCenterowner first name,owner codereferences DimEmployee (owner)updated by first name,updated by codereferences DimEmployee (updater)therapist first name,therapist codereferences DimEmployee (therapist)appointment group idreferences 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.