Forms metadata dimension table
Bi_DimFormsMetaData
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
formsmetadatawid | unique identifier for the row - Primary key | BIGINT | Y | |
formsmetadataid | unique identifier for the row | BIGINT | ||
FormId | Unique identifier for the form. This is the same ID visible in URL of forms page | VARCHAR(36) | ||
HtmlFormPK | Internal to Zenoti | BIGINT | ||
fieldname | name of the input field in the form | VARCHAR(65535) | ||
OrganizationId | unique identifier for the organization | VARCHAR(36) | bi_dimcenter organizationid | |
CreatedDate | Date on which form is created | DATETIME | ||
CreatedBy | userid of the employee who created the form | varchar(36) | bi_dimuser userid | |
EtlLastUpdatedOn | date and time on which the row is last updated. Internal to Zenoti | datetime | ||
EtlLastUpdatedBy | Sys user who updated the row. Internal to Zenoti | VARCHAR(128) | ||
PODETL_UpdatedOn | date and time on which the row is last updated. Internal to Zenoti | datetime | ||
PODETL_UpdatedBy | Sys user who updated the row. Internal to Zenoti | VARCHAR(128) | ||
void | Indicates if the row is void; | INT | ||
PodName | Indicates point of delivery for customer. Internal to Zenoti | VARCHAR(20) | ||
groupid | Indicates the group number in which the row is processed. Internal to Zenoti | BIGINT |