ZenotiHelp

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 wid references DimCenter
  • user wid / user id references DimUser
  • invoice item id references FactInvoiceItem
  • factsegmentwid / factsegmentid references FactAppointmentSegment
  • groupid references 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.