Appointment Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 13 min readGuide
Consolidated appointment fact table combining appointment details with guest, employee, therapist, service, package, resource, equipment, and feedback dimensions for comprehensive appointment and scheduling analytics.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization name | VARCHAR(512) | Yes | Name of the organization. Sourced from Dim_Organization.organization_name. |
| organization account name | VARCHAR(256) | Yes | Account name of the organization. Sourced from Dim_Organization.organization_account_name. |
| zone name | VARCHAR(800) | Yes | Name of the zone the center belongs to. Sourced from Dim_Center.zone_name. |
| center name | VARCHAR(256) | Yes | Name of the center where the appointment occurs. Sourced from Dim_Center.center_name. |
| center city | VARCHAR(256) | Yes | City where the center is located. Sourced from Dim_Center.center_city. |
| center zip | VARCHAR(32) | Yes | Zip/postal code of the center. Sourced from Dim_Center.center_zip. |
| center state name | VARCHAR(4096) | Yes | State name of the center. Sourced from Dim_Center.center_state_name. |
| center company name | VARCHAR(200) | Yes | Company name of the center. Sourced from Dim_Center.company_name. |
| country name | VARCHAR(4096) | Yes | Country name of the center. Sourced from Dim_Center.country_name. |
| operating center | BOOLEAN | Yes | Whether the center is an operating center. Sourced from Dim_Center.operating_center. |
| center wid | BIGINT | Yes | Warehouse identifier for the center dimension. Sourced from Dim_Center.wid. |
| user wid | BIGINT | Yes | Warehouse identifier for the guest/user dimension. Sourced from Dim_User.wid. |
| user id | VARCHAR(36) | Yes | Unique identifier (GUID) of the guest/user. Sourced from Dim_User.user_id. |
| guest first name | VARCHAR(256) | Yes | First name of the guest. Sourced from Dim_User.first_name. |
| guest last name | VARCHAR(256) | Yes | Last name of the guest. Sourced from Dim_User.last_name. |
| guest middle name | VARCHAR(256) | Yes | Middle name of the guest. Sourced from Dim_User.middle_name. |
| guest code | VARCHAR(128) | Yes | Unique code of the guest. Sourced from Dim_User.guest_code. |
| guest city | VARCHAR(128) | Yes | City of the guest. Sourced from Dim_User.city. |
| guest zipcode | VARCHAR(128) | Yes | Zip/postal code of the guest. Sourced from Dim_User.zipcode. |
| guest type name | VARCHAR(128) | Yes | Type classification of the guest. Sourced from Dim_User.guest_type_name. |
| guest email | VARCHAR(512) | Yes | Email address of the guest. Sourced from Dim_User.email. |
| guest mobile phone | VARCHAR(64) | Yes | Mobile phone number of the guest. Sourced from Dim_User.mobile_phone. |
| guest phone code | INTEGER | Yes | Phone country code of the guest. Sourced from Dim_User.phone_code. |
| guest gender | VARCHAR(14) | Yes | Gender of the guest. Sourced from Dim_User.gender. |
| guest dob | TIMESTAMP WITHOUT TIME ZONE | Yes | Date of birth of the guest. Sourced from Dim_User.dob. |
| referred by guestid | VARCHAR(36) | Yes | GUID of the guest who referred this guest. Sourced from Dim_User.referred_by_guestid. |
| guest anniversary date | TIMESTAMP WITHOUT TIME ZONE | Yes | Anniversary date of the guest. Sourced from Dim_User.anniversary_date. |
| guest state | VARCHAR(4096) | Yes | State of the guest address. Sourced from Dim_User.state. |
| guest country name | VARCHAR(4096) | Yes | Country name of the guest. Sourced from Dim_User.country_name. |
| is guest inactive | BOOLEAN | Yes | Whether the guest is inactive. Sourced from Dim_User.is_inactive. |
| guest tags | VARCHAR(65535) | Yes | Tags associated with the guest. Sourced from Dim_User.tags. |
| guest referral source | VARCHAR(3200) | Yes | Referral source of the guest. Sourced from Dim_User.referral_source. |
| guest base center | VARCHAR(256) | Yes | Base/home center of the guest. Sourced from Dim_User.base_center. |
| employee first name | VARCHAR(256) | Yes | First name of the employee (service provider). Sourced from Dim_Employee.first_name. |
| employee last name | VARCHAR(256) | Yes | Last name of the employee. Sourced from Dim_Employee.last_name. |
| employee middle name | VARCHAR(256) | Yes | Middle name of the employee. Sourced from Dim_Employee.middle_name. |
| employee mobile phone | VARCHAR(64) | Yes | Mobile phone of the employee. Sourced from Dim_Employee.mobile_phone. |
| employee code | VARCHAR(128) | Yes | Code of the employee. Sourced from Dim_Employee.employee_code. |
| employee - code | VARCHAR(128) | Yes | Alternate code of the employee. Sourced from Dim_Employee.employee_code_alt. |
| employee gender | VARCHAR(14) | Yes | Gender of the employee. Sourced from Dim_Employee.gender. |
| employee job name | VARCHAR(1020) | Yes | Job title of the employee. Sourced from Dim_Employee.job_name. |
| is employee inactive | BOOLEAN | Yes | Whether the employee is inactive. Sourced from Dim_Employee.is_inactive. |
| therapist first name | VARCHAR(256) | Yes | First name of the therapist. Sourced from Dim_Employee.first_name (therapist). |
| therapist last name | VARCHAR(256) | Yes | Last name of the therapist. Sourced from Dim_Employee.last_name (therapist). |
| therapist middle name | VARCHAR(256) | Yes | Middle name of the therapist. Sourced from Dim_Employee.middle_name (therapist). |
| therapist code | VARCHAR(128) | Yes | Code of the therapist. Sourced from Dim_Employee.employee_code (therapist). |
| therapist employee - code | VARCHAR(128) | Yes | Alternate code of the therapist. Sourced from Dim_Employee.employee_code_alt (therapist). |
| therapist gender | VARCHAR(14) | Yes | Gender of the therapist. Sourced from Dim_Employee.gender (therapist). |
| therapist job name | VARCHAR(1020) | Yes | Job title of the therapist. Sourced from Dim_Employee.job_name (therapist). |
| service name | VARCHAR(1024) | Yes | Name of the service. Sourced from Dim_Service.service_name. |
| service length | INTEGER | Yes | Duration of the service in minutes. Sourced from Dim_Service.service_length. |
| service category | VARCHAR(1024) | Yes | Category of the service. Sourced from Dim_Service.service_category. |
| service parent category | VARCHAR(1024) | Yes | Parent category of the service. Sourced from Dim_Service.parent_category. |
| service has variant | VARCHAR(14) | Yes | Whether the service has variants. Sourced from Dim_Service.has_variant. |
| service is variant | VARCHAR(14) | Yes | Whether the service is itself a variant. Sourced from Dim_Service.is_variant. |
| is addon | BOOLEAN | Yes | Whether the service is an add-on. Sourced from Dim_Service.is_addon. |
| service businessunit | VARCHAR(800) | Yes | Business unit of the service. Sourced from Dim_Service.businessunit. |
| is service inactive | BOOLEAN | Yes | Whether the service is inactive. Sourced from Dim_Service.is_inactive. |
| service tags | VARCHAR(65535) | Yes | Tags associated with the service. Sourced from Dim_Service.tags. |
| package name | VARCHAR(1024) | Yes | Name of the package. Sourced from Dim_Package.package_name. |
| package type | VARCHAR(14) | Yes | Type of the package. Sourced from Dim_Package.package_type. |
| package category | VARCHAR(800) | Yes | Category of the package. Sourced from Dim_Package.package_category. |
| package businessunit | VARCHAR(800) | Yes | Business unit of the package. Sourced from Dim_Package.businessunit. |
| is package inactive | BOOLEAN | Yes | Whether the package is inactive. Sourced from Dim_Package.is_inactive. |
| package tags | VARCHAR(65535) | Yes | Tags associated with the package. Sourced from Dim_Package.tags. |
| invoice id | VARCHAR(36) | Yes | Unique identifier (GUID) of the related invoice. Sourced from Fact_Appointment.invoice_id. |
| invoice no | VARCHAR(40) | Yes | Invoice number. Sourced from Fact_Appointment.invoice_no. |
| appointment source | VARCHAR(128) | Yes | Source of the appointment booking (e.g., Store, Online, App). Sourced from Fact_Appointment.appointment_source. |
| appointment created date | DATE | Yes | Date when the appointment was created. Sourced from Fact_Appointment.appointment_created_date. |
| appointment created date time | TIMESTAMP WITHOUT TIME ZONE | Yes | Date and time when the appointment was created. Sourced from Fact_Appointment.appointment_created_date_time. |
| appointment start date | DATE | Yes | Scheduled start date of the appointment. Sourced from Fact_Appointment.appointment_start_date. |
| appointment start date and time | TIMESTAMP WITHOUT TIME ZONE | Yes | Scheduled start date and time. Sourced from Fact_Appointment.appointment_start_date_and_time. |
| appointment end date | DATE | Yes | Scheduled end date of the appointment. Sourced from Fact_Appointment.appointment_end_date. |
| appointment end date and time | TIMESTAMP WITHOUT TIME ZONE | Yes | Scheduled end date and time. Sourced from Fact_Appointment.appointment_end_date_and_time. |
| appointment actual start date and time | TIMESTAMP WITHOUT TIME ZONE | Yes | Actual start date and time of the appointment. Sourced from Fact_Appointment.appointment_actual_start_date_and_time. |
| actual completed date and time | TIMESTAMP WITHOUT TIME ZONE | Yes | Actual completion date and time. Sourced from Fact_Appointment.actual_completed_date_and_time. |
| appointment group | INTEGER | Yes | Appointment group number. Sourced from Fact_Appointment.appointment_group. |
| appointment status | VARCHAR(100) | Yes | Status of the appointment. Sourced from Fact_Appointment.appointment_status. |
| equipment name | VARCHAR(1024) | Yes | Name of the equipment used. Sourced from Dim_Equipment.equipment_name. |
| is equipment active | BOOLEAN | Yes | Whether the equipment is active. Sourced from Dim_Equipment.is_active. |
| equipment capacity | INTEGER | Yes | Capacity of the equipment. Sourced from Dim_Equipment.capacity. |
| is primary appointment | VARCHAR(100) | Yes | Whether this is the primary appointment. Sourced from Fact_Appointment.is_primary_appointment. |
| is rebook target | VARCHAR(100) | Yes | Whether the appointment is a rebook target. Sourced from Fact_Appointment.is_rebook_target. |
| is rebook service | VARCHAR(100) | Yes | Whether the service is a rebook service. Sourced from Fact_Appointment.is_rebook_service. |
| resource name | VARCHAR(128) | Yes | Name of the resource/room. Sourced from Dim_Resource.resource_name. |
| resource type name | VARCHAR(128) | Yes | Type name of the resource. Sourced from Dim_Resource.resource_type_name. |
| resource capacity | INTEGER | Yes | Capacity of the resource. Sourced from Dim_Resource.capacity. |
| resource code | VARCHAR(128) | Yes | Code of the resource. Sourced from Dim_Resource.resource_code. |
| room category name | VARCHAR(800) | Yes | Category name of the room. Sourced from Dim_Resource.room_category_name. |
| therapist request type | VARCHAR(100) | Yes | Type of therapist request (e.g., Requested, Not Requested). Sourced from Fact_Appointment.therapist_request_type. |
| check in date and time | TIMESTAMP WITHOUT TIME ZONE | Yes | Date and time of guest check-in. Sourced from Fact_Appointment.check_in_date_and_time. |
| guest member status | VARCHAR(100) | Yes | Membership status of the guest at appointment time. Sourced from Fact_Appointment.guest_member_status. |
| service minutes | INTEGER | Yes | Duration of the service in minutes. Sourced from Fact_Appointment.service_minutes. |
| service sold count | INTEGER | Yes | Count of services sold. Sourced from Fact_Appointment.service_sold_count. |
| cancelled source | VARCHAR(128) | Yes | Source of the cancellation. Sourced from Fact_Appointment.cancelled_source. |
| appointment pk | INTEGER | Yes | Primary key of the appointment. Sourced from Fact_Appointment.appointment_pk. |
| appointment cancel or no show status | VARCHAR(21) | Yes | Cancellation or no-show status. Sourced from Fact_Appointment.appointment_cancel_or_no_show_status. |
| guest feedback ambience | VARCHAR(4096) | Yes | Guest feedback on ambience. Sourced from Fact_Appointment.guest_feedback_ambience. |
| guest feedback cleanliness | VARCHAR(4096) | Yes | Guest feedback on cleanliness. Sourced from Fact_Appointment.guest_feedback_cleanliness. |
| guest feedback service | VARCHAR(4096) | Yes | Guest feedback on service quality. Sourced from Fact_Appointment.guest_feedback_service. |
| guest feedback therapist | VARCHAR(4096) | Yes | Guest feedback on the therapist. Sourced from Fact_Appointment.guest_feedback_therapist. |
| guest feedback question 1 | VARCHAR(4096) | Yes | Guest response to feedback question 1. Sourced from Fact_Appointment.guest_feedback_question_1. |
| guest feedback question 2 | VARCHAR(4096) | Yes | Guest response to feedback question 2. Sourced from Fact_Appointment.guest_feedback_question_2. |
| guest feedback question 3 | VARCHAR(4096) | Yes | Guest response to feedback question 3. Sourced from Fact_Appointment.guest_feedback_question_3. |
| feedback by user id | VARCHAR(36) | Yes | User ID of the person who provided feedback. Sourced from Fact_Appointment.feedback_by_user_id. |
| feedback by first name | VARCHAR(256) | Yes | First name of the feedback provider. Sourced from Dim_Employee.first_name (feedback by). |
| feedback by last name | VARCHAR(256) | Yes | Last name of the feedback provider. Sourced from Dim_Employee.last_name (feedback by). |
| feedback by middle name | VARCHAR(256) | Yes | Middle name of the feedback provider. Sourced from Dim_Employee.middle_name (feedback by). |
| feedback by user code | VARCHAR(128) | Yes | User code of the feedback provider. Sourced from Dim_Employee.user_code (feedback by). |
| feedback by employee - code | VARCHAR(128) | Yes | Alternate code of the feedback provider. Sourced from Dim_Employee.employee_code_alt (feedback by). |
| is feedback given | BOOLEAN | Yes | Whether feedback was provided. Sourced from Fact_Appointment.is_feedback_given. |
| ambience feedback | INTEGER | Yes | Numeric ambience feedback score. Sourced from Fact_Appointment.ambience_feedback. |
| cleanliness feedback | INTEGER | Yes | Numeric cleanliness feedback score. Sourced from Fact_Appointment.cleanliness_feedback. |
| service feedback | INTEGER | Yes | Numeric service feedback score. Sourced from Fact_Appointment.service_feedback. |
| therapist feedback | INTEGER | Yes | Numeric therapist feedback score. Sourced from Fact_Appointment.therapist_feedback. |
| avg feedback | DOUBLE PRECISION | Yes | Average feedback score. Sourced from Fact_Appointment.avg_feedback. |
| recommended | BOOLEAN | Yes | Whether the guest recommended the service. Sourced from Fact_Appointment.recommended. |
| share feedback | INTEGER | Yes | Share feedback indicator. Sourced from Fact_Appointment.share_feedback. |
| feedback updated date time | TIMESTAMP WITHOUT TIME ZONE | Yes | Date and time when feedback was last updated. Sourced from Fact_Appointment.feedback_updated_date_time. |
| feedback source | VARCHAR(128) | Yes | Source of the feedback. Sourced from Fact_Appointment.feedback_source. |
| appointment group primarty key | INTEGER | Yes | Primary key of the appointment group. Sourced from Fact_Appointment.appointment_group_primary_key. |
| actual appointment time | TIMESTAMP WITHOUT TIME ZONE | Yes | Actual appointment time. Sourced from Fact_Appointment.actual_appointment_time. |
| action performed date time in center | TIMESTAMP WITHOUT TIME ZONE | Yes | Date and time of action in center timezone. Sourced from Fact_Appointment.action_performed_date_time_in_center. |
| appointment wid | BIGINT | Yes | Warehouse identifier for the appointment. Sourced from Fact_Appointment.wid. |
| user creation date | TIMESTAMP WITHOUT TIME ZONE | Yes | Date when the user/guest record was created. Sourced from Dim_User.creation_date. |
| rebooked appointment count | INTEGER | Yes | Count of rebooked appointments. Sourced from Fact_Appointment.rebooked_appointment_count. |
| appointment category code | VARCHAR(1024) | Yes | Code of the appointment category. Sourced from Fact_Appointment.appointment_category_code. |
| appointment category name | VARCHAR(1024) | Yes | Name of the appointment category. Sourced from Fact_Appointment.appointment_category_name. |
| is appointment category active | BOOLEAN | Yes | Whether the appointment category is active. Sourced from Fact_Appointment.is_appointment_category_active. |
| is center franchise | BOOLEAN | Yes | Whether the center is a franchise. Sourced from Dim_Center.is_franchise. |
| center cst number | VARCHAR(80) | Yes | CST number of the center. Sourced from Dim_Center.cst_number. |
| center tin number | VARCHAR(80) | Yes | TIN number of the center. Sourced from Dim_Center.tin_number. |
| center tot number | VARCHAR(80) | Yes | TOT number of the center. Sourced from Dim_Center.tot_number. |
| center service tax number | VARCHAR(80) | Yes | Service tax number of the center. Sourced from Dim_Center.service_tax_number. |
| center vat number | VARCHAR(80) | Yes | VAT number of the center. Sourced from Dim_Center.vat_number. |
| center luxary tax number | VARCHAR(80) | Yes | Luxury tax number of the center. Sourced from Dim_Center.luxary_tax_number. |
| employee additional field 1 | VARCHAR(8000) | Yes | Custom additional field 1 for the employee. Sourced from Dim_Employee.additional_field_1. |
| employee additional field 2 | VARCHAR(8000) | Yes | Custom additional field 2 for the employee. Sourced from Dim_Employee.additional_field_2. |
| therapist additional field 1 | VARCHAR(8000) | Yes | Custom additional field 1 for the therapist. Sourced from Dim_Employee.additional_field_1 (therapist). |
| therapist additional field 2 | VARCHAR(8000) | Yes | Custom additional field 2 for the therapist. Sourced from Dim_Employee.additional_field_2 (therapist). |
| therapist wid | BIGINT | Yes | Warehouse identifier for the therapist. Sourced from Dim_Employee.wid (therapist). |
| appointment cancel reason | VARCHAR(65535) | Yes | Reason for appointment cancellation. Sourced from Fact_Appointment.appointment_cancel_reason. |
| appointment cancel reason code | VARCHAR(1024) | Yes | Code for appointment cancellation reason. Sourced from Fact_Appointment.appointment_cancel_reason_code. |
| appointment recurrence interval | INTEGER | Yes | Recurrence interval of the appointment. Sourced from Fact_Appointment.appointment_recurrence_interval. |
| appointment recurrence occurences | INTEGER | Yes | Number of recurrence occurrences. Sourced from Fact_Appointment.appointment_recurrence_occurences. |
| appointment recurrence time period | VARCHAR(100) | Yes | Time period for recurrence (e.g., Daily, Weekly). Sourced from Fact_Appointment.appointment_recurrence_time_period. |
| appointment recurrence start date time | TIMESTAMP WITHOUT TIME ZONE | Yes | Start date and time of the recurrence. Sourced from Fact_Appointment.appointment_recurrence_start_date_time. |
| rebooked source appointment pk | BIGINT | Yes | Primary key of the source appointment that was rebooked. Sourced from Fact_Appointment.rebooked_source_appointment_pk. |
| rebooked source group id | VARCHAR(36) | Yes | Group ID of the source rebooked appointment. Sourced from Fact_Appointment.rebooked_source_group_id. |
| appointment group id | VARCHAR(36) | Yes | Group identifier of the appointment. Sourced from Fact_Appointment.appointment_group_id. |
| recurrence wid | BIGINT | Yes | Warehouse identifier for the recurrence. Sourced from Fact_Appointment.recurrence_wid. |
| createdby employee first name | VARCHAR(256) | Yes | First name of the employee who created the appointment. Sourced from Dim_Employee.first_name (created by). |
| createdby employee last name | VARCHAR(256) | Yes | Last name of the employee who created the appointment. Sourced from Dim_Employee.last_name (created by). |
| createdby employee middle name | VARCHAR(256) | Yes | Middle name of the employee who created the appointment. Sourced from Dim_Employee.middle_name (created by). |
| createdby employee mobile phone | VARCHAR(64) | Yes | Mobile phone of the creating employee. Sourced from Dim_Employee.mobile_phone (created by). |
| createdby employee code | VARCHAR(128) | Yes | Code of the creating employee. Sourced from Dim_Employee.employee_code (created by). |
| createdby employee - code | VARCHAR(128) | Yes | Alternate code of the creating employee. Sourced from Dim_Employee.employee_code_alt (created by). |
| createdby employee gender | VARCHAR(14) | Yes | Gender of the creating employee. Sourced from Dim_Employee.gender (created by). |
| createdby employee job name | VARCHAR(1020) | Yes | Job title of the creating employee. Sourced from Dim_Employee.job_name (created by). |
| createdby employee job code | VARCHAR(8000) | Yes | Job code of the creating employee. Sourced from Dim_Employee.job_code (created by). |
| is createdby employee inactive | BOOLEAN | Yes | Whether the creating employee is inactive. Sourced from Dim_Employee.is_inactive (created by). |
| createdby employee tags | VARCHAR(65535) | Yes | Tags for the creating employee. Sourced from Dim_Employee.tags (created by). |
| createdby employee additional field 1 | VARCHAR(8000) | Yes | Custom additional field 1 for the creating employee. Sourced from Dim_Employee.additional_field_1 (created by). |
| createdby employee additional field 2 | VARCHAR(8000) | Yes | Custom additional field 2 for the creating employee. Sourced from Dim_Employee.additional_field_2 (created by). |
| createdby employee last date | TIMESTAMP WITHOUT TIME ZONE | Yes | Last working date of the creating employee. Sourced from Dim_Employee.last_date (created by). |
| employee last date | TIMESTAMP WITHOUT TIME ZONE | Yes | Last working date of the employee. Sourced from Dim_Employee.last_date. |
| therapist last date | TIMESTAMP WITHOUT TIME ZONE | Yes | Last working date of the therapist. Sourced from Dim_Employee.last_date (therapist). |
| is therapist inactive | BOOLEAN | Yes | Whether the therapist is inactive. Sourced from Dim_Employee.is_inactive (therapist). |
| minutes to add | INTEGER | Yes | Minutes offset to add for timezone conversion. Sourced from Dim_Center.minutes_to_add. |
| feedback version | INTEGER | Yes | Version of the feedback form. Sourced from Fact_Appointment.feedback_version. |
| feedback tag1 | VARCHAR(32000) | Yes | Feedback tag 1. Sourced from Fact_Appointment.feedback_tag1. |
| feedback tag2 | VARCHAR(32000) | Yes | Feedback tag 2. Sourced from Fact_Appointment.feedback_tag2. |
| feedback tag3 | VARCHAR(32000) | Yes | Feedback tag 3. Sourced from Fact_Appointment.feedback_tag3. |
| feedback tag4 | VARCHAR(32000) | Yes | Feedback tag 4. Sourced from Fact_Appointment.feedback_tag4. |
| feedback tag5 | VARCHAR(32000) | Yes | Feedback tag 5. Sourced from Fact_Appointment.feedback_tag5. |
| feedback tag6 | VARCHAR(32000) | Yes | Feedback tag 6. Sourced from Fact_Appointment.feedback_tag6. |
| feedback tag7 | VARCHAR(32000) | Yes | Feedback tag 7. Sourced from Fact_Appointment.feedback_tag7. |
| feedback tag8 | VARCHAR(32000) | Yes | Feedback tag 8. Sourced from Fact_Appointment.feedback_tag8. |
| recovery minutes | INTEGER | Yes | Recovery time in minutes after service. Sourced from Fact_Appointment.recovery_minutes. |
| service internal cost | DOUBLE PRECISION | Yes | Internal cost of the service. Sourced from Dim_Service.internal_cost. |
| is segmented | INTEGER | Yes | Whether the appointment is segmented. Sourced from Fact_Appointment.is_segmented. |
| recurrence appointment group primary key | BIGINT | Yes | Primary key of the recurrence appointment group. Sourced from Fact_Appointment. |
| recurrence appointment pk | BIGINT | Yes | Primary key of the recurrence appointment. Sourced from Fact_Appointment. |
| recurrence appointment invoice no | VARCHAR(40) | Yes | Invoice number of the recurrence appointment. Sourced from Fact_Appointment. |
| is surprise | INTEGER | Yes | Whether the appointment is a surprise. Sourced from Fact_Appointment.is_surprise. |
| is addon primary appointment pk | BIGINT | Yes | Primary key of the primary appointment for this add-on. Sourced from Fact_Appointment. |
| feedback comments | VARCHAR(32000) | Yes | Free-text feedback comments. Sourced from Fact_Appointment.feedback_comments. |
| factappointmentid | INTEGER | Yes | Internal integer identifier for the appointment fact. Sourced from Fact_Appointment.id. |
| appointment id | VARCHAR(36) | Yes | Unique identifier (GUID) of the appointment. Sourced from Fact_Appointment.appointment_id. |
| Initial Suggested StartTimeInCenter | TIMESTAMP | Yes | Initial suggested start time in center timezone. Sourced from Fact_Appointment. |
| utm source | NVARCHAR(128) | Yes | UTM source tracking parameter. Sourced from Fact_Appointment.utm_source. |
| utm medium | NVARCHAR(128) | Yes | UTM medium tracking parameter. Sourced from Fact_Appointment.utm_medium. |
| Center Code | VARCHAR(40) | Yes | Code of the center. Sourced from Dim_Center.center_code. |
| bundle package name | VARCHAR(1024) | Yes | Name of the bundle package. Sourced from Fact_Appointment.bundle_package_name. |
| bundle package number | INTEGER | Yes | Number of the bundle package. Sourced from Fact_Appointment.bundle_package_number. |
| is queue | BOOLEAN | Yes | Whether the appointment is in a queue. Sourced from Fact_Appointment.is_queue. |
| actual waittime in seconds | BIGINT | Yes | Actual wait time in seconds for queued appointments. Sourced from Fact_Appointment.actual_waittime_in_seconds. |
| initial preferred time in center | TIMESTAMP | Yes | Initial preferred time in center timezone. Sourced from Fact_Appointment.initial_preferred_time_in_center. |
| initial therapist request type | VARCHAR(100) | Yes | Initial therapist request type before changes. Sourced from Fact_Appointment.initial_therapist_request_type. |
| cancelled on | TIMESTAMP | Yes | Timestamp when the appointment was cancelled. Sourced from Fact_Appointment.cancelled_on. |
| queue appointment type | NVARCHAR(30) | Yes | Type of queued appointment. Sourced from Fact_Appointment.queue_appointment_type. |
Primary Key
No explicit primary key defined. The appointment pk and appointment wid serve as logical identifiers.
Foreign Keys
appointment wid- Warehouse identifier for the appointment factcenter wid- References Dim_Center.widuser wid- References Dim_User.widtherapist wid- References Dim_Employee.wid (therapist)invoice id- References the invoice recordappointment group id- References the appointment grouprecurrence wid- References the recurrence recordrebooked source appointment pk- References source appointmentappointment id- Unique GUID of the appointmentfactappointmentid- Internal fact identifier
Enumerator Values
| Column Name | Known Values |
|---|---|
| appointment status | -2 = No Show |
| appointment cancel or no show status | -2 = No Show |
| appointment source | 0 = Store |
| therapist request type | 0 = Any |
| guest member status | 0 = Never a Member |
| feedback source | 0 = Email |
| appointment recurrence time period | Day |
| queue appointment type | 0 = Group Booking |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.