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.
![]() |
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) |