ZenotiHelp

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.