ZenotiHelp

Feedback Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing guest feedback survey responses across multiple categories (ambience, cleanliness, service, therapist) and custom questions, with derived rating categories. Populated from the guest feedback module.

Columns

Column Name Data Type Nullable Description
feedbackwid BIGINT IDENTITY No Surrogate warehouse key for the feedback dimension
feedbackid NUMERIC(19,0) Yes Natural numeric identifier of the feedback record
guestfeedback_ambience VARCHAR(4096) Yes Guest rating or response for the ambience category
guestfeedback_cleanliness VARCHAR(4096) Yes Guest rating or response for the cleanliness category
guestfeedback_service VARCHAR(4096) Yes Guest rating or response for the service category
guestfeedback_therapist VARCHAR(4096) Yes Guest rating or response for the therapist category
guestfeedback_question1 VARCHAR(4096) Yes Guest response to custom feedback question 1
guestfeedback_question2 VARCHAR(4096) Yes Guest response to custom feedback question 2
guestfeedback_question3 VARCHAR(4096) Yes Guest response to custom feedback question 3
ambiencecategory VARCHAR(4112) Yes Derived rating category for ambience (e.g., Excellent, Good, Poor)
cleanlinesscategory VARCHAR(4112) Yes Derived rating category for cleanliness
servicecategory VARCHAR(4112) Yes Derived rating category for service
therapistcategory VARCHAR(4112) Yes Derived rating category for therapist
rowinserteddatetime TIMESTAMP Yes Timestamp when the feedback record was inserted in the source system
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
podid BIGINT Yes Identifier of the source pod

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

feedbackwid

Foreign Keys

Column References
feedbackid the feedback record in the source system

Enumerator Values

Column Values
ambiencecategory Excellent (5)
Good (4)
Average (3)
Below Average (2)
Poor (1)
cleanlinesscategory Derived rating bucket for cleanliness (same scale as ambience)
servicecategory Derived rating bucket for service (same scale as ambience)
therapistcategory Derived rating bucket for therapist (same scale as ambience)
Was this article helpful?
Your feedback helps us improve our documentation.