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 | This flag indicates whether the service has a variant. Hardcoded values: - True indicates that the service does have a variant. - False indicates that the service does not have a variant. | INT | ||
Bi_DimService_s3 | IsVariant | This flag indicates whether the service is a variant. Hardcoded values: - True: indicates that the service is a variant. - False: indicates that the service is not a variant. | 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 |