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.