Training Class Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Dimension table storing training class definitions including category hierarchy, catalog settings, commission configuration, and business unit assignment.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| classwid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| classid | VARCHAR(36) | Yes | Source system unique identifier for the class |
| classname | VARCHAR(1024) | Yes | Display name of the training class |
| classtype | INTEGER | Yes | Type/category enumerator for the class |
| classlength | INTEGER | Yes | Default length/duration of the class |
| categoryid | VARCHAR(36) | Yes | Unique identifier of the class category |
| categoryname | VARCHAR(1024) | Yes | Name of the class category |
| categorycode | VARCHAR(128) | Yes | Short code of the class category |
| parentcategoryid | VARCHAR(36) | Yes | Unique identifier of the parent category |
| parentcategoryname | VARCHAR(1024) | Yes | Name of the parent category |
| parentcategorycode | VARCHAR(128) | Yes | Short code of the parent category |
| classdesc | VARCHAR(4096) | Yes | Full description of the class |
| classinternalcost | NUMERIC(19,4) | Yes | Internal cost of the class |
| comissioneligible | BOOLEAN | Yes | Indicates if the class is eligible for commission |
| recoverytime | INTEGER | Yes | Recovery time in minutes after class ends |
| commissionfactor | DOUBLE PRECISION | Yes | Multiplier used for commission calculation |
| showincatalog | INTEGER | Yes | Flag indicating if class is displayed in the catalog |
| catalogrecommended | INTEGER | Yes | Flag indicating if class is recommended in the catalog |
| catalognew | INTEGER | Yes | Flag indicating if class is marked as new in the catalog |
| classdisplayname | VARCHAR(512) | Yes | Alternate display name for the class |
| classcatalogprice | VARCHAR(128) | Yes | Display price for the catalog listing |
| code | VARCHAR(128) | Yes | Short code identifying the class |
| showprice | BOOLEAN | Yes | Flag indicating if the price is shown |
| businessunitid | VARCHAR(36) | Yes | Unique identifier of the business unit |
| commissiontype | INTEGER | Yes | Type of commission applied |
| flatcommissionvalue | DOUBLE PRECISION | Yes | Flat commission amount when type is flat |
| registrationnotes | VARCHAR(65535) | Yes | Notes displayed during registration |
| businessunitname | VARCHAR(800) | Yes | Name of the business unit |
| businessunitdescription | VARCHAR(65535) | Yes | Description of the business unit |
| void | BOOLEAN | Yes | Soft-delete flag |
| tags | VARCHAR(65535) | Yes | Comma-separated tags associated with the class |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
classwid
Foreign Keys
| Column | References |
|---|---|
| categoryid | the class category |
| parentcategoryid | the parent category in the category hierarchy |
| businessunitid | the business unit |
Enumerator Values
| Column | Values |
|---|---|
| classtype | 0 = Regular 1 = Workshop 2 = Training |
| commissiontype | 1 = Flat 2 = Percentage 3 = Tiered |
| showincatalog | 0 = Hidden 1 = Visible in Catalog |
| catalogrecommended | 0 = Not Recommended 1 = Recommended |
| catalognew | 0 = Not New 1 = Marked as New |
Was this article helpful?
Your feedback helps us improve our documentation.