Training class dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimTrainingClass_s3 | Classid | VARCHAR(36) | PK | |
Bi_DimTrainingClass_s3 | ClassName | NVARCHAR(512) | ||
Bi_DimTrainingClass_s3 | ClassType | INT | ||
Bi_DimTrainingClass_s3 | ClassLength | INT | ||
Bi_DimTrainingClass_s3 | CategoryID | VARCHAR(36) | ||
Bi_DimTrainingClass_s3 | CategoryName | NVARCHAR(1024) | ||
Bi_DimTrainingClass_s3 | CategoryCode | NVARCHAR(200) | ||
Bi_DimTrainingClass_s3 | ParentCategoryID | VARCHAR(36) | ||
Bi_DimTrainingClass_s3 | ParentCategoryName | NVARCHAR(1024) | ||
Bi_DimTrainingClass_s3 | ParentCategoryCode | NVARCHAR(200) | ||
Bi_DimTrainingClass_s3 | ClassDesc | NVARCHAR(65535) | ||
Bi_DimTrainingClass_s3 | OrganizationID | VARCHAR(36) | ||
Bi_DimTrainingClass_s3 | ClassInternalCost | DECIMAL(19,4) | ||
Bi_DimTrainingClass_s3 | ComissionEligible | BOOLEAN | ||
Bi_DimTrainingClass_s3 | RecoveryTime | INT | ||
Bi_DimTrainingClass_s3 | CommissionFactor | FLOAT | ||
Bi_DimTrainingClass_s3 | ShowInCatalog | INT | ||
Bi_DimTrainingClass_s3 | CatalogRecommended | INT | ||
Bi_DimTrainingClass_s3 | CatalogNew | INT | ||
Bi_DimTrainingClass_s3 | ClassDisplayName | NVARCHAR(512) | ||
Bi_DimTrainingClass_s3 | ClassCatalogPrice | NVARCHAR(128) | ||
Bi_DimTrainingClass_s3 | Code | NVARCHAR(128) | ||
Bi_DimTrainingClass_s3 | ShowPrice | BOOLEAN | ||
Bi_DimTrainingClass_s3 | BusinessUnitId | VARCHAR(36) | ||
Bi_DimTrainingClass_s3 | CommissionType | INT | ||
Bi_DimTrainingClass_s3 | FlatCommissionValue | FLOAT | ||
Bi_DimTrainingClass_s3 | RegistrationNotes | NVARCHAR(4096) | ||
Bi_DimTrainingClass_s3 | BusinessUnitName | NVARCHAR(800) | ||
Bi_DimTrainingClass_s3 | BusinessUnitDescription | NVARCHAR(8000) | ||
Bi_DimTrainingClass_s3 | void | BOOLEAN | ||
Bi_DimTrainingClass_s3 | TAGS | VARCHAR(MAX) | ||
Bi_DimTrainingClass_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimTrainingClass_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimTrainingClass_s3 | PodName | VARCHAR(20) | ||
Bi_DimTrainingClass_s3 | groupid | BIGINT |