Deleted Appointments Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 6 min readGuide
Consolidated fact table storing details of deleted appointment segments, including guest, employee, service, and audit trail information for modified and created-by employees.
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. |
| zone name | VARCHAR(800) | YES | Name of the geographic zone. 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 where the center is located. Sourced from DimCenter.center city. |
| center zip | VARCHAR(32) | YES | ZIP/postal code of the center. Sourced from DimCenter.center zip. |
| center state name | VARCHAR(4096) | YES | State name of the center. Sourced from DimCenter.center state name. |
| country name | VARCHAR(4096) | YES | Country name of the center. Sourced from DimCenter.country name. |
| center company name | VARCHAR(200) | YES | Company name associated with the center. Sourced from DimCenter.center company name. |
| operating center | BOOLEAN | YES | Indicates whether the center is an operating center. Sourced from DimCenter.operating center. |
| center wid | BIGINT | YES | Warehouse identifier for the center. Sourced from DimCenter.center wid. |
| user wid | BIGINT | YES | Warehouse identifier for the guest. Sourced from DimUser.user wid. |
| user id | VARCHAR(36) | YES | Unique identifier for the guest. Sourced from DimUser.user id. |
| guest first name | VARCHAR(160) | YES | First name of the guest. Sourced from DimUser.guest first name. |
| guest last name | VARCHAR(256) | YES | Last name of the guest. Sourced from DimUser.guest last name. |
| guest middle name | VARCHAR(128) | YES | Middle name of the guest. Sourced from DimUser.guest middle name. |
| guest city | VARCHAR(128) | YES | City of the guest. Sourced from DimUser.guest city. |
| guest zipcode | VARCHAR(128) | YES | ZIP/postal code of the guest. Sourced from DimUser.guest zipcode. |
| guest type name | VARCHAR(128) | YES | Type/category of the guest. Sourced from DimUser.guest type name. |
| guest email | VARCHAR(256) | YES | Email address of the guest. Sourced from DimUser.guest email. |
| guest mobile phone | VARCHAR(64) | YES | Mobile phone number of the guest. Sourced from DimUser.guest mobile phone. |
| guest home phone | VARCHAR(64) | YES | Home phone number of the guest. Sourced from DimUser.guest home phone. |
| guest phone code | INTEGER | YES | Phone country code of the guest. Sourced from DimUser.guest phone code. |
| guest code | VARCHAR(128) | YES | Code assigned to the guest. Sourced from DimUser.guest code. |
| guest gender | VARCHAR(14) | YES | Gender of the guest. Sourced from DimUser.guest gender. |
| guest dob | TIMESTAMP WITHOUT TIME ZONE | YES | Date of birth of the guest. Sourced from DimUser.guest dob. |
| referred by guestid | VARCHAR(36) | YES | Identifier of the guest who referred this guest. Sourced from DimUser.referred by guestid. |
| guest anniversary date | TIMESTAMP WITHOUT TIME ZONE | YES | Anniversary date of the guest. Sourced from DimUser.guest anniversary date. |
| guest state | VARCHAR(4096) | YES | State of the guest. Sourced from DimUser.guest state. |
| guest country name | VARCHAR(4096) | YES | Country of the guest. Sourced from DimUser.guest country name. |
| is guest inactive | BOOLEAN | YES | Indicates whether the guest is inactive. Sourced from DimUser.is guest inactive. |
| guest tags | VARCHAR(65535) | YES | Tags associated with the guest. Sourced from DimUser.guest tags. |
| guest referral source | VARCHAR(1600) | YES | Referral source for the guest. Sourced from DimUser.guest referral source. |
| no sale comments | VARCHAR(65535) | YES | Comments recorded when no sale was made. |
| employee first name | VARCHAR(160) | YES | First name of the assigned employee. Sourced from DimEmployee.employee first name. |
| employee last name | VARCHAR(256) | YES | Last name of the assigned employee. Sourced from DimEmployee.employee last name. |
| employee middle name | VARCHAR(128) | YES | Middle name of the assigned employee. Sourced from DimEmployee.employee middle name. |
| employee mobile phone | VARCHAR(64) | YES | Mobile phone of the assigned employee. Sourced from DimEmployee.employee mobile phone. |
| employee code | VARCHAR(128) | YES | Code for the assigned employee. Sourced from DimEmployee.employee code. |
| employee - code | VARCHAR(128) | YES | Alternate code for the assigned employee. Sourced from DimEmployee.employee - code. |
| employee gender | VARCHAR(14) | YES | Gender of the assigned employee. Sourced from DimEmployee.employee gender. |
| employee job name | VARCHAR(1020) | YES | Job title of the assigned employee. Sourced from DimEmployee.employee job name. |
| employee job code | VARCHAR(1020) | YES | Job code of the assigned employee. Sourced from DimEmployee.employee job code. |
| is employee inactive | BOOLEAN | YES | Indicates whether the assigned employee is inactive. Sourced from DimEmployee.is employee inactive. |
| service name | VARCHAR(512) | YES | Name of the service. 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. |
| is service inactive | BOOLEAN | YES | Indicates whether the service is inactive. Sourced from DimService.is service inactive. |
| service tags | VARCHAR(65535) | YES | Tags associated with the service. Sourced from DimService.service tags. |
| appointment pk | BIGINT | YES | Primary key of the appointment segment record. |
| modified by employee first name | VARCHAR(160) | YES | First name of the employee who last modified the appointment. Sourced from DimEmployee.employee first name. |
| modified by employee last name | VARCHAR(256) | YES | Last name of the modifying employee. Sourced from DimEmployee.employee last name. |
| modified by employee middle name | VARCHAR(128) | YES | Middle name of the modifying employee. Sourced from DimEmployee.employee middle name. |
| modified by employee mobile phone | VARCHAR(64) | YES | Mobile phone of the modifying employee. Sourced from DimEmployee.employee mobile phone. |
| modified by employee code | VARCHAR(128) | YES | Code of the modifying employee. Sourced from DimEmployee.employee code. |
| modified by employee - code | VARCHAR(128) | YES | Alternate code of the modifying employee. Sourced from DimEmployee.employee - code. |
| modified by employee gender | VARCHAR(14) | YES | Gender of the modifying employee. Sourced from DimEmployee.employee gender. |
| modified by employee job name | VARCHAR(1020) | YES | Job title of the modifying employee. Sourced from DimEmployee.employee job name. |
| modified by employee job code | VARCHAR(1020) | YES | Job code of the modifying employee. Sourced from DimEmployee.employee job code. |
| is modified by employee inactive | BOOLEAN | YES | Indicates whether the modifying employee is inactive. Sourced from DimEmployee.is employee inactive. |
| created by employee first name | VARCHAR(160) | YES | First name of the employee who created the appointment. Sourced from DimEmployee.employee first name. |
| created by employee last name | VARCHAR(256) | YES | Last name of the creating employee. Sourced from DimEmployee.employee last name. |
| created by employee middle name | VARCHAR(128) | YES | Middle name of the creating employee. Sourced from DimEmployee.employee middle name. |
| created by employee mobile phone | VARCHAR(64) | YES | Mobile phone of the creating employee. Sourced from DimEmployee.employee mobile phone. |
| created by employee code | VARCHAR(128) | YES | Code of the creating employee. Sourced from DimEmployee.employee code. |
| created by employee - code | VARCHAR(128) | YES | Alternate code of the creating employee. Sourced from DimEmployee.employee - code. |
| created by employee gender | VARCHAR(14) | YES | Gender of the creating employee. Sourced from DimEmployee.employee gender. |
| created by employee job name | VARCHAR(1020) | YES | Job title of the creating employee. Sourced from DimEmployee.employee job name. |
| created by employee job code | VARCHAR(1020) | YES | Job code of the creating employee. Sourced from DimEmployee.employee job code. |
| is created by employee inactive | BOOLEAN | YES | Indicates whether the creating employee is inactive. Sourced from DimEmployee.is employee inactive. |
| invoice no | VARCHAR(40) | YES | Human-readable invoice number. |
| invoice item id | VARCHAR(36) | YES | Unique identifier for the invoice item. |
| modified date time | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time the appointment was last modified. |
| modified date | DATE | YES | Date the appointment was last modified. |
| created date time | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time the appointment was created. |
| created date | DATE | YES | Date the appointment was created. |
| appointment start date time | TIMESTAMP WITHOUT TIME ZONE | YES | Scheduled start date and time of the appointment. |
| appointment start date | DATE | YES | Scheduled start date of the appointment. |
| appointment end date time | TIMESTAMP WITHOUT TIME ZONE | YES | Scheduled end date and time of the appointment. |
| appointment end date | DATE | YES | Scheduled end date of the appointment. |
| comments | VARCHAR(65535) | YES | Comments or reason for deleting the appointment. |
| minutes to add | INTEGER | YES | Minute offset to convert UTC to center local time. |
| factsegmentwid | BIGINT | YES | Warehouse identifier for the appointment segment fact. |
| Center Code | VARCHAR(40) | YES | Code assigned to the center. Sourced from DimCenter.Center Code. |
Primary Key
appointment pk -- BIGINT surrogate key uniquely identifying each deleted appointment record.
Foreign Keys
center widreferences DimCenteruser wid/user idreferences DimUserinvoice item idreferences FactInvoiceItemfactsegmentwid/factsegmentidreferences FactAppointmentSegmentgroupidreferences the tenant/data group
Enumerator Values
| Column Name | Known Values |
|---|---|
| guest gender | VARCHAR(14) |
| employee gender | VARCHAR(14) |
| service has variant | VARCHAR(14) |
| service is variant | VARCHAR(14) |
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.