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.