Feedback dimension table
bi_dimfeedback
Field | Description | Field Type | Primary Key |
|---|---|---|---|
ambiencecategory | varchar ( 4112 ) | ||
cleanlinesscategory | varchar ( 4112 ) | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
feedbackid | numeric | ||
feedbackwid | bigint | ||
guestfeedback_ambience | The first feedback question configured in the 'V1' feedback form. The answer format for this question is a rating from 1 to 5. | varchar ( 4096 ) | |
guestfeedback_cleanliness | The second feedback question configured in the 'V1' feedback form. The answer format for this question is a rating from 1 to 5. | varchar ( 4096 ) | |
guestfeedback_question1 | The first question for which the answer format is 'Yes/ No' in the 'V1' feedback form. | varchar ( 4096 ) | |
guestfeedback_question2 | The second question for which the answer format is 'Yes/ No' in the 'V1' feedback form. | varchar ( 4096 ) | |
guestfeedback_question3 | The question configured for the feedback comment in the 'V1' feedback form. | varchar ( 4096 ) | |
guestfeedback_service | The third feedback question configured in the 'V1' feedback form. The answer format for this question is a rating from 1 to 5. | varchar ( 4096 ) | |
guestfeedback_therapist | The fourth feedback question configured in the 'V1' feedback form. The answer format for this question is a rating from 1 to 5. | varchar ( 4096 ) | |
organizationid | varchar ( 36 ) | ||
podid | bigint | ||
podname | varchar ( 20 ) | ||
rowinserteddatetime | timestamp without time zone | ||
servicecategory | varchar ( 4112 ) | ||
therapistcategory | varchar ( 4112 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |