Resource dimension table
Bi_DimResource_s3 | ResourceId | VARCHAR(36) | PK | |
|---|---|---|---|---|
Bi_DimResource_s3 | ResourceName | NVARCHAR(128) | ||
Bi_DimResource_s3 | ResourceTypeName | NVARCHAR(128) | ||
Bi_DimResource_s3 | CenterId | VARCHAR(36) | ||
Bi_DimResource_s3 | ResourceTypeId | VARCHAR(36) | ||
Bi_DimResource_s3 | Capacity | INT | ||
Bi_DimResource_s3 | ShowInReceipt | BOOLEAN | ||
Bi_DimResource_s3 | IndicatorColor | NVARCHAR(128) | ||
Bi_DimResource_s3 | ResourceCode | NVARCHAR(128) | ||
Bi_DimResource_s3 | CanExceedRoomCapacity | BOOLEAN | ||
Bi_DimResource_s3 | void | BOOLEAN | ||
Bi_DimResource_s3 | RoomCategoryId | VARCHAR(36) | ||
Bi_DimResource_s3 | RoomCategoryCode | NVARCHAR(800) | ||
Bi_DimResource_s3 | RoomCategoryName | NVARCHAR(800) | ||
Bi_DimResource_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimResource_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimResource_s3 | PodName | VARCHAR(20) | ||
Bi_DimResource_s3 | organizationid | VARCHAR(36) | ||
Bi_DimResource_s3 | groupid | BIGINT |