Skip to main content

Registrations data model

Guests can register for either classes or workshops. An individual occurrence of a class is a session. Workshops can be divided into tracks which can be further divided into events which are further divided into sessions. This data source brings in details of all guests attending the various sessions. There is a unique registration associated with each session that the guest attends.

Example use cases

  • Number of registrations per session

  • % of registrations canceled per session

  • Number of spots available vs. slots booked per session

  • % of capacity filled per instructor

Granularity of the data

At the most basic level, data is organized at the registration and session levels. In the example below, there is a class called 'Divine Yoga', shown in pink. Three guests registered for this class for the session starting on January 26 at 13:30. This session has a capacity of six, against which three have registered. Two of the guests ended up canceling earlier that day. Since these registrations are for a class, the workshop and track details are not filled. The blue rows reflect registrations for a workshop called 'kr workshop1'. This workshop only has one track 'Default'. Mario and Petey registered for this workshop. This workshop has three sessions named 'event1', 'event2', and 'event3'. The track start is the minimum start time of the three sessions and the track end time is the maximum end time of the three sessions. Since this registration is for a workshop, the class details are not filled.

httpreportszenoticomwp-contentuploads202102analytics_registrationsdatamodeljpg.jpeg

Note

Appointments get booked against each registration after the session is confirmed. Till that time, it is not associated with an appointment id.

Group

Description

Field

New Definition

Examples/Notes

Data Type

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 guest registered for a class or workshop.

organization account name

The domain name of the organization in Zenoti.

If you use this URL to log in to Zenoti 'https://massagespa.zenoti.com', then "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 guest registered for a class or workshop.

center name

The center where the guest registered for a class or workshop.

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 guest registered for a class or workshop.

minutes to add

The number of minutes that need to be added to UTC time to get the current time at the center. Timestamps that are generated by Tableau [E.g. if you use filters such as Today, Tomorrow, etc.] are in UTC, hence this field is needed to arrive at the center time. This is not needed for timestamps that are in the data source directly- these are already in the center time zone.

int4

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

guest first name

First name of the guest.

varchar(256)

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

guest middle name

Middle name of the guest.

varchar(256)

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

guest last name

Last name of the guest.

varchar(256)

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

is guest inactive

A flag indicating if 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 who registered for a class or workshop.

guest base center

Base center of the guest. This is where the guest's profile was created.

varchar(256)

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

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 who registered for a class or workshop.

user id

A unique identifier for 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 who registered for a class or workshop.

transfer guest first name

First name of the guest to whom the registration is transferred.

varchar(256)

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

transfer guest middle name

MIddle name of the guest to whom the registration is transferred.

varchar(256)

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

transfer guest last name

Last name of the guest to whom the registration is transferred.

varchar(256)

Guest

These fields detail the attributes of the guest who registered for a class or workshop.

is transfer guest inactive

A flag indicating whether the transfer guest is inactive. The transfer guest is the guest to whom the registration is transferred. 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 who registered for a class or workshop.

transfer user id

A unique identifier for the transfer guest. The transfer guest is the guest to whom the registration is transferred. This is a non-blank value that gets populated for every guest.

varchar(36)

Session

These fields detail the attributes of the guest who registered for a class or workshop.

session name

The unique name of the session for which the guest registered.

varchar(128)

Session

These fields detail the attributes of the guest who registered for a class or workshop.

session code

The unique code of the session that the guest registered for.

varchar(32)

Session

These fields detail the attributes of the guest who registered for a class or workshop.

session start date

The date and time on which the session is scheduled to start.

timestamp

Session

These fields detail the attributes of the guest who registered for a class or workshop.

session end date

The date and time on which the session is scheduled to end.

timestamp

Session

These fields detail the attributes of the guest who registered for a class or workshop.

session status

The current status of the session. Possible values: -Cancel -Checkin -Closed -Confirmed -Noshow -Open

Guests can either register for a class or workshop. Classes and workshops are further divided into sessions. 'Registration Status' indicates the status of the overall registration for the class or workshop. 'Session Status' indicates the status of the individual session within the class or workshop.

varchar(100)

Session

These fields detail the attributes of the guest who registered for a class or workshop.

session duration in mins

The duration of the session in minutes.

integer

Session

These fields detail the attributes of the guest who registered for a class or workshop.

session capacity

The overall capacity of the session.

integer

Session

These fields detail the attributes of the guest who registered for a class or workshop.

is session inactive

A flag indicating if the session is inactive. A session is considered inactive if it has been removed from the system. - True: Session is inactive. - False: Session is active.

boolean

Session

These fields detail the attributes of the guest who registered for a class or workshop.

dim session wid

A unique identifier for each session. This is generated in analytics, it does not exist in the core system.

bigint

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

class name

The name of the class corresponding to the session that the guest registered for.

This gets filled only if the registration is for a class.

varchar(128)

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

class code

The code of the class corresponding to the session for which the guest registered.

This gets filled only if the registration is for a class.

varchar(32)

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

is class inactive

A flag indicating whether the class is inactive. A class is considered inactive if it has been removed from the system. -True: Class is inactive. False: Class is active.

This is populated only if the registration is for a class.

boolean

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

workshop name

The name of the workshop for which the guest registered.

This gets filled only if the registration is for a workshop.

varchar(128)

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

workshop code

The unique code of the workshop for which the guest registered.

This gets filled only if the registration is for a workshop.

varchar(32)

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

is workshop inactive

A flag indicating if the workshop is inactive. A workshop is considered inactive if it has been removed from the system. - True: Workshop is inactive. - False: Workshop is active.

This gets filled only if the registration is for a workshop.

boolean

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

track name

The name of the workshop track for which the guest registered.

This gets filled only if the registration is for a workshop.

varchar(128)

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

track code

The unique code of the workshop track for which the guest registered.

This gets filled only if the registration is for a workshop.

varchar(32)

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

track start date

The date and time on which the workshop track is scheduled to start.

This gets filled only if the registration is for a workshop.

timestamp

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

track end date

The date and time on which the workshop track is scheduled to end.

This gets filled only if the registration is for a workshop.

timestamp

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

track duration in mins

The duration of the workshop track in minutes.

This gets filled only if the registration is for a workshop.

integer

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

is track inactive

A flag indicating if the workshop track is inactive. A workshop track is considered inactive if it has been removed from the system. - True: Track is inactive. - False: Track is active.

This gets filled only if the registration is for a workshop.

boolean

Class and Workshop

The individual session either corresponds to a class or workshop. The class and workshop details get recorded here.

dim workshop wid

A unique identifier for each workshop track. This is generated in Analytics, it does not exist in the core system.

This gets filled only if the registration is for a workshop.

bigint

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor first name

First name of the instructor of the corresponding session.

varchar(256)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor middle name

Middle name of the instructor of the corresponding session.

varchar(256)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor last name

Last name of the instructor of the corresponding session.

varchar(256)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor employee code

The employee code of the instructor of the corresponding session.

varchar(128)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor user id

A unique identifier for the session instructor. This is a non-blank value that gets populated for every instructor.

varchar(36)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor job name

Job name associated with the session instructor.

Yoga Trainer, Fitness Specialist, etc.

varchar(1020)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor job code

Unique code associated with the job of the session instructor.

varchar(128)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor start date

The date on which the session instructor started working for the organization.

timestamp

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor last date

The date on which the session instructor stopped working for the organization.

timestamp

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor tags

The tags associated with the session instructor.

Tags can be setup for employees in their profile. These will be comma separated values if there are multiple tags.

varchar(65535)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor additional field1

The details in 'Additional Field1' for the session instructor.

Additional Field1' can be entered for an employee when you navigate to 'Employee'>'Manage Employees'>'General' in Zenoti.

varchar(8000)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

instructor additional field2

The details in 'Additional Field2' for the session instructor.

Additional Field2' can be entered for an employee when you navigate to 'Employee'>'Manage Employees'>'General' in Zenoti.

varchar(8000)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

is instructor inactive

A flag indicating if the session instructor is inactive. An instructor is considered inactive if they have been removed from the system. - True: Instructor is inactive. - False: Instructor is active.

boolean

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor first name

First name of the instructor who was assigned when the session was created.

varchar(256)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor middle name

Middle name of the instructor instructor who was assigned when the session was created.

varchar(256)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor last name

Last name of the instructor who was assigned when the session was created.

varchar(256)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor employee code

The employee code of the instructor who was assigned when the session was created.

varchar(128)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor user id

A unique identifier for the instructor who was assigned when the session was created. This is a non-blank value that gets populated for every instructor.

varchar(36)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor job name

Job name associated with the instructor who was assigned when the session was created.

Yoga Trainer, Fitness Specialist, etc.

varchar(1020)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor job code

Unique code associated with the job of the instructor who was assigned when the session was created.

Yoga Trainer, Fitness Specialist, etc.

varchar(128)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor start date

The date on which the instructor who was assigned when the session was created started working for the organization.

timestamp

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor last date

The date on which the instructor who was assigned when the session was created stopped working for the organization.

timestamp

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor tags

The tags associated with the instructor who was assigned when the session was created.

Tags can be setup for employees in their profile. These will be comma separated values if there are multiple tags.

varchar(65535)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor additional field1

The details in 'Additional Field1' for the instructor who was assigned when the session was created.

Additional Field1' can be entered for an employee when you navigate to 'Employee'>'Manage Employees'>'General' in Zenoti.

varchar(8000)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital instructor additional field2

The details in 'Additional Field2' for the instructor who was assigned when the session was created.

Additional Field2' can be entered for an employee when you navigate to 'Employee'>'Manage Employees'>'General' in Zenoti.

varchar(8000)

Instructor

This group of fields describes the attributes of two types of instructors: 1) Instructor: The latest instructor assigned to the corresponding session 2) Initial instructor: The instructor assigned to the corresponding session at the time of creation of the session.

inital is instructor inactive

A flag indicating if the instructor who was assigned when the session was created is inactive. An instructor is considered inactive if they have been removed from the system. - True: Instructor is inactive. - False: Instructor is active.

boolean

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

registration fk

A unique identifier for each registration. This is a non-blank value that gets populated for every registration.

bigint

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

registration date

The date and time at which the guest registered for a class or workshop.

timestamp

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

registration status

The current status of the registration. Possible values: - Registered - Cancelled - No Show - Signed In - Waitlisted - Substituted - ClassCancelled - Closed - Enrolled - Rejected

Guests can either register for a class or workshop. Classes and workshops are further divided into sessions. 'Registration Status' indicates the status of the overall registration for the class or workshop. 'Session Status' indicates the status of the individual session within the class or workshop.

varchar(100)

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

cancellation date

The date and time at which the guest cancelled the registration.

timestamp

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

no show date

The date and time at which the guest did not attend the class or workshop for which they registered.

timestamp

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

check in date

The date and time at which the guest checked in for the class or workshop.

timestamp

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

waitlist date

The date and time at which the guest got waitlisted for a class or workshop.

timestamp

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

is from waitlist

A flag indicating if the guest is from waitlist. - True: From waitlist - False: Not from waitlist

int

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

is web booking

A flag indicating if the booking is from the web. - True: Web booking - False: Not a web booking

int

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

is direct booking

A flag indicating if the booking is a direct booking. - True: Direct booking - False: Not a direct booking

int

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

transfer registration fk

A unique registration fk created for the transferred guest.

bigint

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

multiple registration fk

A unique identifier for multiple registrations. This will be same for all the registrations in that group.

bigint

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

invoice item id

A unique identifier for each item in the Invoice. Unique within the organization.

varchar(36)

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

package version wid

A unique identifier for each package user id. This is generated in Analytics, it does not exist in the core system. This is populated if the registration is redeemed through a package.

bigint

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

membership version wid

Unique identifier for each membership user id. This is generated in Analytics, it does not exist in the core system. This is populated if the registration is redeemed through a membership.

bigint

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

invoiceid

A unique identifier for the invoice. This is unique within the organization.

varchar(36)

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

InvoiceNo

Invoice number that helps in identifying and tracking the invoice.

varchar(160)

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

appointment id

A unique identifier for the appointment. This is a non-blank value that gets populated for every appointment. Appointments get booked against each registration after the session is confirmed.

varchar(36)

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

appointment pk

A unique identifier for each appointment. Appointments get booked against each registration after the session is confirmed.

bigint

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

appointment void

A flag indicating if the appointment is inactive. An appointment is considered inactive if it has been removed from the system. -1: Appointment is inactive. - 0: Appointment is active. Appointments get booked against each registration after the session is confirmed.

integer

Registration

These fields detail the attributes of the registration associated with the guest. There is a separate registration associated with each session that the guest attends.

appointment source

Appointments get booked against each registration after the session is confirmed. This field populates the application from where the appointment was created. For example, through the Employee app, the mobile app, etc.

- MMS: Appointment created through the core system (i.e abc.zenoti.com) - PoS: Appointments created through PoS screen of the core system - Employee App: Appointments created through Employee App - Mobile: Appointments created through the CMA (Customer Mobile App) - Web: Appointments created through the Webstore - Imports: Appointments created through bulk data import - Offline: Appointments created through the offline app - Take5: Appointments created through the 'Take5 mobile app' - MobilePosAndroid: Appointments created through the Therapist Android App - Therapist Android App: Appointments created through the Therapist Android App (This source was renamed as 'MobilePosAndroid') - MobilePosiOS: Appointments created through the Therapist iOS App - Kiosk: Appointment created from the Guest Kiosk: In-store - KioskCMA: Appointment created from the Guest-Kiosk : CMA - KioskWeb: Appointment created from Guest-Kiosk : Webstore

varchar(128)