ZenotiHelp

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.