Appointment Segments Data Model
Services can be split into multiple steps known as segments. For example, a typical hair coloring service involves the following steps — wash, blow-dry, color application, color absorption, second wash, and second blow-dry — which can be divided into different segments.
The Appointments data source does not have segment information for services that are segmented. This data source bridges that gap and brings in details of all segments and their attributes, such as provider, start and end times, etc. The Appointment Segments data source does not contain any information about appointments that do not have segments.
Note
This data source does not have information about segments that belong to deleted appointments, turnaways, and waitlisted appointments.
Example Use-Cases
Total number of segments serviced
Number of segments serviced by a therapist
Average segment length
Granularity of Data
At the most granular level, we have a unique identifier 'segment pk' for each segment. Each segment is populated in a separate row. It can be mapped to the appointment in the Appointments data source through the 'appointment pk' field.
 |
Group | Description | Field | Definition | Examples/Notes | Data Type |
|---|---|---|---|---|---|
Center, Organization | These fields detail the attributes of the center. Here, we refer to the center where the segment is scheduled to be serviced. | organization name | The formal name of the organization. | Massage Spa Express' is the formal name of an organization. | varchar(512) |
Center, Organization | These fields detail the attributes of the center. Here, we refer to the center where the segment is scheduled to be serviced. | organization account name | Domain name of the organization in Zenoti. | If you use the https://massagespa.zenoti.com URL to log in to Zenoti, then massagespa is your account name. The formal name and domain name may be different. | varchar(256) |
Center, Organization | These fields detail the attributes of the center. Here, we refer to the center where the segment is scheduled to be serviced. | center name | The center where the segment is scheduled to be serviced. | varchar(128) | |
Center, Organization | These fields detail the attributes of the center. Here, we refer to the center where the segment is scheduled to be serviced. | 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 datasource directly, these are already in the center time zone. | int4 | |
Appointment | These fields describe the attributes of the service with which the segment is associated. | appointment pk | The unique identifier of the service with which the segment is associated. | integer | |
Appointment | These fields describe the attributes of the service with which the segment is associated. | service name | The name of the service with which the segment is associated. | varchar(1024) | |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment pk | A unique identifier for each segment. | integer | |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment name | The name of the segment. | varchar(1024) | |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment length | The ideal time taken to complete a segment (in minutes), as setup in Zenoti. | integer | |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment start date | The date on which the segment is scheduled to start. | If any changes are made to the segment start date, this column will have the latest start date of the segment. | date |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment start date and time | The date and time at which the segment is scheduled to start. | If any changes are made to the segment start date and time, this column will have the latest start date and time of the segment. | timestamp |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment end date | The date on which the segment is scheduled to end. | If any changes are made to the segment end date, this column will have the latest end date of the segment. | date |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment end date and time | The date and time at which the segment is scheduled to end. | If any changes are made to the segment end date and time, this column will have the latest end date and time of the segment. | timestamp |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment actual start date and time | The date and time at which the status for the segment was changed to 'Checkin'. | date | |
Segment | These fields describe the attributes of the service with which the segment is associated. | segment actual completed date and time | The date and time at which the status for the segment was changed to 'Closed'. | timestamp | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist first name | First name of the therapist. | varchar(160) | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist middle name | Middle name of the therapist. | varchar(128) | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist last name | Last name of the therapist. | varchar(256) | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist employee - code | Unique code of the therapist. This is taken from the employee's profile in Zenoti. | varchar(128) | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist wid | Unique identifier for the therapist. This is generated in Analytics and it does not exist in the core application. | bigint | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist gender | Gender of the therapist. | Possible values: - Male - Female - Not applicable | varchar(14) |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist last date | The date on which the therapist stopped working for the organization. | date | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist job name | Job name associated with the therapist. | varchar(255) | |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist additional field 1 | The details in 'Additional Field1' for the therapist. | Additional Field1' can be entered for an employee when you navigate to 'Employee'>'Manage Employees'>'General' in Zenoti. | varchar(8000) |
Therapist | These fields describe the attributes of the therapist scheduled for the corresponding segment. | therapist additional field 2 | The details in 'Additional Field2' for the therapist. | Additional Field2' can be entered for an employee when you navigate to 'Employee'>'Manage Employees'>'General' in Zenoti. | varchar(8000) |