Work tasks dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimWorkTasks_s3 | WorkTaskPK | DECIMAL(19,0) | PK | |
Bi_DimWorkTasks_s3 | WorkTaskId | VARCHAR(36) | ||
Bi_DimWorkTasks_s3 | WorkTaskCode | NVARCHAR(512) | ||
Bi_DimWorkTasks_s3 | WorkTaskName | NVARCHAR(1024) | ||
Bi_DimWorkTasks_s3 | Description | NVARCHAR(4096) | ||
Bi_DimWorkTasks_s3 | OrganizationId | VARCHAR(36) | ||
Bi_DimWorkTasks_s3 | CreatedDate | TIMESTAMP | ||
Bi_DimWorkTasks_s3 | LastUpdated | TIMESTAMP | ||
Bi_DimWorkTasks_s3 | CreatedBy | VARCHAR(36) | ||
Bi_DimWorkTasks_s3 | LastUpdatedBy | VARCHAR(36) | ||
Bi_DimWorkTasks_s3 | Active | BOOLEAN | ||
Bi_DimWorkTasks_s3 | Void | BOOLEAN | ||
Bi_DimWorkTasks_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimWorkTasks_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimWorkTasks_s3 | PodName | VARCHAR(20) | ||
Bi_DimWorkTasks_s3 | groupid | BIGINT |