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