Training Center Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table linking training classes to centers with center-specific pricing and tax configuration.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| trainingcenterwid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| trainingcenterid | VARCHAR(36) | Yes | Source system unique identifier for the training-center association |
| classid | VARCHAR(36) | Yes | Unique identifier of the training class |
| centerid | VARCHAR(36) | Yes | Unique identifier of the center |
| price | DOUBLE PRECISION | Yes | Center-specific price for the training class |
| includestax | BOOLEAN | Yes | Indicates if the price includes tax |
| centertaxid | VARCHAR(36) | Yes | Identifier of the tax configuration applied at this center |
| void | BOOLEAN | Yes | Soft-delete flag |
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
trainingcenterwid
Foreign Keys
| Column | References |
|---|---|
| classid | the training class (Bi_DimTrainingClass) |
| centerid | the center dimension |
| centertaxid | the tax configuration |
Was this article helpful?
Your feedback helps us improve our documentation.