ZenotiHelp

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 fact
  • center wid - References Dim_Center.wid
  • user wid - References Dim_User.wid
  • therapist wid - References Dim_Employee.wid (therapist)
  • invoice id - References the invoice record
  • appointment group id - References the appointment group
  • recurrence wid - References the recurrence record
  • rebooked source appointment pk - References source appointment
  • appointment id - Unique GUID of the appointment
  • factappointmentid - 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.