Deleted Appointments data model

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

organization name

Formal name of the organization.

Massage Spa Express is the formal name of an organization.

varchar(512)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

organization account name

Domain name of the organization in Zenoti.

If you use the https://massagespa.zenoti.com URL to log in to Zenoti, massagespa is your account name. The formal name and domain name may be different.

varchar(256)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

center name

Center in which the appointment is deleted.

varchar(128)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

center wid

A unique identifier for the center. This is generated in Analytics; it does not exist in the core system.

bigint

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

zone name

Zone to which the center belongs.

varchar(800)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

center city

City in which the center is located.

varchar(128)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

center state name

State in which the center is located.

varchar(1024)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

country name

Country in which the center is located.

varchar(1024)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

center zip

Zip code of the center's location.

varchar(32)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

center company name

Name under which the center is registered.

Businesses, especially in a franchisee model, may register each center as a different company - such details are tracked on the Centers > General tab.

varchar(128)

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

operating center

A flag that indicates whether the center is operational. - True: Operational - False: Not operational

boolean

Center, Zone, Organization

An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the appointment is deleted.

minutes to add

Number of minutes that need to be added to UTC time to calculate the current time at the center. Timestamps that are generated by Tableau (for example, if you use filters such as Today and Tomorrow) are in UTC. As a result, you need this field to find out the current center time. Note: You do not need this field for timestamps that are directly in the data source - these timestamps are already in the center's time zone.

integer

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest first name

First name of the guest.

varchar(160)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest middle name

Middle name of the guest.

varchar(128)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest last name

Last name of the guest.

varchar(256)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

user wid

Unique identifier of the guest. This is generated in Analytics; it does not exist in the core system.

bigint

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

user id

Unique identifier of the guest. This is a non-blank value that gets populated for every guest.

varchar(36)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest code

Unique identifier of the guest. This is a non-mandatory value and it can be blank. This field maps to the guest code in a guest's profile in Zenoti.

varchar(128)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest city

City to which the guest belongs.

varchar(128)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest state

State to which the guest belongs.

varchar(4096)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest country name

Country to which the guest belongs.

varchar(4096)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest zipcode

Zip code of the guest's address.

varchar(128)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest email

Email ID of the guest.

varchar(256)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest mobile phone

Mobile phone number of the guest.

varchar(64)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest home phone

Home phone number of the guest.

varchar(64)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest phone code

Phone country code of the guest.

integer

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest gender

Gender of the guest.

varchar(14)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest dob

Date of birth of the guest.

timestamp

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest anniversary date

Marriage anniversary date of the guest.

timestamp

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest type name

An indicator of whether the guest is indeed a guest or an employee.

Possible values: - Guest - Employee - Internal Guest/Virtual Guest: Guests who made their first purchase on Webstore.

varchar(128)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

is guest inactive

A flag that indicates whether the guest is inactive. A guest is considered inactive if his/her profile has been removed from the system. - True: Guest is inactive. - False: Guest is active.

boolean

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest tags

Tags associated with the guest.

Tags can be set up for guests in their profile under the General tab. These will be comma-separated values if there are multiple tags.

varchar(65535)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

guest referral source

Source from where the guest got to know about the organization.

Possible values: - Advertisement - Driving By - Friend - Guest - Instagram - Other - Walkin - Yelp - Youtube

varchar(3200)

Guest

These fields detail the attributes of the guest for whom the deleted appointment was initially booked.

referred by guestid

User ID of the person who referred the guest.

varchar(36)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee - code

Unique code of the employee marked as primary Sold by. This code is taken from the employee's profile in Zenoti.

varchar(128)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee code

Unique code of the employee marked as primary Sold by. This is the code from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The employee code is usually the same as employee - code unless someone manually changes it in the database.

DO NOT USE- THIS FIELD IS BEING DEPRECATED

varchar(128)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee first name

First name of the employee marked as primary Sold by for the corresponding service.

varchar(160)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee middle name

Middle name of the employee marked as primary Sold by for the corresponding service.

varchar(128)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee last name

Last name of the employee marked as primary Sold by for the corresponding service.

varchar(256)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee mobile phone

Mobile number of the employee marked as primary Sold by.

varchar(64)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee gender

Gender of the employee marked as primary Sold by.

varchar(14)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee job name

Job name associated with the employee marked as primary Sold by.

Therapist, Manager, Aesthetician etc.

varchar(255)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

employee job code

Unique code associated with the job of the employee marked as primary Sold by.

varchar(2000)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

is employee inactive

Flag that indicates whether the primary Sold by employee is inactive. An employee is considered inactive if they have been removed from the system. -True: Employee is inactive -False: Employee is active

boolean

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee - code

Unique code of the employee who created the invoice. This code is taken from the employee's profile in Zenoti.

varchar(128)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee code

Unique code of the employee who created the invoice. This code is taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The employee code is usually the same as employee - code unless someone manually changes it in the database.

DO NOT USE- THIS FIELD IS BEING DEPRECATED

varchar(128)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee first name

First name of the employee who created the invoice.

varchar(160)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee middle name

Middle name of the employee who created the invoice.

varchar(256)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee last name

Last name of the employee who created the invoice.

varchar(256)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee gender

Gender of the employee who created the invoice.

varchar(14)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee mobile phone

Mobile number of the employee who created the invoice.

varchar(64)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee job name

Job name associated with the employee who created the invoice.

varchar(255)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

created by employee job code

Unique code associated with the job of the employee who created the invoice.

varchar(2000)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

is created by employee inactive

Flag that indicates whether the employee who created the invoice is inactive. An employee is considered inactive if they have been removed from the system. -True: Employee is inactive -False: Employee is active

boolean

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee - code

Unique code of the employee who deleted the appointment. This code is taken from the employee's profile in Zenoti.

varchar(128)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee code

Unique code of the employee who deleted the appointment. This code is taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The employee code is usually the same as employee - code unless someone manually changes it in the database.

DO NOT USE- THIS FIELD IS BEING DEPRECATED

varchar(128)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee first name

First name of the employee who deleted the appointment.

varchar(160)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee middle name

Middle name of the employee who deleted the appointment.

varchar(256)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee last name

Last name of the employee who deleted the appointment.

varchar(256)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee gender

Gender of the employee who deleted the appointment.

varchar(14)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee mobile phone

Mobile number of the employee who deleted the appointment.

varchar(64)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee job name

Job name associated with the employee who deleted the appointment.

varchar(255)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

modified by employee job code

Unique code associated with the job of the employee who deleted the appointment.

varchar(2000)

Employee

This group of fields describes the attributes of three types of employees:

- Sold by employee: The employee who primarily sold the service associated with the deleted appointment.

- Created by employee: The employee who created the invoice.

- Modified by employee: The employee who deleted the appointment.

is modified by employee inactive

Flag that indicates whether the employee who deleted the appointment is inactive. An employee is considered inactive if they have been removed from the system. -True: Employee is inactive -False: Employee is active

boolean

Service

These fields detail the service associated with the deleted appointment.

service name

Name of the service.

varchar(1024)

Service

These fields detail the service associated with the deleted appointment.

service category

Category of the service. This is set up as Sub-category in core.

For a Brazilian Wax service, category could be Waxing and parent category could be Hair removal.

varchar(1024)

Service

These fields detail the service associated with the deleted appointment.

service parent category

Parent category of the service. This is set up as Category in core.

For a Brazilian Wax service, category could be Waxing and parent category could be Hair removal.

varchar(1024)

Service

These fields detail the service associated with the deleted appointment.

service has variant

Flag that indicates whether the service has a variant. - True: indicates that the service has a variant. - False: indicates that the service does not have a variant. - Not Applicable.

A center has a service called Massage that has two variants: 30 minute massage and 60 minute massage. This flag would be true for the Massage service and it would be false for the 30 minute massage and 60 minute massage services.

varchar(14)

Service

These fields detail the service associated with the deleted appointment.

service is variant

Flag that indicates whether the service is a variant. - True: indicates that the service is a variant. - False: indicates that the service is not a variant. - Not Applicable.

A center has a service called Massage that has two variants: 30 minute massage and 60 minute massage. This flag would be false for the Massage service and it would be true for the 30 minute massage and 60 minute massage services.

varchar(14)

Service

These fields detail the service associated with the deleted appointment.

is addon

Flag that indicates whether the service is an add-on. - True: indicates that the service is an add-on. - False: indicates that the service is not an add-on.

boolean

Service

These fields detail the service associated with the deleted appointment.

service businessunit

Business unit to which the service belongs.

varchar(800)

Service

These fields detail the service associated with the deleted appointment.

is service inactive

Flag that indicates whether the service is inactive. A service is considered inactive if it has been removed from the system. - True: indicates that the service is inactive. - False: indicates that the service is active.

boolean

Service

These fields detail the service associated with the deleted appointment.

service tags

Tags associated with the service.

Tags can be created for a service in Organization view. These will be comma separated values if there are multiple tags.

varchar(65535)

Service

These fields detail the service associated with the deleted appointment.

service length

Ideal time taken to complete a service (in minutes), as set up in Zenoti.

integer

Appointment

These fields detail the service associated with the deleted appointment.

appointment pk

Unique indentifier of each deleted appointment.

integer

Appointment

These fields detail the service associated with the deleted appointment.

created date

Date on which the appointment was created.

date

Appointment

These fields detail the service associated with the deleted appointment.

created date time

Date and time at which the appointment was created.

timestamp

Appointment

These fields detail the service associated with the deleted appointment.

modified date

Date on which the appointment was deleted.

date

Appointment

These fields detail the service associated with the deleted appointment.

modified date time

Date and time at which the appointment was deleted.

timestamp

Appointment

These fields detail the service associated with the deleted appointment.

appointment start date

Date on which the appointment was scheduled to start.

If any changes were made to the appointment start date, this field displays the latest start date of the appointment.

date

Appointment

These fields detail the service associated with the deleted appointment.

appointment start date time

Date and time at which the appointment was scheduled to start.

If any changes were made to the appointment start date and time, this field displays the latest start date and time of the appointment.

timestamp

Appointment

These fields detail the service associated with the deleted appointment.

appointment end date

Date on which the appointment was scheduled to end.

If any changes were made to the appointment end date, this field displays the latest end date of the appointment.

date

Appointment

These fields detail the service associated with the deleted appointment.

appointment end date time

Date and time at which the appointment was scheduled to end.

If any changes were made to the appointment end date and time, this field displays the latest end date and time of the appointment.

timestamp

Appointment

These fields detail the service associated with the deleted appointment.

invoice no

Unique identifier for the invoice (unique within the center). This is the invoice associated with the corresponding appointment.

varchar(40)

Appointment

These fields detail the service associated with the deleted appointment.

invoice item id

Unique identifier for each line item within the invoice. This is the invoice item ID associated with the corresponding appointment.

varchar(36)

Appointment

These fields detail the service associated with the deleted appointment.

no sale comments

Comments that a front-desk executive enters when the sale of an intended service, membership, or package does not take place.

For example, a guest comes in for a paid consulation for a weight loss program. The consultant may not recommend that the guest should undertake the program due to medical conditions. In such a scenario, the front-desk executive may enter a comment such as: "Guest has a medical condition - the medical consultant advises against taking this program." Such comments appear under the No Sale Comments column.

varchar(65535)

Appointment

These fields detail the service associated with the deleted appointment.

comments

Comments that are entered while deleting the appointment.

For example, "Duplicate appointment booked."

varchar(65535)