ZenotiHelp

Custom Forms Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Dimension table storing custom form definitions including form type, versioning, expiry rules, and review/action configuration.

Columns

Column Name Data Type Nullable Description
FormWID BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
FormPk BIGINT Yes Source system primary key for the form
FormId VARCHAR(36) Yes Source system unique identifier for the form
FormName NVARCHAR(2048) Yes Display name of the form
FormDesc NVARCHAR(MAX) Yes Full description of the form
FormType INT Yes Enumerator indicating the type of form
void BOOLEAN Yes Soft-delete flag
FormCode NVARCHAR Yes Short code identifying the form
Active BOOLEAN Yes Indicates if the form is currently active
ReviewNeeded BOOLEAN Yes Indicates if form submissions require review
ViewOnly BOOLEAN Yes Indicates if the form is read-only
FormExpiryType INT Yes Enumerator indicating the expiry behavior of the form
ExpiryTime NVARCHAR Yes Expiry time value (interpreted based on FormExpiryType)
FormVersion INT Yes Version number of the form
FormActionType INT Yes Enumerator indicating the action type of the form
CopyPreviousData BOOLEAN Yes Indicates if previous data is copied to new submissions
PrefillOldVersionData BOOLEAN Yes Indicates if old version data is pre-filled
ExcludeChildFormsForReview BOOLEAN Yes Indicates if child forms are excluded from review
CreatedOn TIMESTAMP Yes Date/time the form was created
CreatedBy VARCHAR(36) Yes User ID who created the form
CTEtlLastUpdatedOn TIMESTAMP Yes Timestamp of the last center-specific ETL update

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

FormWID

Foreign Keys

Column References
FormPk

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
FormExpiryType 0 = No Expiry
1 = Date-based
2 = Visit-based
FormActionType 0 = No Action
1 = Submit
2 = Review
3 = Approve
Was this article helpful?
Your feedback helps us improve our documentation.