Service Segment Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing the individual segments that compose a service, including segment ordering, duration, type, and commission information.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| serviceid | VARCHAR(36) | Yes | Unique identifier of the parent service |
| servicesegmentwid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| servicesegmentid | VARCHAR(36) | Yes | Source system unique identifier for the service segment |
| servicesegmentname | VARCHAR(512) | Yes | Display name of the segment |
| servicesegmenttype | INTEGER | Yes | Enumerator indicating the type of segment |
| servicesegmentlength | INTEGER | Yes | Duration/length of the segment in minutes |
| segmentorder | INTEGER | Yes | Order/sequence of the segment within the service |
| void | SMALLINT | Yes | Soft-delete flag (non-zero indicates voided) |
| commission | DOUBLE PRECISION | Yes | Commission value associated with the segment |
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
servicesegmentwid
Foreign Keys
| Column | References |
|---|---|
| serviceid | the service dimension (Bi_DimService or equivalent) |
Enumerator Values
| Column | Values |
|---|---|
| servicesegmenttype | Processing Finish Break |
Was this article helpful?
Your feedback helps us improve our documentation.