Employee role dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimEmployeeRole_s3 | DimEmployeeRoleId | DECIMAL(19,0) | PK |
Bi_DimEmployeeRole_s3 | EmployeeID | VARCHAR(36) | |
Bi_DimEmployeeRole_s3 | EmployeeTypeName | NVARCHAR(128) | |
Bi_DimEmployeeRole_s3 | CenterId | VARCHAR(36) | |
Bi_DimEmployeeRole_s3 | StartDate | TIMESTAMP | |
Bi_DimEmployeeRole_s3 | EndDate | TIMESTAMP | |
Bi_DimEmployeeRole_s3 | IsCurrentRecord | BOOLEAN | |
Bi_DimEmployeeRole_s3 | etlCreatedDate | TIMESTAMP | |
Bi_DimEmployeeRole_s3 | Void | BOOLEAN | |
Bi_DimEmployeeRole_s3 | PodName | VARCHAR(20) | |
Bi_DimEmployeeRole_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimEmployeeRole_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimEmployeeRole_s3 | OrganizationId | VARCHAR(36) | |
Bi_DimEmployeeRole_s3 | groupid | BIGINT |