ZenotiHelp

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.