Forms Meta Data Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing metadata about individual fields within custom forms, capturing field names and their association to HTML form definitions.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| FormsMetaDataWID | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| formsmetadataid | BIGINT | No | Source system primary key for the form metadata record |
| FormId | VARCHAR(36) | Yes | Unique identifier of the parent form |
| HtmlFormPK | BIGINT | Yes | Primary key of the associated HTML form definition |
| fieldname | VARCHAR(65535) | Yes | Name/label of the form field |
| CreatedDate | DATETIME | Yes | Date/time the metadata record was created |
| CreatedBy | VARCHAR(36) | Yes | User ID who created the metadata record |
| PODETL_UpdatedOn | DATETIME | No | Timestamp of the last PODETL processing update |
| PODETL_UpdatedBy | VARCHAR(128) | Yes | User/process that last ran the PODETL update |
| void | INT | No | Void/soft-delete flag (non-zero indicates voided) |
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
FormsMetaDataWID
Foreign Keys
| Column | References |
|---|---|
| FormId | the parent custom form (Bi_DimCustomForms) |
| HtmlFormPK | the HTML form definition |
Was this article helpful?
Your feedback helps us improve our documentation.