ZenotiHelp

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.