Forms Fact Table
ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide
Stores form submission and review data linked to guests, therapists, appointments, and services, including field-level values and form lifecycle metadata.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| formwid | BIGINT IDENTITY | NOT NULL | Surrogate key and primary key for the form record. |
| factformid | BIGINT | YES | Source system identifier for the form fact. |
| formid | VARCHAR(36) | YES | GUID identifier for the form. |
| guestwid | BIGINT | YES | Foreign key to the guest dimension (Bi_DimUser.userwid). |
| therapistwid | BIGINT | YES | Foreign key to the therapist/employee dimension (Bi_DimUser.userwid). |
| reviewedbywid | BIGINT | YES | Foreign key to the reviewer dimension (Bi_DimUser.userwid). |
| appointmentid | VARCHAR(36) | YES | GUID of the associated appointment. |
| centerwid | BIGINT | YES | Foreign key to the center dimension (Bi_DimCenter.centerwid). |
| servicewid | BIGINT | YES | Foreign key to the service dimension. |
| reviewedon | TIMESTAMP | YES | Timestamp when the form was reviewed. |
| submitteddate | TIMESTAMP | YES | Timestamp when the form was submitted. |
| startdate | TIMESTAMP | YES | Start date of the form validity. |
| isformsubmitted | BOOLEAN | YES | Flag indicating whether the form has been submitted. |
| formtype | INTEGER | YES | Type code of the form. |
| fieldname | VARCHAR(65535) | YES | Name of the form field. |
| value1 | DOUBLE PRECISION | YES | Numeric value stored in the form field. |
| value2 | TIMESTAMP | YES | Date/time value stored in the form field. |
| value3 | BOOLEAN | YES | Boolean value stored in the form field. |
| value4 | VARCHAR(65535) | YES | Text value stored in the form field. |
| datatypedesc | VARCHAR(36) | YES | Description of the data type for the field. |
| pointer | INTEGER | YES | Pointer/index for the form field ordering. |
| void | INTEGER | YES | Soft-delete flag (0 = active, non-zero = voided). |
| formappointmentstatus | INTEGER | YES | Status code of the appointment linked to the form. |
| appointmentnoshoworcancel | INTEGER | YES | Flag indicating no-show or cancellation for the appointment. |
| isappointmentvoided | BOOLEAN | YES | Flag indicating whether the associated appointment is voided. |
| formexpirydate | TIMESTAMP | YES | Expiry date of the form. |
| reviewneeded | BOOLEAN | YES | Flag indicating whether the form requires review. |
| formvoided | BOOLEAN | YES | Flag indicating whether the form itself is voided. |
| formsource | VARCHAR(16) | YES | Source channel of the form submission. |
| dimformwid | BIGINT | YES | Foreign key to the form dimension. |
| lastupdateddate | TIMESTAMP | YES | Timestamp of the last update to this record. |
| isv3form | BOOLEAN | YES | Whether this is a V3 form. |
| apphtmlformpk | BIGINT | YES | Primary key of the appointment HTML form. |
| htmlformpk | BIGINT | YES | Primary key of the HTML form. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
formwid
Foreign Keys
| Column | References |
|---|---|
| guestwid | Bi_DimUser.userwid |
| therapistwid | Bi_DimUser.userwid |
| reviewedbywid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
Enumerator Values
| Column | Values |
|---|---|
| formtype | 0 = No Form 1 = Service Key-Value Pair 2 = Service HTML Form 3 = Guest HTML Form 4 = Guest Key-Value Pair 5 = Tag Form 6 = Membership 7 = Packages 8 = Entity 9 = Loyalty Form 11 = Class Key-Value Pair 12 = Class HTML Form 13 = Service JSON Form 14 = Guest JSON Form 15 = Membership JSON Form 16 = Loyalty JSON Form 17 = Entity JSON Form 18 = Package JSON Form 19 = Class JSON Form 20 = Tag JSON Form 21 = Employee Survey JSON Form |
| formappointmentstatus | -2 = No Show -1 = Cancelled 0 = New/Open 1 = Closed 2 = Checkin 4 = Confirm 10 = Break 11 = Not Specified 20 = Available |
| appointmentnoshoworcancel | 0 = attended; non-zero = no-show or cancelled. |
| isformsubmitted | TRUE if form has been submitted; FALSE otherwise. |
| isappointmentvoided | TRUE if the appointment is voided; FALSE otherwise. |
| reviewneeded | FALSE = No Review Needed, TRUE = Review Required |
| formvoided | FALSE = Active, TRUE = Voided |
| void | 0 = active; non-zero = voided/soft-deleted. |
| isv3form | TRUE = V3 form; FALSE = Legacy form. |
Was this article helpful?
Your feedback helps us improve our documentation.