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.