Employee break category dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimEmployeeBreakCategory_s3 | EmployeeBreakCategoryPK | DECIMAL(19,0) | PK |
Bi_DimEmployeeBreakCategory_s3 | EmployeeBreakCategoryName | NVARCHAR(256) | |
Bi_DimEmployeeBreakCategory_s3 | EmployeeBreakCategoryCode | NVARCHAR(128) | |
Bi_DimEmployeeBreakCategory_s3 | EmployeeBreakDuration | INT | |
Bi_DimEmployeeBreakCategory_s3 | OrganizationId | VARCHAR(36) | |
Bi_DimEmployeeBreakCategory_s3 | OrganizationName | NVARCHAR(512) | |
Bi_DimEmployeeBreakCategory_s3 | AccountName | NVARCHAR(256) | |
Bi_DimEmployeeBreakCategory_s3 | Active | BOOLEAN | |
Bi_DimEmployeeBreakCategory_s3 | void | BOOLEAN | |
Bi_DimEmployeeBreakCategory_s3 | CountInUtilization | BOOLEAN | |
Bi_DimEmployeeBreakCategory_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimEmployeeBreakCategory_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimEmployeeBreakCategory_s3 | PodName | VARCHAR(20) | |
Bi_DimEmployeeBreakCategory_s3 | bookable | boolean | |
Bi_DimEmployeeBreakCategory_s3 | groupid | BIGINT |