ZenotiHelp

Service Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Dimension table storing service catalog information including service details, categorization, pricing, commission settings, and business unit associations. Populated from the service master data.

Columns

Column Name Data Type Nullable Description
servicewid BIGINT IDENTITY No Surrogate warehouse key for the service dimension, auto-generated
serviceid VARCHAR(36) Yes Natural unique identifier (GUID) of the service from the source system
servicelength INTEGER Yes Duration of the service in minutes
categoryid VARCHAR(36) Yes Identifier of the service category
parentcategoryid VARCHAR(36) Yes Identifier of the parent category (for hierarchical categorization)
servicedesc VARCHAR(4096) Yes Detailed description of the service
serviceinternalcost NUMERIC(19,4) Yes Internal cost of delivering the service
comissioneligible BOOLEAN Yes Whether the service is eligible for commission
recoverytime INTEGER Yes Recovery/cleanup time in minutes after the service
commissionfactor DOUBLE PRECISION Yes Commission factor/multiplier for the service
showincatalog INTEGER Yes Flag indicating whether the service is visible in the catalog (1 = visible)
catalogrecommended INTEGER Yes Flag indicating whether the service is marked as recommended in the catalog
catalognew INTEGER Yes Flag indicating whether the service is marked as new in the catalog
hasvariant INTEGER Yes Flag indicating whether the service has variant options
isvariant INTEGER Yes Flag indicating whether this service is itself a variant of another service
showprice BOOLEAN Yes Whether the price should be displayed in the catalog
businessunitid VARCHAR(36) Yes Identifier of the business unit the service belongs to
frequency DOUBLE PRECISION Yes Recommended frequency for the service
commissiontype INTEGER Yes Type of commission calculation (e.g., percentage, flat)
flatcommissionvalue DOUBLE PRECISION Yes Flat commission value when commissiontype is flat
isaddon BOOLEAN Yes Whether this service is an add-on to other services
void BOOLEAN Yes Soft-delete flag; TRUE indicates the record is voided/inactive
tags VARCHAR(65535) Yes Tags associated with the service for categorization/filtering
servicedisplayname VARCHAR(512) Yes Display name of the service
businessunitname VARCHAR(800) Yes Name of the associated business unit
businessunitdescription VARCHAR(65535) Yes Description of the associated business unit
servicenotes VARCHAR(65535) Yes Additional notes about the service
categoryname VARCHAR(1024) Yes Name of the service category
resourcecode VARCHAR(128) Yes Code identifying the resource type required for the service
parentcategoryname VARCHAR(1024) Yes Name of the parent category
categorycode VARCHAR(128) Yes Short code for the service category
parentcategorycode VARCHAR(128) Yes Short code for the parent category
servicecatalogprice VARCHAR(128) Yes Catalog display price of the service (stored as string for formatting)
code VARCHAR(128) Yes Short code identifier for the service
servicename VARCHAR(1024) Yes Full name of the service

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

servicewid

Foreign Keys

Column References
organizationid Bi_DimCenter
categoryid the service category entity
parentcategoryid the parent service category entity
businessunitid the business unit entity

Enumerator Values

Column Values
showincatalog (1 = show, 0 = hide)
catalogrecommended (1 = recommended)
catalognew (1 = new)
hasvariant (1 = has variants)
isvariant (1 = is a variant)
commissiontype 1 = Flat
2 = Percentage
3 = Tiered
Was this article helpful?
Your feedback helps us improve our documentation.