Service dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimService_s3 | ServiceID | VARCHAR(36) | PK | |
Bi_DimService_s3 | ServiceName | NVARCHAR(512) | ||
Bi_DimService_s3 | ServiceLength | INT | ||
Bi_DimService_s3 | CategoryID | VARCHAR(36) | ||
Bi_DimService_s3 | CategoryName | NVARCHAR(1024) | ||
Bi_DimService_s3 | CategoryCode | NVARCHAR(128) | ||
Bi_DimService_s3 | ParentCategoryID | VARCHAR(36) | ||
Bi_DimService_s3 | ParentCategoryName | NVARCHAR(1024) | ||
Bi_DimService_s3 | ParentCategoryCode | NVARCHAR(128) | ||
Bi_DimService_s3 | ServiceDesc | NVARCHAR(4096) | ||
Bi_DimService_s3 | OrganizationID | VARCHAR(36) | ||
Bi_DimService_s3 | ServiceInternalCost | DECIMAL(19,4) | ||
Bi_DimService_s3 | ComissionEligible | BOOLEAN | ||
Bi_DimService_s3 | RecoveryTime | INT | ||
Bi_DimService_s3 | CommissionFactor | FLOAT | ||
Bi_DimService_s3 | ShowInCatalog | INT | ||
Bi_DimService_s3 | CatalogRecommended | INT | ||
Bi_DimService_s3 | CatalogNew | INT | ||
Bi_DimService_s3 | ServiceDisplayName | NVARCHAR(512) | ||
Bi_DimService_s3 | ServiceCatalogPrice | NVARCHAR(128) | ||
Bi_DimService_s3 | HasVariant | INT | ||
Bi_DimService_s3 | IsVariant | INT | ||
Bi_DimService_s3 | Code | NVARCHAR(128) | ||
Bi_DimService_s3 | ShowPrice | BOOLEAN | ||
Bi_DimService_s3 | BusinessUnitId | VARCHAR(36) | ||
Bi_DimService_s3 | Frequency | FLOAT | ||
Bi_DimService_s3 | CommissionType | INT | ||
Bi_DimService_s3 | FlatCommissionValue | FLOAT | ||
Bi_DimService_s3 | ServiceNotes | NVARCHAR(8192) | ||
Bi_DimService_s3 | IsAddOn | BOOLEAN | ||
Bi_DimService_s3 | BusinessUnitName | NVARCHAR(800) | ||
Bi_DimService_s3 | BusinessUnitDescription | NVARCHAR(8000) | ||
Bi_DimService_s3 | void | BOOLEAN | ||
Bi_DimService_s3 | TAGS | VARCHAR(MAX) | ||
Bi_DimService_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimService_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimService_s3 | PodName | VARCHAR(20) | ||
Bi_DimService_s3 | groupid | BIGINT |