Custom forms dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimCustomForms_s3 | FormPk | DECIMAL(19 | PK |
Bi_DimCustomForms_s3 | FormId | VARCHAR(36) | |
Bi_DimCustomForms_s3 | FormName | NVARCHAR(1024) | |
Bi_DimCustomForms_s3 | FormDesc | NVARCHAR(4096) | |
Bi_DimCustomForms_s3 | FormType | INT | |
Bi_DimCustomForms_s3 | OrganizationID | VARCHAR(36) | |
Bi_DimCustomForms_s3 | void | BOOLEAN | |
Bi_DimCustomForms_s3 | FormCode | NVARCHAR(128) | |
Bi_DimCustomForms_s3 | Active | BOOLEAN | |
Bi_DimCustomForms_s3 | ReviewNeeded | BOOLEAN | |
Bi_DimCustomForms_s3 | ViewOnly | BOOLEAN | |
Bi_DimCustomForms_s3 | FormExpiryType | INT | |
Bi_DimCustomForms_s3 | ExpiryTime | NVARCHAR(65535) | |
Bi_DimCustomForms_s3 | FormVersion | INT | |
Bi_DimCustomForms_s3 | FormActionType | INT | |
Bi_DimCustomForms_s3 | CopyPreviousData | BOOLEAN | |
Bi_DimCustomForms_s3 | PrefillOldVersionData | BOOLEAN | |
Bi_DimCustomForms_s3 | ExcludeChildFormsForReview | BOOLEAN | |
Bi_DimCustomForms_s3 | CreatedOn | TIMESTAMP | |
Bi_DimCustomForms_s3 | CreatedBy | VARCHAR(36) | |
Bi_DimCustomForms_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimCustomForms_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimCustomForms_s3 | PodName | VARCHAR(20) | |
Bi_DimCustomForms_s3 | groupid | BIGINT |